Any way to calculate spend from this MP data?
I contacted MP today to get as much history as they had from my MP account. I already have everything back to 2013 -- with only 2019 missing. I contacted them via the chat function (first time using this) and they were able to help and I had the files in about 10 minutes to my email.
So, going through and trying to incorporate the 2019 file into my master excel file and I am a bit stumped. I cant remember what the rules/metrics were back in 2019. The columns that are in the file are: date, description, award miles base miles (yes, this is grouped as 1 column), bonus miles, total miles, premier qualification miles, segments.
I am trying to get the spend data.... for 2019, were any of these columns a calculation based on spend? For examples, are PQMs base fare multiplied by 11.... or something like this.
FYI, I was GS in 2019 which should be a factor in any calculation.