How to Calculate CLV for Ecommerce in 5 Steps

Here's how to calculate Customer Lifetime Value (CLV) for your online store:

Find average purchase value
Calculate purchase frequency
Determine customer lifespan
Compute customer value
Calculate final CLV

The basic formula: CLV = Customer Value × Average Customer Lifespan

Quick breakdown:

Step	Formula	Example
1. Average Purchase Value	Total Revenue ÷ Number of Orders	$100,000 ÷ 1,000 = $100
2. Purchase Frequency	Number of Orders ÷ Number of Customers	1,000 ÷ 250 = 4 times/year
3. Customer Value	Average Purchase Value × Purchase Frequency	$100 × 4 = $400/year
4. Average Lifespan	Estimate based on data	5 years
5. CLV	Customer Value × Average Lifespan	$400 × 5 = $2,000

Why CLV matters:

Guides marketing spend
Shows customer loyalty
More cost-effective than acquiring new customers
Boosts profits (5% increase in retention can lead to 25-95% profit increase)

Remember:

Include customer acquisition costs
Factor in changing customer behavior
Don't overestimate customer lifespan
Consider variable costs

Keep your CLV calculations updated regularly to make smarter business decisions.

What you need before calculating CLV

Before you start crunching CLV numbers, you need to get your ducks in a row. Here's what you'll need:

Required data

To calculate CLV, you'll need these basics:

Purchase history (dates, amounts, products)
Customer details (first purchase date, contact info)
How often customers buy

Want to go deeper? Use the RFM model:

Recency: When was their last purchase?
Frequency: How often do they buy?
Monetary value: How much do they spend?

Useful tools

Here are some tools to help you gather and crunch the numbers:

1. E-commerce platform analytics

Shopify's Reports section, for example, shows order count and total sales per customer.

2. CRM systems

These give you a 360-view of customer interactions.

3. Data collection and analysis tools

CountVisits: Tracks website visitors
SEObot: Provides SEO insights

4. Spreadsheet software

For when you need to roll up your sleeves and do some manual number-crunching.

Pro tip: Keep your data clean. Remove duplicates and errors regularly. Garbage in, garbage out!

1. Find the average purchase value

Let's kick things off by calculating the average purchase value for your e-commerce store. This number tells you how much your customers typically spend per order.

Here's the simple formula:

Average Purchase Value = Total Revenue / Number of Orders

So, if you made $100,000 from 1,000 orders last month, your average purchase value would be $100.

Pro tip: Calculate this monthly to spot trends and seasonal changes.

What impacts your average purchase value? A few things:

Product mix
Pricing strategy
Upselling and cross-selling
Seasonal trends

Want to bump up that average? Try these:

Beef up your product pages
Upsell like a pro
Cross-sell during checkout
Create irresistible bundles

Check out these industry averages:

Industry	Average Order Value
Beauty	$70
Health & Fitness	$76
Fashion	$97
Home & Garden	$353

2. Work out how often customers buy

To calculate CLV, you need to know your customers' purchase frequency (PF). Here's how to figure it out:

Calculating purchase frequency

Use this formula:

Purchase Frequency = Number of Orders / Number of Unique Customers

For example: 10,000 orders from 5,000 unique customers in a year = 2 PF

This means your average customer buys twice a year.

"Purchase Frequency = number of orders (365 days) divided by number of unique customers (365 days)."

Dealing with seasonal changes

For businesses with busy and quiet seasons:

Calculate PF for each month
Average these monthly PFs
Compare to your yearly PF

This helps spot trends and plan for seasonal shifts.

Pro tip: Check your Time Between Purchases (TBP):

TBP = 365 days / Purchase Frequency

If your PF is 2, your TBP is 182.5 days. Use this to time reminder emails or offers.

Industry insights

Industry	Average Online Shopping Frequency
Groceries	Weekly
Fashion	Monthly
Electronics	Yearly
Furniture	Every 1-10 years

Your customers might not fit these averages, so always check your own data.

Boosting purchase frequency

Want customers to buy more often? Try these:

Start a loyalty program
Send targeted emails based on past purchases
Offer subscriptions for repeat-buy items

3. Figure out how long customers stay

To calculate CLV, you need to know your customer lifespan. Here's how to do it:

How to estimate customer lifespan

1. Calculate churn rate

Churn rate shows how many customers you're losing. Here's the formula:

Churn Rate = (Customers at Start - Customers at End) / Customers at Start

Let's say you had 1000 customers at the start of the year and 800 at the end:

Churn Rate = (1000 - 800) / 1000 = 0.2 or 20%

2. Use churn rate to estimate lifespan

Now, use this formula:

Customer Lifespan = 1 / Churn Rate

In our example: 1 / 0.2 = 5 years

3. Analyze cohorts

Group customers who started buying at the same time. Track how long they stick around. It's more accurate than just looking at overall numbers.

Cohort Start Date	% Active After 1 Year	% Active After 2 Years	% Active After 3 Years
January 2020	70%	50%	35%
January 2021	75%	55%	-
January 2022	80%	-	-

Watch out for these pitfalls

1. New vs. old customers

New customers often bail faster than your loyal ones. It can mess up your calculations.

2. Industry differences

Customer lifespan varies A LOT by industry:

Industry	Average Customer Lifespan
Groceries	20+ years
Fashion	3-5 years
Electronics	7-10 years

3. Changes over time

What worked last year might not apply now. Keep an eye on trends.

4. Data quality

Garbage in, garbage out. Make sure your tracking is on point.

Want better estimates? Try these:

Use a solid customer service system
Look at different customer groups separately
Check your numbers regularly
Ask customers for feedback

4. Calculate customer value

Time to figure out what your customers are worth. This step combines purchase value and frequency to determine a customer's value.

Customer value formula

Here's the basic formula:

Customer Value = Average Purchase Value × Average Purchase Frequency

Let's use an example:

Your online jewelry store's data shows:

Average Purchase Value: $75
Average Purchase Frequency: 3 times per year

So, your customer value is:

$75 × 3 = $225 per year

Each customer brings in $225 annually.

Don't forget profit margins

The basic formula is a start, but it doesn't show the whole picture. To get more accurate, factor in your profit margins.

Here's how:

1. Calculate your gross profit margin

2. Apply it to your customer value

Let's say your gross profit margin is 40%. Your adjusted customer value would be:

$225 × 40% = $90 per year

This $90 is the actual profit each customer brings in annually.

Metric	Value
Average Purchase Value	$75
Average Purchase Frequency	3 times/year
Basic Customer Value	$225/year
Gross Profit Margin	40%
Adjusted Customer Value	$90/year

Including profit margins gives you a clearer view of each customer's worth. This helps you make smarter decisions about where to spend your marketing dollars and how to keep customers coming back.

sbb-itb-b8bc310

5. Work out the final CLV

Let's put it all together and figure out the Customer Lifetime Value (CLV) for your e-commerce business.

Combining all the parts

Here's the simple formula we'll use:

CLV = Customer Value × Average Customer Lifespan

Let's stick with our jewelry store example:

Customer Value: $90 per year
Average Customer Lifespan: 5 years

CLV = $90 × 5 = $450

So, each customer is worth about $450 to your business over their entire relationship with you.

Here's a quick breakdown:

Metric	Value
Average Purchase Value	$75
Purchase Frequency	3 times/year
Customer Value (per year)	$90
Average Customer Lifespan	5 years
Customer Lifetime Value	$450

What does CLV mean for your business?

Your $450 CLV shows what you can expect from a typical customer over time. This number is super helpful for:

Customer acquisition: If you're spending $100 to get a new customer, your $450 CLV looks pretty good.
Marketing budget: Knowing your CLV helps you decide how much to spend on marketing.
Customer segments: Calculate CLV for different groups to spot your VIP customers.
Product development: Use CLV to guide decisions on new products that could boost customer value.
Customer service: Justify spending more on customer service by showing how it can increase CLV.

More complex CLV calculations

As your e-commerce business grows, you'll need smarter ways to predict customer value. Let's look at two key methods:

Predicting future CLV

Advanced math models can give you a clearer picture of future customer value. These models factor in:

How customer behavior changes over time
The effect of your marketing efforts
Economic shifts

One popular method? The Cohort Approach. Here's how it works:

1. Group customers who joined at the same time

2. Track their spending over several years

3. Use this data to predict future spending for new customers

Let's say you run an online clothing store. Your data might look like this:

Cohort	Year 1 Spend	Year 2 Spend	Year 3 Spend
2020	$100	$150	$200
2021	$120	$180	?
2022	$150	?	?

This helps you guess what newer groups might spend down the line.

Breaking customers into groups

Splitting your customers into categories can sharpen your CLV calculations. You might group them by:

How often they buy
How much they spend per order
What types of products they buy

Here's what that might look like:

Customer Group	Avg. Order Value	Purchase Frequency	Predicted CLV
VIP	$200	12 times/year	$12,000
Regular	$100	6 times/year	$3,000
Occasional	$50	2 times/year	$500

Understanding these groups helps you tailor your approach. You might focus on keeping VIPs happy while trying to turn Occasional buyers into Regulars.

Using CLV in your online store

Improving marketing with CLV

CLV data can supercharge your marketing. Here's how:

1. Target high-value customers

Use CLV to find your best customers. Then, shower them with attention.

Take Blume, a body care brand. They use "Blume Bucks" to keep top spenders coming back. Customers earn points for actions and trade them for free stuff. Smart, right?

2. Tailor your approach

Group customers by CLV. Then, create custom marketing plans.

Group	Avg. Order	Buys Per Year	Marketing Tactics
VIP	$200	12	Exclusive deals, early product access
Regular	$100	6	Personalized product suggestions
Occasional	$50	2	Re-engagement campaigns, special offers

3. Boost ad spend ROI

CLV helps you figure out how much to spend on new customers while staying profitable.

Keeping customers longer

Want customers to stick around? Try these:

Smooth onboarding

Bad onboarding = 23% customer loss. Make it easy for newbies to start using your stuff.

Top-notch support

Be there when customers need help. Set up live chat, 24/7 support, and a knowledge base. Fun fact: 91% of customers love using a knowledge base if it's there.

Stay in touch

Send regular, helpful emails. Sell accounting software? Weekly emails showing money saved could work wonders.

Ask what they think

Use surveys, then act on feedback. It shows you care and helps you improve.

Build a community

Create a space for customers to connect. A Facebook group or website forum can make customers feel part of something bigger.

Mistakes to avoid when calculating CLV

When figuring out CLV for your online store, watch out for these common slip-ups:

Forgetting about customer acquisition costs

Don't leave out how much it costs to get new customers. This can make your CLV look better than it really is.

A high-profile Australian liquor business made this exact error. They didn't count all their customer acquisition costs, which led to skewed calculations. After fixing this:

19.1% of customers drove 77.4% of revenue

By focusing on this group, sales jumped 19.7% in just two months

Always include the full cost of getting new customers in your CLV math.

Not considering changes in customer behavior

Customer habits change over time. If you don't keep up, your CLV numbers can get way off.

A Canadian catering firm learned this the hard way:

They hadn't updated their CLV for years

After recalculating, they discovered 19.3% of customers made up 81.7% of revenue

By shifting focus to this group, they cut churn by 16.4% and boosted sales by 34.1% in one quarter

Keep your CLV calculations fresh. Update them regularly to reflect how your customers' buying habits change.

Overestimating customer lifespan

It's easy to be too optimistic about how long customers will stick around. This can inflate your CLV and lead to financial headaches down the road.

To get it right:

Look at your actual customer data
See how long people typically stay with your store
Use this real number in your calculations, not a guess

Ignoring variable costs

Some store owners only look at revenue when calculating CLV. But this misses a big piece of the puzzle: variable costs.

What to include	What to avoid
Product costs	Fixed overhead
Shipping fees	One-time expenses
Transaction fees	Sunk costs

By factoring in these costs, you'll get a more accurate picture of each customer's true value to your business.

A "CLV-to-CAC" ratio based only on revenue doesn't tell the whole story. It's practically useless without considering variable costs.

Wrap-up

Let's review how to calculate CLV for your e-commerce business:

Find average purchase value
Calculate purchase frequency
Determine customer lifespan
Compute customer value
Calculate final CLV

The basic formula: CLV = Customer Value × Average Customer Lifespan

Calculating CLV isn't a one-off task. It needs regular updates because:

Customer behavior changes
Market conditions shift
Your business evolves

Updating CLV regularly helps you:

Spot value trends
Adjust marketing strategies
Improve acquisition and retention decisions

Take Starbucks, for example. They found their average American customer's CLV is $32,000. How? They looked at:

Average order: $3.5
Lifetime orders: About 9,100

This analysis helps Starbucks fine-tune their marketing and customer experience.

CLV Update Benefit	Business Impact
Better segmentation	Targeted marketing
Improved forecasting	Effective resource use
Early churn detection	Proactive retention

"CLV is crucial for eCommerce. It shows the long-term value of customers." - Khalid Saleh, Author

FAQs