Facebook Ads

Generally AvailableETL Sources

Extract data from applications, files, databases, and events.

Features

Feature Name	Supported	Notes
OAuth	✓	OAuth 2.0 authentication
Access Token	—
Full Refresh	✓	Complete data reload
Incremental Sync	✓	Only new/updated records
Distribution Stage	✓	Generally Available
Dynamic Streams	—
Start Date	—
Column Hashing	—

Sync Overview

Total Streams: 113
Parent Streams: 34
Sub-Streams: 79
Supported Sync Modes: Full Refresh, Incremental

Available Streams

account_history (Full Refresh, Incremental)
- custom_conversion_history
- reach_frequency
ACTION_CANVAS_COMPONENT (Full Refresh, Incremental)
- ACTION_CANVAS_COMPONENT_website_purchase_roas
ACTION_CAROUSEL_CARD (Full Refresh, Incremental)
- ACTION_CAROUSEL_CARD_website_purchase_roas
ACTION_CONVERSION_DEVICE (Full Refresh, Incremental)
- ACTION_CONVERSION_DEVICE_website_purchase_roas
ACTION_PRODUCT_ID (Full Refresh, Incremental)
- ACTION_PRODUCT_ID_website_purchase_roas
ACTION_REACTIONS (Full Refresh, Incremental)
- ACTION_REACTIONS_action_values
- ACTION_REACTIONS_actions
ACTION_VIDEO_SOUND (Full Refresh, Incremental)
- ACTION_VIDEO_SOUND_video_30_sec_watched_actions
- ACTION_VIDEO_SOUND_video_avg_time_watched_actions
- ACTION_VIDEO_SOUND_video_p100_watched_actions
- ACTION_VIDEO_SOUND_video_p25_watched_actions
- ACTION_VIDEO_SOUND_video_p50_watched_actions
- ACTION_VIDEO_SOUND_video_p75_watched_actions
- ACTION_VIDEO_SOUND_video_thruplay_watched_actions
ACTION_VIDEO_VIEW_TYPE (Full Refresh, Incremental)
- ACTION_VIDEO_VIEW_TYPE_video_30_sec_watched_actions
- ACTION_VIDEO_VIEW_TYPE_video_avg_time_watched_actions
- ACTION_VIDEO_VIEW_TYPE_video_p100_watched_actions
- ACTION_VIDEO_VIEW_TYPE_video_p25_watched_actions
- ACTION_VIDEO_VIEW_TYPE_video_p50_watched_actions
- ACTION_VIDEO_VIEW_TYPE_video_p75_watched_actions
- ACTION_VIDEO_VIEW_TYPE_video_thruplay_watched_actions
ad (Full Refresh, Incremental)
- ad_ad_label
- ad_recommendation
ad_history (Full Refresh, Incremental)
- ad_conversion
- ad_tracking
ad_image (Full Refresh, Incremental)
- ad_image_creative
ad_image_history (Full Refresh, Incremental)
ad_set (Full Refresh, Incremental)
- ad_set_ad_label
ad_set_history (Full Refresh, Incremental)
- ad_campaign_issues_info
- ad_set_custom_audience
- pacing_type
- targeting_optimization_types
ad_video_history (Full Refresh, Incremental)
- ad_video_thumbnail
BASIC_AD (Full Refresh, Incremental)
- BASIC_AD_actions
- BASIC_AD_cost_per_action_type
BASIC_AD_SET (Full Refresh, Incremental)
- BASIC_AD_SET_actions
- BASIC_AD_SET_cost_per_action_type
BASIC_ALL_LEVELS (Full Refresh, Incremental)
- BASIC_ALL_LEVELS_actions
- BASIC_ALL_LEVELS_cost_per_action_type
BASIC_CAMPAIGN (Full Refresh, Incremental)
- BASIC_CAMPAIGN_actions
- BASIC_CAMPAIGN_cost_per_action_type
campaign (Full Refresh, Incremental)
- campaign_ad_label
- campaign_issue_info
campaign_history (Full Refresh, Incremental)
creative_history (Incremental, Full Refresh)
- ad_asset_feed_spec_ad_format
- ad_asset_feed_spec_asset_customization_rule
- ad_asset_feed_spec_autotranslate
- ad_asset_feed_spec_body
- ad_asset_feed_spec_call_to_action
- ad_asset_feed_spec_caption
- ad_asset_feed_spec_description
- ad_asset_feed_spec_event
- ad_asset_feed_spec_group_rule
- ad_asset_feed_spec_image
- ad_asset_feed_spec_link_url
- ad_asset_feed_spec_message_extension
- ad_asset_feed_spec_title
- ad_asset_feed_spec_video
- creative_label
custom_audience_history (Full Refresh, Incremental)
- lookalike_origin
- lookalike_target_country
DELIVERY_DEVICE (Full Refresh, Incremental)
- DELIVERY_DEVICE_actions
- DELIVERY_DEVICE_cost_per_action_type
DELIVERY_PLATFORM (Full Refresh, Incremental)
- DELIVERY_PLATFORM_actions
- DELIVERY_PLATFORM_cost_per_action_type
DELIVERY_PLATFORM_AND_DEVICE (Full Refresh, Incremental)
- DELIVERY_PLATFORM_AND_DEVICE_actions
- DELIVERY_PLATFORM_AND_DEVICE_cost_per_action_type
DELIVERY_PURCHASE_ROAS (Full Refresh, Incremental)
- DELIVERY_PURCHASE_ROAS_website_purchase_roas
DEMOGRAPHICS_AGE (Full Refresh, Incremental)
- DEMOGRAPHICS_AGE_actions
- DEMOGRAPHICS_AGE_cost_per_action_type
DEMOGRAPHICS_AGE_AND_GENDER (Full Refresh, Incremental)
- DEMOGRAPHICS_AGE_AND_GENDER_actions
- DEMOGRAPHICS_AGE_AND_GENDER_cost_per_action_type
DEMOGRAPHICS_COMSCORE_MARKET (Full Refresh, Incremental)
- DEMOGRAPHICS_COMSCORE_MARKET_actions
- DEMOGRAPHICS_COMSCORE_MARKET_cost_per_action_type
DEMOGRAPHICS_COUNTRY (Full Refresh, Incremental)
- DEMOGRAPHICS_COUNTRY_actions
- DEMOGRAPHICS_COUNTRY_cost_per_action_type
DEMOGRAPHICS_GENDER (Full Refresh, Incremental)
- DEMOGRAPHICS_GENDER_actions
- DEMOGRAPHICS_GENDER_cost_per_action_type
DEMOGRAPHICS_REGION (Full Refresh, Incremental)
- DEMOGRAPHICS_REGION_actions
- DEMOGRAPHICS_REGION_cost_per_action_type
MARKETING_MIX_MODELING (Full Refresh, Incremental)

Next Steps

Setup Guide — Learn how to connect Facebook Ads
API Configuration — View schema and API details
Release Notes — See recent changes