Some more (better??) data on hotel point values

Discussion in 'Wandering Aramean Travel Tools' started by Wandering Aramean, Dec 18, 2014.  |  Print Topic

  1. Wandering Aramean
    Original Member

    Wandering Aramean Gold Member

    Messages:
    28,216
    Likes Received:
    61,747
    Status Points:
    20,020
    Yesterday I posted some charts showing off a bit of the data I’ve collected on hotel program point values compared across eight brands. I also asked what other information from that data set might be of interest. And, well, y’all are very interested. Some of the requests were easier than others so I’ve updated the data sets on the Hotel Hustle Data Visualization page and I’m including the snapshots here.

    One of the requests was to show median rather than mean for the point values. That turns out to be easy enough. So now the top chart shows both. In most cases the two are sufficiently close together that it doesn’t really render well in the graph but for SPG you can see the spread. The median values are generally 8-14% below the mean within each brand.

    [​IMG][​IMG]

    Another request was to show the 25th & 75th percentile numbers. Once you’re calculating the median value the others are reasonably easy to get at as well. So I’ve added a second chart showing them.

    [​IMG][​IMG]

    This data suggests that Marriott and Hyatt have the widest variability in point value relative to the median.

    And, as I noted in the other post, I’ll continue to point out that the accrual rates for the different programs vary significantly so it is not possible to look only at these charts and say that points in one program are better or worse than points in another program. People have different approaches to accrual such that I’m not sure a completely fair comparison can be drawn, but generally speaking the points with higher values on the chart are also harder to accumulate. And if a program doesn’t have a hotel where you want to go then it doesn’t matter anyways.

    Lots of variables. Lots of data. Lots of fun.

    Related Posts:


    The post Some more (better??) data on hotel point values appeared first on Wandering Aramean.

    Continue reading...
     
    HaveMilesWillTravel likes this.
  2. HaveMilesWillTravel
    Original Member

    HaveMilesWillTravel Gold Member

    Messages:
    12,504
    Likes Received:
    20,199
    Status Points:
    16,520
    Where the numbers are probably most helpful to me is when thinking about credit card usage. I have a number of hotel cards (Carlson, SPG, IHG, Hilton... SPG likely will go away next year). I don't aim for top status with any hotel company and pretty much spread my stays around based on what property/chain best needs my needs for a given stay. Price, points, promotions, elite benefits... all are some factor in that "calculation". Taking the median numbers, if I spend a dollar in a non-bonused category, I would earn

    - 5 CC points
    - 3 HHonors points
    - 1 IHG point
    - 1 Star point

    Needless to say, the IHG card doesn't have a permanent slot in my wallet. And neither does the HHonors card. And it seems the Club Carlson card then beats out the SPG card by a hair.
     
  3. Wandering Aramean
    Original Member

    Wandering Aramean Gold Member

    Messages:
    28,216
    Likes Received:
    61,747
    Status Points:
    20,020
    And someone in the comments on the earlier post chided me for considering non-bonus earning categories rather than only considering valuation based on the best bonus ratio used in a heavy manufactured spending scenario. Hard to please everyone which is why I'm mostly staying out of the fray.

    But if I can give you better tools and data to do the analysis yourself then I'm all over it. :cool:
     
    HaveMilesWillTravel likes this.
  4. HaveMilesWillTravel
    Original Member

    HaveMilesWillTravel Gold Member

    Messages:
    12,504
    Likes Received:
    20,199
    Status Points:
    16,520
    I don't really manufacture spend. According to my records, I bought $5k Vanilla Reloads the first few months of the year when I had convenient opportunities, but that's probably the daily "spend" for many in that business. I have too many other things going on that keep me busy and are more productive in the big picture. So having some fact-based valuations that let me make decisions once (set it and forget it and don't worry about every fractional mile/point) helps.
     
    Wandering Aramean likes this.
  5. mattsteg
    Original Member

    mattsteg Gold Member

    Messages:
    3,276
    Likes Received:
    5,543
    Status Points:
    4,170
    chart of hotel price vs point value would be interesting. Maybe a calculator where people can enter their own earning rate to normalize?
     
  6. Wandering Aramean
    Original Member

    Wandering Aramean Gold Member

    Messages:
    28,216
    Likes Received:
    61,747
    Status Points:
    20,020
    I already let you enter your perceived value of the points to help calculate the value portion on searches.

    I do like the idea of CPP grouped by cash rates. Maybe something like <$75 and then $50 increments up from there perhaps.
     

Share This Page