How to Calculate Customer Lifetime Value (LTV) for E-commerce

How much can you afford to spend acquiring a customer? The answer depends on how much that customer will be worth over their entire relationship with your business. Customer Lifetime Value (LTV or CLV) quantifies this relationship value - and it's the foundation for sustainable growth.

Research shows acquiring a new customer costs 5-25x more than retaining an existing one. Understanding LTV helps you invest appropriately in both acquisition and retention.

What is Customer Lifetime Value?

Definition

Customer Lifetime Value is the total revenue a business can expect from a single customer account throughout the business relationship. It considers purchase frequency, average order value, and customer lifespan.

LTV shifts focus from single transactions to ongoing relationships. A customer who makes five $50 purchases is worth more than one who makes a single $200 purchase and never returns.

Why LTV Matters

LTV informs critical business decisions: how much to spend acquiring customers, which customer segments to prioritize, where to invest in retention, and product and pricing strategy.

Without LTV, you risk overspending on acquisition for low-value customers or underinvesting in high-value segments.

Basic LTV Formulas

Simple Historic LTV

The simplest calculation uses historical data:

**LTV = Average Order Value x Purchase Frequency x Customer Lifespan**

For example: $75 average order x 3 purchases per year x 4 year lifespan = $900 LTV

This straightforward approach works for businesses with stable customer behavior patterns.

Revenue-Based LTV

**LTV = Total Revenue from Customer Cohort / Number of Customers in Cohort**

Take all customers acquired in a specific period, sum their total lifetime revenue, divide by customer count. This gives actual historic LTV for that cohort.

Margin-Based LTV

Revenue-based LTV overstates customer value if your margins are tight. For more accuracy:

**LTV = (Average Order Value x Gross Margin %) x Purchase Frequency x Customer Lifespan**

This calculates contribution margin rather than revenue, showing actual profit from customer relationships.

Advanced LTV Models

Cohort-Based LTV

Cohort analysis calculates LTV by customer acquisition period. Compare customers acquired in January vs February vs March to see how LTV varies.

This reveals whether customer quality is improving or declining over time and helps identify which acquisition channels bring higher-value customers.

Predictive LTV

Historic LTV looks backward. Predictive LTV estimates future value for customers with incomplete histories.

Basic predictive models use average purchase frequency to project future purchases, recency to adjust for churn probability, and customer tenure to weight predictions.

More sophisticated models use machine learning on behavioral data to predict individual customer trajectories.

Probabilistic Models

Statistical models like BG/NBD (Beta-Geometric/Negative Binomial Distribution) estimate LTV considering the probability a customer is still "alive" (active), their expected future transaction rate, and expected transaction value.

These models handle the uncertainty inherent in predicting human behavior.

Calculating LTV Components

Average Order Value (AOV)

**AOV = Total Revenue / Number of Orders**

Calculate over a consistent time period. Segment by customer type if new customers behave differently from returning customers.

Purchase Frequency

**Purchase Frequency = Number of Orders / Number of Unique Customers**

This gives average purchases per customer over your measurement period. For annualized frequency, use a full year of data.

Customer Lifespan

Customer lifespan is harder to measure because many customers are still active. Options include defining lifespan as time from first to last purchase, using a cohort approach (average active lifespan for completed cohorts), or setting a churn threshold (no purchase in X months = churned).

For subscription businesses, average subscription duration is straightforward. For transaction-based businesses, defining "churned" requires judgment.

Churn Rate

**Churn Rate = Customers Lost / Total Customers at Start of Period**

Customer lifespan relates inversely to churn: **Average Lifespan = 1 / Churn Rate**

If 25% of customers churn annually, average lifespan is 4 years.

LTV to CAC Ratio

The Critical Metric

LTV alone isn't enough - it must be compared to Customer Acquisition Cost (CAC). The LTV:CAC ratio determines whether your business model is sustainable.

**LTV:CAC = Customer Lifetime Value / Customer Acquisition Cost**

Interpreting the Ratio

**LTV:CAC < 1** means you're losing money on every customer acquired. Unsustainable unless you can improve retention or reduce acquisition costs.

**LTV:CAC = 1-3** suggests tight margins. Profitable but vulnerable to cost increases or behavior changes.

**LTV:CAC = 3-5** is generally healthy. You're earning good returns on acquisition investment.

**LTV:CAC > 5** may indicate underinvestment in growth. You could potentially spend more on acquisition and grow faster.

Payback Period

Beyond the ratio, consider how quickly you recover acquisition costs:

**Payback Period = CAC / (AOV x Gross Margin x Purchase Frequency)**

Shorter payback periods reduce risk and improve cash flow.

Segmenting LTV

By Acquisition Channel

Calculate LTV separately for customers from different channels: organic search, paid search, social media, email, and referral. Some channels attract higher-value customers despite higher acquisition costs.

Attribution data connects customers to their acquisition source for accurate channel LTV.

By Product Category

First purchase category often predicts lifetime value. Customers who start with your hero product may have different trajectories than those who start with accessories.

By Customer Behavior

Segment by early behaviors that predict long-term value: time to second purchase, engagement level, product diversity in early orders, and response to marketing.

Identify patterns that signal high-LTV customers and invest in nurturing similar prospects.

Using LTV in Decisions

Acquisition Spending

If you know LTV is $500 with 20% margin, you can afford up to $100 CAC and still break even. Target a 3:1 ratio, and your max CAC is $33.

Set channel-specific CAC targets based on channel-specific LTV.

Retention Investment

Improving retention by 5% can increase profits by 25-95%. LTV quantifies this: if extending average lifespan from 3 to 4 years increases LTV by 33%, significant retention investment is justified.

AI-powered churn prevention becomes easier to justify when you understand customer value.

Customer Service Priority

High-LTV customers deserve higher service levels. Consider priority support, proactive outreach, and exclusive perks for your most valuable customers.

Pricing Strategy

LTV helps evaluate pricing changes. A price increase that reduces purchase frequency might still improve LTV if the margin increase outweighs volume decline.

Implementation

Data Requirements

Calculating LTV requires customer-level order history including customer ID, order dates, order values, and product details. Connect this with acquisition source for channel LTV.

Most e-commerce platforms store this data - the challenge is extracting and analyzing it consistently.

Calculation Frequency

Recalculate LTV periodically to catch changes in customer behavior. Monthly cohort analysis and quarterly LTV reviews work for most businesses.

Tracking Changes

Monitor LTV trends over time. Declining LTV may indicate product issues, competitive pressure, or customer mix changes. Rising LTV suggests improving retention or AOV.

Common Mistakes

Ignoring Cohort Differences

Averaging LTV across all customers masks important variation. Recent customers haven't had time to demonstrate full value. Channel mix changes affect overall LTV. Seasonal cohorts behave differently.

Always segment LTV analysis.

Using Revenue Instead of Margin

Revenue-based LTV overstates value for low-margin businesses. If your gross margin is 30%, revenue-based LTV is 3x higher than reality.

Short Measurement Windows

New e-commerce businesses lack long customer histories. LTV calculated on 6 months of data may miss repeat purchases that happen at month 8 or 12.

Use longer windows when possible, and flag short-window estimates as preliminary.

Forgetting Time Value of Money

$100 today is worth more than $100 in three years. Sophisticated LTV models discount future revenue to present value.

For many e-commerce contexts, this refinement is less critical than getting basic LTV right.

Getting Started

Start with simple calculations. Take customers acquired 2+ years ago. Calculate their total revenue and divide by customer count. That's your historic LTV baseline.

Then add sophistication: segment by channel, calculate margin-based LTV, compare to CAC.

Arktis tracks attribution and customer journeys to power accurate LTV calculations across channels.

Sources

1. Harvard Business Review, "The Value of Keeping the Right Customers"

2. Shopify, "Customer Lifetime Value"

3. McKinsey, "Value Creation Through Customer Analytics"

4. Wharton, "Customer Lifetime Value Models"