Skip to content

Customer lifetime value for Shopify: a simple way to estimate it

A practical customer lifetime value formula for Shopify stores, worked examples, the common mistakes, and how to use CLV to decide what to spend on ads and retention.

Customer lifetime value (CLV or LTV) is how much a customer is worth to your store over the whole relationship, not just their first order. It is the number that tells you how much you can afford to spend to win a customer, and how much it is worth spending to keep one.

The simple formula

For most Shopify stores this is good enough:

CLV = average order value × average orders per customer

Where:

  • Average order value (AOV) = revenue ÷ number of orders
  • Average orders per customer = number of orders ÷ number of unique customers

Use the same time window for both, for example the last 24 months, and use paid orders only.

Example

  • Revenue over 24 months: 120,000
  • Orders: 2,400
  • Unique customers: 1,500

AOV = 120,000 ÷ 2,400 = 50. Orders per customer = 2,400 ÷ 1,500 = 1.6. CLV = 50 × 1.6 = 80.

Use profit, not revenue

A customer who spends 80 is not worth 80 to you. If your gross margin after product cost, shipping and payment fees is 45%, the customer is worth about 36 in gross profit. That is the number to compare with what you pay to acquire customers.

Profit CLV = CLV × gross margin

If you spend 40 on ads to win a customer worth 36 in profit, every new customer loses money unless something improves.

Common mistakes

  1. Using a short window. Customers who joined last month have not had time to come back. Use at least 12 months, ideally 24.
  2. Mixing in one-off spikes. A big sale or a viral moment can flood your data with one-time buyers. Compare cohorts of customers who joined in different months.
  3. Ignoring refunds and cancellations. Leave out cancelled orders and subtract refunds.
  4. One number for everyone. Your Best Customers might be worth ten times your average customer. Average CLV hides that.

CLV by customer group

CLV becomes much more useful when you split it. Calculate it separately for groups such as Best Customers, Loyal and New (see customer segments). You will usually find:

  • A small group of customers produces a big share of lifetime value.
  • First-time buyers who place a second order are worth far more than those who do not.
  • Customers in At Risk still carry a lot of value you can protect.

That tells you where retention effort pays off.

Three levers to raise CLV

  1. More orders per customer: better post-purchase emails, reorder reminders timed to your cycle, and win-back emails. Track this with your repeat purchase rate.
  2. Higher order value: bundles, free-shipping thresholds and relevant cross-sells.
  3. Longer relationships: spot customers drifting away early, before they are gone.

See expected spend per customer

WinBack shows an Expected Spend for every customer, based on how they buy, next to their Customer Score and risk of leaving, so you can see which relationships are worth the most effort. See WinBack on the Shopify App Store.