The Ecomm Analyst

Growing stores, one honest take at a time.

Reading LTV and cohort curves without fooling yourself

Cohort curves are one of the most seductive charts in e-commerce analytics, and one of the easiest to over-read. At small scale especially, people pull a cohort report, see a line bending nicely upward, and build a CAC ceiling on top of it that the data cannot actually support. Here is how I try to read these without fooling myself.

What a cohort curve actually shows

A cohort curve groups customers by when they first bought, usually by month, then tracks cumulative revenue per customer as each group ages. The January cohort, the February cohort, and so on, each followed across the months since acquisition. Done right it shows you how much a customer is worth over time and how quickly that value accumulates. Done carelessly it shows you mostly noise dressed up as insight.

Small samples lie

The first problem at small scale is sample size. A cohort of eighty customers can be dominated by two or three big spenders, and average revenue per customer will swing wildly month to month for reasons that have nothing to do with your marketing or product. Look at the median alongside the mean, or a trimmed average that drops the extremes, before you trust any per-customer number. If the mean sits far above the median, a handful of whales are running your chart and the average is not describing a typical customer at all.

Do not compare cohorts of different ages

The second trap is comparing a mature cohort to a young one on absolute value. Of course your cohort from a year ago has higher cumulative revenue per customer than the one from last month, it has had a year to make repeat purchases while the new one has had a few weeks. That is not a decline in customer quality, it is just truncation. Compare cohorts at the same age, January at month three against June at month three, or you will invent trends that are pure artifacts of the calendar.

Read the shape, not just the headline number

The most useful information in a cohort curve is the shape, not the final LTV figure. How quickly customers come back for a second order. What share ever place a second order at all. Whether the curve keeps climbing or flattens after the first ninety days. Two brands with the same twelve-month LTV can have completely different businesses, one with high repeat rates and a curve that keeps climbing, one front-loaded with a single purchase and a flat line after. The shape tells you whether you have a retention business or an acquisition treadmill.

Do not spend against LTV you have not earned yet

This is the one that actually costs people money. It is tempting to take a projected long-run LTV, sometimes extrapolated from thin data, and use it to justify a high CAC today. The problem is you are spending real money now against revenue that is a forecast, and if the forecast is optimistic you are buying customers at a loss for months before you find out. I prefer to set spend ceilings against a conservative realized window, something like ninety-day realized contribution that has actually happened, and treat longer-run LTV as upside rather than budget. If the long tail shows up, good, but you have not bet the business on it.

Watch for seasonality and source

A cohort acquired during a holiday promo or a viral moment behaves differently from one acquired in a quiet month through steady spend. Discount-driven cohorts often have weaker repeat behavior. If you blend all acquisition sources and seasons together, you get an average that describes none of them. Segment by acquisition month and, where you can, by source, so you are comparing like with like.

A cohort curve is a hypothesis generator, not a forecast you can take to the bank. It is great for spotting that something changed, that a recent cohort is repeating faster, that a channel brings worse retention, and worth almost nothing as a precise prediction at small volume. Read it for direction and shape, stay skeptical of the headline number, and never let an unearned LTV write checks your bank account has to cash.

8 responses to “Reading LTV and cohort curves without fooling yourself”

  1. How do you calculate LTV for a Shopify store? – The Ecomm Analyst Avatar

    […] Recalculate quarterly, not monthly. Cohort curves move slowly, and monthly recalculation mostly produces noise that people then react to. If you want the longer version of how to read those curves without fooling yourself, I wrote that up here: Reading LTV and cohort curves without fooling yourself. […]

    Like

  2. Why gift shoppers distort your Q4 new-customer numbers – The Ecomm Analyst Avatar

    […] Split the Q4 cohort. Report new customers acquired between Black Friday and Christmas as their own cohort, with gift-tagged orders broken out, and compare their 90-day repeat rate against the same window from a normal quarter. That gives you a gift discount you can apply to Q4 new-customer numbers in future years. I explained how to read these curves in reading LTV and cohort curves without fooling yourself. […]

    Like

  3. Tools to measure whether BFCM actually worked – The Ecomm Analyst Avatar

    […] Lifetimely is built for the third question. It tracks repurchase rate, time between orders, and lifetime value by cohort, so you can follow the November cohort against your regular cohorts at 30, 60, and 90 days. Pricing is based on monthly order volume. The free plan covers up to 50 orders, S is $79 a month for up to 500, M is $149 for up to 3,000, and L is $299 for up to 7,000, with a 14-day trial on paid plans. Order-based pricing means your November volume matters here, so check how a one-month spike is billed before the sale. The real payoff comes in February, when you can see whether BFCM buyers behave like customers or like coupon hunters. I wrote about reading those curves in reading LTV and cohort curves without fooling yourself. […]

    Like

  4. Triple Whale alternatives for LTV and cohort analysis – The Ecomm Analyst Avatar

    […] The useful split is between two questions. Cohort tools tell you how customers acquired in a given month behave over time: how many come back, how fast, and how much they spend. Acquisition tools tell you which channels and campaigns bring in customers worth having. Most brands need both answers, and very few tools are good at both. I walked through how to read the output without fooling yourself in reading LTV and cohort curves. […]

    Like

  5. Northbeam alternatives for LTV and cohort analysis – The Ecomm Analyst Avatar

    […] more than any model setting. I explained how to read the curves without fooling yourself in reading LTV and cohort curves, and the math is in how to calculate LTV for a Shopify […]

    Like

  6. Attribution tools for baby and kids brands – The Ecomm Analyst Avatar

    […] Your customer has a shelf life. Look at cohort curves by first product, not just by month. A parent who starts with newborn clothes may keep buying for two years. A parent who starts with a one-time product like a stroller accessory may not come back at all. That difference should change how much you pay to acquire each one. The cohort side of this is covered in reading LTV cohort curves on Shopify. […]

    Like

  7. Peel Insights vs Lifetimely – The Ecomm Analyst Avatar

    […] Peel goes further on analysis. It lists more than 30 cohort metrics, product and customer journey reports, and RFM segments you can export to email and ad platforms. If your team wants to slice cohorts by first product, discount used or subscription status and then act on those segments, Peel has more depth. How I read the curves themselves is in reading LTV cohort curves on Shopify. […]

    Like

  8. How to measure loyalty program revenue on Shopify – The Ecomm Analyst Avatar

    […] Seasonality muddies this, so line up comparable months where you can, and don’t launch a loyalty program the same quarter you change pricing or your email program. The cohort method is covered in more detail in reading LTV cohort curves on Shopify. […]

    Like

Leave a Reply

Navigation

About

Six years in e-commerce. Three Shopify stores across different niches, one scaled past seven figures. I’ve tested hundreds of ad creatives, obsessed over email flows, and learned more from my failures than my wins.

Now I focus on conversion optimization, retention marketing, and the analytics behind it all. This blog is where I share what actually works, backed by real numbers. No fluff, no guru energy.