Frequently Asked Questions (FAQ)

Most common questions about Supermetrics for Google Drive

Can I schedule my reports to be refreshed or emailed at specific intervals?
Yes, you can. See the detailed guide at:
Thu, 12 Apr, 2018 at 4:15 PM
The triggers I added don't work.
There are a few things you can do: Delete the trigger and add it again. This usually fixes the issue. If the trigger is set to run very late in the eveni...
Mon, 30 Apr, 2018 at 4:16 PM
I've added triggers to refresh my queries every hour, but they don't work.
You can use multiple hourly triggers only with a Super Pro subscription.  The Pro subscription allows you to run one refresh per day per sheet. (If you ...
Mon, 13 Nov, 2017 at 2:10 PM
Which data sources can I access with Supermetrics for Google Docs/Sheets, and will you be adding more?
We are constantly adding more data sources. Some of the data sources we support are: Google Analytics AdWords Bing Ads YouTube Facebook Ads Facebook ...
Thu, 12 Apr, 2018 at 4:17 PM
I'm logged into Google Docs with one Google Account, but for Supermetrics, I want to log in to Google Analytics with a different Google Account. How do I do this?
There are two options: 1.) You can simply click the Log in link, and in the Google authentication page that opens, click the upper right corner to add t...
Thu, 12 Apr, 2018 at 4:20 PM
How does the tool determine where to place the data on query refresh? How can I move queries?
When you create a new query, our add-on creates a named range for it. The named range is called "zsupermetrics_" + the query ID. When you refresh ...
Thu, 12 Apr, 2018 at 4:25 PM
What does the "Filter referral spam" setting do?
When you use this setting, traffic from known spam referral sites will be filtered out of your query results. These are sites that send fake traffic to your...
Mon, 20 Mar, 2017 at 1:40 PM
What does the "Show all time values" setting do?
When you're splitting the data by a time dimension, using this setting ensures all time values (dates/weeks/months/years) will be returned, even if the...
Mon, 20 Mar, 2017 at 1:41 PM
What does the "Combine new results with old" setting do?
How exactly this setting works depends on the data source: Google Search Console only lets you fetch data on the last 90 days. With this setting, you ca...
Fri, 9 Mar, 2018 at 4:03 PM
Can I see/edit all of the queries that I've created?
Yes you can. All the queries that you have created per Google Sheet file, can be found from "SupermetricsQueries" -sheet. You can open up the ...
Mon, 20 Mar, 2017 at 2:01 PM