| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | AA | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Fixed value | Dec 2023 | Jan 2024 | Feb 2024 | Mar 2024 | Apr 2024 | May 2024 | Jun 2024 | Jul 2024 | Aug 2024 | Sep 2024 | Oct 2024 | Nov 2024 | Dec 2024 | Value checker | ||||||||||||
2 | Acquisition during the month - Paid Referral | ||||||||||||||||||||||||||
3 | % Learners that start invitation flow | 20% | |||||||||||||||||||||||||
4 | Invitation flow completion rate | 80% | |||||||||||||||||||||||||
5 | # Invitations per inviter | 4.2 | |||||||||||||||||||||||||
6 | |||||||||||||||||||||||||||
7 | % Recipients that open the invitation | 70% | |||||||||||||||||||||||||
8 | % Recipients that click the invitation | 20% | |||||||||||||||||||||||||
9 | % Recipients that finish the signup flow | 45% | |||||||||||||||||||||||||
10 | The signups are distributed the following way: | ||||||||||||||||||||||||||
11 | ...signed up to Basic | 80% | |||||||||||||||||||||||||
12 | ...signed up to Professional | 18% | |||||||||||||||||||||||||
13 | ...signed up to Premium | 2% | |||||||||||||||||||||||||
14 | |||||||||||||||||||||||||||
15 | Total Learners | 18,352 | 11,793 | 9,364 | 7,969 | 6,974 | 6,223 | 5,658 | 5,240 | 4,939 | 4,733 | 4,600 | 4,527 | 4,499 | TRUE | 4,499 | |||||||||||
16 | % Learners that start invitation flow | 3,670 | 2,359 | 1,873 | 1,594 | 1,395 | 1,245 | 1,132 | 1,048 | 988 | 947 | 920 | 905 | 900 | TRUE | 900 | |||||||||||
17 | Invitation flow completion rate | 2,936 | 1,887 | 1,498 | 1,275 | 1,116 | 996 | 905 | 838 | 790 | 757 | 736 | 724 | 720 | TRUE | 720 | |||||||||||
18 | # Total Invitations | 12,333 | 7,925 | 6,293 | 5,355 | 4,686 | 4,182 | 3,802 | 3,521 | 3,319 | 3,180 | 3,091 | 3,042 | 3,024 | TRUE | 3,024 | |||||||||||
19 | |||||||||||||||||||||||||||
20 | # Recipients that open the invitation | 8,633 | 5,548 | 4,405 | 3,749 | 3,280 | 2,927 | 2,661 | 2,465 | 2,323 | 2,226 | 2,164 | 2,129 | 2,117 | TRUE | 2,117 | |||||||||||
21 | # Recipients that click the invitation | 1,727 | 1,110 | 881 | 750 | 656 | 585 | 532 | 493 | 465 | 445 | 433 | 426 | 423 | TRUE | 423 | |||||||||||
22 | # Recipients that finish the signup flow... | 777 | 499 | 396 | 337 | 295 | 263 | 240 | 222 | 209 | 200 | 195 | 192 | 190 | TRUE | 190 | |||||||||||
23 | ...signed up to Basic | 622 | 399 | 317 | 270 | 236 | 211 | 192 | 177 | 167 | 160 | 156 | 153 | 152 | TRUE | 152 | |||||||||||
24 | ...signed up to Professional | 140 | 90 | 71 | 61 | 53 | 47 | 43 | 40 | 38 | 36 | 35 | 34 | 34 | TRUE | 34 | |||||||||||
25 | ...signed up to Premium | 16 | 10 | 8 | 7 | 6 | 5 | 5 | 4 | 4 | 4 | 4 | 4 | 4 | TRUE | 4 | |||||||||||
26 | If they sign up for a paid plan, then both learners are instantly paid a referral bonus of 50$ | ||||||||||||||||||||||||||
27 | Customer Acquisition Cost | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | TRUE | $100.00 | |||||||||||
28 | |||||||||||||||||||||||||||
29 | Acquisition during the month - Paid Search | ||||||||||||||||||||||||||
30 | Total Ad Budget | $95,000 | $100,000 | $105,000 | $110,000 | $115,000 | $120,000 | $125,000 | $130,000 | $135,000 | $140,000 | $145,000 | $150,000 | $155,000 | |||||||||||||
31 | Cost per Click (CpC) | $2.70 | $2.70 | $2.70 | $2.70 | $2.70 | $2.70 | $2.70 | $2.70 | $2.70 | $2.70 | $2.70 | $2.70 | $2.70 | |||||||||||||
32 | Ad CTR on Google | 3.14% | |||||||||||||||||||||||||
33 | % Landing page visitors that start the signup flow | 10% | |||||||||||||||||||||||||
34 | % Landing page visitors that complete the signup flow... | 25% | |||||||||||||||||||||||||
35 | ...signed up to Free | 65% | |||||||||||||||||||||||||
36 | ...signed up to Basic | 25% | |||||||||||||||||||||||||
37 | ...signed up to Professional | 9% | |||||||||||||||||||||||||
38 | ...signed up to Premium | 1% | |||||||||||||||||||||||||
39 | |||||||||||||||||||||||||||
40 | Number of Clicks | 35,185 | 37,037 | 38,889 | 40,741 | 42,593 | 44,444 | 46,296 | 48,148 | 50,000 | 51,852 | 53,704 | 55,556 | 57,407 | TRUE | 57,407 | |||||||||||
41 | # Landing page visitors that start the signup flow | 3,519 | 3,704 | 3,889 | 4,074 | 4,259 | 4,444 | 4,630 | 4,815 | 5,000 | 5,185 | 5,370 | 5,556 | 5,741 | TRUE | 5,741 | |||||||||||
42 | # Total Landing page visitors that complete the signup flow | 880 | 926 | 972 | 1,019 | 1,065 | 1,111 | 1,157 | 1,204 | 1,250 | 1,296 | 1,343 | 1,389 | 1,435 | TRUE | 1,435 | |||||||||||
43 | ...signed up to Free | 572 | 602 | 632 | 662 | 692 | 722 | 752 | 782 | 813 | 843 | 873 | 903 | 933 | TRUE | 933 | |||||||||||
44 | ...signed up to Basic | 220 | 231 | 243 | 255 | 266 | 278 | 289 | 301 | 313 | 324 | 336 | 347 | 359 | TRUE | 359 | |||||||||||
45 | ...signed up to Professional | 79 | 83 | 88 | 92 | 96 | 100 | 104 | 108 | 113 | 117 | 121 | 125 | 129 | TRUE | 129 | |||||||||||
46 | ...signed up to Premium | 9 | 9 | 10 | 10 | 11 | 11 | 12 | 12 | 13 | 13 | 13 | 14 | 14 | TRUE | 14 | |||||||||||
47 | |||||||||||||||||||||||||||
48 | Credit Card Fees | ||||||||||||||||||||||||||
49 | Stripe Charge - Percentage | 2.90% | |||||||||||||||||||||||||
50 | Stripe Charge - Flat | $0.30 | |||||||||||||||||||||||||
51 | |||||||||||||||||||||||||||
52 | Monthly Support Cost | ||||||||||||||||||||||||||
53 | Support cost per month - Free | $5.00 | |||||||||||||||||||||||||
54 | Support cost per month - Basic | $10.00 | |||||||||||||||||||||||||
55 | Support cost per month - Pro | $15.00 | |||||||||||||||||||||||||
56 | Support cost per month - Premium | $23.00 | |||||||||||||||||||||||||
57 | |||||||||||||||||||||||||||
58 | Learner License Price / Month | ||||||||||||||||||||||||||
59 | Free Tier | $0.00 | |||||||||||||||||||||||||
60 | Basic Tier | $100.00 | |||||||||||||||||||||||||
61 | Professional Tier | $250.00 | |||||||||||||||||||||||||
62 | Premium Tier | $500.00 | |||||||||||||||||||||||||
63 | |||||||||||||||||||||||||||
64 | Plan Upsell | ||||||||||||||||||||||||||
65 | Free Tier Users | 8561 | 2,284 | 1,059 | 844 | 831 | 858 | 894 | 931 | 969 | 1,006 | 1,044 | 1,081 | 1,119 | |||||||||||||
66 | % Learners that are upsold higher plan | 50% | 4,281 | 1,142 | 529 | 422 | 415 | 429 | 447 | 466 | 484 | 503 | 522 | 541 | 560 | TRUE | 560 | ||||||||||
67 | % Learners that convert on upsell... | 20% | 856 | 228 | 106 | 84 | 83 | 86 | 89 | 93 | 97 | 101 | 104 | 108 | 112 | TRUE | 112 | ||||||||||
68 | ...signed up to Basic | 80% | 685 | 183 | 85 | 67 | 66 | 69 | 72 | 74 | 77 | 80 | 84 | 87 | 90 | TRUE | 90 | ||||||||||
69 | ...signed up to Professional | 18% | 154 | 41 | 19 | 15 | 15 | 15 | 16 | 17 | 17 | 18 | 19 | 19 | 20 | TRUE | 20 | ||||||||||
70 | ...signed up to Premium | 2% | 17 | 5 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | TRUE | 2 | ||||||||||
71 | Basic Tier Users | 6961 | 6,519 | 5,508 | 4,624 | 3,939 | 3,424 | 3,040 | 2,757 | 2,552 | 2,406 | 2,308 | 2,246 | 2,212 | |||||||||||||
72 | % Learners that are upsold higher plan | 30% | 2,088 | 1,956 | 1,652 | 1,387 | 1,182 | 1,027 | 912 | 827 | 766 | 722 | 692 | 674 | 664 | TRUE | 664 | ||||||||||
73 | % Learners that convert on upsell... | 40% | 835 | 782 | 661 | 555 | 473 | 411 | 365 | 331 | 306 | 289 | 277 | 270 | 265 | TRUE | 265 | ||||||||||
74 | ...signed up to Professional | 95% | 794 | 743 | 628 | 527 | 449 | 390 | 347 | 314 | 291 | 274 | 263 | 256 | 252 | TRUE | 252 | ||||||||||
75 | ...signed up to Premium | 5% | 42 | 39 | 33 | 28 | 24 | 21 | 18 | 17 | 15 | 14 | 14 | 13 | 13 | TRUE | 13 | ||||||||||
76 | Professional Tier Users | 2037 | 2,559 | 2,524 | 2,302 | 2,043 | 1,804 | 1,603 | 1,443 | 1,319 | 1,226 | 1,159 | 1,113 | 1,083 | |||||||||||||
77 | % Learners that are upsold higher plan | 30% | 611 | 768 | 757 | 690 | 613 | 541 | 481 | 433 | 396 | 368 | 348 | 334 | 325 | TRUE | 325 | ||||||||||
78 | % Learners that convert on upsell - Premium | 5% | 31 | 38 | 38 | 35 | 31 | 27 | 24 | 22 | 20 | 18 | 17 | 17 | 16 | TRUE | 16 | ||||||||||
79 | |||||||||||||||||||||||||||
80 | Plan Downgrade | ||||||||||||||||||||||||||
81 | Professional Tier Users | 2037 | 2,559 | 2,524 | 2,302 | 2,043 | 1,804 | 1,603 | 1,443 | 1,319 | 1,226 | 1,159 | 1,113 | 1,083 | 1,083 | ||||||||||||
82 | % Learners that start the plan downgrade flow | 5% | 102 | 128 | 126 | 115 | 102 | 90 | 80 | 72 | 66 | 61 | 58 | 56 | 54 | TRUE | 54 | ||||||||||
83 | % Learners that complete the downgrade to Basic | 90% | 92 | 115 | 114 | 104 | 92 | 81 | 72 | 65 | 59 | 55 | 52 | 50 | 49 | TRUE | 49 | ||||||||||
84 | |||||||||||||||||||||||||||
85 | Premium Tier Users | 793 | 431 | 274 | 200 | 161 | 137 | 120 | 109 | 100 | 94 | 89 | 86 | 85 | 85 | ||||||||||||
86 | % Learners that start the plan downgrade flow | 40% | 317 | 172 | 109 | 80 | 64 | 55 | 48 | 43 | 40 | 37 | 36 | 35 | 34 | TRUE | 34 | ||||||||||
87 | % Learners that complete the downgrade... | 90% | 285 | 155 | 99 | 72 | 58 | 49 | 43 | 39 | 36 | 34 | 32 | 31 | 30 | TRUE | 30 | ||||||||||
88 | ...signed up to Basic | 10% | 29 | 16 | 10 | 7 | 6 | 5 | 4 | 4 | 4 | 3 | 3 | 3 | 3 | TRUE | 3 | ||||||||||
89 | ...signed up to Professional | 90% | 257 | 140 | 89 | 65 | 52 | 44 | 39 | 35 | 32 | 30 | 29 | 28 | 27 | TRUE | 27 | ||||||||||
90 | |||||||||||||||||||||||||||
91 | Plan Cancellation | ||||||||||||||||||||||||||
92 | Basic Tier Users | 6961 | 6,519 | 5,508 | 4,624 | 3,939 | 3,424 | 3,040 | 2,757 | 2,552 | 2,406 | 2,308 | 2,246 | 2,212 | |||||||||||||
93 | % Learners that start plan cancellation flow | 20% | 1,392 | 1,304 | 1,102 | 925 | 788 | 685 | 608 | 551 | 510 | 481 | 462 | 449 | 442 | TRUE | 442 | ||||||||||
94 | % Learners that complete cancellation | 90% | 1,253 | 1,173 | 991 | 832 | 709 | 616 | 547 | 496 | 459 | 433 | 415 | 404 | 398 | TRUE | 398 | ||||||||||
95 | |||||||||||||||||||||||||||
96 | Professional Tier Users | 2037 | 2,559 | 2,524 | 2,302 | 2,043 | 1,804 | 1,603 | 1,443 | 1,319 | 1,226 | 1,159 | 1,113 | 1,083 | |||||||||||||
97 | % Learners that start plan cancellation flow | 45% | 917 | 1,152 | 1,136 | 1,036 | 919 | 812 | 721 | 649 | 594 | 552 | 522 | 501 | 488 | TRUE | 488 | ||||||||||
98 | % Learners that complete cancellation | 85% | 779 | 979 | 965 | 880 | 781 | 690 | 613 | 552 | 504 | 469 | 443 | 426 | 414 | TRUE | 414 | ||||||||||
99 | |||||||||||||||||||||||||||
100 | Premium Tier Users | 793 | 431 | 274 | 200 | 161 | 137 | 120 | 109 | 100 | 94 | 89 | 86 | 85 |