This guide covers the following kinds of behavior found in the Supermetrics for Google Sheets product:
- User thought they updated query, but old configuration still showing in results
- Results not updating
- Results misaligned/data from older query still showing
- Queries seem to work fine with manual refreshes, but get unexpected data/errors with triggered refreshes
- Mixed results in the cells, like two different queries wrote into the cells at the same time
In most cases, these behaviors are due to having one or more queries saved into the same cell space on that sheet, and depending on the order they run in, you can see different results, including older data or issues you thought you corrected.
Checking For and Fixing Duplicate Queries
- Open the SupermetricsQueries tab (if hidden, click Add-ons->Supermetrics->Manage queries to reveal it).
- Check the "Sheet name" and "Range address" columns to see if there are different queries assigned to the same or overlapping cells. As an example of this, here there are two queries in Sheet2 in range J2-K11:
- If you see there are overlapping or duplicated queries, check the rows to see which is the one to keep (the full configuration will be shown in the row).
- Delete the whole row for the duplicates you do not want.
- Repeat as needed for other sets of duplicates.
- Once there is only one query per cell set, refresh those remaining to update the data.
- Note that if there was a lot of extra data in the destination due to misaligned queries or cell write conflicts, you may want to delete all the old data in that sheet and then run the remaining queries to ensure clean data.
How Does This Happen?
In most cases, the duplication is purely an accident. The sidebar state is sometimes unclear to users and they may believe they are editing an existing query, but are actually creating a new copy of it over the old one. So the key to avoiding this in the future is to know what state the sidebar is in.
If the sidebar looks like this, regardless of what is in the settings, this is a "create query" state and no query is selected. Continuing with this will make a new query:
If the sidebar looks like this, this is the "query overview" state with an existing query selected and could be modified:
If the sidebar looks like this, an existing query is being actively modified:
So to make sure you are editing the query, select a cell in the query results, wait for the sidebar to change to the overview state. Then click Modify to edit it.
There are also some special circumstances that the query configuration recording process gets interrupted and it may make duplicates as a safety measure. This is often due to exceeding the cell character limit or the Sheet cell limit, and preventing that from happening should stop the duplications.