Facebook Ads

Connector Overview

Automatic Data Synchronization

Our Facebook Ads connector gives you the ability to sync your data automatically in hourly, daily, weekly, or monthly increments.


When authorizing access, make sure that the user has the correct permissions. To access the Ads account data, the user has to have assigned MANAGE permission. However, the best practice is to create a dedicated System user within the Business Manager. Check the Facebook tutorial for further details.

Available Metrics

Dataddo can extract all the metrics provided via an 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. Dataddo supports automatic pagination, so the data extraction is in fact distributed into multiple rows.

Metric 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 again, these weekly/monthly values will match Facebook exactly. 

Multi-account extraction

Dataddo Facebook Ads connector supports automatic extraction from all the available Facebook Ads accounts. This feature is particularly useful when you have multiple accounts (e.g. online agencies) and need to automatically extract the same metrics and dimensions across all of them.

Using Audience breakdowns

Our Facebook Ads connector allows the use of both demographic and geographical dimensions to break down the metrics according to the audience categories. Since the underlying calculations for these dimensions are based on data samples, when you plan to use these dimensions, 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.

How to create a Facebook Ads Data Source

Number 1

Sign in to your Dataddo account and click on Sources at the top of the page. Home Page - Data Source

Number 2

Click on Create Source in the top right corner.Data Sources - Create Source

Number 3 From the list of sources, choose Facebook Ads. You can type Facebook into the search bar to find the connector faster.
Facebook Ads - step 3
Number 4 Choose the Facebook Account, Ads account, Campaign, and Ad set you want to connect and click on Next. Facebook Ads - step 4
a) Add new account
If you want to connect a Facebook account, which is not on the list, click on Add Account. You will be redirected to Facebook to confirm the right account. Once you confirm, you will be redirected back to the Dataddo app.
Facebook Ads - step 4a
b) Authorize Facebook Ads Account
If you have not authorized your Facebook Ad Account with Dataddo, click on Authorize and you will be redirected to your account to log in.
Facebook Ads - step 4b
After you log in and give Dataddo the necessary permissions to access your data, you will get redirected back to the connector.
Facebook Ads - step 4c
Number 5

Choose a name for your Data Source, select the Reporting level, the Metrics, and the Attributes. To continue to the next page, click Next.

NOTE: Attributes depend on the reporting level you select.

TIP: The reporting level is a hierarchy-type report:

  • 1st level - Account 
  • 2nd level - Campaign
  • 3rd level - Adset
  • 4th level - Ad

More details can be found hereFacebook Ads - step 5
Facebook Ads - step 5a

Number 6

The next page is optional. Here you can establish the following parameters:

  • 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 drop down) 
CAUTION: Unless you already know what you’re doing, we recommend skipping this step and keeping the pre-selected values.
Facebook Ads - step 6
Number 7

On the snapshotting page, you can set up the destination configuration. To help you with the snapshot mapping, we make it easier for you to create a connection to the destination based on your preference.

  • a) Click on the option Dashboarding App if you want your data to connect to applications such as Google Data Studio, Power BI, or Tableau.
  • b) Click on the option Data Warehouse, if you want your data to be sent to warehouse storage, e.g., MySQL, Big Query or PostgreSQL.
Facebook Ads - step 7
Number 8

Configure your snapshotting preferences by choosing your Data range*, Sync type, Sync frequency, Time, and Timezone. Confirm your setup by clicking on Next.

NOTE: *If the Data range is available to select, you can load historical data. Read more about it in our guide.

Facebook Ads - step 8

Number 9 In the last step you can preview your data. Click on Save and your new Data Source is ready.
Facebook Ads - step 9 preview
* 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, attribute or breakdowns, or their combination - you may not have any values for them.
Facebook Ads - step 9 error

Congratulations, your new Data Source is ready!

To load historic data, make sure you divide the load into batches of 90 days, as it is a Facebook limit. for more information, how t load the data, check our guide.

Need assistance?

Feel free to contact us or create a ticket and we will help you setup the Data Source.