Skip to content

Instantly share code, notes, and snippets.

@jackross

jackross/february_2011_2015_payment_month.txt

Created September 19, 2014 16:44
Show Gist options
  • Save jackross/c3c39beb3c817cc86866 to your computer and use it in GitHub Desktop.
Save jackross/c3c39beb3c817cc86866 to your computer and use it in GitHub Desktop.
Download ZIP
February 2011 - 2015 Payment Month
Raw
february_2011_2015_payment_month.txt

----------------------------------------------------------------
Sourcing data from facts.memberships for Feb 2011
Sourcing data from facts.memberships for Feb 2010
Payment Month # Pmts Payment $ Avg Pmt $ Reg Pmt $ Def Pmt $ % Def $
------------- ------- ---------- ---------- ---------- ---------- --------
Feb 2010 86108 1725646 20.04 1668826 56820 0.03293
Feb 2011 61743 1215289 19.68 1167263 48016 0.03951
Expire Group Activation Segment # Pmts % Pmts Pmt $ Avg Pmt $ % Pmt $ Cum % Pmt $ Impact
---------------- -------------------- ------- ------- ------ ---------- -------- ------------ --------
Feb 2012 Expires B. Continuous/Reg 6148 0.09957 176610 28.73 0.14532 0.14532 1.45945
Feb 2012 Expires D. Revived 12166 0.19704 136820 11.25 0.11258 0.25791 0.57136
Feb 2012 Expires A. Newborn 12991 0.21040 136515 10.51 0.11233 0.37024 0.53388
Mar 2012 Expires B. Continuous/Reg 3622 0.05866 122130 33.72 0.10049 0.47073 1.71309
Apr 2012 Expires B. Continuous/Reg 3563 0.05771 120323 33.77 0.09901 0.56974 1.71569
Feb 2012 Expires C. Consecutive 6938 0.11237 116490 16.79 0.09585 0.66559 0.85302
May 2012 Expires B. Continuous/Reg 2839 0.04598 114825 40.45 0.09448 0.76008 2.05483
Jan 2012 Expires B. Continuous/Reg 2397 0.03882 78150 32.60 0.06431 0.82438 1.65640
Feb 2012 Expires E. Reborn 4982 0.08069 54570 10.95 0.04490 0.86928 0.55648
Jun 2012 Expires B. Continuous/Reg 1176 0.01905 42410 36.06 0.03490 0.90418 1.83218
----------------------------------------------------------------
Sourcing data from facts.memberships for Feb 2012
Sourcing data from facts.memberships for Feb 2011
Payment Month # Pmts Payment $ Avg Pmt $ Reg Pmt $ Def Pmt $ % Def $
------------- ------- ---------- ---------- ---------- ---------- --------
Feb 2011 61743 1215289 19.68 1167263 48016 0.03951
Feb 2012 87729 2170136 24.74 2127416 42720 0.01969
Expire Group Activation Segment # Pmts % Pmts Pmt $ Avg Pmt $ % Pmt $ Cum % Pmt $ Impact
---------------- -------------------- ------- ------- ------ ---------- -------- ------------ --------
Jun 2013 Expires B. Continuous/Reg 17095 0.19486 687161 40.20 0.31664 0.31664 1.62497
Apr 2013 Expires B. Continuous/Reg 8992 0.10250 289688 32.22 0.13349 0.45013 1.30235
Feb 2013 Expires B. Continuous/Reg 8501 0.09690 243189 28.61 0.11206 0.56219 1.15645
Mar 2013 Expires B. Continuous/Reg 4415 0.05033 165694 37.53 0.07635 0.63855 1.51715
Feb 2013 Expires C. Consecutive 10380 0.11832 159263 15.34 0.07339 0.71193 0.62026
Feb 2013 Expires A. Newborn 13370 0.15240 151720 11.35 0.06991 0.78185 0.45874
Feb 2013 Expires D. Revived 11817 0.13470 142245 12.04 0.06555 0.84739 0.48661
Jan 2013 Expires B. Continuous/Reg 3564 0.04063 108692 30.50 0.05008 0.89748 1.23286
May 2013 Expires B. Continuous/Reg 1805 0.02057 69920 38.74 0.03222 0.92970 1.56595
Feb 2013 Expires E. Reborn 2979 0.03396 34025 11.42 0.01568 0.94538 0.46170
----------------------------------------------------------------
Sourcing data from facts.memberships for Feb 2013
Sourcing data from facts.memberships for Feb 2012
Payment Month # Pmts Payment $ Avg Pmt $ Reg Pmt $ Def Pmt $ % Def $
------------- ------- ---------- ---------- ---------- ---------- --------
Feb 2012 87729 2170136 24.74 2127416 42720 0.01969
Feb 2013 84064 1979137 23.54 1939012 40125 0.02027
Expire Group Activation Segment # Pmts % Pmts Pmt $ Avg Pmt $ % Pmt $ Cum % Pmt $ Impact
---------------- -------------------- ------- ------- ------ ---------- -------- ------------ --------
Jun 2014 Expires B. Continuous/Reg 16765 0.19943 660055 39.37 0.33351 0.33351 1.67228
Apr 2014 Expires B. Continuous/Reg 8147 0.09691 267015 32.77 0.13491 0.46842 1.39210
Feb 2014 Expires B. Continuous/Reg 6286 0.07478 195823 31.15 0.09894 0.56737 1.32319
Feb 2014 Expires C. Consecutive 13313 0.15837 177252 13.31 0.08956 0.65692 0.56552
Feb 2014 Expires D. Revived 11346 0.13497 130981 11.54 0.06618 0.72311 0.49034
Feb 2014 Expires A. Newborn 12021 0.14300 128860 10.72 0.06511 0.78822 0.45531
Mar 2014 Expires B. Continuous/Reg 3033 0.03608 108822 35.88 0.05498 0.84320 1.52396
Jan 2014 Expires B. Continuous/Reg 2502 0.02976 81485 32.57 0.04117 0.88437 1.38329
May 2014 Expires B. Continuous/Reg 1774 0.02110 76207 42.96 0.03850 0.92288 1.82462
Feb 2014 Expires E. Reborn 4994 0.05941 55747 11.16 0.02817 0.95104 0.47414
----------------------------------------------------------------
Sourcing data from facts.memberships for Feb 2014
Sourcing data from facts.memberships for Feb 2013
Payment Month # Pmts Payment $ Avg Pmt $ Reg Pmt $ Def Pmt $ % Def $
------------- ------- ---------- ---------- ---------- ---------- --------
Feb 2013 84064 1979137 23.54 1939012 40125 0.02027
Feb 2014 79815 1993012 24.97 1947748 45264 0.02271
Expire Group Activation Segment # Pmts % Pmts Pmt $ Avg Pmt $ % Pmt $ Cum % Pmt $ Impact
---------------- -------------------- ------- ------- ------ ---------- -------- ------------ --------
Jun 2015 Expires B. Continuous/Reg 17621 0.22077 680546 38.62 0.34147 0.34147 1.54668
Apr 2015 Expires B. Continuous/Reg 9205 0.11533 296058 32.16 0.14855 0.49001 1.28803
Feb 2015 Expires B. Continuous/Reg 7349 0.09208 211563 28.79 0.10615 0.59617 1.15288
Feb 2015 Expires C. Consecutive 9603 0.12032 138814 14.46 0.06965 0.66582 0.57889
Feb 2015 Expires A. Newborn 11001 0.13783 126590 11.51 0.06352 0.72933 0.46082
Mar 2015 Expires B. Continuous/Reg 3062 0.03836 109605 35.80 0.05499 0.78433 1.43349
Jan 2015 Expires B. Continuous/Reg 2494 0.03125 80381 32.23 0.04033 0.82466 1.29071
Feb 2015 Expires D. Revived 6576 0.08239 75279 11.45 0.03777 0.86243 0.45844
May 2015 Expires B. Continuous/Reg 1786 0.02238 71270 39.90 0.03576 0.89819 1.59804
Jul 2015 Expires B. Continuous/Reg 1574 0.01972 57395 36.46 0.02880 0.92699 1.46030
----------------------------------------------------------------
Sourcing data from simulation for Feb 2015
Sourcing data from facts.memberships for Feb 2014
Payment Month # Pmts Payment $ Avg Pmt $ Reg Pmt $ Def Pmt $ % Def $
------------- ------- ---------- ---------- ---------- ---------- --------
Feb 2014 79815 1993012 24.97 1947748 45264 0.02271
Feb 2015 69542 1808926 26.01 1795362 13564 0.00750
Expire Group Activation Segment # Pmts % Pmts Pmt $ Avg Pmt $ % Pmt $ Cum % Pmt $ Impact
---------------- -------------------- ------- ------- ------ ---------- -------- ------------ --------
Jun 2016 Expires B. Continuous/Reg 14903 0.21430 621038 41.67 0.34332 0.34332 1.60203
Apr 2016 Expires B. Continuous/Reg 6912 0.09939 248489 35.95 0.13737 0.48069 1.38207
Feb 2016 Expires D. Revived 18451 0.26532 222240 12.04 0.12286 0.60354 0.46305
Feb 2016 Expires B. Continuous/Reg 6575 0.09455 200695 30.52 0.11095 0.71449 1.17346
Feb 2016 Expires A. Newborn 11525 0.16573 127580 11.07 0.07053 0.78502 0.42557
Mar 2016 Expires B. Continuous/Reg 3386 0.04869 114043 33.68 0.06304 0.84806 1.29480
Jan 2016 Expires B. Continuous/Reg 2171 0.03122 77024 35.48 0.04258 0.89064 1.36390
Feb 2016 Expires C. Consecutive 2739 0.03939 76607 27.97 0.04235 0.93299 1.07522
Jul 2016 Expires B. Continuous/Reg 1820 0.02617 75285 41.37 0.04162 0.97461 1.59022
May 2016 Expires B. Continuous/Reg 818 0.01176 32421 39.63 0.01792 0.99253 1.52363
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment