How to modify the High Level PPC Report (monthly)

Hi there,


I've been wanting to modify this template a bit https://docs.google.com/spreadsheets/d/1EwrH-CBk14ojcSKjcKDxa3pYCq1VmPnAnxZVtittIQE/edit#gid=0. I'd like to have it so the data is based off of MTD compared to the previous month so for example: 1/1/2021 - 1/7/2021 compared to 12/1/2020 - 12/7/2020. Right now I think the template is doing last month compared to 2 months ago. 


  • Hi Brett,


    This template actually doesn't use any comparison values, but you can change the date range and add a comparison date range by two ways:


    1) Unhide the columns and navigate to column R. If you have the sidebar open, it should give you the option to edit the query if you select one of the cells that has the query on it. Click on 'modify' and make the desired changes. 


    2) You can also change queries if you open the SupermetricsQueries sheet (hidden by default) and edit the values in the date range columns. Then refresh the queries via Add-ons > Supermetrics > Refresh all.


    I hope this helps you further!


    Best,

    Menno

    - Supermetrics

Login to post a comment