← All blog posts

Customer lifetime value: common mistakes and how to avoid them

WhiteUI · A plain-English guide to customer lifetime value calculator

Most wrong answers come from a small set of slips, not from hard maths. Here are the ones to watch for, with the correction for each.

Using revenue where profit was meant. This formula gives lifetime revenue per customer, not lifetime profit. A customer worth ₹24,000 in revenue at a 40% margin is worth ₹9,600 in gross profit. Quoting ₹24,000 as profit overstates the figure by two and a half times.

Guessing the lifespan. Lifespan is the hardest input to know and the one the answer is most sensitive to: doubling it from 3 years to 6 doubles the result, from ₹24,000 to ₹48,000. Use observed retention — how long past customers actually stayed — not a hopeful round number.

Averaging very different customers together. A café regular buying weekly and a one-time gift buyer averaged together give a customer who does not exist. Segment first — regulars and occasional buyers separately — then calculate lifetime value for each group.

Worked example to test yourself against: An average purchase of ₹2,000, bought 4 times a year, over a 3-year lifespan gives 2,000 × 4 × 3 = ₹24,000 of lifetime value per customer. A second example: ₹500 × 6 purchases a year × 2 years gives 500 × 6 × 2 = ₹6,000. A third check: ₹1,200 × 12 purchases a year × 5 years gives 1,200 × 12 × 5 = ₹72,000 — the high frequency and long lifespan matter far more than the single order value. If your calculator gives a different answer for those inputs, one of the slips above is almost certainly the cause.

A note on scope: this guide is for planning and estimation only — it is not financial advice. The figures here describe revenue per customer, not profit, and real customer behaviour varies far more than any single formula suggests.

Frequently asked questions

What is the single most common mistake?

Entering a number in the wrong unit, or dividing the wrong way round. Convert to the base unit first, every time.

How do I catch a mistake before it matters?

Sanity-check the answer: does it sit in a plausible range, and does changing one input move it in the direction you expect?

What if my result looks wrong?

Re-read each field and its unit first. Most wrong results come from a mistyped number or a wrong unit, not from the calculator itself.

More guides on the Customer Lifetime Value Calculator

Try it yourself

Enter average purchase value, purchases per year and customer lifespan to see lifetime value.

Open the Customer Lifetime Value Calculator