Facebook Ads

Dataddo's Facebook Ads connector enables simple API data extraction without writing a single line of code.

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. Please check the following tutorial for further details: https://developers.facebook.com/docs/marketing-api/business-manager/system-user

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.

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 using 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, 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. 

Creating a Facebook Ads Data Source

To create a Facebook Ads data source, navigate to Sources at the top left of the Dataddo app.

Top Bar Marked-png-1

Then click on New Sources from the top right corner.

Source Selection Page-png-1

From the list of connectors, choose the Facebook Ads connector.


On the next page, you will need to give Dataddo authorization to connect with your Facebook Ads account. Once you click on Authorize, you will be redirected to your account to log in.

configure account

Having a problem with the authorization process?

You can contact us or create a ticket and we will add it for you if possible

After you log in and give Dataddo the necessary permissions to access your data, you will get redirected back to the connector. If you happen to have more Facebook accounts connected to Dataddo, you can select the one you would like to use from the drop-down menu. You will have to select also in drop-down menus the Ads Account, the Campaign, and the Ad set.


Next, you can name your data source, and select the Reporting level, the Metrics, and the Attributes.

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 here


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

  • Time breakdown (Daily, Weekly and Monthly Reports)
  • Optional breakdown (Like reports broken down by Age, Gender, Platform Device, etc)
  • Advanced filtering (including Attribution window, Action report time) These parameters are for advanced uses. If you are using our application for the first time, we suggest you skip these selections


Need assistance?

Feel free to contact us or create a ticket and we will help with the creation of your preferred source

On the snapshotting page, you will 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.

  • Click on the option "Dashboarding App" if you want your data to connect to applications, like Google Data Studio, Power BI, or Tableau.
  • Click on the option "Data Warehouse", If you want your data to be sent to warehouse storage, like MySQL, Big Query, or PostgreSQL.
  • If you are already experienced with the snapshotting setup, you can go ahead and process without selecting the two options.

snapshotting options

Lastly, configure your snapshotting preferences by choosing your Data range (if available), Snapshotting frequency, and Snapshotting retention. 

snapshotting configuration

Now you are all set and ready. Click on See Preview to review all the selections made by you before saving the Data Source using the button in the top right corner Save source.


Visual Example