# Facebook Ads schema ERD

Table and field reference for the Fivetran Facebook Ads connector.

## Table & Field Reference

### 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 |  |

### custom_conversion_history

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| account_id | Long | FK |
| name | 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_** |  |  |

### pixel_event_stats

| Column | Type | Keys |
| --- | --- | --- |
| aggregation | String | PK |
| pixel_id | Long | PK |
| start_time | Instant | PK |
| value | String | PK |
| count | Long |  |

### lookalike_origin

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| custom_audience_id | Long | PK, FK |
| custom_audience_updated_time | Instant | PK, FK |
| origin_custom_audience_id | Long | FK |
| name | String |  |
| type | String |  |

### failed_delivery_checks

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| _fivetran_id | String | PK, FK |
| account_id | Long |  |
| check_name | String |  |
| description | String |  |
| summary | String |  |

### ad_asset_feed_spec_group_rule

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| creative_id | Long | PK, FK |
| body_label | Json |  |
| caption_label | Json |  |
| description_label | Json |  |
| image_label | Json |  |
| link_url_label | Json |  |
| title_label | Json |  |
| video_label | Json |  |

### ad_asset_feed_spec_link_url

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| creative_id | Long | PK, FK |
| adlabels | Json |  |
| carousel_link_url | String |  |
| deeplink_url | String |  |
| display_url | String |  |
| object_store_urls | Json |  |
| url_tags | String |  |
| website_url | String |  |

### ad_asset_feed_spec_video

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| creative_id | Long | PK, FK |
| adlabels | Json |  |
| caption_ids | Json |  |
| thumbnail_hash | String |  |
| thumbnail_url | String |  |
| url_tags | String |  |
| video_id | String |  |

### ad_set_custom_audience

| Column | Type | Keys |
| --- | --- | --- |
| ad_set_id | Long | PK, FK |
| ad_set_updated_time | Instant | PK, FK |
| custom_audience_id | Long | PK, FK |
| is_excluded | Boolean |  |

### ad_asset_feed_spec_ad_format

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| creative_id | Long | PK, FK |
| name | String |  |

### 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_** |  |  |

### ad_conversion

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| ad_id | Long | PK, FK |
| ad_updated_time | Instant | PK, FK |
| 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_caption

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| creative_id | Long | PK, FK |
| adlabels | Json |  |
| text | String |  |
| url_tags | String |  |

### 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_** |  |  |

### creative_sequence

| Column | Type | Keys |
| --- | --- | --- |
| ad_id | String | PK, FK |
| ad_set_id | Long | PK, FK |
| ad_set_updated_time | Instant | PK, FK |

### ad_group_issues_info

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| ad_id | Long | PK, FK |
| ad_updated_time | Instant | PK, FK |
| error_code | Int |  |
| error_message | String |  |
| error_summary | String |  |
| error_type | String |  |
| level | String |  |

### ad_asset_feed_spec_autotranslate

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| creative_id | Long | PK, FK |
| name | String |  |

### ad_rotation_interval

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| ad_set_id | Long | PK, FK |
| ad_set_updated_time | Instant | PK, FK |
| date_range_start_time | Long |  |

### ad_label

| Column | Type | Keys |
| --- | --- | --- |
| ad_id | Long | PK, FK |
| ad_updated_time | Instant | PK, FK |
| label_id | Long | PK, FK |

### pacing_type

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| ad_set_id | Long | PK, FK |
| ad_set_updated_time | Instant | PK, FK |
| name | String |  |

### performance_recommendation

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| account_id | Long | PK, FK |
| object_id | String |  |
| recommendation_signature | String |  |
| type | String |  |

### lookalike_target_country_name

| Column | Type | Keys |
| --- | --- | --- |
| country_name | String | PK |
| custom_audience_id | Long | PK, FK |
| custom_audience_updated_time | Instant | PK, FK |

### lookalike_target_country

| Column | Type | Keys |
| --- | --- | --- |
| country | String | PK |
| custom_audience_id | Long | PK, FK |
| custom_audience_updated_time | Instant | PK, FK |

### 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_asset_feed_spec_title

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| creative_id | Long | PK, FK |
| adlabels | Json |  |
| text | String |  |
| url_tags | String |  |

### ad_asset_feed_spec_asset_customization_rule

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| creative_id | Long | PK, FK |
| 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_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 |  |

### ad_study_cell

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

### ad_asset_feed_spec_message_extension

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| creative_id | Long | PK, FK |
| type | String |  |

### lead_custom_disclaimer_response

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| lead_id | String | PK, FK |
| checkbox_key | String |  |
| is_checked | Boolean |  |
| title | String |  |

### ad_asset_feed_spec_image

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| creative_id | Long | PK, FK |
| adlabels | Json |  |
| hash | String |  |
| image_crops | Json |  |
| url | String |  |
| url_tags | String |  |

### reach_frequency

| Column | Type | Keys |
| --- | --- | --- |
| country_code | String | PK |
| _fivetran_id | String | PK, FK |
| account_id | Long |  |
| max_campaign_duration | Long |  |
| max_days_to_finish | Long |  |
| min_campaign_duration | Long |  |
| min_reach_limits | Long |  |

### 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_study_objective

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

### lead_field_data

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| lead_id | String | PK, FK |
| name | String |  |
| values | Json |  |

### ad_asset_feed_spec_description

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| creative_id | Long | PK, FK |
| adlabels | Json |  |
| text | String |  |
| url_tags | String |  |

### ad_campaign_issues_info

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| ad_set_id | Long | PK, FK |
| ad_set_updated_time | Instant | PK, FK |
| error_code | Int |  |
| error_message | String |  |
| error_summary | String |  |
| error_type | String |  |
| level | String |  |

### ad_tracking

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| ad_id | Long | PK, FK |
| ad_updated_time | Instant | PK, FK |
| 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_objective_result

| Column | Type | Keys |
| --- | --- | --- |
| date | LocalDate | PK |
| cell_id | Long | PK, FK |
| objective_id | Long | PK, FK |

### ad_asset_feed_spec_body

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| creative_id | Long | PK, FK |
| adlabels | Json |  |
| text | String |  |
| url_tags | String |  |

### ad_asset_feed_spec_call_to_action

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| creative_id | Long | PK, FK |
| adlabels | Json |  |
| type | String |  |
| value_** |  |  |

### ad_set_label

| Column | Type | Keys |
| --- | --- | --- |
| ad_set_id | Long | PK, FK |
| ad_set_updated_time | Instant | PK, FK |
| label_id | Long | PK, FK |

### adset_schedule

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| ad_set_id | Long | PK, FK |
| ad_set_updated_time | Instant | PK, FK |
| days | Json |  |
| end_minute | Int |  |
| start_minute | Int |  |
| timezone_type | String |  |

### 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 |  |

### campaign_label

| Column | Type | Keys |
| --- | --- | --- |
| ad_label_id | Long | PK, FK |
| campaign_id | Long | PK, FK |
| campaign_updated_time | Instant | PK, FK |

### 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 |  |

### 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 |  |

### creative_label

| Column | Type | Keys |
| --- | --- | --- |
| creative_id | Long | PK, FK |
| label_id | Long | PK, FK |

### frequency_control

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| ad_set_id | Long | PK, FK |
| ad_set_updated_time | Instant | PK, FK |
| event | String |  |
| interval_days | Int |  |
| max_frequency | Int |  |

### 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 |  |

### targeting_optimization_types

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| ad_set_id | Long | PK, FK |
| ad_set_updated_time | Instant | PK, FK |
| key | String |  |
| value | Int |  |

### 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_upcoming_event

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| creative_id | Long | PK, FK |
| 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 | PK, FK |
| details_page_product_id | Long |  |
| shop_collection_product_set_id | Long |  |
| storefront_shop_id | Long |  |

### custom_audience_label

| Column | Type | Keys |
| --- | --- | --- |
| label | String | PK |
| custom_audience_id | Long | PK, FK |
| custom_audience_updated_time | Instant | PK, FK |

### ad_asset_feed_spec_event

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| creative_id | Long | PK, FK |
| id | String |  |

### ad_recommendation

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| ad_id | Long | PK, FK |
| ad_updated_time | Instant | PK, FK |
| blame_field | String |  |
| code | Int |  |
| confidence | String |  |
| importance | String |  |
| message | String |  |
| recommendation_data | Json |  |
| title | String |  |

### ad_set_attribution

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| ad_set_id | Long | PK, FK |
| ad_set_updated_time | Instant | PK, FK |

### label_history

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

## Relationships

- ad_study(account_id) → account_history(id)
- custom_conversion_history(account_id) → account_history(id)
- campaign_history(account_id) → account_history(id)
- campaign_history(source_campaign_id) → campaign_history(id)
- lookalike_origin(custom_audience_id) → custom_audience_history(id)
- lookalike_origin(custom_audience_updated_time) → custom_audience_history(id)
- lookalike_origin(origin_custom_audience_id) → custom_audience_history(id)
- failed_delivery_checks(_fivetran_id) → account_history(_fivetran_id)
- ad_asset_feed_spec_group_rule(creative_id) → creative_history(id)
- ad_asset_feed_spec_link_url(creative_id) → creative_history(id)
- ad_asset_feed_spec_video(creative_id) → creative_history(id)
- ad_set_custom_audience(ad_set_id) → ad_set_history(id)
- ad_set_custom_audience(custom_audience_id) → custom_audience_history(id)
- ad_set_custom_audience(ad_set_updated_time) → ad_set_history(id)
- ad_asset_feed_spec_ad_format(creative_id) → creative_history(id)
- ad_conversion(ad_id) → ad_history(id)
- ad_conversion(ad_updated_time) → ad_history(id)
- ad_asset_feed_spec_caption(creative_id) → creative_history(id)
- custom_audience_history(account_id) → account_history(id)
- creative_sequence(ad_set_id) → ad_set_history(id)
- creative_sequence(ad_set_updated_time) → ad_set_history(id)
- creative_sequence(ad_id) → ad_history(id)
- ad_group_issues_info(ad_id) → ad_history(id)
- ad_group_issues_info(ad_updated_time) → ad_history(id)
- ad_asset_feed_spec_autotranslate(creative_id) → creative_history(id)
- ad_rotation_interval(ad_set_id) → ad_set_history(id)
- ad_rotation_interval(ad_set_updated_time) → ad_set_history(id)
- ad_label(ad_id) → ad_history(id)
- ad_label(ad_updated_time) → ad_history(id)
- ad_label(label_id) → label_history(id)
- pacing_type(ad_set_id) → ad_set_history(id)
- pacing_type(ad_set_updated_time) → ad_set_history(id)
- performance_recommendation(account_id) → account_history(id)
- lookalike_target_country_name(custom_audience_id) → custom_audience_history(id)
- lookalike_target_country_name(custom_audience_updated_time) → custom_audience_history(id)
- lookalike_target_country(custom_audience_id) → custom_audience_history(id)
- lookalike_target_country(custom_audience_updated_time) → custom_audience_history(id)
- creative_history(account_id) → account_history(id)
- ad_asset_feed_spec_title(creative_id) → creative_history(id)
- ad_asset_feed_spec_asset_customization_rule(creative_id) → creative_history(id)
- ad_activity(account_id) → account_history(id)
- ad_study_cell(ad_study_id) → ad_study(id)
- ad_asset_feed_spec_message_extension(creative_id) → creative_history(id)
- lead_custom_disclaimer_response(lead_id) → lead(id)
- ad_asset_feed_spec_image(creative_id) → creative_history(id)
- reach_frequency(_fivetran_id) → account_history(_fivetran_id)
- ad_set_history(campaign_id) → campaign_history(id)
- ad_set_history(account_id) → account_history(id)
- ad_set_history(adset_source_id) → ad_set_history(id)
- ad_study_objective(ad_study_id) → ad_study(id)
- lead_field_data(lead_id) → lead(id)
- ad_asset_feed_spec_description(creative_id) → creative_history(id)
- ad_campaign_issues_info(ad_set_id) → ad_set_history(id)
- ad_campaign_issues_info(ad_set_updated_time) → ad_set_history(id)
- ad_tracking(ad_id) → ad_history(id)
- ad_tracking(ad_updated_time) → ad_history(id)
- ad_study_objective_result(objective_id) → ad_study_objective(id)
- ad_study_objective_result(cell_id) → ad_study_cell(id)
- ad_asset_feed_spec_body(creative_id) → creative_history(id)
- ad_asset_feed_spec_call_to_action(creative_id) → creative_history(id)
- ad_set_label(ad_set_id) → ad_set_history(id)
- ad_set_label(ad_set_updated_time) → ad_set_history(id)
- ad_set_label(label_id) → label_history(id)
- adset_schedule(ad_set_id) → ad_set_history(id)
- adset_schedule(ad_set_updated_time) → ad_set_history(id)
- ad_video_history(account_id) → account_history(id)
- campaign_label(campaign_id) → campaign_history(id)
- campaign_label(campaign_updated_time) → campaign_history(id)
- campaign_label(ad_label_id) → label_history(id)
- ad_video_thumbnail(video_id) → ad_video_history(id)
- lead(ad_id) → ad_history(id)
- lead(campaign_id) → campaign_history(id)
- lead(adset_id) → ad_set_history(id)
- creative_label(creative_id) → creative_history(id)
- creative_label(label_id) → label_history(id)
- frequency_control(ad_set_id) → ad_set_history(id)
- frequency_control(ad_set_updated_time) → ad_set_history(id)
- ad_history(account_id) → account_history(id)
- ad_history(campaign_id) → campaign_history(id)
- ad_history(creative_id) → creative_history(id)
- ad_history(ad_set_id) → ad_set_history(id)
- ad_history(ad_source_id) → ad_history(id)
- targeting_optimization_types(ad_set_id) → ad_set_history(id)
- targeting_optimization_types(ad_set_updated_time) → ad_set_history(id)
- ad_image_history(account_id) → account_history(id)
- ad_asset_feed_spec_upcoming_event(creative_id) → creative_history(id)
- ad_asset_feed_spec_onsite_destination(creative_id) → creative_history(id)
- custom_audience_label(custom_audience_id) → custom_audience_history(id)
- custom_audience_label(custom_audience_updated_time) → custom_audience_history(updated_time)
- ad_asset_feed_spec_event(creative_id) → creative_history(id)
- ad_recommendation(ad_id) → ad_history(id)
- ad_recommendation(ad_updated_time) → ad_history(id)
- ad_set_attribution(ad_set_id) → ad_set_history(id)
- ad_set_attribution(ad_set_updated_time) → ad_set_history(id)
- label_history(account_id) → account_history(id)