Facebook Ads
  • 5 Minutes to read
  • Dark

Facebook Ads

  • Dark

Connector Overview


When authorizing access to your Facebook account, make sure the account has the proper permissions to access the data you would like to extract. To access the ads account data, the user must have Manager permission. However, the best practice is to create a dedicated System User within Facebook Business Manager. Check the Facebook tutorial for further details.

Available Metrics

Dataddo can extract all the metrics provided via Facebook's official API. The full list is available here.


Facebook Ads API has a hard limit for the total number of rows that can be extracted per call. However, Dataddo supports automatic pagination, meaning Dataddo will make multiple calls to the Facebook API in order to retrieve all of your data.

Reach and ad recall data may not match.

The problem with reach and ad recall metrics is that these metrics cannot be simply summed to get the totals for longer periods. The reason for this is that these metrics are measuring the daily unique users, who either see your ad (reach) or will remember the ad (ad recall). It is not possible to get data for a specific period and keep aggregating them.

  1. One option is to get the daily breakdown and then the daily values will match, but not when summing over more days.

  2. The second solution is to get the data weekly or monthly and these weekly/monthly values will match Facebook exactly.

    • The way to achieve this is to create a new source and then a new flow with the particular breakdown (for example, source and flow with daily breakdowns/synchronizations)

Read more about the metrics and why the data may not be matching here.

Multi-account Extraction

Dataddo's Facebook Ads connector supports automatic extraction from all available Facebook Ads accounts. This feature is particularly useful when you have multiple ads accounts and need to automatically extract the same metrics and dimensions from all ads accounts.

Using Audience Breakdowns

Dataddo's Facebook Ads connector allows the use of both demographic and geographical dimensions to break down the metrics according to the audience categories. Because the underlying calculations for these dimensions are based on data samples, we highly recommend isolating them into separate data sources. Due to the calculation mechanism, the data with the audience dimensions are proportionally correct, however, the absolute values may be distorted.

Facebook Ads API limits historic data loads to 90 days. For historic data beyond 90 days, change the date range for each load and load in batches of 90 days. For more information, on how to load the data, check our guide.

Facebook Ads API limits the total historical data load to the last 36 months.

How to create a Facebook Ads Data Source

  1. Sign in to your Dataddo account and click on Sources at the top of the page.
  2. Click on Create Source in the top right corner.
  3. Choose the connector you would like to extract data from.
  4. From the drop-down menu, choose your Facebook Account connected to Dataddo or authorize your account. Select the Ads Account, Campaign, and Ad Set. Click on Next to continue with the setup.

Didn't find your account?
If you want to connect a new account that is not on the list, click on Add New Account at the bottom of the drop-down. You will be redirected to the authorization/sign-in page to confirm the right account. Once you confirm, you will be redirected back to the Dataddo app.

Facebook Ads - step 4a
5. Change the name of your data source at the top of the screen. Then, select the metricsdimensions, and the data labels.
Facebook Ads - metrics
1. You can only select 200 metrics per source.
2. Attributes depend on the reporting level you select.
3. The reporting level is a hierarchy-type report:
* 1st level - Account 
* 2nd level - Campaign
* 3rd level - Adset
* 4th level - Ad
* NOTE: More details can be found here

  1. The next page is optional. You can select the time increment, breakdowns, attribution window, action report time, and advanced filtering.
    :::(Warning) CAUTION: Unless you already know what you're doing, we recommend skipping this step and keeping the preselected values.
CAUTION: We recommend skipping this step and keeping the preselected values.
  • Time breakdown (Daily, 7 days, Monthly, or None)
  • Optional breakdown, max 3 (reports broken down by Age, Gender, Platform Device, etc.)
  • Attribution window (7 day click, 1 day view)
  • Action Report Time (On conversion date, On impression date)
  • Advanced filtering (if you choose yes, the filter statement window will dropdown)

Facebook Ads - account
7. Select the frequency that your data will be extracted. We recommend selecting Daily.
8. If you would like to configure the advanced settings, you may choose your date range and time. However, we recommend you use the default settings.
NOTE: If the date range is available to select, you can load historical data. Read more in our guide.
9. Before saving the source, preview your data by clicking on the Test Data button. Adjust the date range to see a more specific range of data.
Data source - create - preview{height="" width=""}
10. Click on Save and your new Data Source is ready.

Congratulations, your new data source is ready!


Broken View / Error Message

If you cannot see a preview of your data, go back a few steps and check your setup. The most common causes are:

  • Date range: We recommend a smaller date range. If you need to load historical data, check our guide.
  • Invalid metrics, attributes, or breakdowns: You may not have any data for the selected metrics, attributes, or breakdowns.
  • Combination of metrics, attributes, or breakdowns: The combination you have selected cannot be queried together. Please refer to the service's documentation to view a full list of which metrics can be included in the same source.
    Data source -create- error

Authorization Error

If your Facebook Ads source is broken, you can look into the log for an error.

  1. Go to Sources , click on the three dosts and choose Test Extraction.
  2. Look for the error below in the detail log:
"response_status": "401 Unauthorized"
"Www-Authenticate": "OAuth \"Facebook Platform\" \"invalid_token\" \"You cannot access the app till you log in to www.facebook.com and follow the instructions given.\""
"response_body": "{\"error\":{\"message\":\"You cannot access the app till you log in to www.facebook.com and follow the instructions given.\",\"type\":\"OAuthException\",\"code\":190,\"error_data\":\"{\\\"checkpoint_url\\\":\\\"https:\\\\\\/\\\\\\/www.facebook.com\\\"}\",\"error_subcode\":459,\"fbtrace_id\":\"AUWZQsg7Opr7SEpp_lk9wUa\"}}"
  1. Go to Connected Services to re-auhtorize the service (Facebook).
  2. Restart the broken sources by clicking on Manual Data Load icon next to the source.
    Facebook - authorization error log 1

Facebook - authorization error log 2

Facebook - authorization error log 3

Need assistance?

Feel free to contact us and we will help you with the setup. To speed the process of resolving your issue, make sure you provide us with sufficient information.

Was this article helpful?