What Is Customer Lifetime Value? Calculating It From CRM Data
How to calculate customer lifetime value: the formula, required CRM fields, the ratio to acquisition cost, segment breakdowns and three ways to raise it.
Customer lifetime value is the total revenue a customer will leave with you over the life of the relationship. Decisions based on a single sale are almost always wrong: a segment that looks unprofitable on first purchase can turn out to be your most valuable group over three years. Pulling this number from your CRM changes decisions from marketing budget to pricing.
How customer lifetime value is calculated
For subscription or recurring models the base formula is: average monthly revenue multiplied by average customer lifespan in months. Lifespan itself is 1 divided by the monthly churn rate. A business losing 2 percent of customers monthly has an average lifespan of 50 months.
For one-off sales the formula changes: average order value multiplied by orders per year multiplied by average relationship length. Whichever model applies, multiply by gross margin — you should be reasoning in profit, not revenue.
Which CRM fields you need
- Customer start date: The basis of the lifespan calculation.
- Renewal or repeat purchase records: To see revenue continuity.
- Churn date and reason: To calculate the churn rate.
- Segment or industry: For breakdown analysis.
- Source channel: To compare value by acquisition channel.
Churn date is the field most often left blank. When a customer quietly drifts away nobody closes the record, so your churn rate looks lower than it is — which systematically inflates lifetime value.
The ratio that actually matters
Lifetime value is not a target on its own. It means something only against customer acquisition cost. The commonly used thresholds:
- Below 3: Growth is expensive. Either lower acquisition cost or retain customers longer.
- Between 3 and 5: A healthy range.
- Above 5: Sounds good, but usually means you are underinvesting in marketing.
Also check payback period: how many months to recover acquisition cost? Under 12 months is comfortable for most businesses; over 18 puts real strain on cash flow.
Calculate by segment, never trust the average
A single company-wide average rarely produces a decision. Repeat the calculation across these cuts:
- By company size.
- By industry.
- By acquisition channel.
- By the first product or plan purchased.
At least one of these four almost always reveals a striking difference — and that difference tells your sales team exactly who to target.
Three ways to raise lifetime value
The formula has three components, each addressed differently:
- Raise average revenue: Pricing changes, plan upgrades or cross-sell. The fastest-acting lever.
- Extend lifespan: Reduce churn. Cutting monthly churn from 2 percent to 1.5 raises average lifespan from 50 to 67 months — a 33 percent increase without a single new sale.
- Improve margin: Lower cost to serve. The component most teams forget; value rises even when revenue stays flat.
To find which lever works hardest for you, model a 10 percent improvement in each separately. The gap is usually wider than expected.
The common mistake: averaging in new customers
Including customers who are only three months old drags average lifespan down and understates value. Calculate using customers who have completed at least one renewal cycle, and track new customers as a separate cohort. Likewise, keep a handful of very large accounts out of the average — calculate the median too and read the two side by side.
Practical tip: quarterly, on one page
Do not attempt this monthly; churn fluctuates month to month and will mislead you. Report quarterly, with all four segment cuts on a single page and the prior quarter's value alongside. The direction of change drives more decisions than the absolute number.
Timely entry of renewal and churn records is the precondition here, and Closync makes those updates easy to capture by voice.
