Facebook Marketing

Overview

Features

Feature Name	Supported
Full Import	Yes
Incremental Import	Yes
Start Date Selection	Yes
Change data capture	Yes

Supported streams

List of supported streams:

Prebuilt Facebook Ad Insights Reports:

Stream	Breakdowns	Action Breakdowns
Ad Insights Action Carousel Card	---	`action_carousel_card_id`, `action_carousel_card_name`
Ad Insights Action Conversion Device	`device_platform`	`action_type`
Ad Insights Action Product ID	`product_id`	---
Ad Insights Action Reaction	---	`action_reaction`
Ad Insights Action Video Sound	---	`action_video_sound`
Ad Insights Action Video Type	---	`action_video_type`
Ad Insights Action Type	---	`action_type`
Ad Insights Age And Gender	`age`, `gender`	`action_type`, `action_target_id`, `action_destination`
Ad Insights Delivery Device	`device_platform`	`action_type`
Ad Insights Delivery Platform	`publisher_platform`	`action_type`
Ad Insights Delivery Platform And Device Platform	`publisher_platform`, `device_platform`	`action_type`
Ad Insights Demographics Age	`age`	`action_type`
Ad Insights Demographics Country	`country`	`action_type`
Ad Insights Demographics DMA Region	`dma`	`action_type`
Ad Insights Demographics Gender	`gender`	`action_type`
Ad Insights DMA	`dma`	`action_type`, `action_target_id`, `action_destination`
Ad Insights Country	`country`	`action_type`, `action_target_id`, `action_destination`
Ad Insights Platform And Device	`publisher_platform`, `platform_position`, `impression_device`	`action_type`
Ad Insights Region	`region`	`action_type`, `action_target_id`, `action_destination`

Getting started

Requirements and prerequisites

A Facebook Ad Account ID (opens in a new tab)
The credentials of your Facebook account with permission to access your ads account

Set up guide

Create a new source, select Facebook Merketing (Airbyte) from the Source type dropdown and enter a name for it.
On the source setup page, create a new Facebook Merketing secret, enter a unique name for it.
For Account ID, enter the Facebook Ad Account ID Number (opens in a new tab) to use when pulling data from the Facebook Marketing API. To find this ID, open your Meta Ads Manager. The Ad Account ID number can be found in the Account dropdown menu, or in your browser's address bar. Refer to the Facebook docs (opens in a new tab) for more information.
Select a Start date.
(Optional) Toggle the Include Deleted Campaigns, Ads, and AdSets button to include data from deleted Campaigns, Ads, and AdSets.
(Optional) Toggle the Fetch Thumbnail Images button to fetch the thumbnail_url and store the result in thumbnail_data_url for each Ad Creative (opens in a new tab).
(Optional) For Page Size of Requests, you can specify the number of records per page for paginated responses. Most users do not need to set this field unless specific issues arise or there are unique use cases that require tuning the connector's settings. The default value is set to retrieve 100 records per page.
(Optional) For Insights Window Lookback, you may set a window in days to revisit data during syncing to capture updated conversion data from the API. Facebook allows for attribution windows of up to 28 days, during which time a conversion can be attributed to an ad. If you have set a custom attribution window in your Facebook account, please set the same value here. Otherwise, you may leave it at the default value of 28. For more information on action attributions, please refer to the Meta Help Center (opens in a new tab).

Limitations

Insight tables are only able to pull data from the last 37 months. If you are syncing insight tables and your start date is older than 37 months, your sync will fail.
If Start Date is not set then all data will be replicated for usual streams and only last 2 years for insight streams.
The Facebook Marketing API does not have a concept of deleting records in the same way that a database does. While you can archive or delete an ad campaign, the API maintains a record of the campaign. Toggling the Include Deleted button lets you replicate records for campaigns or ads even if they were archived or deleted from the Facebook platform.
CustomAudiences (opens in a new tab) stream can cause the rule field to not be synced for all records because it caused the error message Please reduce the amount of data.... Please limit the record number by changing start date to reduce the number of ingested records.
The Facebook Marketing connector uses the lookback_window parameter to repeatedly read data from the last <lookback_window> days during an Incremental sync. This means some data will be synced twice (or possibly more often) despite the cursor value being up to date, in order to capture updated ads conversion data from Facebook. You can change this date window by adjusting the lookback_window parameter when setting up the source, up to a maximum of 28 days. Smaller values will result in fewer duplicates, while larger values provide more accurate results. For a deeper understanding of the purpose and role of the attribution window, refer to this Meta article (opens in a new tab).

BigQuery Faker