Ecommerce Customer Lifetime Value (CLV) Calculator

Measure customer retention value. Input average order values, repeat purchase frequency, product margins, and lifespans to resolve net customer lifetime value.

Select Retention Preset
$
#
%
yr
Share Your Feedback

Have a suggestion or found a calculation discrepancy? Let us know!

Rate this calculator (optional)
Minimum 10 chars, maximum 2,000.0 / 10

Methodology: Resolving Repeat Purchase Frequencies and Lifetime Margins

The CLV Formulas

We resolve the net customer lifetime value by multiplying transaction size, repurchase speed, and margins over customer lifespans:

Annual Revenue = AOV * Purchase Frequency
Lifetime Revenue = Annual Revenue * Lifespan
CLV = Lifetime Revenue * (Gross Margin % / 100)

In e-commerce unit economics and marketing budget auditing, Customer Lifetime Value (CLV or LTV) is the ultimate metric of store health. While paid acquisition campaigns (such as Facebook or TikTok ads) focus on generating immediate sales conversions, transactional stores that fail to drive repeat purchases must recover their entire Customer Acquisition Cost (CAC) on the first order, making ad scaling highly difficult.

By contrast, brands with high repeat purchase rates (such as coffee subscriptions or cosmetics lines) can model a customer's total value over their entire buying relationship lifespan. CLV measures this value, representing the **net profit contribution** generated after subtracting Cost of Goods Sold (COGS).

Calculating CLV requires multiplying **Average Order Value (AOV)** by annual **Purchase Frequency**, product **Gross Margin percentage**, and average **Customer Lifespan** in years. Modeling CLV accurately allows marketing teams to set a target LTV:CAC ratio (typically aiming for **3:1** or higher), establishing a sustainable customer acquisition budget.

Example Calculation Walkthrough

D2C Brand Retention Profile

Let's evaluate a D2C specialty coffee subscription brand with strong customer retention under the following parameters:

  • Average Order Value (AOV) = $75.00
  • Annual Purchase Frequency = 3.5 times per year
  • Product Gross Margin = 65%
  • Average Customer Lifespan = 3 years

Step-by-Step CLV Resolution

1. Solve for Annual Revenue contribution per customer:
$75.00 AOV * 3.5 purchases/year = $262.50 per year.

2. Solve for Lifetime Revenue contribution:
$262.50 annual revenue * 3 lifespan years = $787.50 lifetime revenue.

3. Solve for Customer Lifetime Value (Net Profit CLV):
$787.50 lifetime revenue * 65% gross margin = $511.88 CLV.

This merchant generates **$511.88 in net profit** (CLV) from a single customer over 3 years. If the store's Customer Acquisition Cost (CAC) is $150.00, the LTV:CAC ratio is **3.41:1** ($511.88 / $150.00), demonstrating a highly profitable marketing model.

The LTV:CAC Ratio and Ad Scaling Budgets

Understanding CLV allows brands to establish data-driven Customer Acquisition Cost (CAC) budgets for advertising:

LTV:CAC < 1.0: You spend more to acquire a customer than they generate in profit over their entire relationship. The store will lose money on every acquisition.

LTV:CAC = 3.0: The golden benchmark for retail brands, providing a sustainable balance between marketing cost and customer margin returns.

LTV:CAC > 5.0: Your marketing spend is highly efficient, but you may be under-spending on ads. You can afford to increase CAC bids to capture more market share.

Common Pitfalls in CLV Modeling

Calculating CLV Using Revenue Instead of Gross Profit

A common error is neglecting to multiply lifetime revenue by the product gross margin percentage. This error overestimates CLV, leading to over-spending on acquisition ads and causing cash flow deficits.

Using Simple Average Lifespans for Cohorts

Customer behavior varies significantly between cohorts. Customers acquired during holiday discount sales often have much shorter lifespans and lower repurchase rates than customers acquired at full retail price. Segment CLV calculations by cohort to get accurate data.

Guidelines for CLV Optimization
  • Gross Margin: Always base CLV on net profit dollars, not gross revenue.
  • Cohort Auditing: Track retention rates and CLV by customer acquisition cohort.
  • Retention Flows: Deploy automated email retention campaigns to extend customer lifespan.

Related Calculators

Related Articles & Guides

Financial & Valuation Disclaimer

The calculations, projections, and reports generated by BizToolkitPro are for educational and informational purposes only. They do not represent professional investment advice, financial planning, tax guidance, legal counsel, or formal business valuation.

Financial models and valuation formulas (including WACC, DCF, IRR, and NPV) rely on assumptions and inputs provided directly by the user. Actual financial markets and business metrics fluctuate; therefore, BizToolkitPro makes no warranties, express or implied, regarding the accuracy, completeness, or suitability of the outputs for any investment strategy or corporate decision.

Always perform your own independent diligence and consult with a licensed Financial Analyst, Certified Public Accountant (CPA), or certified valuation specialist before committing capital or executing corporate transactions.