A DTC brand spending $40 per acquisition has no idea whether that's profitable — because they've never calculated what a customer is actually worth. The customer lifetime value formula answers this in one number: the total revenue (or profit) you'll earn from an average customer over your entire relationship. Three formulas exist, each with different data requirements and accuracy levels. Here's how to calculate CLV using each one, with worked examples you can follow with your own data.
Why CLV Is the Most Important Number You're Not Tracking
Every growth decision bottlenecks on a single question: how much can we spend to acquire a customer? Without CLV, the answer is a guess. With CLV, it's arithmetic. If your average customer is worth $340 over their lifetime, you can spend up to $113 on acquisition (at a 3:1 ratio) and remain profitable. If CLV is $80, that same $113 acquisition cost means you're burning cash on every customer.
CLV also exposes which customer segments deserve investment and which are quietly draining resources. A Shopify store might discover that customers acquired through Instagram have a CLV of $210 while Google Shopping customers average $85. Same product, same price — radically different lifetime economics. Without customer lifetime value analysis, you'd treat them identically.
The metric goes by multiple abbreviations — CLV, LTV, and CLTV all refer to the same thing. The formulas below work regardless of which label your team uses.
The Simple CLV Formula
The simplest customer lifetime value formula requires three numbers you can pull from any order export:
CLV = Average Order Value × Purchase Frequency × Average Customer LifespanAverage Order Value (AOV) is total revenue divided by total orders. Purchase Frequency is total orders divided by unique customers over a period (typically 12 months). Average Customer Lifespan is how long a customer remains active, measured in the same time unit as purchase frequency.
Worked Example: E-commerce Store
A Shopify store has $480,000 in revenue from 8,000 orders placed by 3,200 unique customers over the past year. Average customer lifespan (from first to last purchase analysis) is 2.4 years.
AOV = $480,000 ÷ 8,000 = $60
Purchase Frequency = 8,000 ÷ 3,200 = 2.5 per year
Customer Lifespan = 2.4 years
CLV = $60 × 2.5 × 2.4 = $360Each customer is worth $360 on average over their lifetime. If acquisition cost (CAC) is $90, the CLV:CAC ratio is 4:1 — a healthy margin.
When to Use the Simple Formula
Use this formula for quick back-of-envelope calculations, board presentations, and setting acquisition budget ceilings. It's accurate enough for strategic decisions but doesn't account for discount rates, varying purchase patterns, or the probability that a customer has permanently churned versus being temporarily inactive.
The Historical CLV Formula
The historical CLV formula calculates the actual value of each customer based on past transactions — no predictions, no averages, just what each customer has spent to date.
Historical CLV = Σ (Transaction Value × Gross Margin) for all transactions by customerIf you want profit-based CLV rather than revenue-based, multiply each transaction by your gross margin percentage. For revenue-based CLV, simply sum all transaction values.
Worked Example: SaaS Company
A SaaS company tracks three customer segments by actual spend:
| Segment | Avg Monthly Spend | Avg Tenure (months) | Historical CLV |
|---|---|---|---|
| Starter | $29 | 4.2 | $122 |
| Professional | $99 | 14.8 | $1,465 |
| Enterprise | $499 | 28.3 | $14,122 |
This reveals that Enterprise customers are worth 115x more than Starter customers — not 17x more (which is what the monthly price ratio would suggest). The lifespan difference amplifies the gap dramatically. If your acquisition cost is the same for both segments, this data should radically shift your sales and marketing strategy.
The Predictive CLV Formula (BG/NBD Model)
The simple and historical formulas look backward. The predictive customer lifetime value formula looks forward: how much will this customer spend in the future? This is where statistical modeling enters the picture.
The BG/NBD (Beta-Geometric/Negative Binomial Distribution) model is the gold standard for predictive CLV in non-contractual settings — businesses where customers can purchase at any time without a subscription (e-commerce, retail, marketplaces). It estimates two things simultaneously:
1. Is this customer still "alive"? A customer who bought 5 times in their first month then nothing for 6 months has probably churned. A customer who buys once per quarter and last bought 2 months ago is likely still active. The model calculates a probability of being alive for each customer.
2. How many future purchases will they make? Given their historical pattern (recency, frequency), the model predicts expected transactions over a chosen horizon (30 days, 90 days, 12 months).
Combined with a Gamma-Gamma model for monetary value prediction, this produces a dollar-denominated CLV estimate per customer. The inputs are minimal — you only need three columns from your orders data:
Required columns:
- Customer ID
- Transaction Date
- Transaction AmountFrom these three columns, the model derives recency (time since last purchase), frequency (number of repeat purchases), and monetary value (average transaction amount) — the RFM variables that drive the prediction.
Worked Example: E-commerce Store with Repeat Buyers
An online store uploads 18 months of order data (14,200 orders, 4,800 customers). The BG/NBD + Gamma-Gamma model produces:
| Segment | Customers | P(Alive) | Predicted 12mo CLV |
|---|---|---|---|
| Champions | 380 | 94% | $842 |
| Loyal | 720 | 78% | $395 |
| At Risk | 1,100 | 42% | $118 |
| Lost | 2,600 | 8% | $14 |
The 380 Champions represent 8% of customers but 42% of predicted future revenue. The 2,600 Lost customers are effectively gone — spending retention budget on them would be wasted. The 1,100 At-Risk customers are the intervention opportunity: they have purchase history but are drifting away.
This is the level of insight that separates the simple CLV formula from the predictive one. The simple formula tells you the average customer is worth $360. The predictive model tells you which customers are worth $842 and which are worth $14.
CLV vs CAC: The Ratio That Determines Profitability
Customer lifetime value only becomes actionable when paired with Customer Acquisition Cost (CAC). The CLV:CAC ratio is the single most important health metric for any customer-driven business.
CLV:CAC Ratio = Customer Lifetime Value ÷ Customer Acquisition Cost| Ratio | What It Means | Action |
|---|---|---|
| < 1:1 | Losing money on every customer | Fix urgently — cut CAC or increase LTV |
| 1:1 to 3:1 | Marginally profitable but fragile | Improve retention or raise prices |
| 3:1 to 5:1 | Healthy — the benchmark range | Maintain and scale confidently |
| > 5:1 | Underinvesting in growth | Increase acquisition spend |
Calculate this ratio per acquisition channel, not just as a company average. Your email list might have a 6:1 ratio while paid social runs at 1.5:1. Channel-level CLV:CAC analysis tells you exactly where to shift budget for maximum return.
Common CLV Calculation Mistakes
Using revenue instead of gross profit. A $100 order with 30% margins is worth $30 in CLV, not $100. Revenue-based CLV overstates actual value and leads to overspending on acquisition. Use gross margin for profit-based CLV whenever possible.
Ignoring the discount rate. $100 received today is worth more than $100 received in three years. For accurate CLV, apply a discount rate (typically 10-15% annually) to future cash flows. This matters most for long-lifespan businesses like SaaS or financial services.
Averaging across all customers. CLV follows a power law — a small percentage of customers generate most of the value. Company-wide averages hide this distribution. Always calculate CLV by segment: acquisition channel, product category, customer tier, or cohort.
Confusing alive and dead customers. A customer who bought once 18 months ago probably isn't coming back. Including them in "average lifespan" calculations inflates the number. The BG/NBD model handles this automatically by estimating probability of being alive, but the simple formula can't distinguish.
Not recalculating regularly. CLV changes as your product, pricing, and customer mix evolve. A formula calculated last year with different pricing is stale. Recalculate quarterly at minimum, or monthly for subscription businesses.
Which CLV Formula Should You Use?
| Formula | Best For | Data Needed | Accuracy |
|---|---|---|---|
| Simple | Quick estimates, board decks | AOV, frequency, lifespan | Low |
| Historical | Backward-looking segment analysis | Full transaction history | Medium (past only) |
| Predictive (BG/NBD) | Future value, individual targeting | Customer ID, date, amount | High |
Start with the simple formula if you've never calculated CLV. It takes 5 minutes and gives you a useful baseline. Move to historical CLV when you want segment-level analysis. Graduate to predictive CLV when you need per-customer scores for targeting, retention, and budget allocation. MCP Analytics runs the full BG/NBD + Gamma-Gamma predictive model from a simple CSV upload — no statistical knowledge required.
Calculate Your Customer Lifetime Value
Upload your orders CSV (customer ID, date, amount) and get predictive CLV per customer with segment breakdowns. Takes under 2 minutes.
Calculate CLV FreeFrequently Asked Questions
What is the simplest customer lifetime value formula?
The simplest CLV formula is: CLV = Average Order Value x Purchase Frequency x Average Customer Lifespan. For example, if a customer spends $50 per order, buys 4 times per year, and stays for 3 years: CLV = $50 x 4 x 3 = $600. This gives a quick estimate but doesn't account for discount rates or varying purchase patterns.
What is the difference between CLV and LTV?
CLV (Customer Lifetime Value) and LTV (Lifetime Value) are the same metric — different abbreviations used interchangeably. Some companies use CLTV as a third abbreviation. All refer to the total revenue or profit a business expects from a single customer over their entire relationship.
How do I calculate CLV for a subscription business?
For subscription businesses, CLV = Average Monthly Revenue per Customer / Monthly Churn Rate. If your average subscriber pays $49/month and your monthly churn rate is 5%: CLV = $49 / 0.05 = $980. To account for the time value of money, use: CLV = ARPU / (Churn Rate + Discount Rate).
What is a good CLV to CAC ratio?
A CLV:CAC ratio of 3:1 is the benchmark for healthy businesses — each customer generates 3x what it costs to acquire them. Ratios below 1:1 mean you're losing money on every customer. Ratios above 5:1 suggest you may be underinvesting in growth.
How often should I recalculate customer lifetime value?
Recalculate CLV quarterly for most businesses. Subscription businesses with monthly billing should review monthly. Recalculate immediately after major pricing changes, new product launches, or shifts in customer acquisition channels, as these events change the underlying purchase patterns that drive CLV.