LiftSignals is live. Every plan starts with a 30-day free trial — no credit card required. Start free →
Free tool · coming soon

Customer lifetime value calculator

A free CLV and LTV calculator for online stores is on its way. You don’t have to wait for the math, though: the formula, a worked example and a spreadsheet version are all below, ready to use today.

One email when it launches. No newsletter.

PREVIEW · EXAMPLE NUMBERS

Coming soon
$86.80
2.4
3
45%
Lifetime value (margin)$281

The formula

The customer lifetime value formula.

CLV = average order value × purchase frequency × customer lifespan × gross margin

Average order value
Revenue ÷ number of orders, over the same period.
Purchase frequency
Orders ÷ unique customers, per year.
Customer lifespan
How many years a typical customer keeps buying. Often estimated as 1 ÷ annual churn rate.
Gross margin
The share of revenue you keep after product costs. Leave it out to get revenue CLV instead.

Worked example

Customer lifetime value, step by step.

Illustrative store: the same one used across our platform pages. Your own numbers come from your order export.

01

Average order value$451,360 revenue ÷ 5,200 orders

$86.80

02

Purchase frequency5,200 orders ÷ 2,167 customers in a year

2.4

03

Revenue per customer, per year$86.80 × 2.4

$208.32

04

Over a 3-year lifespan$208.32 × 3

$624.96

05

After 45% gross margin$624.96 × 0.45

$281.23

Use it today

The CLV formula in a spreadsheet, ready to copy.

Type your own numbers into column B. The last two rows calculate themselves.

AB
1Average order value86.80
2Orders per customer per year2.4
3Years as a customer3
4Gross margin0.45
5Revenue CLV=B1*B2*B3
6Margin CLV=B5*B4

Works the same in Excel and Google Sheets. Formulas in orange.

Where the simple version breaks

Why one average CLV misleads.

Averages hide your best customers

A store-wide CLV of $281 blends $4,000 customers with $40 ones, so every decision built on it fits nobody.

It looks backward

The formula uses past averages. It can’t tell you whose value is rising or falling right now.

Lifespan is a guess

“Three years” is usually an assumption. Change it to two and your CLV drops by a third.

LiftSignals predicts lifetime value for every customer individually, every night, from your own orders. Predictive customer lifetime value →

FAQ · clv calculator

CLV calculator questions, answered.

Is CLV the same as LTV?

Yes. Customer lifetime value (CLV) and lifetime value (LTV) are two names for the same measure.

Should I calculate CLV on revenue or gross margin?

Margin, if you’ll use it to decide what to spend acquiring or keeping a customer. Revenue CLV overstates what a customer is worth to you.

How do I estimate customer lifespan?

A common shortcut is 1 ÷ annual churn rate: if 40% of customers don’t return in a year, lifespan is about 2.5 years. Our churn rate calculator page shows how to get that rate.

When will the calculator be available?

It’s in progress. Leave your email above and we’ll send one message when it’s live.

Can I calculate CLV for each customer, not just an average?

Not with this formula. Per-customer predictions need a model of each customer’s buying pattern, which is what LiftSignals does.