The LTV math
most Shopify brands
are getting wrong.

There is a brand doing $8M in revenue that believes their LTV is $240. That number comes from their Shopify Analytics dashboard — average order value, multiplied by purchase frequency, multiplied across the customer lifespan as the platform reports it. The calculation is clean. The spreadsheet looks right. And it has been driving their acquisition strategy for 18 months.

The actual number, when you run it properly — contribution margin adjusted, cohort-segmented, time-discounted — is closer to $140. That $100 gap means every channel decision they've made has been off. They've been paying more to acquire customers than those customers are actually worth at the margin. They know revenue is growing. They don't know the margin is compressing. They think growth is working.

This is the most common and most costly math error in DTC. Not fraud, not negligence — just the wrong methodology, applied with confidence, at scale. The brands that close the $5M inflection point are almost always the ones that figured this out first.

Wrong LTV is not
a data problem.
It's a strategy problem.

LTV is not a vanity metric. It is the number your entire acquisition strategy sits on. Your CAC ceiling — the maximum you can justify paying to acquire a customer — is a direct function of LTV. Your channel mix decisions depend on which channels produce customers with the highest actual lifetime value, not the highest volume. Your retention investment is justified or cut based on what a retained customer is worth.

When LTV is wrong, everything downstream is wrong. You overpay on Meta. You underinvest in channels that produce genuinely high-value customers. You deprioritize retention work because the LTV number looks acceptable without it. The cascade of bad decisions compounds quietly for months — sometimes for years — before the margin reality becomes undeniable.

The brands that get this right do not have better data than the ones that get it wrong. They have a different methodology. The methodology is not complicated. What it requires is discipline — the discipline to measure what you actually keep, not what shows up in your revenue line, and to track it at the cohort level rather than the aggregate.

Three errors.
Each one makes
the next one worse.

These are not independent mistakes. They stack. A brand that averages instead of cohorts, calculates on gross revenue instead of contribution margin, and ignores time decay has an LTV figure that is wrong in three directions simultaneously. Fix one and your number improves. Fix all three and the picture looks completely different.

Error 1: Averaging Instead of Cohorting

Aggregate LTV hides the trend that matters most. When you calculate LTV across your entire customer base, you blend customers acquired three years ago with customers acquired last month. The old cohorts — acquired when your product was newer, your retention program was tighter, your organic word-of-mouth was stronger — drag the average up. The new cohorts, which reflect your current acquisition reality, are masked underneath.

A brand with genuinely deteriorating retention can show flat or even improving aggregate LTV for 12 to 18 months because the historical cohorts are carrying the number. By the time aggregate LTV starts declining, the new cohorts have been underperforming for over a year. You've been making acquisition bets based on the retention profile of customers you acquired years ago.

The right unit of analysis is the cohort: customers acquired in the same calendar month, from the same channel, buying the same first product. That's where the real signal lives.

Error 2: Gross Revenue Instead of Contribution Margin

Revenue LTV is theater. What matters is what flows through to the business after you've subtracted everything that leaves when a customer buys. That means COGS, fulfillment per order, returns and the associated reverse logistics cost (average reverse fulfillment in ecommerce runs $8 to $18 per return), and the channel-specific discounts you issued to acquire or retain that customer.

Contribution LTV = gross revenue minus COGS, minus fulfillment, minus returns cost, minus discount spend on that customer's orders. That is the number that tells you whether you're building a business or just building revenue.

A brand running frequent 30% discount days may show strong revenue LTV because purchase frequency is elevated by the promotions. Contribution LTV will look very different. The same customer who shows up as $280 in revenue LTV might be $95 in contribution LTV after their discount history and return rate are applied. Every acquisition decision made on the $280 number was wrong.

Error 3: Ignoring Time Decay

A dollar of margin received three years from now is worth less than a dollar today. Cash you can deploy into inventory and acquisition this year is worth more than cash you'll receive from a re-order in year three. Most DTC brands calculate LTV over an extended horizon — sometimes the full "lifetime" of the customer — without applying any time discount to future cash flows.

For most DTC brands, the practical solution is to use 12-month and 24-month CM-LTV windows as primary metrics. Not "lifetime." These windows are close enough to present value that the distortion is manageable, they force a useful discipline around near-term retention, and they are auditable — you can actually verify them against real cohort data rather than projecting infinitely into the future.

How to calculate
LTV correctly.

This is not a theoretical framework. These are the steps. Run them in order. The output will look different from what your Shopify dashboard shows, and the difference is the information you've been missing.

Step 1: Define Your Cohorts

Group customers by acquisition month, acquisition channel (the channel that drove the first order), and first product category purchased. These are your three primary cohort dimensions. You don't need all three simultaneously at the start — begin with acquisition month, then layer in channel segmentation once you have the baseline framework running.

Step 2: Calculate Contribution Margin Per Order

For each order in a cohort's history: gross revenue minus COGS minus fulfillment cost per order minus return cost (allocate return cost to the order using your average return rate and average reverse fulfillment cost) minus the discount amount applied. This is your contribution margin per order. Sum these across all orders a cohort has placed in a given window and you have cohort CM.

Step 3: Calculate 12-Month and 24-Month CM-LTV by Cohort

Take the total contribution margin generated by each acquisition cohort within 12 months of their first purchase, divided by the number of customers in that cohort. That is your 12-month CM-LTV. Run the same calculation at 24 months. Plot both figures by cohort across time — you want to see whether each successive cohort's CM-LTV at the 12-month mark is improving, stable, or declining.

Step 4: Calculate Payback Period

Payback period = CAC divided by monthly contribution margin contribution per customer. If your CAC is $85 and your average customer contributes $12 of CM per month (based on purchase frequency and order CM), your payback period is approximately seven months. Anything beyond 12 months on payback is a significant risk signal for a DTC brand — it means you need to keep the business funded for a long time before new customers become positive contributors.

Step 5: Calculate LTV:CAC by Channel Cohort

Once you have CM-LTV at the 12-month and 24-month windows by acquisition channel, divide each by the CAC for that channel. This is your channel-level CM LTV:CAC ratio. These numbers will vary significantly across channels. That variation is the single most actionable output of the entire exercise.

These benchmarks are on a contribution margin basis, not gross revenue. Industry 3:1 on CM is meaningfully different from 3:1 on revenue. A brand reporting 3:1 on gross revenue with 40% contribution margins is actually running at 1.2:1 on a CM basis. That is a business with a structural problem, not a growth opportunity.

Getting the data
out of Shopify —
and where it falls short.

Shopify has native cohort analysis. You'll find it under Analytics > Reports > Customers > Customer cohort analysis. It shows you retention rates by acquisition month — what percentage of each cohort came back to purchase in subsequent months. It is genuinely useful as a starting point, and most brands have never looked at it.

What Shopify's cohort report shows: monthly purchase retention by cohort, with the ability to filter by sales channel. What it does not show: contribution margin at the cohort level, channel-level acquisition cost, return rates by cohort, or discount spend broken out by customer. It gives you the retention curve shape. The economic content of that curve is a separate exercise.

The Four Data Sources You Need to Join

Shopify cohort report: Purchase retention rates, purchase frequency, revenue by cohort. The baseline for timing and frequency data.

Klaviyo (or your ESP): Revenue attributed to email flows and campaigns by cohort. This matters because email-driven repurchase has a different cost profile than paid retargeting. Customers who reorder through email are genuinely higher-margin than customers who need a paid retargeting ad to come back. The right tech stack at each revenue tier determines how well you can actually execute and measure this.

Returns platform (Loop, Narvar, or your 3PL data): Return rate by cohort, return cost per order. This is the most commonly skipped data join. Brands will calculate LTV without knowing that their 2024-Q4 cohort — acquired heavily through a holiday discount — has a 28% return rate versus the 12% baseline for non-promotional cohorts.

Ad platform data: Channel-level CAC by acquisition month. Meta, Google, TikTok. You need the actual cost to acquire each cohort at the channel level to calculate the LTV:CAC ratio that matters — not a blended average.

The practical approach: build this in a Google Sheet or Looker Studio at first. Pull cohort-level revenue from Shopify, channel CAC from your ad platforms, email revenue contribution from Klaviyo, and return rates from your returns data. Join on customer acquisition month and channel. Calculate CM per cohort by subtracting COGS and order costs from cohort revenue. You'll have a working CM-LTV model within a day if the data is clean. If it's not clean, fixing the data hygiene is its own return on investment.

LTV benchmarks
by DTC category.

Category matters. A 4:1 CM-LTV:CAC ratio for an apparel brand is excellent. For a supplements brand with monthly replenishment cycles, 4:1 is underperforming. These benchmarks are reference points — not targets you set without understanding your own category economics.

When the number
comes back worse
than you expected.

Run the corrected calculation and the result is below your CAC. What now?

First, separate the problem. Contribution LTV below CAC means you have an acquisition problem, a retention problem, a margin problem, or some combination of all three. They are not the same fix. An acquisition problem means you're paying too much for the wrong customers — solve it with channel mix and targeting. A retention problem means customers aren't coming back — solve it with post-purchase experience and loyalty infrastructure. A margin problem means COGS, discounting, or returns are destroying what should be profitable revenue — solve it with pricing discipline and returns rate management. If you're also evaluating working capital to fund growth through this period, understand that the cost of Shopify Capital compounds quickly when CM-LTV is already under pressure.

Second, look at channel-level CM-LTV:CAC. You almost certainly have channels that are positive and channels that are negative — and without the proper calculation, you probably don't know which is which.

This was not a marginal finding. We had been directing budget based on a metric — ROAS on gross revenue — that told a fundamentally different story than the metric that actually mattered. The channels that produced the best ROAS were also producing customers who purchased heavily on discount, returned at elevated rates, and didn't come back at the same frequency as customers from other channels. On revenue, they looked great. On contribution margin, cohorted at 12 months, they were a cash drain.

The channel we'd been underspending produced customers who paid full price more often, returned less, and had a 90-day second purchase rate 18 percentage points higher than our best-performing paid social channel. The CAC was slightly higher. The CM-LTV at 12 months was 6× that CAC. We had been leaving the most profitable acquisition channel underfunded because the surface-level metric didn't tell us it was the best one.

The single number
that tells you where
LTV is headed.

Building a full CM-LTV model takes time and requires 12 to 24 months of cohort history to be meaningful. You can not wait that long to know whether the customers you are acquiring right now will produce good returns. You need a leading indicator that tells you early — ideally within 90 days of the first purchase — whether a cohort is on track or not.

That indicator is second purchase within 90 days.

The data is clear on this. Roughly 62% of all repeat purchases happen within 90 days of the first order. The median time to second purchase across DTC is 45 days. Customers who come back within 90 days have a dramatically different long-term retention profile than customers who don't. Speed to second purchase is the strongest single predictor of long-term LTV — more predictive than first-order AOV, more predictive than acquisition channel in isolation, more predictive than the product category in most cases.

Brands with 35%+ 90-day second purchase rates compound their LTV over time. The customers come back faster, they tend to accept fewer discounts on subsequent orders, and they refer at higher rates. Brands below 25% typically struggle to reach 3:1 CM-LTV:CAC on a contribution basis, regardless of how well the acquisition side is running.

How to Use This as a Dashboard KPI

Build 90-day second purchase rate as a primary dashboard metric — not an afterthought in a retention report. Track it by cohort (acquisition month), by acquisition channel, and by first product purchased. When a new cohort's 90-day second purchase rate drops below your baseline, that is an early warning that either the acquisition targeting has drifted toward lower-quality buyers, or the post-purchase experience has degraded for that cohort's entry point.

The specific triggers to watch: if 90-day second purchase rate drops more than 5 percentage points versus the prior three cohorts, investigate immediately. If it drops more than 10 points, stop scaling acquisition from that cohort's primary channel until you understand the cause. The diagnosis is faster than you think when you have clean cohort data — it is usually one of three things: first-order experience quality, post-purchase email timing, or acquisition targeting that has drifted toward deal-seekers rather than brand buyers.

Shopify's Customer cohort analysis report will show you retention by month. Pull the percentage of each cohort that placed a second order in month 1 and month 2 combined. That is your 90-day second purchase rate. This is available natively — you do not need a third-party tool to start tracking it. You just need to look at the report and build the habit of reviewing it when you review any other acquisition metric. Pair this metric with a product page conversion audit — the two work together: one measures how well you're retaining buyers, the other measures how well you're converting them in the first place.

LTV is not a number on a dashboard. It is a statement about whether the economics of your business are working. The brands that get it right are not using more sophisticated software — they are asking a more honest question: what does a customer actually contribute after everything it costs to serve them? That question, answered at the cohort level, by channel, over a realistic time horizon, will tell you more about the health of your DTC brand than any other single piece of analysis.

Run the math. The answer will almost certainly surprise you. What you do with the surprise is what determines the next 12 months.