Sales & PartnershipsFree
Sales Conversion Rate Analysis by Stage
Conversion by stage computed on deals that have actually resolved, ranked by how many you lose at each one rather than by percentage.
River returns a sheet, a chart and a short document. The sheet is conversion by stage, by segment and by rep, computed only on opportunities that have reached a terminal state, with deals lost and dollars lost sitting next to every rate. The chart is the funnel drawn per segment rather than in aggregate. The document names the one stage worth working on next quarter and the two changes to make there.
The ranking is by absolute loss, not by rate, and that single change usually moves the answer. A stage converting at 53 percent looks like an emergency until you count how many deals reach it. Rank by deals lost and a different stage wins; rank by dollars lost and a third one does. All three columns appear on the sheet, because the disagreement between them is the finding rather than a rounding problem, and which one a dashboard sorts on is usually an accident of whoever built it.
Written for the sales manager preparing a quarterly review, the revenue operations analyst who has been asked why win rate moved, and the founder looking at a funnel chart for the first time. Run it at quarter end with four quarters of history behind it, before anybody has committed next quarter's coaching time to a theory. The review itself is the deal review pack, what happens on the calls inside the worst stage is the call coaching pack, and rolling the resulting number upward is the forecast submission pack.
Why a conversion rate points the wrong way
A conversion rate is a relative measure and relative measures do not tell you what a fix is worth. The Cochrane Handbook makes the same point about clinical effects: even if relative effects are similar across subgroups, absolute effects will differ according to baseline risk. Baseline risk in a funnel is how many deals arrive. Two stages losing a third of what enters them are not the same problem when one sees 705 deals and the other sees 96.
Aggregating across segments hides the reversal that matters. Bickel, Hammel and O'Connell examined Berkeley graduate admissions and found the aggregate data shows a clear but misleading pattern that vanished once each department was looked at on its own. A funnel behaves the same way, so every rate on the sheet is computed per segment as well as overall, and the two are reported side by side. Where they disagree, the segment figure names a change and the aggregate hides it.
Thornbury Systems, four quarters, 1,000 opportunities created and 820 resolved. Security review converts worst at 53.1 percent, so it gets the attention. Discovery loses the most deals at 207. Proposal loses the most money at $6.44 million. Once losses that were never winnable come out, Proposal holds $6.44 million of addressable loss and security review holds $1.26 million, which ranks it fifth of six. A quarter of coaching time was heading to the stage the arithmetic puts fifth.
How it works
Close the cohort
Drop live deals out of every denominator, and report how many were dropped and from where.
Count the losses
Deals and dollars lost at each stage, sitting beside the conversion rate rather than instead of it.
Cut by segment
Every stage recomputed per segment and per rep, with any reversal against the aggregate flagged.
Price the fix
What each stage is worth fixing, after the losses that were never winnable come out.
What you get
- Conversion by stage computed only on opportunities that have reached a terminal state
- Deals lost and dollars lost beside every rate, with the three rankings shown together
- The same funnel drawn per segment, so an aggregate reversal shows up rather than hiding
- Losses split into the ones that were winnable and the ones that never were
- Conditional stages flagged, since a stage most deals skip cannot be compared to one they enter
- A ceiling in dollars on fixing each stage, so two candidate projects can be compared
Common questions
Our CRM already reports conversion by stage.
It reports a rate, and a rate on its own cannot tell you what a fix is worth. It also usually counts live deals in the denominator. In the worked example that combination understates late stages by nearly ten points and hands the team the stage where the least money sits.
Why drop open deals from the denominator?
Because they have not converted or failed yet, so counting them as failures measures cycle time rather than conversion. Negotiation reads 73.0 percent with its 48 open deals included and 84.8 percent without them, which is the difference between the second-worst stage in the business and the second best.
What counts as a loss that was never winnable?
One where no selling could have changed the outcome. A deal that entered Discovery with no confirmed budget and nobody named to sign, or a security review failed on a control the product does not have. Both belong on the sheet, and neither belongs in the number you are trying to move.
Is a stage most deals skip even comparable?
No, and it gets flagged rather than ranked alongside the rest. Security review in the worked example is enterprise only, so 96 deals reach it against 705 at Discovery. Comparing their percentages side by side is what produces the wrong answer, which is why deals entered sits next to every rate.
The segment cut contradicts our overall numbers.
That is the useful outcome, and it is common enough to have a name. Proposal loses 31.5 percent overall, which hides mid-market at 45.4 percent against inbound SMB at 18.3 percent. One number describes a stage and the other tells you what to change. Losses per deal are the post-mortem.
How many quarters of history does this need?
Four is comfortable, two is workable, one is not. The constraint is the resolved cohort rather than elapsed time: you need enough deals that have finished at each stage for the rate to mean anything, and late stages resolve slowest. The sheet prints the denominator next to every figure.
What do we actually do with the winning stage?
Two changes, both specific. In the worked example, route inbound SMB out of Discovery until budget and a signer exist, and find what mid-market proposals lose against that SMB ones do not, which is usually price. That second question is the three-year comparison.
Sales Conversion Rate Analysis by Stage
Fill in the form and your workspace opens with the work already underway.