The CRM is the most under-used diagnostic tool in most sales organisations. Not because the data is missing, but because the reports being run are the wrong reports — activity counts, leaderboards, revenue rollups. Those tell you what happened. They do not tell you where the system is losing conversion, extending cycle time or absorbing slip. Five reports, run consistently, will tell you exactly where deals are losing momentum and which stage to fix first.
Why activity reports stopped telling the truth
Activity reports were useful when the correlation between calls-made and revenue-closed was strong. Today, buyer behaviour has broken that correlation. A team can run more activity, hit more meetings and still miss the number — because the friction is not at the top of the funnel; it is somewhere in the middle, quietly compounding.
The reports below focus on where deals actually die, not where activity is loudest.
Report 1 — Stage conversion
What percentage of deals move from each stage to the next? This is the single most important sales report and the one most often missing. It shows exactly which stage is the choke point — the stage where investment in coaching, training or asset improvement will produce the largest revenue lift.
A healthy funnel usually shows steadily declining conversion. A sudden cliff — a 60 percent drop between two stages, for example — is a diagnostic gift. That is the stage to fix first.
Report 2 — Stage cycle time
How long do deals spend at each stage compared to your target? Cycle time by stage exposes where deals stall silently. 'Proposal sent' is the most common graveyard: deals age there indefinitely because no exit criterion forces them out.
Set a target duration per stage. Deals that exceed it should trigger a manager review, not a nudge email.
Report 3 — Loss reasons by stage
Which reasons are increasing, and are they tied to a specific stage? Aggregated loss reasons are noise. Loss reasons by stage — for example, 'no budget' losses concentrated at the qualification stage — point directly at the fix.
Enforce a mandatory disqualification reason on stage exit. Without it, half the funnel disappears without diagnostic trace.
Report 4 — Rep variance
Where does conversion vary most between reps, and why? Variance between reps at a single stage is the most efficient training signal a manager will ever get. If one rep converts discovery at 70 percent and another at 30 percent, the training focus is obvious.
The point of the report is not ranking. It is capability targeting. Pair the low performer with the high performer on that specific stage for a fortnight and re-measure.
Report 5 — Forecast accuracy and slip
What percentage of commit deals actually land in the quarter, and how far do slip deals push? Forecast accuracy is a leadership signal — under 70 percent for two consecutive quarters means the definition of 'commit' has drifted.
Slip rate is the sibling metric. If deals push by an average of six weeks, the exit criteria at the late stages are not tight enough.
Move from observation to intervention
The reports are only useful when they lead to a specific change: an updated exit criterion, a new sales asset, a focused coaching sprint, a positioning adjustment. Data that does not change behaviour is decoration.
A minimum-viable rhythm: run the five reports weekly, name one intervention per week, measure the effect at the end of the month.
- Weekly: run the reports, agree one intervention.
- Monthly: measure the intervention's impact on the specific stage.
- Quarterly: rebaseline targets and refresh the intervention backlog.
Frequently asked questions
What CRM reports should every sales manager run weekly?+
Five reports: stage conversion rates, average time-in-stage, deal age by stage, activity-to-outcome ratio, and loss reasons by segment. Together they surface friction before it becomes a forecast miss.
How do I know my CRM data is trustworthy?+
Trust improves when stage advancement requires evidence, close dates are updated after every buyer interaction, and loss reasons are mandatory. Without those three disciplines, reports reflect rep optimism rather than pipeline reality.
What is a healthy stage conversion rate in B2B sales?+
It varies by industry, but typical B2B service benchmarks are 40–60% qualified-to-discovery, 50–70% discovery-to-proposal and 25–40% proposal-to-close. What matters more than the absolute number is the trend and where the biggest drop-off sits.
How often should I clean my CRM pipeline?+
Weekly, as part of the pipeline review. Any deal without a next step calendared or with a close date in the past gets triaged: advance, reset or disqualify. Monthly clean-ups are too infrequent to keep forecasting honest.