# Google Ads schema ERD

Table and field reference for the Fivetran Google Ads connector.

## Table & Field Reference

### account_label_history

| Column | Type | Keys |
| --- | --- | --- |
| account_id | Long | PK, FK |
| label_id | Long | PK, FK |
| updated_at | Instant | PK, FK |

### account_history

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| updated_at | Instant | PK |
| manager_customer_id | Long | FK |
| auto_tagging_enabled | Boolean |  |
| currency_code | String |  |
| descriptive_name | String |  |
| final_url_suffix | String |  |
| hidden | Boolean |  |
| manager | Boolean |  |
| optimization_score | Double |  |
| pay_per_conversion_eligibility_failure_reasons | String |  |
| test_account | Boolean |  |
| time_zone | String |  |
| tracking_url_template | String |  |

### video_ad_history

| Column | Type | Keys |
| --- | --- | --- |
| ad_group_id | Long | PK, FK |
| ad_id | Long | PK, FK |
| updated_at | Instant | PK, FK |
| discovery_description_1 | String |  |
| discovery_description_2 | String |  |
| discovery_headline | String |  |
| in_stream_action_button_label | String |  |
| in_stream_action_headline | String |  |
| out_stream_description | String |  |
| out_stream_headline | String |  |
| type | String |  |

### text_ad_history

| Column | Type | Keys |
| --- | --- | --- |
| ad_group_id | Long | PK, FK |
| ad_id | Long | PK, FK |
| updated_at | Instant | PK, FK |
| description_1 | String |  |
| description_2 | String |  |
| headline | String |  |

### campaign_local_setting_history

| Column | Type | Keys |
| --- | --- | --- |
| campaign_id | Long | PK, FK |
| updated_at | Instant | PK, FK |
| location_source_type | String |  |

### shared_criterion_history

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| shared_set_id | Long | PK, FK |
| updated_at | Instant | PK, FK |
| brand_display_name | String |  |
| brand_primary_url | String |  |
| brand_rejection_reason | String |  |
| brand_status | String |  |
| keyword_match_type | String |  |
| keyword_text | String |  |
| mobile_app_category_constant_id | Int |  |
| mobile_app_category_constant_name | String |  |
| mobile_application_app_id | String |  |
| mobile_application_name | String |  |
| placement_url | String |  |
| type | String |  |
| youtube_channel_id | String |  |
| youtube_video_id | String |  |

### local_ad_history

| Column | Type | Keys |
| --- | --- | --- |
| ad_group_id | Long | PK, FK |
| ad_id | Long | PK, FK |
| updated_at | Instant | PK, FK |
| call_to_actions | String |  |
| descriptions | String |  |
| headlines | String |  |
| path_1 | String |  |
| path_2 | String |  |

### ad_group_history

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| updated_at | Instant | PK |
| base_ad_group_id | Long | FK |
| campaign_id | Long | FK |
| ad_rotation_mode | String |  |
| ai_max_ad_group_setting_disable_search_term_matching | Boolean |  |
| campaign_name | String |  |
| display_custom_bid_dimension | String |  |
| explorer_auto_optimizer_setting_opt_in | Boolean |  |
| final_url_suffix | String |  |
| name | String |  |
| status | String |  |
| target_restrictions | String |  |
| tracking_url_template | String |  |
| type | String |  |

### geo_target

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| parent_geo_target_id | Long | FK |
| canonical_name | String |  |
| country_code | String |  |
| name | String |  |
| status | String |  |
| target_type | String |  |

### combined_audience

| Column | Type | Keys |
| --- | --- | --- |
| customer_id | Long | PK |
| id | Long | PK |
| name | String | PK |
| description | String |  |
| status | String |  |

### campaign_budget_history

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| campaign_id | Long | PK, FK |
| updated_at | Instant | PK, FK |
| amount_micros | Long |  |
| delivery_method | String |  |
| explicitly_shared | Boolean |  |
| has_recommended_budget | Boolean |  |
| name | String |  |
| period | String |  |
| recommended_budget_amount_micros | Long |  |
| reference_count | Long |  |
| status | String |  |
| total_amount_micros | Long |  |
| type | String |  |

### campaign_bidding_strategy_history

| Column | Type | Keys |
| --- | --- | --- |
| campaign_id | Long | PK, FK |
| updated_at | Instant | PK, FK |
| cpc_bid_ceiling_micros | Long |  |
| cpc_bid_floor_micros | Long |  |
| enhanced_cpc | String |  |
| enhanced_cpc_enabled | Boolean |  |
| location | String |  |
| location_fraction_micros | Long |  |
| manual_cpa | String |  |
| manual_cpm | String |  |
| manual_cpv | String |  |
| name | String |  |
| status | String |  |
| target_cpa_micros | Long |  |
| target_cpm | String |  |
| target_roas | Double |  |
| type | String |  |

### campaign_shopping_setting_history

| Column | Type | Keys |
| --- | --- | --- |
| campaign_id | Long | PK, FK |
| updated_at | Instant | PK, FK |
| campaign_priority | Int |  |
| enable_local | Boolean |  |
| feed_label | String |  |
| merchant_id | Long |  |

### expanded_dynamic_search_ad_history

| Column | Type | Keys |
| --- | --- | --- |
| ad_group_id | Long | PK, FK |
| ad_id | Long | PK, FK |
| updated_at | Instant | PK, FK |
| description | String |  |
| description_2 | String |  |

### demand_gen_product_ad_history

| Column | Type | Keys |
| --- | --- | --- |
| ad_group_id | Long | PK, FK |
| ad_id | Long | PK, FK |
| updated_at | Instant | PK, FK |
| breadcrumb_1 | String |  |
| breadcrumb_2 | String |  |
| business_name | String |  |
| call_to_action_asset | String |  |
| description | String |  |
| headline | String |  |
| logo_image_asset | String |  |

### legacy_responsive_display_ad_history

| Column | Type | Keys |
| --- | --- | --- |
| ad_group_id | Long | PK, FK |
| ad_id | Long | PK, FK |
| updated_at | Instant | PK, FK |
| accent_color | String |  |
| allow_flexible_color | Boolean |  |
| business_name | String |  |
| call_to_action_text | String |  |
| description | String |  |
| format_setting | String |  |
| long_headline | String |  |
| main_color | String |  |
| price_prefix | String |  |
| promo_text | String |  |
| short_headline | String |  |

### label

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| name | String |  |
| status | String |  |
| text_label_background_color | String |  |
| text_label_description | String |  |

### responsive_search_ad_history

| Column | Type | Keys |
| --- | --- | --- |
| ad_group_id | Long | PK, FK |
| ad_id | Long | PK, FK |
| updated_at | Instant | PK, FK |
| descriptions | String |  |
| headlines | String |  |
| path_1 | String |  |
| path_2 | String |  |

### shopping_product_ad_history

| Column | Type | Keys |
| --- | --- | --- |
| ad_group_id | Long | PK, FK |
| ad_id | Long | PK, FK |
| updated_at | Instant | PK, FK |
| shopping_product_ad | String |  |

### hotel_ad_history

| Column | Type | Keys |
| --- | --- | --- |
| ad_group_id | Long | PK, FK |
| ad_id | Long | PK, FK |
| updated_at | Instant | PK, FK |
| hotel_ad | String |  |

### ad_custom_parameter_history

| Column | Type | Keys |
| --- | --- | --- |
| sequence_id | Int | PK |
| ad_group_id | Long | PK, FK |
| ad_id | Long | PK, FK |
| updated_at | Instant | PK, FK |
| key | String |  |
| value | String |  |

### legacy_app_install_ad_history

| Column | Type | Keys |
| --- | --- | --- |
| ad_group_id | Long | PK, FK |
| ad_id | Long | PK, FK |
| updated_at | Instant | PK, FK |
| app_id | String |  |
| app_store | String |  |
| description_1 | String |  |
| description_2 | String |  |
| headline | String |  |

### responsive_display_ad_history

| Column | Type | Keys |
| --- | --- | --- |
| ad_group_id | Long | PK, FK |
| ad_id | Long | PK, FK |
| updated_at | Instant | PK, FK |
| accent_color | String |  |
| allow_flexible_color | Boolean |  |
| business_name | String |  |
| call_to_action_text | String |  |
| descriptions | String |  |
| enable_asset_enhancements | Boolean |  |
| enable_autogen_video | Boolean |  |
| format_setting | String |  |
| headlines | String |  |
| long_headline | String |  |
| main_color | String |  |
| price_prefix | String |  |
| promo_text | String |  |

### demand_gen_multi_asset_ad_history

| Column | Type | Keys |
| --- | --- | --- |
| ad_group_id | Long | PK, FK |
| ad_id | Long | PK, FK |
| updated_at | Instant | PK, FK |
| business_name | String |  |
| call_to_action_text | String |  |
| descriptions | String |  |
| headlines | String |  |
| lead_form_only | Boolean |  |
| logo_images | String |  |
| marketing_images | String |  |
| portrait_marketing_images | String |  |
| square_marketing_images | String |  |

### ad_policy_topic_constraint_history

| Column | Type | Keys |
| --- | --- | --- |
| sequence_id | Int | PK |
| ad_group_id | Long | PK, FK |
| ad_id | Long | PK, FK |
| policy_topic_sequence_id | Int | PK, FK |
| updated_at | Instant | PK, FK |
| constrained_countries | String |  |
| reseller_constraint | String |  |
| total_targeted_countries | Int |  |
| type | String |  |

### app_engagement_ad_history

| Column | Type | Keys |
| --- | --- | --- |
| ad_group_id | Long | PK, FK |
| ad_id | Long | PK, FK |
| updated_at | Instant | PK, FK |
| descriptions | String |  |
| headlines | String |  |

### demand_gen_carousel_ad_history

| Column | Type | Keys |
| --- | --- | --- |
| ad_group_id | Long | PK, FK |
| ad_id | Long | PK, FK |
| updated_at | Instant | PK, FK |
| business_name | String |  |
| call_to_action_text | String |  |
| carousel_cards | String |  |
| description | String |  |
| headline | String |  |

### ad_group_criterion_custom_parameter_history

| Column | Type | Keys |
| --- | --- | --- |
| sequence_id | Int | PK |
| ad_group_id | Long | PK, FK |
| criterion_id | Long | PK, FK |
| updated_at | Instant | PK, FK |
| key | String |  |
| value | String |  |

### smart_campaign_ad_history

| Column | Type | Keys |
| --- | --- | --- |
| ad_group_id | Long | PK, FK |
| ad_id | Long | PK, FK |
| updated_at | Instant | PK, FK |
| descriptions | String |  |
| headlines | String |  |

### mobile_device

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| manufacturer_name | String |  |
| name | String |  |
| operating_system_name | String |  |
| type | String |  |

### campaign_conversion_goal_history

| Column | Type | Keys |
| --- | --- | --- |
| resource_name | String | PK |
| campaign_id | Long | PK, FK |
| updated_at | Instant | PK, FK |
| biddable | Boolean |  |
| category | String |  |
| origin | String |  |

### shopping_comparison_listing_ad_history

| Column | Type | Keys |
| --- | --- | --- |
| ad_group_id | Long | PK, FK |
| ad_id | Long | PK, FK |
| updated_at | Instant | PK, FK |
| headline | String |  |

### call_ad_history

| Column | Type | Keys |
| --- | --- | --- |
| ad_group_id | Long | PK, FK |
| ad_id | Long | PK, FK |
| updated_at | Instant | PK, FK |
| business_name | String |  |
| call_tracked | Boolean |  |
| conversion_action | String |  |
| conversion_reporting_state | String |  |
| country_code | String |  |
| description_1 | String |  |
| description_2 | String |  |
| disable_call_conversion | Boolean |  |
| headline_1 | String |  |
| headline_2 | String |  |
| path_1 | String |  |
| path_2 | String |  |
| phone_number | String |  |
| phone_number_verification_url | String |  |

### campaign_criterion_ad_schedule_history

| Column | Type | Keys |
| --- | --- | --- |
| campaign_id | Long | PK, FK |
| criterion_id | Long | PK, FK |
| updated_at | Instant | PK, FK |
| day_of_week | String |  |
| end_hour | Int |  |
| end_minute | String |  |
| start_hour | Int |  |
| start_minute | String |  |

### campaign_label_history

| Column | Type | Keys |
| --- | --- | --- |
| campaign_id | Long | PK, FK |
| label_id | Long | PK, FK |
| updated_at | Instant | PK, FK |

### campaign_criterion_history

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| updated_at | Instant | PK |
| campaign_id | Long | PK, FK |
| geo_target_constant_id | Long | FK |
| mobile_device_id | Long | FK |
| operating_system_version_id | Long | FK |
| user_interest_id | Long | FK |
| user_list_id | Long | FK |
| age_range_type | String |  |
| bid_modifier | Double |  |
| carrier_country_code | String |  |
| carrier_name | String |  |
| content_label_type | String |  |
| device_type | String |  |
| display_name | String |  |
| gender_type | String |  |
| income_range_type | String |  |
| ip_block_ip_address | String |  |
| keyword_match_type | String |  |
| keyword_text | String |  |
| language_code | String |  |
| language_name | String |  |
| mobile_app_category_constant_id | Int |  |
| mobile_app_category_constant_name | String |  |
| mobile_application_app_id | String |  |
| mobile_application_name | String |  |
| negative | Boolean |  |
| parental_status_type | String |  |
| placement_url | String |  |
| status | String |  |
| topic_constant_id | Long |  |
| type | String |  |
| youtube_channel_id | String |  |
| youtube_video_id | String |  |

### campaign_history

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| updated_at | Instant | PK |
| base_campaign_id | Long | FK |
| customer_id | Long | FK |
| ad_serving_optimization_status | String |  |
| advertising_channel_subtype | String |  |
| advertising_channel_type | String |  |
| ai_max_setting_bundling_required | String |  |
| ai_max_setting_enable_ai_max | Boolean |  |
| end_date | String |  |
| end_date_time | String |  |
| experiment_type | String |  |
| final_url_suffix | String |  |
| frequency_caps | String |  |
| local_services_enabled | Boolean |  |
| local_services_pmax_campaign_settings_country_code | String |  |
| local_services_pmax_campaign_settings_founding_year | Long |  |
| local_services_pmax_campaign_settings_navigational_query_leads_enabled | Boolean |  |
| local_services_pmax_campaign_settings_phone_numbers | String |  |
| name | String |  |
| optimization_score | Double |  |
| payment_mode | String |  |
| serving_status | String |  |
| start_date | String |  |
| start_date_time | String |  |
| status | String |  |
| tracking_url_template | String |  |
| vanity_pharma_display_url_mode | String |  |
| vanity_pharma_text | String |  |
| video_brand_safety_suitability | String |  |

### app_ad_history

| Column | Type | Keys |
| --- | --- | --- |
| ad_group_id | Long | PK, FK |
| ad_id | Long | PK, FK |
| updated_at | Instant | PK, FK |
| descriptions | String |  |
| headlines | String |  |
| mandatory_ad_text | String |  |

### audience

| Column | Type | Keys |
| --- | --- | --- |
| customer_id | Long | PK |
| id | Long | PK |
| name | String | PK |
| description | String |  |
| dimensions | String |  |
| exclusion_dimension | String |  |
| scope | String |  |
| status | String |  |

### campaign_hotel_setting_history

| Column | Type | Keys |
| --- | --- | --- |
| campaign_id | Long | PK, FK |
| updated_at | Instant | PK, FK |
| hotel_center_id | Long |  |

### campaign_targeting_setting_history

| Column | Type | Keys |
| --- | --- | --- |
| sequence_id | Int | PK |
| campaign_id | Long | PK, FK |
| updated_at | Instant | PK, FK |
| bid_only | Boolean |  |
| targeting_dimension | String |  |

### ad_label_history

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

### ad_policy_topic_history

| Column | Type | Keys |
| --- | --- | --- |
| sequence_id | Int | PK |
| ad_group_id | Long | PK, FK |
| ad_id | Long | PK, FK |
| updated_at | Instant | PK, FK |
| topic | String |  |
| type | String |  |

### campaign_dynamic_search_ads_setting_history

| Column | Type | Keys |
| --- | --- | --- |
| campaign_id | Long | PK, FK |
| updated_at | Instant | PK, FK |
| domain_name | String |  |
| language_code | String |  |
| use_supplied_urls_only | Boolean |  |

### campaign_app_campaign_setting_history

| Column | Type | Keys |
| --- | --- | --- |
| campaign_id | Long | PK, FK |
| updated_at | Instant | PK, FK |
| app_id | String |  |
| app_store | String |  |
| bidding_strategy_goal_type | String |  |

### expanded_text_ad_history

| Column | Type | Keys |
| --- | --- | --- |
| ad_group_id | Long | PK, FK |
| ad_id | Long | PK, FK |
| updated_at | Instant | PK, FK |
| description | String |  |
| description_2 | String |  |
| headline_part_1 | String |  |
| headline_part_2 | String |  |
| headline_part_3 | String |  |
| path_1 | String |  |
| path_2 | String |  |

### image_ad_history

| Column | Type | Keys |
| --- | --- | --- |
| ad_group_id | Long | PK, FK |
| ad_id | Long | PK, FK |
| updated_at | Instant | PK, FK |
| image_url | String |  |
| mime_type | String |  |
| name | String |  |
| pixel_height | Long |  |
| pixel_width | Long |  |
| preview_image_url | String |  |
| preview_pixel_height | Long |  |
| preview_pixel_width | Long |  |

### ad_group_bidding_strategy_history

| Column | Type | Keys |
| --- | --- | --- |
| ad_group_id | Long | PK, FK |
| updated_at | Instant | PK, FK |
| cpc_bid_micros | Long |  |
| cpm_bid_micros | Long |  |
| cpv_bid_micros | Long |  |
| effective_target_cpa_micros | Long |  |
| effective_target_cpa_source | String |  |
| effective_target_roas | Double |  |
| effective_target_roas_source | String |  |
| percent_cpc_bid_micros | Long |  |
| target_cpa_micros | Long |  |
| target_cpm_micros | Long |  |
| target_roas | Double |  |

### campaign_geo_target_type_setting_history

| Column | Type | Keys |
| --- | --- | --- |
| campaign_id | Long | PK, FK |
| updated_at | Instant | PK, FK |
| negative_geo_target_type | String |  |
| positive_geo_target_type | String |  |

### ad_history

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| updated_at | Instant | PK |
| ad_group_id | Long | PK, FK |
| action_items | String |  |
| ad_strength | String |  |
| added_by_google_ads | Boolean |  |
| device_preference | String |  |
| display_url | String |  |
| final_app_urls | String |  |
| final_mobile_urls | String |  |
| final_url_suffix | String |  |
| final_urls | String |  |
| name | String |  |
| policy_summary_approval_status | String |  |
| policy_summary_review_status | String |  |
| status | String |  |
| system_managed_resource_source | String |  |
| tracking_url_template | String |  |
| type | String |  |
| url_collections | String |  |

### topic

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| parent_topic_id | Long | FK |
| path | String |  |

### operating_system_version

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| name | String |  |
| operator_type | String |  |
| os_major_version | Int |  |
| os_minor_version | Int |  |

### user_list

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| access_reason | String |  |
| account_user_list_status | String |  |
| closing_reason | String |  |
| description | String |  |
| eligible_for_display | Boolean |  |
| eligible_for_search | Boolean |  |
| membership_status | String |  |
| name | String |  |
| read_only | Boolean |  |
| size_for_display | Long |  |
| size_for_search | Long |  |
| size_range_for_display | String |  |
| size_range_for_search | String |  |
| type | String |  |

### video_responsive_ad_history

| Column | Type | Keys |
| --- | --- | --- |
| ad_group_id | Long | PK, FK |
| ad_id | Long | PK, FK |
| updated_at | Instant | PK, FK |
| breadcrumb_1 | String |  |
| breadcrumb_2 | String |  |
| call_to_actions | String |  |
| descriptions | String |  |
| headlines | String |  |
| long_headlines | String |  |

### ad_group_criterion_label_history

| Column | Type | Keys |
| --- | --- | --- |
| ad_group_id | Long | PK, FK |
| criterion_id | Long | PK, FK |
| label_id | Long | PK, FK |
| updated_at | Instant | PK, FK |

### campaign_criterion_proximity_history

| Column | Type | Keys |
| --- | --- | --- |
| campaign_id | Long | PK, FK |
| criterion_id | Long | PK, FK |
| updated_at | Instant | PK, FK |
| city_name | String |  |
| country_code | String |  |
| geo_point_latitude_in_micro_degrees | Int |  |
| geo_point_longitude_in_micro_degrees | Int |  |
| postal_code | String |  |
| province_code | String |  |
| province_name | String |  |
| radius | Double |  |
| radius_units | String |  |
| street_address | String |  |

### campaign_network_setting_history

| Column | Type | Keys |
| --- | --- | --- |
| campaign_id | Long | PK, FK |
| updated_at | Instant | PK, FK |
| target_content_network | Boolean |  |
| target_google_search | Boolean |  |
| target_partner_search_network | Boolean |  |
| target_search_network | Boolean |  |

### custom_audience

| Column | Type | Keys |
| --- | --- | --- |
| customer_id | Long | PK |
| id | Long | PK |
| name | String | PK |
| description | String |  |
| members | String |  |
| status | String |  |
| type | String |  |

### campaign_asset_automation_setting_history

| Column | Type | Keys |
| --- | --- | --- |
| sequence_id | Int | PK |
| campaign_id | Long | PK, FK |
| updated_at | Instant | PK, FK |
| asset_automation_status | String |  |
| asset_automation_type | String |  |

### ad_group_label_history

| Column | Type | Keys |
| --- | --- | --- |
| ad_group_id | Long | PK, FK |
| label_id | Long | PK, FK |
| updated_at | Instant | PK, FK |

### shared_set_history

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| updated_at | Instant | PK |
| customer_id | Long | FK |
| member_count | Long |  |
| name | String |  |
| reference_count | Long |  |
| status | String |  |
| type | String |  |

### campaign_criterion_keyword_theme_history

| Column | Type | Keys |
| --- | --- | --- |
| campaign_id | Long | PK, FK |
| criterion_id | Long | PK, FK |
| updated_at | Instant | PK, FK |
| country_code | String |  |
| display_name | String |  |
| language_code | String |  |

### campaign_shared_set_history

| Column | Type | Keys |
| --- | --- | --- |
| updated_at | Instant | PK |
| campaig_id | Long | PK, FK |
| shared_set_id | Long | PK, FK |
| campaign_id | Long |  |
| status | String |  |

### ad_group_custom_parameter_history

| Column | Type | Keys |
| --- | --- | --- |
| sequence_id | Int | PK |
| ad_group_id | Long | PK, FK |
| updated_at | Instant | PK, FK |
| key | String |  |
| value | String |  |

### display_upload_ad_history

| Column | Type | Keys |
| --- | --- | --- |
| ad_group_id | Long | PK, FK |
| ad_id | Long | PK, FK |
| updated_at | Instant | PK, FK |
| display_upload_product_type | String |  |

### campaign_bid_modifier_history

| Column | Type | Keys |
| --- | --- | --- |
| criterion_id | Long | PK |
| campaign_id | Long | PK, FK |
| updated_at | Instant | PK, FK |
| bid_modifier | Double |  |
| interaction_event_types | String |  |
| interaction_type | String |  |

### campaign_optimization_goal_setting_history

| Column | Type | Keys |
| --- | --- | --- |
| sequence_id | Int | PK |
| campaign_id | Long | PK, FK |
| updated_at | Instant | PK, FK |
| optimization_goal_type | String |  |

### ad_policy_topic_evidence_history

| Column | Type | Keys |
| --- | --- | --- |
| sequence_id | Int | PK |
| ad_group_id | Long | PK, FK |
| ad_id | Long | PK, FK |
| policy_topic_sequence_id | Int | PK, FK |
| updated_at | Instant | PK, FK |
| type | String |  |
| value | String |  |

### campaign_criterion_listing_scope_dimension_history

| Column | Type | Keys |
| --- | --- | --- |
| sequence_id | Int | PK |
| campaign_id | Long | PK, FK |
| criterion_id | Long | PK, FK |
| updated_at | Instant | PK, FK |
| hotel_city_criterion_id | Long |  |
| hotel_class | Long |  |
| hotel_country_region_criterion_id | Long |  |
| hotel_id | String |  |
| hotel_state_criterion_id | Long |  |
| product_brand_value | String |  |
| product_category_country_code | String |  |
| product_category_id | Long |  |
| product_category_level | String |  |
| product_channel | String |  |
| product_channel_exclusivity | String |  |
| product_condition | String |  |
| product_custom_attribute_value | String |  |
| product_item_id | String |  |
| product_type_value | String |  |

### ad_group_bid_modifier_history

| Column | Type | Keys |
| --- | --- | --- |
| criterion_id | Long | PK |
| ad_group_id | Long | PK, FK |
| updated_at | Instant | PK, FK |
| base_ad_group | String |  |
| bid_modifier | Double |  |
| bid_modifier_source | String |  |
| device_type | String |  |
| hotel_advance_booking_window_max_days | Long |  |
| hotel_advance_booking_window_min_days | Long |  |
| hotel_check_in_date_range_end_date | String |  |
| hotel_check_in_date_range_start_date | String |  |
| hotel_check_in_day_day_of_week | String |  |
| hotel_date_selection_type | String |  |
| hotel_length_of_stay_max_nights | Long |  |
| hotel_length_of_stay_min_nights | Long |  |

### shopping_smart_ad_history

| Column | Type | Keys |
| --- | --- | --- |
| ad_group_id | Long | PK, FK |
| ad_id | Long | PK, FK |
| updated_at | Instant | PK, FK |
| shopping_smart_ad | String |  |

### ad_group_criterion_history

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| updated_at | Instant | PK |
| ad_group_id | Long | PK, FK |
| audience_id | Long | FK |
| combined_audience_id | Long | FK |
| custom_audience_id | Long | FK |
| user_interest_id | Long | FK |
| user_list_id | Long | FK |
| age_range_type | String |  |
| app_payment_model_type | String |  |
| approval_status | String |  |
| bid_modifier | Double |  |
| cpc_bid_micros | Long |  |
| cpm_bid_micros | Long |  |
| cpv_bid_micros | Long |  |
| custom_affinity_id | Long |  |
| custom_intent_id | Long |  |
| disapproval_reasons | String |  |
| display_name | String |  |
| final_mobile_urls | String |  |
| final_url_suffix | String |  |
| final_urls | String |  |
| first_page_cpc_micros | Long |  |
| first_position_cpc_micros | Long |  |
| gender_type | String |  |
| income_range_type | String |  |
| keyword_match_type | String |  |
| keyword_text | String |  |
| mobile_app_category_constant_id | Int |  |
| mobile_app_category_constant_name | String |  |
| mobile_application_app_id | String |  |
| mobile_application_name | String |  |
| negative | Boolean |  |
| parent_ad_group_criterion_id | Long |  |
| parental_status_type | String |  |
| placement_url | String |  |
| quality_info_creative_score | String |  |
| quality_info_post_click_score | String |  |
| quality_info_score | Int |  |
| quality_info_search_predicted_ctr | String |  |
| status | String |  |
| system_serving_status | String |  |
| top_of_page_cpc_micros | Long |  |
| topic_constant_id | Long |  |
| tracking_url_template | String |  |
| type | String |  |
| webpage_conditions | String |  |
| youtube_channel_id | String |  |
| youtube_video_id | String |  |

### ad_listing_group_criterion_history

| Column | Type | Keys |
| --- | --- | --- |
| ad_group_id | Long | PK, FK |
| criterion_id | Long | PK, FK |
| updated_at | Instant | PK, FK |
| hotel_city_criterion_id | Long |  |
| hotel_class | Long |  |
| hotel_country_region_criterion_id | Long |  |
| hotel_id | String |  |
| hotel_state_criterion_id | Long |  |
| listing_group_type | String |  |
| product_brand_value | String |  |
| product_category_country_code | String |  |
| product_category_id | Long |  |
| product_category_level | String |  |
| product_channel | String |  |
| product_channel_exclusivity | String |  |
| product_condition | String |  |
| product_custom_attribute_value | String |  |
| product_item_id | String |  |
| product_type_value | String |  |

### campaign_real_time_bidding_setting_history

| Column | Type | Keys |
| --- | --- | --- |
| campaign_id | Long | PK, FK |
| updated_at | Instant | PK, FK |
| opt_in | Boolean |  |

### user_interest

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| parent_id | Long | FK |
| availabilities | String |  |
| launched_to_all | Boolean |  |
| name | String |  |
| taxonomy_type | String |  |

### campaign_tracking_setting_history

| Column | Type | Keys |
| --- | --- | --- |
| campaign_id | Long | PK, FK |
| updated_at | Instant | PK, FK |
| tracking_url | String |  |

## Relationships

- account_label_history(account_id) → account_history(id)
- account_label_history(updated_at) → account_history(id)
- account_label_history(label_id) → label(id)
- account_history(manager_customer_id) → account_history(id)
- video_ad_history(ad_id) → ad_history(id)
- video_ad_history(ad_group_id) → ad_history(id)
- video_ad_history(updated_at) → ad_history(id)
- text_ad_history(ad_id) → ad_history(id)
- text_ad_history(ad_group_id) → ad_history(id)
- text_ad_history(updated_at) → ad_history(id)
- campaign_local_setting_history(campaign_id) → campaign_history(id)
- campaign_local_setting_history(updated_at) → campaign_history(id)
- shared_criterion_history(updated_at) → shared_set_history(updated_at)
- shared_criterion_history(shared_set_id) → shared_set_history(id)
- local_ad_history(ad_id) → ad_history(id)
- local_ad_history(ad_group_id) → ad_history(id)
- local_ad_history(updated_at) → ad_history(id)
- ad_group_history(campaign_id) → campaign_history(id)
- ad_group_history(base_ad_group_id) → ad_group_history(id)
- geo_target(parent_geo_target_id) → geo_target(id)
- campaign_budget_history(campaign_id) → campaign_history(id)
- campaign_budget_history(updated_at) → campaign_history(id)
- campaign_bidding_strategy_history(campaign_id) → campaign_history(id)
- campaign_bidding_strategy_history(updated_at) → campaign_history(id)
- campaign_shopping_setting_history(campaign_id) → campaign_history(id)
- campaign_shopping_setting_history(updated_at) → campaign_history(id)
- expanded_dynamic_search_ad_history(ad_id) → ad_history(id)
- expanded_dynamic_search_ad_history(ad_group_id) → ad_history(id)
- expanded_dynamic_search_ad_history(updated_at) → ad_history(id)
- demand_gen_product_ad_history(ad_id) → ad_history(id)
- demand_gen_product_ad_history(ad_group_id) → ad_history(id)
- demand_gen_product_ad_history(updated_at) → ad_history(id)
- legacy_responsive_display_ad_history(ad_id) → ad_history(id)
- legacy_responsive_display_ad_history(ad_group_id) → ad_history(id)
- legacy_responsive_display_ad_history(updated_at) → ad_history(id)
- responsive_search_ad_history(ad_id) → ad_history(id)
- responsive_search_ad_history(ad_group_id) → ad_history(id)
- responsive_search_ad_history(updated_at) → ad_history(id)
- shopping_product_ad_history(ad_id) → ad_history(id)
- shopping_product_ad_history(ad_group_id) → ad_history(id)
- shopping_product_ad_history(updated_at) → ad_history(id)
- hotel_ad_history(ad_id) → ad_history(id)
- hotel_ad_history(ad_group_id) → ad_history(id)
- hotel_ad_history(updated_at) → ad_history(id)
- ad_custom_parameter_history(ad_id) → ad_history(id)
- ad_custom_parameter_history(ad_group_id) → ad_history(id)
- ad_custom_parameter_history(updated_at) → ad_history(id)
- legacy_app_install_ad_history(ad_id) → ad_history(id)
- legacy_app_install_ad_history(ad_group_id) → ad_history(id)
- legacy_app_install_ad_history(updated_at) → ad_history(id)
- responsive_display_ad_history(ad_id) → ad_history(id)
- responsive_display_ad_history(ad_group_id) → ad_history(id)
- responsive_display_ad_history(updated_at) → ad_history(id)
- demand_gen_multi_asset_ad_history(ad_id) → ad_history(id)
- demand_gen_multi_asset_ad_history(ad_group_id) → ad_history(id)
- demand_gen_multi_asset_ad_history(updated_at) → ad_history(id)
- ad_policy_topic_constraint_history(ad_id) → ad_policy_topic_history(sequence_id)
- ad_policy_topic_constraint_history(ad_group_id) → ad_policy_topic_history(sequence_id)
- ad_policy_topic_constraint_history(updated_at) → ad_policy_topic_history(sequence_id)
- ad_policy_topic_constraint_history(policy_topic_sequence_id) → ad_policy_topic_history(sequence_id)
- app_engagement_ad_history(ad_id) → ad_history(id)
- app_engagement_ad_history(ad_group_id) → ad_history(id)
- app_engagement_ad_history(updated_at) → ad_history(id)
- demand_gen_carousel_ad_history(ad_id) → ad_history(id)
- demand_gen_carousel_ad_history(ad_group_id) → ad_history(id)
- demand_gen_carousel_ad_history(updated_at) → ad_history(id)
- ad_group_criterion_custom_parameter_history(criterion_id) → ad_group_criterion_history(id)
- ad_group_criterion_custom_parameter_history(ad_group_id) → ad_group_criterion_history(id)
- ad_group_criterion_custom_parameter_history(updated_at) → ad_group_criterion_history(id)
- smart_campaign_ad_history(ad_id) → ad_history(id)
- smart_campaign_ad_history(ad_group_id) → ad_history(id)
- smart_campaign_ad_history(updated_at) → ad_history(id)
- campaign_conversion_goal_history(campaign_id) → campaign_history(id)
- campaign_conversion_goal_history(updated_at) → campaign_history(id)
- shopping_comparison_listing_ad_history(ad_id) → ad_history(id)
- shopping_comparison_listing_ad_history(ad_group_id) → ad_history(id)
- shopping_comparison_listing_ad_history(updated_at) → ad_history(id)
- call_ad_history(ad_id) → ad_history(id)
- call_ad_history(ad_group_id) → ad_history(id)
- call_ad_history(updated_at) → ad_history(id)
- campaign_criterion_ad_schedule_history(criterion_id) → campaign_criterion_history(id)
- campaign_criterion_ad_schedule_history(campaign_id) → campaign_criterion_history(id)
- campaign_criterion_ad_schedule_history(updated_at) → campaign_criterion_history(id)
- campaign_label_history(campaign_id) → campaign_history(id)
- campaign_label_history(updated_at) → campaign_history(id)
- campaign_label_history(label_id) → label(id)
- campaign_criterion_history(campaign_id) → campaign_history(id)
- campaign_criterion_history(geo_target_constant_id) → geo_target(id)
- campaign_criterion_history(mobile_device_id) → mobile_device(id)
- campaign_criterion_history(operating_system_version_id) → operating_system_version(id)
- campaign_criterion_history(user_interest_id) → user_interest(id)
- campaign_criterion_history(user_list_id) → user_list(id)
- campaign_history(customer_id) → account_history(id)
- campaign_history(base_campaign_id) → campaign_history(id)
- app_ad_history(ad_id) → ad_history(id)
- app_ad_history(ad_group_id) → ad_history(id)
- app_ad_history(updated_at) → ad_history(id)
- campaign_hotel_setting_history(campaign_id) → campaign_history(id)
- campaign_hotel_setting_history(updated_at) → campaign_history(id)
- campaign_targeting_setting_history(campaign_id) → campaign_history(id)
- campaign_targeting_setting_history(updated_at) → campaign_history(id)
- ad_label_history(ad_id) → ad_history(id)
- ad_label_history(ad_group_id) → ad_history(id)
- ad_label_history(updated_at) → ad_history(id)
- ad_label_history(label_id) → label(id)
- ad_policy_topic_history(ad_id) → ad_history(id)
- ad_policy_topic_history(ad_group_id) → ad_history(id)
- ad_policy_topic_history(updated_at) → ad_history(id)
- campaign_dynamic_search_ads_setting_history(campaign_id) → campaign_history(id)
- campaign_dynamic_search_ads_setting_history(updated_at) → campaign_history(id)
- campaign_app_campaign_setting_history(campaign_id) → campaign_history(id)
- campaign_app_campaign_setting_history(updated_at) → campaign_history(id)
- expanded_text_ad_history(ad_id) → ad_history(id)
- expanded_text_ad_history(ad_group_id) → ad_history(id)
- expanded_text_ad_history(updated_at) → ad_history(id)
- image_ad_history(ad_id) → ad_history(id)
- image_ad_history(ad_group_id) → ad_history(id)
- image_ad_history(updated_at) → ad_history(id)
- ad_group_bidding_strategy_history(ad_group_id) → ad_group_history(id)
- ad_group_bidding_strategy_history(updated_at) → ad_group_history(id)
- campaign_geo_target_type_setting_history(campaign_id) → campaign_history(id)
- campaign_geo_target_type_setting_history(updated_at) → campaign_history(id)
- ad_history(ad_group_id) → ad_group_history(id)
- topic(parent_topic_id) → topic(id)
- video_responsive_ad_history(ad_id) → ad_history(id)
- video_responsive_ad_history(ad_group_id) → ad_history(id)
- video_responsive_ad_history(updated_at) → ad_history(id)
- ad_group_criterion_label_history(criterion_id) → ad_group_criterion_history(id)
- ad_group_criterion_label_history(ad_group_id) → ad_group_criterion_history(id)
- ad_group_criterion_label_history(updated_at) → ad_group_criterion_history(id)
- ad_group_criterion_label_history(label_id) → label(id)
- campaign_criterion_proximity_history(criterion_id) → campaign_criterion_history(id)
- campaign_criterion_proximity_history(campaign_id) → campaign_criterion_history(id)
- campaign_criterion_proximity_history(updated_at) → campaign_criterion_history(id)
- campaign_network_setting_history(campaign_id) → campaign_history(id)
- campaign_network_setting_history(updated_at) → campaign_history(id)
- campaign_asset_automation_setting_history(campaign_id) → campaign_history(id)
- campaign_asset_automation_setting_history(updated_at) → campaign_history(id)
- ad_group_label_history(ad_group_id) → ad_group_history(id)
- ad_group_label_history(updated_at) → ad_group_history(id)
- ad_group_label_history(label_id) → label(id)
- shared_set_history(customer_id) → account_history(id)
- campaign_criterion_keyword_theme_history(criterion_id) → campaign_criterion_history(id)
- campaign_criterion_keyword_theme_history(campaign_id) → campaign_criterion_history(id)
- campaign_criterion_keyword_theme_history(updated_at) → campaign_criterion_history(id)
- campaign_shared_set_history(campaig_id) → campaign_history(id)
- campaign_shared_set_history(shared_set_id) → shared_set_history(id)
- ad_group_custom_parameter_history(ad_group_id) → ad_group_history(id)
- ad_group_custom_parameter_history(updated_at) → ad_group_history(id)
- display_upload_ad_history(ad_id) → ad_history(id)
- display_upload_ad_history(ad_group_id) → ad_history(id)
- display_upload_ad_history(updated_at) → ad_history(id)
- campaign_bid_modifier_history(campaign_id) → campaign_history(id)
- campaign_bid_modifier_history(updated_at) → campaign_history(id)
- campaign_optimization_goal_setting_history(campaign_id) → campaign_history(id)
- campaign_optimization_goal_setting_history(updated_at) → campaign_history(id)
- ad_policy_topic_evidence_history(ad_id) → ad_policy_topic_history(sequence_id)
- ad_policy_topic_evidence_history(ad_group_id) → ad_policy_topic_history(sequence_id)
- ad_policy_topic_evidence_history(updated_at) → ad_policy_topic_history(sequence_id)
- ad_policy_topic_evidence_history(policy_topic_sequence_id) → ad_policy_topic_history(sequence_id)
- campaign_criterion_listing_scope_dimension_history(criterion_id) → campaign_criterion_history(id)
- campaign_criterion_listing_scope_dimension_history(campaign_id) → campaign_criterion_history(id)
- campaign_criterion_listing_scope_dimension_history(updated_at) → campaign_criterion_history(id)
- ad_group_bid_modifier_history(ad_group_id) → ad_group_history(id)
- ad_group_bid_modifier_history(updated_at) → ad_group_history(id)
- shopping_smart_ad_history(ad_id) → ad_history(id)
- shopping_smart_ad_history(ad_group_id) → ad_history(id)
- shopping_smart_ad_history(updated_at) → ad_history(id)
- ad_group_criterion_history(ad_group_id) → ad_group_history(id)
- ad_group_criterion_history(user_interest_id) → user_interest(id)
- ad_group_criterion_history(user_list_id) → user_list(id)
- ad_group_criterion_history(custom_audience_id) → custom_audience(id)
- ad_group_criterion_history(audience_id) → audience(id)
- ad_group_criterion_history(combined_audience_id) → combined_audience(id)
- ad_listing_group_criterion_history(criterion_id) → ad_group_criterion_history(id)
- ad_listing_group_criterion_history(ad_group_id) → ad_group_criterion_history(id)
- ad_listing_group_criterion_history(updated_at) → ad_group_criterion_history(id)
- campaign_real_time_bidding_setting_history(campaign_id) → campaign_history(id)
- campaign_real_time_bidding_setting_history(updated_at) → campaign_history(id)
- user_interest(parent_id) → user_interest(id)
- campaign_tracking_setting_history(campaign_id) → campaign_history(id)
- campaign_tracking_setting_history(updated_at) → campaign_history(id)