I am currently using merged queries to calculate % change of media spend between two time periods. I use 2 dimensions, channel and platform, to see spend at a more granular level. The primary merged query shows data from the past 7 days, while the co...