Most sales reporting reports the wrong thing. The headline figure is the pipeline total, which is the least informative number available.
Here is why, and what to look at instead.
The problem with pipeline value
It combines things that are not comparable. An enquiry received on Tuesday and a quote a customer has verbally accepted both sit in the same total, weighted by nothing more than optimism.
It only goes up. Adding an opportunity increases it; nobody is incentivised to remove anything. Over a year the total climbs while the business does not.
And it invites a specific bad habit. A pipeline that must reach a target gets padded, and once padded it cannot be used for planning by anybody.
The four figures worth having
1. Conversion rate by stage
Of the opportunities that reached "quoted", what proportion were won? Of those that reached "in discussion", what proportion reached "quoted"?
This is what tells you where the business actually loses work, and the answer is often not where people assume. Businesses that believe they have a lead generation problem frequently have a quote follow-up problem — plenty of opportunities arrive and nobody chases them.
Calculate it over a meaningful period. With low volumes, quarterly rather than monthly, or the numbers move too much to read.
2. Time in stage
How long does an opportunity take to move from one stage to the next, on average, and which stage is slowest?
The stage where things sit longest is where your process has a bottleneck. If quotes take eleven days to produce, that is both a conversion problem and a fixable one — see quoting without the retyping.
3. What has stalled
Open opportunities with no activity in thirty days, and their total value.
This is the most immediately actionable report in any CRM. It is a list of work that has been paid for in effort and is being allowed to lapse. Reviewing it weekly and either chasing or closing each item is a habit that finds real revenue.
It also keeps the pipeline honest, because stalled opportunities are what inflate the total.
4. Won and lost, by source and reason
Where the work came from and, when lost, why.
Source tells you where to spend marketing money. Loss reason tells you whether you are losing on price, on timing, to a competitor, or to no decision at all.
That last category matters. Losing to inaction is common and is a different problem from losing to a competitor — it usually means the case for doing anything was not made, rather than that someone else made it better.
The pipeline total tells you how much has been entered. Conversion, cycle time and stall rate tell you how the business is actually performing.
On weighted forecasting
Multiplying each opportunity by a probability and summing the result produces a single confident-looking number.
For large sales organisations with hundreds of deals, the averaging works. For a business with fifteen open opportunities, it does not — the outcome is dominated by whether the largest one lands, and no weighting captures that.
A more honest approach at small scale: list the opportunities expected to close this quarter, with a real date and a note on what has to happen. Then read the list. It is more useful than a number, and it prompts the right conversation.
Making the data trustworthy
None of this works if the underlying records are not maintained, and they will not be maintained if maintaining them is a burden.
Fewer stages. Four or five, each with a plain definition of what must be true to be in it. Nine stages produce disagreement rather than precision.
Fewer required fields. Each one is a tax on entry — see the CRM data worth capturing.
A dated next action on everything open. Non-negotiable, and it is what makes the stalled report possible.
Regular clearing. A monthly pass through anything untouched for sixty days, either revived or closed. Uncomfortable and necessary.
Automatic capture where possible. Source set by the enquiry form, correspondence attached by the email connection. Fields that fill themselves are always accurate.
Reports people will actually read
Send them rather than housing them in a dashboard. A short weekly email with four figures and the stalled list gets read; a dashboard requiring a login does not — the pattern is covered in automating business reporting.
Keep it to what will change behaviour this week. A report nobody acts on is a report that should be shorter.
The conversation the numbers should produce
Good reporting changes what a sales meeting is about. Instead of reviewing every opportunity in turn, the meeting can start from: conversion is down at the quoting stage, six opportunities have stalled, and two of the three largest came from the same source.
Those are decisions. Reading out a pipeline list is not.
Our CRM team configures reporting for UK businesses around the decisions being made rather than around what the software can display. Start a conversation.
