How to build a sales funnel report
A funnel report visualizes where prospects leak as they move from awareness to purchase. Its whole purpose is to find the single stage where you lose the most, so you fix the constraint rather than spreading effort evenly.
The key discipline is measuring a consistent cohort. Following the same group of leads through the stages, rather than mixing time periods, is what makes the conversion rates trustworthy.
- Stage-by-stage Conversion at each step
- Biggest drop Your constraint
- Fixed cohort For valid rates
Short answer
Build a sales funnel report by counting how many prospects enter each stage and what share convert to the next, from lead through closed-won. Lay the stages top to bottom, show the conversion rate between each pair, and highlight the biggest drop-off. That weakest step is your constraint and where to focus.
Step by step
Define the funnel stages
List the stages from lead to closed-won: lead, MQL, SQL, opportunity, proposal, closed. These should match your pipeline so the report ties to reality.
Count entries at each stage
For a fixed cohort, count how many reached each stage. Use one cohort of leads followed over time, not different time slices, so the rates reconcile.
Compute conversion between stages
Divide the count entering each stage by the count entering the prior stage. These pass-through rates are the substance of the report.
Highlight the biggest leak
Find the lowest conversion rate relative to its benchmark. That is your constraint. Model the revenue impact of improving it before choosing where to invest.
Common mistakes
Mixing time periods so the counts do not reconcile. If this month's leads are compared to last month's opportunities, the rates are meaningless. Follow one cohort through the funnel.
Focusing on the widest part of the funnel out of habit. The stage worth fixing is the one furthest below its benchmark, which is often mid-funnel, not the top.
How Ardovo handles it
Ardovo builds the funnel from live lead and deal data with conversion at every stage, and Rook points to the biggest leak and estimates the revenue from fixing it. The report updates itself, so it is never a manual month-end rebuild.
Frequently asked questions
How do you build a sales funnel report?
Count entries and conversion at each stage from lead to closed-won for a fixed cohort, then highlight the biggest drop-off. The weakest conversion step relative to its benchmark is your constraint and where to focus.
What is the difference between a funnel report and a pipeline report?
A funnel report shows aggregate conversion rates between stages to find leaks. A pipeline report shows the specific open deals and their stages right now. The funnel is the shape; the pipeline is the deals.
Which funnel stage should I fix first?
The one furthest below its benchmark, because it is the constraint. Weigh position too: improving a late-stage rate multiplies against every earlier stage, so it can be worth more per point than a top-of-funnel fix.