ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACAD
1
Retention Function Calc (y=a*x^b)Integral on Retention Function180 Day LTV Calculation
2
DayRetention D1
(%)
Retention D7
(%)
Retention D30
(%)
DAURevenue IAP
(Proceed) (USD)
Revenue Ad
(USD)
Revenue Ad CN
(USD)
Revenue
(USD)
ARPDAU
(USD)
abDaysRetention func.Integral to date180d Integral
User days (to 180d)
2.303024073
3
125.698.171.829434.048.950.6513.640.014528.52027602-0.767973820602.303024073Avg. ARPDAU$0.010
4
221.798.910.827070.005.910.146.050.008628.7806795-0.9367566396134.5034.50LTV$0.022
5
339.344.482.277340.007.430.137.560.010333.75344958-0.8538454012219.4729916153.97
6
439.6710.361.597610.005.920.025.940.007845.677948-0.9318244327313.1103102467.08
7
534.666.190.338070.007.470.007.470.009345.2372074-1.34201546849.90159015376.98
8
641.957.581.718520.008.470.258.720.010243.39843769-0.937476064657.96426564384.95
9
737.227.990.6110030.2110.530.2911.030.011046.86538968-1.18589304766.66630589491.61
10
832.037.500.589070.119.020.339.460.010440.67256686-1.15573001975.73538289697.35
11
926.095.461.627480.007.540.127.660.010226.2821598-0.816374845685.034741939102.38
12
1036.075.430.007320.005.800.005.800.0079167.8260463-3.60975043994.488131057106.87
13
1140.135.681.037310.005.020.025.040.006941.75675599-1.072907085104.049654816110.92
14
1232.759.741.987520.006.680.036.710.008936.60275627-0.813922235113.690025849114.61
15
1342.935.380.818450.286.780.107.160.008545.36333027-1.161856941123.389670684118.00
16
1433.638.502.059550.008.740.208.940.009435.84549365-0.8162037269133.135007948121.14
17
1529.246.321.409210.007.110.367.470.008131.00508716-0.8877182237142.916316708124.05
18
1624.924.920.336900.648.700.019.350.013531.71988641-1.247499664152.726454777126.78
19
1731.217.641.597230.007.130.097.220.010033.93871324-0.8669731881162.560056112129.34
20
1838.028.770.907560.008.620.068.680.011546.0311419-1.081681233172.41301056131.75
21
1935.1410.611.557690.008.810.009.330.012141.51032804-0.9011292181182.282116439134.04
22
2045.238.520.009000.008.290.528.540.0095232.6210483-3.666355224192.164842466136.20
23
2136.597.640.009580.006.230.256.290.0066187.2110597-3.604542756202.059160865138.26
24
2232.566.230.709400.117.000.067.230.007737.97548171-1.113693008211.963427991140.22
25
2330.796.371.587610.006.380.126.430.008431.88615289-0.8696853776221.876297404142.10
26
2437.067.292.337250.105.600.055.770.008036.60970844-0.8146517215231.796655533143.90
27
2535.805.380.997000.007.530.077.560.010837.43372802-1.05049887241.723573374145.62
28
2637.088.041.987560.106.990.007.660.010138.66402306-0.8573092831251.656269738147.28
29
2739.008.941.808570.007.200.037.350.008642.29970002-0.896270751261.594082946148.87
30
2836.965.652.389720.289.620.579.900.010233.86232881-0.815079396271.536448796150.41
31
2933.237.301.429140.1110.270.1510.380.011436.05696569-0.9188735917281.482883235151.89
32
3028.208.630.007020.125.540.005.660.0081154.141455-3.521415259291.432968599153.32
33
301.386342597154.71
34
Ave34.507.321.218170.008.000.007.870.009638.29661666-0.9757424011311.342689422156.05
35
Sum6.10225.284.62236.00321.301732517157.35
36
331.263228658158.62
37
341.226963072159.84
38
351.192745389161.04
39
361.160406275162.20
40
371.129794593163.33
41
381.100775026164.43
42
391.073226055165.50
43
401.047038244166.55
44
411.022112771167.57
45
420.9983601723168.57
46
430.9756992577169.54
47
440.9540561752170.50
48
450.9333635997171.43
49
460.9135600264172.34
50
470.8945891546173.24
51
480.8763993479174.12
52
490.8589431609174.97
53
500.8421769215175.82
54
510.826060363176.64
55
520.8105562982177.45
56
530.79563033178.25
57
540.7812505942179.03
58
550.7673875308179.80
59
560.7540136786180.55
60
570.7411034923181.29
61
580.7286331783182.02
62
590.7165805462182.74
63
600.7049248766183.44
64
610.6936468008184.14
65
620.6827281921184.82
66
630.6721520684185.49
67
640.6619025022186.15
68
650.6519645409186.80
69
660.6423241324187.45
70
670.6329680588188.08
71
680.6238838751188.70
72
690.6150598535189.32
73
700.6064849325189.93
74
710.5981486698190.52
75
720.5900412003191.11
76
730.5821531959191.70
77
740.5744758298192.27
78
750.5670007432192.84
79
760.5597200148193.40
80
770.5526261322193.95
81
780.545711966194.50
82
790.5389707456195.03
83
800.5323960371195.57
84
810.5259817222196.09
85
820.5197219795196.61
86
830.5136112665197.13
87
840.5076443028197.63
88
850.5018160553198.14
89
860.4961217235198.63
90
870.4905567264199.12
91
880.4851166897199.61
92
890.4797974348200.09
93
900.4745949678200.56
94
910.469505469201.03
95
920.4645252841201.50
96
930.4596509148201.96
97
940.4548790109202.41
98
950.4502063623202.86
99
960.4456298922203.31
100
970.4411466495203.75