Skip to content

Instantly share code, notes, and snippets.

@jackross
Created September 19, 2014 16:51
Show Gist options
  • Save jackross/ffde385fa91f73d272bf to your computer and use it in GitHub Desktop.
Save jackross/ffde385fa91f73d272bf to your computer and use it in GitHub Desktop.
October 2011 - 2015 Payment Month

----------------------------------------------------------------
Sourcing data from facts.memberships for Oct 2011
Sourcing data from facts.memberships for Oct 2010
Payment Month # Pmts Payment $ Avg Pmt $ Reg Pmt $ Def Pmt $ % Def $
------------- ------- ---------- ---------- ---------- ---------- --------
Oct 2010 34017 1313515 38.61 425800 887715 0.67583
Oct 2011 35298 1278274 36.21 441042 837232 0.65497
Expire Group Activation Segment # Pmts % Pmts Pmt $ Avg Pmt $ % Pmt $ Cum % Pmt $ Impact
---------------- -------------------- ------- ------- ------ ---------- -------- ------------ --------
Jan 2013 Expires B. Continuous/Def 14421 0.40855 632172 43.84 0.49455 0.49455 1.21050
Oct 2012 Expires C. Consecutive 5631 0.15953 109105 19.38 0.08535 0.57990 0.53504
Oct 2012 Expires B. Continuous/Reg 2282 0.06465 95535 41.86 0.07474 0.65464 1.15603
Dec 2012 Expires B. Continuous/Def 2160 0.06119 80750 37.38 0.06317 0.71781 1.03232
Nov 2012 Expires B. Continuous/Reg 1900 0.05383 74260 39.08 0.05809 0.77591 1.07925
Jan 2013 Expires B. Continuous/Reg 1557 0.04411 69765 44.81 0.05458 0.83048 1.23729
Sep 2012 Expires B. Continuous/Reg 871 0.02468 34635 39.76 0.02710 0.85758 1.09805
Feb 2013 Expires B. Continuous/Def 1360 0.03853 32415 23.83 0.02536 0.88294 0.65815
Nov 2012 Expires B. Continuous/Def 789 0.02235 30375 38.50 0.02376 0.90670 1.06306
Apr 2013 Expires B. Continuous/Def 712 0.02017 22925 32.20 0.01793 0.92463 0.88909
----------------------------------------------------------------
Sourcing data from facts.memberships for Oct 2012
Sourcing data from facts.memberships for Oct 2011
Payment Month # Pmts Payment $ Avg Pmt $ Reg Pmt $ Def Pmt $ % Def $
------------- ------- ---------- ---------- ---------- ---------- --------
Oct 2011 35298 1278274 36.21 441042 837232 0.65497
Oct 2012 54133 1322361 24.43 556549 765812 0.57912
Expire Group Activation Segment # Pmts % Pmts Pmt $ Avg Pmt $ % Pmt $ Cum % Pmt $ Impact
---------------- -------------------- ------- ------- ------ ---------- -------- ------------ --------
Feb 2014 Expires B. Continuous/Def 10933 0.20197 413257 37.80 0.31251 0.31251 1.54736
Jan 2014 Expires B. Continuous/Def 3433 0.06342 150500 43.84 0.11381 0.42633 1.79462
Dec 2013 Expires B. Continuous/Def 4414 0.08154 141875 32.14 0.10729 0.53361 1.31579
Oct 2013 Expires C. Consecutive 6854 0.12661 111337 16.24 0.08420 0.61781 0.66497
Oct 2013 Expires D. Revived 9735 0.17983 104532 10.74 0.07905 0.69686 0.43956
Oct 2013 Expires B. Continuous/Reg 2148 0.03968 81475 37.93 0.06161 0.75847 1.55275
Oct 2013 Expires A. Newborn 5228 0.09658 56160 10.74 0.04247 0.80094 0.43974
Nov 2013 Expires B. Continuous/Reg 1171 0.02163 46710 39.89 0.03532 0.83627 1.63291
Oct 2013 Expires E. Reborn 2909 0.05374 31150 10.71 0.02356 0.85982 0.43835
Sep 2013 Expires B. Continuous/Reg 724 0.01337 28205 38.96 0.02133 0.88115 1.59476
----------------------------------------------------------------
Sourcing data from facts.memberships for Oct 2013
Sourcing data from facts.memberships for Oct 2012
Payment Month # Pmts Payment $ Avg Pmt $ Reg Pmt $ Def Pmt $ % Def $
------------- ------- ---------- ---------- ---------- ---------- --------
Oct 2012 54133 1322361 24.43 556549 765812 0.57912
Oct 2013 51851 1296459 25.00 492810 803649 0.61988
Expire Group Activation Segment # Pmts % Pmts Pmt $ Avg Pmt $ % Pmt $ Cum % Pmt $ Impact
---------------- -------------------- ------- ------- ------ ---------- -------- ------------ --------
Feb 2015 Expires B. Continuous/Def 11771 0.22702 432871 36.77 0.33389 0.33389 1.47077
Dec 2014 Expires B. Continuous/Def 4793 0.09244 153073 31.94 0.11807 0.45196 1.27729
Jan 2015 Expires B. Continuous/Def 2744 0.05292 125100 45.59 0.09649 0.54845 1.82334
Oct 2014 Expires C. Consecutive 7339 0.14154 106891 14.56 0.08245 0.63090 0.58251
Oct 2014 Expires D. Revived 7473 0.14412 85396 11.43 0.06587 0.69677 0.45702
Oct 2014 Expires B. Continuous/Reg 2582 0.04980 81845 31.70 0.06313 0.75990 1.26774
Oct 2014 Expires A. Newborn 7150 0.13790 78078 10.92 0.06022 0.82012 0.43673
Mar 2015 Expires B. Continuous/Def 1227 0.02366 52555 42.83 0.04054 0.86066 1.71303
Nov 2014 Expires B. Continuous/Reg 953 0.01838 36400 38.20 0.02808 0.88874 1.52756
Oct 2014 Expires E. Reborn 2489 0.04800 27955 11.23 0.02156 0.91030 0.44918
----------------------------------------------------------------
Sourcing data from simulation for Oct 2014
Sourcing data from facts.memberships for Oct 2013
Payment Month # Pmts Payment $ Avg Pmt $ Reg Pmt $ Def Pmt $ % Def $
------------- ------- ---------- ---------- ---------- ---------- --------
Oct 2013 51851 1296459 25.00 492810 803649 0.61988
Oct 2014 47104 1363434 28.95 441745 921689 0.67600
Expire Group Activation Segment # Pmts % Pmts Pmt $ Avg Pmt $ % Pmt $ Cum % Pmt $ Impact
---------------- -------------------- ------- ------- ------ ---------- -------- ------------ --------
Feb 2016 Expires B. Continuous/Def 13094 0.27798 520869 39.78 0.38203 0.38203 1.37429
Dec 2015 Expires B. Continuous/Def 5159 0.10952 171134 33.17 0.12552 0.50754 1.14603
Mar 2016 Expires B. Continuous/Def 3231 0.06859 136252 42.17 0.09993 0.60748 1.45689
Oct 2015 Expires D. Revived 11033 0.23423 134087 12.15 0.09834 0.70582 0.41987
Oct 2015 Expires B. Continuous/Reg 3234 0.06866 99303 30.71 0.07283 0.77865 1.06082
Jan 2016 Expires B. Continuous/Def 1595 0.03386 74466 46.69 0.05462 0.83327 1.61294
Oct 2015 Expires A. Newborn 5734 0.12173 64183 11.19 0.04707 0.88035 0.38671
Oct 2015 Expires C. Consecutive 1588 0.03371 57477 36.19 0.04215 0.92250 1.25042
Nov 2015 Expires B. Continuous/Reg 913 0.01938 36474 39.95 0.02675 0.94925 1.38015
Sep 2015 Expires B. Continuous/Reg 805 0.01709 33048 41.05 0.02424 0.97349 1.41827
----------------------------------------------------------------
Sourcing data from simulation for Oct 2015
Sourcing data from simulation for Oct 2014
Payment Month # Pmts Payment $ Avg Pmt $ Reg Pmt $ Def Pmt $ % Def $
------------- ------- ---------- ---------- ---------- ---------- --------
Oct 2014 47104 1363434 28.95 441745 921689 0.67600
Oct 2015 41698 1356266 32.53 382794 973472 0.71776
Expire Group Activation Segment # Pmts % Pmts Pmt $ Avg Pmt $ % Pmt $ Cum % Pmt $ Impact
---------------- -------------------- ------- ------- ------ ---------- -------- ------------ --------
Feb 2017 Expires B. Continuous/Def 13146 0.31527 534831 40.68 0.39434 0.39434 1.25081
Mar 2017 Expires B. Continuous/Def 3406 0.08168 158089 46.41 0.11656 0.51090 1.42700
Dec 2016 Expires B. Continuous/Def 4301 0.10315 151820 35.30 0.11194 0.62284 1.08524
Jan 2017 Expires B. Continuous/Def 2123 0.05091 110993 52.28 0.08184 0.70468 1.60735
Oct 2016 Expires B. Continuous/Reg 3118 0.07478 101480 32.55 0.07482 0.77950 1.00062
Oct 2016 Expires D. Revived 7630 0.18298 93998 12.32 0.06931 0.84881 0.37876
Oct 2016 Expires C. Consecutive 1554 0.03727 54948 35.36 0.04051 0.88932 1.08710
Oct 2016 Expires A. Newborn 3627 0.08698 41932 11.56 0.03092 0.92024 0.35544
Nov 2016 Expires B. Continuous/Reg 1146 0.02748 40603 35.43 0.02994 0.95018 1.08928
Sep 2016 Expires B. Continuous/Reg 1032 0.02475 36453 35.32 0.02688 0.97705 1.08597
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment