Facebook Ads

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


When authorizing an access, make sure that the user has a 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 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: https://developers.facebook.com/docs/marketing-api/insights/parameters/v5.0


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 (e.g. being an on-line agency) multiple accounts and need to automatically extract same metrics and dimensions across them.

Using daily breakdowns

Follow these two steps during filling your Facebook Ads connector form.

Step 6 in FB Ads connector

Pick the additional labels "Reporting date start" and "Reporting date stop" to be associated with each data row.

FB Ads 1


Step 8 in FB Ads connector

In the "Optional settings" field breaks up the values by the selected time dimension. Select "Daily" and you will get one result set for each day in the given period.

FB Ads 2


Using Audience breakdowns

Facebook Ads connector allows using both demographic and geographic 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 to isolate them into separate data sources. Because of the calculation mechanism, the data with the audience dimensions are proportionally correct, however, the absolute values might get distorted.