Supermetrics Support Forum

How to Configure an Example Query With Supermetrics for Excel

This guide will show an example of how to set up a basic query for Facebook Ads, to demonstrate the configuration workflow, and how to run the query to get the data into the Excel sheet. This is a very basic example and will only over the necessary options, but hopefully shows the general flow of creating a query in the Supermetrics for Excel add-in.

This guide also assumes you have installed the add-in already, so if you haven't done that yet - see this guide for how to do the installation!

  1. Go through the steps to log into the data source as outlined in this article. This example continues where that guide left off with setting up a query for Facebook Ads.
  2. In Select accounts, select one or more ad accounts to use for the query.

    Example showing the ad account "Supermetrics Ads" has been selected for the account

  3. Then click Select dates to expand that section. This setting will be for what date range the query will being pulling the data from. There are many presets to select from, as well as the option for a "custom date range".

    Showing the date range option available for the query.

  4. For this example, "Last month" will be selected. This is a dynamic setting, so as time moves, what defines "Last Month" will change.
  5. Then click Select metrics. When clicking in the box, you will see all the metrics the tool supports for that data source. You can also start to type the field name in to the box to find it more quickly.

    Example showing the string "impre" typed into the box to find the "Impressions" metric in the list

  6. This example will use some popular metrics for Facebook Ads, like "Reach", "Impressions", and "Amount Spent".
  7. Then click on Split by. This will be the dimensions fields to be used to split the metrics into more meaningful categories. You can split by both rows and by columns, based on where the field is set.
  8. This example will split by row with "Date" and by "Campaign name". It will use the default sort option and leave the rows to be fetched at 100 (if you have more data than the rows setting it will cut it off).

    Example dimension selection with default sort settings

  9. Finally, click on Options. Here you can set a variety of additional settings, some general and others specific to the data source.
  10. For this example, the option to "Show all time values" will be selected and the Add Option button clicked to add it to the configuration.

    Showing the selected option and the blue "Add option" button to add it.

  11. The query is now complete and ready to run!
  12. Select in the sheet the cell the query will start at. Here we want it to be in A1, so we place the cursor there to select it:

    Green highlight around the A1 cell in the sheet

  13. Click Get Data to run the query and have it place the data in the sheet starting at A1.

    Complete example query with orange arrow pointing to blue "Get Data" button

  14. Here is some of the resulting data in the sheet, as well as showing the sidebar now converted into an overview mode of the query that will let you refresh it or modify it.

    Example query results with query overview in the sidebar

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.