Skip to main content
Partner Stories

Customer Lifetime Value (CLV): What It Is, How to Calculate It, and How to Grow It

What is the customer lifetime value?

Customer lifetime value (CLV) is the total profit a business makes from one customer over the whole relationship. It answers one question: what is this customer actually worth to us?

Most dashboards treat that number as a footnote. It isn’t. A customer that costs $5,000 to win and returns $4,000 in profit over their lifetime is a $1,000 loss. Every deal like that loses money. The quarterly revenue chart won’t show it.

CLV shows three groups of what the revenue line hides:

  • CFOs see where margin actually comes from. Not where revenue comes from.
  • Sales sees which accounts deserve more attention. And which ones don’t.
  • IT sees which data needs to be connected. The rest can wait.

What is the customer lifetime value formula?

The simplest customer lifetime value formula multiplies how much a customer spends, how often they buy, how long they stay, and your profit margin:

\text{CLV} = \text{Average order value} \times \text{Purchases per year} \times \text{Years retained} \times \text{Gross margin}

Here’s a worked example. A Canadian distributor’s average customer:

orders $2,000 of product per order

orders 6 times a year

stays 5 years

at a 30% gross margin

$2,000 × 6 × 5 × 0.30 = $18,000 in lifetime profit.

Don’t know how long customers stay? Estimate it from churn: average lifespan ≈ 1 ÷ annual churn rate. A 20% churn rate means a five-year lifespan.

Finance teams often go one step further and discount future profit back to today’s value. A dollar in year five is worth less than a dollar now. That’s more accurate. It’s also not required. The simple version is enough to start making decisions.

How to track customer lifetime value in B2B

B2B is harder than retail. Retail tracks individuals. B2B tracks accounts. One “customer” can mean several buyers, several sites, several contracts, and several sets of payment terms. That data usually lives in at least three systems.

A practical B2B approach looks like this:

1. Measure at the account level. Roll up every order, invoice, and contract under one parent account.

2. Use real margin, not revenue. Include discounts, rebates, freight, and cost to serve. A big account with heavy custom terms can be less profitable than a small one.

3. Combine ERP and CRM data. Your ERP knows what customers bought and paid. Your CRM knows renewals, open opportunities, and support history. CLV needs both.

4. Track it over time. Review CLV quarterly by segment, industry, or region, and watch for accounts whose value is slipping.

5. Compare it to acquisition cost. A CLV-to-CAC ratio of around 3:1 is a common rule of thumb for healthy growth.

How to increase customer lifetime value (CLV)

You increase customer lifetime value by raising one of four levers: order size, purchase frequency, retention, or margin. Most companies get the biggest gain from retention, because keeping a customer for one more year adds a full year of profit.

• Reduce churn early. Flag accounts with falling order volumes or late payments, and have someone call them before they leave.

• Never run out of what they buy. Stockouts quietly push customers to competitors. Good demand forecasting and demand planning keep your best customers' products on the shelf.

• Cross-sell and upsell with data. Recommend products similar accounts already buy, not whatever has the highest margin.

• Make service easy. Fast answers, accurate invoices, and clear delivery dates matter more in B2B than flashy loyalty programs.

• Segment by value. Give your top 20% of accounts dedicated support, and serve low-value accounts through cheaper self-service channels.

How Microsoft Dynamics 365 helps you measure and grow CLV

CLV needs sales, finance, and customer data in one place. Most companies keep them in three. So every quarter someone stitches spreadsheets together, and the number is stale by the time it’s done.

Dynamics 365 puts that data in one ecosystem. Each application covers a different part of the problem:

Business Central holds the financial truth. For small and mid-sized businesses, that means orders, invoices, payment history, and item margins per customer. Put Power BI on top and you can build a basic CLV report from data you already have.

Dynamics 365 Sales tracks the relationship. Opportunities, renewals, and account activity. That’s what tells you whether a customer is likely to stay.

Customer Insights—Data does the forecasting. It ships with a prebuilt CLV prediction model that estimates each customer’s future value and lets you segment the high-value accounts.

Supply chain management closes the loop. Demand forecasting and demand planning mean inventory follows what your most valuable customers will actually order. Not what last year’s average says they might.

To be fair: Dynamics 365 isn’t the only route. Salesforce, HubSpot, SAP, and a solid data warehouse can all calculate CLV. Dynamics 365 makes the most sense if you already run on Microsoft tools. The ERP, CRM, and reporting data are already connected. Elsewhere, connecting them is the project.

Frequently asked questions

What is a good customer lifetime value?

A good customer lifetime value is at least three times what it costs to acquire that customer. Below 1:1, you're losing money on each new customer.

How often should you calculate CLV?

Most businesses review CLV quarterly. Fast-moving ecommerce brands may check it monthly, while B2B firms with long contracts often review it twice a year.

Is CLV based on revenue or profit?

CLV should be based on profit. Revenue-based CLV is easier to calculate, but it can make low-margin customers look far more valuable than they really are.