How it works
Leads = visits × lead conversion; sales = leads × sales conversion. Revenue = modeled sales × average sale; CAC = spend / sales.
Input definitions
- Site visits
- Enter the value in the labeled unit.
- Visit-to-lead conversion (%)
- Enter the value in the labeled unit.
- Lead-to-sale conversion (%)
- Enter the value in the labeled unit.
- Average sale revenue
- Enter the value in the labeled unit.
- Campaign spend
- Enter the value in the labeled unit.
A worked example
- Site visits
- 10000
- Visit-to-lead conversion (%)
- 5
- Lead-to-sale conversion (%)
- 10
- Average sale revenue
- 100
- Campaign spend
- 1000
Assumptions & limits
Planning model using entered costs and policies, not country-specific law or a forecast. Use one currency and consistent time periods.
Sources & review
Maintained by AnsRio. Methods and examples use automated checks; this does not imply independent professional certification.
Method updated 2026-10-17. Content checked against the stated method and examples. Our verification approach.
Common questions
Why can a funnel estimate show a fractional sale?
It models an expected value across many visits, not a count of completed transactions. Fractional expectations are retained so rounding early does not distort the revenue calculation.
How does Marketing funnel conversion worksheet work?
Leads = visits × lead conversion; sales = leads × sales conversion. Revenue = modeled sales × average sale; CAC = spend / sales.
What are the limits of Marketing funnel conversion worksheet?
Planning model using entered costs and policies, not country-specific law or a forecast. Use one currency and consistent time periods.