Facebook Ads

Explore the interactive ERD

Table & Field Reference

lead

Column	Type	Keys
`id`	String	PK
`ad_id`	Long	FK
`adset_id`	Long	FK
`campaign_id`	Long	FK
`created_time`	Instant
`form_id`	String
`is_organic`	Boolean
`partner_name`	String
`platform`	String

label_history

Column	Type	Keys
`id`	Long	PK
`updated_time`	Instant	PK
`account_id`	Long	FK
`created_time`	Instant
`name`	String

ad_image_history

Column	Type	Keys
`hash`	String	PK
`id`	String	PK
`updated_time`	Instant	PK
`account_id`	Long	FK
`created_time`	Instant
`creatives`	Json
`height`	Long
`is_associated_creatives_in_adgroups`	Boolean
`name`	String
`original_height`	Long
`original_width`	Long
`permalink_url`	String
`status`	String
`url`	String
`url_128`	String
`width`	Long

ad_asset_feed_spec_video

Column	Type	Keys
`index`	Int	PK
`creative_id`	Long	PKFK
`adlabels`	Json
`caption_ids`	Json
`thumbnail_hash`	String
`thumbnail_url`	String
`url_tags`	String
`video_id`	String

ad_video_thumbnail

Column	Type	Keys
`id`	String	PK
`video_id`	String	FK
`height`	Long
`is_preferred`	Boolean
`name`	String
`scale`	Float
`uri`	String
`width`	Long

adset_schedule

Column	Type	Keys
`index`	Int	PK
`ad_set_id`	Long	PKFK
`ad_set_updated_time`	Instant	PKFK
`days`	Json
`end_minute`	Int
`start_minute`	Int
`timezone_type`	String

ad_conversion

Column	Type	Keys
`index`	Int	PK
`ad_id`	Long	PKFK
`ad_updated_time`	Instant	PKFK
`action_type`	Json
`application`	Json
`conversion_id`	Json
`creative`	Json
`dataset`	Json
`event`	Json
`event_creator`	Json
`event_type`	Json
`fb_pixel`	Json
`fb_pixel_event`	Json
`leadgen`	Json
`object`	Json
`object_domain`	Json
`offer`	Json
`offer_creator`	Json
`offsite_pixel`	Json
`page`	Json
`page_parent`	Json
`post`	Json
`post_object`	Json
`post_object_wall`	Json
`post_wall`	Json
`question`	Json
`question_creator`	Json
`response`	Json
`subtype`	Json

ad_study

Column	Type	Keys
`id`	Long	PK
`account_id`	Long	FK
`business_id`	Long
`canceled_time`	Instant
`cooldown_start_time`	Instant
`created_time`	Instant
`description`	String
`end_time`	Instant
`name`	String
`observation_end_time`	Instant
`results_first_available_date`	String
`start_time`	Instant
`type`	String
`updated_time`	Instant

performance_recommendation

Column	Type	Keys
`_fivetran_id`	String	PK
`account_id`	Long	PKFK
`object_id`	String
`recommendation_signature`	String
`type`	String

ad_campaign_issues_info

Column	Type	Keys
`index`	Int	PK
`ad_set_id`	Long	PKFK
`ad_set_updated_time`	Instant	PKFK
`error_code`	Int
`error_message`	String
`error_summary`	String
`error_type`	String
`level`	String

ad_asset_feed_spec_ad_format

Column	Type	Keys
`index`	Int	PK
`creative_id`	Long	PKFK
`name`	String

ad_asset_feed_spec_caption

Column	Type	Keys
`index`	Int	PK
`creative_id`	Long	PKFK
`adlabels`	Json
`text`	String
`url_tags`	String

lead_custom_disclaimer_response

Column	Type	Keys
`index`	Int	PK
`lead_id`	String	PKFK
`checkbox_key`	String
`is_checked`	Boolean
`title`	String

campaign_label

Column	Type	Keys
`ad_label_id`	Long	PKFK
`campaign_id`	Long	PKFK
`campaign_updated_time`	Instant	PKFK

reach_frequency

Column	Type	Keys
`country_code`	String	PK
`_fivetran_id`	String	PKFK
`account_id`	Long
`max_campaign_duration`	Long
`max_days_to_finish`	Long
`min_campaign_duration`	Long
`min_reach_limits`	Long

ad_rotation_interval

Column	Type	Keys
`index`	Int	PK
`ad_set_id`	Long	PKFK
`ad_set_updated_time`	Instant	PKFK
`date_range_start_time`	Long

ad_study_objective_result

Column	Type	Keys
`date`	LocalDate	PK
`cell_id`	Long	PKFK
`objective_id`	Long	PKFK

ad_asset_feed_spec_asset_customization_rule

Column	Type	Keys
`index`	Int	PK
`creative_id`	Long	PKFK
`body_label`	Json
`call_to_action_label`	Json
`call_to_action_type_label`	Json
`caption_label`	Json
`carousel_label`	Json
`customization_spec`	Json
`description_label`	Json
`image_label`	Json
`is_default`	Boolean
`link_url_label`	Json
`priority`	Int
`title_label`	Json
`video_label`	Json

ad_set_custom_audience

Column	Type	Keys
`ad_set_id`	Long	PKFK
`ad_set_updated_time`	Instant	PKFK
`custom_audience_id`	Long	PKFK
`is_excluded`	Boolean

targeting_optimization_types

Column	Type	Keys
`index`	Int	PK
`ad_set_id`	Long	PKFK
`ad_set_updated_time`	Instant	PKFK
`key`	String
`value`	Int

lookalike_target_country_name

Column	Type	Keys
`country_name`	String	PK
`custom_audience_id`	Long	PKFK
`custom_audience_updated_time`	Instant	PKFK

ad_asset_feed_spec_description

Column	Type	Keys
`index`	Int	PK
`creative_id`	Long	PKFK
`adlabels`	Json
`text`	String
`url_tags`	String

ad_asset_feed_spec_upcoming_event

Column	Type	Keys
`index`	Int	PK
`creative_id`	Long	PKFK
`end_time`	Instant
`event_id`	String
`event_title`	String
`start_time`	Instant
`updated_time`	Instant

ad_asset_feed_spec_onsite_destination

Column	Type	Keys
`index`	Int	PK
`creative_id`	Long	PKFK
`details_page_product_id`	Long
`shop_collection_product_set_id`	Long
`storefront_shop_id`	Long

ad_asset_feed_spec_image

Column	Type	Keys
`index`	Int	PK
`creative_id`	Long	PKFK
`adlabels`	Json
`hash`	String
`image_crops`	Json
`url`	String
`url_tags`	String

ad_set_history

Column	Type	Keys
`id`	Long	PK
`updated_time`	Instant	PK
`account_id`	Long	FK
`adset_source_id`	Long	FK
`campaign_id`	Long	FK
`asset_feed_id`	Long
`bid_amount`	Long
`bid_strategy`	String
`billing_event`	String
`budget_remaining`	Long
`configured_status`	String
`created_time`	Instant
`daily_budget`	Long
`daily_min_spend_target`	Long
`daily_spend_cap`	Long
`destination_type`	String
`effective_status`	String
`end_time`	Instant
`instagram_user_id`	Long
`is_dynamic_creative`	Boolean
`lifetime_budget`	Long
`lifetime_imps`	Int
`lifetime_min_spend_target`	Long
`lifetime_spend_cap`	Long
`multi_optimization_goal_weight`	String
`name`	String
`optimization_goal`	String
`optimization_sub_event`	String
`recurring_budget_semantics`	Boolean
`review_feedback`	String
`rf_prediction_id`	String
`start_time`	Instant
`status`	String
`use_new_app_click`	Boolean
`learning_stage_info_`
`promoted_object_`
`targeting_`

ad_asset_feed_spec_title

Column	Type	Keys
`index`	Int	PK
`creative_id`	Long	PKFK
`adlabels`	Json
`text`	String
`url_tags`	String

creative_history

Column	Type	Keys
`_fivetran_id`	String	PK
`id`	Long	PK
`account_id`	Long	FK
`actor_id`	Long
`applink_treatment`	String
`authorization_category`	String
`body`	String
`branded_content_sponsor_page_id`	Long
`bundle_folder_id`	Long
`call_to_action_type`	String
`carousel_ad_link`	String
`categorization_criteria`	String
`category_media_source`	String
`destination_set_id`	Long
`dynamic_ad_voice`	String
`effective_authorization_category`	String
`effective_instagram_media_id`	Long
`effective_object_story_id`	String
`enable_direct_install`	Boolean
`image_hash`	String
`image_url`	String
`instagram_permalink_url`	String
`instagram_user_id`	String
`link_destination_display_url`	String
`link_og_id`	Long
`link_url`	String
`name`	String
`object_id`	Long
`object_store_url`	String
`object_story_id`	String
`object_story_link_data_app_link_spec_android`	Json
`object_story_link_data_app_link_spec_ios`	Json
`object_story_link_data_app_link_spec_ipad`	Json
`object_story_link_data_app_link_spec_iphone`	Json
`object_story_link_data_caption`	String
`object_story_link_data_child_attachments`	Json
`object_story_link_data_description`	String
`object_story_link_data_link`	String
`object_story_link_data_message`	String
`object_type`	String
`object_url`	String
`page_link`	String
`page_message`	String
`place_page_set_id`	Long
`platform_customizations_instagram_caption_ids`	Json
`platform_customizations_instagram_image_hash`	String
`platform_customizations_instagram_image_url`	String
`platform_customizations_instagram_video_id`	Long
`playable_asset_id`	Long
`product_set_id`	Long
`source_instagram_media_id`	Long
`status`	String
`template_app_link_spec_android`	Json
`template_app_link_spec_ios`	Json
`template_app_link_spec_ipad`	Json
`template_app_link_spec_iphone`	Json
`template_caption`	String
`template_child_attachments`	Json
`template_description`	String
`template_link`	String
`template_message`	String
`template_page_link`	String
`template_url`	String
`thumbnail_id`	Long
`thumbnail_url`	String
`title`	String
`url_tags`	Json
`use_page_actor_override`	Boolean
`video_call_to_action_type`	String
`video_call_to_action_value_link`	String
`video_id`	Long
`video_image_hash`	String
`video_image_url`	String
`video_link_description`	String
`video_message`	String
`video_page_welcome_message`	String
`video_title`	String
`video_video_id`	Long
`asset_feed_spec_`
`template_url_spec_`

ad_history

Column	Type	Keys
`id`	Long	PK
`updated_time`	Instant	PK
`account_id`	Long	FK
`ad_set_id`	Long	FK
`ad_source_id`	Long	FK
`campaign_id`	Long	FK
`creative_id`	Long	FK
`bid_amount`	Int
`bid_type`	String
`configured_status`	String
`conversion_domain`	String
`created_time`	Instant
`effective_status`	String
`last_updated_by_app_id`	String
`name`	String
`preview_shareable_link`	String
`status`	String

ad_set_label

Column	Type	Keys
`ad_set_id`	Long	PKFK
`ad_set_updated_time`	Instant	PKFK
`label_id`	Long	PKFK

ad_asset_feed_spec_link_url

Column	Type	Keys
`index`	Int	PK
`creative_id`	Long	PKFK
`adlabels`	Json
`carousel_link_url`	String
`deeplink_url`	String
`display_url`	String
`object_store_urls`	Json
`url_tags`	String
`website_url`	String

ad_group_issues_info

Column	Type	Keys
`index`	Int	PK
`ad_id`	Long	PKFK
`ad_updated_time`	Instant	PKFK
`error_code`	Int
`error_message`	String
`error_summary`	String
`error_type`	String
`level`	String

creative_label

Column	Type	Keys
`creative_id`	Long	PKFK
`label_id`	Long	PKFK

ad_study_objective

Column	Type	Keys
`id`	Long	PK
`ad_study_id`	Long	FK
`is_primary`	Boolean
`name`	String
`type`	String

campaign_history

Column	Type	Keys
`id`	Long	PK
`updated_time`	Instant	PK
`account_id`	Long	FK
`source_campaign_id`	Long	FK
`bid_strategy`	String
`boosted_object_id`	Long
`budget_rebalance_flag`	Boolean
`budget_remaining`	Double
`buying_type`	String
`can_create_brand_lift_study`	Boolean
`can_use_spend_cap`	Boolean
`configured_status`	String
`created_time`	Instant
`daily_budget`	Long
`effective_status`	String
`is_skadnetwork_attribution`	Boolean
`last_budget_toggling_time`	Instant
`lifetime_budget`	Long
`name`	String
`objective`	String
`pacing_type`	Json
`smart_promotion_type`	String
`special_ad_categories`	Json
`special_ad_category`	String
`special_ad_category_country`	Json
`spend_cap`	Long
`start_time`	Instant
`status`	String
`stop_time`	Instant
`topline_id`	Long
`promoted_object_`

lead_field_data

Column	Type	Keys
`index`	Int	PK
`lead_id`	String	PKFK
`name`	String
`values`	Json

ad_study_cell

Column	Type	Keys
`id`	Long	PK
`ad_study_id`	Long	FK
`name`	String
`treatment_percentage`	Float

failed_delivery_checks

Column	Type	Keys
`index`	Int	PK
`_fivetran_id`	String	PKFK
`account_id`	Long
`check_name`	String
`description`	String
`summary`	String

ad_asset_feed_spec_body

Column	Type	Keys
`index`	Int	PK
`creative_id`	Long	PKFK
`adlabels`	Json
`text`	String
`url_tags`	String

ad_asset_feed_spec_event

Column	Type	Keys
`index`	Int	PK
`creative_id`	Long	PKFK
`id`	String

ad_recommendation

Column	Type	Keys
`index`	Int	PK
`ad_id`	Long	PKFK
`ad_updated_time`	Instant	PKFK
`blame_field`	String
`code`	Int
`confidence`	String
`importance`	String
`message`	String
`recommendation_data`	Json
`title`	String

ad_asset_feed_spec_call_to_action

Column	Type	Keys
`index`	Int	PK
`creative_id`	Long	PKFK
`adlabels`	Json
`type`	String
`value_`

ad_tracking

Column	Type	Keys
`index`	Int	PK
`ad_id`	Long	PKFK
`ad_updated_time`	Instant	PKFK
`action_type`	Json
`application`	Json
`conversion_id`	Json
`creative`	Json
`dataset`	Json
`event`	Json
`event_creator`	Json
`event_type`	Json
`fb_pixel`	Json
`fb_pixel_event`	Json
`leadgen`	Json
`object`	Json
`object_domain`	Json
`offer`	Json
`offer_creator`	Json
`offsite_pixel`	Json
`page`	Json
`page_parent`	Json
`post`	Json
`post_object`	Json
`post_object_wall`	Json
`post_wall`	Json
`question`	Json
`question_creator`	Json
`response`	Json
`subtype`	Json

ad_asset_feed_spec_autotranslate

Column	Type	Keys
`index`	Int	PK
`creative_id`	Long	PKFK
`name`	String

lookalike_origin

Column	Type	Keys
`index`	Int	PK
`custom_audience_id`	Long	PKFK
`custom_audience_updated_time`	Instant	PKFK
`origin_custom_audience_id`	Long	FK
`name`	String
`type`	String

ad_asset_feed_spec_group_rule

Column	Type	Keys
`index`	Int	PK
`creative_id`	Long	PKFK
`body_label`	Json
`caption_label`	Json
`description_label`	Json
`image_label`	Json
`link_url_label`	Json
`title_label`	Json
`video_label`	Json

frequency_control

Column	Type	Keys
`index`	Int	PK
`ad_set_id`	Long	PKFK
`ad_set_updated_time`	Instant	PKFK
`event`	String
`interval_days`	Int
`max_frequency`	Int

ad_asset_feed_spec_message_extension

Column	Type	Keys
`index`	Int	PK
`creative_id`	Long	PKFK
`type`	String

creative_sequence

Column	Type	Keys
`ad_id`	String	PKFK
`ad_set_id`	Long	PKFK
`ad_set_updated_time`	Instant	PKFK

lookalike_target_country

Column	Type	Keys
`country`	String	PK
`custom_audience_id`	Long	PKFK
`custom_audience_updated_time`	Instant	PKFK

ad_video_history

Column	Type	Keys
`id`	String	PK
`updated_time`	Instant	PK
`account_id`	Long	FK
`ad_breaks`	Json
`backdated_time`	Instant
`backdated_time_granularity`	String
`content_category`	String
`content_tags`	Json
`created_time`	Instant
`custom_labels`	Json
`description`	String
`embed_html`	String
`embeddable`	Boolean
`event`	Json
`format`	Json
`from_object`	Json
`icon`	String
`is_crosspost_video`	Boolean
`is_crossposting_eligible`	Boolean
`is_episode`	Boolean
`is_instagram_eligible`	Boolean
`is_reference_only`	Boolean
`length`	Float
`live_status`	String
`music_video_copyright`	Json
`permalink_url`	String
`picture`	Json
`place`	Json
`post_views`	Long
`premiere_living_room_status`	String
`privacy`	Json
`published`	Boolean
`scheduled_publish_time`	Instant
`source`	String
`status_processing_progress`	Int
`status_value`	String
`title`	String
`universal_video_id`	String
`views`	Long

ad_activity

Column	Type	Keys
`actor_id`	Long	PK
`event_time`	Instant	PK
`event_type`	String	PK
`object_id`	Long	PK
`account_id`	Long	FK
`actor_name`	String
`application_id`	Long
`application_name`	String
`date_time_in_timezone`	String
`extra_data`	String
`object_name`	String
`object_type`	String
`translated_event_type`	String

custom_conversion_history

Column	Type	Keys
`id`	Long	PK
`account_id`	Long	FK
`name`	String

pacing_type

Column	Type	Keys
`index`	Int	PK
`ad_set_id`	Long	PKFK
`ad_set_updated_time`	Instant	PKFK
`name`	String

ad_set_attribution

Column	Type	Keys
`index`	Int	PK
`ad_set_id`	Long	PKFK
`ad_set_updated_time`	Instant	PKFK

account_history

Column	Type	Keys
`_fivetran_id`	String	PK
`id`	Long	PK
`account_status`	String
`age`	Float
`amount_spent`	Long
`balance`	Long
`business_city`	String
`business_country_code`	String
`business_name`	String
`business_state`	String
`business_street`	String
`business_street_2`	String
`business_zip`	String
`can_create_brand_lift_study`	Boolean
`capabilities`	Json
`created_time`	Instant
`currency`	String
`disable_reason`	String
`end_advertiser`	Long
`end_advertiser_name`	String
`funding_source`	Long
`has_migrated_permissions`	Boolean
`io_number`	Long
`is_attribution_spec_system_default`	Boolean
`is_direct_deals_enabled`	Boolean
`is_in_3_ds_authorization_enabled_market`	Boolean
`is_notifications_enabled`	Boolean
`is_personal`	Int
`is_prepay_account`	Boolean
`is_tax_id_required`	Boolean
`media_agency`	Long
`min_campaign_group_spend_cap`	Long
`min_daily_budget`	Int
`name`	String
`next_bill_date`	Instant
`offsite_pixels_tos_accepted`	Boolean
`owner`	Long
`partner`	Long
`salesforce_invoice_group_id`	String
`spend_cap`	Long
`tax_id`	String
`tax_id_status`	String
`tax_id_type`	String
`timezone_id`	Int
`timezone_name`	String
`timezone_offset_hours_utc`	Float
`agency_client_declaration_`
`business_manager_`
`extended_credit_invoice_group_`
`funding_source_details_`

custom_audience_history

Column	Type	Keys
`id`	Long	PK
`updated_time`	Instant	PK
`account_id`	Long	FK
`approximate_count_lower_bound`	Long
`approximate_count_upper_bound`	Long
`content_updated_time`	Instant
`created_time`	Instant
`customer_file_source`	String
`data_source_creation_params`	String
`data_source_sub_type`	String
`data_source_type`	String
`delivery_status_code`	Int
`delivery_status_description`	String
`description`	String
`is_value_based`	Boolean
`name`	String
`operation_status_code`	Int
`operation_status_description`	String
`opt_out_link`	String
`pixel_id`	Long
`retention_days`	Int
`rule`	String
`rule_aggregation`	String
`subtype`	String
`external_event_source_`
`lookalike_`
`permission_for_actions_`

ad_label

Column	Type	Keys
`ad_id`	Long	PKFK
`ad_updated_time`	Instant	PKFK
`label_id`	Long	PKFK