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.

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.