Using ChatGPT to Create a Marriott Activity Spreasheet
 

As you probably know, you cannot easily download your historical Marriott activity and even printing it out is a pain. Those of us who like to download our stays/points into a spreadsheet to audit/analyze our activity have to go through a manual process of pasting the raw data into a spreadsheet and then doing a lot of manual data manipulation and parsing to get a proper data table. It is now possible to automate a substantial portion of that process using ChatGPT, so for anyone who cares I have created and tested a ChatGPT prompt that will automatically take the raw Marriott activity data and output it as an Excel spreadsheet file with each activity having its own row and the different kind of points associated with that acitivity in their own columns. (I made a similar one for American Airlines activity I posted in that forum.)

To take advantage of this there are a few requirements:

• You have to have access to the GPT-4 version of ChatGPT which allows you to upload files.
• This has to be done on laptop/pc using a web browser and preferably on as big a screen as possilbe, it will not work using your phone/mobile app.
• The instructions are for doing this with a Google Chrome browser. If you have Safari, Edge or some other browser too, it should work, you just have to modify steps 3,4 and 6 to use the feature similar to Google's inspection feature.

That said, here are the detailed instructions:

1. Create a new text file using something like Notepad or you can create an Excel file, whatever is easiest. Name it whatever you want. Leave the file open.
2. Log in to your Marriott account and select the "Activity" link from the top right dropdown menu under your name/icon.
3. Scroll down to the list of recent activity. Go to the "Filters:" on the top right, make sure the 1st drop down filter is set to "All Types" and then select the time period of activity you want to download in the 2nd drop-down box. The farthest back it will go is 24 months from today.
4. Now right click anywhere on the activity list and then select "Inspect", which should be towards the bottom of the list in the pop-up box. This will bring up a very complex looking companion box to the right or bottom of the webpage.
5. In the complex box, from the list of words across the top that starts with "Elements", then "Console", then "Sources" and then "Network" and so on, click on "Network".
6. Now go over to the activities webpage and go to the bottom of the activity list and to the right of the "View Per Page" select "All" from the drop down box.
7. Go back to the complex box on the right and look at the list of files that have rapidly loaded into in the Network tab. There will be a file titled "activityList.comp". Click on that name. It will bring up a big code file. Now right click on that same file name. This will bring up a pop-up box. Navigate to the "Copy" line in the box and then select the "Copy Response" from the sub pop-up that appears.
8. Select the file you created in Step 1 and paste the data you just copied into the file using the Control + V key or the Apple paste key. If using a spreadsheet, paste the data into the the top row and first column of your spreadsheet. Save the note/sheet and close it.
9. Go to ChatGPT (or Microsoft Co-Pilot w/ GPT-4). Upload (by clicking the papeclip icon) the note or speadsheet you just saved in step 8, then paste in the prompt listed below and then hit enter:
   
   Prompt: From the snippet of JSON code in the uploaded file, extract the data from each activitiesList records into a structured table putting each record into its own row and each data field within a record into in a separate column
   Ensure that any extracted numbers are converted from strings to integers to facilitate numerical operation.
   Save the final structured table as a new Excel file and provide a download link for it.
   
   
10. Click on the download link provided, open the downloaded spreadsheet file and enjoy.

Don't be alarmed if ChatGPT takes awhile or runs into some errors and restarts its analysis a couple of time while it thinks things through. It should evenutally finish and provide you will a nicely formated excel spreadsheet listing out all your Marriott activity for the timeframe you specified with separate columns for base, bonus and extra points.

If you have questions or run into issues feel free to post questions or better yet if you figure out a way to improve the process/prompt please post those. Any edits/improvements to the prompt can be used by everyone so hopefully over time the prompt will get better and better. My guess is by this time next year (or sooner) we may have a prompt that does steps 1-5 automatically as well but for now its nice to have step 6 automated.

BillBurn thank you for the really comprehensive how-to guide! I've tried it and it worked as expected, but only my 'reward stays' are shown in the generated Excel spreadsheet.

Diving into the raw json it seems that activitylist.comp only contains reward stays, though the web page shows all activites (with the reward stays at the bottom): "status":"success","message":"Rewards Component successfully resolved."

arjen05 Not 100% sure what the issue but the 1st thing I would check is to open the file you save in Step 8, scroll down a bit and confirm that the file has some non-reward stay activitiy in it. If it does not (and I suspect it doesn't), go back to Step 3, and before you select the specific time frame you are requesting, make sure activity filter (just to the left of the time filter) is set to "All Types". Then repeat the other steps.

If that is not the issue, you can always try just opening a new chat, pasting the prompt and uploading your file again(asuming you have confirmed it does have ALL your stay data) and running it again. Since ChatGPT is probabilistic and not deterministic, it often (and quite maddingly) provides different responses to the same question for no apparent reason.

The json does only contain reward activity, so that's the issue. Activity filter on marriott.com is set to all activity and I do see all my stays on the web page.