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
- Open a Google Sheets file.
- Navigate to Extensions → Supermetrics → Launch to open the Supermetrics sidebar.
- Click Create new query.
- Under Data source, choose which data source your query should pull data from.
- Select which data source account you want to use for this data source, and which query type to use, if prompted.
- If the data source has query types, select one to use under Report configuration. Available query types for each data source are listed in the connection guides.
- 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. - Make further adjustments in Options, and add a filter if you need one.
- In Data visuals, select a visualization for your data. Note that visualizations are available only when you're creating the query for the first time. When you're editing an existing query, you can't change the visualization.
- Click Get data. 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.