Skip to content

Instantly share code, notes, and snippets.

@jackross

jackross/january_2011_2015_payment_month.txt

Created September 19, 2014 16:41
Show Gist options
  • Save jackross/6898180834066cd092be to your computer and use it in GitHub Desktop.
Save jackross/6898180834066cd092be to your computer and use it in GitHub Desktop.
Download ZIP
January 2011 - 2015 Payment Month
Raw
january_2011_2015_payment_month.txt

----------------------------------------------------------------
Sourcing data from facts.memberships for Jan 2011
Sourcing data from facts.memberships for Jan 2010
Payment Month # Pmts Payment $ Avg Pmt $ Reg Pmt $ Def Pmt $ % Def $
------------- ------- ---------- ---------- ---------- ---------- --------
Jan 2010 40107 1348624 33.63 1278034 70590 0.05234
Jan 2011 46385 1493159 32.19 1387958 105200 0.07045
Expire Group Activation Segment # Pmts % Pmts Pmt $ Avg Pmt $ % Pmt $ Cum % Pmt $ Impact
---------------- -------------------- ------- ------- ------ ---------- -------- ------------ --------
Apr 2012 Expires B. Continuous/Reg 11110 0.23952 400472 36.05 0.26820 0.26820 1.11977
Jan 2012 Expires B. Continuous/Reg 5825 0.12558 222838 38.26 0.14924 0.41744 1.18840
Feb 2012 Expires B. Continuous/Reg 6246 0.13466 208181 33.33 0.13942 0.55687 1.03540
May 2012 Expires B. Continuous/Reg 2950 0.06360 117407 39.80 0.07863 0.63550 1.23634
Mar 2012 Expires B. Continuous/Reg 2688 0.05795 105325 39.18 0.07054 0.70603 1.21723
Jan 2012 Expires C. Consecutive 4258 0.09180 92255 21.67 0.06179 0.76782 0.67306
Jun 2012 Expires B. Continuous/Reg 2014 0.04342 77165 38.31 0.05168 0.81950 1.19023
Dec 2011 Expires B. Continuous/Reg 2015 0.04344 67355 33.43 0.04511 0.86461 1.03840
Apr 2013 Expires B. Continuous/Def 1158 0.02496 42164 36.41 0.02824 0.89285 1.13111
Jan 2012 Expires A. Newborn 2393 0.05159 31765 13.27 0.02127 0.91412 0.41235
----------------------------------------------------------------
Sourcing data from facts.memberships for Jan 2012
Sourcing data from facts.memberships for Jan 2011
Payment Month # Pmts Payment $ Avg Pmt $ Reg Pmt $ Def Pmt $ % Def $
------------- ------- ---------- ---------- ---------- ---------- --------
Jan 2011 46385 1493159 32.19 1387958 105200 0.07045
Jan 2012 50923 1687495 33.14 1638685 48810 0.02892
Expire Group Activation Segment # Pmts % Pmts Pmt $ Avg Pmt $ % Pmt $ Cum % Pmt $ Impact
---------------- -------------------- ------- ------- ------ ---------- -------- ------------ --------
May 2013 Expires B. Continuous/Reg 7237 0.14212 308718 42.66 0.18294 0.18294 1.28728
Jan 2013 Expires B. Continuous/Reg 7979 0.15669 284169 35.61 0.16840 0.35134 1.07473
Apr 2013 Expires B. Continuous/Reg 8278 0.16256 281678 34.03 0.16692 0.51826 1.02683
Feb 2013 Expires B. Continuous/Reg 7506 0.14740 261223 34.80 0.15480 0.67306 1.05020
Mar 2013 Expires B. Continuous/Reg 3067 0.06023 125405 40.89 0.07431 0.74738 1.23387
Jan 2013 Expires C. Consecutive 3799 0.07460 89441 23.54 0.05300 0.80038 0.71046
Dec 2012 Expires B. Continuous/Reg 2789 0.05477 84750 30.39 0.05022 0.85060 0.91698
Jun 2013 Expires B. Continuous/Reg 1938 0.03806 79675 41.11 0.04721 0.89782 1.24060
Jan 2013 Expires D. Revived 2512 0.04933 35730 14.22 0.02117 0.91899 0.42922
Jan 2013 Expires A. Newborn 2662 0.05228 34175 12.84 0.02025 0.93924 0.38739
----------------------------------------------------------------
Sourcing data from facts.memberships for Jan 2013
Sourcing data from facts.memberships for Jan 2012
Payment Month # Pmts Payment $ Avg Pmt $ Reg Pmt $ Def Pmt $ % Def $
------------- ------- ---------- ---------- ---------- ---------- --------
Jan 2012 50923 1687495 33.14 1638685 48810 0.02892
Jan 2013 48109 1595473 33.16 1554148 41325 0.02590
Expire Group Activation Segment # Pmts % Pmts Pmt $ Avg Pmt $ % Pmt $ Cum % Pmt $ Impact
---------------- -------------------- ------- ------- ------ ---------- -------- ------------ --------
May 2014 Expires B. Continuous/Reg 6493 0.13496 280725 43.24 0.17595 0.17595 1.30368
Jan 2014 Expires B. Continuous/Reg 6273 0.13039 229533 36.59 0.14386 0.31982 1.10332
Feb 2014 Expires B. Continuous/Reg 6890 0.14322 219770 31.90 0.13775 0.45756 0.96180
Jun 2014 Expires B. Continuous/Reg 5272 0.10958 190030 36.05 0.11911 0.57667 1.08688
Mar 2014 Expires B. Continuous/Reg 4616 0.09595 174375 37.78 0.10929 0.68596 1.13908
Apr 2014 Expires B. Continuous/Reg 3901 0.08109 156551 40.13 0.09812 0.78408 1.21009
Dec 2013 Expires B. Continuous/Reg 3097 0.06437 94001 30.35 0.05892 0.84300 0.91522
Jan 2014 Expires C. Consecutive 2392 0.04972 56670 23.69 0.03552 0.87852 0.71437
Jul 2014 Expires B. Continuous/Reg 1055 0.02193 43175 40.92 0.02706 0.90558 1.23396
Jan 2014 Expires A. Newborn 3153 0.06554 43068 13.66 0.02699 0.93257 0.41186
----------------------------------------------------------------
Sourcing data from facts.memberships for Jan 2014
Sourcing data from facts.memberships for Jan 2013
Payment Month # Pmts Payment $ Avg Pmt $ Reg Pmt $ Def Pmt $ % Def $
------------- ------- ---------- ---------- ---------- ---------- --------
Jan 2013 48109 1595473 33.16 1554148 41325 0.02590
Jan 2014 45047 1505617 33.42 1458407 47210 0.03136
Expire Group Activation Segment # Pmts % Pmts Pmt $ Avg Pmt $ % Pmt $ Cum % Pmt $ Impact
---------------- -------------------- ------- ------- ------ ---------- -------- ------------ --------
May 2015 Expires B. Continuous/Reg 6713 0.14902 293060 43.66 0.19464 0.19464 1.30614
Feb 2015 Expires B. Continuous/Reg 7341 0.16296 222002 30.24 0.14745 0.34209 0.90480
Jan 2015 Expires B. Continuous/Reg 5560 0.12343 219174 39.42 0.14557 0.48766 1.17940
Mar 2015 Expires B. Continuous/Reg 4746 0.10536 179735 37.87 0.11938 0.60704 1.13307
Jun 2015 Expires B. Continuous/Reg 3884 0.08622 151935 39.12 0.10091 0.70795 1.17039
Apr 2015 Expires B. Continuous/Reg 3754 0.08334 148233 39.49 0.09845 0.80641 1.18141
Dec 2014 Expires B. Continuous/Reg 2885 0.06404 80402 27.87 0.05340 0.85981 0.83381
Jan 2015 Expires C. Consecutive 3299 0.07323 69025 20.92 0.04584 0.90565 0.62599
Jan 2015 Expires A. Newborn 2438 0.05412 33996 13.94 0.02258 0.92823 0.41719
Jan 2015 Expires D. Revived 1852 0.04111 27200 14.69 0.01807 0.94630 0.43940
----------------------------------------------------------------
Sourcing data from simulation for Jan 2015
Sourcing data from facts.memberships for Jan 2014
Payment Month # Pmts Payment $ Avg Pmt $ Reg Pmt $ Def Pmt $ % Def $
------------- ------- ---------- ---------- ---------- ---------- --------
Jan 2014 45047 1505617 33.42 1458407 47210 0.03136
Jan 2015 40010 1385729 34.63 1372915 12813 0.00925
Expire Group Activation Segment # Pmts % Pmts Pmt $ Avg Pmt $ % Pmt $ Cum % Pmt $ Impact
---------------- -------------------- ------- ------- ------ ---------- -------- ------------ --------
May 2016 Expires B. Continuous/Reg 6865 0.17158 299214 43.59 0.21593 0.21593 1.25844
Jun 2016 Expires B. Continuous/Reg 5354 0.13382 220367 41.16 0.15903 0.37495 1.18838
Mar 2016 Expires B. Continuous/Reg 5204 0.13007 180174 34.62 0.13002 0.50497 0.99964
Jan 2016 Expires B. Continuous/Reg 4405 0.11010 171033 38.83 0.12342 0.62840 1.12104
Feb 2016 Expires B. Continuous/Reg 5081 0.12699 168478 33.16 0.12158 0.74998 0.95737
Apr 2016 Expires B. Continuous/Reg 2677 0.06691 108410 40.50 0.07823 0.82821 1.16924
Dec 2015 Expires B. Continuous/Reg 2889 0.07221 86066 29.79 0.06211 0.89032 0.86014
Jan 2016 Expires C. Consecutive 1933 0.04831 60097 31.09 0.04337 0.93369 0.89765
Jan 2016 Expires D. Revived 3481 0.08700 53483 15.36 0.03859 0.97228 0.44360
Jan 2016 Expires A. Newborn 1845 0.04611 25677 13.92 0.01853 0.99081 0.40181
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment