How to Calculate LTV and the LTV to CAC Ratio for an E-commerce Store

You can calculate LTV from your own order data. Multiply AOV by annual purchase frequency and by average customer lifespan, with all three inputs…

By 5 min read
How to Calculate LTV and the LTV to CAC Ratio for an E-commerce Store
3D illustration of an abacus with lime beads, for: How to Calculate LTV and the LTV to CAC Ratio for an E-commerce Store

Which LTV are you calculating?

LTV can mean several different numbers. When two people get different answers from the same store, they have often mixed these up.

  • Historic LTV: the total value of all of a customer's previous orders, after refunds and returns (7).
  • Predicted LTV: what a customer is expected to spend within the prediction window you choose (8).
  • Total LTV: historic plus predicted (8).

If you are deciding how much you can pay to acquire a customer, start with the formula in this article. You can build it entirely from your own order data. Keep in mind that revenue-based LTV is not profit (3), so a later step converts it.

Clean your order data before you calculate

The formula is only as accurate as the orders you feed into it. Before calculating:

  • Remove zero-value orders such as free giveaways and free trials. Klaviyo excludes them from its own LTV calculations, and you should do the same (9).
  • Account for refunds and returns, so the value reflects what customers actually kept (7).
  • Make sure each customer is counted once, because purchase frequency depends on the number of unique customers (2).
  • Pick one time period and use it for every input (1).

Calculate the three inputs from your orders

Take one full year of cleaned order data and work out three inputs:

  • AOV: total revenue divided by the number of orders (2).
  • Annual purchase frequency: the year's orders divided by the number of unique customers who purchased that year (2).
  • Average customer lifespan in years: how many years a customer typically keeps buying from you.

Then multiply them: LTV = AOV × annual purchase frequency × average lifespan in years (1). Measure all three inputs over the same time period. If you combine a monthly AOV with an annual frequency, the answer will be wrong (1).

If your store is young, you will not yet have a reliable lifespan figure. Use a conservative estimate and revise it as data accumulates.

Turn LTV into gross profit

What you have so far is revenue, not profit (3). To compare it with what you spend on acquisition, multiply it by your gross margin. The result is gross profit per customer before acquisition costs and other operating expenses (3).

This is the number to set against CAC. If you compare revenue-based LTV with CAC instead, the ratio will look healthier than the business really is.

For help deciding which number to run your store on, see MER, ROAS, POAS and ROI.

Calculate CAC on the same basis

CAC is the cost of attracting new customers divided by the number of new customers in the same period (4). Two rules keep it accurate:

  • Leave out the cost of serving or retaining existing customers. Including those costs inflates CAC (4).
  • Use your store's own definition of a new customer, and check it against the ad platforms. In Google Ads, under auto-detection, a customer counts as new if they have not purchased in the last 540 days. That may not match how your store defines a new customer (10).

To find the highest CAC your store can carry, see how to calculate break-even CAC.

How to read the LTV to CAC ratio

Divide margin-adjusted LTV by CAC. A 3:1 ratio is a common reference point, but it does not fit every business (5). Read your ratio against:

  • Your margins.
  • Your payback period, meaning how long it takes to recover what you paid to acquire the customer.
  • Your cash needs.
  • Your store's own historical results (5).

Payback matters because a customer who buys once and disappears has no long-term value. The real economics of the relationship begin only after the acquisition cost is recovered (11). A ratio can look good on paper while a long payback period still strains your cash.

Break it down by channel and by cohort

A single blended ratio hides too much. Compare LTV and CAC for each acquisition channel, because a healthy overall ratio can hide a channel that brings in low-value customers at a high cost (6). Without this breakdown, you cannot tell a campaign that created long-term customers from one that only moved short-term volume (12).

When you compare groups of customers acquired at different times, measure each cohort over the same period. Otherwise older groups will look more valuable just because they have had longer to buy (13). If you use Shopify's cohort report, its spending projections need 24 months of store data (13).

Once you know which customers are worth more, you can act on it. Google Ads' new customer acquisition goal lets you add value adjustments to conversions from new customers, so a new customer can be valued above their first order (14). Raising repeat purchases also lifts LTV directly. See how to increase repeat purchases and LTV.

Sources

  1. (1) Shopify · 2026-10-08
  2. (2) Shopify · 2026-10-08
  3. (3) Shopify · 2026-10-08
  4. (4) Shopify · 2026-11-06
  5. (5) Shopify · 2026-10-08
  6. (6) Shopify · 2026-10-08
  7. (7) Klaviyo · 2026-10-26
  8. (8) Klaviyo · 2026-10-26
  9. (9) Klaviyo · 2026-10-26
  10. (10) Google · 2025-10
  11. (11) Bain & Company · 2026-06-18
  12. (12) Bain & Company · 2026-06-18
  13. (13) Shopify · 2026-10-08
  14. (14) Google · 2026-11-13
  15. (15) The CMO Survey (Duke University Fuqua School of Business, Deloitte, American Marketing Association) · 2026-04

What is the difference between revenue-based LTV and margin-adjusted LTV?

Revenue-based LTV is AOV multiplied by annual purchase frequency and by average customer lifespan (1). The margin-adjusted version multiplies that result by gross margin, which gives you gross profit before acquisition costs and other operating expenses (3). Use the margin-adjusted version when you compare against CAC.

Is a 3:1 LTV to CAC ratio right for every store?

No. It is a common reference point, but it does not fit every business. Read your ratio against your margins, payback period, cash needs and your store's own historical results (5).

My store is less than two years old. Can I still calculate LTV?

Yes. You can apply the basic formula to your order data (1) (2), using a conservative lifespan estimate that you revise as data accumulates. Note, though, that spending projections in Shopify's cohort report need 24 months of store data (13).

Should retention costs be included in CAC?

No. CAC covers only the cost of attracting new customers. Including the cost of serving or retaining existing customers inflates the number (4).

Why should I care about LTV if ads already bring in sales?

Because a customer who buys once and disappears has no long-term value (11). Even so, the 2026 CMO Survey found acquisition budgets are 26.0% larger than retention budgets, up from 19.6% a year earlier, although retention is delivering stronger performance results (15).

Read also

Was this article helpful?
Share this article

Want this applied to your own accounts?

Book a Growth Audit

Comments (0)

No comments yet. Be the first to comment.

Add a comment

Comments appear after review. We do not ask for your email.