Lifetime value gets quoted in every pitch deck and used in roughly zero operating decisions. Here's the version that actually moves the business — and the four ways it gets calculated wrong.
Lifetime value shows up in every ecommerce pitch deck and almost zero operating decisions. The founder quotes it on a board call. Marketing quotes it in CAC justification slides. Nobody on the team can tell you what changed last week to move it — because most "LTV figures" don't update faster than quarterly, and most aren't calculated correctly in the first place.
This piece is the version of LTV that actually matters for a sub-£10M / AUD $15M ecommerce business: how to calculate it honestly, four common mistakes that inflate it, and the three operating decisions it should drive.
The short answer
Lifetime value (LTV, sometimes CLV — customer lifetime value) is the total gross profit a customer generates over the time they keep buying from you. Not revenue. Gross profit. Industry-shortened versions usually mean one of three things:
- Average order value × purchase frequency × customer lifespan — the textbook formula. Almost never used in real ecommerce.
- Average revenue per cohort over 12 months — the practical version. Most useful for active operating decisions.
- Predicted future revenue per customer — the modelled version. Used by larger businesses with enough data to fit a curve.
For most ecommerce businesses under £10M revenue, the second version — actual revenue per cohort over a defined window — is the only one that drives real decisions. The textbook formula uses too many estimates. The predictive version needs more data than you have.
The four ways LTV gets calculated wrong
Mistake 1 · Using revenue, not gross profit
If your gross margin is 55%, a customer that produces £400 of revenue produces £220 of gross profit. Comparing £400 against an £80 CAC looks like 5:1 — comparing £220 against £80 is 2.75:1, which is the real ratio. Revenue-LTV vs Cost is a vanity metric.
Mistake 2 · Including refunds, but not return-shipping cost
Even careful operators net out refunded orders. Fewer net out the cost of shipping the return, restocking it, or writing it off. Categories with 15%+ return rates (apparel especially) need this. The LTV haircut from honest return handling is usually 8–15%.
Mistake 3 · Lifespan = "until we stop hearing from them"
Most stores assume a 24- or 36-month "average lifespan" pulled from someone's blog post. The honest lifespan for the median DTC customer is closer to 14 months — and 60–70% of total LTV is generated in the first 6 months. Inflating the lifespan assumption inflates the LTV.
Mistake 4 · Blending paid acquisition with organic
Customers from paid social have different LTV than customers from organic search. Different intent, different match quality, different cohort behaviour. A blended LTV number obscures whether your paid channels are profitable — they might look profitable in aggregate while specific cohorts are loss-making.
Illustrative DTC cohort. Same blended LTV (£226) hides 3.6× difference between channels.
The version that actually matters: cohort LTV by acquisition channel
For operational decisions, the LTV calculation that matters is:
- Group customers by month of first purchase AND acquisition channel.
- Track total gross profit per customer over a fixed window (6, 12, or 24 months).
- Compare against fully-loaded CAC for that channel in that month.
This needs roughly 6 months of clean data and a willingness to wait — you don't get to know the 12-month LTV of customers acquired this week until next year. What you can do is project: cohorts from earlier months act as a leading indicator of newer ones.
The three operating decisions LTV should drive
1 · Channel budget allocation
If paid social customers have 6-month LTV of £180 and paid display customers have 6-month LTV of £95, and CAC is similar — every additional pound should go to paid social until the channel saturates. The blended-LTV view misses this.
2 · Customer-acquisition payback period
Two scenarios:
| Cohort | CAC | 3-month gross profit | Payback | Action |
|---|---|---|---|---|
| Paid social, Q1 | £62 | £74 | ~2.5 months | Scale spend |
| Paid social, Q2 | £89 | £71 | ~3.8 months | Tighten targeting |
| Display, Q1 | £55 | £32 | ~5+ months | Wind down |
| Email referrals | £0 | £44 | Instant | Invest in lifecycle |
Cash-constrained businesses care about payback period more than absolute LTV. Investors care about both.
3 · Retention investment threshold
If a £20/month loyalty program generates £140 of incremental gross profit per active member per year, it's worth running. If the same program generates £40, it's not. You can't make that call without segmented LTV data — by tier, by category, by acquisition source.
How to actually compute LTV (Shopify + Klaviyo)
You don't need an analytics platform. You need a spreadsheet and 90 minutes:
- Export Shopify orders for the last 13 months (one extra month for a complete 12-month window).
- Group by
customer_id,first_purchase_month,acquisition_source(from UTM or post-purchase survey). - Subtract refunds + estimated return cost. Multiply by gross margin (or pull COGS from your inventory system).
- Sum gross profit per customer over months 1, 3, 6, 12.
- Pivot by month + source. You'll see the cohort × channel grid in the figure above.
If the cohort sizes are too small for any channel to read cleanly, expand to quarters instead of months. The shape is the same.
What LTV doesn't change
Three common LTV-driven decisions that are usually wrong:
- "Our LTV is high so we can afford a higher CAC." Maybe. But "afford" depends on cash flow + payback, not just the ratio. A 4:1 LTV:CAC with a 14-month payback period is dangerous if you're cash-constrained.
- "Our LTV is growing so retention is working." LTV grows mechanically when older cohorts have more time. The right comparison is same-age LTV: month 6 of this year's Q1 cohort vs month 6 of last year's Q1 cohort.
- "We need to increase AOV to lift LTV." Higher AOV often comes from one-off promotional bundling that reduces repeat purchases. Net LTV doesn't move — sometimes it falls.
What to read next
- Customer retention strategy: start with the audit, not the tactics
- Customer lifecycle: the five points where small ecommerce businesses leak revenue
- Ecommerce growth: the three numbers that say whether growth is real or rented
Frequently asked questions
What's a good LTV to CAC ratio for ecommerce?
3:1 is the venture-backed benchmark — for every £1 of CAC, £3 of gross profit over the lifetime. For bootstrapped businesses, 2:1 is workable if payback is under 6 months. Anything under 1.5:1 means the unit economics don't support paid acquisition at scale.
How do you calculate LTV for a subscription business?
Subscription LTV is simpler — monthly recurring revenue × gross margin × average customer lifespan in months, minus support cost. The complexity is estimating lifespan; either pull it from churn data (1/monthly churn rate = average lifespan in months) or use cohort survival analysis if you have 12+ months of data.
Should I use predicted LTV or actual LTV?
Actual cohort LTV for operating decisions. Predicted LTV for forecasting (board reports, fundraising). They're different tools for different audiences. Predicted LTV needs at least 12 months of history to fit reliable curves; without that, predictions diverge badly from reality.
Why is my LTV dropping?
Almost always one of: (1) acquisition mix shifted to lower-quality channels, (2) first-to-second purchase rate dropped, (3) average order value fell because of more discounting. Run cohort-by-cohort. The drop will be concentrated in one bucket.
What's a realistic LTV for a small DTC brand?
Highly category-dependent. Skincare/beauty: 12-month LTV of £140–£260 gross profit per customer. Supplements: £180–£320 (higher repeat). Apparel: £80–£160 (lower repeat). Food/beverage subscriptions: £200–£400 (frequency carries it). These are working ranges — outliers exist in both directions.
How Qwrki fits
Qwrki runs analytics as part of the operating layer — the cohort LTV calculation above runs in your live dashboard, refreshed weekly, segmented by channel and product line. We don't ship LTV quarterly in a PDF — we ship the number live, the same one you'd use to decide what to spend next week.
Book a call — first hour we run a cohort export and tell you what your actual blended-vs-segmented LTV looks like.
You may also like
- retention
SMS marketing: the channel that punishes laziness fastest.
SMS marketing for ecommerce done properly: Australian consent rules, the sends that earn the channel, frequency limits and how SMS pairs with email.
4 min - retention
Win-back campaigns: when a lapsed customer is worth chasing.
How to run a win-back email campaign properly: calculate your real lapse point, segment lapsed customers by value, run a short sequence and know when to stop.
4 min