Metric Definition
Reading pipeline health by stage
Track from
Opportunity stage analysis
Opportunity stage analysis is the practice of measuring how deals move through each stage of a sales pipeline, including the conversion rate between stages, the time spent in each stage, and where deals stall or drop out. It turns a single pipeline number into a stage-by-stage picture of where momentum is won and lost. A healthy pipeline converts predictably from one stage to the next and does not pile up at a single bottleneck.
8 min read
What is opportunity stage analysis?
Opportunity stage analysis is the practice of measuring how deals move through each stage of a sales pipeline, from first qualified opportunity to closed won or lost. Rather than looking at total pipeline value as one lump, it breaks the journey into stages and measures the conversion rate, the time spent, and the drop-off at each one. If 200 opportunities enter the proposal stage and 120 advance to negotiation, the proposal-to-negotiation conversion rate is 60 per cent.
It matters because a single headline pipeline figure hides where deals actually succeed or stall. Two teams can carry the same total pipeline value yet have completely different health. One converts steadily at every stage. The other crams deals into an early stage that almost never advance. Stage analysis is what separates a real forecast from wishful thinking. It also feeds sales pipeline velocity, since the time deals spend in each stage is a direct input to how fast revenue arrives.
The analysis rests on a few core measures per stage. Conversion rate is the share of deals that advance. Stage duration is how long they sit there. Stage drop-off is the share lost. Read together across the whole pipeline, these reveal the bottleneck stage where the most value gets stuck, which is almost always the highest-leverage place to intervene. It connects naturally to win rate, the cumulative result of every stage conversion combined.
Stage analysis is only as good as stage hygiene. If reps leave deals parked in a stage they have mentally abandoned, conversion and duration both lie. Define clear exit criteria for each stage and keep stages current, or the analysis measures record-keeping habits rather than real pipeline health.
How to calculate opportunity stage analysis
Opportunity stage analysis is a set of per-stage measures rather than one formula. The central figure is stage conversion rate, the share of opportunities that advance from one stage to the next, but it is read alongside stage duration and drop-off. Calculate each over a fixed period and for a defined set of stages so the numbers stay comparable.
- 1
Define the stages and exit criteria
Lay out the pipeline stages in order and write clear criteria for entering and leaving each one. Without firm exit criteria, deals linger and the conversion numbers blur.
- 2
Count opportunities entering each stage
For the period, count how many opportunities entered each stage. This is the denominator for that stage conversion rate. Count by unique opportunity so a deal that bounces between stages is not double-counted.
- 3
Count opportunities advancing
Count how many of those opportunities moved forward to the next stage. Divide by the entering count and multiply by 100 to get the stage conversion rate.
- 4
Measure stage duration
For each stage, measure the median time opportunities spend there before advancing or dropping out. Median is steadier than mean because a few stuck deals will not distort it.
- 5
Measure stage drop-off
Count the share of opportunities that exit each stage as lost rather than advancing. High drop-off concentrated at one stage points straight to the bottleneck.
A worked example ties the measures together. Suppose 300 opportunities enter the discovery stage in a quarter. Of those, 210 advance to proposal, a 70 per cent conversion rate, with a median duration of 11 days. From proposal, 210 entering becomes 105 advancing to negotiation, a 50 per cent rate, with a median duration of 24 days. The proposal stage is doing the most damage: it converts worst and takes longest. The arithmetic at each stage is simple. The value is in comparing the stages and seeing where the pipeline narrows hardest.
Opportunity stage analysis in a metric tree
A metric tree decomposes pipeline health into the stages a deal passes through and the factors that decide whether it advances at each one. This turns a flat funnel report into a diagnostic map of where momentum is created and lost.
The first level mirrors the pipeline stages, from qualification through to close. Each stage then breaks into the levers that govern its conversion and duration. Qualification depends on lead quality and fit scoring. Proposal depends on how well the solution maps to the need and how fast quotes go out. Negotiation depends on pricing flexibility and decision-maker access. Each leaf is a specific, ownable cause rather than a vague label.
The structure lets sales leaders diagnose precisely. If overall win rate is slipping, the tree shows which stage conversion fell and which underlying lever moved with it. A drop at proposal traces to slow quote turnaround or weak fit. A drop at negotiation traces to pricing or stalled decision-makers. Each diagnosis points to a different action owned by a different person.
Metric tree insight
The bottleneck stage, the one with the worst conversion and longest duration, deserves attention before any other. A 10-point lift at the stage where most value is stuck moves total win rate far more than the same lift at a stage that already converts well.
Opportunity stage analysis benchmarks
Stage conversion benchmarks vary widely by deal size, sales motion, and how stages are defined, so cross-company comparisons are blunt. The most useful benchmark is your own pipeline over time, and the relative shape of conversion across stages. These ranges give rough orientation for a typical business-to-business pipeline.
| Pipeline stage | Typical conversion to next stage | What healthy looks like |
|---|---|---|
| Lead to qualified opportunity | 20-40% | Tight qualification keeps this lower but cleaner. A very high rate often means weak criteria letting poor-fit deals through. |
| Qualified to discovery completed | 55-75% | Most genuinely qualified deals should reach a completed discovery. Heavy drop-off here points to qualification that was too generous. |
| Discovery to proposal | 50-65% | A solid discovery should convert into a proposal for a clear majority of deals. Slippage here signals weak needs analysis or missing stakeholders. |
| Proposal to closed won | 25-45% | This is usually the hardest stage. Conversion depends on fit, pricing, and decision-maker access. Long durations here flag stalled negotiations. |
Read the table as a shape, not a scorecard. A pipeline that converts evenly and predictably across stages is healthier than one with a single spectacular stage and a brutal bottleneck elsewhere. Watch your own stage conversions trend over quarters, because a steady decline at one stage is an earlier warning than any single absolute number.
How to improve opportunity stage analysis
Improving pipeline health means lifting conversion and cutting duration at the stages that constrain the whole funnel. The biggest gains come from finding the bottleneck stage and addressing its specific cause rather than pushing harder on every stage at once.
Tighten qualification
Sharpen entry criteria so only genuine-fit deals enter the pipeline. Cleaner qualification lifts conversion at every stage downstream, because fewer doomed deals dilute the funnel.
Speed up the bottleneck stage
Cut the duration of the slowest stage. If proposals stall, shorten quote turnaround and remove approval delays. Faster movement at the bottleneck shortens the whole cycle.
Secure decision-maker access
Deals stall in late stages when the real decision-maker is absent. Build multi-threaded relationships early so negotiation does not hinge on a single contact who goes quiet.
Diagnose drop-off by stage
Treat each stage drop-off as its own problem with its own cause. Lost-reason analysis at the bottleneck stage usually reveals a specific, fixable pattern rather than a vague forecast miss.
The metric tree approach starts by locating the stage with the largest gap between current and achievable conversion, then drilling into its leaves to find the true cause. If proposal conversion lags, the tree distinguishes a fit problem from a turnaround problem, and they call for different fixes.
KPI Tree makes this accountable by giving each stage and each lever a clear owner. Sales development owns qualification. Account executives own discovery and proposal. Sales leadership owns pricing flexibility and negotiation support. When a stage conversion moves, the change is pushed to the accountable owner of that branch, so a softening proposal stage reaches the right person quickly. The verified impact loop then checks whether the intervention, such as faster quotes, actually lifted the conversion rather than coinciding with it.
Common mistakes when tracking opportunity stage analysis
- 1
Letting stale deals distort the stages
Deals parked in a stage the rep has mentally written off inflate duration and depress conversion. Define exit criteria and clear out dead deals so the numbers reflect reality.
- 2
Measuring conversion without duration
A stage can convert well yet take so long that revenue arrives too late. Always read stage conversion alongside how long deals sit in the stage.
- 3
Ignoring the bottleneck stage
Spreading effort evenly across all stages wastes it. The stage with the worst conversion and longest duration is where the leverage is, and it deserves attention first.
- 4
Inconsistent stage definitions
If reps interpret stages differently, the conversion numbers are noise. Document what each stage means and what it takes to advance, and hold the team to it.
- 5
Treating drop-off as a single number
Lumping all lost deals together hides where and why they were lost. Break drop-off out by stage and capture lost reasons so the pattern becomes actionable.
Related metrics
Win Rate
Sales Metrics
Metric Definition
Win Rate = (Closed-Won Deals / Total Closed Deals) × 100
Win rate measures the percentage of sales opportunities that result in a closed-won deal. It is the single most revealing metric of sales effectiveness, indicating how well your team converts qualified pipeline into revenue.
Sales Pipeline Velocity
Sales Metrics
Metric Definition
Pipeline Velocity = (Opportunities × Deal Value × Win Rate) / Sales Cycle Length
Sales pipeline velocity measures how quickly deals move through your pipeline and generate revenue. It combines the four core levers of sales performance into a single metric that reveals the rate at which your pipeline converts to closed revenue.
Average Deal Size
Sales MetricsMetric Definition
Average Deal Size = Total Revenue from Closed Deals / Number of Closed Deals
Average deal size measures the mean revenue value of closed-won deals. It is a fundamental sales metric that directly influences pipeline velocity, quota planning, and the economics of your go-to-market model.
Lead Conversion Rate
Sales MetricsMetric Definition
Lead Conversion Rate = (Converted Leads / Total Leads) x 100
Lead conversion rate measures the percentage of leads that progress to the next meaningful stage in the sales funnel, whether that is becoming a qualified opportunity, a demo booking, or a paying customer. It is the primary indicator of how effectively your top-of-funnel activity translates into commercial outcomes.
Metric trees for sales teams
Metric Definition
Reading pipeline health by stage is a core sales metric, so this guide shows how to place opportunity stage analysis within a sales teams wider metric tree.
Conversion rate: a metric tree decomposition
Metric Definition
Stage-to-stage conversion is what opportunity stage analysis is really measuring, so this decomposition helps you turn each stage transition into actionable levers.
Decompose your pipeline and find the bottleneck stage
Build an opportunity stage analysis metric tree that connects each stage conversion to the rep and leader who can move it, with the bottleneck made obvious.
