If you have already built a Google Sheets file with multiple queries for specific data sources, you can duplicate the whole file and queries for other accounts — for example, all your clients' ad accounts.
About "Combine new results with old" setting
If you're using the "Combine new results with old" setting with your queries and want to duplicate the report, you have to manually copy the historical data for these queries from the original file and start a new query under the historical data or in another tab. Duplicating a report in Google Sheets will break the queries that use the "Combine new results with old" setting.
Instructions
- In the Google Sheets file you want to duplicate, open the Supermetrics sidebar.
- Scroll down to Duplicate for another account.
- Select the connection and accounts you want to use in the new duplicated file and its queries.
If you used several data sources in the original file, select the connections and accounts for all the data sources. - Once you have selected your connections and accounts, click Duplicate file.
- Your queries will now be duplicated and refreshed in the new copied file. This may take a few moments to complete, depending on the volume of queries in the original file.