Customer lifetime value (LTV) is the total value a customer generates for your store after their first purchase. A cohort is a group of customers who placed their first order in the same period, usually the same month. Put together, cohort LTV answers a very practical question: how much is a customer acquired in January actually worth after one, three or six months? That number is what decides how much you can afford to pay Meta, TikTok or Google to acquire the next one.
Why a single LTV number misleads
The textbook formula multiplies three averages:
LTV = average order value × purchases per year × years as a customer
It is fine for a back-of-the-envelope estimate, but it has four problems for a Shopify store that buys traffic every day. The lifespan is a guess. The averages blend your oldest, most loyal customers with the ones you acquired last week with a 30% discount. It hides changes over time: if the customers you acquire now repeat less than the ones from a year ago, a single average will take months to show it. And it is usually calculated on revenue, which says nothing about how much money is left after the product, the shipping and the fees.
Cohorts fix the first three problems by only comparing customers who started at the same time, and measuring what they actually did month by month, with no assumptions about the future. The fourth problem you fix by measuring gross profit instead of revenue.
What a cohort table is
Each row is a cohort (the customers whose first order was in that month). Each column is the age of the cohort: month 0 is the month of the first order, month 1 is the following month, and so on. Each cell shows the cumulative value per customer up to that age. The table is a triangle because recent cohorts have not lived long enough to fill the later columns.
| Cohort | New customers | Month 0 | Month 1 | Month 2 | Month 3 |
|---|---|---|---|---|---|
| January | 200 | €50 | €60 | €67 | €72 |
| February | 250 | €48 | €56 | €62 | – |
| March | 300 | €45 | €51 | – | – |
| April | 280 | €52 | – | – | – |
Reading rows and columns
- Read along a row to see how one cohort matures: January customers were worth €50 each after the first month and €72 after month 3.
- Read down a column to compare cohorts at the same age: at month 1, January is at €60, February at €56 and March at €51. Each new cohort is repeating a little less.
- Never compare across the diagonal: April's €52 at month 0 is not 'worse' than January's €72; it is just younger.
- A falling column is a question, not an answer. In this example, March might have been acquired with heavier discounts or a different product. The table tells you where to look.
Revenue LTV vs gross-profit LTV
Revenue LTV is the number most dashboards show, and it is the one that gets stores into trouble, because you do not pay for ads with revenue. You pay for them with what is left after the cost of the product, shipping, payment fees and refunds. That is gross-profit LTV (some teams call it contribution LTV).
Revenue LTV (month N) = cumulative net revenue of the cohort up to month N / customers in the cohort Gross-profit LTV (month N) = cumulative (net revenue − COGS − shipping − payment fees) up to month N / customers in the cohort
Use revenue excluding VAT and net of refunds in both. VAT is not yours, and a refunded order is not a sale.
Worked example: the January cohort
Take the January cohort from the table: 200 new customers. To acquire them, the store spent €6,000 on ads that month, so CAC is €30. After COGS, shipping and payment fees, the store keeps 40% of each euro of net revenue. Here is the cohort month by month:
| Month | Revenue in the month | Cumulative revenue | Revenue LTV per customer | Gross-profit LTV per customer |
|---|---|---|---|---|
| 0 | €10,000 | €10,000 | €50.00 | €20.00 |
| 1 | €2,000 | €12,000 | €60.00 | €24.00 |
| 2 | €1,400 | €13,400 | €67.00 | €26.80 |
| 3 | €1,000 | €14,400 | €72.00 | €28.80 |
| 4 | €800 | €15,200 | €76.00 | €30.40 |
| 5 | €600 | €15,800 | €79.00 | €31.60 |
CAC = €6,000 / 200 customers = €30 Revenue LTV at month 5 = €15,800 / 200 = €79.00 Gross-profit LTV at month 5 = €79.00 × 0.40 = €31.60
Revenue per customer more than covers the €30 CAC from day one. Gross profit per customer only catches up in month 4.
Payback period: when a customer has paid back their CAC
CAC payback is the first month in which cumulative gross-profit LTV is equal to or greater than CAC. In the January cohort, gross-profit LTV is €28.80 at month 3 (below €30) and €30.40 at month 4 (above €30). Payback happens in month 4, counting the month of the first order as month 0.
Payback is also a cash question. Until month 4, you have fronted €30 per customer and recovered less than that. The faster you scale acquisition, the more cash you have tied up in customers who have not paid back yet, even if the cohort is profitable in the end.
LTV:CAC, and why the denominator is not the problem
Revenue LTV:CAC at month 5 = €79.00 / €30 = 2.63 Gross-profit LTV:CAC at month 5 = €31.60 / €30 = 1.05
The same customers, the same CAC, and two ratios that tell opposite stories. A 2.63 looks healthy; a 1.05 means that after five months each customer has returned €1.60 above what it cost to acquire them, before rent, salaries, apps or any other fixed cost. A ratio of 3:1 is an often-quoted rule of thumb, but it is a heuristic, not a law, and it only makes sense on gross profit and over a stated horizon (LTV:CAC at 6 months, at 12 months). Do not extrapolate beyond the months you have actually observed: month 6 and later may add more, or almost nothing.
Turning cohorts into a maximum CAC
The most useful thing a cohort table gives you is a ceiling for acquisition cost. Decide how long you are willing to wait for payback, which mostly depends on your cash, and read the gross-profit LTV at that age:
Maximum CAC (3-month payback) = gross-profit LTV at month 3 = €28.80 Current CAC = €30.00 → €1.20 above the ceiling
There are three ways to get back under the line. Lower CAC (creative, targeting, offer). Raise first-order value with bundles or thresholds, which lifts month 0, the biggest cell. Or improve margin: if the store moved from 40% to 45% gross margin, gross-profit LTV at month 3 would be €72.00 × 0.45 = €32.40, and the same €30 CAC would pay back within the target. Retention flows (post-purchase email, replenishment reminders) work on the later columns, which are smaller and slower to move.
Common mistakes when building cohorts
- Including VAT or shipping charged to the customer in revenue, which inflates LTV by the tax rate.
- Not subtracting refunds and cancellations, or subtracting them in the month they were processed instead of against the cohort.
- Dividing by orders instead of customers. LTV is per customer; a customer with three orders counts once.
- Computing CAC with all ad spend, including retargeting of existing customers, and calling it new-customer CAC. Blended CAC (total ad spend / new customers) is a valid simplification, but say so.
- Mixing very different acquisition sources in one cohort. If a big influencer or discount campaign brought in a month's customers, look at that cohort separately.
- Judging a cohort before it is old enough to show repeat behaviour, especially for products customers rebuy every few months.
How to build a cohort table from Shopify
- Export orders with customer ID, order date, net revenue excluding tax and refunds per order.
- For each customer, find the date of their first order. That month is their cohort.
- For every order, compute its age: months between the order and the customer's first order.
- Sum net revenue by cohort and age, then make it cumulative along each row.
- Divide each cell by the number of customers in the cohort.
- Multiply by your gross margin, or better, subtract the actual COGS, shipping and fees of each order, to get gross-profit LTV.
Shopify's analytics includes cohort-style views of returning customers and sales, but they are built on sales, not on what is left after product cost and shipping. That last step is where most of the insight lives. ProfitFly builds the same cohorts on gross profit using the product costs you have already entered, so the table reads in euros you actually keep.
Frequently asked questions
What is a good LTV:CAC ratio for a Shopify store?
There is no universal number. 3:1 is a commonly cited rule of thumb, but it only means something when LTV is measured on gross profit and over a stated horizon, such as 6 or 12 months. Your fixed costs and cash position matter more than any benchmark.
Should LTV include the first order?
Yes. Cohort LTV starts at month 0 with the first order, because that order is part of what the acquisition paid for. Excluding it would make payback look much slower than it is.
How many months of data do I need?
Enough to cover the repeat cycle of your product. For consumables you might see the shape in three to six months; for products bought once or twice a year you need longer before drawing conclusions.
What is the difference between payback period and LTV?
LTV is how much a customer is worth by a given age. Payback is the age at which their cumulative gross profit first reaches CAC. A cohort can have a good LTV and a slow payback, which is a cash-flow problem rather than a profitability one.