Facebook

Facebook

Generally AvailableETL Sources

Extract data from this source and load it into your data warehouse.

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: 128
• Parent Streams: 34
• Sub-Streams: 94
• 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_creative (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
  • ad_creative_ad_label
• 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 (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_COUNTRY (Full Refresh, Incremental)
  • DEMOGRAPHICS_COUNTRY_actions
  • DEMOGRAPHICS_COUNTRY_cost_per_action_type
• DEMOGRAPHICS_DMA_REGION (Full Refresh, Incremental)
  • DEMOGRAPHICS_DMA_REGION_actions
  • DEMOGRAPHICS_DMA_REGION_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

Next Steps

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