If we pull data from four different data sources (Google Analytics, Google Ads, Facebook ads, and Google Search Console) into Google Sheets, the Supermetrics Google Sheets Add-on run four different queries in the background.
Therefore by extracting data from multiple data sources into one Google Sheet, we run multiple queries in one Google Sheet.
However, you should avoid running more than one query per Google Sheet.
How to view query information in Google Sheets via Supermetrics
#2 Viewing query information via a SupermetricsQueries sheet
Follow the steps below:
Step-1: Navigate to ‘Add-ons’ menu > Supermetrics and then click on the ‘Manage Queries’ link:
As soon as you click on the ‘Manage Queries’ link, Supermetrics will create a new sheet in your Google Sheet document named ‘SupermetricsQueries’:
Step-2: Click on the ‘SupermetricsQueries’ sheet tab. All the queries created by supermetrics are stored here:
If you remember, we pulled data from four different data sources (Google Analytics, Google Ads, Facebook ads and Google Search Console) into Google Sheets. In other words, we ran four different queries via Supermetrics Google Sheets add-on.
That’s why the SupermetricsQueries sheet shows data for four different queries:
Each query is uniquely identified by an ID called the ‘Query ID’.
Through the SupermetricsQueries sheet you can:
Modify the parameters of a query. Any changes will be visible when you run a refresh.
Remove a query by deleting its row.
Add new queries: type a range address and query parameters, leave the query ID empty. The query will be added when you run a refresh. (Of course, it’s much easier to use the ‘Supermetrics sidebar to add new queries.)
Add queries that point to other spreadsheets: follow step 3, but also add a spreadsheet ID (you can see the ID in the URL when you have a file open).
How to modify queries in Google Sheets via Supermetrics
Every time you pull data from a data source (like Google Search Console), the Supermetrics Google Sheets Add-on creates and runs a query in the background.
Supermetrics run queries at a specific location in Google Sheets. This location is specified by you when you click on a particular cell.
There are two methods to modify a query:
Via the Supermetrics Sidebar (recommended)
Manually modify the query via the SupermetricsQueries sheet
#1 Modifying query via Supermetrics sidebar
Step-1: Click on any cell in the data table in your Google Sheet whose query information you want to see.
For example in the screenshot below I clicked on a cell of the data table which shows data from Google Analytics:
Step-2: Navigate to ‘Add-ons’ menu > Supermetrics and then click on the ‘Launch Sidebar’ link:
You should now be able to see the query information:
Step-3: Above the ‘Query Information’ section there is a ‘Modify’ button. Click on it to modify your query:
Step-4: Change one or more settings (like ‘Data Source’, ‘Views’, ‘Dates’ etc). Once you have made all the necessary changes then click on the ‘Apply Changes’ button:
Note: When you change these settings, supermetrics is going to modify the query in the background.
Step-5: Once the query is modified then click on the ‘Exit’ button:
#2 Manually modify the query via the SupermetricsQueries sheet
Step-1: Click on the ‘SupermetricsQueries’ sheet tab.
Step-2: Manually change one or more fields (like ‘Range Address’, ‘Date Range Type’, ‘Start Date’, ‘End Date’ etc) of a query:
You need to have a very good knowledge of Google Sheets and its formulas if you want to modify the queries directly via the SupermetricsQueries sheet.
Otherwise, you are likely to make a lot of mistakes and your queries may not run. That’s the reason, I don’t recommend modifying queries manually.
Step-3: Once you have made all the necessary changes to your query then click on the ‘Refresh All’ link (under (Add-ons > Supermetrics menu):
You would then see a message box like the one below:
Followed by:
That’s how you can modify queries manually in Google Sheets via the SupermetricsQueries sheet.
Refreshing queries automatically in Google Sheets
If you want the latest data in your Google Sheets all the time then you should schedule query refreshes via the Supermetrics Google Sheets Add-on.
When your schedule refreshes, Supermetrics automatically refreshes the queries after a certain time has elapsed.
You can schedule refreshes by creating one or more triggers.
There are two categories of triggers:
Refresh-only triggers
Refresh and email triggers
#1 Refresh-only triggers
You can instruct Supermetrics to automatically refresh queries after specific time intervals say every hour. In this way, the data in your Google Sheets will always remain up to date.
Otherwise, you would have to remember to manually update the query, every time you choose to use that data either in Google Sheets or Looker Studio.
Following are the various Refresh-only triggers available in Supermetrics:
Refresh hourly
Refresh daily
Refresh weekly
Refresh monthly
#2 Refresh and email triggers
You can instruct Supermetrics to not only automatically refresh queries after a certain time has elapsed but also email you the updated report(s).
Following are the various Refresh and email triggers available in Supermetrics:
Refresh & Email daily
Refresh & Email weekly
Refresh & Email monthly
Follow the steps below to create a new trigger and schedule query refreshes:
Step-2: Select the action you want Supermetrics to take from the ‘Action’ drop-down menu:
Step-3: Change the various settings (which are pretty self-explanatory) and then click on the ‘Store trigger‘ button.
Following is a short description of various scheduling actions (aka triggers) you can use:
Refresh hourly
Supermetrics will automatically refresh/run queries every hour:
Refresh daily
Supermetrics will automatically refresh/run queries once every day at a specified time:
Refresh weekly
Supermetrics will automatically refresh/run queries once every week on a specified day and time:
Refresh monthly
Supermetrics will automatically refresh/run queries once a month on a specified day and time:
Refresh & Email daily
Supermetrics will automatically refresh/run queries once every day at a specified time and then automatically email the report in the format you specified:
Here is how the email notification from Supermetrics may look like:
Refresh & Email weekly
Supermetrics will automatically refresh/run queries once every week on a specified day and time and then automatically email the report in the format you specified.
Refresh & Email monthly
Supermetrics will automatically refresh/run queries once every month on a specified day and time and then automatically email the report in the format you specified.
Sending email alerts if queries fail on refresh
Sometimes your query may fail on scheduled refresh. But you may not know about it unless you manually check your query status.
You can instruct supermetrics to automatically send email alerts to you if your queries fail on scheduled refresh by clicking on the checkbox ‘Send email alerts if queries fail on refresh‘ (while setting up a trigger):
Creating a second trigger
If you want Supermetrics to take another scheduled action then click on the ‘+Add trigger’ button:
Configure your second trigger and then click on the ‘Store Trigger’ button:
"How to use Digital Analytics to generate floods of new Sales and Customers without spending years figuring everything out on your own."
Here’s what we’re going to cover in this training…
#1 Why digital analytics is the key to online business success.
#2 The number 1 reason why most marketers are not able to scale their advertising and maximize sales.
#3 Why Google and Facebook ads don’t work for most businesses & how to make them work.
#4 Why you won’t get any competitive advantage in the marketplace just by knowing Google Analytics.
#5 The number 1 reason why conversion optimization is not working for your business.
#6 How to advertise on any marketing platform for FREE with an unlimited budget.
#7 How to learn and master digital analytics and conversion optimization in record time.
My best selling books on Digital Analytics and Conversion Optimization
Maths and Stats for Web Analytics and Conversion Optimization
This expert guide will teach you how to leverage the knowledge of maths and statistics in order to accurately interpret data and take actions, which can quickly improve the bottom-line of your online business.
Master the Essentials of Email Marketing Analytics
This book focuses solely on the ‘analytics’ that power your email marketing optimization program and will help you dramatically reduce your cost per acquisition and increase marketing ROI by tracking the performance of the various KPIs and metrics used for email marketing.
Attribution Modelling in Google Analytics and BeyondSECOND EDITION OUT NOW!
Attribution modelling is the process of determining the most effective marketing channels for investment. This book has been written to help you implement attribution modelling. It will teach you how to leverage the knowledge of attribution modelling in order to allocate marketing budget and understand buying behaviour.
Attribution Modelling in Google Ads and Facebook
This book has been written to help you implement attribution modelling in Google Ads (Google AdWords) and Facebook. It will teach you, how to leverage the knowledge of attribution modelling in order to understand the customer purchasing journey and determine the most effective marketing channels for investment.
About the Author
Himanshu Sharma
Founder, OptimizeSmart.com
Over 15 years of experience in digital analytics and marketing
Author of four best-selling books on digital analytics and conversion optimization
Nominated for Digital Analytics Association Awards for Excellence
Runs one of the most popular blogs in the world on digital analytics
Consultant to countless small and big businesses over the decade
Get My Step-By-Step Blueprint For Finding The Best KPIs (32 pages ebook)
We use cookies on our website to give you the most relevant experience by remembering your preferences and repeat visits. By clicking “Accept”, you consent to the use of ALL the cookies.
This website uses cookies to improve your experience while you navigate through the website. Out of these, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may affect your browsing experience.
Necessary cookies are absolutely essential for the website to function properly. These cookies ensure basic functionalities and security features of the website, anonymously.
Cookie
Duration
Description
cookielawinfo-checkbox-analytics
11 months
This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Analytics".
cookielawinfo-checkbox-functional
11 months
The cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional".
cookielawinfo-checkbox-necessary
11 months
This cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category "Necessary".
cookielawinfo-checkbox-others
11 months
This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Other.
cookielawinfo-checkbox-performance
11 months
This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Performance".
viewed_cookie_policy
11 months
The cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. It does not store any personal data.
Functional cookies help to perform certain functionalities like sharing the content of the website on social media platforms, collect feedbacks, and other third-party features.
Performance cookies are used to understand and analyze the key performance indexes of the website which helps in delivering a better user experience for the visitors.
Advertisement cookies are used to provide visitors with relevant ads and marketing campaigns. These cookies track visitors across websites and collect information to provide customized ads.
Analytical cookies are used to understand how visitors interact with the website. These cookies help provide information on metrics the number of visitors, bounce rate, traffic source, etc.