Step 1
Start with
rough data
Day 1
Retention 32%
Day 30
Retention 11%
Step 2
Add diagram
Step 3
Add
trendline
Step 4
Add formula
and adjust for “potential”
Use
resulting formula for calculating each day from day 1 to day 180 (for instance). Of course you can prolong the time period you are looking at
Then
multiply ARPDAU x number of days = LTV (Life time value)