Facebook Ads source for ELT & CDC


Description	With a few clicks, you can run ads across Facebook, Instagram, Audience Network and Messenger.
Supported Replication	Initial Sync, Continuous Sync
Authentication Type	OAuth

Collections

Collection Name	Full/ Initial Sync	Incremental/ Continuous Sync	Supports Update	Supports Delete	Notes
Ad creatives https://developers.facebook.com/docs/marketing-api/reference/ad-creative	✔	✖	✔	✖	•
Ads https://developers.facebook.com/docs/marketing-api/reference/adgroup	✔	✔	✖	✖
Ads insights https://developers.facebook.com/docs/marketing-api/reference/adgroup/insights	✔	✔	✖	✖	“breakdowns”: []
Ads insights by age and gender https://developers.facebook.com/docs/marketing-api/reference/adgroup/insights	✔	✔	✖	✖	“breakdowns”: [‘age’, ‘gender’]
Ads insights by country https://developers.facebook.com/docs/marketing-api/reference/adgroup/insights	✔	✔	✖	✖	“breakdowns”: [‘country’]
Ads insights by dma https://developers.facebook.com/docs/marketing-api/reference/adgroup/insights	✔	✔	✖	✖	“breakdowns”: [‘dma’]
Ads insights by hourly advertiser https://developers.facebook.com/docs/marketing-api/reference/adgroup/insights	✔	✔	✖	✖	‘breakdowns’: [‘hourly_stats_aggregated_by_advertiser_time_zone’]
Ads insights by platform and device https://developers.facebook.com/docs/marketing-api/reference/adgroup/insights	✔	✔	✖	✖	“breakdowns”: [‘publisher_platform’, ‘platform_position’, ‘impression_device’]
Ads insights by region https://developers.facebook.com/docs/marketing-api/reference/adgroup/insights	✔	✔	✖	✖	‘breakdowns’: [‘region’]
Ad sets https://developers.facebook.com/docs/marketing-api/reference/ad-campaign	✔	✔	✖	✖
Campaigns https://developers.facebook.com/docs/marketing-api/reference/ad-campaign-group	✔	✔	✖	✖
Leads https://developers.facebook.com/docs/marketing-api/guides/lead-ads/	✔	✔	✖	✖

Deleted records

Syncs from Facebook Ads include records with a DELETED status. Deleted ads, ad sets, and campaigns land in your destination alongside active records so you retain historical reporting after items are removed in Facebook Ads Manager. Filter on the status field in your warehouse to exclude deleted records from downstream queries.

Historical Window

Facebook’s historical data availability varies by data type:

Data Type	Historical Window
Standard total metrics	37 months
Unique-count metrics (such as unique clicks)	13 months
Hourly breakdowns	13 months
Reach with breakdowns	~13 months (about 394 days)
Frequency breakdowns	6 months

Data Lookback

Lookback Window
28 days

Setting up Facebook Ads for ELT & CDC

Overview

ELT & CDC uses the Marketing API provided by Facebook to sync the data. Facebook Marketing API reference

Requirements

You need to authenticate using OAuth.
Sign In and Authenticate.

Getting Started

Pipelines

Sources

Destinations

Monitoring

Security

Transforms

Data Observability

Facebook Ads source for ELT & CDC

Collections

Deleted records

Historical Window

Data Lookback

Setting up Facebook Ads for ELT & CDC

Overview

Requirements

​Collections

​Deleted records

​Historical Window

​Data Lookback

​Setting up Facebook Ads for ELT & CDC

​Overview

​Requirements

Collections

Deleted records

Historical Window

Data Lookback

Setting up Facebook Ads for ELT & CDC

Overview

Requirements