How to Analyze Customer Lifetime Value
How to analyze customer lifetime value (CLV) starts with actual purchase history, not a formula with assumed inputs. Historical CLV — the sum of all revenue a customer has generated to date — is always more reliable than a predicted CLV built on averages.
Upload your customer order history and ask "What is the average CLV by acquisition channel?" or "Which customer cohort has the highest 12-month lifetime value?"
Drop your file in and ask a question — no account needed.
Upload your spreadsheet.xlsx .xls .csv — free to try, no accountWhat this export contains
| Customer ID |
| Acquisition Channel |
| First Order Date |
| Order Date |
| Order Value |
| Cohort Month |
| Product Category |
| Discount Used |
| Returns |
| Total Orders |
What usually goes wrong with it
CLV is calculated as a single company-wide average
An average CLV of $350 hides the fact that customers acquired through referral have a $700 CLV while those acquired through paid social have a $120 CLV — the same acquisition budget should not be spent equally on both.
DataMimi Datamimi calculates CLV by acquisition channel so you can compare long-term revenue from each source against what you spend to acquire from it.
Returns aren't subtracted from CLV calculations
Order value is summed across all purchases including returned items, overstating CLV for segments with high return rates like apparel or electronics.
DataMimi It subtracts return value from each customer's total revenue before calculating CLV when a returns column is present in the export.
CLV is calculated on all customers, including very recent ones
A customer acquired 30 days ago has a CLV of $45 because they've only had time for one order, pulling down the average — CLV should be calculated on mature cohorts with at least 12 months of history.
DataMimi It filters the CLV calculation to customers acquired at least 12 months ago so immature cohorts don't artificially deflate the average.
The LTV:CAC ratio isn't visible in the data
CLV exists in one spreadsheet and acquisition cost data exists in another — without joining them, you can't tell which channels are profitable over the customer's lifetime.
DataMimi It lets you add a CAC column by channel and calculates LTV:CAC ratio per segment, flagging channels where the ratio is below 3:1.
Common questions
How to analyze customer lifetime value: what is the simplest way to start?
Sum all revenue per customer using their Customer ID, then group by acquisition channel and cohort month. Average those totals for customers with 12+ months of history. That gives you historical CLV without any assumptions.
What is a good LTV to CAC ratio?
3:1 is the standard target — earning $3 in lifetime value for every $1 spent acquiring the customer. Below 2:1 means acquisition costs are unsustainably high. Above 5:1 may mean you're under-investing in growth.
How is predicted CLV different from historical CLV?
Historical CLV is the actual revenue a customer has generated. Predicted CLV uses average order value, purchase frequency, and expected lifespan to estimate future value. Historical is more reliable; predicted is more useful for planning.
How do I improve customer lifetime value?
Three levers: increase average order value (upsell, bundle), increase purchase frequency (retention emails, subscriptions), and extend customer lifespan (loyalty programs, great service). Improving any one raises CLV without acquiring new customers.
How much does Datamimi cost?
Free plan: $0/month, 40 credits, no credit card required. Lite: $9/month, 400 credits. Starter: $24/month, 1,500 credits, up to 3 simultaneous files. Pro: $59/month, 5,000 credits with rollover. Team: $199/month, 20,000 credits for 5 users.
Try it with your own file
DataMimi reads the file you actually have — merged cells, headers below row one, totals pasted at the bottom — and shows which rows and columns every number came from.
Ask about your file