Customer Lifetime Value for Ecommerce: How to Calculate It Without Fantasy
Customer lifetime value is useful.
It is also one of the easiest ecommerce metrics to abuse.
The problem is the word:
lifetime.
A brand can take optimistic repeat-purchase assumptions, project them years into the future and justify almost any acquisition cost.
That is not analysis.
It is storytelling with a spreadsheet.
What customer lifetime value actually means
McKinsey describes customer lifetime value as the long-term value a customer contributes across the relationship, used alongside acquisition and retention cost to guide investment. (mckinsey.com)
A simple ecommerce formula is:
average order value × purchase frequency × customer lifespan
But I would prefer:
contribution per order × purchase frequency × observed customer lifespan
where possible.
Revenue is not profit.
Historical value vs predicted value
Historical
What the customer actually contributed.
Predicted
What we expect them to contribute later.
Keep those separate.
Use cohorts
Instead of one global lifetime value:
January 2025 cohort:
90-day contribution = $70
180-day = $105
365-day = $160.
Now the value is tied to observed behaviour.
This is much more useful.
Common Thread’s near-term approach is strong
Common Thread Collective argues that brands should focus on 60- to 120-day “cash multiplier” windows rather than waiting for vague lifetime value. (commonthreadco.com)
I like that because it answers:
How much cash does this cohort generate soon enough to fund growth?
Frequently asked questions
What is a good customer lifetime value?
There is no universal dollar value. Compare against acquisition cost, contribution margin and category.
What is a good lifetime-value-to-acquisition-cost ratio?
The commonly quoted 3:1 benchmark can be a useful rule of thumb, but it should not replace payback and cash-flow analysis. Shopify currently cites 3:1 as a widely used benchmark. (shopify.com)
How do I increase customer lifetime value?
Increase:
- repeat purchase,
- purchase frequency,
- contribution per order,
- customer lifespan.
The principle
Do not use customer lifetime value to explain away bad first-order economics.
Use it to understand how customer value actually develops.