The RevOps KPI Dashboard: What to Track, How to Build It, and What to Ignore

Every revenue leader has dashboards. Most have too many. The average CRM contains 30-50 custom reports, of which 5-10 actually get looked at regularly. The rest are artifacts of a meeting that happened six months ago.

A good RevOps dashboard doesn't show everything. It shows the right things — the metrics that surface problems early enough to fix them and opportunities fast enough to capture them.

The Dashboard Architecture

You don't need one dashboard. You need three, each serving a different audience and cadence:

Dashboard 1: Executive Revenue Summary (Weekly)

Audience: CEO, CRO, CFO, board Purpose: "Are we on track this quarter?" Refresh: Weekly

Metric	What It Shows	Why It Matters
ARR (current)	Total recurring revenue	The scoreboard
Net new ARR (MTD/QTD)	New + expansion - churn - contraction	Growth trajectory
Pipeline coverage	Total qualified pipeline ÷ remaining quota	Whether you have enough pipeline to hit the number
Weighted pipeline	Pipeline × stage probability	More realistic than raw pipeline
Win rate (trailing 90 days)	Deals won ÷ deals closed	Trending up or down?
Average deal size	Average ACV of closed-won deals	Trending up or down?
Sales cycle length	Average days from opportunity creation to close	Getting faster or slower?
NRR (trailing 12 months)	Net revenue retention	Is existing revenue growing?

Design principle: This dashboard should be readable in 60 seconds. No scrolling. No clicking. The CEO should see green/yellow/red at a glance.

Dashboard 2: Pipeline Operations (Daily)

Audience: Sales managers, RevOps Purpose: "Where are deals stuck, leaking, or moving?" Refresh: Daily

Metric	What It Shows	Action Triggered
Pipeline created this week	New opportunities added	Is generation keeping pace?
Pipeline by stage (waterfall)	Distribution across stages	Bottlenecks visible
Deals without activity (7+ days)	Stale deals	Manager follow-up
Deals with past-due close dates	Pipeline hygiene issues	Force rep updates
Stage conversion rates (30-day trailing)	Where deals die	Process intervention
Average time in stage	Velocity by stage	Identify slow stages
Ramp-adjusted pipeline per rep	Individual rep health	Coaching conversations
Forecast category breakdown	Commit vs. best-case vs. pipeline	Forecast accuracy check

Design principle: This dashboard drives daily action. Every metric should answer "what do I need to do today?"

Dashboard 3: Full-Funnel Revenue Analytics (Monthly)

Audience: RevOps, marketing leadership, CS leadership Purpose: "Is the revenue engine healthy end-to-end?" Refresh: Monthly

Metric	What It Shows	Insight
Lead-to-MQL conversion rate	Marketing efficiency	Are we generating quality?
MQL-to-SQL conversion rate	Sales-marketing alignment	Is sales accepting marketing leads?
SQL-to-opportunity rate	Discovery effectiveness	Are qualified leads becoming real deals?
CAC by channel	Acquisition efficiency	Where should we spend more/less?
Payback period	Months to recover CAC	Sustainable economics?
LTV:CAC ratio	Unit economics health	Target >3:1
Gross revenue retention	Base revenue retained	Churn trend
Expansion revenue (monthly)	Growth from existing customers	Expansion motion health
CSM portfolio health distribution	% green/yellow/red	Retention risk
Support ticket volume and resolution time	Customer experience	Trending better or worse?

Design principle: This dashboard tells the strategic story. It's the basis for monthly leadership reviews and quarterly planning.

How to Build It

Step 1: Start With Your Data Model

Before building any dashboard, audit your data:

Are deal stages consistently used? If "Qualification" means different things to different reps, your stage conversion data is meaningless.
Are close dates current? If 30% of your pipeline has past-due close dates, your forecast dashboard is fiction.
Is attribution tracked? If you can't connect leads to their source, your CAC-by-channel numbers are garbage.
Are customer records linked to deals? If renewal and expansion deals aren't connected to the original account, NRR is incalculable.

Critical rule: Don't build a dashboard on bad data. Fix the data first, or flag the data quality issues on the dashboard itself so nobody makes decisions on unreliable numbers.

Step 2: Choose Your Tool

Tool	Best For	Limitation
CRM-native (HubSpot/Salesforce reports)	Standard metrics, quick setup	Limited cross-object analysis
Looker / Tableau / Power BI	Complex analysis, custom visualizations	Requires data warehouse + analyst
Google Sheets / Excel	Quick models, ad-hoc analysis	Doesn't scale, manual refresh
Purpose-built (Clari, Gong Forecast)	Forecasting and pipeline intelligence	Expensive, narrow scope

For most companies under $20M ARR, CRM-native reporting handles 80% of needs. Add a BI tool when you need cross-system analysis (combining product usage data with CRM data, for example).

Step 3: Design for Decisions, Not Decoration

Every metric on your dashboard should pass the "so what?" test:

If this number goes up, what do we do?
If this number goes down, what do we do?
Who is responsible for acting on this metric?

If you can't answer all three, the metric doesn't belong on the dashboard.

Kill vanity metrics ruthlessly:

Total leads generated (without qualification rates, meaningless)
Total pipeline value (without win rates and stage distribution, misleading)
Number of activities logged (measuring effort, not outcome)
Email open rates (unreliable after Apple Mail Privacy Protection)

Step 4: Add Context, Not Just Numbers

A number without context is noise. Every metric needs:

Trend line: Is it going up, down, or flat? Show 90-day or 6-month trends.
Target/benchmark: What should this number be? Show the goal alongside the actual.
Comparison: MoM, QoQ, or YoY. A 25% win rate means nothing without knowing it was 30% last quarter.
Segmentation: Overall win rate is less useful than win rate by segment (enterprise vs. mid-market), source (inbound vs. outbound), or product line.

Step 5: Set Alert Thresholds

The best dashboard is the one you don't have to check every day because it tells you when something needs attention.

Set automated alerts for:

Condition	Alert To	Urgency
Pipeline coverage drops below 3x	CRO + RevOps	High — generation problem
Win rate drops >5% MoM	Sales management	Medium — investigate cause
Deal stale >14 days in any stage	Deal owner + manager	Medium — deal may be dead
NRR drops below 100%	CS leadership	High — net revenue declining
New pipeline created <80% of weekly target	Marketing + SDR management	Medium — generation lag

Alerts prevent dashboard fatigue. You check the dashboard for context. The alerts tell you when to check.

Common Dashboard Mistakes

Too many dashboards. If you have 15 dashboards and nobody knows which one to look at, you effectively have zero. Consolidate to 3 and archive the rest.

Measuring inputs instead of outcomes. "Calls made" is an input. "Meetings booked per rep" is an output. "Pipeline created per meeting" is an outcome. Measure as far downstream as you reliably can.

No owner. Every dashboard needs a human who maintains it, validates data accuracy, and iterates on design. Dashboards without owners decay within months.

Static design. Your dashboard should evolve as your business evolves. A $5M ARR company tracks different metrics than a $25M company. Review dashboard design quarterly and retire metrics that no longer drive decisions.

Ignoring data quality on the dashboard. If 20% of your pipeline has no close date, don't just show the pipeline chart — show the data quality score alongside it. Decision-makers need to know how much to trust the numbers.

The Monthly Revenue Review

The dashboard is an artifact. The operating cadence is what creates accountability.

Monthly revenue review agenda (60 minutes):

Scorecard review (10 min): Walk through the executive dashboard. Where are we vs. plan? What changed from last month?
Pipeline deep-dive (15 min): Stage conversion trends, stuck deals, coverage gaps.
Win/loss themes (10 min): Top 3 reasons we won and lost this month.
Full-funnel health (10 min): Lead quality, CAC trends, retention signals.
Actions and owners (15 min): What are we changing? Who owns it? When will we see results?

The dashboard makes this meeting efficient. Without it, the meeting becomes a data-hunting exercise instead of a decision-making session.

Build the right dashboards. Set the right alerts. Run the right reviews. That's how RevOps turns data into revenue.