How to set up, run, and copy Supermetrics queries in Excel

Supermetrics Support Site Team

Modified on: Wed, 28 Aug, 2024 at 10:15 AM

This guide will walk you through how to run queries and start pulling your data into Excel with Supermetrics.

Before you begin

Note that once you've created a query, you can copy it to any Excel spreadsheet you use with Supermetrics.

Open an Excel file.
In the Ribbon, navigate to the Data tab.
At the right-hand side of the Ribbon, click Show Supermetrics.
In the Data source section of the sidebar, select the data source you want to pull data from.
Select the data source account (its name will depend on the data source). Select at least one to include in the query.
Navigate to Select dates. Set your date range.
Navigate to Select metrics. Choose as many metrics as your report needs.
In the Split by section, set your data to be split to rows and/or columns with different dimensions.
Use the Filter and Options sections to further customize your query. Learn how to use filters here.
When you’re ready, click Get Data. Your data will be inserted starting from the cell you’ve selected in your spreadsheet.

If you need to refresh, modify, or delete the query, click any cell containing the query's data, and the Query info tab will open again.

To refresh the query, click Refresh.
To make changes to the query, click Modify, make the adjustments, and click Update to run the query again.
To delete the query, click the 3-dot icon, and select Delete query or Delete query and data.

You can copy Supermetrics queries and reuse them in other Excel spreadsheets.

In the Excel worksheet you want to copy the query from, open the SupermetricsQueries tab. (This is the saved configuration of all the queries in the file, and it’s hidden by default. To open the tab, right-click on a tab, click Unhide..., and select SupermetricsQueries.)
Find the row that contains the query you want to copy.
Highlight the full row. Copy it by right-clicking and selecting Copy, or using the Ctrl + C command.
In the worksheet you want to copy the query to, open the SupermetricsQueries tab.
Paste the copied row into the next empty row in the SupermetricsQueries tab.
Scroll to the far right. In the second Range address (static) column, update the copied query’s row to the place in the file where you want it to appear. Update both the sheet name and the range.
Open the Supermetrics sidebar and click Refresh. The new query’s data will appear in the location specified in its row in the SupermetricsQueries tab.