How to Create a Customer Lifetime Value Calculation for Your Store

A store can make a profit on the first order and still lose money over time if customers rarely return, discounts consume the margin, or fulfilment costs are too high. Customer lifetime value, commonly shortened to CLV or LTV, helps you measure the total profit or revenue a buyer may generate throughout the relationship with your business.

This metric is useful for ecommerce shops, digital product sellers, subscription businesses, VTU platforms, and service providers. It gives you a clearer basis for deciding how much to spend on advertising, which customers deserve retention campaigns, and whether your pricing model can support long-term growth.

A reliable calculation does not require expensive software. With order records, payment data, customer counts, and a spreadsheet, you can build a practical estimate and improve it as your store gathers more evidence.

Understand What Customer Lifetime Value Measures

Customer lifetime value estimates the financial contribution of an average customer over the period they continue buying from your store. Some businesses calculate lifetime revenue, while others calculate lifetime gross profit. The second option is usually more useful because sales income alone does not show what remains after product and fulfilment costs.

For example, a customer who spends ₦100,000 over three years may appear highly valuable. However, if product costs, delivery, payment charges, refunds, and support expenses total ₦85,000, the store has generated only ₦15,000 before marketing and overheads.

Your calculation should match the decision you want to make. Use revenue-based CLV when comparing customer spending patterns. Use profit-based CLV when setting an acquisition budget or assessing whether a marketing campaign is sustainable.

Gather The Numbers Behind The Formula

Start with your average order value. Add the revenue from all completed orders during a selected period and divide it by the total number of orders. Exclude cancelled transactions and decide how you will treat refunds, discounts, delivery charges, and taxes before calculating.

Next, estimate purchase frequency. Divide the number of orders by the number of unique customers during the same period. A frequency of 2.4 means the average customer placed approximately 2.4 orders in that timeframe. Use a period long enough to reflect your buying cycle, such as 12 months for household goods or three months for frequently purchased digital services.

You also need an average customer lifespan or retention period. This can come from historical records, a churn rate, or a reasonable forecast. If customers typically remain active for 18 months, use 1.5 years in an annual calculation. For a new store, label the result as an estimate and update it as customer behaviour becomes clearer.

Choose A Calculation Method

The simple revenue formula is:

Customer Lifetime Value = Average Order Value × Purchase Frequency × Customer Lifespan

Suppose your average order value is ₦18,000, customers place four orders per year, and the average relationship lasts for 2.5 years. The estimated revenue-based CLV is ₦180,000. This figure helps you understand expected sales, but it does not represent profit.

A margin-adjusted formula gives a more realistic view:

Profit-Based CLV = Average Order Value × Purchase Frequency × Customer Lifespan × Gross Margin

If the store has a 35% gross margin, the previous example produces an estimated gross profit CLV of ₦63,000. You can subtract average servicing expenses, loyalty rewards, refunds, and other variable costs to make the result more precise.

Metric Example value Calculation role Data source
Average order value ₦18,000 Measures typical basket size Order history
Purchase frequency 4 per year Measures repeat buying Customer records
Customer lifespan 2.5 years Estimates relationship duration Cohort or churn data
Gross margin 35% Converts revenue into gross profit Product costing
Profit-based CLV ₦63,000 Estimates customer contribution Combined formula

Improve Accuracy With Retention Data

A single average can hide major differences between customer groups. Customers acquired through search may buy more frequently than customers attracted by a one-time discount. Buyers of premium products may have a larger order value but a longer gap between purchases.

Use cohort analysis to compare customers based on their first purchase month, acquisition channel, product category, or location. Track how many customers from each cohort return after 30, 60, 90, and 180 days. This approach helps you replace broad assumptions with observed retention behaviour.

You can also estimate lifespan using churn. If your annual churn rate is 25%, a basic lifespan estimate is:

Customer Lifespan = 1 ÷ Annual Churn Rate

That produces four years in this example, though the method works best for businesses with relatively stable subscription or repeat-purchase patterns. For irregular ecommerce purchases, use repeat-rate data and customer activity windows instead of treating every inactive buyer as permanently lost.

Connect CLV With Customer Acquisition Cost

CLV becomes strategically valuable when you compare it with customer acquisition cost, or CAC. CAC is the total amount spent on marketing and sales divided by the number of new customers gained. Include advertising, influencer fees, sales commissions, creative production, and relevant software costs.

If your profit-based CLV is ₦63,000 and CAC is ₦20,000, the relationship appears attractive before fixed overheads. If CAC rises to ₦55,000, the store has little room for delivery problems, refunds, customer support, or price changes. Revenue-based CLV may make the ratio look healthy while hiding a weak profit position.

A useful rule is to aim for CLV that comfortably exceeds CAC rather than treating equality as success. The ideal ratio depends on cash flow and business model. A subscription company may accept a longer payback period, while a small Nigerian ecommerce business may need to recover acquisition costs within the first few orders.

Build The Calculation In A Spreadsheet

Create columns for customer ID, first order date, latest order date, total orders, total revenue, refunds, product cost, delivery cost, and marketing source. A spreadsheet can then calculate average order value, repeat purchase rate, gross margin, and customer-level contribution.

Keep revenue and profit figures separate. A customer may have high sales value but low profitability because of repeated discounts or expensive delivery locations. Adding a contribution margin column shows which customers and products support healthy growth.

For store owners who are also building digital businesses, a free VTU Script registration can provide a starting point for exploring online business resources and tools. The important part is to maintain accurate transaction records wherever your store operates, whether through a website, social media checkout, payment link, or messaging platform.

Review the spreadsheet monthly or quarterly. Record the assumptions beside the formulas, including the measurement period, margin percentage, lifespan estimate, and treatment of refunds. This makes it easier to identify changes instead of silently replacing old figures.

Segment Customers Before Taking Action

An overall CLV is useful for planning, but segments reveal where growth opportunities exist. Separate first-time buyers from repeat customers, high-value buyers from occasional shoppers, and organic customers from paid customers. Calculate order value, frequency, retention, and margin for each group.

A customer with high CLV may respond well to early access, product bundles, referral rewards, or personalised recommendations. A low-CLV segment may need better onboarding, clearer product education, a smaller minimum order, or a different acquisition channel.

Avoid using CLV as a reason to ignore customers with smaller budgets. A low current value can reflect a short relationship rather than low potential. A new buyer may become valuable after a well-timed follow-up message, useful post-purchase support, or a relevant second-offer campaign.

Use The Results To Guide Store Decisions

Your CLV estimate can shape your advertising limits. If a segment generates ₦30,000 in expected gross profit, spending ₦8,000 to acquire a customer may be reasonable. Spending ₦28,000 leaves little protection against inaccurate forecasts or unexpected costs.

The metric can also guide retention investment. Compare the cost of a campaign with the additional profit it creates. If a ₦100,000 email or SMS campaign encourages 20 customers to place an extra ₦15,000 order at a 40% margin, it generates ₦120,000 in gross profit before campaign expenses and may be worthwhile.

Use CLV alongside conversion rate, average order value, refund rate, repeat purchase rate, and cash flow. No single metric explains the whole business. A store can have an excellent projected lifetime value and still experience financial pressure if it pays suppliers before collecting customer revenue.

Practical Habits For Better CLV Decisions

A useful CLV model is a working business instrument rather than a permanent answer. Begin with the information you already have, state your assumptions clearly, and replace estimates with actual cohort data as your store matures. Over time, the calculation will show which customers create lasting value and which parts of the buying experience need attention.

Set up your spreadsheet today, enter your latest order records, and calculate the first version of your customer lifetime value. Use the result to set a sensible acquisition budget, improve repeat purchases, and build a store that grows through profitable customer relationships.