Customer Lifetime Value (CLV) Calculator

Customer Lifetime Value (CLV) is a predictive metric that estimates the total gross revenue a single customer will generate throughout their entire relationship with your brand. By understanding CLV, marketing teams can justify spending more on initial Customer Acquisition Costs (CAC), confidently scaling campaigns on platforms like Meta and Google Ads based on long-term cohort profitability.

How do you use this CLV calculator?

1. Enter AOV: Input the average amount a customer spends per transaction.
2. Enter Purchases Per Year: Input the average frequency of repeat orders annually.
3. Enter Lifespan: Input the estimated number of years a customer stays active.
4. Project Revenue: The calculator will instantly output the projected Lifetime Value for your average customer.

What is CLV and how does it drive marketing strategy?

Relying solely on first-purchase profitability limits scale. Mature brands use CLV modeling to understand:

• Average Order Value (AOV): The baseline transaction amount.
• Purchase Frequency: The velocity at which customers return to buy again.
• Customer Lifespan: The average number of years a customer remains active before churning.
• LTV:CAC Ratio: The gold standard metric comparing the lifetime value against the cost to acquire them (a 3:1 ratio is considered healthy).

How do you calculate Customer Lifetime Value?

The standard heuristic formula for historical CLV multiplies the customer’s value by their average lifespan.

• Customer Value = Average Order Value (AOV) * Annual Purchase Frequency
• CLV = Customer Value * Average Customer Lifespan (in Years)

For advanced analysts building cohort models in SQL, a historical LTV calculation looks like this:

SELECT 
    cohort_month,
    COUNT(DISTINCT customer_id) as total_customers,
    SUM(total_revenue) / COUNT(DISTINCT customer_id) AS historical_clv
FROM 
    customer_transactions
GROUP BY 
    cohort_month
ORDER BY 
    cohort_month DESC;

Why use CLV instead of First-Order Revenue?