RevOps Dashboard Template: What to Track and How

The best RevOps dashboards aren't the ones with the most metrics. They're the ones where every metric triggers a specific action. Start with 7-10 KPIs on the executive view, build drill-down views for managers, and create personal scorecards for reps. Refresh cadence should match decision cadence.

The Three-Layer Dashboard Architecture

Every RevOps team needs three dashboard layers. Not because more dashboards are better, but because different audiences need different levels of detail at different cadences.

Layer 1: Executive Dashboard

Audience: CEO, CRO, CFO, Board

Refresh: Weekly (auto-refresh daily)

Goal: Answer "are we on track?" in 30 seconds

The executive dashboard should fit on a single screen. No scrolling. 7 metrics maximum. Every metric needs: current value, trend direction, target, and status indicator (on track / at risk / off track).

The 7 executive metrics:

1. Revenue vs Plan: Current quarter closed revenue against the quarterly target. Show as a progress bar or gauge. This is the number the CEO looks at first.
2. Pipeline Coverage Ratio: Qualified pipeline divided by remaining quota. Target: 3x-4x. Below 3x is a red flag that needs immediate attention. Display with a 4-quarter trend line.
3. Forecast Accuracy: Last quarter's commit vs actual. Show the trailing 4-quarter trend. If accuracy is consistently above 90%, your forecasting process works. Below 80%, the pipeline data or forecasting methodology needs repair.
4. Win Rate: Closed-won vs total closed (won + lost). Exclude stale/disqualified. Segment by new logo vs expansion. A declining win rate with growing pipeline usually means you're qualifying too loosely.
5. Average Sales Cycle: Days from opportunity creation to close. Track the trend. A lengthening cycle signals competitive pressure, a buying committee problem, or scope creep in deals.
6. Net Revenue Retention (NRR): Expansion revenue minus churn from existing customers. This is the metric that indicates whether you have a sustainable business or a leaky bucket.
7. CAC Payback Period: Months to recoup customer acquisition cost. Under 18 months is healthy for most B2B SaaS. Over 24 months and the unit economics are strained.

Layer 2: Management Dashboard

Audience: VP of Sales, VP of Marketing, CS Director

Refresh: Daily

Goal: Answer "where do I need to intervene?" with enough detail to act

Management dashboards need interactive filters. Managers need to slice by team, segment, time period, and source. The same pipeline chart filtered by "Enterprise West" vs "SMB East" tells a completely different story.

Core management metrics:

• Pipeline by Stage: Funnel visualization with conversion rates between stages. The stage with the biggest drop-off is where coaching or process intervention has the most leverage. This is the centerpiece of every weekly pipeline review.
• Pipeline Created vs Pipeline Needed: Tracks whether lead generation is keeping pace with the sales plan. Show weekly and monthly trends. If created pipeline falls below needed pipeline for 3 consecutive weeks, the quarter is at risk.
• Rep Activity Dashboard: Calls, emails, meetings booked, proposals sent. Not as a surveillance tool, but as a leading indicator. When activity drops before pipeline drops, you have time to intervene.
• Lead-to-Opportunity Conversion by Source: Which channels produce pipeline vs which produce vanity metrics. If paid search generates 500 leads but only 10 opportunities, and events generate 50 leads and 15 opportunities, the budget allocation is wrong.
• Deal Velocity by Segment: How fast deals move through stages. Enterprise deals that stall in Stage 2 for 40+ days have a different diagnosis than SMB deals with the same pattern.
• Quota Attainment Distribution: Not the average, the distribution. A histogram showing how many reps are at 0-50%, 50-80%, 80-100%, 100%+ of quota. This reveals whether you have a team problem or an individual problem.

Layer 3: Individual Contributor Scorecards

Audience: AEs, SDRs, CSMs

Refresh: Real-time or daily

Goal: Answer "what should I focus on today?"

IC dashboards should show only metrics the individual can control. Don't show reps the company NRR. Show them their pipeline, their activity targets, their deal health.

Rep scorecard metrics:

• Personal pipeline value and coverage ratio
• Activity vs target (calls, emails, meetings this week)
• Deals with overdue next steps (the "action required" list)
• Win rate and average deal size (trailing 90 days)
• Quota attainment (month-to-date and quarter-to-date)

Building the Pipeline Review Dashboard

The weekly pipeline review is where dashboards meet decisions. Here's the specific layout that works:

Section 1: The Scoreboard (1 slide)

Four numbers on one screen: revenue vs plan, pipeline coverage, forecast (commit + best case + pipeline), and deals closing this month. No discussion. Just the facts to orient the room.

Section 2: What Changed This Week (1-2 slides)

Deals that moved stages (forward or backward). New pipeline created. Deals pushed out of the current quarter. Deals added to commit. Focus on movement, not status. The pipeline review should surface changes, not repeat last week's conversation.

Section 3: Deal Spotlight (2-3 slides)

Deep dive on 3-5 deals that need attention. Selection criteria: at-risk deals above a dollar threshold, deals stalled for 2+ weeks, deals with upcoming close dates that haven't moved stages recently. For each deal: current stage, age, amount, risk factors, and required action with an owner.

Section 4: Actions (1 slide)

Every discussion point gets an owner and a deadline. Written down in the meeting. If an action item doesn't get assigned during the review, it won't get done.

Tool Selection for Dashboards

Match the tool to the need:

• Native CRM reporting (Salesforce Dashboards, HubSpot Reports): Handles 80% of operational dashboards. No additional cost. Limited by the data in your CRM.
• BI tools (Tableau, Looker, Power BI): Required when you need to combine CRM data with external sources (marketing platform data, product usage, billing). Budget: $70-$100/user/month.
• Revenue intelligence platforms (Clari, Gong Forecast): Purpose-built for pipeline analytics and forecasting. Better signal extraction from deal data than generic BI tools. Budget varies by vendor.
• Spreadsheets: Still the right tool for one-off analysis, board deck prep, and scenario modeling. Don't build recurring dashboards in spreadsheets. They break when you leave the company and nobody can maintain them.

Data Quality Requirements

A dashboard built on bad data is worse than no dashboard, because it gets trusted. Before building anything, ensure:

• Required fields are enforced: Amount, close date, stage, and next step at minimum. Every empty field is a reporting gap. See our data hygiene automation guide for enforcement strategies.
• Stage definitions are documented: If "Discovery" means different things to different reps, your stage conversion data is meaningless. Write definitions and criteria for advancing to each stage.
• Stale pipeline is addressed: Opportunities unchanged for 30+ days should be flagged automatically. A deal with a close date three months in the past is polluting your coverage ratio.
• Duplicates are controlled: Duplicate accounts inflate pipeline. Duplicate contacts skew activity metrics. Run dedup monthly at minimum.

Common Dashboard Mistakes

• Building 50 dashboards nobody uses: Audit usage quarterly. If a dashboard hasn't been viewed in 30 days, archive it. Maintenance burden on unused dashboards is pure waste.
• Metrics without context: "Win rate: 22%" is noise. "Win rate: 22%, down from 28% last quarter, driven by a 15-point drop in Enterprise segment" is actionable intelligence. Every metric needs trend, comparison, and segment context.
• All lagging indicators: Revenue, churn, and win rate are outcomes you can't change retroactively. Pair every lagging indicator with its leading counterpart. Revenue (lagging) pairs with pipeline created (leading). Churn (lagging) pairs with health score trend (leading).
• Dashboard as a substitute for analysis: Dashboards surface signals. They don't explain causes. When a metric moves, someone needs to dig into the data to understand why. Budget time for analysis, not just dashboard building.
• No defined response to metric changes: Every metric on your dashboard should have a documented threshold and response. "If pipeline coverage drops below 3x, trigger increased outbound activity." Without defined responses, dashboards are wallpaper.

Scaling Your Reporting

As the company grows, reporting needs evolve:

• $5M-$20M ARR: Native CRM dashboards are sufficient. 3-5 core dashboards. One person (RevOps Manager) builds and maintains them.
• $20M-$50M ARR: Add a BI tool for cross-source analysis. 8-12 dashboards. Dedicate a half-FTE to reporting and analytics.
• $50M+ ARR: Data warehouse + BI platform + embedded analytics. 15-20+ dashboards across teams. Full analytics team within RevOps. See our team structure guide for how analytics fits into the org.

For the full list of metrics and how to measure each one, see our 25 RevOps KPIs guide. For tool selection guidance, browse the tool reviews.

Frequently Asked Questions

What should a RevOps metrics dashboard include?

At minimum: pipeline coverage ratio, pipeline velocity, win rate, sales cycle length, forecast vs actual, quota attainment distribution, and lead-to-opportunity conversion rate. Limit executive dashboards to 7-10 metrics. Add drill-down views for managers.

What tool should I use to build a RevOps dashboard?

Start with native CRM reporting (Salesforce dashboards or HubSpot reports). This handles 80% of use cases without additional cost. Add Tableau, Looker, or Power BI only when you need to combine data from multiple sources or build analysis that native reporting cannot support.

How often should RevOps dashboards be updated?

Match refresh cadence to decision cadence. Pipeline and activity dashboards: real-time or daily. Forecast dashboards: weekly. Strategic metrics (CAC, NRR, quota attainment): monthly. QBR decks: quarterly. Over-refreshing wastes compute and creates noise.

What is the difference between a RevOps dashboard and a sales dashboard?

A sales dashboard tracks rep activity and quota attainment for sales management. A RevOps dashboard spans the full funnel: marketing pipeline contribution, lead handoff efficiency, sales velocity, CS expansion revenue, and data quality metrics. RevOps dashboards focus on system health, not just sales performance.