FlyerTalk Forums - Halfway to LTD... Fun with Statistics

I just earned my 500th night in a Hilton property since joining the program in 2013. I went nerdy with the activity spreadsheet I keep. Below is some fun with statistics of my lifetime activity with Hilton.

Stays per year: 38
States: 19
Countries: 2
Nights per year: 74.3
Award Points Earned (not including CC bonus points): 1.98-million.

Award Points Earned per Night:

2013: 3,260
2014: 2,839
2015: 3,199
2016: 3,599
2017: 5,403
2018: 5,447
2019: 4,263

Unique Properties:

2013: 14
2014: 18
2015: 23
2016: 20
2017: 19
2018: 29
2019: 17
TOTAL: 97

Award Nights Redeemed:

2013: 2
2014: 7
2015: 9
2016: 5
2017: 11
2018: 17
2019: 13
TOTAL: 64

Nights per Year by Brand (DT, HI&S, Hilton, HS, ES, WA, HGI):

2013: 26, 6, 25, 4, 2, 1, 0
2014: 23, 9, 29, 0, 3, 0, 43
2015: 2, 58, 3, 3, 1, 3, 8
2016: 0, 52, 9, 0, 3, 1, 13
2017: 4, 32, 8, 0, 0, 1, 17
2018: 5, 45, 12, 2, 0, 2, 10
2019: 9, 23, 1, 0, 0, 5, 5

Total Nights by Brand:

DoubleTree: 69
Hampton Inn & Suites: 225
Hilton: 87
Homewood Suites: 9
Embassy Suites: 9
Waldorf Astoria: 13
Hilton Garden Inn: 96

Interesting Observations:

About 65% of my stay activity is with Hamptons and HGIs. However, since I started the program, my spend per night has increased by 45%. Economy is doing better, rates are rising, etc. With that, the award points per night have increased by the same margin.

I redeem 1 award night roughly every 8 paid nights. I'm content with that ratio considering the lower-tier hotel paid nights (HI&S, HGI) and higher-tier award nights (WA, Hilton).