MODEL OVERVIEW

Estimating User Lifetime Value from Retention Data

A cohort-based approach to early lifecycle forecasting

Business questions addressed by the model

Retention data can support several connected decisions: estimating unit economics, setting acquisition budgets, forecasting active users, and comparing acquisition plans. This model links those decisions through expected user lifetime.

Unit Economics
Budget Planning
Growth Forecasting
Plan Comparison

Model structure

A power function fitted to cohort retention observations

Illustrative validation

A comparison using retention data from five digital products

Planning use

An early estimate based on seven days of observed retention

UNIT ECONOMICS

Core Business Model for Digital Products

Connecting user value, acquisition cost, and acquisition volume

Simplified contribution model

$$\text{Profit} = \text{ROI} \times \text{Quantity}$$
01

Return and investment

$$\text{ROI} = \frac{\text{Return}}{\text{Investment}}$$
$$\text{ROI} = \text{Return} - \text{Investment}$$
02

Digital product unit economics

$$\text{ROI} = \text{LTV} - \text{CAC}$$
$$\text{LTV} = \text{LT} \times \text{V}$$
LTV: Lifetime Value CAC: Acquisition Cost

Planning question: How can LTV be estimated before a full year of data is available?

A full-year observation period delays acquisition and budget decisions. Early retention data provides a basis for estimating the remaining lifecycle, subject to the model assumptions described below.

RETENTION AND LIFETIME

Estimating lifetime from retention

Expected active days derived from a cohort retention curve

Retention rate

The retention rate is the share of the original cohort that remains active on day $t$.

$$t\text{-day retention} = \frac{\text{Active Users on Day } t}{\text{Initial Acquired Cohort}}$$

Sample retention data (Days 1 to 7)

Sample Cohort
Day 1100%
Day 239%
Day 330%
Day 426%
Day 524%
Day 622%
Day 721%

DERIVATION IN THREE STEPS

Step 1: Cohort behavior
User-level expectation

For a randomly selected cohort member, $R_t$ is the probability of being active on day $t$.

Step 2: Expected value
Observed lifetime
$$\sum [\text{Active Days}] = \sum_{t=1}^{N} R_t$$
Step 3: Long-run limit
Lifetime estimate
$$LT_{\infty} = \sum_{t=1}^{\infty} R_t$$

Long-run LT formula

$$LT_{\infty} = \sum_{t=1}^{\infty} R_t$$

The sum of daily retention probabilities over the modeled lifecycle.

Seven-day calculation

LT₇ = 100% + 39% + 30% + 26% + 24% + 22% + 21% = 2.62 Days

The observed cohort contributes 2.62 expected active days during the first seven days.

MODEL SELECTION

Comparing candidate retention curves

Fit and extrapolation behavior of five candidate functions

Linear Function

Not suitable
$$R(t) = a + bt$$
Limitation: Linear decay eventually predicts negative retention ($R(t) < 0$), outside the valid range for a retention rate.

Logarithmic Function

Not suitable
$$R(t) = a + b \ln(t)$$
Limitation: The fitted curve eventually crosses zero as $t \to \infty$, so it cannot support long-term extrapolation.

Polynomial Function

Poor extrapolation
$$R(t) = at^2 + bt + c$$
Limitation: The quadratic curve turns upward beyond Day 7, which conflicts with the assumed monotonic decline in retention.

Exponential Function

Underfit
$$R(t) = ae^{bt}$$
Limitation: The tail decays too quickly in this sample, predicting 6.7% retention against an observed 12% on Day 30.

Power Function

Best sample fit
$$R(t) = at^b \quad (b < 0)$$
Result: The power function has the highest in-sample fit ($R^2 = 0.9988$) and preserves a positive, slowly decaying tail.

Cross-product comparison

Observed and power-function estimates of 30-day retention

Platform Predicted Actual Error Rate
WeChat 81.37% 84.96% -4.23%
YouTube 51.70% 51.43% +0.52%
Facebook 47.71% 47.66% +0.10%
Taobao 28.91% 28.50% +1.44%
Momo 12.82% 12.65% +1.34%

Error profile

Four of the five products have an absolute error below 1.5%; WeChat is the exception at 4.23%.

Product coverage

The comparison includes social, video, ecommerce, and dating products. Broader use requires validation on the target product's own cohorts.

ACQUISITION SCENARIOS

Comparing three acquisition schedules

The schedules differ in timing, spend concentration, and retained DAU

Model 01

Target-day acquisition

Acquire the full cohort on the target date

Metric Day 1 Day 2 Day 3
DNU 0 0 100
DAU 0 0 100
Advantage

Simple to execute and reaches the target on the specified day.

Disadvantage

Concentrates all spend on one day, while DAU declines immediately afterward.

Model 02

Front-loaded acquisition

Acquire users early to offset subsequent retention decay

Metric Day 1 Day 2 Day 3
DNU 333 0 0
DAU 333 133 100
Advantage

Reaches the Day 3 target under the stated retention assumptions.

Disadvantage

Requires 3.3 times the target volume in Day 1 acquisition.

Model 03 (planning baseline)

Equal daily acquisition

Distribute acquisition evenly across the planning period

Metric Day 1 Day 2 Day 3
DNU 59 59 59
DAU 59 83 100
Advantage

Produces a predictable daily budget and a gradual build in DAU.

Assumption

Assumes consistent daily execution and a retention curve that remains suitable for forecasting.

COHORT ACCUMULATION

DAU under equal daily acquisition

Each daily cohort contributes retained users to total DAU

365-Day Cohort Accumulation Matrix

Unit DNU Inflow
Cohort Day 1 Day 2 Day 3 Day 4 Day 5 ... Day 364 Day 365 DAU
Cohort 1 R₁ R₂ R₃ R₄ R₅ ... R₃₆₄ R₃₆₅
Cohort 2 - R₁ R₂ R₃ R₄ ... R₃₆₃ R₃₆₄
Cohort 3 - - R₁ R₂ R₃ ... R₃₆₂ R₃₆₃
Cohort 365 - - - - - ... - R₁

DAU AND LIFETIME RELATIONSHIP

$$DAU_{\infty} = LT_{\infty} \cdot DNU = \sum_{t=1}^{\infty} R_t \cdot DNU$$
$$DAU_{\infty}$$

Expected daily active users at steady state.

$$LT_{\infty}$$

Expected active days, calculated from the retention curve.

$$DNU$$

The number of new users acquired each day.

WORKED EXAMPLE

Acquisition volume for a target DAU

A worked example using a 365-day planning period

Scenario and planning target

Given: A mobile game with a 365-day user lifecycle ($LT_{365}$) of 28 days, and a target to reach 1,000,000 DAU on Day 365 under equal daily acquisition.

Question: How many total users must be acquired ($Total$), and what is the required daily acquisition rate ($DNU$)?

Algebraic steps

Step 1: Fundamental identities
$$DAU_M = LT_M \cdot DNU \quad \text{and} \quad Total = M \cdot DNU$$
Step 2: Ratio substitution
$$\frac{DAU_M}{Total} = \frac{LT_M \cdot DNU}{M \cdot DNU} = \frac{LT_M}{M}$$
Step 3: Final acquisition formula
$$Total = \frac{DAU_M \cdot M}{LT_M}$$

Calculation and result

Substitute values ($DAU = 1M, M = 365, LT = 28$):
$$Total = \frac{1,000,000 \times 365}{28} = 13,035,714$$
Required acquisition rate
DNU = 35,714 / Day

Under the model assumptions, acquiring 35,714 new users per day, or 13.04 million over the year, yields an estimated 1 million DAU on Day 365.

DECISION SUPPORT

How the model supports planning

Using early retention observations to estimate lifecycle and acquisition needs

Lifecycle forecasting

Fit an early retention curve and use it to estimate active days beyond the observation window.

Budget planning

Translate a target DAU into daily and total acquisition requirements, then compare alternative spend schedules.

DAU forecasting

Estimate how new cohorts and retained users combine to produce DAU over the planning period.

Practical use and limitations

The power-function model produces an early lifecycle estimate from seven days of retention data. In this five-product comparison, four estimates are within 1.5% of observed 30-day retention and one differs by 4.23%. Results should be recalibrated as more cohort data becomes available.