The Leaky Bucket Problem
Most companies treat growth as an acquisition problem. Spend more on ads, get more users, grow the number. But if your product leaks — meaning users leave faster than you acquire them — acquisition just fills the bucket while the hole stays open.
The math is simple. If you acquire 1,000 users/month but retain only 20% after 3 months, your active user base plateaus regardless of acquisition spend. Fix retention first. Acquisition scales what already works.
Scroll horizontally to inspect the complete figure.
The Economics of Retention
Acquisition and retention costs vary widely by product, market, channel and lifecycle, so there is no universal multiplier. The durable unit-economics point is that CAC (Customer Acquisition Cost) is paid upfront, while retained users can spread that cost across a longer lifetime. The figures below are illustrative inputs, not reported customer results.
The relationship between retention and LTV is not linear. Small retention improvements compound dramatically over time:
Scroll horizontally to inspect the complete figure.
Cohort Analysis — The Right Way to Measure Retention
Aggregate retention numbers lie. A flat overall retention rate can hide the fact that new cohorts are churning faster while old loyal users prop up the average. Cohort analysis separates users by signup month and tracks each group independently.
WITH cohorts AS (
SELECT
user_id,
DATE_TRUNC('month', MIN(event_time)) AS cohort_month
FROM events
GROUP BY user_id
),
activity AS (
SELECT
e.user_id,
c.cohort_month,
DATE_TRUNC('month', e.event_time) AS activity_month,
EXTRACT(MONTH FROM AGE(
DATE_TRUNC('month', e.event_time), c.cohort_month
)) AS months_since_signup
FROM events e
JOIN cohorts c ON e.user_id = c.user_id
)
SELECT
cohort_month,
months_since_signup,
COUNT(DISTINCT user_id) AS retained_users
FROM activity
WHERE months_since_signup <= 6
GROUP BY 1, 2
ORDER BY 1, 2;Scroll horizontally to inspect the complete figure.
| Cohort | M0 | M1 | M2 | M3 | M4 | M5 |
|---|---|---|---|---|---|---|
| Jan 2025 | 100% | 72% | 58% | 47% | 39% | 34% |
| Feb 2025 | 100% | 68% | 52% | 41% | 33% | 28% |
| Mar 2025 | 100% | 75% | 62% | 51% | 44% | 38% |
| Apr 2025 | 100% | 71% | 55% | 44% | 36% | 30% |
| May 2025 | 100% | 69% | 54% | 43% | — | — |
Reading the heatmap: each row is a user cohort. Each column is how many months after signup. The darker the cell, the higher the retention. Flat rows = good retention. Steep drops = churn problem in early lifecycle.
What Good Retention Looks Like by Stage
- Month 0–1 drop: may indicate activation friction; review onboarding and time-to-value evidence
- Month 1–3 drop: may indicate weak repeat value; investigate usage patterns and user context
- Month 3+ drop: may indicate changing value or needs; combine cohort data with qualitative research
- Flat after Month 3: suggests a retained segment worth studying; it does not establish product health alone
Unit economics
The Business Case in One Equation
If retention improves by 5 percentage points and your CAC is ₹800 per user and your monthly ARPU is ₹200:
Old LTV (70% retention): ₹200 / (1 - 0.70) = ₹667
New LTV (75% retention): ₹200 / (1 - 0.75) = ₹800
LTV improvement: +₹133 per user
CAC stays constant: ₹800
Illustrative old LTV:CAC ratio = 0.83
Illustrative new LTV:CAC ratio = 1.00In this simplified scenario, a five-point retention change moves the modeled ratio from 0.83 to 1.00 while acquisition cost stays fixed. Real unit economics also depend on margin, timing and cohort behavior.
Summary
Key Takeaways
- Acquisition fills the bucket. Retention fixes the hole. Fix the hole first.
- Aggregate retention numbers can hide cohort-level decay — add cohort analysis where the data supports it
- Retention changes can affect modeled LTV, but the size depends on margin, timing and cohort behavior
- Drop patterns by month help locate where further lifecycle investigation may be useful
- LTV:CAC can connect retention assumptions to unit economics when interpreted with margin and payback period