Skip to content

Instantly share code, notes, and snippets.

@jackross

jackross/april_2011_2015_payment_month.txt

Created September 19, 2014 16:45
Show Gist options
  • Save jackross/543a77ad42052f63e8d7 to your computer and use it in GitHub Desktop.
Save jackross/543a77ad42052f63e8d7 to your computer and use it in GitHub Desktop.
Download ZIP
April 2011 - 2015 Payment Month
Raw
april_2011_2015_payment_month.txt

----------------------------------------------------------------
Sourcing data from facts.memberships for Apr 2011
Sourcing data from facts.memberships for Apr 2010
Payment Month # Pmts Payment $ Avg Pmt $ Reg Pmt $ Def Pmt $ % Def $
------------- ------- ---------- ---------- ---------- ---------- --------
Apr 2010 60475 1257647 20.80 1195950 61698 0.04906
Apr 2011 62116 1571381 25.30 1493801 77560 0.04936
Expire Group Activation Segment # Pmts % Pmts Pmt $ Avg Pmt $ % Pmt $ Cum % Pmt $ Impact
---------------- -------------------- ------- ------- ------ ---------- -------- ------------ --------
Jun 2012 Expires B. Continuous/Reg 7587 0.12214 282125 37.19 0.17954 0.17954 1.46991
Jul 2012 Expires B. Continuous/Reg 5920 0.09531 252085 42.58 0.16042 0.33996 1.68324
Apr 2012 Expires B. Continuous/Reg 6292 0.10129 199856 31.76 0.12718 0.46715 1.25559
Apr 2012 Expires C. Consecutive 11994 0.19309 198615 16.56 0.12640 0.59354 0.65459
Aug 2012 Expires B. Continuous/Reg 4049 0.06518 145180 35.86 0.09239 0.68593 1.41736
May 2012 Expires B. Continuous/Reg 2726 0.04389 108250 39.71 0.06889 0.75482 1.56972
Apr 2012 Expires D. Revived 8253 0.13286 93270 11.30 0.05935 0.81418 0.44673
Apr 2012 Expires A. Newborn 7531 0.12124 85670 11.38 0.05452 0.86869 0.44967
Mar 2012 Expires B. Continuous/Reg 2472 0.03980 82850 33.52 0.05272 0.92142 1.32484
Apr 2012 Expires E. Reborn 2081 0.03350 23440 11.26 0.01492 0.93634 0.44523
----------------------------------------------------------------
Sourcing data from facts.memberships for Apr 2012
Sourcing data from facts.memberships for Apr 2011
Payment Month # Pmts Payment $ Avg Pmt $ Reg Pmt $ Def Pmt $ % Def $
------------- ------- ---------- ---------- ---------- ---------- --------
Apr 2011 62116 1571381 25.30 1493801 77560 0.04936
Apr 2012 64582 1598001 24.74 1529645 68356 0.04278
Expire Group Activation Segment # Pmts % Pmts Pmt $ Avg Pmt $ % Pmt $ Cum % Pmt $ Impact
---------------- -------------------- ------- ------- ------ ---------- -------- ------------ --------
Aug 2013 Expires B. Continuous/Reg 11388 0.17633 407751 35.81 0.25516 0.25516 1.44704
Jun 2013 Expires B. Continuous/Reg 5235 0.08106 211238 40.35 0.13219 0.38735 1.63075
Apr 2013 Expires B. Continuous/Reg 5520 0.08547 183918 33.32 0.11509 0.50244 1.34653
Apr 2013 Expires C. Consecutive 6774 0.10489 152765 22.55 0.09560 0.59804 0.91140
Apr 2013 Expires D. Revived 11506 0.17816 131023 11.39 0.08199 0.68003 0.46021
Apr 2013 Expires A. Newborn 9521 0.14742 105755 11.11 0.06618 0.74621 0.44890
May 2013 Expires B. Continuous/Reg 2602 0.04029 92095 35.39 0.05763 0.80384 1.43041
Jul 2013 Expires B. Continuous/Reg 2190 0.03391 90850 41.48 0.05685 0.86070 1.67654
Mar 2013 Expires B. Continuous/Reg 1983 0.03071 72360 36.49 0.04528 0.90598 1.47470
Apr 2013 Expires E. Reborn 4201 0.06505 47455 11.30 0.02970 0.93568 0.45652
----------------------------------------------------------------
Sourcing data from facts.memberships for Apr 2013
Sourcing data from facts.memberships for Apr 2012
Payment Month # Pmts Payment $ Avg Pmt $ Reg Pmt $ Def Pmt $ % Def $
------------- ------- ---------- ---------- ---------- ---------- --------
Apr 2012 64582 1598001 24.74 1529645 68356 0.04278
Apr 2013 63190 1632240 25.83 1577935 54305 0.03327
Expire Group Activation Segment # Pmts % Pmts Pmt $ Avg Pmt $ % Pmt $ Cum % Pmt $ Impact
---------------- -------------------- ------- ------- ------ ---------- -------- ------------ --------
Aug 2014 Expires B. Continuous/Reg 9687 0.15330 398815 41.17 0.24434 0.24434 1.59384
Jun 2014 Expires B. Continuous/Reg 5772 0.09134 228195 39.53 0.13980 0.38414 1.53053
Apr 2014 Expires B. Continuous/Reg 5817 0.09206 210785 36.24 0.12914 0.51328 1.40282
Apr 2014 Expires C. Consecutive 9916 0.15692 163106 16.45 0.09993 0.61321 0.63679
Apr 2014 Expires D. Revived 9474 0.14993 112464 11.87 0.06890 0.68211 0.45956
Apr 2014 Expires A. Newborn 8737 0.13827 101740 11.64 0.06233 0.74444 0.45081
Jul 2014 Expires B. Continuous/Reg 2078 0.03288 95760 46.08 0.05867 0.80311 1.78401
May 2014 Expires B. Continuous/Reg 2110 0.03339 84485 40.04 0.05176 0.85487 1.55010
Mar 2014 Expires B. Continuous/Reg 2193 0.03470 78140 35.63 0.04787 0.90274 1.37940
Apr 2014 Expires E. Reborn 3439 0.05442 41710 12.13 0.02555 0.92829 0.46952
----------------------------------------------------------------
Sourcing data from facts.memberships for Apr 2014
Sourcing data from facts.memberships for Apr 2013
Payment Month # Pmts Payment $ Avg Pmt $ Reg Pmt $ Def Pmt $ % Def $
------------- ------- ---------- ---------- ---------- ---------- --------
Apr 2013 63190 1632240 25.83 1577935 54305 0.03327
Apr 2014 47888 1450458 30.29 1381066 69392 0.04784
Expire Group Activation Segment # Pmts % Pmts Pmt $ Avg Pmt $ % Pmt $ Cum % Pmt $ Impact
---------------- -------------------- ------- ------- ------ ---------- -------- ------------ --------
Aug 2015 Expires B. Continuous/Reg 8220 0.17165 354244 43.10 0.24423 0.24423 1.42283
Jun 2015 Expires B. Continuous/Reg 6642 0.13870 251320 37.84 0.17327 0.41750 1.24925
Apr 2015 Expires B. Continuous/Reg 6110 0.12759 205879 33.70 0.14194 0.55944 1.11248
Apr 2015 Expires C. Consecutive 5857 0.12231 120017 20.49 0.08274 0.64218 0.67653
Jul 2015 Expires B. Continuous/Reg 2093 0.04371 94775 45.28 0.06534 0.70752 1.49501
May 2015 Expires B. Continuous/Reg 2397 0.05005 91800 38.30 0.06329 0.77082 1.26443
Mar 2015 Expires B. Continuous/Reg 1958 0.04089 65968 33.69 0.04548 0.81629 1.11233
Apr 2015 Expires A. Newborn 4318 0.09017 57035 13.21 0.03932 0.85562 0.43609
Apr 2015 Expires D. Revived 3861 0.08063 48488 12.56 0.03343 0.88905 0.41462
Sep 2015 Expires B. Continuous/Reg 854 0.01783 37655 44.09 0.02596 0.91501 1.45571
----------------------------------------------------------------
Sourcing data from simulation for Apr 2015
Sourcing data from facts.memberships for Apr 2014
Payment Month # Pmts Payment $ Avg Pmt $ Reg Pmt $ Def Pmt $ % Def $
------------- ------- ---------- ---------- ---------- ---------- --------
Apr 2014 47888 1450458 30.29 1381066 69392 0.04784
Apr 2015 52514 1439722 27.42 1429002 10720 0.00745
Expire Group Activation Segment # Pmts % Pmts Pmt $ Avg Pmt $ % Pmt $ Cum % Pmt $ Impact
---------------- -------------------- ------- ------- ------ ---------- -------- ------------ --------
Aug 2016 Expires B. Continuous/Reg 7100 0.13520 333791 47.01 0.23184 0.23184 1.71479
Jun 2016 Expires B. Continuous/Reg 5924 0.11281 228209 38.52 0.15851 0.39035 1.40512
Apr 2016 Expires B. Continuous/Reg 5106 0.09723 186093 36.45 0.12926 0.51961 1.32937
Apr 2016 Expires D. Revived 14611 0.27823 179082 12.26 0.12439 0.64400 0.44706
Apr 2016 Expires C. Consecutive 4106 0.07819 117741 28.68 0.08178 0.72578 1.04593
May 2016 Expires B. Continuous/Reg 2683 0.05109 100468 37.45 0.06978 0.79556 1.36583
Apr 2016 Expires A. Newborn 7552 0.14381 90420 11.97 0.06280 0.85836 0.43672
Mar 2016 Expires B. Continuous/Reg 2914 0.05549 88338 30.32 0.06136 0.91972 1.10573
Jul 2016 Expires B. Continuous/Reg 1208 0.02300 55508 45.95 0.03855 0.95827 1.67601
Sep 2016 Expires B. Continuous/Reg 1127 0.02146 50333 44.66 0.03496 0.99323 1.62901
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment