Getting Started - Facebook Ads

This guide covers the basic functionality of the Supermetrics Facebook Ads connector, and gives examples of how to set up a query for Google Sheets, Google Data Studio, and Microsoft Excel. 


Quick links to the sections below:

Google Sheets

Google Data Studio

Microsoft Excel

"If everything fails..." 

Data Source Access Requirements:

To enable Supermetrics for Facebook Ads, you must have an Admin or Campaign Manager user role level. To learn more, please refer to these guides:

Google Sheets - Query Setup Example:

1. To authenticate the data source, please see:

How to Authenticate/Re-authenticate Facebook Ads in Google Sheets, Google Data Studio & Microsoft Excel

 2. Select account/s. To select a specific account, search with the account name. To select all accounts, click on "all accounts".

3. Select dates. Choose one date range (today, yesterday, last week, etc).

- To select a custom date, you can either insert the date manually on start and end or select it from the calendar bar.

- As an additional filter, you can also compare to a specific time frame (previous period, a year ago, etc).

4. Select metrics. To see all metrics that can be fetched with Facebook Ads, please see Facebook Ads documentation. To deselect a metric click on the X next to the metric's name. 

- When searching for a metric in the documentation, please see "Type met"

Field label is the metric name that appears in the sidebar. 

5. Split by dimensions. You can choose dimensions in rows and/or columns. To see all dimensions that can be fetched with Facebook Ads, please see Facebook Ads documentation. To deselect a dimension click on the X next to the dimension's name. 

If you wish to split dimensions to rows, select number of rows and how to sort them (automatic, month, year & month, etc.)

- If you wish to split dimensions to columns. Select number of columns and how to sort them (descending, alphabetical, reverse alphabetical, etc.). To deselect a dimension click on the X next to the dimension's name. 

- When searching for a dimension in the documentation, please see "Type dim"

Field label is the metric name that appears in the sidebar. 


6. As a last step, click on Get Data To Table.

You have completed all the steps to setup a query. 


Further Reading

1. As optional, click on filter to filter your data. Select field, operator and insert the value to filter by. 

2. Select options to add additional features to your query.

- Timezone: specifies timezone for displayed data. See the list of available timezone values here

- Conversion window: for Facebook Ads, please see Custom Conversion Window for Facebook Ads Metrics

- Time of action stats: choose either impression date or conversion date. 

In addition, these options are available:

- Show all time value values: please see What does the "Show all time values" do

- Replace blank metric values with zeroes.

- Combine new results with old: please see What does the "Combine new results with old" setting do

- Format results for Google Data Studio (to import data from Google Sheets to Google Data Studio).

- No header row.

- Highlight values with colours (green, red, etc.).

- Advanced settings: please see Advanced Settings for Google Sheets.

Google Data Studio - Query Setup Example:

1. To authenticate the data source, please see:

How to Authenticate/Re-authenticate Facebook Ads in Google Sheets, Google Data Studio & Microsoft Excel

2. Select dimensions. To see all dimensions that can be fetched with Facebook Ads, please see Facebook Ads documentation. To deselect a dimension click on the X next to the dimension's name.

- When searching for a dimension in the documentation, please see "Type dim"

Field label is the metric name that appears in the sidebar. 

4. Select metrics. To see all metrics that can be fetched with Facebook Ads, please see Facebook Ads documentation. To deselect a metric click on the X next to the metric's name.

- When searching for a metric in the documentation, please see "Type met"

Field label is the metric name that appears in the sidebar. 

5. Sort how the data is shown. Choose the field you wish to sort wish and the order you want to use (ascending/descending).

6.Select default date range on auto or custom.

- To select a custom date, click on last 28 days. An automatic calendar bar will open, select a date on start date and end date and click apply.

To select a specific period (fixed, previoud period, previous year, none, advanced), click on the arrow on the right top corner.

You have completed all the steps to setup a query. 


Further Reading

1. As optional, click on add a filter to filter your data.

If you encounter a discrepancy when using a filter, please see Discrepancies in Data Studio When Using a Filter.


Microsoft Excel - Query Setup Example:

1. To authenticate the data source, please see:

How to Authenticate/Re-authenticate Facebook Ads in Google Sheets, Google Data Studio & Microsoft Excel

2. Select account/s. To select a specific account, search with the account name. 

3. Select dates. Choose one date range (today, yesterday, last week, etc.).

- To select a custom date, you can either insert the date manually on start and end or select it from the calendar bar.

4. Select metrics. To see all metrics that can be fetched with Facebook Ads, please see Facebook Ads documentation. To deselect a metric click on the X next to the metric's name.

- When searching for a metric in the documentation, please see "Type met"

Field label is the metric name that appears in the sidebar. 

5. Split dimensions by rows and/or columns.

- If you wish to split dimensions by rows, select number of rows and how to sort them (ascending/descending).

- If you wish to split dimensions by columns, select number of categories and how to sort them (descending/alphabetical).


6. As a last step, click on Get data

You have completed all the steps to setup a query. 


Further Reading

1. As optional, click on add filter to filter your data.

2. Select options to add additional features to your query.

- Replace blank metric values with zeroes.

- No header row.

- Show all time value values: please see What does the "Show all time values" do

- Conversion window. 

- Time of action stats: choose either impression date or conversion date.

- Combine new results with old: please see What does the "Combine new results with old" setting do

- Custom, advanced settings: please see Advanced Settings for Excel.

Common errors:

- For authentication/re-authentication common errors, please see section "common errors" from this guide: How to Authenticate/Re-authenticate Facebook Ads in Google Sheets, Google Data Studio & Microsoft Excel

- Error:" Unsupported Get Request. Object With ID 'act_XXXX' Does Not Exist", please see this guide

- Facebook Ad account is missing from the list, please see this guide

- Facebook Ad Account Shared Through Business Asset Group Missing From List, please see this guide

- Facebook Ads Discrepancies Due to Conversion Windows, please see this guide

- Error validating access token: The user is enrolled in a blocking, logged-in checkpoint, please see this guide

- Getting "null" or "No Data" With Reach and Other Unique Metrics With Filters, please see this guide

Did you find it helpful? Yes No

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