Your pipeline report is telling you what happened. Not what’s about to.
Most B2B sales dashboards count activity. Activity is the easiest thing to measure and the least useful thing to know. This is what to put on the screen instead — the six numbers that actually predict whether you hit the number, and the four that quietly waste everyone’s time.
Activity theatre
Walk into most $5M–$50M B2B businesses and ask to see the sales dashboard. You’ll get a wall of green: calls made, emails sent, meetings booked, total pipeline value. Every number is going up. Nobody in the room can tell you whether the quarter is safe.
That’s not a reporting problem. It’s a measurement problem. The dashboard is measuring effort because effort is easy to capture automatically. The things that predict revenue are harder to capture, so they don’t get measured — and what doesn’t get measured doesn’t get managed.
What most dashboards show
- Calls and emails logged this week
- Total open pipeline value
- Number of MQLs generated
- Meetings booked per rep
- Overall win rate, all deals combined
- Revenue vs target, month to date
What actually predicts the quarter
- Pipeline coverage against the gap still to close
- Conversion rate at each individual stage
- Days a deal has sat in its current stage
- How many times a close date has moved
- Sales velocity as one composite number
- Revenue by source — not leads by source
What it should look like
One screen. Six numbers. Readable in about ten seconds by someone who doesn’t work in sales. If a dashboard needs explaining, it has failed.
Pipeline Coverage
2.4×
$3.1M open against a $1.28M gap still to close.
Sales Velocity
$14.2k
Expected revenue produced per day by the current pipeline.
Avg Cycle Length
94 days
First qualified contact to signed order, trailing 12 months.
Stage Conversion — where deals actually die
Deal age in current stage
Lead source — volume vs revenue
Illustrative figures. The layout is the point — three headline numbers, two diagnostics, one attribution view.
What each number actually tells you
None of these require new software. Every one can be built from data a functioning CRM already holds — which is usually the problem, because most CRMs aren’t holding it.
Pipeline coverage ratio
Raw pipeline value is meaningless on its own. $3M of pipeline is excellent against a $500k gap and a disaster against a $2M one. Coverage is the only version of this number worth showing.
Healthy floor: 3× for most B2B. Long-cycle technical sales often need 4–5×.
Stage conversion rates
An overall win rate averages away the only useful information. You need the drop between each pair of stages, because one of them is doing almost all the damage — and it’s rarely the one people assume.
Look for the single biggest drop. Fix that one thing first.
Sales velocity
The best single composite number in B2B. It folds volume, quality, value and speed into one figure, which means you can’t game it by inflating any one input.
÷ avg cycle length in days
Track the trend, not the absolute. Direction is the signal.
Days in current stage
The single most underused number in B2B sales. Deals almost never get formally rejected — they go quiet and rot in place. Stage age catches that weeks before a forecast does.
Set a threshold per stage, not one global number.
Close-date slippage
Count how many times a deal’s expected close date has been pushed. It is the most honest predictor of a deal that will never close, and almost nobody reports it because it makes the forecast look bad. That’s precisely why it’s valuable.
Slipped 3+ times: treat as lost until proven otherwise.
Source to revenue
Marketing reports leads by source. Finance cares about revenue by source. These two views routinely rank channels in opposite orders, and the lead view is the one that gets budget decisions wrong.
Requires source to survive the whole journey in the CRM.
Four numbers to take off the dashboard
Not because they’re wrong, but because they crowd out the ones that matter and create false comfort. Every metric on a dashboard costs attention. These don’t earn it.
× Activity counts
Calls made, emails sent, touchpoints logged. These measure effort, not progress. Worse, they’re trivially gamed — and the moment a rep knows they’re measured on call volume, you get call volume instead of revenue.
× Total pipeline value
Meaningless without the gap it’s covering. Replace it with coverage ratio. A growing pipeline number alongside a growing target can represent a position that’s getting worse, not better.
× MQLs
A category invented so marketing could report a number it controls. If an MQL doesn’t convert to pipeline at a known rate, it isn’t a metric — it’s a vanity count. Report qualified opportunities created instead.
× Blended win rate
A single win rate across all deal types, sizes and sources hides everything useful. Segment it or drop it. A 22% blended rate might be 45% on referrals and 4% on paid — two completely different businesses.
How to actually build this
In roughly this order. Most teams try to start at step three and wonder why the dashboard is full of blanks.
Fix the data before you build the view
Every metric above depends on three fields being reliably populated: stage, stage-entry date, and original source. If reps aren’t filling those in, no dashboard will save you — you’ll just get a beautiful visualisation of missing data.
This is almost always the real project. Budget most of your time here. If your CRM isn’t being used properly, start with why your CRM isn’t getting used before touching reporting.
Build it inside the CRM first
Before anyone opens Power BI, build the simplest possible version using native CRM reporting. It’s faster, it stays live automatically, and it forces you to discover which fields are actually missing.
Most mid-market CRMs handle four of the six natively. Pipedrive gives you stage conversion, deal rot and velocity out of the box without a consultant, which makes it a sensible place to prove the concept.
Move to Power BI only when you need to join data
The honest trigger for a BI tool is joining sources the CRM can’t see — ERP order data, delivery dates, margin by product line, service history. If everything you need lives in the CRM, a BI layer adds cost and a refresh schedule for no gain.
When you do move, keep the same six metrics. The temptation with a real BI tool is to build forty visuals because you can. Resist it. The value was always the restraint.
Put it on a wall and review it weekly
A dashboard nobody looks at is a report. The operating rhythm matters more than the visualisation: one 30-minute weekly review, same six numbers, and a rule that any stalled deal must be actioned or closed out on the spot.
Automate the refresh and the alerts so nobody has to remember — a simple Make.com scenario can push stalled-deal alerts into Slack or email the moment a threshold trips.
Get the B2B Sales Stack Cheat Sheet
The tools and templates behind the six metrics above — one page, no fluff. Sent straight to your inbox.
The dashboard is the easy part
The hard part is the data underneath it. If your pipeline isn’t visible today, the problem is almost never the reporting tool — it’s what the CRM is and isn’t capturing.
Some links on this page are affiliate links. If you sign up through them we may earn a commission at no extra cost to you. It doesn’t change what we recommend — the six metrics above work identically regardless of which tool you use.