Supermetrics Support Forum

Query Placement and How to Move Queries

This guide covers the behaviors of how the Supermetrics for Google Sheets inserts queries into the cells and also how to move queries after they have been created.


Quick links to sections below:

Behavior on Initial Query Creation

When a query configuration is run for the first time, the start point of the data will be in the cell the cursor is resting at when the query is run.


In this example, this new query will begin to be added at cell C3 in Sheet6 and fill out from there, based on the size and depth of the data.


This then translates to the query configuration being added into the SupermetricsQueries sheet with the sheet reference and the cell range that the data resides in. The range address will change on later refreshes if the size of the data changes.


How to Move Existing Queries Within the Same Sheet

Once a query has already been created, there's two ways to move it around in the same file.


Method #1 - The Drag-and-Drop

This method works best for smaller queries that you just need to re-adjust their position in the same tab.

  1. Find the query data you want to relocate your Sheet.
  2. Highlight all cells that are part of that query.
  3. Hover over the edge of the selection until you see the hand-icon.
  4. Drag it into the new position, and drop it.
  5. The range address for this query will update automatically in the configuration. Future refreshes will add it to the new location.

GIF showing the drag-and-drop technique to move a query to a new location


Method #2 - Manually Editing the Configuration

This method works best for very large queries that need to be moved either within the same tab or moved to another tab in the same sheet file.

  1. Open the SupermetricsQueries tab (if hidden click Add-ons->Supermetrics->Manage queries)
  2. Find the row that has the query you wish to move. In this example, we want to move this query in row 23 to another location:

    Orange box is highlighting the query in row 23, that is currently positioned in Sheet1, Range G13 to I19.

  3. In that row, delete the Query ID value, the Sheet name value and the first Range Address value (the E column one) for that row.

    Orange box highlighting the deleted values for row 23 to set up the move.

  4. Scroll to the far right until you get to the second Range address (static) column (column AP). For the row that you are editing, change this value to the new sheet and range address for the query.

    Orange box highlighting the original value for column AP (Range address static) for row 23

    Updated Range address for query in row 23 to Sheet movehere and range A1 to C6

    Note that it's more important to have the right start cell in the range than the right end cell - if you mess it up, it will overwrite it correctly for the whole size of the query.

  5. Move the cursor away from the row being edited so it does not lock the cells.
  6. Click Add-ons->Supermetrics->Refresh all.
  7. This should refresh the query into the new location, and update the deleted columns to have a new query ID.
  8. The example query now shows the new ID and the new location as set in the Range address (static) cell.

    Orange box highlights new location for row 23's query in Sheet movehere and range A1 to C7. Note that is was corrected to match the size of the query.

    Note that it has corrected the value to C7 instead of C6, to match the actual data size.

    Orange box highlights that the active tab is 'movehere' and shows the query now moved into position A1 to C7.

  9. This scenario will usually delete the data in the original location, but double-check this has been done after the query has refreshed. If the data was not removed in the original location, delete it manually to clean it up.


How to Move Existing Queries to Another Sheets File

These instructions can be used you need to relocate a query to another file or copy the query to reuse it.

  1. Open the SupermetricsQueries tab in the file you will be copying from (if hidden click Add-ons->Supermetrics->Manage queries).
  2. Find the row that has the query you wish to move. In this example, we want to move this query in row 23 to another file:

    Orange box is highlighting the query in row 23, that is currently positioned in Sheet1, Range G13 to I19.

  3. Copy the whole row of data.
  4. Open the new file you wish to copy into.
    • If the sheet file has never used Supermetrics before, please click Add-ons->Supermetrics->Launch to initialize the add-on and have it generate the SupermetricsQueries tab needed for the next steps.
  5. Open the SupermetricsQueries tab in the destination file (if hidden click Add-ons->Supermetrics->Manage queries).
  6. Paste the copied query row into the next available row under the header (if a new file, always copy into row 21 to start).
  7. Then in the copied row, delete the Query ID value, the Sheet name value and the first Range Address value (the E column one).

    Orange box highlighting the copied query's Query ID, Sheet name, and Range address have been deleted.

  8. Scroll to the far right until you get to the second Range address (static) column (column AP). For the row that you are editing, change this value to the new sheet and range address for the query. Make sure the sheet name exists in this destination file.

    Note that it's more important to have the right sheet name and start cell in the range than the right end cell - if you mess it up, it will overwrite it correctly for the whole size of the query.

  9. Move the cursor away from the row being edited so it does not lock the cells.
  10. Click Add-ons->Supermetrics->Refresh all.
  11. This should refresh the query into the new location, and update the deleted columns to have a new query ID.
  12. The example query now shows the new ID and the new location as set in the Range address (static) cell.

    Orange box highlighting that the copied query now positioned into Sheet1 A1 to C7 in the new file.

    Example of copied query now in the destination file.

  13. If this was to relocate the query, now delete the row for the query in the original file and delete the data in the original location.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.