Sales Funnel Customer Value Formula
Learn how to calculate customer value, funnel revenue, visitor value, lead value, and customer acquisition cost from sales funnel inputs.
This formula page explains how a sales funnel customer value estimate is built from traffic, conversion rates, order value, repeat purchases, and marketing spend. Understanding the math helps you judge how changes in conversion or customer behavior affect revenue per visitor, per lead, and per customer.
- 100% Free
- No Sign-Up Required
- Private & Secure
- Mobile Friendly
Customer Value
Where:
Start with the first purchase value, then add the expected revenue from repeat purchases to estimate the total value of one average customer.
Variables Explained
| Variable | What It Means | Unit |
|---|---|---|
| V - Monthly visitors | The number of visitors entering the funnel during the month. | number |
| LCR - Visitor to lead conversion rate | The percentage of visitors who become leads. | percent |
| CCR - Lead to customer conversion rate | The percentage of leads who become paying customers. | percent |
| AOV - Average order value | The average value of the first purchase. | currency |
| RP - Average repeat purchases | The average number of additional purchases each customer makes after the first order. | number |
| RPV - Repeat purchase value | The average revenue from each repeat purchase. | currency |
| MS - Monthly marketing spend | The amount spent to generate traffic and leads for the same period. | currency |
| CV - Customer value | The estimated total revenue from one average customer. | currency |
Step-by-Step Calculation
Estimate monthly leads
Convert the visitor-to-lead percentage into a decimal and multiply it by monthly visitors to estimate how many leads enter the next stage.
monthlyLeads = monthlyVisitors * (leadConversionRate / 100)
Estimate monthly customers
Take the estimated leads and apply the lead-to-customer conversion rate to estimate paying customers.
monthlyCustomers = monthlyLeads * (customerConversionRate / 100)
Calculate customer value
Add first-order revenue to expected repeat-purchase revenue to get the average revenue per customer.
customerValue = averageOrderValue + (averageRepeatPurchases * repeatPurchaseValue)
Calculate monthly revenue
Multiply the number of customers by average customer value to estimate total funnel revenue.
monthlyRevenue = monthlyCustomers * customerValue
Calculate visitor and lead value
Divide total revenue by visitors or leads to estimate what each visitor and each lead is worth on average.
visitorValue = monthlyRevenue / max(monthlyVisitors, 1); leadValue = monthlyRevenue / max(monthlyLeads, 1)
Calculate customer acquisition cost and return ratio
Compare marketing spend against customer volume and revenue to estimate average acquisition cost and revenue returned per unit of spend.
customerAcquisitionCost = monthlyMarketingSpend / max(monthlyCustomers, 1); marketingReturnRatio = monthlyRevenue / max(monthlyMarketingSpend, 1)
Worked example: small online store funnel
Monthly leads
10,000 × 0.12
1,200 leads
Monthly customers
1,200 × 0.18
216 customers
Customer value
120 + (2 × 90)
$300
Monthly revenue
216 × 300
$64,800
Visitor value
64,800 ÷ 10,000
$6.48 per visitor
Lead value and CAC
64,800 ÷ 1,200; 3,000 ÷ 216
$54.00 per lead; $13.89 CAC
Final Result
Estimated customer value is $300, estimated monthly revenue is $64,800, visitor value is $6.48, lead value is $54.00, and customer acquisition cost is $13.89 per customer.
Assumptions
- ✓Conversion rates are averages for the period being analyzed.
- ✓Visitors are assumed to be broadly similar in quality across the month.
- ✓Repeat purchases are treated as an average customer-level expectation, even if they happen later.
- ✓Marketing spend is assumed to support the same traffic and conversions used in the estimate.
- ✓Revenue is treated before refunds, fees, taxes, and operating costs unless you adjust the inputs manually.
Limitations
- !The calculator estimates revenue, not profit or cash flow timing.
- !Real funnels often have multiple traffic sources with different conversion rates.
- !Repeat purchase behavior may vary by customer segment and time horizon.
- !Seasonality, attribution gaps, and offline sales can make actual results different from the estimate.
- !Using averages can hide large differences between high-value and low-value customers.
Common Mistakes to Avoid
Entering conversion rates as decimals instead of percentages, such as 0.12 instead of 12.
Using total customer lifetime revenue as average order value and then adding repeat purchases again.
Mixing monthly traffic data with quarterly or annual repeat-purchase assumptions.
Including marketing spend that did not contribute to the funnel traffic being measured.
Comparing customer acquisition cost to customer value without considering refunds or non-marketing costs.
Related Formulas
Frequently Asked Questions
What is the core customer value formula?
The core formula is average order value plus average repeat purchases multiplied by repeat purchase value.
How do you calculate monthly leads in a sales funnel?
Multiply monthly visitors by the visitor-to-lead conversion rate divided by 100.
How do you calculate monthly customers from leads?
Multiply monthly leads by the lead-to-customer conversion rate divided by 100.
How is visitor value calculated?
Visitor value is monthly revenue divided by monthly visitors.
How is lead value calculated?
Lead value is monthly revenue divided by monthly leads.
How do you calculate customer acquisition cost in this calculator?
Customer acquisition cost is monthly marketing spend divided by monthly customers.
Ready to calculate your result?
Use the calculator to get instant results with your own inputs.