Skip to content

Instantly share code, notes, and snippets.

@jackross

jackross/july_2011_2015_payment_month.txt

Created September 19, 2014 16:49
Show Gist options
  • Save jackross/951befc69b589a1f30dc to your computer and use it in GitHub Desktop.
Save jackross/951befc69b589a1f30dc to your computer and use it in GitHub Desktop.
Download ZIP
July 2011 - 2015 Payment Month
Raw
july_2011_2015_payment_month.txt

----------------------------------------------------------------
Sourcing data from facts.memberships for Jul 2011
Sourcing data from facts.memberships for Jul 2010
Payment Month # Pmts Payment $ Avg Pmt $ Reg Pmt $ Def Pmt $ % Def $
------------- ------- ---------- ---------- ---------- ---------- --------
Jul 2010 22185 773460 34.86 734053 39407 0.05095
Jul 2011 20281 699990 34.51 664949 35041 0.05006
Expire Group Activation Segment # Pmts % Pmts Pmt $ Avg Pmt $ % Pmt $ Cum % Pmt $ Impact
---------------- -------------------- ------- ------- ------ ---------- -------- ------------ --------
Oct 2012 Expires B. Continuous/Reg 4610 0.22731 191280 41.49 0.27326 0.27326 1.20217
Aug 2012 Expires B. Continuous/Reg 2637 0.13002 95480 36.21 0.13640 0.40966 1.04905
Jul 2012 Expires C. Consecutive 3186 0.15709 85145 26.72 0.12164 0.53130 0.77430
Jul 2012 Expires B. Continuous/Reg 2103 0.10369 83645 39.77 0.11949 0.65079 1.15238
Sep 2012 Expires B. Continuous/Reg 1794 0.08846 82904 46.21 0.11844 0.76923 1.33890
Jun 2012 Expires B. Continuous/Reg 2316 0.11420 79610 34.37 0.11373 0.88296 0.99592
Jul 2012 Expires A. Newborn 1558 0.07682 22535 14.46 0.03219 0.91515 0.41907
Nov 2012 Expires F. Gift Recipient 352 0.01736 9225 26.21 0.01318 0.92833 0.75927
Oct 2012 Expires B. Continuous/Def 58 0.00286 6430 110.86 0.00919 0.93752 3.21174
Jun 2013 Expires B. Continuous/Def 153 0.00754 5835 38.14 0.00834 0.94585 1.10485
----------------------------------------------------------------
Sourcing data from facts.memberships for Jul 2012
Sourcing data from facts.memberships for Jul 2011
Payment Month # Pmts Payment $ Avg Pmt $ Reg Pmt $ Def Pmt $ % Def $
------------- ------- ---------- ---------- ---------- ---------- --------
Jul 2011 20281 699990 34.51 664949 35041 0.05006
Jul 2012 25123 843287 33.57 708332 134955 0.16003
Expire Group Activation Segment # Pmts % Pmts Pmt $ Avg Pmt $ % Pmt $ Cum % Pmt $ Impact
---------------- -------------------- ------- ------- ------ ---------- -------- ------------ --------
Nov 2013 Expires B. Continuous/Reg 3937 0.15671 170458 43.30 0.20214 0.20214 1.28987
Aug 2013 Expires B. Continuous/Reg 3511 0.13975 122075 34.77 0.14476 0.34690 1.03583
Sep 2013 Expires B. Continuous/Reg 1812 0.07213 76500 42.22 0.09072 0.43761 1.25776
Jul 2013 Expires B. Continuous/Reg 1864 0.07419 74260 39.84 0.08806 0.52567 1.18687
Jul 2013 Expires C. Consecutive 2080 0.08279 63755 30.65 0.07560 0.60128 0.91315
Jun 2013 Expires B. Continuous/Reg 1675 0.06667 60920 36.37 0.07224 0.67352 1.08353
Nov 2013 Expires B. Continuous/Def 1075 0.04279 50410 46.89 0.05978 0.73329 1.39700
Oct 2013 Expires B. Continuous/Reg 1173 0.04669 49705 42.37 0.05894 0.79224 1.26238
Jan 2014 Expires B. Continuous/Def 891 0.03547 36340 40.79 0.04309 0.83533 1.21507
Jul 2013 Expires A. Newborn 2654 0.10564 35285 13.30 0.04184 0.87717 0.39608
----------------------------------------------------------------
Sourcing data from facts.memberships for Jul 2013
Sourcing data from facts.memberships for Jul 2012
Payment Month # Pmts Payment $ Avg Pmt $ Reg Pmt $ Def Pmt $ % Def $
------------- ------- ---------- ---------- ---------- ---------- --------
Jul 2012 25123 843287 33.57 708332 134955 0.16003
Jul 2013 27106 921738 34.00 813673 108065 0.11724
Expire Group Activation Segment # Pmts % Pmts Pmt $ Avg Pmt $ % Pmt $ Cum % Pmt $ Impact
---------------- -------------------- ------- ------- ------ ---------- -------- ------------ --------
Nov 2014 Expires B. Continuous/Reg 3770 0.13908 167955 44.55 0.18221 0.18221 1.31011
Aug 2014 Expires B. Continuous/Reg 3412 0.12588 128601 37.69 0.13952 0.32173 1.10839
Sep 2014 Expires B. Continuous/Reg 3077 0.11352 111275 36.16 0.12072 0.44246 1.06348
Jul 2014 Expires B. Continuous/Reg 2490 0.09186 99725 40.05 0.10819 0.55065 1.17777
Jun 2014 Expires B. Continuous/Reg 3026 0.11164 97805 32.32 0.10611 0.65676 0.95049
Jul 2014 Expires C. Consecutive 2515 0.09278 69250 27.53 0.07513 0.73189 0.80972
Oct 2014 Expires B. Continuous/Reg 1462 0.05394 57395 39.26 0.06227 0.79416 1.15447
Nov 2014 Expires B. Continuous/Def 1050 0.03874 48630 46.31 0.05276 0.84692 1.36199
Dec 2014 Expires B. Continuous/Def 1050 0.03874 40505 38.58 0.04394 0.89086 1.13442
Jul 2014 Expires A. Newborn 1846 0.06810 26475 14.34 0.02872 0.91958 0.42174
----------------------------------------------------------------
Sourcing data from facts.memberships for Jul 2014
Sourcing data from facts.memberships for Jul 2013
Payment Month # Pmts Payment $ Avg Pmt $ Reg Pmt $ Def Pmt $ % Def $
------------- ------- ---------- ---------- ---------- ---------- --------
Jul 2013 27106 921738 34.00 813673 108065 0.11724
Jul 2014 23604 850118 36.02 724869 125249 0.14733
Expire Group Activation Segment # Pmts % Pmts Pmt $ Avg Pmt $ % Pmt $ Cum % Pmt $ Impact
---------------- -------------------- ------- ------- ------ ---------- -------- ------------ --------
Nov 2015 Expires B. Continuous/Reg 3886 0.16463 167680 43.15 0.19724 0.19724 1.19808
Aug 2015 Expires B. Continuous/Reg 2580 0.10930 105220 40.78 0.12377 0.32101 1.13236
Sep 2015 Expires B. Continuous/Reg 2327 0.09858 96290 41.38 0.11327 0.43428 1.14892
Jul 2015 Expires B. Continuous/Reg 2023 0.08571 86371 42.69 0.10160 0.53588 1.18543
Jun 2015 Expires B. Continuous/Reg 2287 0.09689 77620 33.94 0.09130 0.62718 0.94234
Jul 2015 Expires C. Consecutive 2529 0.10714 68650 27.15 0.08075 0.70794 0.75369
Dec 2015 Expires B. Continuous/Def 1572 0.06660 57020 36.27 0.06707 0.77501 1.00712
Nov 2015 Expires B. Continuous/Def 1087 0.04605 51080 46.99 0.06009 0.83510 1.30473
Oct 2015 Expires B. Continuous/Reg 1107 0.04690 45180 40.81 0.05314 0.88824 1.13318
Jul 2015 Expires A. Newborn 1222 0.05177 25351 20.75 0.02982 0.91806 0.57600
----------------------------------------------------------------
Sourcing data from simulation for Jul 2015
Sourcing data from facts.memberships for Jul 2014
Payment Month # Pmts Payment $ Avg Pmt $ Reg Pmt $ Def Pmt $ % Def $
------------- ------- ---------- ---------- ---------- ---------- --------
Jul 2014 23604 850118 36.02 724869 125249 0.14733
Jul 2015 23136 820472 35.46 642678 177794 0.21670
Expire Group Activation Segment # Pmts % Pmts Pmt $ Avg Pmt $ % Pmt $ Cum % Pmt $ Impact
---------------- -------------------- ------- ------- ------ ---------- -------- ------------ --------
Nov 2016 Expires B. Continuous/Reg 3512 0.15180 151150 43.04 0.18422 0.18422 1.21361
Dec 2016 Expires B. Continuous/Def 2718 0.11748 111051 40.86 0.13535 0.31957 1.15211
Sep 2016 Expires B. Continuous/Reg 2581 0.11156 90339 35.00 0.11011 0.42968 0.98699
Jun 2016 Expires B. Continuous/Reg 2446 0.10572 87473 35.76 0.10661 0.53629 1.00842
Aug 2016 Expires B. Continuous/Reg 1942 0.08394 83119 42.80 0.10131 0.63760 1.20691
Jul 2016 Expires B. Continuous/Reg 1763 0.07620 72985 41.40 0.08895 0.72655 1.16735
Jul 2016 Expires C. Consecutive 2185 0.09444 68471 31.34 0.08345 0.81001 0.88364
Nov 2016 Expires B. Continuous/Def 1197 0.05174 61349 51.25 0.07477 0.88478 1.44524
Jul 2016 Expires D. Revived 2612 0.11290 34705 13.29 0.04230 0.92708 0.37466
Oct 2016 Expires B. Continuous/Reg 760 0.03285 28186 37.09 0.03435 0.96143 1.04578
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment