| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | |||||||||||||||
2 | Info | ||||||||||||||
3 | |||||||||||||||
4 | Subscription | type and lenght of your subscription product | Lifetime | Average number of subscription period paying users stays | |||||||||||
5 | Users | Number of users in you cohort; real of fictional | Price | Price of subscription as it is visisble for user | |||||||||||
6 | Trials | Number of trials; calculated autimatically | User LTV | Projected Lifetime Value of a user of this сohort | |||||||||||
7 | Direct Subs | Number of direct subs; calculated automatically | |||||||||||||
8 | Trial CVR | Conversion from install to trial; to be put manually | |||||||||||||
9 | Trial2Paid CVR | Conversion from trial period to payment; to be put manually | |||||||||||||
10 | Paid CVR | Overall conversion from User to Paying User; to by put or calculated manually | |||||||||||||
11 | |||||||||||||||
12 | |||||||||||||||
13 | Segment | Subscription | Trial | Users | Trials | Direct Subs | Trial CVR | Trial2Paid CVR | Paid CVR | Lifetime, periods | Price | User LTV | |||
14 | Subs Setup #1 | Weekly | 7 Days | 2,500 | 250 | 100 | 10.00% | 40.00% | 4.00% | 15 | $5.99 | $3.05 | $3.05 | ||
15 | SCN00048 | Monthly | No | 0 | 0 | 0.00% | 0.00% | 0.00% | 2 | $6.99 | $0.00 | ||||
16 | SCN00048 | Annual | No | 0 | 0 | 0.00% | 0.00% | 0.00% | 1 | $39.99 | $0.00 | ||||
17 | Subs Setup #2 | Weekly | No | 10,000 | 0 | 300 | 0.00% | 0.00% | 3.00% | 5 | $3.99 | $0.42 | $0.85 | ||
18 | SCN00049 | Monthly | 7 Days | 1,000 | 0 | 10.00% | 15.00% | 1.50% | 2 | $6.99 | $0.15 | ||||
19 | SCN00049 | Annual | No | 0 | 100 | 0.00% | 0.00% | 1.00% | 1 | $39.99 | $0.28 | ||||
20 | Subs Setup #3 | Weekly | No | 10,000 | 0 | 300 | 0.00% | 0.00% | 3.00% | 5 | $3.99 | $0.42 | $1.17 | ||
21 | SCN00050 | Monthly | No | 0 | 200 | 0.00% | 0.00% | 2.00% | 2 | $6.99 | $0.20 | ||||
22 | SCN00050 | Annual | 7 Days | 1,000 | 0 | 10.00% | 20.00% | 2.00% | 1 | $39.99 | $0.56 | ||||
23 | |||||||||||||||
24 | Segment | Users | Cost | CPI | User LTV | Margin | Projected Revenue | Projected Profit | |||||||
25 | Subs Setup #1 | 10,000 | $3,000 | $0.30 | $3.05 | $3.05 | 90.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.85 | 64.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.17 | 74.46% | $11,745.30 | $8,745.30 | ||||||
32 | SCN00050 | $0.20 | |||||||||||||
33 | SCN00050 | $0.56 | |||||||||||||
34 | |||||||||||||||
35 | |||||||||||||||