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
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.
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.
Then click on New Sources from the top right corner.
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.
Having a problem with the authorization process?
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
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.
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.