Supermetrics queries in Google Sheets are tied to the account used to create them. Use this guide if you need to transfer queries to a different account, manage multiple accounts, or have visibility over which other accounts can see or edit your queries.
Manage access to queries
If you give an account access to a document that contains Supermetrics queries, the added account can’t usually edit or refresh them.
However, they can refresh all queries if they have the same Supermetrics license user level as you, or higher. If they have the same level of access to the data sources (for example, a Google Analytics account) the queries pull from, they can edit all of those queries.
If you’re using a free trial of Supermetrics, with queries that comply with the trial’s limitations, an account given access to the file will be able to refresh all of its queries. If they have the same level of access to the data source as you do, they can edit all of these queries.
If you want to prevent anyone from using your access rights to refresh or edit queries, log out of your account. This will remove your authentication information. Other accounts that have access rights to the data source will still be able to refresh the queries using their own access rights.
Transfer queries to a different user
Before you begin
This process is easiest to complete if the person who owns the file with the queries and the Supermetrics license associated with it. If you can’t access the license or the Supermetrics Team Site, contact our support team for help.
The account that you’re transferring queries to needs:
- A valid Supermetrics license for Google Sheets, connected to the Google account they’ll use with the transferred queries. Learn more about transferring license ownership.
- Access to the data sources the queries pull from, or a general user account for each, so they can set up the data sources with their own accounts
- Open the new Google Sheets file that you want to transfer the queries to.
- Launch the Supermetrics sidebar and log in to each data source the queries pull from.
- Open the original Google Sheets file that contains the queries to be transferred.
- In both files, open the SupermetricsQueries tab. (This is hidden by default. Click Add-ons → Supermetrics → Manage queries to open it.)
- In the original Sheet, select and copy the whole row in the SupermetricsQueries that contains the query you want to transfer.
- Paste this row into the SupermetricsQueries tab in the new Sheet.
- Don’t make edits to any rows above Row 21 in the SupermetricsQueries tab.
- Staying in the same tab, delete the values in the Query ID (column A) and Refresh with user account (column AU).
- Click Add-ons → Supermetrics → Refresh all.
After you refresh, you’ll see a new Query ID in column A. Every time you transfer a query and refresh, verify that it has values in these cells.
If a transferred query fails because it can’t get a range for the query, it could be because the new query can’t recognize the range for the new data to be written on.
To fix this, open the SupermetricsQueries tab, and then delete the values in Sheet name (column E) and Range address (column D).
Replace those values with the name of the Sheet you want your query to be in in Sheet name, and then the cells you want as its range in Range address. It can help to copy this information over from your original Sheet, so your query appears in the same location in the new Sheet.
Click Add-ons → Supermetrics → Refresh all to complete the change.