When you create a query with Supermetrics in Google Sheets, you can modify it afterwards in the Supermetrics sidebar. You can also move queries from one cell to another.
- Click any cell in your Sheet. (When your query's ready, your data will populate starting in this cell.)
- In the Supermetrics sidebar, click Modify.
- Make any changes you want to the query setup, and click Apply changes.
- The query will be run again with the new setup. Once you no longer want to make edits, click Exit.
Before you begin
Every time you create a query in Supermetrics, it creates the query’s configuration in the SupermetricsQueries tab. This tab is hidden by default — to open it, click Add-ons → Supermetrics → Manage queries. Every query in a file is stored here.
The queries are organized in rows starting at row 21.
You can also edit the configuration of queries directly here. If you change an element and refresh the query, it’ll update based on the changes you made in its configuration.
Please note that while you can see all of the queries running in a file, there’s no way to view all of your queries across all files.
Because the SupermetricsQueries tab stores your query configurations directly, you should take care when interacting with it. Follow the guidance below.
- Don’t rename the tab. This will break the sidebar, which won’t be able to find the query configurations.
- Don’t delete the tab. If this tab is deleted, you’ll lose your configurations. Supermetrics doesn’t store them. If you delete this tab accidentally, restore the last good version from the file’s version history to restore it.
- Don’t edit rows 19-20. This can cause glitches and reliability issues. Only add queries at row 21 and below.
- New queries and copies should have an empty query ID. They’ll be assigned a new, unique ID the first time the query is refreshed.
Part of the query configuration stored in the SupermetricsQueries tab is the query’s cell range in the file. The range address updates if the size of the data changes.
There are 2 ways to move a query around in the same file.
For smaller queries that need to be repositioned in the same tab:
- Find the query data you want to move.
- Highlight all the cells that are part of that query.
- Hover over the edge of the selection until you see a Hand icon.
- Click the icon, and hold. Drag your selection to its new location and unclick to drop it.
The range address will update automatically in the query’s configuration.
For larger queries that need to be moved to the same tab, or to a new tab:
- Open the SupermetricsQueries tab.
- Find the row that contains the query you want to move.
- In that row only, delete the Query ID and Sheet Name values (columns A and D).
- Delete the existing value In the Range address cell (column E).
- Add the query’s new location into the Range address cell.
- Move your cursor away from the row, so it doesn’t lock the cells.
- Click Add-ons → Supermetrics → Refresh all. This will refresh the query to its new location, as written in Range address, and create new Query ID and Sheet name values for it.
Double-check that all the query’s data has been deleted from its original location. If this didn’t happen, delete it manually to clean it up.