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.