How to create a Supermetrics query in Google Sheets

This guide will walk you through how to create a query and start pulling your data directly into Google Sheets with Supermetrics.

Make sure you’ve installed the Supermetrics add-on and logged into at least one data source before you begin.

Instructions

1. Open a Google Sheets file.
2. Navigate to Extensions → Supermetrics → Launch to open the Supermetrics sidebar.
3. Click Create new query.
4. Under Data source, choose which data source your query should pull data from.
5. Select which data source account you want to use for this data source, and which query type to use, if prompted.
6. In the sidebar, choose your query’s Date range, Metrics, and Dimensions.
   With the Custom date range option, you can use exact dates but also sliding dates. For example, you can set the start date to be -5 days and the end day to yesterday. This information can be typed into the date boxes.
7. Make further adjustments in Options, and add a filter if you need one.
8. Click Get Data to Table. Your data will fill starting from the cell you’ve selected in your Sheet.

If you need to modify your query, click on any cell containing its data to open the Supermetrics sidebar and highlight the query or find the query in the sidebar. When you've found the right query, click the pencil icon to edit.

Next steps

• Use Supermetrics report templates
• Set up automatic data refreshes and email reports
• Enable advanced settings