Ecommerce customer lifetime value: the CLV guide for Shopify stores

Ecommerce customer lifetime value or CLTV is the total gross profit per customer that a store will receive from all future purchases that a customer makes in your store. This single number is the most important when determining ad budget as it dictamens how much you can safely spend to acquire a new customer.

File this one under “wildly important” – most Shopify founders cite CAC when they should be citing CLV. CAC tells you the cost of the first order. CLV tells you if you’ll ever get paid back. One of those numbers matters more than the other, and it is not CAC.

This 3-part guide explains how to calculate CLV using the common formula, show how to extract the necessary variables from Shopify, walk through industry benchmarks for repeat rates, point out the retention metrics that actually move the needle, and explain why segmenting by first product bought is THE single trick that most retailers miss (and you can get a free CLV Calculator to run the math for you in under a minute).

In this post

The CLV formula

The cleanest version of the formula is:

CLV = Average order value x Gross margin x Average orders per customer

If your AOV is $80, gross margin is 60% and customers on average place 2.3 orders over their lifetime, then CLV would be $80 x 0.6 x 2.3 = $110. This is how much you can afford to spend per customer acquisition and still break even in the long run. In reality you’d want to acquire customers for 1/3 or even 1/4 the value of CLV, but $110 is your ceiling.

Pulling the inputs from Shopify

  • AOV: Shopify Analytics > Reports > Sales by time. Divide total sales by order count.
  • Gross margin: Use your profit margin calculator and fold in COGS, Shopify fees, payment processing, and shipping.
  • Orders per customer: Customers report. Total orders divided by unique customers.

Or skip the spreadsheet and drop the numbers into our CLV calculator, which can even handle multiple years and properly apply your discount rate, whether you’ve calculated gross or net CLV.

Repeat purchase rate benchmarks

CategoryHealthy repeat rate
Consumables (coffee, supplements, skincare)35% to 50%
Apparel20% to 30%
Home goods15% to 25%
Furniture and high ticket5% to 15%

If your repeat rate is too low for the bottom of your price band, you’re probably wasting money acquiring customers – stop spending until you fix the ‘leak’ and make sure they stick around.

Retention levers that move CLV

  • Post purchase email flow (day 3, day 14, day 45, day 90)
  • SMS for consumables with predictable replenishment cadence
  • Loyalty program with real rewards, not 50 points for signing up
  • Product quality. If the first order disappoints, nothing else matters.
  • Easy reorders (Shop Pay saved carts, customer account with one click reorder)
  • Clean product pages that show the right color on the right photo, so returning customers can find the exact variant they bought last time

This is often the case with customers returning for similar items. If their previous purchase does not look exactly the same, they will leave the theme prematurely. The Rubik Variant Images plugin fixes this problem to improve the repeat customer UX.

Why CLV beats CAC

A merchant with $40 CAC and $50 AOV looks broken on the first order. Same merchant with $280 CLV over 18 months is printing money. CAC alone is a snapshot. CLV is the whole movie.

We shoot for a minimum CLV:CAC ratio of 3:1. Anything worse than 1:1 is losing money on each customer. Anything between 1:1 and 3:1 is just barely surviving on each customer. And anything above 3:1 means you can scale your ads without eating too much into your profit margin.

Segmenting by first product

Store’s look healthy on paper, but actually have a ton of hidden variance. By sorting customers by first purchase then computing their CLV, you can uncover an interesting pattern where 1-2 products account for customers worth ~3x the CLV of the average customer.

If you understand which 2-3 first purchases create the highest Customer Life Value, then you need to direct your ad spending to those products. This isn’t necessarily the items that have the highest conversion, the highest margin or the best traction with customers. The number may actually be very different.

For stores with a lot of near duplicate products (one per color), this is really useful because you can combine those products with Rubik Combined Listings, which makes sense for a bunch of your products, whereas doing cohort analysis for a store with 30 different fake SKUs when really you have 1 product is just not sane and even more annoying to compute CLV for.

Run your CLV

Plug your numbers in. Then fix your retention leaks! See the live demo store, watch the tutorial video, or read the getting started guide.

FAQ

What is a good CLV for an ecommerce store?

This varies by category but for a healthy store you are looking to be at least 3x CLV over CAC. subscription/consumable stores would look to be even higher. for furniture/high ticket items the first order is so large that you are looking for a lower CAC/CLV.

Should CLV use gross profit or revenue?

Gross Profit. Using Revenue in the calculation for CLV increases the number and leads to misallocation of ad budget. The answer to questions of how much can I spend on acquisition is “It’s whatever your customer is willing to pay, and that number is equal to your gross profit, not revenue.”

Over what time window should I measure CLV?

12 to 24 months. Any longer, and the numbers don’t really mean much. Any shorter, and they overstate the CLV for stores with longer cycles between purchases.

Does Shopify show CLV natively?

Shopify does offer customer analytics reports and repeat purchase rates within its Analytics section, but you will not find a single “Customer Life Time Value” (CLV) number to look up. You have to calculate it manually (as we provided a free CLV calculator for you) or choose a paid tool.

What is a healthy repeat purchase rate?

Content % Apparel 20-30% Consumables 35-50% Furniture <15% Make sure you're fixed on retention before you attempt to scale acquisition.

How do I improve CLV quickly?

The fastest wins are implementing a post purchase email flow, remind for consumables, and cleaning up product pages so returning customers can easily find what they bought previously.

Should CLV include returns?

Yes. Net CLV after returns is an honest measure. Gross CLV dramatically overstates the value of customers in high return categories like apparel.

Co-Founder at Craftshift