> ## Content Index
> Fetch the complete content index at: https://conversion.club/llms.txt
> Use this file to discover other available public pages before exploring further.

# How to calculate customer lifetime value
- URL: https://conversion.club/playbook/calculate-customer-lifetime-value-cohorts/
- Published: 2026-10-29T09:14:21.000Z
- Updated: 2026-10-29T09:14:21.000Z
- Description: Measure cumulative contribution from acquisition cohorts at twelve and twenty-four months. Treat a simple lifetime formula as an estimate, not observed value.
- Author: Jeremie Werner
- Tags: Protect margin, #playbook, Analytics, Shopify, Email & CRM

To calculate customer lifetime value, group customers acquired in the same month and sum the contribution they actually generate at twelve and twenty-four months. Average order value × frequency × lifetime × margin is an initial estimate, useful before sufficient history exists and often optimistic.

## The benchmark

The Shopify formula cited by the source multiplies AOV, buying frequency, customer lifetime, and gross-margin rate. In a fictional coffee brand, $70 excluding tax per order, 1.8 annual orders, two years, and 45% product gross margin give $252 in revenue and $113.40 in product margin per customer.

Compare that estimate with the source's fictional January 2025 acquisition cohort, acquired for $40 per customer:

| Horizon            | Cumulative revenue per acquired customer, excluding tax | Product margin at 45% | Margin ÷ $40 CAC |
| ------------------ | ------------------------------------------------------- | --------------------- | ---------------- |
| First order        | $72                                                     | $32.40                | 0.81             |
| Three months       | $88                                                     | $39.60                | 0.99             |
| Six months         | $101                                                    | $45.45                | 1.14             |
| Twelve months      | $118                                                    | $53.10                | 1.33             |
| Twenty-four months | $142                                                    | $63.90                | 1.60             |

The twenty-four-month row is an illustrative mature-cohort scenario, not an observed January-2025 result as of October 2026\. At that horizon, $63.90 is barely over half the formula's $113.40\. A formula can give the whole cohort the repeat pace of loyal customers even though many never reorder.

## The rule

Calculate LTV in margin and by cohort. Comparing $252 of estimated revenue with $40 CAC yields an impressive-looking 6.3 ratio. The fictional cohort's product-margin ratio reaches only 1.60 after two years. Contribution after fulfillment and payment costs would be lower still. The [LTV/CAC guide](https://conversion.club/playbook/what-ltv-to-cac-ratio-should-you-aim-for-and-what-can-your-site-change/) uses that more disciplined reading.

Choose a horizon the business can finance: twelve months for acquisition decisions if that is your affordable payback period, twenty-four for evaluating retention or subscriptions. One contributor compares forty-eight- and twenty-four-month results in mature cohorts and uses twenty-four months when the extra contribution is small.

With less than a year's history, use the formula as a labeled estimate. Then migrate to an observed cohort curve and review it quarterly. Never label a projection as realized lifetime contribution.

## The steps

1. **Build cohorts.** Group by first-order month using the [cohort-analysis method](https://conversion.club/playbook/customer-cohort-analysis/). Shopify's Customer cohort analysis supports weekly, monthly, and quarterly groupings. Use cumulative net sales divided by the original cohort size rather than assuming “Amount spent per customer” has the tax and shipping basis you need. The cited Shopify changelog describes that metric's inclusions and refunds. The source notes projections require twenty-four months of data; confirm current report availability.
2. **Accumulate revenue.** Measure net tax-exclusive revenue per original acquired customer at three, six, twelve, and twenty-four months. In an export, use customer ID in column A, order date in B, and net tax-exclusive value in C. In an English-locale Google Sheet, `=MINIFS(B:B,A:A,A2)` gives first-order date in D; `=DATEDIF(D2,B2,"M")` gives order age in months in E. A pivot groups by acquisition cohort and order age. Accumulate age-period sums and divide by the original cohort count, including nonreturners.
3. **Convert to contribution.** Multiply by a relevant product-margin rate or, preferably, the [contribution rate](https://conversion.club/playbook/how-do-you-calculate-the-contribution-margin-of-an-order/) after fulfillment and payment costs. Use cohort/product-specific costs where mix changes materially.
4. **Check repeat behavior.** Compare the curve with [repeat purchase rate](https://conversion.club/playbook/how-do-i-calculate-my-repurchase-rate/). More repeat purchasing often explains growth better than a larger basket, but inspect your own mix.
5. **Compare matched acquisition cost.** Put twelve-month cumulative contribution against CAC for the same cohort. [First-order target ROAS](https://conversion.club/playbook/target-roas-poas-contribution-margin/) shows the initial economics; measured LTV informs whether an affordable later payback is plausible.

## The pitfall

An all-customer lifetime average mixes four-year-old customers with last month's recruits. Older cohorts lift the figure without revealing current acquisition quality.

Acquisition context matters too. A lingerie-and-apparel brand's 2026 analysis found first-order revenue of €170–€230 per customer and twelve-month revenue of €250–€300 by acquisition month, with full-price cohorts ahead of promotional cohorts. “We will not even double LTV after a year,” the analyst observed. Keep those original euros and the case-specific result. For retention work, see [triggering the second purchase](https://conversion.club/playbook/when-and-how-to-trigger-the-second-purchase/).

## What to tell your team

These are fictional horizon values:

> “Our example cohort produces $53 in product margin at twelve months and $64 at twenty-four, against $40 acquisition cost. We set acquisition budgets against an affordable twelve-month contribution horizon and follow every new cohort on the same curve.”

## Sources

- [Shopify: What Is Customer Lifetime Value?](https://www.shopify.com/blog/customer-lifetime-value?ref=conversion.club)
- [Shopify Changelog: Enhancements to cohort analysis, November 29, 2023](https://changelog.shopify.com/posts/enhancements-to-the-cohort-analysis-report?ref=conversion.club)
- [Shopify Help: Customer reports](https://help.shopify.com/en/manual/reports-and-analytics/shopify-reports/report-types/default-reports/customers-reports?ref=conversion.club)