How do you calculate customer lifetime value on Shopify?

Multiply average order value by orders per customer per year by average customer lifespan in years, then multiply by gross margin for a profit view. Shopify documents no single CLV report, so use Customer cohort analysis (amount spent per customer, average order value) and an order export for the inputs, and a spreadsheet for the math.

Does Shopify show customer lifetime value?

Shopify's documentation describes no dollar CLV per customer. Its Customer cohort analysis reports average amount spent per customer by first-purchase cohort, with optional projections based on your store's previous 24 months. Predicted spend tier sorts customers into High, Medium, or Low, but it is a category, not a dollar value.

What is the CLV formula for ecommerce?

The basic formula is CLV = average order value x purchase frequency x average customer lifespan. For a profit view, multiply the result by gross margin, then subtract per-order costs such as shipping, payment fees, and returns. A cohort method skips the lifespan guess by tracking real cumulative spend per customer.

What is a good LTV:CAC ratio?

Shopify cites 3:1 LTV to CAC as a common reference point, and also says the right target depends on your margins and operating costs and does not fit every business. Use margin-adjusted LTV, not revenue, and pair the ratio with a payback check: how many orders until contribution covers CAC.

Is predicted spend tier the same as customer lifetime value?

No. Predicted spend tier places a customer in a High, Medium, or Low group using order frequency, spend per order against the store average, order count, and recency. Shopify requires more than 100 sales for it. It helps you segment customers, but it does not give you a dollar lifetime value.

Customer Lifetime Value on Shopify: 3 Formulas and Examples

Q: What is a good customer lifetime value?

There is no good dollar figure on its own, because order value, margin, and acquisition cost differ by brand and currency. Judge CLV against what it cost to acquire the customer. Compare margin-adjusted CLV with CAC, check how many orders it takes to repay CAC, and track whether each new cohort improves.

Customer lifetime value (CLV or LTV) is the total amount a customer spends with your business over the whole relationship. For an ecommerce brand, the number you can act on is narrower: how much gross profit the average customer brings in, compared with what it cost to acquire them.

Searching "customer lifetime value Shopify" tends to end the same way: you look through Analytics for a CLV report. Shopify's analytics field reference has no field with that name, and its own CLV guide tells merchants to calculate CLV in a spreadsheet, using cohort reports and predicted spend tiers for the inputs. This guide covers what to calculate, with an AED example, and what Shopify does and does not report.

Quick Answer

Simple CLV = average order value x orders per customer per year x years a customer stays. That is the basic formula in Shopify's CLV guide. Multiply by gross margin for margin-adjusted CLV, which is the version to compare with acquisition cost. Shopify's documentation describes no dollar CLV for each customer. It offers Customer cohort analysis (amount spent per customer, with optional projections) and predicted spend tier (High, Medium, or Low). A good CLV depends on margin and CAC; Shopify cites 3:1 LTV to CAC as a common reference point and notes it does not fit every business.

Check your own number. The free retention check works out your repeat purchase rate and what a few points of lift are worth, in your browser and without a signup.

What customer lifetime value means in ecommerce
CLV formula for ecommerce: three methods
Customer lifetime value example in AED
What Shopify reports about customer lifetime value
How to calculate customer lifetime value on Shopify
What is a good customer lifetime value?
How to raise customer lifetime value
Where Tranthor fits
FAQ

What Customer Lifetime Value Means in Ecommerce

CLV is one idea with three choices hidden inside it. Make each choice on purpose, or two people in the same company will quote two different numbers.

Choice	Option A	Option B	Better default
Revenue or profit	Revenue per customer	Gross profit or contribution per customer	Profit, because acquisition and fulfilment are paid in profit
Past or future	Historical: what customers have spent so far	Predicted: what they are expected to spend	Report both, labeled
Lifespan	Assume how long customers stay	Fix a horizon (12 or 24 months)	A fixed horizon, because lifespan is only known after customers leave

The lifespan point matters most for stores with no subscription. There is no cancellation date. A customer you assume stays 2.5 years may order twice and vanish. A 12-month or 24-month CLV is lower, and it is a number you can check against what actually happened.

CLV Formula for Ecommerce: Three Methods

Method 1: Simple historical CLV

Simple CLV = average order value x orders per customer per year x average customer lifespan (years)

This is the basic formula in Shopify's CLV guide. It needs three inputs you can pull from order history. Its weakness is lifespan, which is a guess unless you fix the horizon. If you only want what customers have actually spent, skip the formula: divide net sales from a customer group by the number of customers in it.

Method 2: Margin-adjusted CLV

Margin-adjusted CLV = simple CLV x gross margin
Contribution CLV    = margin-adjusted CLV - (lifetime orders x per-order costs)

Shopify's guide gives the first line and notes that the result is gross profit before acquisition costs and other operating expenses. The second line goes one step further. Per-order costs are the ones that sit outside product cost: shipping you absorb, payment fees, fulfilment, returns, and cash-on-delivery handling if you offer it. For a brand shipping across the UAE and KSA, those costs can change the answer.

Method 3: Cohort and predictive CLV

Group customers by the month of their first order and track the average cumulative spend for each group. No lifespan guess is needed, because you see the real curve. To predict, take an older cohort whose curve is complete and ask whether a newer cohort is tracking above or below it at the same age. If it tracks at 98% of the older cohort at month 3, expect roughly 98% of its month-12 spend.

Shopify's Customer cohort analysis does the grouping for you, and its Show projections toggle estimates future amount spent per customer using your store's previous 24 months of data, not industry averages. Shopify warns projections are not a guarantee.

Customer Lifetime Value Example in AED

An example brand sells skincare refills in the UAE. All values are illustrative and in AED, with tax and shipping charges already removed from order value.

Input	Value
Average order value	AED 210
Orders per customer per year	2.4
Expected lifespan	2.5 years
Gross margin	62%
Per-order costs (fulfilment, shipping, payment fees)	AED 25
Customer acquisition cost (CAC)	AED 140

Step	Calculation	Result
Lifetime orders	2.4 x 2.5	6.0
Simple CLV	AED 210 x 6.0	AED 1,260
Margin-adjusted CLV	AED 1,260 x 62%	AED 781
Contribution CLV	AED 781 - (6.0 x AED 25)	AED 631
LTV:CAC on revenue	AED 1,260 / AED 140	9.0
LTV:CAC on contribution	AED 631 / AED 140	4.5

The same customer is worth AED 1,260 or AED 631 depending on the method, and the ratio halves. A team quoting revenue CLV against CAC would think acquisition was twice as healthy as it is.

The payback check

Contribution on one order is AED 210 x 62% - AED 25 = AED 105. CAC is AED 140. The first order does not repay acquisition cost. The second order does (AED 210 across two orders against AED 140). That is why the second purchase is the hinge of ecommerce CLV: until a customer places it, the store is behind on that customer. For the metric that tracks it, see what a second purchase is and how to measure it.

The cohort view

Average cumulative spend per customer, in AED, by cohort age:

Cohort	Customers	Month 0	Month 3	Month 6	Month 12
June 2025	480	210	310	385	520
June 2026	610	205	305	not yet	not yet

The June 2026 cohort is at 305 / 310 = 98% of last year's curve at month 3. A hand projection for month 12 is 520 x 0.98, about AED 510. Run this check first, then compare it with Shopify's projection. If the two disagree by a lot, find out why before you plan spend on either.

What Shopify Reports About Customer Lifetime Value

Only describe what the documentation supports. Here is that list.

Shopify feature	What it gives you	What it is not
Customer cohort analysis, "Amount spent per customer"	Average cumulative amount customers in a first-purchase cohort have spent. Shopify's field reference lists tracking customer lifetime value as its use	A profit figure
Same report, "Show projections"	Projected amount spent per customer, based on your store's previous 24 months of data per cohort. The toggle does not appear without 24 months of data	A guarantee, or an industry average
Same report, "Average order value"	Average value of orders placed by customers in a cohort	A lifespan or frequency estimate
Predicted spend tier	High, Medium, or Low for each customer with at least one purchase, based on purchase frequency, spend per order against the store average, order count, and recency. Needs over 100 sales	A dollar value
Segment filters `amount_spent`, `number_of_orders`, `predicted_spend_tier`	Customer segments by spend, order count, or tier	A report
Returning customers report	Customers with two or more orders, with order count, average spend per order, and total spend	A forecast

Two caveats. Shopify's January 2024 changelog announced predicted spend metrics in cohort analysis for Advanced plans and above with at least 24 months of sales history. The current help page states the 24-month requirement and does not list a plan, so check what your admin shows. Also, customer spend totals in Shopify can include taxes and shipping, so strip them out before applying margin.

How to Calculate Customer Lifetime Value on Shopify

Open the reports. In Shopify admin, go to Analytics, then Reports, and filter to the Customers category.
Open Customer cohort analysis. Rows are cohorts by first-purchase month. Set the metric to Amount spent per customer for cumulative spend, then switch to Average order value for the formula input. For orders per customer, divide orders by customers in an order export, or use the order count in the Returning customers report.
Add projections if you can. If your store has 24 months of data, turn on Show projections while Amount spent per customer is the selected metric.
Take the numbers to a spreadsheet. Apply gross margin and per-order costs from your own accounts, because the cohort figures are spend, not profit.
Segment by predicted spend tier. If your store has more than 100 sales, filter customers with predicted_spend_tier = 'HIGH' in the segment editor to see who to protect, and compare tiers by acquisition source.

What Is a Good Customer Lifetime Value?

No dollar figure is good on its own. Average order value, margin, and acquisition cost vary by brand, and a benchmark quoted in US dollars from a US blog does not transfer to an AED store with different delivery costs. Use three tests instead.

Test	How to run it	What it tells you
LTV:CAC ratio	Margin-adjusted CLV / CAC	Whether acquisition spend creates value
Payback	Orders needed for cumulative contribution to repay CAC	How long cash is tied up
Cohort trend	CLV by first-order month, same age	Whether each new cohort beats the last

On the ratio: Shopify cites 3:1 LTV to CAC as a common reference point, and in the same guide says the target depends on your margins and operating costs and does not fit every business. Treat it as a starting question, not a pass mark. In the AED example the contribution ratio is 4.5 and the first order still does not repay CAC, which a 3:1 headline would hide.

If your ratio is below your target, the usual levers are lower CAC, higher margin, or more orders per customer. Repeat orders are the lever retention work most directly controls.

How to Raise Customer Lifetime Value

CLV rises when customers order more often, order more per basket, stay longer, or when margin per order improves. Start with frequency, the input retention work moves most directly.

Lever	CLV input it moves	Read next
Get more first-time buyers to a second order	Orders per customer	Repeat purchase rate: formula and benchmarks
Match the next message to the product bought	Orders and order value	Repeat purchase campaign examples
Fix discount dependency	Margin per order	Shopify retention strategy: 90-day plan
Reach MENAP buyers on the channels they use	Orders per customer	Ecommerce retention marketing in the UAE

Re-run the cohort view each quarter. A rising CLV alongside a falling margin usually points to discounting, so check both together.

Where Tranthor Fits

Tranthor is an autonomous CRM for ecommerce retention. It reads your Shopify order history, finds the repeat-purchase moment for a customer, and drafts the campaign for review. Every playbook starts in review, auto-send is off by default and unlocks after one approved run, and limits you approve (contact frequency, spacing, daily send cap, discount percentage cap) are enforced at send time. The overview is in AI CRM for ecommerce.

You can calculate every figure above without it. The point of the example is that the second order decides whether acquisition pays back, and that is the moment retention software is built to act on.

Sources: Shopify customer lifetime value guide, Shopify customer reports, Shopify analytics field reference, Shopify predicted spend tier, Shopify segment filter reference, Shopify changelog: predictive spend metrics in cohort analysis.