How to Measure Customer Lifetime Value (CLV) for Your Business
Quick Answer
Customer Lifetime Value (CLV) = Average Order Value × Purchase Frequency × Average Customer Lifespan. For a B2B company: average order of ₹50,000, ordering 6 times/year, average 3-year relationship = CLV of ₹9,00,000. Track CLV by customer segment, acquisition channel, and product line. The most valuable CLV insight for Indian B2B businesses is comparing CLV to CAC (Customer Acquisition Cost) to assess whether marketing spend is profitable.
CLV is the most important metric for making smart customer acquisition and retention decisions. Without CLV, you don't know how much you should pay to acquire a customer — which makes marketing budget decisions fundamentally guesswork.
CLV Formulas
Simple CLV (Historical Method)
Calculate from actual customer history:
CLV = Total Revenue from Customer ÷ Months Active × 12 (annualised)
Or for the full relationship:
CLV = Average Order Value × Purchase Frequency × Customer Lifespan
Example:
- Average order value: ₹45,000
- Orders per month: 1.5
- Average tenure: 2.5 years
CLV = ₹45,000 × 1.5 × 12 × 2.5 = ₹20,25,000
Predictive CLV
Uses cohort analysis and churn rates to project future value:
Predictive CLV = Average Monthly Revenue × (1 ÷ Monthly Churn Rate)
Example: ₹67,500/month average revenue × (1 ÷ 0.03 monthly churn rate) = ₹22,50,000 predicted lifetime value
Building a CLV Dashboard
Step 1: Calculate CLV for Each Customer
Connect your BI tool to Tally or CRM to get:
- First purchase date (start of relationship)
- Last purchase date (end or current)
- Total revenue per customer
- Number of orders
Then calculate: Average monthly revenue per customer, customer lifespan (months), and CLV.
Step 2: Segment CLV Analysis
By acquisition channel: Which channel acquires the highest-CLV customers? This is more valuable than looking at just CAC.
By customer size/type: Do large enterprise customers have higher CLV or do mid-market customers?
By product first purchase: Customers who first bought Product A — what's their average CLV vs those who first bought Product B?
By geography: Regional CLV differences inform territory investment decisions.
By acquisition cohort: Month-of-acquisition CLV analysis shows if your customer quality has improved or declined over time.
Step 3: CLV vs CAC Analysis
The CLV:CAC ratio is the profitability measure for customer acquisition:
| Ratio | Interpretation |
|---|---|
| <1:1 | Losing money on every customer |
| 1:1–2:1 | Marginally profitable acquisition |
| 3:1–5:1 | Healthy, sustainable unit economics |
| >5:1 | Under-investing in growth opportunities |
A 3:1 ratio (CLV = 3× CAC) is the typical benchmark for healthy acquisition economics.
CLV for Indian B2B Businesses
In Indian B2B markets, CLV analysis reveals some India-specific patterns:
Relationship-driven longevity: Indian B2B customers often have very long tenures if service is good — a distributor relationship of 5–10 years is common. CLV models should account for this potential.
Seasonal ordering patterns: Indian customers often increase/decrease orders around Diwali, financial year-end, and harvest seasons. Monthly CLV calculations should be normalised for seasonality.
Credit-influenced CLV: Customers on longer credit terms often have higher order volumes but may also carry higher receivables risk — a complete CLV model should net out bad debt write-offs.
See what is customer lifetime value for the conceptual overview.
Explore FireAI Workflows
Jump from the concept on this page into the product features and solution paths most relevant to it.
BI Fundamentals
Foundational guides on business intelligence, analytics architecture, self-service BI, and core data concepts.
Ready to Transform Your Business Data?
Experience the power of AI-powered business intelligence. Ask questions, get insights, make better decisions.
Frequently Asked Questions
To calculate CLV from Tally: (1) connect your BI tool to Tally to access customer-level invoice history, (2) for each customer, calculate total revenue, number of orders, and date range of their transactions, (3) divide total revenue by months active to get average monthly revenue, (4) multiply by the average customer lifespan (or 12 months to get annualised CLV). With a native Tally connector like FireAI, this calculation is automated across all customers — you get a CLV ranking of your full customer base without manual analysis.
The CLV:CAC ratio compares how much value a customer generates (CLV) versus how much it cost to acquire them (CAC). A ratio of 3:1 means a customer generates 3 times more revenue than they cost to acquire — a healthy, sustainable business. A ratio below 1:1 means you're losing money on customer acquisition. Tracking this ratio by channel, product, and customer segment tells you exactly where to increase or decrease marketing investment.
CLV helps retention decisions by quantifying the cost of churn. If a high-CLV customer (₹20 lakh lifetime value) is at risk, investing ₹1–2 lakh in retention efforts is clearly justified. CLV also helps prioritise which at-risk customers to prioritise — a team with limited time should focus retention efforts on customers with the highest remaining lifetime value, not just the ones currently ordering the most. CLV-ranked at-risk lists are more actionable than simple revenue-ranked lists.
Related Questions In This Topic
What is Customer Lifetime Value (CLV/LTV)? Formula, Calculation, and Importance
Customer Lifetime Value (CLV or LTV) is the total revenue a business can expect from a single customer account throughout the entire relationship. Learn the CLV formula, how to calculate it, and how to use it to improve marketing and retention decisions.
How to Track Customer Churn Rate in a Dashboard
Customer churn rate measures the percentage of customers who stop buying from you in a given period. Learn how to calculate, track, and visualise churn rate in a dashboard — and how to use churn analytics to identify at-risk customers before they leave.
What is Cohort Analysis? Definition, Examples, and Business Applications
Cohort analysis groups customers or users by a shared characteristic (like acquisition date) to track behaviour over time. Learn how cohort analysis reveals retention, LTV, and churn patterns that aggregate metrics hide.
Analytics for Sales Teams in India: How to Use Data to Hit Targets
Learn how Indian sales teams use analytics to track performance, identify at-risk accounts, prioritise territory coverage, and forecast revenue more accurately. Practical guide for sales managers and heads of sales in Indian businesses.
Related Guides From Our Blog
How a Modern Analytics Platform Transforms Business Intelligence
Why faster decision-making, real-time analytics, and AI-driven intelligence separate market leaders from laggards—and how Fire AI closes the gap between data and action.
How AI-Powered Analytics Can Transform India’s Arbitration Bottleneck?
AI-powered analytics can transform India's arbitration system by automating case classification, predicting timelines, and optimizing arbitrator allocation to cut delays.
Democratizing Data: How AI Analytics Levels the Playing Field for Small Businesses and Freelancers
For decades, data-driven decision making was a luxury that only enterprises could afford. Big companies hired data scientists, purchased expensive BI tools, and built complex data warehouses. In exchange, they received precise insights that guided budgets, strategy, and growth.