LTV based on modeling RETENTION function
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
ABCDEFGHIJKLMNOPQRSTUVWX
1
Full explanation of this method can be found here -
2
http://blog.soom.la/2016/04/clv-modeling-retnetion-function-spreadsheet.html
3
InputRetention Function Calc (y=a*x^b)Integral on Retention Function180 Day LTV Calculation
4
DaysUsersARPDAUabDaysRetention func.Integral to date180d Integral
User days (to 180d)
11.54993642
5
010000.6755619207-0.614436236011.54993642Avg. ARPDAU$0.100
6
14500.450.0910.450.45LTV$1.155
7
23500.350.0920.350.8
8
33000.30.0930.31.1
9
42700.270.0940.271.37
10
52600.260.0950.261.63
11
62500.250.0960.251.88
12
72400.240.0970.242.12
13
82300.230.0980.232.35
14
92200.220.0990.222.57
15
102100.210.09100.212.78
16
112000.20.09110.22.98
17
121900.190.09120.193.17
18
131800.180.09130.183.35
19
141700.170.09140.173.52
20
151600.160.09150.163.68
21
161500.150.11160.153.83
22
171400.140.11170.143.97
23
181300.130.11180.134.1
24
191200.120.11190.124.22
25
201100.110.11200.114.33
26
211000.10.11210.14.43
27
22950.0950.11220.0954.525
28
23900.090.11230.094.615
29
24850.0850.11240.0854.7
30
25800.080.11250.084.78
31
26750.0750.11260.0754.855
32
27700.070.11270.074.925
33
28650.0650.11280.0654.99
34
29600.060.11290.065.05
35
30550.0550.11300.0555.105
36
310.081906524115.186906524
37
320.080324212135.267230736
38
330.078819771625.346050508
39
340.077387179865.423437688
40
350.076021039615.499458727
41
360.074716498515.574175226
42
370.073469180755.647644407
43
380.07227512895.719919536
44
390.071130754175.79105029
45
400.070032793625.861083083
46
410.06897827345.930061357
47
420.067964476755.998025833
48
430.066988916326.06501475
49
440.066049310026.13106406
50
450.065143559856.19620762
51
460.064269733386.260477353
52
470.063426047386.3239034
53
480.06261085356.386514254
54
490.061822625416.448336879
55
500.061059947596.509396827
56
510.060321505216.569718332
57
520.059606075196.629324407
58
530.058912518156.688236925
59
540.058239771276.746476697
60
550.057586841816.804063539
61
560.056952801346.86101634
62
570.056336780496.91735312
63
580.055737964286.973091085
64
590.055155587797.028246672
65
600.054588932347.082835605
66
610.054037321997.136872927
67
620.05350012037.190373047
68
630.052976727487.243349775
69
640.052466577717.295816352
70
650.051969136727.347785489
71
660.05148389967.399269389
72
670.051010388757.450279777
73
680.050548152027.500827929
74
690.050096761047.55092469
75
700.049655809587.6005805
76
710.049224912197.649805412
77
720.048803702797.698609115
78
730.048391833487.747000948
79
740.047988973427.794989922
80
750.047594807737.84258473
81
760.047209036567.889793766
82
770.046831374157.93662514
83
780.046461548047.983086688
84
790.046099298258.029185987
85
800.045744376598.074930363
86
810.045396545948.120326909
87
820.04505557978.165382489
88
830.044721261138.21010375
89
840.044393382848.254497133
90
850.04407174638.298568879
91
860.043756161328.34232504
92
870.043446445638.385771486
93
880.043142424498.428913911
94
890.042843930248.471757841
95
900.042550801998.514308643
96
910.042262885238.556571528
97
920.041980031568.59855156
98
930.041702098358.640253658
99
940.041428948458.681682606
100
950.041160449978.722843056
Loading...