Spreadsheet: 861065d1709052671-building-customer-cohort-chart-with-dynamic-renewal-rates-and-periods-subscriber-cohort-chart
Sheet: Sheet1

 | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 | 2024-06-01 00:00:00 | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00 | 2024-10-01 00:00:00 | 2024-11-01 00:00:00 | 2024-12-01 00:00:00 | 2025-01-01 00:00:00 | 2025-02-01 00:00:00 | 2025-03-01 00:00:00 | 2025-04-01 00:00:00 | 2025-05-01 00:00:00 | 2025-06-01 00:00:00 | 2025-07-01 00:00:00 | 2025-08-01 00:00:00 | 2025-09-01 00:00:00 | 2025-10-01 00:00:00 | 2025-11-01 00:00:00 | 2025-12-01 00:00:00 | 2026-01-01 00:00:00 | 2026-02-01 00:00:00 | 2026-03-01 00:00:00 | 2026-04-01 00:00:00 | 2026-05-01 00:00:00 | 2026-06-01 00:00:00 | 2026-07-01 00:00:00 | 2026-08-01 00:00:00 | 2026-09-01 00:00:00 | 2026-10-01 00:00:00 | 2026-11-01 00:00:00 | 2026-12-01 00:00:00 | 2027-01-01 00:00:00 | 2027-02-01 00:00:00 | 2027-03-01 00:00:00 | 2027-04-01 00:00:00 | 2027-05-01 00:00:00 | 2027-06-01 00:00:00 | 2027-07-01 00:00:00 | 2027-08-01 00:00:00 | 2027-09-01 00:00:00 | 2027-10-01 00:00:00 | 2027-11-01 00:00:00 | 2027-12-01 00:00:00 | 2028-01-01 00:00:00 | 2028-02-01 00:00:00 | 2028-03-01 00:00:00
New subscribers
Annual | 1000 |  | 1040.4 | 1061.208 | 1082.43216 | 1104.0808032 | 1126.162419264 | 1148.68566764928 | 1171.659381002266 | 1195.092568622311 | 1218.994419994757 | 1243.374308394653 | 1268.241794562546 | 1293.606630453797 | 1319.478763062873 | 1345.86833832413 | 1372.785705090613 | 1400.241419192425 | 1428.246247576274 | 1456.811172527799 | 1485.947395978355 | 1515.666343897922 | 1545.979670775881 | 1576.899264191398 | 1608.437249475226 | 1640.605994464731 | 1673.418114354025 | 1706.886476641106 | 1741.024206173928 | 1775.844690297406 | 1811.361584103355 | 1847.588815785422 | 1884.54059210113 | 1922.231403943153 | 1960.676032022016 | 1999.889552662456 | 2039.887343715706 | 2080.68509059002 | 2122.29879240182 | 2164.744768249857 | 2208.039663614854 | 2252.200456887151 | 2297.244466024894 | 2343.189355345392 | 2390.0531424523 | 2437.854205301346 | 2486.611289407373 | 2536.34351519552
Quarterly | 200 |  | 208.08 | 212.2416 | 216.486432 | 220.81616064 | 225.2324838528 | 229.737133529856 | 234.3318762004531 | 239.0185137244622 | 243.7988839989515 | 248.6748616789305 | 253.6483589125091 | 258.7213260907593 | 263.8957526125745 | 269.173667664826 | 274.5571410181225 | 280.048283838485 | 285.6492495152547 | 291.3622345055598 | 297.189479195671 | 303.1332687795845 | 309.1959341551761 | 315.3798528382796 | 321.6874498950452 | 328.1211988929462 | 334.6836228708051 | 341.3772953282212 | 348.2048412347856 | 355.1689380594813 | 362.2723168206709 | 369.5177631570843 | 376.9081184202261 | 384.4462807886306 | 392.1352064044032 | 399.9779105324913 | 407.9774687431411 | 416.1370181180039 | 424.459758480364 | 432.9489536499713 | 441.6079327229708 | 450.4400913774302 | 459.4488932049788 | 468.6378710690784 | 478.0106284904599 | 487.5708410602691 | 497.3222578814745 | 507.268703039104
Retention rates
Annual | 0.5 |  | 0.51005 | 0.5151505 | 0.520302005 | 0.52550502505 | 0.5307600753005 | 0.5360676760535049 | 0.54142835281404 | 0.5468426363421804 | 0.5523110627056023 | 0.5578341733326583 | 0.5634125150659849 | 0.5690466402166448 | 0.5747371066188112 | 0.5804844776849993 | 0.5862893224618493 | 0.5921522156864678 | 0.5980737378433325 | 0.6040544752217658 | 0.6100950199739835 | 0.6161959701737234 | 0.6223579298754607 | 0.6285815091742153 | 0.6348673242659575 | 0.641215997508617 | 0.6476281574837032 | 0.6541044390585402 | 0.6606454834491257 | 0.667251938283617 | 0.6739244576664531 | 0.6806637022431177 | 0.6874703392655489 | 0.6943450426582044 | 0.7012884930847865 | 0.7083013780156343 | 0.7153843917957906 | 0.7225382357137485 | 0.7297636180708861 | 0.737061254251595 | 0.7444318667941109 | 0.751876185462052 | 0.7593949473166726 | 0.7669888967898393 | 0.7746587857577377 | 0.7824053736153151 | 0.7902294273514683 | 0.798131721624983
Quarterly | 0.4 |  | 0.40804 | 0.4121204 | 0.416241604 | 0.42040402004 | 0.4246080602404 | 0.428854140842804 | 0.433142682251232 | 0.4374741090737443 | 0.4418488501644818 | 0.4462673386661266 | 0.4507300120527879 | 0.4552373121733158 | 0.4597896852950489 | 0.4643875821479994 | 0.4690314579694794 | 0.4737217725491742 | 0.478458990274666 | 0.4832435801774126 | 0.4880760159791868 | 0.4929567761389786 | 0.4978863439003685 | 0.5028652073393721 | 0.5078938594127659 | 0.5129727980068935 | 0.5181025259869625 | 0.5232835512468321 | 0.5285163867593005 | 0.5338015506268935 | 0.5391395661331624 | 0.544530961794494 | 0.549976271412439 | 0.5554760341265634 | 0.5610307944678291 | 0.5666411024125074 | 0.5723075134366326 | 0.5780305885709989 | 0.5838108944567089 | 0.5896490034012759 | 0.5955454934352886 | 0.6015009483696415 | 0.6075159578533379 | 0.6135911174318712 | 0.6197270286061899 | 0.6259242988922518 | 0.6321835418811743 | 0.638505377299986
Active subscribers
Annual
Total active quarterly subscribers |  | 404 | 612.08 | 706.7456800000001 | 804.9696400160001 | 906.8650852260832 | 963.3284471282732 | 1022.089305105378 | 1083.236537955193 | 1110.079305570826 | 1137.639085509418 | 1165.936621905934 | 1194.993306184892 | 1224.831198604799 | 1255.473050557148 | 1286.942327647434 | 1319.26323358667 | 1352.460734922957 | 1386.56058664377 | 1421.589358680776 | 1457.574463350166 | 1494.544183762769 | 1532.527703239471 | 1571.555135768797 | 1611.65755754492 | 1652.867039625797 | 1695.216681752609 | 1738.740647373271 | 1783.474199914352 | 1829.453740347455 | 1876.716846097821 | 1925.302311344749 | 1975.250188765285 | 2026.601832774578 | 2079.399944318353 | 2133.688617275022 | 2189.513386527143 | 2246.921277764221 | 2305.960859081188 | 2366.682294439328 | 2429.137399058996 | 2493.379696816073 | 2559.464479716861 | 2627.448869528977 | 2697.391881648738 | 2769.354491288624 | 2843.399702071567 | 2919.592617122179
Quarterly
 |  | 200 | 204 | 208.08 | 212.2416 | 216.486432 | 220.81616064 | 225.2324838528 | 229.737133529856 | 234.3318762004532 | 239.0185137244622 | 243.7988839989515 | 248.6748616789305 | 253.6483589125091 | 258.7213260907594 | 263.8957526125745 | 269.173667664826 | 274.5571410181226 | 280.048283838485 | 285.6492495152547 | 291.3622345055598 | 297.189479195671 | 303.1332687795845 | 309.1959341551761 | 315.3798528382797 | 321.6874498950453 | 328.1211988929462 | 334.6836228708051 | 341.3772953282212 | 348.2048412347856 | 355.1689380594813 | 362.272316820671 | 369.5177631570844 | 376.9081184202261 | 384.4462807886306 | 392.1352064044033 | 399.9779105324913 | 407.9774687431411 | 416.1370181180039 | 424.4597584803641 | 432.9489536499714 | 441.6079327229708 | 450.4400913774302 | 459.4488932049789 | 468.6378710690785 | 478.01062849046 | 487.5708410602692 | 497.3222578814746
 |  |  | 200 | 204 | 208.08 | 212.2416 | 216.486432 | 220.81616064 | 225.2324838528 | 229.737133529856 | 234.3318762004532 | 239.0185137244622 | 243.7988839989515 | 248.6748616789305 | 253.6483589125091 | 258.7213260907594 | 263.8957526125745 | 269.173667664826 | 274.5571410181226 | 280.048283838485 | 285.6492495152547 | 291.3622345055598 | 297.189479195671 | 303.1332687795845 | 309.1959341551761 | 315.3798528382797 | 321.6874498950453 | 328.1211988929462 | 334.6836228708051 | 341.3772953282212 | 348.2048412347856 | 355.1689380594813 | 362.272316820671 | 369.5177631570844 | 376.9081184202261 | 384.4462807886306 | 392.1352064044033 | 399.9779105324913 | 407.9774687431411 | 416.1370181180039 | 424.4597584803641 | 432.9489536499714 | 441.6079327229708 | 450.4400913774302 | 459.4488932049789 | 468.6378710690785 | 478.01062849046 | 487.5708410602692
 |  |  |  |  | 83.2483208 | 85.76242008816 | 88.35244517482245 | 91.02068901910208 | 93.76951382747896 | 96.60135314506883 | 99.51871401004988 | 102.5241791731534 | 105.6204093841827 | 108.810145747585 | 112.0962121491621 | 115.4815177560668 | 118.9690595923 | 122.5619251919874 | 126.2632953327855 | 130.0764468518356 | 134.004755546761 | 138.0516991642732 | 142.2208604790343 | 146.5159304655011 | 150.9407115655592 | 155.4991210548392 | 160.1951945106953 | 165.0330893849183 | 170.0170886843428 | 175.15160476261 | 180.4411832264408 | 185.8905069598793 | 191.5044002700677 | 197.2878331582237 | 203.2459257196021 | 209.3839526763341 | 215.7073480471595 | 222.2217099581837 | 228.9328055989208 | 235.8465763280082 | 242.969142933114 | 250.3068110496941 | 257.8660767433948 | 265.6536322610453 | 273.6763719553289 | 281.9413983883799 | 290.4560286197089 | 299.2278006840242
 |  |  |  |  |  | 84.080804008 | 86.6200442890416 | 89.23596962657066 | 91.9308959092931 | 94.70720896575375 | 97.56736667651951 | 100.5139011501504 | 103.5494209648849 | 106.6766134780245 | 109.8982472050608 | 113.2171742706537 | 116.6363329336274 | 120.158750188223 | 123.7875444439073 | 127.5259282861133 | 131.377211320354 | 135.3448031022286 | 139.4322161559159 | 143.6430690838246 | 147.9810897701561 | 152.4501186812149 | 157.0541122653875 | 161.7971464558022 | 166.6834202787675 | 171.7172595711863 | 176.9031208102361 | 182.2455950587052 | 187.7494120294781 | 193.4194442727684 | 199.260711489806 | 205.2783849767982 | 211.4777922030975 | 217.864421527631 | 224.4439270577655 | 231.22213365491 | 238.2050420912882 | 245.3988343624452 | 252.809879160191 | 260.4447375108288 | 268.3101685836558 | 276.4131356748822 | 284.7608123722637 | 293.360588905906
 |  |  |  |  |  |  |  | 36.05840096422303 | 37.51883832007599 | 39.03842630971571 | 40.61956065211182 | 42.26473409764365 | 43.97654035806642 | 45.75767819564881 | 47.61095567792899 | 49.53929460479647 | 51.54573511487995 | 53.63344047850282 | 55.80570208476314 | 58.06594463060022 | 60.4177315200288 | 62.864770482053 | 65.41091941611712 | 68.06019247430869 | 70.81676638990315 | 73.68498706222701 | 76.66937640822132 | 79.77463949150713 | 83.00567194019216 | 86.36756766511382 | 89.86562689068627 | 93.50536451101284 | 97.29251878443789 | 101.2330603802452 | 105.3332017917659 | 109.599407130736 | 114.0384023183451 | 118.6571856890427 | 123.4630390238204 | 128.4635390303631 | 133.6665692881709 | 139.0803326774804 | 144.7133643115837 | 150.5745449929314 | 156.6731152142351 | 163.018689726642 | 169.6212726979505 | 176.4912734847629
 |  |  |  |  |  |  |  |  | 36.41898497386526 | 37.89402670327675 | 39.42881057281287 | 41.02575625863294 | 42.68738143862009 | 44.41630576164708 | 46.2152549776053 | 48.08706523470828 | 50.03468755084444 | 52.06119246602875 | 54.16977488328785 | 56.36375910561078 | 58.64660407690622 | 61.02190883522909 | 63.49341818687354 | 66.06502861027829 | 68.7407943990518 | 71.52493405380218 | 74.42183693284929 | 77.43607017230354 | 80.57238588642221 | 83.83572865959408 | 87.23124334176495 | 90.76428315959313 | 94.44041815612297 | 98.26544397228227 | 102.2453909840477 | 106.3865338096836 | 110.6954012020434 | 115.1787863415286 | 119.8437575459332 | 124.6976694140586 | 129.7481744206667 | 135.0032349810526 | 140.4711360042552 | 146.1604979546995 | 152.0802904428607 | 158.2398463663774 | 164.6488766239084 | 171.31748542493
Pricing
Annual | 2500 |  | 2601 | 2653.02 | 2706.0804 | 2760.202008 | 2815.40604816 | 2871.7141691232 | 2929.148452505664 | 2987.731421555777 | 3047.486049986893 | 3108.435770986631 | 3170.604486406363 | 3234.016576134491 | 3298.69690765718 | 3364.670845810324 | 3431.964262726531 | 3500.603547981061 | 3570.615618940682 | 3642.027931319496 | 3714.868489945886 | 3789.165859744804 | 3864.9491769397 | 3942.248160478493 | 4021.093123688063 | 4101.514986161825 | 4183.545285885061 | 4267.216191602763 | 4352.560515434818 | 4439.611725743514 | 4528.403960258384 | 4618.972039463552 | 4711.351480252823 | 4805.57850985788 | 4901.690080055037 | 4999.723881656138 | 5099.718359289262 | 5201.712726475047 | 5305.746981004548 | 5411.861920624639 | 5520.099159037131 | 5630.501142217874 | 5743.111165062232 | 5857.973388363476 | 5975.132856130745 | 6094.635513253361 | 6216.528223518429 | 6340.858787988797
Quarterly | 750 |  | 780.3000000000001 | 795.9060000000001 | 811.8241200000001 | 828.0606024000001 | 844.6218144480001 | 861.5142507369601 | 878.7445357516993 | 896.3194264667334 | 914.245814996068 | 932.5307312959894 | 951.1813459219093 | 970.2049728403475 | 989.6090722971545 | 1009.401253743098 | 1029.58927881796 | 1050.181064394319 | 1071.184685682205 | 1092.608379395849 | 1114.460546983766 | 1136.749757923441 | 1159.48475308191 | 1182.674448143548 | 1206.32793710642 | 1230.454495848548 | 1255.063585765519 | 1280.164857480829 | 1305.768154630446 | 1331.883517723055 | 1358.521188077516 | 1385.691611839066 | 1413.405444075848 | 1441.673552957365 | 1470.507024016512 | 1499.917164496842 | 1529.915507786779 | 1560.513817942515 | 1591.724094301365 | 1623.558576187392 | 1656.02974771114 | 1689.150342665363 | 1722.93334951867 | 1757.392016509044 | 1792.539856839225 | 1828.390653976009 | 1864.958467055529 | 1902.25763639664
Total revenue
Annual
Quarterly