EN
Bookkeeping

How to Calculate Customer Lifetime Value (CLV)? The LTV Formula in E-commerce, the CLV/CAC Ratio and an Example Calculation

How do you calculate customer lifetime value (CLV/LTV)? The formula for e-commerce, a profit-based example calculation, the CLV/CAC ratio, CLV by segment and common mistakes.

Contents 12 sections
  1. What is customer lifetime value (CLV)?
  2. What data do you need to calculate CLV?
  3. How is customer lifetime value calculated?
  4. What is the CLV/CAC ratio, and what should it be?
  5. How does the retention rate affect CLV?
  6. How is CLV calculated by customer group?
  7. What is the difference between historical CLV and predictive CLV?
  8. How is CLV calculated step by step?
  9. How do you increase customer lifetime value?
  10. What are the most common mistakes when calculating CLV?
  11. How does NetKasam help with calculating CLV?
  12. Frequently Asked Questions About Customer Lifetime Value

The most expensive asset of an e-commerce business is not its inventory or its advertising budget but its customers. You spend money on ads, discounts and shipping campaigns to bring in the first order; whether that spending pays back is determined not by a single order but by the total profit the customer leaves during the time they stay with you. Customer lifetime value (CLV or LTV) measures exactly this total. A seller who correctly answers the question of how to calculate customer lifetime value knows the most they can spend to win a customer, which customer group to invest in and which campaign is actually losing money.

In this guide, we explain with numbers what CLV is, how it is calculated on profit instead of revenue, a fully worked example, the ratio between CLV and customer acquisition cost (CAC), the difference in CLV across customer groups and the most effective ways to increase CLV. At the end you will find common mistakes, frequently asked questions and how the data needed for the calculation is collected in NetKasam.

What is customer lifetime value (CLV)?

In short: Customer lifetime value (CLV; LTV for short) is the total profit left from all the purchases a customer makes for as long as their relationship with your business lasts. It shows the value not of a single order but of the entire customer relationship.

In e-commerce, we make most decisions based on a single order: "What did I earn from this basket?" Yet a customer who generates a loss on the first order but comes back four times a year is far more valuable than a customer who leaves a profit on the first order and never returns. CLV makes this difference visible. It answers three questions:

  • What is the most I can spend to win a customer? The upper limit of the advertising and campaign budget comes from CLV.
  • Which customers should I prioritize? The CLV gap between customer groups often exceeds tenfold.
  • Is my business growing profitably as it grows? If CLV is falling while the number of orders rises, growth is being paid for out of future profit.

Because CLV measures the customer relationship, it is the core number of the CRM (customer relationship management) approach; the results of work on customer churn, repeat purchases and loyalty ultimately show up in this single figure.

What data do you need to calculate CLV?

In short: Four pieces of data are enough: average order value excluding VAT, annual number of orders per customer, contribution margin per order and annual retention rate. All of these can be pulled from your sales, invoice and account records.

DataHow do you find it?Sample value
Average order value (AOV)Period revenue (excluding VAT) ÷ number of orders600 ₺
Annual number of ordersAnnual number of orders ÷ number of unique customers who made purchases3 orders
Contribution margin(Revenue − product cost − commission − shipping and packaging) ÷ revenue%25
Annual retention rateCustomers who shopped last year and again this year ÷ last year's customers%50
Customer acquisition cost (CAC)Marketing and advertising spend ÷ number of new customers300 ₺

The sample values in the table are chosen only to illustrate the method. Most mistakes are made in the contribution margin: contribution margin is not gross profit margin; in addition to product cost, every variable cost tied to the order (marketplace commission, payment commission, shipping, packaging, return allowance) is deducted. For the difference between margins, see our article how to calculate profit margin, and for details of marketplace costs, the guide how to calculate net profit on a marketplace.

How is customer lifetime value calculated?

In short: The contribution profit per order (average order value × contribution margin) is multiplied by the annual number of orders to find the customer's annual contribution; this amount is multiplied by the average number of years the customer stays. Customer lifetime is estimated with the formula 1 ÷ (1 − annual retention rate).

FormulaSix formulas for customer lifetime value
  1. Contribution per order = Average order value (excluding VAT) × Contribution margin
  2. Annual contribution = Contribution per order × Annual number of orders
  3. Customer lifetime (years) = 1 ÷ (1 − Annual retention rate)
  4. CLV = Annual contribution × Customer lifetime
  5. CLV/CAC ratio = CLV ÷ Customer acquisition cost
  6. Payback period (months) = CAC ÷ (Annual contribution ÷ 12)

All amounts exclude VAT. The retention rate should be measured annually; if a monthly rate is used, lifetime also comes out in months.

Let's do the calculation step by step with the sample values in the table:

  1. Contribution per order: ₺600 × 25% = ₺150
  2. Annual contribution: ₺150 × 3 orders = ₺450
  3. Customer lifetime: 1 ÷ (1 − 0.50) = 2 years
  4. CLV: ₺450 × 2 = ₺900
  5. CLV/CAC: 900 ÷ 300 = 3
  6. Payback period: 300 ÷ (450 ÷ 12) = 300 ÷ 37.5 = 8 months

Over two years, this customer places six orders on average and generates ₺3,600 in revenue. But the contribution the business keeps is ₺900; after deducting the acquisition cost, the customer's net value drops to ₺600:

The value of one customerFrom ₺3,600 in revenue to ₺600 in net customer value
  1. Two-year revenue (6 orders × ₺600)₺3,600
  2. Product cost (50%)−₺1,800
  3. Marketplace and payment commission (15%)−₺540
  4. Shipping and packaging (10%)−₺360
  5. CLV (contribution profit)₺900
  6. Customer acquisition cost (CAC)−₺300
  7. Net customer value₺600

Prepared with sample values; amounts exclude VAT. Overheads (rent, staff, software) are reflected not in CLV but in the business's profit for the period.

The waterfall shows the most important distinction in the CLV calculation: the same customer is worth ₺3,600 when viewed on revenue and ₺900 when viewed on contribution. A business that plans its advertising budget based on ₺3,600 loses money on every new customer.

What is the CLV/CAC ratio, and what should it be?

In short: The CLV/CAC ratio is the total contribution a customer leaves divided by the amount spent to win them. In e-commerce, the widely accepted target is around 3: below 1 means a loss on every customer, while well above 3 may mean a growth opportunity is being missed.

CLV/CAC ratioMeaningWhat should you do?
Below 1The customer does not pay back the cost of winning themStop ad spending, review margin and retention
1 – 2The cost pays back, but nothing is left to cover overheadsIncrease order value and repeat purchases, cut expensive channels
About 3Healthy balanceTrack the ratio by channel, grow the good channels
5 and aboveVery profitable, but too little may be spent on acquiring customersTry increasing the advertising budget in a controlled way

The reverse of the ratio is also useful: if your target ratio is 3, the most you can spend on a customer is CLV ÷ 3. In the example, 900 ÷ 3 = ₺300. If an advertising channel brings in a new customer for ₺450, the ratio drops to 2; this channel grows revenue but not profit.

The payback period is as important as the ratio. In the example, the customer acquisition cost pays back in 8 months; during this time, the money spent on advertising has left the business as cash. Businesses that grow fast but have a long payback period can face a cash crunch even if they are profitable. To plan the cash side, see our article how to prepare a cash flow statement.

Takeaways from the exampleOne customer, four critical numbers
  • ₺900customer lifetime value based on contribution profit
  • ₺3,600two-year revenue of the same customer
  • 3CLV/CAC ratio (with an acquisition cost of ₺300)
  • 8 monthspayback period of the acquisition cost

How does the retention rate affect CLV?

In short: Because the retention rate directly determines customer lifetime, it is the strongest lever of CLV. In the example, when the retention rate rises from 50% to 60%, customer lifetime goes from 2 years to 2.5 years and CLV rises from ₺900 to ₺1,125; increasing order value by the same proportion does not have this much impact.

When we change only the annual retention rate and keep everything else constant, the same customer's value changes as follows:

ScenarioCLV by annual retention rate (annual contribution ₺450)
  1. 30% retention (lifetime 1.43 years)₺643
  2. 40% retention (lifetime 1.67 years)₺750
  3. 50% retention (lifetime 2 years)₺900
  4. 60% retention (lifetime 2.5 years)₺1,125
  5. 70% retention (lifetime 3.33 years)₺1,500

Calculation: ₺450 × 1 ÷ (1 − retention rate); amounts are rounded.

The curve in the chart is not linear: as the retention rate rises, the value of each additional point increases. Going from 60% to 70% adds ₺375 to CLV, while going from 30% to 40% adds ₺107. That is why preventing the loss of an already loyal customer is often more profitable than winning a new one.

For comparison, suppose we increase order value by 10%: ₺660 × 25% × 3 × 2 = ₺990. CLV rises by 10%. Increasing retention by 10 points, on the other hand, raises CLV by 25%. Of course, both can be done together; but this difference should be kept in mind when setting priorities.

How is CLV calculated by customer group?

In short: Customers are divided into groups by order frequency and retention rate, and CLV is calculated separately for each group. Average CLV is often misleading; a few loyal customer groups can carry more than half of the total value.

Let's divide a sample store with 1,000 customers into three groups. Contribution margin is assumed to be 25% in each group:

GroupCustomerAnnual ordersAverage basketAnnual contributionRetentionLifetimeCLV
Loyal1506700 ₺1.050 ₺%754 years4.200 ₺
Regular3503600 ₺450 ₺%502 years900 ₺
One-time5001500 ₺125 ₺%201.25 years156 ₺

The total value of each group is found by multiplying the number of customers by CLV: the loyal group ₺630,000, the regular group ₺315,000 and the one-time group about ₺78,000. The distribution of total value is as follows:

DistributionDistribution of the total lifetime value of 1,000 customers across groups
  • Loyal customers (150 people)₺630,00061.6%
  • Regular customers (350 people)₺315,00030.8%
  • One-time customers (500 people)₺78,1257.6%

Prepared with sample values. 15% of customers carry about 62% of the total value.

This table leads to three decisions. First, losing a loyal customer is more than four times as costly as losing an average customer (₺1,023); that is why special pricing, fast delivery and priority support for them are an investment, not a cost. Second, the value of a one-time customer is ₺156; campaigns that win this group at ₺300 lose money. Third, the biggest opportunity is often moving a one-time customer to a second order. For a similar grouping on the product side, see our article how to do an ABC analysis, and for customer grouping methods, the glossary page what is customer segmentation in e-commerce.

What is the difference between historical CLV and predictive CLV?

In short: Historical CLV is the actual contribution profit a customer has left so far; predictive CLV is an estimate of the total contribution they will leave in the future, based on average order value, frequency and retention rate. The historical value is precise but late; the predictive value is early but based on assumptions.

Historical CLV is the most reliable way to rank existing customers and find the loyal group: the contribution profit from each customer's orders to date is added up. Predictive CLV is needed for forward-looking decisions: you want to know, right after the first orders, how valuable the customers brought in by a new advertising channel will be.

The most practical way to combine the two is cohort tracking: you follow customers who placed their first order in the same month as a group and record their total contribution at months 3, 6 and 12. Once a few cohorts have accumulated, you can estimate the 12-month value of new customers quite well from the first 3 months of data. For details of the method, see our article customer movement and behavior analysis with cohort analysis.

There is one more point with long-lived customers: ₺100 earned today and ₺100 to be earned three years from now are not of equal value. In groups with a long lifetime, a more cautious CLV can be found by discounting future years' contribution to the present with a discount rate. For most small and mid-sized e-commerce businesses, the simple formula is enough to make decisions; what matters is applying the same method consistently every period.

How is CLV calculated step by step?

In short: Take the last 12 months of sales and expense data, extract the number of orders and revenue per customer, calculate the contribution margin, measure the retention rate, calculate CLV by group and compare it with CAC. Repeat the calculation every quarter.

Step by stepSix steps to calculating CLV with your own data
  1. 01
    Collect the dataPull the last 12 months of orders with customer, date and amount excluding VAT.
  2. 02
    Find the contribution marginDeduct product cost, commission, shipping, packaging and return allowance from revenue.
  3. 03
    Summarize by customerExtract each customer's number of orders, revenue and first and last order dates.
  4. 04
    Measure retentionFind the share of last year's customers who also shopped this year.
  5. 05
    Calculate by groupCalculate CLV separately for loyal, regular and one-time customers.
  6. 06
    Compare with CACCompare each advertising channel's new customer cost with the CLV of the relevant group.

Tracking customers from marketplaces and from your own site separately lets you see the real value of each channel.

Pay attention to two points to keep the calculation sound. Returns should be deducted from revenue; a returned order leaves neither revenue nor contribution and also creates two-way shipping costs. A discounted first order should also be recorded at its actual amount; coupon and campaign discounts are either deducted from the contribution or added to CAC, not both.

How do you increase customer lifetime value?

In short: Each of the four factors in the CLV formula is a lever: average order value, order frequency, contribution margin and retention rate. The fastest impact usually comes from retention and conversion to a second order.

LeverExamples in practiceImpact in the example
Retention rateOn-time and accurate delivery, fast returns, post-order updates, smooth support50% → 60%: CLV ₺900 → ₺1,125
Order frequencyReorder reminders for used-up products, complementary product recommendations, a regular campaign calendar3 → 4 orders a year: CLV ₺900 → ₺1,200
Average basketProduct bundles, a free shipping threshold, cross-selling₺600 → ₺660: CLV ₺900 → ₺990
Contribution marginCorrect pricing, lower shipping costs, a lower return rate25% → 28%: CLV ₺900 → ₺1,008

Operations are at the core of retention: a product that shows as in stock but cannot be shipped, an invoice issued late or an order sent incorrectly loses the customer before the second order. That is why CLV is the shared result not only of the marketing team but also of inventory, order and accounting processes. For marketing methods that bring customers back, see our article how do you get customers who have shopped to visit your site again.

A note for businesses selling on marketplaces: the rules for direct communication with marketplace customers are restricted by each marketplace. Here, repeat purchases are driven by store rating, reviews, fast and accurate delivery and the quality of the product page. Keeping marketplace customers separate from your own site's customers in the CLV calculation lets you compare the real value of the two channels.

What are the most common mistakes when calculating CLV?

In short: The most common mistakes are calculating CLV on revenue, using amounts including VAT, not deducting returns, using a single average for all customers and underestimating CAC.

  1. Mistaking revenue for CLV. In the example, the revenue-based value is ₺3,600 and the contribution-based value is ₺900. The CLV/CAC ratio calculated on revenue comes out at 12 and pushes the business to overspend on advertising.
  2. Calculating with amounts including VAT. VAT is not the business's income; when it is included, order value and CLV are artificially inflated.
  3. Not deducting returns and cancellations. In categories with a high return rate, CLV can appear 20%–30 higher if returns are not deducted.
  4. Using a single average. The average of loyal and one-time customers represents no one; the budget goes to the wrong group.
  5. Counting only ad spend as CAC. First-order discounts, coupons and campaign costs are also customer acquisition costs.
  6. Writing down the retention rate as a guess. The assumption "probably 70% stay" can double CLV; the rate should be measured from records.
  7. Doing the calculation once and leaving it. Commissions, shipping fees and customer behavior change; CLV should be recalculated every quarter.

Similar mistakes also appear in the business's overall profitability calculation. To know after how many sales you will break even, see how to calculate the break-even point, and for the definition of net profitability, the what is net profit margin page.

How does NetKasam help with calculating CLV?

The hard part of calculating CLV is not the formula but scattered data: orders sit on different marketplaces, invoices in one place and customer balances in another. NetKasam brings this data together in one panel:

  • Orders on one screen. With marketplace integration and e-commerce integrations, orders from all channels are collected on the same screen and invoiced automatically; they are tracked with their statuses on the order management screen.
  • Unlimited customer records. With customer and supplier account tracking, you can create as many customers as you like, import your existing customers from Excel, filter your customers and set discounts and campaigns individually or in groups. Giving a special price to the loyal customer group is thus a single setting.
  • Reports and export. On the reports screen, you create reports based on the filters and criteria you set, save the reports you run regularly and export them to Excel. You can prepare the per-customer order and revenue summary for the CLV calculation with this data.
  • Bookkeeping is free. e-Invoice, e-Archive invoice, customer and supplier accounts, inventory, cash, bank and expense tracking are always free; details of the marketplace and e-commerce integration plans are on the pricing page.

Frequently Asked Questions About Customer Lifetime Value

How is customer lifetime value calculated?

CLV = Average order value × Annual number of orders × Contribution margin × Customer lifetime. Customer lifetime is found with 1 ÷ (1 − annual retention rate). In the example, ₺600 × 3 × 25% × 2 years = ₺900.

Are CLV and LTV the same thing?

Yes. CLV (Customer Lifetime Value) and LTV (Lifetime Value) are two abbreviations for the same concept; both refer to the total value a customer leaves over the course of the relationship.

Should CLV be calculated on revenue or on profit?

On profit. Revenue-based CLV ignores costs such as product cost, commission and shipping, so it overstates the customer's value several times over and leads to a poorly planned advertising budget.

What is a good CLV/CAC ratio?

In e-commerce, the common target is around 3. Below 1 means a loss on every customer; well above 5 may indicate that too little is being spent on acquiring customers.

How is the retention rate measured?

The number of customers who shopped last year and placed at least one order again this year is divided by last year's number of customers. For an earlier signal, you can track the share of customers who place a second order within 90 days of their first order.

Can a newly opened store calculate CLV?

Without a year of data, the retention rate cannot be measured. New stores can track the 90-day second-order rate in the first months, estimate CLV with a cautious assumption and update the calculation as data accumulates.

How is CLV calculated for marketplace customers?

The method is the same; only the marketplace commission and marketplace-specific costs are deducted from the contribution margin. Calculating marketplace customers and your own site's customers separately lets you compare the real value of the two channels.

How often should CLV be updated?

At least every three months. When the commission rate, shipping fee, product cost or customer behavior changes, CLV changes too; planning a budget with an outdated value leads to wrong decisions.

Bookkeeping Is Now Completely Free

Manage your bookkeeping and e-Invoice operations with NetKasam without paying a thing. Customer and supplier accounts, inventory, collections and more in one panel, completely free.

Start FreeCustomer and Supplier Account Tracking

Read similar articles

19 free tools

Commission, shipping, VAT and profit calculations in your browser, no sign-up needed.

All tools