Skip to content

Instantly share code, notes, and snippets.

@jackross

jackross/august_2011_2015_payment_month.txt

Created September 19, 2014 16:50
Show Gist options
  • Save jackross/6172e0a12fdf566a2a27 to your computer and use it in GitHub Desktop.
Save jackross/6172e0a12fdf566a2a27 to your computer and use it in GitHub Desktop.
Download ZIP
August 2011 - 2015 Payment Month
Raw
august_2011_2015_payment_month.txt

----------------------------------------------------------------
Sourcing data from facts.memberships for Aug 2011
Sourcing data from facts.memberships for Aug 2010
Payment Month # Pmts Payment $ Avg Pmt $ Reg Pmt $ Def Pmt $ % Def $
------------- ------- ---------- ---------- ---------- ---------- --------
Aug 2010 22023 786798 35.73 657753 129045 0.16401
Aug 2011 21692 709476 32.71 623986 85490 0.12050
Expire Group Activation Segment # Pmts % Pmts Pmt $ Avg Pmt $ % Pmt $ Cum % Pmt $ Impact
---------------- -------------------- ------- ------- ------ ---------- -------- ------------ --------
Nov 2012 Expires B. Continuous/Reg 3946 0.18191 162640 41.22 0.22924 0.22924 1.26018
Aug 2012 Expires B. Continuous/Reg 3497 0.16121 120760 34.53 0.17021 0.39945 1.05582
Aug 2012 Expires C. Consecutive 5375 0.24779 109947 20.46 0.15497 0.55442 0.62541
Sep 2012 Expires B. Continuous/Reg 1797 0.08284 81050 45.10 0.11424 0.66866 1.37901
Oct 2012 Expires B. Continuous/Reg 1423 0.06560 60884 42.79 0.08582 0.75447 1.30815
Jul 2012 Expires B. Continuous/Reg 1367 0.06302 51050 37.34 0.07195 0.82643 1.14179
Nov 2012 Expires B. Continuous/Def 979 0.04513 45590 46.57 0.06426 0.89069 1.42378
Dec 2012 Expires B. Continuous/Def 896 0.04131 21040 23.48 0.02966 0.92034 0.71794
Aug 2012 Expires A. Newborn 931 0.04292 15910 17.09 0.02243 0.94277 0.52250
Aug 2013 Expires B. Continuous/Def 118 0.00544 4985 42.25 0.00703 0.94979 1.29159
----------------------------------------------------------------
Sourcing data from facts.memberships for Aug 2012
Sourcing data from facts.memberships for Aug 2011
Payment Month # Pmts Payment $ Avg Pmt $ Reg Pmt $ Def Pmt $ % Def $
------------- ------- ---------- ---------- ---------- ---------- --------
Aug 2011 21692 709476 32.71 623986 85490 0.12050
Aug 2012 22776 838180 36.80 502645 335535 0.40031
Expire Group Activation Segment # Pmts % Pmts Pmt $ Avg Pmt $ % Pmt $ Cum % Pmt $ Impact
---------------- -------------------- ------- ------- ------ ---------- -------- ------------ --------
Dec 2013 Expires B. Continuous/Def 5912 0.25957 238245 40.30 0.28424 0.28424 1.09504
Aug 2013 Expires B. Continuous/Reg 3534 0.15516 125030 35.38 0.14917 0.43341 0.96136
Oct 2013 Expires B. Continuous/Reg 1852 0.08131 78100 42.17 0.09318 0.52659 1.14591
Dec 2013 Expires B. Continuous/Reg 1203 0.05282 66445 55.23 0.07927 0.60586 1.50083
Aug 2013 Expires C. Consecutive 1584 0.06955 56885 35.91 0.06787 0.67373 0.97585
Sep 2013 Expires B. Continuous/Reg 1423 0.06248 56285 39.55 0.06715 0.74088 1.07479
Jan 2014 Expires B. Continuous/Def 1415 0.06213 55870 39.48 0.06666 0.80754 1.07290
Jul 2013 Expires B. Continuous/Reg 779 0.03420 30615 39.30 0.03653 0.84406 1.06790
Nov 2013 Expires B. Continuous/Reg 694 0.03047 28825 41.53 0.03439 0.87845 1.12859
Aug 2013 Expires A. Newborn 1433 0.06292 20840 14.54 0.02486 0.90331 0.39517
----------------------------------------------------------------
Sourcing data from facts.memberships for Aug 2013
Sourcing data from facts.memberships for Aug 2012
Payment Month # Pmts Payment $ Avg Pmt $ Reg Pmt $ Def Pmt $ % Def $
------------- ------- ---------- ---------- ---------- ---------- --------
Aug 2012 22776 838180 36.80 502645 335535 0.40031
Aug 2013 30182 1081808 35.84 620925 460883 0.42603
Expire Group Activation Segment # Pmts % Pmts Pmt $ Avg Pmt $ % Pmt $ Cum % Pmt $ Impact
---------------- -------------------- ------- ------- ------ ---------- -------- ------------ --------
Dec 2014 Expires B. Continuous/Def 7927 0.26264 306668 38.69 0.28348 0.28348 1.07934
Aug 2014 Expires B. Continuous/Reg 3491 0.11566 131273 37.60 0.12134 0.40482 1.04911
Oct 2014 Expires B. Continuous/Reg 4076 0.13505 125398 30.76 0.11592 0.52074 0.85833
Jan 2015 Expires B. Continuous/Def 2664 0.08826 121610 45.65 0.11241 0.63315 1.27359
Dec 2014 Expires B. Continuous/Reg 1526 0.05056 77300 50.66 0.07145 0.70461 1.41325
Aug 2014 Expires C. Consecutive 2689 0.08909 75908 28.23 0.07017 0.77477 0.78757
Sep 2014 Expires B. Continuous/Reg 1884 0.06242 70010 37.16 0.06471 0.83949 1.03675
Nov 2014 Expires B. Continuous/Reg 955 0.03164 40800 42.72 0.03771 0.87720 1.19192
Jul 2014 Expires B. Continuous/Reg 1060 0.03512 37715 35.58 0.03486 0.91207 0.99265
Aug 2014 Expires A. Newborn 1382 0.04579 22830 16.52 0.02110 0.93317 0.46088
----------------------------------------------------------------
Sourcing data from facts.memberships for Aug 2014
Sourcing data from facts.memberships for Aug 2013
Payment Month # Pmts Payment $ Avg Pmt $ Reg Pmt $ Def Pmt $ % Def $
------------- ------- ---------- ---------- ---------- ---------- --------
Aug 2013 30182 1081808 35.84 620925 460883 0.42603
Aug 2014 28568 1004953 35.18 550829 454124 0.45188
Expire Group Activation Segment # Pmts % Pmts Pmt $ Avg Pmt $ % Pmt $ Cum % Pmt $ Impact
---------------- -------------------- ------- ------- ------ ---------- -------- ------------ --------
Dec 2015 Expires B. Continuous/Def 8551 0.29932 317438 37.12 0.31587 0.31587 1.05530
Oct 2015 Expires B. Continuous/Reg 3979 0.13928 121990 30.66 0.12139 0.43726 0.87153
Jan 2016 Expires B. Continuous/Def 2555 0.08944 111175 43.51 0.11063 0.54789 1.23694
Aug 2015 Expires B. Continuous/Reg 2688 0.09409 110660 41.17 0.11011 0.65800 1.17029
Aug 2015 Expires C. Consecutive 2762 0.09668 72520 26.26 0.07216 0.73017 0.74639
Dec 2015 Expires B. Continuous/Reg 1306 0.04572 65190 49.92 0.06487 0.79504 1.41895
Sep 2015 Expires B. Continuous/Reg 1541 0.05394 60430 39.21 0.06013 0.85517 1.11476
Jul 2015 Expires B. Continuous/Reg 876 0.03066 33535 38.28 0.03337 0.88854 1.08823
Nov 2015 Expires B. Continuous/Reg 813 0.02846 32185 39.59 0.03203 0.92056 1.12536
Aug 2015 Expires A. Newborn 1053 0.03686 17565 16.68 0.01748 0.93804 0.47418
----------------------------------------------------------------
Sourcing data from simulation for Aug 2015
Sourcing data from facts.memberships for Aug 2014
Payment Month # Pmts Payment $ Avg Pmt $ Reg Pmt $ Def Pmt $ % Def $
------------- ------- ---------- ---------- ---------- ---------- --------
Aug 2014 28568 1004953 35.18 550829 454124 0.45188
Aug 2015 25867 985632 38.10 477389 508243 0.51565
Expire Group Activation Segment # Pmts % Pmts Pmt $ Avg Pmt $ % Pmt $ Cum % Pmt $ Impact
---------------- -------------------- ------- ------- ------ ---------- -------- ------------ --------
Dec 2016 Expires B. Continuous/Def 8579 0.33166 363434 42.36 0.36873 0.36873 1.11178
Jan 2017 Expires B. Continuous/Def 2708 0.10469 134084 49.51 0.13604 0.50477 1.29944
Oct 2016 Expires B. Continuous/Reg 3602 0.13925 116134 32.24 0.11783 0.62260 0.84615
Aug 2016 Expires B. Continuous/Reg 2103 0.08130 87624 41.67 0.08890 0.71150 1.09349
Aug 2016 Expires C. Consecutive 2185 0.08447 74659 34.17 0.07575 0.78725 0.89673
Sep 2016 Expires B. Continuous/Reg 1782 0.06889 65698 36.87 0.06666 0.85390 0.96754
Jul 2016 Expires B. Continuous/Reg 973 0.03762 38783 39.86 0.03935 0.89325 1.04603
Dec 2016 Expires B. Continuous/Reg 469 0.01813 28866 61.55 0.02929 0.92254 1.61523
Aug 2016 Expires D. Revived 1419 0.05486 24297 17.12 0.02465 0.94719 0.44935
Aug 2016 Expires A. Newborn 1355 0.05238 20585 15.19 0.02089 0.96807 0.39870
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment