Revenue Operations 21 min read

The RevOps Dashboard: What to Include and What to Skip

Which metrics belong on a RevOps dashboard — pipeline health, forecast vs. actual, funnel conversion, CAC by channel, NRR, expansion pipeline, quota attainment — and what to cut. Structured by daily, weekly, and monthly review cadence.

Siddharth Gangal

TL;DR

  • A high-signal RevOps dashboard contains 8 to 12 metrics maximum — not 40.
  • The seven core metrics: pipeline health, forecast vs. actual, funnel conversion, CAC by channel, NRR, expansion pipeline, and quota attainment.
  • Structure by cadence: daily anomaly alerts, weekly team review, monthly leadership review.
  • Vanity metrics — raw lead counts, email open rates, total activities logged — consume dashboard space without driving decisions.
  • Apply the action test and lag test before adding any metric: if you cannot name what changes when the number moves, it does not belong.

The Signal Problem With Most RevOps Dashboards

Revenue operations teams at growing B2B companies face a paradox: more data is available than ever, and yet confidence in the revenue forecast has not improved proportionally. According to Gartner research, the average sales forecast accuracy for B2B organizations sits at roughly 45% — meaning companies miss their own projections by more than they hit them, despite access to CRMs, BI tools, and dedicated RevOps headcount.

The culprit is not a lack of data. It is the wrong data displayed at the wrong time to the wrong audience. Most RevOps dashboards are built through accretion: a metric is added whenever someone asks a question, and nothing is ever removed. Over time, a dashboard that began as a lean operating view expands into a 30-metric report that takes two hours to review and produces no clear action.

The discipline of dashboard design is fundamentally about subtraction. Every metric you add competes for the attention of the person reading it. When everything is measured, nothing is prioritized. The goal is a dashboard where every number is actionable, every view has a named owner, and every cadence has a defined purpose.

This guide covers the seven metric categories that belong on a RevOps dashboard, the metrics that do not belong despite their popularity, and a framework for making that judgment call as your business evolves. For a broader foundation on revenue operations structure, see the complete guide to revenue operations.

The Seven Metric Categories That Belong on a RevOps Dashboard

These seven categories represent the minimum complete picture of revenue health. Removing any one of them creates a blind spot. Adding categories beyond these requires passing the prioritization tests described later in this guide.

01 — PIPELINE HEALTH

Pipeline Coverage, Velocity, and Slippage

Pipeline health is the upstream indicator for everything that follows. It answers: do we have enough qualified opportunity to hit quota, how fast is it moving, and is it decelerating?

Pipeline health is not a single metric — it is a cluster of three related signals that must be read together. Coverage without velocity is a false comfort. Velocity without coverage is unsustainable. Both without slippage tracking will leave you forecasting closed deals that quietly moved to next quarter.

Pipeline Coverage Ratio measures total qualified pipeline value against quota for the period. A standard benchmark is 3x to 4x. Below 3x at the start of a quarter signals structural risk. Below 2.5x at mid-quarter means the team almost certainly misses quota without extraordinary effort or discounting.

Coverage Ratio = Qualified Pipeline Value ÷ Quota
Example: $3.2M pipeline ÷ $1.0M quota = 3.2x coverage
Target: ≥ 3.0x at quarter open · ≥ 2.5x at mid-quarter

Pipeline Velocity synthesizes four variables — number of opportunities, average deal size, win rate, and sales cycle length — into a single dollars-per-day number. A declining velocity number before quarter-end is often the earliest available warning that the team will miss its number, appearing weeks before slippage becomes visible in the forecast.

Velocity = (Opportunities × Avg Deal Size × Win Rate) ÷ Avg Cycle Days
Example: 60 opps × $22,000 × 0.27 ÷ 55 days = $6,458 / day
Track week-over-week trend — direction matters as much as absolute value

Deal Slippage Rate measures the percentage of committed deals that do not close in the forecasted quarter. The industry average is 20–25%. Above 30% signals systematic problems: premature stage advancement, weak qualification, or CRM hygiene failures that require process correction rather than rep coaching. For a complete breakdown of pipeline health signals, see the guide to pipeline health metrics and what to track.

02 — FORECAST ACCURACY

Forecast vs. Actual Variance

Forecast accuracy is the report card for the entire RevOps function. It measures how reliably the team converts pipeline intelligence into precise revenue predictions.

Forecast variance should be tracked at two levels: the team aggregate (are we within 10% of the forecast at quarter close?) and by forecast category (how accurate are "commit" versus "best case" versus "pipeline" deals?). Teams that only track aggregate accuracy miss the signal that commit-category deals are slipping at higher rates than the number suggests.

According to Salesforce research, best-in-class revenue organizations achieve forecast accuracy within 10% of actual for 80% or more of quarters. The median B2B organization achieves within-10% accuracy roughly 45% of the time. The gap is almost entirely explained by CRM data quality and stage-definition discipline — not by the sophistication of the forecasting model.

Forecast Category Definition Expected Close Accuracy
Commit Rep has verbal or written confirmation; expects to close this period 85–95%
Best Case Rep believes deal could close; depends on buyer decision timeline 50–65%
Pipeline Qualified opportunity; close date within the period is optimistic 20–35%
Omitted Early stage or disqualified; not expected in-period < 10%

Track forecast vs. actual as a trailing 4-quarter trend. A single quarter miss is noise. Three consecutive misses in the same direction — consistently over-forecasting, for example — reveals a structural bias in how the team qualifies and stages deals.

03 — FUNNEL CONVERSION

Stage-by-Stage Conversion Rates

Funnel conversion rates reveal where revenue is being lost before it reaches the forecast. Each stage transition is a diagnostic checkpoint.

The standard B2B funnel for RevOps purposes has five transitions worth tracking: lead to qualified lead (MQL), MQL to sales-accepted lead (SAL), SAL to opportunity, opportunity to proposal, and proposal to closed-won. The specific stage names vary by organization, but the principle is consistent: measure the percentage of records advancing through each transition, and track how those rates change over time.

Aggregate win rate is a lagging indicator — it tells you that deals are or are not closing, but not where the leak is. Stage conversion rates are leading indicators: a drop in opportunity-to-proposal conversion, for example, surfaces two to three months before that decline appears in win rate data. That early warning gives RevOps the window to diagnose and correct before the quarter is at risk.

Common mistake: Tracking funnel conversion only in aggregate. A marketing-sourced funnel with 4% lead-to-opportunity conversion and a partner-sourced funnel with 18% conversion will average to 11% — a number that hides the fact that one channel is healthy and the other is burning budget. Always segment by source, segment, and rep before drawing conclusions.

Benchmark conversion rates vary significantly by ACV and sales motion. For mid-market B2B products ($20K–$80K ACV), healthy benchmarks are: MQL-to-SAL at 45–60%, SAL-to-opportunity at 55–70%, opportunity-to-proposal at 60–75%, and proposal-to-close at 25–40%. For enterprise motion (>$100K ACV), expect lower rates at each stage with longer cycle times at each transition.

04 — ACQUISITION EFFICIENCY

CAC by Acquisition Channel

Aggregate CAC tells you what you are paying to acquire a customer. CAC by channel tells you which investments are returning capital and which are destroying it.

Most RevOps teams track blended CAC — total sales and marketing spend divided by new customers acquired. That number is useful for investor reporting. It is nearly useless for operating decisions. A blended CAC of $18,000 could mean every channel is efficient at $18,000, or it could mean organic and partner channels are returning customers at $8,000 while paid search is delivering customers at $42,000 — and the blend is masking a decision that would materially change profitability.

Channel CAC = Channel Spend (period) ÷ New Customers from Channel (period)
Example: $180,000 paid search spend ÷ 12 new customers = $15,000 CAC
Pair with CAC Payback Period = Channel CAC ÷ (ACV × Gross Margin)

The actionable metric is CAC Payback Period by channel — how many months of gross margin contribution are required to recover the acquisition cost. HubSpot's benchmarks place healthy CAC payback for B2B SaaS at under 18 months for growth-stage companies and under 12 months for scale-stage companies. Channels consistently producing payback above 24 months warrant reallocation decisions, not incremental optimization.

Channel Typical CAC Range (B2B SaaS) Payback Benchmark
Inbound / Organic $4,000–$10,000 6–12 months
Content / SEO $6,000–$14,000 8–14 months
Partner / Referral $5,000–$12,000 6–12 months
Outbound SDR $12,000–$28,000 12–20 months
Paid Search / SEM $14,000–$35,000 14–24 months
Field / Events $18,000–$45,000 16–28 months
05 — RETENTION

Net Revenue Retention (NRR)

NRR is the single metric that best summarizes the health of a SaaS business. It captures churn, contraction, and expansion in one number — and it predicts whether growth compounds or decays.

Net Revenue Retention measures what percentage of last period's revenue from existing customers you retain and grow in the current period. An NRR of 100% means you are exactly replacing what you lose with expansion. Above 100%, expansion revenue from existing customers outpaces churn — the customer base grows in dollars even without winning a single new logo. Below 100%, the business is leaking faster than it grows and new customer acquisition is running to stand still.

NRR = (Starting MRR + Expansion MRR − Churned MRR − Contraction MRR) ÷ Starting MRR
Example: ($500K + $80K − $30K − $10K) ÷ $500K = 108%
Measure monthly; report 12-month rolling trend to smooth seasonality

For detailed benchmarks by ARR stage and segment, see the NDR benchmarks guide for SaaS. The short version: 110% is the threshold between average and strong for most mid-market B2B products. 125%+ is the threshold for elite, and at that level, existing customer expansion creates a compounding growth engine that dramatically reduces dependence on new-logo acquisition.

NRR should appear on the RevOps dashboard as a 12-month rolling trend, not a single-period snapshot. A single-month NRR of 95% could be a seasonality blip. A 12-month trend from 112% down to 95% is a structural erosion that requires root-cause investigation: are we losing specific cohorts? Is a product change driving contraction? Are competitors winning renewal conversations?

06 — EXPANSION

Expansion Pipeline

Expansion pipeline is the qualified opportunity value from existing customers — upsells, cross-sells, and seat expansion. It is the highest-efficiency revenue motion available to most SaaS businesses.

Expansion deals close at 60–80% win rates with near-zero incremental acquisition cost. Yet most RevOps dashboards treat expansion pipeline as an afterthought — buried in a customer success report rather than sitting alongside new-logo pipeline as a first-class revenue signal. That omission understates available growth and misallocates selling effort toward lower-efficiency new-logo motion when expansion is the better use of capacity.

Track expansion pipeline in three dimensions:

  • Expansion pipeline value — qualified dollar value of open upsell and cross-sell opportunities by close date
  • Expansion pipeline coverage — expansion pipeline vs. expansion quota (same 3x benchmark applies)
  • Expansion as a percentage of total new bookings — healthy B2B SaaS targets 30–40% of new bookings from expansion; above 50% may indicate insufficient new-logo engine; below 20% may indicate customer success under-investment

Expansion pipeline should be built from signals: product usage data showing underutilization of features in higher tiers, seat headcount growth at the account, executive sponsor changes that create re-entry points, and support ticket patterns that indicate pain points addressable with upgrades. RevOps owns the data infrastructure to surface these signals. Customer success owns the conversations. The dashboard is the coordination layer between them.

07 — TEAM PERFORMANCE

Quota Attainment Distribution

Quota attainment as a single average number hides the bimodal distribution that actually describes most sales teams: a top quartile exceeding quota and a bottom quartile well below it.

Track attainment as a distribution, not an average. The key cuts are: percentage of reps above 100%, percentage between 75% and 100%, percentage between 50% and 75%, and percentage below 50%. A healthy team at scale typically shows 55–65% of reps above quota, 20–25% between 75% and 100%, and less than 15% below 75%. Heavy concentration at the extremes — many at 120%+ and many at below 50% — usually indicates territorial or quota-setting problems rather than performance problems.

Pair attainment with ramp progress for reps under 12 months tenure. A new rep at 60% of quota in month 8 may be on a healthy ramp trajectory. A tenured rep at 60% in month 18 is a performance issue. The dashboard should distinguish these two cases clearly, because the management response differs entirely. For a full treatment of RevOps performance metrics, see the RevOps maturity model.

Attainment Band Healthy Distribution Diagnostic Signal
Above 100% 55–65% of reps Below 40% → quota or territory problem
75%–100% 20–25% of reps Above 35% → sandbagging risk
50%–75% 10–15% of reps Growing share → coaching intervention needed
Below 50% < 10% of reps Above 20% → hiring, onboarding, or ICP problem

What to Skip: Metrics That Sound Important but Are Not Actionable

Every metric that does not belong on a RevOps dashboard got there because someone found it interesting. Interesting is not the same as actionable. The test is simple: if this number changes by 20%, what specific decision changes? If the answer is unclear or requires several intermediate steps, the metric belongs in a supplementary report, not on the operating dashboard.

Raw Lead Volume

Total leads generated is a marketing output metric. It tells you the volume of inbound activity but nothing about quality, fit, or revenue potential. A month with 2,000 leads and 0.8% pipeline conversion is worse than a month with 800 leads and 4.5% pipeline conversion — yet the first month looks dramatically better on a raw volume dashboard. Replace raw lead volume with MQL-to-SAL conversion rate and lead-to-pipeline value, which measure lead quality rather than quantity.

Total Pipeline Created

Pipeline creation volume sounds like a leading indicator. It is not, unless paired with quality filters. Pipeline created from poorly qualified leads inflates the number while simultaneously degrading win rate and consuming selling capacity on opportunities that will never close. Track qualified pipeline — defined by consistent stage-entry criteria — not total pipeline created. The distinction requires investment in CRM stage discipline, but it is the difference between a meaningful metric and a number that flatters without informing.

Email Open Rates and Activity Counts

Email open rates, call volumes, and activities logged are effort metrics. They measure input, not output. A rep logging 80 calls per week who closes nothing is demonstrating effort without producing results. A rep logging 25 calls per week who closes 130% of quota is demonstrating leverage. Dashboards built around activity metrics inadvertently reward effort over outcomes and create incentives to game the CRM rather than advance deals.

MQL Attainment in Isolation

Marketing hitting its MQL target by 120% while revenue misses by 15% is a pattern familiar to nearly every RevOps leader who has managed the marketing-sales handoff. MQL attainment divorced from pipeline conversion and closed revenue is a siloed metric that measures marketing-defined success, not revenue-defined success. On a RevOps dashboard, MQL exists only in relation to SAL conversion rate and pipeline contribution — not as a standalone number.

Gross Revenue Added (Without Churn Context)

New bookings without churn context is an incomplete picture. A business adding $500K per month in new ARR while churning $450K per month is technically growing — and is structurally at risk. Net New ARR (new bookings minus churned ARR minus contraction ARR plus expansion ARR) is the correct metric for understanding whether the business is actually growing its revenue base. Track NRR alongside new bookings, never new bookings alone.

Structuring Your Dashboard by Review Cadence

The most common RevOps dashboard failure is not the wrong metrics — it is the right metrics presented to the wrong audience at the wrong frequency. A CRO reviewing pipeline slippage daily is not better informed; they are distracted from strategic decisions by operational noise. A rep reviewing NRR weekly has no lever to pull. The solution is three distinct views organized by cadence and audience.

CADENCE 01 — DAILY

Anomaly Alerts (Automated)

The daily view is not a review — it is a threshold alert system. Set automated notifications for conditions that require same-day response: pipeline coverage dropping below 2.5x, forecast slippage exceeding 15% week-over-week, a deal in "commit" category moving to "best case," or a high-ACV account showing churn risk signals. Daily dashboards reviewed manually in a team meeting are overhead. Daily dashboards that surface alerts only when thresholds are breached are leverage.

CADENCE 02 — WEEKLY

Team Operating Review

The weekly team review covers the metrics that move on a weekly cycle and inform rep and manager decisions: pipeline coverage by segment and rep, deal velocity trend, at-risk deals (deals past expected close date or showing negative engagement signals), and funnel conversion by stage. This view is designed for sales managers and RevOps operators. It should take 30 minutes, produce at least three named actions, and be owned by a single RevOps lead who prepares the report and facilitates the discussion.

CADENCE 03 — MONTHLY

Leadership Review

The monthly leadership review covers metrics that require a full cycle of data to be meaningful: forecast accuracy vs. prior quarter, NRR trend, CAC payback by channel (updated with closed-period attribution), quota attainment distribution, and expansion pipeline vs. expansion quota. This view is for CROs, CFOs, and founders. It should answer three questions: Is the engine generating the right volume of qualified pipeline? Is it converting efficiently? Is the customer base healthy and growing? Everything else is secondary.

The three-cadence structure prevents a common pathology: the weekly leadership meeting that attempts to cover daily anomalies, weekly operations, and monthly trend analysis simultaneously. The result is a meeting that produces no decisions because no one can distinguish signal from noise across three different time horizons in a single session.

The Metric Prioritization Framework: What to Add and What to Remove

As a business evolves, its RevOps dashboard should evolve with it. A metric that was critical at $2M ARR may be irrelevant at $20M ARR. A metric irrelevant at Series A may become the most important signal at Series C. The following framework provides a repeatable process for making those add/remove decisions without falling into the trap of continuous dashboard expansion.

Step 1: Apply the Action Test

For every existing and candidate metric, write down the specific action the team takes when the number changes by 20% in either direction. The action must be specific — "investigate further" does not count. "Reassign two deals from rep A to rep B and adjust Q3 territory" counts. Metrics that fail the action test move to a secondary diagnostic report. They are available for investigation but do not occupy primary dashboard real estate.

Step 2: Apply the Lag Test

Classify each metric as a leading indicator (predicts a future outcome) or a lagging indicator (records a completed outcome). Operating dashboards should be weighted at least 60% toward leading indicators. Pipeline coverage, velocity, stage conversion rates, and expansion pipeline are leading. Win rate, quota attainment, and NRR are lagging. Both have value, but in different contexts. Leading indicators drive weekly operating decisions. Lagging indicators drive monthly strategic reviews.

Step 3: Assign a Single Owner

Every metric on the dashboard must have a named owner responsible for monitoring it, diagnosing anomalies, and presenting findings in the relevant review. A metric without an owner is noise — no one will catch when it moves, and no one will take responsibility when it signals a problem. If you cannot name an owner, the metric is not ready for the dashboard.

Step 4: Conduct a Quarterly Dashboard Audit

Every quarter, run a 30-minute audit: for each metric on the dashboard, confirm that it passed the action test last quarter (i.e., it actually informed at least one named decision), confirm that it has a current owner, and confirm that the benchmark or threshold is calibrated to the current stage of the business. Metrics that fail any criterion get removed or demoted to a secondary report. This is the mechanism that prevents the dashboard from expanding through accretion.

Criterion Test Result if Failed
Action Test Can name specific action when metric moves ±20% Move to diagnostic report
Lag Test Is leading indicator, or lagging with named strategic use Move to monthly leadership report
Ownership Test Has a named individual who monitors and presents it Assign owner or remove
Relevance Test Informed at least one decision last quarter Remove or demote to reference report
Benchmark Test Threshold calibrated to current ARR stage and motion Recalibrate or replace with stage-appropriate metric

What Changes by ARR Stage

The seven core metric categories are stable across most ARR stages. What changes is the segmentation depth and benchmark calibration. At $2M ARR, pipeline coverage may be tracked at the company level. At $15M ARR, it should be segmented by rep, region, and segment. At $50M ARR, it may need further segmentation by product line and motion (new-logo vs. expansion vs. renewal). The metric does not change — the analytical depth does, and the RevOps dashboard must reflect that increased granularity without becoming unreadable.

FAIRVIEW — OPERATING INTELLIGENCE PLATFORM

Your RevOps Dashboard, Without the Configuration Overhead

Fairview connects to your CRM, billing system, and marketing data to surface the seven core RevOps metrics — pipeline health, forecast variance, funnel conversion, CAC by channel, NRR, expansion pipeline, and quota attainment — in a single operating view, organized by cadence.

No dashboard configuration required. No SQL. No BI analyst required to answer the question "are we going to hit quota this quarter?" Fairview answers that question — and surfaces what to do about it — within the first session.

Learn about Fairview

Frequently asked questions

What metrics should a RevOps dashboard include?

A high-signal RevOps dashboard should include: pipeline coverage ratio, forecast vs. actual variance, stage-by-stage funnel conversion rates, CAC by acquisition channel, net revenue retention, expansion pipeline value, and quota attainment distribution. Every metric must connect to a decision. If you cannot name what action changes when the number moves, the metric does not belong on the dashboard. The total metric count should stay between 8 and 12.

How often should a RevOps team review their dashboard?

Three cadences cover the full operating cycle: daily automated alerts for threshold breaches (pipeline coverage below 2.5x, forecast slippage exceeding 10%); weekly team reviews covering funnel conversion, deal velocity, and at-risk accounts; and monthly leadership reviews covering forecast accuracy, NRR trend, CAC payback by channel, and quota attainment. Mixing these cadences into a single review creates confusion — each audience and time horizon requires a distinct view.

What vanity metrics should RevOps remove from dashboards?

Remove: raw lead volume (unqualified leads inflate the number without improving revenue), total pipeline created without quality filters, email open rates (a marketing engagement metric, not a revenue predictor), number of activities logged (effort is not output), and MQL attainment in isolation (meaningful only when correlated with pipeline-stage conversion and closed revenue). Any metric that looks good while the business misses quota is a vanity metric by definition.

What is a good NRR benchmark for B2B SaaS?

NRR benchmarks by segment: SMB-focused products 97–103%, mid-market products 105–112%, enterprise products 115–125%. Above 110% is solid across most segments. Above 125% indicates that expansion revenue from existing customers is outpacing churn — a compounding growth dynamic that dramatically reduces dependence on new-logo acquisition. Below 100% means the customer base is contracting in dollar terms even without losing logos, which is a structural warning that requires immediate root-cause investigation.

How do you decide which metrics to add or remove from a RevOps dashboard?

Apply four tests. The action test: can you name the specific decision that changes when the metric moves 20%? The lag test: is it a leading indicator, or a lagging one with a defined strategic use? The ownership test: is there a named individual who monitors it and presents findings? The relevance test: did it inform at least one decision last quarter? Metrics failing any test move to a diagnostic report or are removed. Run this audit quarterly to prevent dashboard expansion through accretion. If you cannot pass all four tests, the metric does not belong on the primary operating view.