Skip to content

Instantly share code, notes, and snippets.

@jackross

jackross/may_2011_2015_payment_month.txt

Created September 19, 2014 16:48
Show Gist options
  • Save jackross/98077a9ef6b49849e60d to your computer and use it in GitHub Desktop.
Save jackross/98077a9ef6b49849e60d to your computer and use it in GitHub Desktop.
Download ZIP
May 2011 - 2015 Payment Month
Raw
may_2011_2015_payment_month.txt

----------------------------------------------------------------
Sourcing data from facts.memberships for May 2011
Sourcing data from facts.memberships for May 2010
Payment Month # Pmts Payment $ Avg Pmt $ Reg Pmt $ Def Pmt $ % Def $
------------- ------- ---------- ---------- ---------- ---------- --------
May 2010 24762 766049 30.94 734853 31196 0.04072
May 2011 29020 910980 31.39 860595 50385 0.05531
Expire Group Activation Segment # Pmts % Pmts Pmt $ Avg Pmt $ % Pmt $ Cum % Pmt $ Impact
---------------- -------------------- ------- ------- ------ ---------- -------- ------------ --------
Jun 2012 Expires B. Continuous/Reg 5386 0.18560 207550 38.54 0.22783 0.22783 1.22756
Aug 2012 Expires B. Continuous/Reg 5400 0.18608 199885 37.02 0.21942 0.44725 1.17916
May 2012 Expires B. Continuous/Reg 2742 0.09449 99610 36.33 0.10934 0.55659 1.15723
Apr 2012 Expires B. Continuous/Reg 3328 0.11468 98335 29.55 0.10794 0.66454 0.94127
May 2012 Expires C. Consecutive 3916 0.13494 97245 24.83 0.10675 0.77128 0.79106
Jul 2012 Expires B. Continuous/Reg 1756 0.06051 73420 41.81 0.08059 0.85188 1.33191
May 2012 Expires A. Newborn 2110 0.07271 27220 12.90 0.02988 0.88176 0.41094
May 2012 Expires D. Revived 1280 0.04411 16520 12.91 0.01813 0.89989 0.41113
Jun 2013 Expires B. Continuous/Def 317 0.01092 11590 36.56 0.01272 0.91262 1.16464
Sep 2012 Expires B. Continuous/Reg 284 0.00979 11425 40.23 0.01254 0.92516 1.28148
----------------------------------------------------------------
Sourcing data from facts.memberships for May 2012
Sourcing data from facts.memberships for May 2011
Payment Month # Pmts Payment $ Avg Pmt $ Reg Pmt $ Def Pmt $ % Def $
------------- ------- ---------- ---------- ---------- ---------- --------
May 2011 29020 910980 31.39 860595 50385 0.05531
May 2012 27210 936698 34.42 905898 30800 0.03288
Expire Group Activation Segment # Pmts % Pmts Pmt $ Avg Pmt $ % Pmt $ Cum % Pmt $ Impact
---------------- -------------------- ------- ------- ------ ---------- -------- ------------ --------
Sep 2013 Expires B. Continuous/Reg 4762 0.17501 212545 44.63 0.22691 0.22691 1.29655
Jun 2013 Expires B. Continuous/Reg 3660 0.13451 146348 39.99 0.15624 0.38315 1.16154
Jul 2013 Expires B. Continuous/Reg 2307 0.08479 98575 42.73 0.10524 0.48838 1.24121
May 2013 Expires B. Continuous/Reg 2315 0.08508 93937 40.58 0.10029 0.58867 1.17873
May 2013 Expires C. Consecutive 2894 0.10636 86198 29.79 0.09202 0.68069 0.86522
Aug 2013 Expires B. Continuous/Reg 2037 0.07486 79140 38.85 0.08449 0.76518 1.12858
Apr 2013 Expires B. Continuous/Reg 2349 0.08633 73845 31.44 0.07884 0.84401 0.91320
May 2013 Expires A. Newborn 2260 0.08306 33295 14.73 0.03555 0.87956 0.42796
Oct 2013 Expires B. Continuous/Reg 620 0.02279 24400 39.35 0.02605 0.90561 1.14317
May 2013 Expires D. Revived 1320 0.04851 16885 12.79 0.01803 0.92364 0.37158
----------------------------------------------------------------
Sourcing data from facts.memberships for May 2013
Sourcing data from facts.memberships for May 2012
Payment Month # Pmts Payment $ Avg Pmt $ Reg Pmt $ Def Pmt $ % Def $
------------- ------- ---------- ---------- ---------- ---------- --------
May 2012 27210 936698 34.42 905898 30800 0.03288
May 2013 38514 1125126 29.21 1099061 26065 0.02317
Expire Group Activation Segment # Pmts % Pmts Pmt $ Avg Pmt $ % Pmt $ Cum % Pmt $ Impact
---------------- -------------------- ------- ------- ------ ---------- -------- ------------ --------
Sep 2014 Expires B. Continuous/Reg 5560 0.14436 231685 41.67 0.20592 0.20592 1.42640
Jun 2014 Expires B. Continuous/Reg 4602 0.11949 159222 34.60 0.14151 0.34743 1.18433
Jul 2014 Expires B. Continuous/Reg 3369 0.08747 120060 35.64 0.10671 0.45414 1.21987
Apr 2014 Expires B. Continuous/Reg 3620 0.09399 112106 30.97 0.09964 0.55378 1.06007
May 2014 Expires B. Continuous/Reg 2517 0.06535 103195 41.00 0.09172 0.64550 1.40343
Aug 2014 Expires B. Continuous/Reg 2186 0.05676 92973 42.53 0.08263 0.72813 1.45587
May 2014 Expires C. Consecutive 3742 0.09716 90060 24.07 0.08004 0.80818 0.82384
May 2014 Expires A. Newborn 3417 0.08872 50960 14.91 0.04529 0.85347 0.51050
May 2014 Expires D. Revived 2576 0.06688 34560 13.42 0.03072 0.88419 0.45924
Oct 2014 Expires B. Continuous/Reg 686 0.01781 25295 36.87 0.02248 0.90667 1.26215
----------------------------------------------------------------
Sourcing data from facts.memberships for May 2014
Sourcing data from facts.memberships for May 2013
Payment Month # Pmts Payment $ Avg Pmt $ Reg Pmt $ Def Pmt $ % Def $
------------- ------- ---------- ---------- ---------- ---------- --------
May 2013 38514 1125126 29.21 1099061 26065 0.02317
May 2014 36257 1087521 29.99 1055563 31958 0.02939
Expire Group Activation Segment # Pmts % Pmts Pmt $ Avg Pmt $ % Pmt $ Cum % Pmt $ Impact
---------------- -------------------- ------- ------- ------ ---------- -------- ------------ --------
Sep 2015 Expires B. Continuous/Reg 4712 0.12996 212105 45.01 0.19503 0.19503 1.50072
Jun 2015 Expires B. Continuous/Reg 4253 0.11730 154336 36.29 0.14192 0.33695 1.20983
Jul 2015 Expires B. Continuous/Reg 2595 0.07157 117462 45.26 0.10801 0.44496 1.50907
May 2015 Expires B. Continuous/Reg 2647 0.07301 105897 40.01 0.09737 0.54233 1.33377
May 2015 Expires C. Consecutive 5050 0.13928 103821 20.56 0.09546 0.63780 0.68540
Apr 2015 Expires B. Continuous/Reg 3050 0.08412 99442 32.60 0.09144 0.72924 1.08698
Aug 2015 Expires B. Continuous/Reg 1813 0.05000 80190 44.23 0.07374 0.80297 1.47460
May 2015 Expires A. Newborn 3981 0.10980 58985 14.82 0.05424 0.85721 0.49397
May 2015 Expires D. Revived 4757 0.13120 58686 12.34 0.05396 0.91117 0.41129
Oct 2015 Expires B. Continuous/Reg 912 0.02515 37825 41.47 0.03478 0.94596 1.38270
----------------------------------------------------------------
Sourcing data from simulation for May 2015
Sourcing data from facts.memberships for May 2014
Payment Month # Pmts Payment $ Avg Pmt $ Reg Pmt $ Def Pmt $ % Def $
------------- ------- ---------- ---------- ---------- ---------- --------
May 2014 36257 1087521 29.99 1055563 31958 0.02939
May 2015 34560 1040500 30.11 1029643 10858 0.01043
Expire Group Activation Segment # Pmts % Pmts Pmt $ Avg Pmt $ % Pmt $ Cum % Pmt $ Impact
---------------- -------------------- ------- ------- ------ ---------- -------- ------------ --------
Sep 2016 Expires B. Continuous/Reg 5154 0.14913 226320 43.91 0.21751 0.21751 1.45851
Jun 2016 Expires B. Continuous/Reg 3819 0.11050 145431 38.08 0.13977 0.35728 1.26485
Jul 2016 Expires B. Continuous/Reg 2602 0.07529 106747 41.03 0.10259 0.45987 1.36264
May 2016 Expires B. Continuous/Reg 2842 0.08223 103004 36.24 0.09899 0.55887 1.20381
Apr 2016 Expires B. Continuous/Reg 2838 0.08212 98281 34.63 0.09445 0.65332 1.15023
May 2016 Expires D. Revived 7530 0.21788 96930 12.87 0.09316 0.74648 0.42756
May 2016 Expires C. Consecutive 3031 0.08770 92715 30.59 0.08911 0.83559 1.01599
Oct 2016 Expires B. Continuous/Reg 1565 0.04528 61194 39.10 0.05881 0.89440 1.29875
May 2016 Expires A. Newborn 4055 0.11733 56055 13.82 0.05387 0.94827 0.45915
Aug 2016 Expires B. Continuous/Reg 941 0.02723 43284 46.00 0.04160 0.98987 1.52777
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment