ABCDEFGHIJKLMNO
1
2
Info
3
4
Subscriptiontype and lenght of your subscription productLifetimeAverage number of subscription period paying users stays
5
UsersNumber of users in you cohort; real of fictionalPricePrice of subscription as it is visisble for user
6
TrialsNumber of trials; calculated autimaticallyUser LTV Projected Lifetime Value of a user of this сohort
7
Direct SubsNumber of direct subs; calculated automatically
8
Trial CVRConversion from install to trial; to be put manually
9
Trial2Paid CVRConversion from trial period to payment; to be put manually
10
Paid CVROverall conversion from User to Paying User; to by put or calculated manually
11
12
13
SegmentSubscriptionTrialUsersTrialsDirect SubsTrial CVRTrial2Paid CVRPaid CVRLifetime, periodsPriceUser LTV
14
Subs Setup #1
Weekly7 Days2,50025010010.00%40.00%4.00%15$5.99$3.05$3.05
15
SCN00048MonthlyNo000.00%0.00%0.00%2$6.99$0.00
16
SCN00048AnnualNo000.00%0.00%0.00%1$39.99$0.00
17
Subs Setup #2
WeeklyNo10,00003000.00%0.00%3.00%5$3.99$0.42$0.85
18
SCN00049Monthly7 Days1,000010.00%15.00%1.50%2$6.99$0.15
19
SCN00049AnnualNo01000.00%0.00%1.00%1$39.99$0.28
20
Subs Setup #3
WeeklyNo10,00003000.00%0.00%3.00%5$3.99$0.42$1.17
21
SCN00050MonthlyNo02000.00%0.00%2.00%2$6.99$0.20
22
SCN00050Annual7 Days1,000010.00%20.00%2.00%1$39.99$0.56
23
24
SegmentUsersCostCPIUser LTVMarginProjected RevenueProjected Profit
25
Subs Setup #1
10,000$3,000$0.30$3.05$3.0590.18%$30,549.00$27,549.00
26
SCN00048$0.00
27
SCN00048$0.00
28
Subs Setup #2
10,000$3,000$0.30$0.42$0.8564.53%$8,456.70$5,456.70
29
SCN00049$0.15
30
SCN00049$0.28
31
Subs Setup #3
10,000$3,000$0.30$0.42$1.1774.46%$11,745.30$8,745.30
32
SCN00050$0.20
33
SCN00050$0.56
34
35