Google Ads

Explore the interactive ERD

Table & Field Reference

text_ad_history

Column	Type	Keys
`ad_group_id`	Long	PKFK
`ad_id`	Long	PKFK
`updated_at`	Instant	PKFK
`description_1`	String
`description_2`	String
`headline`	String

legacy_app_install_ad_history

Column	Type	Keys
`ad_group_id`	Long	PKFK
`ad_id`	Long	PKFK
`updated_at`	Instant	PKFK
`app_id`	String
`app_store`	String
`description_1`	String
`description_2`	String
`headline`	String

app_engagement_ad_history

Column	Type	Keys
`ad_group_id`	Long	PKFK
`ad_id`	Long	PKFK
`updated_at`	Instant	PKFK
`descriptions`	String
`headlines`	String

shopping_comparison_listing_ad_history

Column	Type	Keys
`ad_group_id`	Long	PKFK
`ad_id`	Long	PKFK
`updated_at`	Instant	PKFK
`headline`	String

demand_gen_product_ad_history

Column	Type	Keys
`ad_group_id`	Long	PKFK
`ad_id`	Long	PKFK
`updated_at`	Instant	PKFK
`breadcrumb_1`	String
`breadcrumb_2`	String
`business_name`	String
`call_to_action_asset`	String
`description`	String
`headline`	String
`logo_image_asset`	String

campaign_bid_modifier_history

Column	Type	Keys
`criterion_id`	Long	PK
`campaign_id`	Long	PKFK
`updated_at`	Instant	PKFK
`bid_modifier`	Double
`interaction_event_types`	String
`interaction_type`	String

campaign_conversion_goal_history

Column	Type	Keys
`resource_name`	String	PK
`campaign_id`	Long	PKFK
`updated_at`	Instant	PKFK
`biddable`	Boolean
`category`	String
`origin`	String

mobile_device

Column	Type	Keys
`id`	Long	PK
`manufacturer_name`	String
`name`	String
`operating_system_name`	String
`type`	String

campaign_targeting_setting_history

Column	Type	Keys
`sequence_id`	Int	PK
`campaign_id`	Long	PKFK
`updated_at`	Instant	PKFK
`bid_only`	Boolean
`targeting_dimension`	String

ad_group_criterion_custom_parameter_history

Column	Type	Keys
`sequence_id`	Int	PK
`ad_group_id`	Long	PKFK
`criterion_id`	Long	PKFK
`updated_at`	Instant	PKFK
`key`	String
`value`	String

campaign_hotel_setting_history

Column	Type	Keys
`campaign_id`	Long	PKFK
`updated_at`	Instant	PKFK
`hotel_center_id`	Long

campaign_geo_target_type_setting_history

Column	Type	Keys
`campaign_id`	Long	PKFK
`updated_at`	Instant	PKFK
`negative_geo_target_type`	String
`positive_geo_target_type`	String

campaign_label_history

Column	Type	Keys
`campaign_id`	Long	PKFK
`label_id`	Long	PKFK
`updated_at`	Instant	PKFK

user_interest

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

campaign_dynamic_search_ads_setting_history

Column	Type	Keys
`campaign_id`	Long	PKFK
`updated_at`	Instant	PKFK
`domain_name`	String
`language_code`	String
`use_supplied_urls_only`	Boolean

ad_group_bid_modifier_history

Column	Type	Keys
`criterion_id`	Long	PK
`ad_group_id`	Long	PKFK
`updated_at`	Instant	PKFK
`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

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

responsive_search_ad_history

Column	Type	Keys
`ad_group_id`	Long	PKFK
`ad_id`	Long	PKFK
`updated_at`	Instant	PKFK
`descriptions`	String
`headlines`	String
`path_1`	String
`path_2`	String

display_upload_ad_history

Column	Type	Keys
`ad_group_id`	Long	PKFK
`ad_id`	Long	PKFK
`updated_at`	Instant	PKFK
`display_upload_product_type`	String

ad_custom_parameter_history

Column	Type	Keys
`sequence_id`	Int	PK
`ad_group_id`	Long	PKFK
`ad_id`	Long	PKFK
`updated_at`	Instant	PKFK
`key`	String
`value`	String

ad_history

Column	Type	Keys
`id`	Long	PK
`updated_at`	Instant	PK
`ad_group_id`	Long	PKFK
`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

responsive_display_ad_history

Column	Type	Keys
`ad_group_id`	Long	PKFK
`ad_id`	Long	PKFK
`updated_at`	Instant	PKFK
`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

call_ad_history

Column	Type	Keys
`ad_group_id`	Long	PKFK
`ad_id`	Long	PKFK
`updated_at`	Instant	PKFK
`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

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

campaign_criterion_keyword_theme_history

Column	Type	Keys
`campaign_id`	Long	PKFK
`criterion_id`	Long	PKFK
`updated_at`	Instant	PKFK
`country_code`	String
`display_name`	String
`language_code`	String

video_responsive_ad_history

Column	Type	Keys
`ad_group_id`	Long	PKFK
`ad_id`	Long	PKFK
`updated_at`	Instant	PKFK
`breadcrumb_1`	String
`breadcrumb_2`	String
`call_to_actions`	String
`descriptions`	String
`headlines`	String
`long_headlines`	String

campaign_bidding_strategy_history

Column	Type	Keys
`campaign_id`	Long	PKFK
`updated_at`	Instant	PKFK
`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

image_ad_history

Column	Type	Keys
`ad_group_id`	Long	PKFK
`ad_id`	Long	PKFK
`updated_at`	Instant	PKFK
`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

campaign_shopping_setting_history

Column	Type	Keys
`campaign_id`	Long	PKFK
`updated_at`	Instant	PKFK
`campaign_priority`	Int
`enable_local`	Boolean
`feed_label`	String
`merchant_id`	Long

campaign_optimization_goal_setting_history

Column	Type	Keys
`sequence_id`	Int	PK
`campaign_id`	Long	PKFK
`updated_at`	Instant	PKFK
`optimization_goal_type`	String

operating_system_version

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

ad_group_custom_parameter_history

Column	Type	Keys
`sequence_id`	Int	PK
`ad_group_id`	Long	PKFK
`updated_at`	Instant	PKFK
`key`	String
`value`	String

app_ad_history

Column	Type	Keys
`ad_group_id`	Long	PKFK
`ad_id`	Long	PKFK
`updated_at`	Instant	PKFK
`descriptions`	String
`headlines`	String
`mandatory_ad_text`	String

campaign_network_setting_history

Column	Type	Keys
`campaign_id`	Long	PKFK
`updated_at`	Instant	PKFK
`target_content_network`	Boolean
`target_google_search`	Boolean
`target_partner_search_network`	Boolean
`target_search_network`	Boolean

video_ad_history

Column	Type	Keys
`ad_group_id`	Long	PKFK
`ad_id`	Long	PKFK
`updated_at`	Instant	PKFK
`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

ad_group_criterion_label_history

Column	Type	Keys
`ad_group_id`	Long	PKFK
`criterion_id`	Long	PKFK
`label_id`	Long	PKFK
`updated_at`	Instant	PKFK

legacy_responsive_display_ad_history

Column	Type	Keys
`ad_group_id`	Long	PKFK
`ad_id`	Long	PKFK
`updated_at`	Instant	PKFK
`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

ad_policy_topic_history

Column	Type	Keys
`sequence_id`	Int	PK
`ad_group_id`	Long	PKFK
`ad_id`	Long	PKFK
`updated_at`	Instant	PKFK
`topic`	String
`type`	String

campaign_tracking_setting_history

Column	Type	Keys
`campaign_id`	Long	PKFK
`updated_at`	Instant	PKFK
`tracking_url`	String

campaign_criterion_proximity_history

Column	Type	Keys
`campaign_id`	Long	PKFK
`criterion_id`	Long	PKFK
`updated_at`	Instant	PKFK
`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

topic

Column	Type	Keys
`id`	Long	PK
`parent_topic_id`	Long	FK
`path`	String

ad_policy_topic_evidence_history

Column	Type	Keys
`sequence_id`	Int	PK
`ad_group_id`	Long	PKFK
`ad_id`	Long	PKFK
`policy_topic_sequence_id`	Int	PKFK
`updated_at`	Instant	PKFK
`type`	String
`value`	String

campaign_asset_automation_setting_history

Column	Type	Keys
`sequence_id`	Int	PK
`campaign_id`	Long	PKFK
`updated_at`	Instant	PKFK
`asset_automation_status`	String
`asset_automation_type`	String

campaign_real_time_bidding_setting_history

Column	Type	Keys
`campaign_id`	Long	PKFK
`updated_at`	Instant	PKFK
`opt_in`	Boolean

hotel_ad_history

Column	Type	Keys
`ad_group_id`	Long	PKFK
`ad_id`	Long	PKFK
`updated_at`	Instant	PKFK
`hotel_ad`	String

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

account_label_history

Column	Type	Keys
`account_id`	Long	PKFK
`label_id`	Long	PKFK
`updated_at`	Instant	PKFK

campaign_criterion_ad_schedule_history

Column	Type	Keys
`campaign_id`	Long	PKFK
`criterion_id`	Long	PKFK
`updated_at`	Instant	PKFK
`day_of_week`	String
`end_hour`	Int
`end_minute`	String
`start_hour`	Int
`start_minute`	String

ad_policy_topic_constraint_history

Column	Type	Keys
`sequence_id`	Int	PK
`ad_group_id`	Long	PKFK
`ad_id`	Long	PKFK
`policy_topic_sequence_id`	Int	PKFK
`updated_at`	Instant	PKFK
`constrained_countries`	String
`reseller_constraint`	String
`total_targeted_countries`	Int
`type`	String

ad_group_criterion_history

Column	Type	Keys
`id`	Long	PK
`updated_at`	Instant	PK
`ad_group_id`	Long	PKFK
`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

campaign_criterion_history

Column	Type	Keys
`id`	Long	PK
`updated_at`	Instant	PK
`campaign_id`	Long	PKFK
`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

ad_listing_group_criterion_history

Column	Type	Keys
`ad_group_id`	Long	PKFK
`criterion_id`	Long	PKFK
`updated_at`	Instant	PKFK
`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

ad_group_label_history

Column	Type	Keys
`ad_group_id`	Long	PKFK
`label_id`	Long	PKFK
`updated_at`	Instant	PKFK

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

custom_audience

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

shared_criterion_history

Column	Type	Keys
`id`	Long	PK
`shared_set_id`	Long	PKFK
`updated_at`	Instant	PKFK
`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

campaign_shared_set_history

Column	Type	Keys
`updated_at`	Instant	PK
`campaig_id`	Long	PKFK
`shared_set_id`	Long	PKFK
`campaign_id`	Long
`status`	String

expanded_dynamic_search_ad_history

Column	Type	Keys
`ad_group_id`	Long	PKFK
`ad_id`	Long	PKFK
`updated_at`	Instant	PKFK
`description`	String
`description_2`	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
`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

campaign_local_setting_history

Column	Type	Keys
`campaign_id`	Long	PKFK
`updated_at`	Instant	PKFK
`location_source_type`	String

local_ad_history

Column	Type	Keys
`ad_group_id`	Long	PKFK
`ad_id`	Long	PKFK
`updated_at`	Instant	PKFK
`call_to_actions`	String
`descriptions`	String
`headlines`	String
`path_1`	String
`path_2`	String

demand_gen_carousel_ad_history

Column	Type	Keys
`ad_group_id`	Long	PKFK
`ad_id`	Long	PKFK
`updated_at`	Instant	PKFK
`business_name`	String
`call_to_action_text`	String
`carousel_cards`	String
`description`	String
`headline`	String

ad_label_history

Column	Type	Keys
`ad_group_id`	Long	PKFK
`ad_id`	Long	PKFK
`label_id`	Long	PKFK
`updated_at`	Instant	PKFK

expanded_text_ad_history

Column	Type	Keys
`ad_group_id`	Long	PKFK
`ad_id`	Long	PKFK
`updated_at`	Instant	PKFK
`description`	String
`description_2`	String
`headline_part_1`	String
`headline_part_2`	String
`headline_part_3`	String
`path_1`	String
`path_2`	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	PKFK
`updated_at`	Instant	PKFK
`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

label

Column	Type	Keys
`id`	Long	PK
`name`	String
`status`	String
`text_label_background_color`	String
`text_label_description`	String

ad_group_bidding_strategy_history

Column	Type	Keys
`ad_group_id`	Long	PKFK
`updated_at`	Instant	PKFK
`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

smart_campaign_ad_history

Column	Type	Keys
`ad_group_id`	Long	PKFK
`ad_id`	Long	PKFK
`updated_at`	Instant	PKFK
`descriptions`	String
`headlines`	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

shopping_product_ad_history

Column	Type	Keys
`ad_group_id`	Long	PKFK
`ad_id`	Long	PKFK
`updated_at`	Instant	PKFK
`shopping_product_ad`	String

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_app_campaign_setting_history

Column	Type	Keys
`campaign_id`	Long	PKFK
`updated_at`	Instant	PKFK
`app_id`	String
`app_store`	String
`bidding_strategy_goal_type`	String

campaign_criterion_listing_scope_dimension_history

Column	Type	Keys
`sequence_id`	Int	PK
`campaign_id`	Long	PKFK
`criterion_id`	Long	PKFK
`updated_at`	Instant	PKFK
`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

shopping_smart_ad_history

Column	Type	Keys
`ad_group_id`	Long	PKFK
`ad_id`	Long	PKFK
`updated_at`	Instant	PKFK
`shopping_smart_ad`	String

demand_gen_multi_asset_ad_history

Column	Type	Keys
`ad_group_id`	Long	PKFK
`ad_id`	Long	PKFK
`updated_at`	Instant	PKFK
`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