ANALYTICS UTILITY · SHEET 02

Cohort Retention &
LTV Simulator.

Fit a mathematical power-law decay curve R(t) = a · t−b to model user lifespan. Visualize retention decay alongside cumulative LTV buildup over time to evaluate monetization health.

Use this before a UA budget review or a monetization audit, when you need a defensible cohort LTV number without exporting raw retention data into a spreadsheet. It is built for operators who already have D1/D7/D30 (or a fuller retention curve) and want to see how sensitive LTV is to shifts in the decay rate.

FILE · SIM_02

Model Parameters

*Data compiled from global industry benchmarks published by GameAnalytics, AppsFlyer, Adjust, and Liftoff.
01 · Day 1 Retention %
02 · Day 7 Retention %
03 · Day 30 Retention %
04 · Daily ARPU (ARPDAU) $

Simulator Outcomes

Active Lifespan
22.0 days
Expected active days per user
Day 365 Survival
2.8%
Users active after 1 year
Decay rate (b)
0.450
Power-law decay coefficient
COHORT RETENTION DECAY (R(t) = a · t-b) Onboarding cliff Habit formation Steady-state tail
CUMULATIVE LIFETIME VALUE (LTV = ARPU · Lifespan(t)) Projected LTV $0.00

Anatomy of the decay curve.

Every cohort's lifetime value is decided across four distinct friction gates. When retention decays, the diagnostic begins by isolating the gate that is failing.

STAGE 01 · D0 → D1

Onboarding Drop-off

The vertical drop on Day 1. Typically driven by tutorial friction, device performance, value-proposition mismatch, or broken initial user flows.

Leverage: Highest (controls downstream volume)
STAGE 02 · D1 → D7

Habit Formation

Early-stage churn. Driven by content depth, early progression pace, session intervals, and failure to establish the secondary core loop.

Leverage: High (sets the slope of the curve)
STAGE 03 · D7 → D30

Mid-Term Stability

The curve flattens. Users choose to make the product a regular habit. Influenced by feature depth, personalization, and social hooks.

Leverage: Medium (creates the LTV baseline)
STAGE 04 · D30 → D365

Steady-State Tail

The loyal tail. Driven by live operations, elder game economy, communities, and high-affinity habits. This tail supports direct scale.

Leverage: Compounding (drives 80% of long-term LTV)
MONETIZATION AUDIT DIAGNOSTIC

Is your curve decaying too fast?

A 5% shift in early retention can compound into a 25%+ increase in cohort LTV. If your curves drop off too steeply, optimizing monetization or spending on acquisition is leaking water. We diagnose these curves, rewrite progression systems, and audit ad networks to secure the tail.

FAQ

Common questions.

What does this calculator do?

It fits a power-law decay curve to your cohort retention inputs (R(t) = a · t⁻ᵇ), then uses that curve to project active user lifespan, Day 365 survival, and cumulative cohort LTV based on your ARPDAU.

What inputs do I need?

In Basic mode: Day 1, Day 7, and Day 30 retention percentages, Daily ARPU (ARPDAU), and an LTV projection horizon (90, 180, or 365 days). Advanced mode accepts an 8-point retention profile (Day 1, 3, 5, 7, 14, 21, 30, 90) for a tighter curve fit. A genre-benchmark dropdown can also autofill these fields.

How is LTV projected from retention?

The tool fits the power-law curve R(t) = a · t⁻ᵇ to your entered retention points, uses the fitted decay rate (b) to estimate active lifespan and Day 365 survival, then multiplies the curve's cumulative active-day count by your Daily ARPU to build the LTV projection out to your selected horizon.