Marketing & Advertising
Sales Funnel Calculator
Analyze lead flow through qualification, opportunity, and customer stages. Measure stage conversion, drop-off, overall close rate, average deal value, and export the complete funnel as a professional PDF.
Lead-to-qualified rate-
Qualified-to-opportunity rate-
Opportunity close rate-
Overall lead-to-customer rate-
Average revenue per customer-
Stage conversion
Volume and drop-off through the funnel
Sales funnel stage volumeCounts entered for the same cohort
| Stage | Volume | Conversion from prior | Drop-off count | Drop-off rate | Share of initial leads |
|---|
Pipeline view
Sales stage movement and deal value
Lead flow, qualification, opportunity creation, close rate, and revenue per customer are separated.
Sales stage movement and deal value
Leads0
Qualified0
Opportunities0
Customers0
Overall close0
Opportunity close0
Average deal0
Revenue0
How to use Sales Funnel Calculator
- Enter leads, qualified leads, opportunities, customers, and booked revenue from one consistent sales period.
- Review each stage conversion rate before using the overall conversion rate; a small middle-stage leak can hide behind a healthy top-of-funnel number.
- Use the pipeline visual and scenario table to test whether improving qualification, opportunity creation, or closing would move revenue most.
Calculator guide
Understanding Sales Funnel Calculator
A sales funnel shows how volume changes from leads through qualification and opportunity to customers. Stage-by-stage conversion reveals where the greatest absolute and proportional losses occur.
Calculation method
How the calculation works
Stage conversion rate = next-stage count / prior-stage count x 100. For each adjacent stage, divide the next count by the prior count. Calculate drop-off as the difference, overall conversion as customers divided by leads, and average deal value as revenue divided by customers.
What the sales funnel shows
When to use the result
Worked situations
Practical examples
- Use Sales Funnel Calculator for a quick everyday estimate.
- Change any input to compare another scenario.
Better inputs
Useful tips
- Use mutually consistent stage definitions.
- Measure cohorts over enough time to complete the sales cycle.
- Segment by source, product, sales team, and customer type.
Before relying on the result
Limitations and common mistakes
- Open cohorts can understate later-stage conversion.
- Counts do not reveal deal quality, cycle length, or profitability.
- Customers moving backward or skipping stages require more detailed event data.
Reference
Key terms
- Lead
- Initial prospect entering the measured funnel.
- Opportunity
- Qualified potential deal under the selected sales definition.
- Drop-off
- Records not advancing from one stage to the next.
- Close rate
- Customers divided by leads or opportunities, depending on the stated denominator.
Important note
Calculated from the entered campaign values. Validate attribution, incrementality, lag, margin, and observed source data before making decisions.
Frequently asked questions
Why can a stage exceed the previous stage?
Mixed periods, reopened records, duplicates, or inconsistent stage definitions can cause this; reconcile the data before interpreting rates.
What is overall conversion?
Customers divided by the initial lead count.
Should I use created or closed cohorts?
Use cohort-based analysis when sales cycles are long so records have time to progress.
Does the funnel measure profitability?
No. Add acquisition cost, margin, and lifetime value for economics.