Facebook Ads - Schema Information
Discover everything you need to know about schema information for Facebook Ads, including how to optimize your ad campaigns for success.
Facebook Ads - Schema Information
Discover everything you need to know about schema information for Facebook Ads, including how to optimize your ad campaigns for success.
adinsights
Purpose:
Contains aggregated ad performance metrics (impressions, clicks, spend, reach, etc.) for campaigns, ad sets, and ads. Use this table for campaign analytics and reporting.
Source API Documentation:
link
Replication:
Key-Based Replication
Replication Key: lastRunDate
Fields:
| Name | Type |
|---|---|
| account_currency | STRING |
| account_id | STRING |
| account_name | STRING |
| actions | RECORD |
| action_values | RECORD |
| ad_id | STRING |
| ad_name | STRING |
| adset_id | STRING |
| adset_name | STRING |
| buying_type | STRING |
| campaign_id | STRING |
| campaign_name | STRING |
| canvas_avg_view_percent | NUMERIC |
| clicks | NUMERIC |
| cost_per_estimated_ad_recallers | NUMERIC |
| cost_per_inline_link_click | NUMERIC |
| cost_per_inline_post_engagement | NUMERIC |
| cost_per_unique_click | NUMERIC |
| cost_per_unique_inline_link_click | NUMERIC |
| conversion_values | RECORD |
| cpc | NUMERIC |
| cpm | NUMERIC |
| cpp | NUMERIC |
| ctr | NUMERIC |
| date_start | STRING |
| date_stop | STRING |
| estimated_ad_recall_rate | NUMERIC |
| estimated_ad_recallers | NUMERIC |
| frequency | NUMERIC |
| impressions | NUMERIC |
| inline_link_clicks | NUMERIC |
| inline_post_engagement | NUMERIC |
| objective | STRING |
| reach | NUMERIC |
| social_spend | NUMERIC |
| spend | NUMERIC |
| unique_clicks | NUMERIC |
| unique_ctr | NUMERIC |
| unique_inline_link_click_ctr | NUMERIC |
| unique_inline_link_clicks | NUMERIC |
| video_30_sec_watched_actions | RECORD |
| video_p25_watched_actions | RECORD |
| video_p50_watched_actions | RECORD |
| video_p75_watched_actions | RECORD |
| video_p95_watched_actions | RECORD |
| video_p100_watched_actions | RECORD |
| video_avg_time_watched_actions | RECORD |
| video_play_actions | RECORD |
| website_ctr | RECORD |
| outbound_clicks | RECORD |
| website_purchase_roas | RECORD |
| cost_per_thruplay | RECORD |
| video_thruplay_watched_actions | RECORD |
adinsights_breakdown_country
Purpose:
Contains ad performance metrics broken down by country, enabling geographic analysis of campaign results.
Source API Documentation:
link
Replication:
Key-Based Replication
Replication Key: lastRunDate
Fields:
| Name | Type |
|---|---|
| account_currency | STRING |
| account_id | STRING |
| account_name | STRING |
| actions | RECORD |
| action_values | RECORD |
| ad_id | STRING |
| ad_name | STRING |
| adset_id | STRING |
| adset_name | STRING |
| buying_type | STRING |
| campaign_id | STRING |
| campaign_name | STRING |
| canvas_avg_view_percent | NUMERIC |
| clicks | NUMERIC |
| cost_per_estimated_ad_recallers | NUMERIC |
| cost_per_inline_link_click | NUMERIC |
| cost_per_inline_post_engagement | NUMERIC |
| cost_per_unique_click | NUMERIC |
| cost_per_unique_inline_link_click | NUMERIC |
| conversion_values | RECORD |
| cpc | NUMERIC |
| cpm | NUMERIC |
| cpp | NUMERIC |
| ctr | NUMERIC |
| date_start | STRING |
| date_stop | STRING |
| estimated_ad_recall_rate | NUMERIC |
| estimated_ad_recallers | NUMERIC |
| frequency | NUMERIC |
| impressions | NUMERIC |
| inline_link_clicks | NUMERIC |
| inline_post_engagement | NUMERIC |
| objective | STRING |
| country | STRING |
| reach | NUMERIC |
| social_spend | NUMERIC |
| spend | NUMERIC |
| unique_clicks | NUMERIC |
| unique_ctr | NUMERIC |
| unique_inline_link_click_ctr | NUMERIC |
| unique_inline_link_clicks | NUMERIC |
| video_30_sec_watched_actions | RECORD |
| video_p25_watched_actions | RECORD |
| video_p50_watched_actions | RECORD |
| video_p75_watched_actions | RECORD |
| video_p95_watched_actions | RECORD |
| video_p100_watched_actions | RECORD |
| video_avg_time_watched_actions | RECORD |
| video_play_actions | RECORD |
| website_ctr | RECORD |
| outbound_clicks | RECORD |
| website_purchase_roas | RECORD |
| cost_per_thruplay | RECORD |
| video_thruplay_watched_actions | RECORD |
adinsights_breakdown_product_id
Purpose:
Contains ad performance metrics broken down by product ID, supporting analysis of dynamic product ads and catalog sales.
Source API Documentation:
link
Replication:
Key-Based Replication
Replication Key: lastRunDate
Fields:
| Name | Type |
|---|---|
| account_currency | STRING |
| account_id | STRING |
| account_name | STRING |
| actions | RECORD |
| action_values | RECORD |
| ad_id | STRING |
| ad_name | STRING |
| adset_id | STRING |
| adset_name | STRING |
| buying_type | STRING |
| campaign_id | STRING |
| campaign_name | STRING |
| canvas_avg_view_percent | NUMERIC |
| clicks | NUMERIC |
| cost_per_estimated_ad_recallers | NUMERIC |
| cost_per_inline_link_click | NUMERIC |
| cost_per_inline_post_engagement | NUMERIC |
| cost_per_unique_click | NUMERIC |
| cost_per_unique_inline_link_click | NUMERIC |
| conversion_values | RECORD |
| cpc | NUMERIC |
| cpm | NUMERIC |
| cpp | NUMERIC |
| ctr | NUMERIC |
| date_start | STRING |
| date_stop | STRING |
| estimated_ad_recall_rate | NUMERIC |
| estimated_ad_recallers | NUMERIC |
| frequency | NUMERIC |
| impressions | NUMERIC |
| inline_link_clicks | NUMERIC |
| inline_post_engagement | NUMERIC |
| objective | STRING |
| product_id | STRING |
| converted_product_quantity | RECORD |
| converted_product_value | RECORD |
| reach | NUMERIC |
| social_spend | NUMERIC |
| spend | NUMERIC |
| unique_clicks | NUMERIC |
| unique_ctr | NUMERIC |
| unique_inline_link_click_ctr | NUMERIC |
| unique_inline_link_clicks | NUMERIC |
| video_30_sec_watched_actions | RECORD |
| video_p25_watched_actions | RECORD |
| video_p50_watched_actions | RECORD |
| video_p75_watched_actions | RECORD |
| video_p95_watched_actions | RECORD |
| video_p100_watched_actions | RECORD |
| video_avg_time_watched_actions | RECORD |
| video_play_actions | RECORD |
| website_ctr | RECORD |
| outbound_clicks | RECORD |
| website_purchase_roas | RECORD |
| cost_per_thruplay | RECORD |
| video_thruplay_watched_actions | RECORD |
adinsights_breakdown_region
Purpose:
Contains ad performance metrics broken down by region, enabling sub-country geographic analysis.
Source API Documentation:
link
Replication:
Key-Based Replication
Replication Key: lastRunDate
Fields:
(Fields are the same as adinsights_breakdown_country except with region instead of country)
| Name | Type |
|---|---|
| ... | ... |
| region | STRING |
| ... | ... |
adinsights_breakdown_publisher_platform
Purpose:
Contains ad performance metrics broken down by publisher platform (e.g., Facebook, Instagram, Audience Network, Messenger).
Source API Documentation:
link
Replication:
Key-Based Replication
Replication Key: lastRunDate
Fields:
(Fields are the same as adinsights_breakdown_country except with publisher_platform instead of country)
| Name | Type |
|---|---|
| ... | ... |
| publisher_platform | STRING |
| ... | ... |
adinsights_breakdown_publisher_platform_position
Purpose:
Contains ad performance metrics broken down by both publisher platform and platform position (e.g., Facebook feed, Instagram stories).
Source API Documentation:
link
Replication:
Key-Based Replication
Replication Key: lastRunDate
Fields:
(Fields are the same as adinsights_breakdown_country except with publisher_platform and platform_position instead of country)
| Name | Type |
|---|---|
| ... | ... |
| publisher_platform | STRING |
| platform_position | STRING |
| ... | ... |
adinsights_breakdown_gender
Purpose:
Contains ad performance metrics broken down by gender, supporting demographic analysis.
Source API Documentation:
link
Replication:
Key-Based Replication
Replication Key: lastRunDate
Fields:
(Fields are the same as adinsights_breakdown_country except with gender instead of country)
| Name | Type |
|---|---|
| ... | ... |
| gender | STRING |
| ... | ... |
adinsights_breakdown_gender_age
Purpose:
Contains ad performance metrics broken down by both gender and age, enabling detailed demographic analysis.
Source API Documentation:
link
Replication:
Key-Based Replication
Replication Key: lastRunDate
Fields:
(Fields are the same as adinsights_breakdown_country except with gender and age instead of country)
| Name | Type |
|---|---|
| ... | ... |
| gender | STRING |
| age | STRING |
| ... | ... |
adinsights_breakdown_device_platform
Purpose:
Contains ad performance metrics broken down by device platform (e.g., mobile, desktop), supporting device-specific campaign optimization.
Source API Documentation:
link
Replication:
Key-Based Replication
Replication Key: lastRunDate
Fields:
(Fields are the same as adinsights_breakdown_country except with device_platform instead of country)
| Name | Type |
|---|---|
| ... | ... |
| device_platform | STRING |
| ... | ... |
ads
Purpose:
Stores details for each ad, including configuration, creative, status, and associated assets.
Source API Documentation:
link
Replication:
Key-Based Replication
Replication Key: lastRunRecordDate
Fields:
| Name | Type |
|---|---|
| id | STRING |
| account_id | STRING |
| adlabels | RECORD |
| adset_id | STRING |
| bid_amount | NUMERIC |
| campaign_id | STRING |
| configured_status | STRING |
| created_time | STRING |
| creative | RECORD |
| effective_status | STRING |
| last_updated_by_app_id | STRING |
| name | STRING |
| recommendations | RECORD |
| source_ad_id | STRING |
| status | STRING |
| tracking_specs | RECORD |
| updated_time | STRING |
adsets
Purpose:
Represents a group of ads with shared budget, schedule, bid strategy, and targeting.
Source API Documentation:
link
Replication:
Key-Based Replication
Primary Key: id
Fields:
| Name | Type |
|---|---|
| id | STRING |
| name | STRING |
| account_id | STRING |
| campaign_id | STRING |
| daily_budget | NUMERIC |
| lifetime_budget | STRING |
| bid_strategy | STRING |
| bid_amount | NUMERIC |
| configured_status | STRING |
| effective_status | STRING |
| status | STRING |
| pacing_type | STRING |
| optimization_goal | STRING |
| billing_event | STRING |
| promoted_object | STRING |
| targeting | STRING |
| created_time | STRING |
| start_time | STRING |
| end_time | STRING |
campaigns
Purpose:
Contains campaign-level details such as objective, status, and spend cap.
Source API Documentation:
link
Replication:
Key-Based Replication
Replication Key: lastRunRecordDate
Fields:
| Name | Type |
|---|---|
| id | STRING |
| account_id | STRING |
| adlabels | RECORD |
| name | STRING |
| objective | STRING |
| spend_cap | NUMERIC |
| status | STRING |
| buying_type | STRING |
| created_time | STRING |
| updated_time | STRING |
adcreatives
Purpose:
Contains creative asset details for ads, such as images, videos, text, and call-to-action information.
Source API Documentation:
link
Replication:
Key-Based Replication
Replication Key: AdAccount
Fields:
| Name | Type |
|---|---|
| id | STRING |
| account_id | STRING |
| body | STRING |
| image_url | STRING |
| name | STRING |
| object_story_id | STRING |
| object_story_spec | RECORD |
| status | STRING |
| thumbnail_url | STRING |
| title | STRING |
| url_tags | STRING |
| video_id | STRING |
