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.
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 matchThe 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.
- One option is to get the daily breakdown and then the daily values will match, but not when summing over more days.
- The second solution is to get the data weekly or monthly and again, these weekly/monthly values will match Facebook exactly.
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
Sign in to your Dataddo account and click on Sources at the top of the page.
Click on Create Source in the top right corner.
|From the list of sources, choose Facebook Ads. You can type Facebook into the search bar to find the connector faster.
|Choose the Facebook Account, Ads account, Campaign, and Ad set you want to connect and click on Next.|
|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.
|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.
After you log in and give Dataddo the necessary permissions to access your data, you will get redirected back to the connector.
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:
More details can be found here
The next page is optional. Here you can establish the following parameters:
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.
NOTE: *If the Data range is available to select, you can load historical data. Read more about it in our guide.
|In the last step you can preview your data. Click on Save and 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:
Congratulations, your new Data Source is ready!