Skip to content

Instantly share code, notes, and snippets.

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

----------------------------------------------------------------
Sourcing data from facts.memberships for Nov 2011
Sourcing data from facts.memberships for Nov 2010
Payment Month # Pmts Payment $ Avg Pmt $ Reg Pmt $ Def Pmt $ % Def $
------------- ------- ---------- ---------- ---------- ---------- --------
Nov 2010 32171 1186334 36.88 290652 895682 0.75500
Nov 2011 28318 1054941 37.25 231613 823328 0.78045
Expire Group Activation Segment # Pmts % Pmts Pmt $ Avg Pmt $ % Pmt $ Cum % Pmt $ Impact
---------------- -------------------- ------- ------- ------ ---------- -------- ------------ --------
Feb 2013 Expires B. Continuous/Def 10349 0.36546 399115 38.57 0.37833 0.37833 1.03522
Jan 2013 Expires B. Continuous/Def 4371 0.15435 189503 43.35 0.17963 0.55796 1.16377
Dec 2012 Expires B. Continuous/Def 3567 0.12596 122605 34.37 0.11622 0.67418 0.92265
Nov 2012 Expires B. Continuous/Reg 1540 0.05438 60203 39.09 0.05707 0.73125 1.04937
Nov 2012 Expires C. Consecutive 2060 0.07275 56935 27.64 0.05397 0.78522 0.74189
Oct 2012 Expires B. Continuous/Reg 946 0.03341 36805 38.91 0.03489 0.82011 1.04435
Nov 2012 Expires B. Continuous/Def 725 0.02560 29080 40.11 0.02756 0.84767 1.07667
Apr 2013 Expires B. Continuous/Def 787 0.02779 26910 34.19 0.02551 0.87318 0.91783
Mar 2013 Expires B. Continuous/Def 676 0.02387 25740 38.08 0.02440 0.89758 1.02209
Dec 2012 Expires B. Continuous/Reg 473 0.01670 21570 45.60 0.02045 0.91803 1.22408
----------------------------------------------------------------
Sourcing data from facts.memberships for Nov 2012
Sourcing data from facts.memberships for Nov 2011
Payment Month # Pmts Payment $ Avg Pmt $ Reg Pmt $ Def Pmt $ % Def $
------------- ------- ---------- ---------- ---------- ---------- --------
Nov 2011 28318 1054941 37.25 231613 823328 0.78045
Nov 2012 31849 1178880 37.01 197175 981705 0.83274
Expire Group Activation Segment # Pmts % Pmts Pmt $ Avg Pmt $ % Pmt $ Cum % Pmt $ Impact
---------------- -------------------- ------- ------- ------ ---------- -------- ------------ --------
Mar 2014 Expires B. Continuous/Def 7237 0.22723 317520 43.87 0.26934 0.26934 1.18533
Jan 2014 Expires B. Continuous/Def 6420 0.20158 254965 39.71 0.21628 0.48562 1.07293
Feb 2014 Expires B. Continuous/Def 3311 0.10396 125885 38.02 0.10678 0.59240 1.02716
Dec 2013 Expires B. Continuous/Def 3468 0.10889 107875 31.11 0.09151 0.68391 0.84036
Apr 2014 Expires B. Continuous/Def 2588 0.08126 95265 36.81 0.08081 0.76472 0.99447
Nov 2013 Expires B. Continuous/Reg 1341 0.04210 53705 40.05 0.04555 0.81027 1.08194
Nov 2013 Expires C. Consecutive 1674 0.05256 52190 31.18 0.04427 0.85454 0.84227
Oct 2013 Expires B. Continuous/Reg 893 0.02804 33270 37.26 0.02822 0.88277 1.00651
Nov 2013 Expires B. Continuous/Def 722 0.02267 29155 40.38 0.02473 0.90750 1.09094
May 2014 Expires B. Continuous/Def 537 0.01686 22350 41.62 0.01896 0.92646 1.12438
----------------------------------------------------------------
Sourcing data from facts.memberships for Nov 2013
Sourcing data from facts.memberships for Nov 2012
Payment Month # Pmts Payment $ Avg Pmt $ Reg Pmt $ Def Pmt $ % Def $
------------- ------- ---------- ---------- ---------- ---------- --------
Nov 2012 31849 1178880 37.01 197175 981705 0.83274
Nov 2013 36093 1237584 34.29 225036 1012548 0.81817
Expire Group Activation Segment # Pmts % Pmts Pmt $ Avg Pmt $ % Pmt $ Cum % Pmt $ Impact
---------------- -------------------- ------- ------- ------ ---------- -------- ------------ --------
Mar 2015 Expires B. Continuous/Def 6895 0.19103 300662 43.61 0.24294 0.24294 1.27172
Jan 2015 Expires B. Continuous/Def 6211 0.17208 249739 40.21 0.20180 0.44474 1.17266
Feb 2015 Expires B. Continuous/Def 4595 0.12731 177248 38.57 0.14322 0.58796 1.12497
Dec 2014 Expires B. Continuous/Def 3911 0.10836 123399 31.55 0.09971 0.68767 0.92017
Apr 2015 Expires B. Continuous/Def 2867 0.07943 105925 36.95 0.08559 0.77326 1.07750
Nov 2014 Expires C. Consecutive 2745 0.07605 57175 20.83 0.04620 0.81946 0.60744
Nov 2014 Expires B. Continuous/Reg 1259 0.03488 47795 37.96 0.03862 0.85808 1.10713
Oct 2014 Expires B. Continuous/Reg 1632 0.04522 47371 29.03 0.03828 0.89635 0.84650
Nov 2014 Expires B. Continuous/Def 613 0.01698 26040 42.48 0.02104 0.91739 1.23882
Nov 2014 Expires D. Revived 1701 0.04713 20985 12.34 0.01696 0.93435 0.35978
----------------------------------------------------------------
Sourcing data from simulation for Nov 2014
Sourcing data from facts.memberships for Nov 2013
Payment Month # Pmts Payment $ Avg Pmt $ Reg Pmt $ Def Pmt $ % Def $
------------- ------- ---------- ---------- ---------- ---------- --------
Nov 2013 36093 1237584 34.29 225036 1012548 0.81817
Nov 2014 34701 1119432 32.26 276735 842697 0.75279
Expire Group Activation Segment # Pmts % Pmts Pmt $ Avg Pmt $ % Pmt $ Cum % Pmt $ Impact
---------------- -------------------- ------- ------- ------ ---------- -------- ------------ --------
Mar 2016 Expires B. Continuous/Def 8096 0.23331 356451 44.03 0.31842 0.31842 1.36481
Jan 2016 Expires B. Continuous/Def 4630 0.13343 190388 41.12 0.17008 0.48850 1.27468
Apr 2016 Expires B. Continuous/Def 2917 0.08406 119496 40.97 0.10675 0.59524 1.26988
Dec 2015 Expires B. Continuous/Def 3294 0.09493 105708 32.09 0.09443 0.68967 0.99477
Nov 2015 Expires D. Revived 6471 0.18648 81139 12.54 0.07248 0.76216 0.38869
Oct 2015 Expires B. Continuous/Reg 1918 0.05527 56865 29.65 0.05080 0.81295 0.91905
Nov 2015 Expires C. Consecutive 1255 0.03617 49368 39.34 0.04410 0.85706 1.21940
Feb 2016 Expires B. Continuous/Def 1253 0.03611 48595 38.78 0.04341 0.90046 1.20221
Nov 2015 Expires B. Continuous/Reg 1157 0.03334 42688 36.90 0.03813 0.93860 1.14369
Nov 2015 Expires A. Newborn 2888 0.08323 31930 11.06 0.02852 0.96712 0.34272
----------------------------------------------------------------
Sourcing data from simulation for Nov 2015
Sourcing data from simulation for Nov 2014
Payment Month # Pmts Payment $ Avg Pmt $ Reg Pmt $ Def Pmt $ % Def $
------------- ------- ---------- ---------- ---------- ---------- --------
Nov 2014 34701 1119432 32.26 276735 842697 0.75279
Nov 2015 33613 1131783 33.67 267048 864734 0.76405
Expire Group Activation Segment # Pmts % Pmts Pmt $ Avg Pmt $ % Pmt $ Cum % Pmt $ Impact
---------------- -------------------- ------- ------- ------ ---------- -------- ------------ --------
Mar 2017 Expires B. Continuous/Def 8128 0.24181 379784 46.73 0.33556 0.33556 1.38770
Jan 2017 Expires B. Continuous/Def 4179 0.12433 183789 43.98 0.16239 0.49795 1.30614
Apr 2017 Expires B. Continuous/Def 3239 0.09636 134078 41.39 0.11847 0.61642 1.22938
Dec 2016 Expires B. Continuous/Def 2746 0.08169 94149 34.29 0.08319 0.69960 1.01826
Nov 2016 Expires D. Revived 6105 0.18163 76775 12.58 0.06784 0.76744 0.37349
Oct 2016 Expires B. Continuous/Reg 1828 0.05438 57137 31.26 0.05048 0.81792 0.92827
Feb 2017 Expires B. Continuous/Def 1412 0.04201 53585 37.95 0.04734 0.86527 1.12706
Nov 2016 Expires B. Continuous/Reg 1398 0.04159 48241 34.51 0.04262 0.90789 1.02481
Nov 2016 Expires C. Consecutive 1192 0.03546 42990 36.07 0.03798 0.94588 1.07110
Nov 2016 Expires A. Newborn 2729 0.08119 30768 11.27 0.02719 0.97306 0.33484
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment