Yahoo Search Ads on Yahoo Japan

Explore the interactive ERD

Table & Field Reference

campaign_target_list

Column	Type	Keys
`_fivetran_id`	String	PK
`account_id`	Unknown	FK
`campaign_id`	Unknown	FK
`all_conv`	Unknown
`all_conv_rate`	Unknown
`all_conv_value`	Unknown
`all_conv_value_per_cost`	Unknown
`avg_cpc`	Unknown
`bid_adjustment_percentage`	Unknown
`campaign_tracking_id`	Unknown
`click_type`	Unknown
`clicks`	Unknown
`conv`	Unknown
`conv_rate`	Unknown
`conv_value`	Unknown
`conv_value_per_cost`	Unknown
`conversions`	Unknown
`conversions_across_devices`	Unknown
`cost`	Unknown
`cost_per_all_conv`	Unknown
`ctr`	Unknown
`day`	Unknown
`device`	Unknown
`id`	Unknown
`impressions`	Unknown
`name`	Unknown
`per`	Unknown
`reach_status`	Unknown
`show_ads_on`	Unknown
`target_list_tracking_id`	Unknown
`value_per_all_conv`	Unknown
`value_per_conv`	Unknown

Column	Type	Keys
`_fivetran_id`	String	PK
`account_id`	Unknown	FK
`ad_group_id`	Unknown	FK
`campaign_id`	Unknown	FK
`ad_group_tracking_id`	Unknown
`ad_tracking_id`	Unknown
`all_conv`	Unknown
`all_conv_rate`	Unknown
`all_conv_value`	Unknown
`all_conv_value_per_cost`	Unknown
`avg_cpc`	Unknown
`campaign_tracking_id`	Unknown
`click_type`	Unknown
`clicks`	Unknown
`conv_rate`	Unknown
`conv_value`	Unknown
`conv_value_per_cost`	Unknown
`conversion_name`	Unknown
`conversions`	Unknown
`conversions_across_devices`	Unknown
`cost`	Unknown
`cost_per_all_conv`	Unknown
`cost_per_conv`	Unknown
`ctr`	Unknown
`custom_parameters`	Unknown
`day`	Unknown
`description_1`	Unknown
`description_1_asset`	Unknown
`description_2`	Unknown
`description_2_asset`	Unknown
`description_3_asset`	Unknown
`description_4_asset`	Unknown
`destination_url`	Unknown
`device`	Unknown
`directory_1`	Unknown
`directory_2`	Unknown
`display_url`	Unknown
`distribution_settings`	Unknown
`editorial_status`	Unknown
`final_url`	Unknown
`focus_device`	Unknown
`id`	Unknown
`impressions`	Unknown
`label`	Unknown
`name`	Unknown
`objective_of_conversion_tracking`	Unknown
`search_absolute_top_impression_rate`	Unknown
`search_top_impression_rate`	Unknown
`show_ads_on`	Unknown
`smartphone_final_url`	Unknown
`title_1`	Unknown
`title_10_asset`	Unknown
`title_11_asset`	Unknown
`title_12_asset`	Unknown
`title_13_asset`	Unknown
`title_14_asset`	Unknown
`title_15_asset`	Unknown
`title_1_asset`	Unknown
`title_2`	Unknown
`title_2_asset`	Unknown
`title_3`	Unknown
`title_3_asset`	Unknown
`title_4_asset`	Unknown
`title_5_asset`	Unknown
`title_6_asset`	Unknown
`title_7_asset`	Unknown
`title_8_asset`	Unknown
`title_9_asset`	Unknown
`tracking_url`	Unknown
`type`	Unknown
`value_per_all_conv`	Unknown
`value_per_conv`	Unknown

search_query

Column	Type	Keys
`_fivetran_id`	String	PK
`account_id`	Unknown	FK
`ad_group_id`	Unknown	FK
`campaign_id`	Unknown	FK
`keyword_id`	Unknown	FK
`ad_group_tracking_id`	Unknown
`all_conv`	Unknown
`all_conv_rate`	Unknown
`all_conv_value`	Unknown
`all_conv_value_per_cost`	Unknown
`avg_cpc`	Unknown
`campaign_tracking_id`	Unknown
`clicks`	Unknown
`conv_rate`	Unknown
`conv_value`	Unknown
`conv_value_per_cost`	Unknown
`conversions`	Unknown
`conversions_across_devices`	Unknown
`cost`	Unknown
`cost_per_all_conv`	Unknown
`cost_per_conv`	Unknown
`ctr`	Unknown
`day`	Unknown
`device`	Unknown
`final_url`	Unknown
`impressions`	Unknown
`keyword_negative_keyword`	Unknown
`keyword_tracking_id`	Unknown
`search_absolute_top_impression_rate`	Unknown
`search_query`	Unknown
`search_query_match_type`	Unknown
`search_top_impression_rate`	Unknown
`show_ads_on`	Unknown
`tracking_url`	Unknown
`value_per_all_conv`	Unknown
`value_per_conv`	Unknown

keyword

Column	Type	Keys
`_fivetran_id`	String	PK
`account_id`	Unknown	FK
`ad_group_id`	Unknown	FK
`campaign_id`	Unknown	FK
`ad_group_tracking_id`	Unknown
`ad_relevance`	Unknown
`ad_relevance_hist`	Unknown
`all_conv`	Unknown
`all_conv_rate`	Unknown
`all_conv_value`	Unknown
`all_conv_value_per_cost`	Unknown
`avg_cpc`	Unknown
`bid_jpy`	Unknown
`campaign_tracking_id`	Unknown
`click_type`	Unknown
`clicks`	Unknown
`conv_rate`	Unknown
`conv_value`	Unknown
`conv_value_per_cost`	Unknown
`conversions`	Unknown
`conversions_across_devices`	Unknown
`cost`	Unknown
`cost_per_all_conv`	Unknown
`cost_per_conv`	Unknown
`ctr`	Unknown
`custom_parameters`	Unknown
`custom_url`	Unknown
`day`	Unknown
`device`	Unknown
`distribution_settings`	Unknown
`editorial_status`	Unknown
`exact_match_impression_share`	Unknown
`expected_ctr`	Unknown
`expected_ctr_hist`	Unknown
`final_url`	Unknown
`first_page_bid_estimate`	Unknown
`id`	Unknown
`impression_share`	Unknown
`impressions`	Unknown
`keyword`	Unknown
`label`	Unknown
`landing_page_experience`	Unknown
`landing_page_experience_hist`	Unknown
`match_type`	Unknown
`negative_keywords`	Unknown
`quality_index`	Unknown
`quality_index_hist`	Unknown
`quality_lost_impression_share`	Unknown
`search_absolute_top_impression_rate`	Unknown
`search_absolute_top_impression_share`	Unknown
`search_lost_absolute_top_impression_share_budget`	Unknown
`search_lost_absolute_top_impression_share_rank`	Unknown
`search_lost_top_impression_share_budget`	Unknown
`search_lost_top_impression_share_rank`	Unknown
`search_top_impression_rate`	Unknown
`search_top_impression_share`	Unknown
`show_ads_on`	Unknown
`smartphone_final_url`	Unknown
`status`	Unknown
`top_of_page_bid_estimate`	Unknown
`tracking_id`	Unknown
`tracking_url`	Unknown
`value_per_all_conv`	Unknown
`value_per_conv`	Unknown

schedule_target

Column	Type	Keys
`_fivetran_id`	String	PK
`account_id`	Unknown	FK
`campaign_id`	Unknown	FK
`all_conv`	Unknown
`all_conv_rate`	Unknown
`all_conv_value`	Unknown
`all_conv_value_per_cost`	Unknown
`avg_cpc`	Unknown
`bid_adjustment_percentage`	Unknown
`campaign_tracking_id`	Unknown
`clicks`	Unknown
`conv_rate`	Unknown
`conv_value`	Unknown
`conv_value_per_cost`	Unknown
`conversions`	Unknown
`conversions_across_devices`	Unknown
`cost`	Unknown
`cost_per_all_conv`	Unknown
`cost_per_conv`	Unknown
`ctr`	Unknown
`day`	Unknown
`impressions`	Unknown
`query_targeting_status`	Unknown
`target_schedule`	Unknown
`target_schedule_id`	Unknown
`value_per_all_conv`	Unknown
`value_per_conv`	Unknown

adgroup_target_list

Column	Type	Keys
`_fivetran_id`	String	PK
`account_id`	Unknown	FK
`ad_group_id`	Unknown	FK
`campaign_id`	Unknown	FK
`ad_group_tracking_id`	Unknown
`all_conv`	Unknown
`all_conv_rate`	Unknown
`all_conv_value`	Unknown
`all_conv_value_per_cost`	Unknown
`avg_cpc`	Unknown
`bid_adjustment_percentage`	Unknown
`campaign_tracking_id`	Unknown
`click_type`	Unknown
`clicks`	Unknown
`conv_rate`	Unknown
`conv_value`	Unknown
`conv_value_per_cost`	Unknown
`conversions`	Unknown
`conversions_across_devices`	Unknown
`cost`	Unknown
`cost_per_all_conv`	Unknown
`cost_per_conv`	Unknown
`ctr`	Unknown
`day`	Unknown
`device`	Unknown
`id`	Unknown
`impressions`	Unknown
`name`	Unknown
`reach_status`	Unknown
`show_ads_on`	Unknown
`target_list_tracking_id`	Unknown
`value_per_all_conv`	Unknown
`value_per_conv`	Unknown

geo

Column	Type	Keys
`_fivetran_id`	String	PK
`account_id`	Unknown	FK
`ad_group_id`	Unknown	FK
`campaign_id`	Unknown	FK
`ad_group_tracking_id`	Unknown
`all_conv`	Unknown
`all_conv_rate`	Unknown
`all_conv_value`	Unknown
`all_conv_value_per_cost`	Unknown
`avg_cpc`	Unknown
`campaign_tracking_id`	Unknown
`city`	Unknown
`clicks`	Unknown
`conv_rate`	Unknown
`conv_value`	Unknown
`conv_value_per_cost`	Unknown
`conversions`	Unknown
`conversions_across_devices`	Unknown
`cost`	Unknown
`cost_per_all_conv`	Unknown
`cost_per_conv`	Unknown
`country_territory`	Unknown
`ctr`	Unknown
`day`	Unknown
`device`	Unknown
`impressions`	Unknown
`location`	Unknown
`location_type`	Unknown
`metro_area`	Unknown
`prefecture`	Unknown
`show_ads_on`	Unknown
`value_per_all_conv`	Unknown
`value_per_conv`	Unknown

campaign_asset

Column	Type	Keys
`_fivetran_id`	String	PK
`account_id`	Unknown	FK
`campaign_id`	Unknown	FK
`ad_display_option_id`	Unknown
`ad_display_option_tracking_id`	Unknown
`ad_display_option_type`	Unknown
`all_conv`	Unknown
`all_conv_rate`	Unknown
`all_conv_value`	Unknown
`all_conv_value_per_cost`	Unknown
`avg_cpc`	Unknown
`callout`	Unknown
`campaign_tracking_id`	Unknown
`category`	Unknown
`click_type`	Unknown
`clicks`	Unknown
`conv_rate`	Unknown
`conv_value`	Unknown
`conv_value_per_cost`	Unknown
`conversions`	Unknown
`conversions_across_devices`	Unknown
`cost`	Unknown
`cost_per_all_conv`	Unknown
`cost_per_conv`	Unknown
`ctr`	Unknown
`custom_parameters`	Unknown
`day`	Unknown
`device`	Unknown
`editorial_status`	Unknown
`end_date`	Unknown
`final_url`	Unknown
`impressions`	Unknown
`phone_number`	Unknown
`quick_link_description_1`	Unknown
`quick_link_description_2`	Unknown
`quick_link_text`	Unknown
`show_ads_on`	Unknown
`smartphone_final_url`	Unknown
`start_date`	Unknown
`text`	Unknown
`tracking_url`	Unknown
`value_per_all_conv`	Unknown
`value_per_conv`	Unknown

adgroup

Column	Type	Keys
`_fivetran_id`	String	PK
`account_id`	Unknown	FK
`campaign_id`	Unknown	FK
`ad_group_tracking_id`	Unknown
`all_conv`	Unknown
`all_conv_rate`	Unknown
`all_conv_value`	Unknown
`all_conv_value_per_cost`	Unknown
`avg_cpc`	Unknown
`bid`	Unknown
`campaign_tracking_id`	Unknown
`clicks`	Unknown
`conv_rate`	Unknown
`conv_value`	Unknown
`conv_value_per_cost`	Unknown
`conversions`	Unknown
`conversions_across_devices`	Unknown
`cost`	Unknown
`cost_per_all_conv`	Unknown
`cost_per_conv`	Unknown
`ctr`	Unknown
`custom_parameters`	Unknown
`day`	Unknown
`device`	Unknown
`exact_match_impression_share`	Unknown
`id`	Unknown
`impression_share`	Unknown
`impressions`	Unknown
`label`	Unknown
`name`	Unknown
`objective_of_conversion_tracking`	Unknown
`quality_lost_impression_share`	Unknown
`search_absolute_top_impression_rate`	Unknown
`search_absolute_top_impression_share`	Unknown
`search_lost_absolute_top_impression_share_budget`	Unknown
`search_lost_absolute_top_impression_share_rank`	Unknown
`search_lost_top_impression_share_budget`	Unknown
`search_lost_top_impression_share_rank`	Unknown
`search_top_impression_rate`	Unknown
`search_top_impression_share`	Unknown
`show_ads_on`	Unknown
`tracking_url`	Unknown
`value_per_all_conv`	Unknown
`value_per_conv`	Unknown

geo_target

Column	Type	Keys
`_fivetran_id`	String	PK
`account_id`	Unknown	FK
`campaign_id`	Unknown	FK
`all_conv`	Unknown
`all_conv_rate`	Unknown
`all_conv_value`	Unknown
`all_conv_value_per_cost`	Unknown
`avg_cpc`	Unknown
`bid_adjustment_percentage`	Unknown
`campaign_tracking_id`	Unknown
`clicks`	Unknown
`conv_rate`	Unknown
`conv_value`	Unknown
`conv_value_per_cost`	Unknown
`conversions`	Unknown
`conversions_across_devices`	Unknown
`cost`	Unknown
`cost_per_all_conv`	Unknown
`cost_per_conv`	Unknown
`ctr`	Unknown
`day`	Unknown
`impressions`	Unknown
`target_location_id`	Unknown
`target_location_name`	Unknown
`value_per_all_conv`	Unknown
`value_per_conv`	Unknown

webpage_criterion

Column	Type	Keys
`_fivetran_id`	String	PK
`account_id`	Unknown	FK
`ad_group_id`	Unknown	FK
`campaign_id`	Unknown	FK
`ad_group_tracking_id`	Unknown
`all_conv`	Unknown
`all_conv_rate`	Unknown
`all_conv_value`	Unknown
`all_conv_value_per_cost`	Unknown
`avg_cpc`	Unknown
`bid_adjustment_percentage`	Unknown
`campaign_tracking_id`	Unknown
`click_type`	Unknown
`clicks`	Unknown
`conv_rate`	Unknown
`conv_value`	Unknown
`conv_value_per_cost`	Unknown
`conversions`	Unknown
`conversions_across_devices`	Unknown
`cost`	Unknown
`cost_per_all_conv`	Unknown
`cost_per_conv`	Unknown
`ctr`	Unknown
`day`	Unknown
`device`	Unknown
`impressions`	Unknown
`search_absolute_top_impression_rate`	Unknown
`search_top_impression_rate`	Unknown
`show_ads_on`	Unknown
`target_page_id`	Unknown
`target_page_tracking_id`	Unknown
`value_per_all_conv`	Unknown
`value_per_conv`	Unknown

account

Column	Type	Keys
`_fivetran_id`	String	PK
`all_conv`	Unknown
`all_conv_rate`	Unknown
`all_conv_value`	Unknown
`all_conv_value_per_cost`	Unknown
`avg_cpc`	Unknown
`budget_lost_impression_share`	Unknown
`click_type`	Unknown
`clicks`	Unknown
`conv_rate`	Unknown
`conv_value`	Unknown
`conv_value_per_cost`	Unknown
`conversions`	Unknown
`conversions_across_devices`	Unknown
`cost`	Unknown
`cost_per_all_conv`	Unknown
`cost_per_conv`	Unknown
`ctr`	Unknown
`day`	Unknown
`device`	Unknown
`exact_match_impression_share`	Unknown
`id`	Unknown
`impression_share`	Unknown
`impressions`	Unknown
`invalid_click_rate`	Unknown
`invalid_clicks`	Unknown
`name`	Unknown
`objective_of_conversion_tracking`	Unknown
`quality_lost_impression_share`	Unknown
`show_ads_on`	Unknown
`tracking_url`	Unknown
`value_per_all_conv`	Unknown
`value_per_conv`	Unknown

responsive_ads_search_asset

Column	Type	Keys
`_fivetran_id`	String	PK
`account_id`	Unknown	FK
`ad_group_id`	Unknown	FK
`ad_id`	Unknown	FK
`campaign_id`	Unknown	FK
`asset`	Unknown
`asset_type`	Unknown
`day`	Unknown
`impressions`	Unknown
`performance_rating`	Unknown
`position_pinning`	Unknown
`show_ads_on`	Unknown

landing_page_url

Column	Type	Keys
`_fivetran_id`	String	PK
`account_id`	Unknown	FK
`ad_group_id`	Unknown	FK
`campaign_id`	Unknown	FK
`ad_group_tracking_id`	Unknown
`all_conv`	Unknown
`all_conv_rate`	Unknown
`all_conv_value`	Unknown
`all_conv_value_per_cost`	Unknown
`avg_cpc`	Unknown
`campaign_tracking_id`	Unknown
`clicks`	Unknown
`conv_rate`	Unknown
`conv_value`	Unknown
`conv_value_per_cost`	Unknown
`conversion_name`	Unknown
`conversions`	Unknown
`conversions_across_devices`	Unknown
`cost`	Unknown
`cost_per_all_conv`	Unknown
`cost_per_conv`	Unknown
`ctr`	Unknown
`day`	Unknown
`device`	Unknown
`expanded_landing_page_url`	Unknown
`impressions`	Unknown
`landing_page_url`	Unknown
`objective_of_conversion_tracking`	Unknown
`show_ads_on`	Unknown
`value_per_all_conv`	Unknown
`value_per_conv`	Unknown

bid_strategy

Column	Type	Keys
`_fivetran_id`	String	PK
`account_id`	Unknown	FK
`campaign_id`	Unknown	FK
`ad_position`	Unknown
`all_conv`	Unknown
`all_conv_rate`	Unknown
`all_conv_value`	Unknown
`all_conv_value_per_cost`	Unknown
`avg_cpc`	Unknown
`bid_adjustment_percentage`	Unknown
`bid_limit`	Unknown
`bid_limit_cpa`	Unknown
`bid_limit_maximize_clicks`	Unknown
`bid_limit_roas`	Unknown
`bid_strategy`	Unknown
`bidding_adjustment`	Unknown
`bidding_adjustment_method`	Unknown
`campaign`	Unknown
`campaign_tracking_id`	Unknown
`clicks`	Unknown
`conv_rate`	Unknown
`conv_value`	Unknown
`conv_value_per_cost`	Unknown
`conversions`	Unknown
`conversions_across_devices`	Unknown
`cost`	Unknown
`cost_per_all_conv`	Unknown
`cost_per_conv`	Unknown
`ctr`	Unknown
`day`	Unknown
`impressions`	Unknown
`limit_by_campaign_budget`	Unknown
`low_quality_keyword`	Unknown
`lower_bid_limit_cpa`	Unknown
`lower_bid_limit_roas`	Unknown
`portfolio_bidding_id`	Unknown
`portfolio_bidding_name`	Unknown
`target_cpa`	Unknown
`target_roas`	Unknown
`target_schedule_id`	Unknown
`value_per_all_conv`	Unknown
`value_per_conv`	Unknown

bid_modifier

Column	Type	Keys
`_fivetran_id`	String	PK
`account_id`	Unknown	FK
`ad_group_id`	Unknown	FK
`campaign_id`	Unknown	FK
`bid_adjustment_percentage`	Unknown
`device`	Unknown
`level`	Unknown

adgroup_asset

Column	Type	Keys
`_fivetran_id`	String	PK
`account_id`	Unknown	FK
`ad_group_id`	Unknown	FK
`campaign_id`	Unknown	FK
`ad_display_option_id`	Unknown
`ad_display_option_tracking_id`	Unknown
`ad_display_option_type`	Unknown
`ad_group_tracking_id`	Unknown
`all_conv`	Unknown
`all_conv_rate`	Unknown
`all_conv_value`	Unknown
`all_conv_value_per_cost`	Unknown
`avg_cpc`	Unknown
`callout`	Unknown
`campaign_tracking_id`	Unknown
`category`	Unknown
`click_type`	Unknown
`clicks`	Unknown
`conv_rate`	Unknown
`conv_value`	Unknown
`conv_value_per_cost`	Unknown
`conversion_name`	Unknown
`conversions`	Unknown
`conversions_across_devices`	Unknown
`cost`	Unknown
`cost_per_all_conv`	Unknown
`cost_per_conv`	Unknown
`ctr`	Unknown
`custom_parameters`	Unknown
`day`	Unknown
`device`	Unknown
`editorial_status`	Unknown
`end_date`	Unknown
`final_url`	Unknown
`impressions`	Unknown
`objective_of_conversion_tracking`	Unknown
`phone_number`	Unknown
`quick_link_description_1`	Unknown
`quick_link_description_2`	Unknown
`quick_link_text`	Unknown
`show_ads_on`	Unknown
`smartphone_final_url`	Unknown
`start_date`	Unknown
`text`	Unknown
`tracking_url`	Unknown
`value_per_all_conv`	Unknown
`value_per_conv`	Unknown

keywordless_query

Column	Type	Keys
`_fivetran_id`	String	PK
`account_id`	Unknown	FK
`ad_group_id`	Unknown	FK
`campaign_id`	Unknown	FK
`ad_group_tracking_id`	Unknown
`all_conv`	Unknown
`all_conv_rate`	Unknown
`all_conv_value`	Unknown
`all_conv_value_per_cost`	Unknown
`avg_cpc`	Unknown
`campaign_tracking_id`	Unknown
`clicks`	Unknown
`conv_rate`	Unknown
`conv_value`	Unknown
`conv_value_per_cost`	Unknown
`conversions`	Unknown
`conversions_across_devices`	Unknown
`cost`	Unknown
`cost_per_all_conv`	Unknown
`cost_per_conv`	Unknown
`ctr`	Unknown
`day`	Unknown
`impressions`	Unknown
`search_query`	Unknown
`title_auto_created`	Unknown
`url`	Unknown
`value_per_all_conv`	Unknown
`value_per_conv`	Unknown

campaign

Column	Type	Keys
`_fivetran_id`	String	PK
`account_id`	Unknown	FK
`absolute_top_impression_percentage`	Unknown
`all_conv`	Unknown
`all_conv_rate`	Unknown
`all_conv_value`	Unknown
`all_conv_value_per_cost`	Unknown
`avg_cpc`	Unknown
`bid_strategy_id`	Unknown
`budget_lost_impression_share`	Unknown
`campaign_end_date`	Unknown
`campaign_start_date`	Unknown
`campaign_tracking_id`	Unknown
`campaign_type`	Unknown
`click_rate`	Unknown
`clicks`	Unknown
`conv_rate`	Unknown
`conv_value`	Unknown
`conv_value_per_cost`	Unknown
`conversions`	Unknown
`cost`	Unknown
`cost_per_all_conv`	Unknown
`cost_per_conv`	Unknown
`cross_device_conversions`	Unknown
`custom_parameters`	Unknown
`daily_spending_limit`	Unknown
`day`	Unknown
`device`	Unknown
`distribution_settings`	Unknown
`distribution_status`	Unknown
`enhanced_cpc_enabled`	Unknown
`exact_match_impression_share`	Unknown
`id`	Unknown
`impression_share`	Unknown
`imps`	Unknown
`label`	Unknown
`name`	Unknown
`network`	Unknown
`quality_lost_impression_share`	Unknown
`search_absolute_top_impression_share`	Unknown
`search_budget_lost_absolute_top_impression_share`	Unknown
`search_budget_lost_top_impression_share`	Unknown
`search_rank_lost_absolute_top_impression_share`	Unknown
`search_rank_lost_top_impression_share`	Unknown
`search_top_impression_share`	Unknown
`top_impression_percentage`	Unknown
`tracking_url`	Unknown
`value_per_all_conv`	Unknown
`value_per_conv`	Unknown