Estimating Customer Lifetime Value (LTV) to Cap Acquisition Costs
The CFO and the Growth Director need to estimate how many euros a new customer will bring over their first 24 months (LTV) based on their behaviour in the first 14 days, in order to set the maximum acquisition investment (CAC).
Where the money comes from
What to do now
- 1Calculate LTV in margin (not in revenue) by cohort.
- 2LTV model using the first 14 days.
- 3Set the acquisition cost cap by channel and country.
For your committee
One page with the decision, the impact, the risks, the steps and the KPI to track.
The print dialog opens: choose "Save as PDF".
Watch out: more volume is not always more profit
Setting the acquisition cap using LTV in revenue rather than in margin: you pay for customers who bill but cost more to serve than they leave.
KPI for the committee
LTV in margin / acquisition cost by channel.
Detail for your data team
Proposed technique: Linear Regression
Why: LTV is a continuous monetary figure, and identifying how much each early action contributes (e.g. 'inviting 2 colleagues adds +€450 of LTV') allows product, marketing and finance to be aligned.
Cost of getting it wrong: Overestimating LTV leads to spending more on acquisition than the customer will ever return, burning cash.
Data needed: Product Analytics: Number of sessions, features activated and users invited during the first 14 days.; Historical Billing: Cumulative revenue at 24 months from previous customer cohorts.