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.
- In the Google Sheets file you want to duplicate, go to Extensions → Supermetrics → Duplicate this file for another account.
- Select the accounts, pages, and views you want to use in the new duplicated file and its queries.
If you used several data sources in the original file, you will be asked to choose the accounts for all those data sources. Select the accounts for each data source and click Next until you reach the last one.
- Once you have selected your accounts, click Duplicate the 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.