Sales Funnel Conversion Rate Formula
Learn how to calculate conversion rates at each stage of a sales funnel, overall funnel conversion, drop-off, and estimated revenue.
The Sales Funnel Conversion Rate Calculator estimates how efficiently people move from visitors to leads, leads to opportunities, and opportunities to customers. Understanding the formulas helps you spot weak stages, compare funnel performance over time, and estimate revenue from conversions.
- 100% Free
- No Sign-Up Required
- Private & Secure
- Mobile Friendly
Overall Funnel Conversion Rate
Where:
Take the number of customers, divide it by the number of visitors, and multiply by 100 to get the percentage of top-of-funnel traffic that became customers.
Variables Explained
| Variable | What It Means | Unit |
|---|---|---|
| visitors - Visitors | Total number of people entering the top of the funnel during the measured period. | number |
| leads - Leads | Number of visitors who became leads. | number |
| opportunities - Opportunities | Number of leads that became qualified opportunities. | number |
| customers - Customers | Number of final conversions or paying customers. | number |
| averageDealValue - Average Deal Value | Average revenue generated per customer. | currency |
Step-by-Step Calculation
Calculate visitor-to-lead conversion rate
This shows what share of all visitors became leads.
visitors = 0 ? 0 : (leads / visitors) * 100
Calculate lead-to-opportunity conversion rate
This measures how many leads progressed into qualified opportunities.
leads = 0 ? 0 : (opportunities / leads) * 100
Calculate opportunity-to-customer conversion rate
This shows the closing rate for opportunities.
opportunities = 0 ? 0 : (customers / opportunities) * 100
Calculate overall funnel conversion rate
This combines the whole funnel into one top-to-bottom conversion percentage.
visitors = 0 ? 0 : (customers / visitors) * 100
Calculate estimated revenue
Multiply the number of customers by the average value per deal to estimate total revenue.
customers * averageDealValue
Calculate stage drop-off counts
These values show how many people did not move to the next stage at each step.
visitorDropOff = max(visitors - leads, 0); leadDropOff = max(leads - opportunities, 0); opportunityDropOff = max(opportunities - customers, 0)
Worked example: basic sales funnel
Visitor to lead rate
(1,200 ÷ 10,000) × 100
12%
Lead to opportunity rate
(240 ÷ 1,200) × 100
20%
Opportunity to customer rate
(48 ÷ 240) × 100
20%
Overall conversion rate
(48 ÷ 10,000) × 100
0.48%
Estimated revenue
48 × $1,500
$72,000
Stage drop-off
10,000 - 1,200; 1,200 - 240; 240 - 48
8,800 visitors, 960 leads, 192 opportunities
Final Result
Overall funnel conversion rate: 0.48%. Estimated revenue: $72,000.
Assumptions
- ✓Each stage is measured over the same time period.
- ✓People move through the funnel in order from visitor to lead to opportunity to customer.
- ✓Average deal value is reasonably consistent across customers.
- ✓The counts entered are unique stage totals rather than duplicated records.
Limitations
- !The calculator does not explain why drop-off happens at any stage.
- !It assumes a simple linear funnel and may not fit multi-touch or non-linear buying journeys.
- !Estimated revenue does not account for refunds, discounts, repeat purchases, or payment timing unless included in the average deal value.
- !Results can be misleading if stage counts come from different date ranges or tracking systems.
Common Mistakes to Avoid
Using visitor, lead, opportunity, and customer counts from different time periods.
Entering cumulative CRM totals instead of totals for one defined reporting period.
Including duplicate leads or opportunities, which inflates stage counts.
Comparing funnels with very different traffic sources without noting quality differences.
Treating estimated revenue as booked profit instead of a simple sales estimate.
Related Formulas
Frequently Asked Questions
How do you calculate sales funnel conversion rate?
For each stage, divide the later stage by the earlier stage and multiply by 100. For overall funnel conversion, divide customers by visitors and multiply by 100.
What is the formula for visitor-to-lead conversion rate?
Visitor-to-lead conversion rate = (Leads ÷ Visitors) × 100.
How is overall funnel conversion different from stage conversion?
Overall funnel conversion measures visitors to customers across the entire funnel, while stage conversion measures movement between two adjacent stages.
Why can overall conversion be low even when closing rate is strong?
A funnel can have a strong opportunity-to-customer rate but still have a low overall rate if too few visitors become leads or too few leads become opportunities.
How do you calculate drop-off in a sales funnel?
Subtract the next stage from the current stage. For example, visitor drop-off = visitors minus leads.
How do you estimate revenue from funnel conversions?
Multiply the number of customers by the average deal value to get an estimated revenue total.
Ready to calculate your result?
Use the calculator to get instant results with your own inputs.