CLV Formula: 3 Ways to Calculate Customer Lifetime Value

Simple, average, and predictive — pick the formula that matches your data

What Is the CLV Formula?

Numbers talk. Guesses cost.

The CLV formula is the equation used to calculate customer lifetime value — the total revenue one customer generates over their entire relationship with your brand. The most common version is CLV = Average Order Value x Purchase Frequency x Customer Lifespan, but there are three distinct formulas depending on your data maturity, according to Harvard Business Review.

CLV stands for customer lifetime value. Some people call it LTV — same number, same idea. It answers one question: how much is a customer worth beyond the first transaction?

Most Shopify store owners track conversion rate and average order value. Those are snapshots. CLV is the full picture. It tells you how much you can spend to acquire a customer, which segments deserve retention investment, and when a discount is actually profitable.

We audit 80+ ecommerce stores a year across Malaysia and Singapore. The stores that know their CLV make sharper decisions on ad spend, email frequency, and loyalty programs. The stores that do not know it are guessing — and overspending.

There are three ways to calculate it. Each formula suits a different stage of business. Let me break down all three with worked examples you can plug your own numbers into.

Which CLV Formula Should You Use?

It depends on your data.

Use the simple CLV formula if you have basic sales data. Use the average CLV formula when you have 12+ months of per-customer transaction history. Use the predictive CLV formula when you have churn rate and discount rate data. A 2023 study by Bain & Company found that brands using predictive CLV models allocate acquisition budgets 20-30% more efficiently than those using simple averages.

Here is a quick comparison to help you decide:

Formula	Best For	Inputs Needed	Accuracy	Complexity
Simple CLV	New stores, quick estimates	AOV, purchase frequency, lifespan	Low-Medium	2 minutes
Average CLV	Stores with 12+ months data	Per-customer revenue, customer count	Medium	5 minutes
Predictive CLV	Scaling brands, investor decks	Margins, retention rate, discount rate	High	15 minutes

Source: WebMedic ecommerce audit methodology + Harvard Business Review CLV framework

If you have been running for less than a year, start with simple. If you have Shopify data going back 12+ months, jump to average. If you are building forecasts or pitching investors, go predictive.

Let me walk through each one.

How Do You Calculate Simple CLV?

Multiply three numbers.

Simple CLV = Average Order Value x Purchase Frequency x Customer Lifespan. For a store with a $65 AOV, 2.8 orders per year, and a 2-year average customer lifespan, CLV = $364. This formula comes from the standard marketing textbook model cited by Shopify and works for any store with basic sales data.

Here is the formula:

CLV = AOV x F x L

Where:

• AOV = Average Order Value (total revenue / total orders)
• F = Purchase Frequency (total orders / total unique customers, per year)
• L = Customer Lifespan (average number of years a customer keeps buying)

Worked Example: Simple CLV

Let us say you run a skincare brand on Shopify. Your numbers:

• Total revenue last 12 months: RM 520,000
• Total orders: 8,000
• Unique customers: 2,860
• Average customer lifespan: 2 years (estimated)

Step 1 — AOV: RM 520,000 / 8,000 = RM 65

Step 2 — Purchase frequency: 8,000 / 2,860 = 2.8 orders per year

Step 3 — CLV: RM 65 x 2.8 x 2 = RM 364

That means each customer is worth RM 364 over their lifetime — not RM 65. If your customer acquisition cost (CAC) is RM 45, you are in good shape. If your CAC is RM 120, you still have room. If your CAC is RM 400, you are losing money on every customer.

This is the formula most store owners should start with. You can pull these numbers from Shopify Analytics in under two minutes.

When Simple CLV Breaks Down

The simple formula treats every customer the same. It averages out your power buyers with your one-and-done visitors. That is fine for ballpark estimates, but it hides the distribution.

A store might have a CLV of RM 364 on average, but the top 20% of customers could be worth RM 1,200 while the bottom 50% are worth RM 65. The average masks the reality.

That is where the next formula helps.

How Do You Calculate Average CLV Per Segment?

Split your customers first.

Average CLV sums actual revenue per customer over a defined period and averages it by segment. According to RJMetrics (now Adobe), the top 1% of ecommerce customers are worth 18x more than the average buyer. Segmenting before averaging reveals where the real value sits — and where retention investment pays off.

Here is the formula:

Average CLV = Total Revenue from Segment / Number of Customers in Segment

This is not a prediction. It is historical fact. You look at actual customer spend over a fixed window — usually 12, 24, or 36 months — and calculate average value per group.

Worked Example: Segmented Average CLV

Same skincare brand. You export your Shopify customer data and segment by purchase count:

Segment	Customers	Total Revenue	Avg CLV	% of Revenue
1 purchase	1,716 (60%)	RM 111,540	RM 65	21%
2-3 purchases	858 (30%)	RM 204,360	RM 238	39%
4+ purchases	286 (10%)	RM 204,100	RM 713	40%
All customers	2,860	RM 520,000	RM 182	100%

Source: WebMedic client data (anonymised), Malaysian Shopify store, beauty category, 12-month window

Look at that table. Ten percent of your customers generate 40% of your revenue. Their CLV is 11x higher than one-time buyers.

This changes your strategy. Instead of spending equally on all customers, you invest heavily in moving people from the first segment to the second. A single reorder email sequence could be worth more than a new Facebook campaign.

You can run these numbers with the Customer Lifetime Value Calculator and see your own segmentation.

How to Pull Segmented Data from Shopify

In Shopify Admin, go to Customers > Export. You will get a CSV with order count and total spend per customer. Sort by order count, create three buckets, and calculate the average for each.

If you use Klaviyo, the data is even cleaner — Klaviyo's CLV prediction already segments customers by value tier. But the manual method above works for any store.

Does this sound like your store? Find out where you're leaking revenue — take the free Revenue Score. 3 minutes. Free. No pitch.

How Do You Calculate Predictive CLV?

Factor in churn and the time value of money.

Predictive CLV = (Average Revenue per Customer x Gross Margin) x (Retention Rate / (1 + Discount Rate - Retention Rate)). This model, derived from the Fader and Hardie BG/NBD framework published in the Journal of Marketing Research, accounts for customer churn probability and discounts future cash flows — giving the most accurate estimate of what a customer is worth today.

Here is the formula:

Predictive CLV = (ARPC x GM) x (R / (1 + D - R))

Where:

• ARPC = Average Revenue Per Customer per period (usually annual)
• GM = Gross Margin (as a decimal)
• R = Retention Rate (% of customers who buy again next period)
• D = Discount Rate (cost of capital, usually 8-12% for ecommerce)

Worked Example: Predictive CLV

Same skincare brand. You have two years of data now and can calculate retention rate:

• Average annual revenue per customer: RM 182
• Gross margin: 55% (RM 100.10 profit per customer per year)
• Retention rate: 40% (40% of customers buy again the following year)
• Discount rate: 10%

Step 1 — Margin-adjusted revenue: RM 182 x 0.55 = RM 100.10

Step 2 — Multiplier: 0.40 / (1 + 0.10 - 0.40) = 0.40 / 0.70 = 0.571

Step 3 — Predictive CLV: RM 100.10 x 0.571 = RM 57.16

Wait — RM 57? That is much lower than the RM 364 from the simple formula. Why?

Because the predictive formula only counts profit (not revenue), and it discounts future cash flows. It tells you the net present value of a customer — what they are worth to your business in today's money after accounting for margin erosion and churn.

This is the number you use for:

• Setting maximum CAC (your CAC must be below RM 57)
• Financial modeling and investor presentations
• Comparing customer cohorts over time

Why Does Predictive CLV Give a Lower Number?

The simple formula measures revenue over a lifespan you estimated. Predictive CLV measures profit over a mathematically modeled lifespan. Two critical differences:

1. Margin adjustment: Revenue is vanity. A RM 65 order at 55% margin gives you RM 35.75 in gross profit. The predictive formula uses profit, not revenue.

2. Discount rate: Money next year is worth less than money today. A 10% discount rate means RM 100 next year is worth RM 91 today. Over multiple years, this compounds significantly.

3. Retention curve: Instead of guessing a 2-year lifespan, the predictive model uses your actual retention rate to calculate an implied lifespan. At 40% retention, most customers are gone after 2-3 periods — the math reflects that.

The number is more conservative, but it is more honest. When we run this analysis during LTV calculations for WebMedic clients, the predictive number is usually 50-70% lower than the simple one. That gap is where bad acquisition decisions get made.

How Do You Improve CLV Regardless of Which Formula You Use?

Same levers, every time.

The three CLV levers are average order value, purchase frequency, and retention duration. Increasing any one of them by 10% improves CLV by 10%. Increasing all three by 10% improves CLV by 33%, according to Harvard Business School research on compounding customer value. The highest-ROI lever for most Shopify stores is purchase frequency — because it is the cheapest to influence through email automation.

Here are the five highest-impact actions we see in WebMedic audits:

1. Post-Purchase Email Sequences

A 5-email post-purchase sequence (thank you → education → cross-sell → review request → replenishment reminder) lifts repeat purchase rate by 20-30% for consumable products. Klaviyo data shows replenishment emails alone have 2-3x higher conversion rates than promotional blasts.

The first 100 days after purchase determine whether a customer becomes a repeat buyer or disappears.

2. Subscription or Auto-Replenishment

For consumable products (skincare, supplements, food), adding a subscribe-and-save option increases average customer lifespan by 2-3x. Tools like Recharge or Loop Subscriptions integrate directly with Shopify.

3. Tiered Loyalty Programs

A well-structured loyalty program increases purchase frequency by 20% and AOV by 13%, according to Bond Brand Loyalty's 2024 report. The key: make the first reward achievable within 2-3 purchases, not 20.

4. Bundle and Upsell Strategies

Post-purchase upsells (shown on the thank-you page) add 5-15% to AOV with zero additional acquisition cost. Shopify apps like ReConvert or CartHook make this a 30-minute setup.

5. Win-Back Campaigns at Day 60 and Day 120

If a customer has not purchased again by day 60, trigger a win-back sequence. By day 120, send a final "we miss you" offer with a time-limited discount. This recovers 5-10% of lapsed customers — customers who would have otherwise contributed RM 0 to CLV.

CLV Lever	Tactic	Expected Impact	Implementation Time
Purchase Frequency	Post-purchase email sequence	+20-30% repeat rate	1-2 weeks
Purchase Frequency	Subscription/auto-replenish	+2-3x lifespan	2-3 weeks
AOV	Post-purchase upsell page	+5-15% AOV	1 day
AOV	Tiered loyalty program	+13% AOV, +20% frequency	2-4 weeks
Retention	Win-back campaign (day 60/120)	Recover 5-10% lapsed	1 week

Sources: Klaviyo benchmark data (2025), Bond Brand Loyalty Report (2024), WebMedic client results

What Are Common Mistakes When Calculating CLV?

Almost every store gets at least one wrong.

The three most common CLV mistakes are using revenue instead of profit, ignoring cohort differences, and overestimating customer lifespan. A study by ProfitWell found that 63% of companies overestimate their CLV by 2-5x because they use simple formulas without adjusting for churn. Always validate your CLV against actual cohort data.

Mistake 1: Revenue Instead of Profit

If your CLV is RM 364 but your gross margin is 40%, the actual profit-based CLV is RM 146. Setting your CAC target at RM 300 based on revenue CLV means you lose money on every customer.

Always calculate a second version using margin-adjusted numbers. The predictive formula handles this automatically.

Mistake 2: Ignoring Cohort Differences

Customers acquired through Google Ads behave differently from customers acquired through Instagram. Their AOV, purchase frequency, and lifespan are different. Calculating one CLV for all customers hides these differences.

Segment by acquisition channel. We regularly see 3-5x CLV variation between channels in the same store.

Mistake 3: Overestimating Lifespan

Saying "our customers stay for 3 years" when you have only been in business for 18 months is a guess, not a calculation. Use actual retention data. If 40% of customers return after year one, your implied average lifespan is closer to 1.67 years — not 3.

Mistake 4: Calculating Once and Forgetting

CLV changes. Seasonality, product launches, and market shifts all affect it. Recalculate quarterly. The Customer Lifetime Value Calculator makes this a 2-minute task.

Frequently Asked Questions

What is the simplest CLV formula for ecommerce?

The simplest CLV formula is Average Order Value x Purchase Frequency x Customer Lifespan. A Shopify store with RM 65 AOV, 2.8 annual orders, and a 2-year lifespan has a CLV of RM 364. Pull these three numbers from Shopify Analytics under the Reports section — no spreadsheet needed.

What is the difference between CLV and LTV?

CLV (customer lifetime value) and LTV (lifetime value) are the same metric — different abbreviations for the same calculation. Marketing teams tend to use CLV while finance teams prefer LTV. The formulas, inputs, and outputs are identical regardless of which term you use.

How often should you recalculate CLV?

Recalculate CLV quarterly at minimum. Customer behaviour shifts with seasonality, product launches, and pricing changes. Shopify stores that recalculate quarterly catch retention drops 2-3 months earlier than those who set it once a year, based on WebMedic audit data across 80+ Malaysian and Singaporean stores.

What is a good CLV-to-CAC ratio for ecommerce?

A healthy CLV-to-CAC ratio is 3:1 or higher — meaning each customer generates at least 3x what you spent to acquire them. Below 1:1, you are losing money on every sale. Between 1:1 and 3:1, profitability depends on your gross margin. Above 5:1, you are likely under-investing in growth.

Can you calculate CLV without historical data?

Yes, but with lower accuracy. Use industry benchmarks for purchase frequency and lifespan, then apply the simple formula. Shopify's average across all stores is 1.8 orders per year with a 1.5-year lifespan. Start there, then replace benchmarks with your actual data as it accumulates over 6-12 months.

Keep Reading

• LTV Calculation: How to Calculate Customer Lifetime Value
• Customer Lifetime Value: Why the First 100 Days Determine Everything
• Customer Lifetime Value Calculator