Sales dashboard metrics, explained with the math

Sales dashboard metrics are the numbers that describe a selling operation in motion: pipeline created, deals advancing, quota attainment, and revenue closed. A sales dashboard computes them from opportunity records, so a manager sees the quarter forming before it ends.

The metric set is stable across industries because the underlying process is stable: opportunities enter, advance, and close. What changes is the vocabulary on the labels. A radio ad sales desk and an e-commerce operation track the same 8 metrics below. (CRM-specific KPIs like age in stage get their own treatment in our CRM KPIs article.)

What metrics does a sales dashboard track?

A sales dashboard tracks 8 core metrics: pipeline created, pipeline value, stage conversion, win rate, average deal size, sales cycle length, sales velocity, and quota attainment. Together they describe both the stock of the pipeline (how much exists) and its flow (how fast it converts to revenue).

Metric	Formula	What it tells you
Pipeline created	Sum of new opportunity amounts in the period	Whether the top of the funnel is fed
Pipeline value	Sum of all open opportunity amounts	The revenue sitting in open deals
Stage conversion	Deals reaching stage n+1 ÷ deals reaching stage n	Where deals die in the process
Win rate	Won ÷ (won + lost), measured on a cohort	How often the team closes
Average deal size	Won amount ÷ won count	The size of a typical win
Sales cycle length	Median days from created to closed	How long a deal takes
Sales velocity	(Opps × win rate × deal size) ÷ cycle days	Expected revenue per day
Quota attainment	Bookings ÷ quota, per rep or team	Who is on pace

How does pipeline math work?

Pipeline math reduces to one equation, sales velocity: V = (N × W × D) ÷ L, where N is open opportunities, W is win rate as a decimal, D is average deal size, and L is sales cycle length in days. V is expected revenue per day.

A worked example: 40 open opportunities, a 25% win rate, an $18,000 average deal, and a 45-day cycle produce (40 × 0.25 × $18,000) ÷ 45 = $4,000 per day, roughly $120,000 per month of expected revenue. The equation's real value is diagnostic. When V falls, exactly one of 4 levers moved. The dashboard's job is to show which lever, so the response targets the cause: a prospecting push for N, coaching for W, pricing work for D, or process work for L.

One caution: the inputs must come from the same segment. Velocity computed across enterprise and self-serve deals at once is a number about nothing.

How do you read quota attainment?

Quota attainment is bookings divided by quota, expressed as a percentage, per rep and per team. 100% means the rep delivered exactly the assigned number; 112% means outperformance; 84% means a gap that needs an explanation.

The Pulsar Sales dashboard in our catalogue renders this as a plain table: Alex Morgan at 42 deals and $612K for 112% of quota, Riya Patel at 38 deals and $540K for 98%, Sam Cole at 29 deals and $418K for 84%. Read the pattern, not the individuals. One rep above 110% with the rest below 90% usually means a territory or lead-routing problem, not a talent gap. Attainment also feeds forecasting: a team that lands at 85% for 3 straight quarters has an inflated quota or an underfed pipeline, and the metric set above tells you which.

Which metrics warn you before the quarter ends?

The early-warning metrics are stage age, slipped deals, and forecast category movement. Headline numbers like closed revenue only move after the outcome is decided; these 3 move while the outcome is still changeable.

Crest, our revenue forecasting dashboard, is built around this idea. Its panels include a Stage waterfall shaded by deal age, a list of deals that Slipped out of FQ3, a Forecast category ledger tracking commits against best cases, a Win rate by segment chart, and a Loss reasons Pareto. Age in stage works like this: every stage has a historical median dwell time, and a deal that doubles its median is statistically dying even when the rep is confident. Slipped close dates compound the signal: a deal that has pushed its close date twice is telling you the buyer's urgency is gone.

How does a rep view differ from a manager view?

A rep view shows one book of business; a manager view shows the whole team with the same metrics computed per person. The metric definitions stay identical, only the grouping changes. A rep checks her own attainment, her own aging deals, and her next week of meetings. A manager checks the distribution: attainment across the roster, pipeline coverage by segment, and conversion by stage. Dashboards like Crest handle this by dedicating panels to each zoom level, a Quota attainment panel for the full roster next to a Top open deals list for individual inspection.

Where can you see these metrics running live?

The metric set above ships in working files. Crest, the revenue forecasting dashboard, covers the warning metrics; Pulsar Sales carries the quota attainment table and revenue overview; Vantage Commerce is free on the free templates page if you want to inspect the construction first. All of them sit in the sales dashboard templates hub, and every preview is the working file, watermark aside. For quote-to-order operations, Foundry tracks the same math on a manufacturing desk.

Browse the sales dashboard templates → · Full template catalogue