- Most LTV numbers are too high. The common shortcut (average order value x purchase frequency x lifespan) blends your oldest, most loyal customers with today's new ones.
- Calculate LTV by cohort instead: customers acquired in the same month, tracked forward. It shows what a new customer is worth today, not what customers were worth three years ago.
- Measure LTV in contribution, not revenue, and over a fixed window such as 6 or 12 months. A lifetime number nobody can verify is a forecast, not a fact.
- Shopify's cohort report and Klaviyo's predictive CLV are useful starting points. Klaviyo needs at least 500 customers with orders and 180 days of history.
- Use LTV to set how much you can pay for a customer by channel and first product, alongside payback, never on its own.
In this article
The pitch deck says customer LTV is $240. The founder worked it out the standard way: average order value of $60, customers buy two times a year on average, and they stay about two years. $60 x 2 x 2 = $240. With a CAC of $70, that is a ratio better than 3:1, and the plan is to spend more on acquisition.
When we rebuilt the number from cohorts, customers acquired in the last year were on track to spend about $130 in their first two years, not $240. The "average customer" in the formula was really an average of two very different groups: a loyal core who joined three years ago and bought four times a year, and a much larger wave of recent customers acquired through paid social who mostly bought once. The formula was describing the customers the brand used to get, not the ones it was paying for now.
Why the standard LTV formula overstates value
Each input in that formula is an average across all customers ever acquired. Three things go wrong.
- Survivors inflate frequency. Customers who stayed for years buy often and make up a large share of orders. One-time buyers barely register in the frequency average.
- Lifespan is a guess. Young brands do not have enough history to know how long customers stay, so lifespan is usually assumed.
- Gross margin is not contribution. Shipping, fees, discounts and returns can take another 20 points or more off every order.
24-month value per customer for customers acquired in the last year (illustrative)
Measured properly, recent customers did not yet earn back their CAC within two years.
| Label | LTV per customer |
|---|---|
| Formula, revenue | $240 |
| Cohort, revenue | $130 |
| Cohort, contribution | $62 |
The better method: cohort LTV in contribution
Cohort LTV answers a narrower but far more useful question: what is a customer acquired in a given month actually worth after 3, 6 and 12 months? It uses only what customers have really done, so it can be checked, and it shows whether newer customers are better or worse than older ones.
- Export 18 to 24 months of Shopify orders with customer ID, order date, net revenue, discounts and refunds.
- Assign each customer to the month of their first order.
- Convert every order to contribution using your cost per order (product, shipping, fulfilment, fees, returns).
- For each cohort, add up cumulative contribution at months 1, 3, 6 and 12, and divide by the number of customers in the cohort.
- Compare cohorts at the same age. If month-6 value is falling for newer cohorts, acquisition quality is slipping.
| Cohort | Customers | Month 1 | Month 3 | Month 6 | Month 12 |
|---|---|---|---|---|---|
| Q1 last year | 2,900 | $24 | $36 | $47 | $63 |
| Q2 last year | 3,400 | $23 | $34 | $44 | $58 |
| Q3 last year | 4,600 | $22 | $30 | $38 | |
| Q4 last year | 6,100 | $20 | $27 |
Reading down a column shows newer cohorts are worth less at the same age, as acquisition scaled up.
Using Shopify and Klaviyo to get started
You do not need special software to begin. Shopify's customer cohort analysis report groups customers by acquisition month and shows retention over time. Klaviyo's predictive analytics estimate each customer's historic, predicted and total CLV, once an account has at least 500 customers with orders, 180 days of order history with recent orders, and some customers with three or more orders.
Both are revenue-based and neither splits value by acquisition channel or first product. Treat them as a starting point for spotting trends, and build the contribution view yourself for budget decisions.
Cut LTV by channel and first product
A single LTV for the whole brand is almost useless for decisions, because the decision is always about a specific channel, offer or product. Cohort LTV by acquisition channel tells you which channels are worth a higher CAC. LTV by first product, covered in customer value by first product, tells you what your ads should sell. LTV by discount use, covered in welcome discounts, tells you what your offers are doing to customer quality.
Same brand, customers acquired in the same quarter (illustrative)
| Label | 12-month contribution per customer |
|---|---|
| Google Search | $88 |
| Email signup to first order | $79 |
| Meta prospecting | $61 |
| TikTok | $44 |
| Influencer codes | $37 |
How to use LTV without fooling yourself
| Rule | Why |
|---|---|
| Measure in contribution, not revenue | Revenue LTV can be three or four times the profit a customer actually leaves |
| Use a fixed window (6 or 12 months) | A lifetime number nobody can verify becomes whatever the deck needs |
| Compare cohorts at the same age | Older cohorts have had more time to buy |
| Split by channel, offer and first product | That is where the budget decisions actually are |
| Pair it with payback | LTV says whether a customer is worth it; payback says whether you can afford to wait |
A $240 LTV that was really $62
- What the dashboard said
- Formula LTV of $240 against a $70 CAC, a ratio above 3:1. The plan was to raise CAC targets and scale.
- What was actually happening
- Recent cohorts were on track for $130 of revenue over two years, and $62 of contribution. The formula was dominated by a loyal early cohort that bought four times a year.
- Decision
- Stop Stop raising CAC targets on formula LTV. Set targets per channel from 12-month cohort contribution, and fix the lead offer to improve repeat in new cohorts.
If your LTV comes from a formula rather than cohorts, it describes the customers you used to get.
Read next: CAC payback period. A Blindspot Snapshot builds cohort LTV in contribution by channel and first product from your own Shopify data.
Questions founders ask
What is the formula for customer lifetime value in ecommerce?
The common shortcut is average order value x average orders per year x average customer lifespan in years. A more reliable method is cohort LTV: take customers acquired in one month and add up the contribution they generate over a fixed period, such as 12 months, divided by the number of customers.
Does Shopify calculate LTV?
Shopify reports total spend per customer and offers a customer cohort analysis report that tracks retention by acquisition month. It does not give you contribution-based LTV by channel or first product, so most brands export orders to a spreadsheet or use an analytics app for that.
How does Klaviyo predict customer lifetime value?
Klaviyo's predictive analytics estimate each customer's spend over the next year once an account has at least 500 customers who have placed orders, at least 180 days of order history with orders in the last 30 days, and some customers with three or more orders. It shows historic, predicted and total CLV per profile.
What LTV to CAC ratio should a DTC brand aim for?
A ratio of 3:1 is often quoted, but it depends on whether LTV is measured in revenue or contribution and over what period. A 3:1 ratio on 12-month contribution is strong. A 3:1 ratio on lifetime revenue can still lose money. Pair the ratio with payback period.
