Marriott spend tracker thread
Jan 20, 2019 | 11:48 am
#1
Original Poster
FlyerTalk Evangelist
Join Date: Aug 2012
Location: KHOU/KIAH
Programs: AA EXP | Marriott LT Plat | Hyatt Explorist
Posts: 13,278
Marriott spend tracker thread
Given the complete opacity of Marriott spend and point tracking, I was thinking we can start a shared thread for tracking methods and templates. To that end, attached is a tracker spreadsheet I put together. Please feel free to comment/extend/criticize/help as you see fit.
Tab 1 : Dashboard - This is a running count of points (including a spot to include starting balance and redemptions) as well as spend towards Ambassador
Tab 2 : Data - This is where the data is entered
Tab 1 : Dashboard - This is a running count of points (including a spot to include starting balance and redemptions) as well as spend towards Ambassador
Tab 2 : Data - This is where the data is entered
- Yellow tabs are for informational tracking only
- Orange tabs are used for calculation
- Status - Based on selection, the point bonus is applied
- Brand - This lookup will determine the point multiplier (eg. 10 for Marriott vs 5 for Residence Inn)
- Base Spend - Sum of room rate
- Ancillary Spend - F&B etc.
- MAGC - Number of days of Make a Green Choice selected
- Bonus (Y/N) - For Platinum and up, this is the 1000 point welcome benefit.
- Gray tabs are calculated/tracked
- Tax Rate is informational. It turns red on > 20% to assist as a data entry validation check/prevent miskeys.
Last edited by Antarius; Jan 20, 2019 at 2:24 pm
Jan 20, 2019 | 2:43 pm
#3
Join Date: Jan 2009
Location: TUL
Programs: AA EXP 2MM; Marriott Titanium; Hyatt Explorist; MVC Chairman
Posts: 6,181
Given the complete opacity of Marriott spend and point tracking, I was thinking we can start a shared thread for tracking methods and templates. To that end, attached is a tracker spreadsheet I put together. Please feel free to comment/extend/criticize/help as you see fit.
Tab 1 : Dashboard - This is a running count of points (including a spot to include starting balance and redemptions) as well as spend towards Ambassador
Tab 2 : Data - This is where the data is entered
Tab 1 : Dashboard - This is a running count of points (including a spot to include starting balance and redemptions) as well as spend towards Ambassador
Tab 2 : Data - This is where the data is entered
- Yellow tabs are for informational tracking only
- Orange tabs are used for calculation
- Status - Based on selection, the point bonus is applied
- Brand - This lookup will determine the point multiplier (eg. 10 for Marriott vs 5 for Residence Inn)
- Base Spend - Sum of room rate
- Ancillary Spend - F&B etc.
- MAGC - Number of days of Make a Green Choice selected
- Bonus (Y/N) - For Platinum and up, this is the 1000 point welcome benefit.
- Gray tabs are calculated/tracked
- Tax Rate is informational. It turns red on > 20% to assist as a data entry validation check/prevent miskeys.
Jan 20, 2019 | 4:21 pm
#4
Original Poster
FlyerTalk Evangelist
Join Date: Aug 2012
Location: KHOU/KIAH
Programs: AA EXP | Marriott LT Plat | Hyatt Explorist
Posts: 13,278
From looking at the spreadsheet it appears the tax rate (informational only) is computed only utilizing the Total Spend less the sum of the base rates and ancillary spend. There are several things such as parking, spa treatments, mini-bars, etc that would be included in the Total Spend that would impact the calculation of the tax rate. I could see where the rate would turn "red" as you state yet not be a problem but only because there are other items other than Ancillary, Room Rates and Taxes in the Total Spend amount. Other than that I'm not sure the reason for the tax rate calculation since it appears the main purpose of the spreadsheet is to determine one's progress towards the $20,000 Ambassador requirement.
maybe Tax rate isnt the right term.. Cost Variance perhaps?
thanks for the input!
Jan 21, 2019 | 12:42 pm
#5
Join Date: May 2005
Location: London, England, United Kingdom
Programs: Marriott (Lifetime Titantium), whatever other programs as benefits make sense.
Posts: 2,012
Thanks for putting this together. A great start!
As a non-American, there is obviously the issue of what Marriott considers the value of non-US stays in something other than US dollars. Not travelling now, so haven't put in the effort to address it, but probably need to think about international stays and international guests. Will look at it as I have time.
As a non-American, there is obviously the issue of what Marriott considers the value of non-US stays in something other than US dollars. Not travelling now, so haven't put in the effort to address it, but probably need to think about international stays and international guests. Will look at it as I have time.
Jan 22, 2019 | 7:57 pm
#6
Original Poster
FlyerTalk Evangelist
Join Date: Aug 2012
Location: KHOU/KIAH
Programs: AA EXP | Marriott LT Plat | Hyatt Explorist
Posts: 13,278
Thanks for putting this together. A great start!
As a non-American, there is obviously the issue of what Marriott considers the value of non-US stays in something other than US dollars. Not travelling now, so haven't put in the effort to address it, but probably need to think about international stays and international guests. Will look at it as I have time.
As a non-American, there is obviously the issue of what Marriott considers the value of non-US stays in something other than US dollars. Not travelling now, so haven't put in the effort to address it, but probably need to think about international stays and international guests. Will look at it as I have time.
Jan 31, 2019 | 12:51 am
#7
Join Date: Dec 2013
Location: Homeless
Programs: Hyatt Glob; Hilton Dia; Marriott AMB; Accor Dia; IHG Dia Amb; GHA Tit
Posts: 5,004
The multipliers in column E of sheet "setup" look correct, but is there a link between spend and the brand for the purposes of the $20k ambassador threshold? For example, does spend at RC Reserve or Bvlgari count? I thought hotels were non-participating therefore any spend there does not contribute to the $20k. Also, perhaps it's a stupid question but if you spend $100 at Residence Inn, it counts as $100 spend rather than $50 spend despite points earning being cut in half, right?
Apr 1, 2019 | 8:30 am
#8
Original Poster
FlyerTalk Evangelist
Join Date: Aug 2012
Location: KHOU/KIAH
Programs: AA EXP | Marriott LT Plat | Hyatt Explorist
Posts: 13,278
The multipliers in column E of sheet "setup" look correct, but is there a link between spend and the brand for the purposes of the $20k ambassador threshold? For example, does spend at RC Reserve or Bvlgari count? I thought hotels were non-participating therefore any spend there does not contribute to the $20k. Also, perhaps it's a stupid question but if you spend $100 at Residence Inn, it counts as $100 spend rather than $50 spend despite points earning being cut in half, right?
Apr 1, 2019 | 8:35 am
#9
Original Poster
FlyerTalk Evangelist
Join Date: Aug 2012
Location: KHOU/KIAH
Programs: AA EXP | Marriott LT Plat | Hyatt Explorist
Posts: 13,278
Attached is v1.5
1. Included support for 2019 Double Take promo calculations
2. Improved the welcome bonus and MAGC points to the brand multipliers. (example, MAGC at Four points is worth 250 pts vs 500 at a W, for example).
Cheers.
1. Included support for 2019 Double Take promo calculations
2. Improved the welcome bonus and MAGC points to the brand multipliers. (example, MAGC at Four points is worth 250 pts vs 500 at a W, for example).
Cheers.