Metric Definition
Stage-by-stage conversion
Track from
Sales funnel analysis
Sales funnel analysis is the practice of measuring how prospects move and convert through each stage of the buying process, from first touch to closed deal. It exposes where deals stall and which stage transition is leaking the most revenue. Because it is stage based, it lets you fix one specific handoff rather than guessing at the whole pipeline.
8 min read
What is sales funnel analysis?
Sales funnel analysis is the practice of measuring how prospects move and convert through each stage of the buying process, from first contact to closed deal. Rather than treating the pipeline as a single black box, it breaks the journey into defined stages and measures the conversion rate between each one. The result is a clear picture of where prospects advance and where they drop out.
A typical funnel has stages such as lead, marketing qualified lead, sales qualified lead, opportunity, proposal, and closed won. At each stage a fixed share of prospects continue and the rest fall away. If 1,000 leads enter the top and 50 become customers, the overall funnel conversion is 5 per cent. Funnel analysis goes further and tells you whether that loss happened at lead qualification, at the demo, or at the proposal.
The value of the analysis is precision. A blended pipeline conversion number tells you something is wrong but not where. Stage level conversion tells you exactly which handoff to fix. Improving the worst single transition usually moves overall revenue more than a broad effort spread across every stage.
Definition note
Measure conversion between adjacent stages, not just the top to bottom total. A healthy overall rate can hide one badly leaking stage that an aggregate number masks. The point of funnel analysis is to find that one stage.
How to calculate sales funnel analysis
You calculate the conversion rate for each stage by dividing the number of deals that advanced to the next stage by the number that entered the current stage, then multiplying by 100. You repeat this for every stage transition in the funnel.
For example, if 1,000 leads produce 400 marketing qualified leads, that stage converts at 40 per cent. If those 400 produce 160 sales qualified leads, that stage converts at 40 per cent. If those 160 produce 40 closed deals across the remaining stages, the back half of the funnel is where most of the loss happens. Multiplying every stage rate together gives the overall funnel conversion, in this case 4 per cent.
- 1
Define the stages
Agree on a fixed set of stages with clear entry and exit criteria. Every deal must sit in exactly one stage so counts do not overlap. Vague stage definitions make the analysis unreliable.
- 2
Count deals entering each stage
For a chosen period, count how many opportunities entered each stage. Use a consistent cohort so a deal counted at the top is the same deal tracked to the bottom.
- 3
Count deals advancing to the next stage
Count how many of those opportunities moved forward to the following stage. Deals that were lost or went dormant do not count as advancing.
- 4
Divide and express as a percentage
Divide advances by entries for each transition and multiply by 100. Multiply all stage rates together for the overall funnel conversion rate.
Sales funnel analysis in a metric tree
A metric tree turns funnel analysis from a static report into a diagnostic. The root is overall funnel conversion, and each branch is a stage transition with the operational drivers that move it underneath. Because each stage is owned by a different team, the tree makes it obvious who needs to act when a number slips.
Metric tree insight
When the MQL to SQL rate drops, the tree shows whether the cause is slow SDR follow-up or weak qualification criteria, and it points at the owner of that node. KPI Tree assigns RACI ownership on every metric, so the accountable person is pushed the change the moment the stage moves, and the verified impact loop checks whether their fix actually lifted the rate.
Sales funnel analysis benchmarks
Conversion benchmarks vary widely by motion, deal size, and lead source, so treat these as starting ranges rather than targets. Self-serve and inbound funnels convert higher at the top and lower at the bottom, while outbound enterprise funnels do the reverse. The most useful benchmark is your own funnel measured over time.
| Stage transition | Inbound or PLG | Mid-market | Enterprise outbound |
|---|---|---|---|
| Lead to MQL | 20% to 40% | 15% to 30% | 10% to 20% |
| MQL to SQL | 25% to 45% | 20% to 35% | 15% to 30% |
| SQL to opportunity | 40% to 60% | 40% to 60% | 35% to 55% |
| Opportunity to closed won | 15% to 30% | 20% to 30% | 20% to 35% |
Benchmark note
A funnel that loses most of its volume at one specific transition is more fixable than one that leaks evenly. Find the stage furthest below its benchmark and concentrate effort there before optimising stages that are already healthy.
How to improve sales funnel analysis
Improving the funnel means lifting the conversion rate of the weakest stage, not running a broad campaign across all of them. Identify the transition with the largest gap to benchmark, work out why prospects stall there, and remove that specific friction. Then re-measure and move to the next weakest stage.
Fix the worst stage first
Rank every transition by its gap to benchmark and concentrate on the single weakest one. A ten point lift on the worst stage moves overall revenue more than a small lift everywhere.
Speed up the handoffs
Slow follow-up between stages is one of the most common leaks. Cutting the time between a lead arriving and the first qualification touch often lifts the early stage rate on its own.
Tighten qualification criteria
Letting unqualified deals advance inflates early stage counts and crushes later ones. Sharper entry criteria for each stage produce a smaller but far healthier funnel.
Assign an owner per stage
Each transition is influenced by a different team, from marketing to SDRs to account executives. Give every stage a named owner so a dip triggers action rather than a debate about whose number it is.
Common mistakes when tracking sales funnel analysis
- 1
Looking only at the overall rate
The top to bottom number tells you something is wrong but not where. Without stage level rates you cannot act, and a single bad transition stays hidden inside a respectable aggregate.
- 2
Blending different motions together
Inbound and outbound funnels convert in opposite shapes. Averaging them produces a number that describes neither and hides the real problem in each.
- 3
Changing stage definitions mid-analysis
If the criteria for entering a stage shift partway through, the cohort counts stop being comparable and the conversion rates become meaningless. Lock the definitions before you measure.
- 4
Ignoring time in stage
A deal that technically advanced but sat in a stage for months is a different signal from one that converted quickly. Track how long deals dwell, not just whether they moved.
Related metrics
Lead Conversion Rate
Sales Metrics
Metric 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.
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.
Conversion Rate
CVR
Marketing Metrics
Metric Definition
Conversion Rate = (Number of Conversions / Total Visitors or Leads) × 100
Conversion rate measures the percentage of visitors, users, or leads who take a desired action, such as making a purchase, signing up for a trial, or submitting a form. It is the fundamental metric for evaluating the effectiveness of any acquisition funnel, landing page, or marketing campaign.
Conversion rate: a metric tree decomposition
Metric Definition
Sales funnel analysis is stage-by-stage conversion, so this decomposition shows you how to break each conversion step into the drivers you can act on.
Metric trees for sales teams
Metric Definition
This guide places sales funnel analysis alongside the other measures a sales team tracks, so you can see how stage conversion connects to pipeline and revenue.
Find the one stage that is leaking your pipeline
Build your funnel as a metric tree in KPI Tree, with each stage transition broken into its drivers and a named owner on every node, so a dip in conversion goes straight to the person who can fix it.
