So you’ve created an awesome Google Sheet report for one client. Here’s how to repurpose that for another account easily. 🙌🏻
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.
Note: If you used several data sources in the original file, you will be asked to choose the accounts for all those data sources
Once you have selected your accounts, click Duplicate the file.
Your queries will now be duplicated and refreshed in the newly copied file. Depending on the volume of queries in the original file, this may take a few moments to complete. ...And that’s it.