Funnel Conversion Breakdown
Use visitors, visitor to lead (%), lead to customer (%) to prepare the funnel conversion breakdown record. The worksheet applies the displayed arithmetic to your supplied values; it does not retrieve account data.
Use visitors, visitor to lead (%), lead to customer (%) to prepare the funnel conversion breakdown record. The worksheet applies the displayed arithmetic to your supplied values; it does not retrieve account data.
Turning the revenue target into a measurable sales workload
This worksheet calculates the displayed relationship from the supplied quantities. Its label and period conventions determine how the amount should be interpreted. Pipeline planning joins deal value, conversion and time. The model should use opportunities that meet a defined qualification stage, rather than every contact in the CRM. Deal concentration matters when a few large accounts dominate an average.
Scope of this operation
The figure includes only the listed inputs. It does not add unlisted tax, overhead, provider charges or conversion losses. Negative results can represent a shortfall or the signed difference between options. The example output for funnel conversion breakdown is shown below so the supplied source can be checked against the actual format. It is not evidence that the operation has run against your own file or account.
How it works
Expected customers = [Visitors] × [Visitor to lead (%)] ÷ 100 × [Lead to customer (%)] ÷ 100
Inputs
| Field | Example | Definition |
|---|---|---|
| Visitors | 10000 | Use the source quantity represented by visitors. Keep the counted population fixed and avoid mixing a unit value with a period total. |
| Visitor to lead (%) | 3 | Enter visitor to lead (%) on the percentage scale used in the formula (20 means 20%, not 0.20). Keep its base and reporting period consistent with the other inputs. |
| Lead to customer (%) | 10 | Enter lead to customer (%) on the percentage scale used in the formula (20 means 20%, not 0.20). Keep its base and reporting period consistent with the other inputs. |
Step-by-step guide
Prepare the source
Supply Visitors, Visitor to lead (%), Lead to customer (%). Keep the original material so the output can be compared with it.
Build output
Check Visitors, Visitor to lead (%), then select Generate output.
Use the result
Compare the funnel conversion breakdown result with the unchanged source before copying or downloading it.
When to use it
Expected customers = [Visitors] × [Visitor to lead (%)] ÷ 100 × [Lead to customer (%)] ÷ 100 The figure includes only the listed inputs. It does not add unlisted tax, overhead, provider charges or conversion losses. Negative results can represent a shortfall or the signed difference between options.
Example and scope
Example inputs: Visitors: 10000; Visitor to lead (%): 3; Lead to customer (%): 10.
The figure includes only the listed inputs. It does not add unlisted tax, overhead, provider charges or conversion losses. Negative results can represent a shortfall or the signed difference between options.
Worked output
Expected customers: 30 Assumptions: visitors: 10000 lead_rate: 3 close_rate: 10
Related tool family
This focused tool is associated with Lead to Opportunity Conversion Calculator. Use it when you need to isolate a specific part of that wider workflow.
Several parent models may support the same step. Keep the business question visible and choose the version that best matches the process you actually need to manage.
Related parent models
Lead to Opportunity Conversion Calculator, Opportunity Win Rate Calculator, Average Deal Size Calculator, Sales Cycle Calculator, Revenue per Sales Rep Calculator, Sales Capacity Calculator
Keep the displayed formula, input units and model scope with the result. Corrections or questions can be sent through the request section on this page.
Content updated: October 11, 2026