Dashboard Templates › Learn › CRM KPIs
Learn23 Jul 2026 · 8 min read
CRM KPIs: what should a CRM dashboard measure?
CRM KPIs are the small set of numbers that describe whether a sales pipeline is real and on pace: pipeline value, coverage, win rate, average deal size, cycle length, and stage conversion. A good CRM dashboard computes all of them from the same opportunity records.
The list below is deliberately short. Eight KPIs cover the standing questions of a sales team, and each one appears in a live template from our catalogue, so you can check the formula against a working screen. If you are new to the instrument itself, start with what a CRM dashboard is and come back.
Which KPIs belong at the top of a CRM dashboard?
The top row of a CRM dashboard should carry 4 headline KPIs: closed revenue, win rate, average deal size, and new accounts or new pipeline created. These 4 answer the first morning question: is the quarter landing, and is new material arriving to feed the next one?
The values should carry comparisons, because a number without a reference is trivia. Relay, our free CRM template, shows exactly this row: Closed revenue at $1.28M with +14.2% quarter over quarter, Win rate at 34% with +2.1 points, Avg. deal size at $9,400 with +5.4%, and New accounts at 126 with -3.0%. The deltas do the work. A flat 34% win rate means one thing after a year at 32% and something else after a year at 40%.
How is pipeline coverage calculated?
Pipeline coverage is open pipeline value divided by the remaining target. If your team holds $540K of open pipeline against a $180K quarterly target, coverage is 3.0x. That exact pairing appears on the Fulcrum dashboard in our catalogue, which tracks coverage against a $180K quarterly target.
The folklore says 3x is enough. The arithmetic says the coverage you need is the inverse of your win rate. A team that wins 33% of its pipeline needs 3x. A team that wins 15% needs close to 7x. The honest version of this KPI is stage-weighted: a deal in qualification counts for less than a deal in closing, because historical conversion says so. Coverage computed from untouched leads is comfort, not a forecast.
What does win rate actually measure?
Win rate is the share of closed opportunities marked won: won deals divided by won plus lost, measured on a defined cohort. The denominator matters. Dead deals parked in an "on hold" stage never enter the count, and the win rate climbs without a single deal being won.
Win rate also means nothing blended. A team selling $5K self-serve deals and $200K enterprise deals has 2 win rates, not 1. The useful dashboard segments the KPI by deal type, region, or rep. Crest, our revenue forecasting dashboard, carries a Win rate by segment panel for exactly this reason, next to a loss-reason Pareto that shows where the losses concentrate.
Which CRM KPIs warn you early?
The early-warning KPIs are age in stage, slipped close dates, and stage conversion. They detect dying deals while the forecast still has time to react, which the headline KPIs cannot do, because headline numbers only move after the deal is already lost.
Age in stage is the count of days a deal has sat in its current stage versus the historical median for that stage. A proposal-stage deal at day 40 against a median of 18 is a problem regardless of what the rep believes. Slipped close dates are the count of times a deal's close date has been pushed; 2 pushes is a pattern. Stage conversion is the share of deals entering each stage that advance to the next, measured on a created cohort. Stage conversion tells you where the pipeline leaks; age in stage tells you which deals are leaking right now.
| KPI | Formula | Healthy reading |
|---|---|---|
| Pipeline value | Sum of open opportunity amounts | Large enough to cover the target at your win rate |
| Closed revenue | Sum of won amounts in the period | Rising quarter over quarter; Relay shows $1.28M, +14.2% QoQ |
| Win rate | Won ÷ (won + lost), by cohort | Stable or rising, segmented; Relay shows 34% |
| Average deal size | Won amount ÷ won count | Stable within a segment; Relay shows $9,400 |
| Sales cycle length | Median days from created to closed | Stable; a lengthening cycle predicts a weak quarter |
| Pipeline coverage | Open pipeline ÷ remaining target | At least 1 ÷ win rate, stage-weighted |
| Stage conversion | Deals reaching stage n+1 ÷ deals reaching stage n | Stable quarter to quarter, measured on cohorts |
| Age in stage | Days in current stage vs stage median | Short tail; stale deals worked or killed |
How many KPIs is too many?
A CRM dashboard that tracks more than about 10 KPIs stops being an instrument and becomes a filing cabinet. The test is decision linkage: every number on the screen should map to an action someone takes when it moves. Coverage drops, the manager pushes prospecting. Stage conversion sags at proposal, the team reviews pricing. A KPI with no attached action is decoration, and decoration crowds the numbers that matter.
Where can you see these KPIs computed live?
Every KPI in the table above appears in a working file. Relay, the free CRM dashboard template, shows the headline row and the pipeline panels; Fulcrum adds coverage against its $180K target, stage conversion, and a rep leaderboard; Crest carries win rate by segment and the loss-reason Pareto. The full set lives in the CRM dashboard templates hub, and Relay costs nothing on the free templates page. For the broader metric set beyond CRM, see sales dashboard metrics and pipeline math.
Check these KPIs in the free Relay template → · Browse all dashboard templates