Sales reporting, dashboards & forecasting
CRM dashboard metrics. The numbers worth a panel of their own.
The short answer. A handful of numbers, not a wall of charts.
Ask most founder-led teams what their CRM dashboard metrics should be, and the instinct is to add more panels: another chart, another breakdown, another filter. The better question is which numbers would actually change a decision this week, because a dashboard is not a report, it is a prompt to act. Most CRMs can report dozens of figures out of the box. Almost none of them deserve a permanent spot on the screen people open every morning.
The ones that earn a place answer four questions: how much is in the pipeline and is it moving (pipeline value and velocity), how often are we winning what we chase (win rate), how big is a typical deal (average deal size), and how long does it take from first contact to signature (sales cycle length). Everything else, calls logged, emails sent, individual activity counts, belongs one level down, useful for coaching a specific rep, not for the dashboard a founder checks on a Monday morning.
How it works in practice. What each metric actually answers.
Pipeline value and velocity. Pipeline value is the total value of open opportunities; velocity is how fast deals are moving through stages, usually tracked as average days per stage. A pipeline can look healthy on value alone while sitting almost still, which velocity catches and a single value figure never will.
Win rate. Won deals divided by won-plus-lost deals in a given period. The 2024 Ebsta and Pavilion B2B Sales Benchmark Report put the average win rate on sales-accepted opportunities at around 21 percent across B2B technology companies, which is a useful line to sense-check your own number against rather than a target to chase blindly: a rate far below that usually points to a qualification problem upstream, not a closing problem at the end.
Average deal size. Total won value divided by number of won deals. Worth tracking by segment, not just overall, because a rising average can hide a shrinking number of large deals propping up a weaker base of small ones.
Sales cycle length. Days from first contact, or from a deal's creation, to close. The same 2024 Ebsta and Pavilion report found a median of around 84 days for enterprise B2B SaaS deals over $100,000 in annual contract value, with the direction of travel mattering more than the absolute figure: a cycle that is quietly stretching out, deal by deal, is an early warning that something in the buying process has got harder.
Pipeline coverage. Open pipeline value divided by the revenue target still to hit, usually expressed as a ratio such as 3x. This is the one leading indicator on the list: it is visible weeks before the result it predicts, where win rate and sales cycle length only ever tell you what has already happened. A team running below its usual coverage ratio knows it has a problem a full quarter before the revenue number confirms it, which is the entire point of tracking a leading metric at all.
Forecast accuracy. How close the CRM's forecast for a closed period came to what actually landed, usually tracked as a simple percentage variance. This one is less about the current pipeline and more about whether the numbers feeding every other metric on the dashboard can be trusted. A forecast that is consistently optimistic by the same margin every quarter is not really a forecasting problem, it is a sign that deal stages or close dates are being set too hopefully further up the pipeline, which is worth fixing at the source rather than correcting for with a permanent discount applied to whatever the CRM reports.
The metrics, side by side. What each one is for and where it comes from.
| Metric | What it answers | Benchmark worth knowing |
|---|---|---|
| Pipeline value and velocity | How much is open, and is it actually moving | No universal figure; track your own trend by stage |
| Win rate | How often a chased deal actually closes | ~21% average on sales-accepted opportunities in B2B tech (Ebsta & Pavilion, 2024) |
| Average deal size | How big a typical won deal is, by segment | No universal figure; watch the trend, not the number alone |
| Sales cycle length | How long first contact to close takes | ~84-day median for $100k+ ACV enterprise SaaS (Ebsta & Pavilion, 2024) |
| Pipeline coverage | Whether there is enough open pipeline to hit the target | 3x open pipeline to remaining target is a common working rule |
None of these benchmarks are a target to chase for its own sake. A win rate above the 21 percent average with a sales cycle also well above the 84-day median can simply mean a team is closing fewer, larger, slower deals than the typical B2B technology business the benchmark describes, which is not necessarily wrong for every model. Use the benchmark to ask a question about your own number, not to judge it against a business that may look nothing like yours.
What good looks like. Built for the person reading it, not for everyone at once.
A CRM dashboard metric is only as useful as the person looking at it is able to act on it. A rep needs their own open tasks and the deals closing this week, nothing more abstract than that. A sales manager needs stage conversion rates and pipeline coverage across the team, so a stall can be caught early. A founder or executive needs forecast against target and the win rate trend over the last few quarters, not a feed of individual calls made.
I worked with a founder-led SaaS team whose single company-wide dashboard tried to serve all three audiences on one screen: activity counts sat next to the executive forecast, and reps had started treating the whole thing as something built for leadership to watch them, rather than a tool they used themselves. Splitting it into three views, one per audience, with the same underlying data but a different handful of panels on each, changed nothing about the numbers and almost everything about whether anyone opened the dashboard without being asked to.
A good test before adding any metric: name the decision it is meant to trigger. Pipeline coverage below 3x triggers a pipeline generation push. Win rate dropping two quarters running triggers a look at pricing or qualification. A metric with no decision behind it is a vanity number, however accurate it is.
Cadence matters as much as content. A rep's dashboard is checked daily, often more than once, so it should refresh in real time and show nothing older than today. A manager's weekly pipeline review works from a dashboard that is allowed to be a day old, since the review itself is the moment decisions actually get made from it. An executive's monthly or quarterly view can sit on a slightly longer refresh cycle, because the decisions it drives, pricing, hiring, target-setting, do not change week to week in any case. Matching refresh frequency to decision frequency stops a dashboard from either lagging behind the decisions it needs to support, or updating so constantly that a daily number gets mistaken for a trend.
Pitfalls to avoid. Where CRM dashboards lose people's trust.
The first pitfall is volume for its own sake. A dashboard with fifteen panels gets skimmed, not read, and the panel that actually matters this week gets lost among ones that do not. Five to seven numbers per audience is usually the ceiling before a dashboard stops being a quick check and becomes a report nobody has time for.
The second is leaning entirely on lagging metrics. Win rate and sales cycle length describe what already happened; by the time either one moves, the quarter that caused it is largely over. Pair at least one leading indicator, pipeline coverage above all, with the lagging ones, so a dashboard gives enough warning to act rather than only enough detail to explain what went wrong afterwards.
The third, and the one that undoes every other effort, is stale or dirty underlying data. A dashboard showing deals that closed weeks ago still sitting as open, or stages that were never updated, trains people to distrust every number on the screen, not just the wrong ones. A CRM dashboard metric is only as good as the hygiene of the record it is built on, which is why fixing data discipline usually has to come before the dashboard, not after it. In practice that means agreeing a short, enforced set of rules before the first panel is built: a deal cannot sit in one stage past a set number of days without a note, a close date is mandatory the moment a deal is created, and a won or lost deal gets its status updated within 24 hours, not whenever someone next happens to open the record.
Pick five numbers per audience, name the decision each one triggers, and review the list every quarter rather than letting panels accumulate unchallenged. That discipline matters more than which reporting tool sits on top of the CRM. For the build itself, our guide to a free sales dashboard template gives a structure to copy this week, and the walkthrough on building a sales dashboard in Looker Studio covers connecting the CRM to a reporting layer once the metric list is settled.
Common questions.
What are the most important CRM dashboard metrics?
For most founder-led teams: pipeline value and velocity, win rate, average deal size, and sales cycle length, each split by the audience reading them. A rep needs activity and deals-closing-soon detail; a founder needs pipeline coverage, win rate trend and forecast against target.
What is a good win rate on a CRM dashboard?
The 2024 Ebsta and Pavilion B2B Sales Benchmark Report put the average win rate on sales-accepted opportunities at around 21 percent in B2B technology, so a team sitting meaningfully below that has a qualification or pricing problem worth investigating before adding more leads.
How long should a sales cycle be?
It depends heavily on deal size and sector, but the same 2024 Ebsta and Pavilion report found a median of around 84 days for enterprise B2B SaaS deals over $100,000 in annual contract value. The number itself matters less than whether it is trending up or down for your own pipeline.
What is pipeline coverage and why does it belong on a dashboard?
Pipeline coverage is open pipeline value divided by the remaining revenue target, usually expressed as a ratio such as 3x. It is a leading indicator, visible weeks before the result it predicts, unlike win rate, which only tells you what already happened.
Why do CRM dashboards stop getting used?
Mainly two reasons: too many panels with no owner or decision attached to them, and stale or dirty underlying data that makes the numbers untrustworthy. A dashboard nobody checks is usually a data hygiene problem wearing a design problem's clothes.
Should every role see the same CRM dashboard?
No. A rep's dashboard should show their own open tasks and deals closing this week. A manager's should show stage conversion and pipeline coverage across the team. An executive's should show forecast against target and win rate trend, not day-to-day activity counts.
Looking at a dashboard that nobody trusts?
Get in touch and we'll work out which numbers actually deserve a panel, and fix the data behind them.
Let's talk ↑