Yahoo Display Ads on Yahoo Japan

Explore the interactive ERD

Table & Field Reference

conversion_tracker

Column	Type	Keys
`id`	Unknown	PK
`account_id`	Unknown	PKFK
`advanced_matching_enabled`	Unknown
`all_conversion`	Unknown
`all_conversion_value`	Unknown
`app_conversion_app_id`	Unknown
`app_conversion_platform`	Unknown
`base_account_id`	Unknown
`category`	Unknown
`compare_operator`	Unknown
`conversion`	Unknown
`conversion_value`	Unknown
`conversion_value_via_ad_click`	Unknown
`conversions_via_ad_click`	Unknown
`counting_type`	Unknown
`cross_device_conversion`	Unknown
`exclude_from_bidding`	Unknown
`is_previous_conversion`	Unknown
`measurement_period`	Unknown
`measurement_period_view`	Unknown
`most_recent_conversion_date`	Unknown
`name`	Unknown
`rule_type`	Unknown
`snippet_id`	Unknown
`status`	Unknown
`type`	Unknown
`url`	Unknown
`user_revenue_value`	Unknown
`view_through_conversion`	Unknown
`web_conversion`	Json

conversion_group_conversion

Column	Type	Keys
`index`	Unknown	PK
`account_id`	Unknown	PKFK
`conversion_group_id`	Unknown	PKFK
`conversion_tracker_id`	Unknown	FK
`status`	Unknown
`tag_id`	Unknown
`tag_name`	Unknown
`tracker_id`	Unknown

conversion_group

Column	Type	Keys
`id`	Unknown	PK
`account_id`	Unknown	PKFK
`base_account_id`	Unknown
`name`	Unknown

ad_group_ad_label

Column	Type	Keys
`index`	Unknown	PK
`account_id`	Unknown	PKFK
`ad_group_ad_id`	Unknown	PKFK
`color`	Unknown
`description`	Unknown
`id`	Unknown
`name`	Unknown

ad_group_ad

Column	Type	Keys
`id`	Unknown	PK
`account_id`	Unknown	PKFK
`ad_group_id`	Unknown	FK
`campaign_id`	Unknown	FK
`ad_type`	Unknown
`approval_status`	Unknown
`banner_ad`	Json
`base_account_id`	Unknown
`carousel_ad`	Json
`carousel_gain_friends_ad`	Json
`created_date`	Unknown
`custom_parameters`	Json
`disapproval_reason_codes`	Unknown
`disapproval_reason_description`	Unknown
`display_url`	Unknown
`display_url_level`	Unknown
`dynamic_display_ad`	Json
`final_url`	Unknown
`impression_beacon_urls`	Json
`is_remove_impression_beacon_url`	Unknown
`is_remove_smartphone_final_url`	Unknown
`is_remove_third_party_tracking_script_url`	Unknown
`is_remove_tracking_url`	Unknown
`is_remove_viewable_impression_beacon_url`	Unknown
`main_media_format`	Unknown
`media_id`	Unknown
`name`	Unknown
`responsive_ad`	Json
`responsive_gain_friends_ad`	Json
`smartphone_final_url`	Unknown
`text_ad`	Json
`third_party_tracking_script_url`	Unknown
`third_party_tracking_vendor`	Unknown
`tracking_url`	Unknown
`updated_date`	Unknown
`user_status`	Unknown
`viewable_impression_beacon_urls`	Json

campaign_label

Column	Type	Keys
`index`	Unknown	PK
`account_id`	Unknown	PKFK
`campaign_id`	Unknown	PKFK
`color`	Unknown
`description`	Unknown
`id`	Unknown
`name`	Unknown

campaign

Column	Type	Keys
`id`	Unknown	PK
`account_id`	Unknown	PKFK
`ad_group_id`	Unknown	FK
`conversion_tracker_id`	Unknown	FK
`app_id`	Unknown
`app_name`	Unknown
`app_os_type`	Unknown
`base_account_id`	Unknown
`bidding_strategy_type`	Unknown
`budget_amount`	Unknown
`budget_id`	Unknown
`budget_name`	Unknown
`cpc_bidding_scheme`	Unknown
`cpf_bidding_scheme`	Unknown
`cpv_bidding_scheme`	Unknown
`created_date`	Unknown
`custom_parameters`	Json
`delivery_type`	Unknown
`end_date`	Unknown
`end_time`	Unknown
`enhanced_cpc_enabled`	Unknown
`feed_id`	Unknown
`frequency_level`	Unknown
`frequency_time_unit`	Unknown
`goal`	Unknown
`is_remove_tracking_url`	Unknown
`maximize_conversion_target_roas`	Unknown
`maximize_conversions_target_cpa`	Unknown
`maximize_gaining_target_cpf`	Unknown
`name`	Unknown
`optimization_score`	Unknown
`optimizer_training_status`	Unknown
`serving_status`	Unknown
`skan_optimaize_ad_delivery_enabled`	Unknown
`skan_tcpa_target_type`	Unknown
`start_date`	Unknown
`start_time`	Unknown
`tracking_url`	Unknown
`updated_date`	Unknown
`user_status`	Unknown
`v_imps`	Unknown
`vcpm_bidding_scheme`	Unknown
`vendor_name`	Unknown

ad_group_label

Column	Type	Keys
`index`	Unknown	PK
`account_id`	Unknown	PKFK
`ad_group_id`	Unknown	PKFK
`color`	Unknown
`description`	Unknown
`id`	Unknown
`name`	Unknown

ad_group

Column	Type	Keys
`id`	Unknown	PK
`account_id`	Unknown	PKFK
`base_account_id`	Unknown	FK
`campaign_id`	Unknown	FK
`cpc`	Unknown
`cpf`	Unknown
`cpv`	Unknown
`created_date`	Unknown
`custom_parameters`	Json
`device`	Json
`device_app`	Json
`device_os`	Json
`device_os_version`	Unknown
`enhanced_cpc_enabled`	Unknown
`exclude_line_oa_friend_audience_list_id`	Unknown
`feed_set_id`	Unknown
`is_remove_cpc`	Unknown
`is_remove_cpf`	Unknown
`is_remove_cpv`	Unknown
`is_remove_target_cpa`	Unknown
`is_remove_target_cpf`	Unknown
`is_remove_target_roas`	Unknown
`is_remove_tracking_url`	Unknown
`is_remove_vcpm`	Unknown
`name`	Unknown
`smart_targeting_enabled`	Unknown
`target_cpa`	Unknown
`target_cpf`	Unknown
`target_roas`	Unknown
`tracking_url`	Unknown
`updated_date`	Unknown
`user_status`	Unknown
`vcpm`	Unknown

account

Column	Type	Keys
`id`	Unknown	PK
`auto_tagging_enabled`	Unknown
`base_account_id`	Unknown
`contact_biz_id`	Unknown
`delivery_status`	Unknown
`end_date`	Unknown
`is_mcc_account`	Unknown
`is_test_account`	Unknown
`name`	Unknown
`optimization_score`	Unknown
`start_date`	Unknown
`status`	Unknown
`type`	Unknown

Column	Type	Keys
`_fivetran_id`	String	PK
`account_id`	Unknown	FK
`ad_group_id`	Unknown	FK
`ad_id`	Unknown	FK
`campaign_id`	Unknown	FK
`account_name`	Unknown
`ad_group_labels`	Unknown
`ad_group_name`	Unknown
`ad_group_user_status`	Unknown
`ad_labels`	Unknown
`ad_name`	Unknown
`ad_type`	Unknown
`ad_user_status`	Unknown
`age`	Unknown
`app`	Unknown
`app_id`	Unknown
`app_name`	Unknown
`app_os`	Unknown
`avg_cpc`	Unknown
`avg_cpm`	Unknown
`avg_cpv`	Unknown
`avg_duration_of_video_viewed`	Unknown
`avg_position`	Unknown
`avg_vcpm`	Unknown
`avg_video_view_rate`	Unknown
`campaign_buying_type`	Unknown
`campaign_delivery_type`	Unknown
`campaign_goals`	Unknown
`campaign_labels`	Unknown
`campaign_name`	Unknown
`campaign_type`	Unknown
`campaign_user_status`	Unknown
`city`	Unknown
`city_id`	Unknown
`clicks`	Unknown
`content_keyword`	Unknown
`content_keyword_id`	Unknown
`conv_rate`	Unknown
`conv_rate_all`	Unknown
`conv_rate_via_click`	Unknown
`conv_value`	Unknown
`conv_value_all`	Unknown
`conv_value_all_per_conv_all`	Unknown
`conv_value_all_per_cost`	Unknown
`conv_value_per_conv`	Unknown
`conv_value_per_cost`	Unknown
`conv_value_via_click`	Unknown
`conv_value_via_click_per_conv_via_click`	Unknown
`conv_value_via_click_per_cost`	Unknown
`conversions`	Unknown
`conversions_all`	Unknown
`conversions_via_click`	Unknown
`cost`	Unknown
`cost_per_conv`	Unknown
`cost_per_conv_all`	Unknown
`cost_per_conv_via_click`	Unknown
`cross_device_conv`	Unknown
`ctr`	Unknown
`day`	Unknown
`description_1`	Unknown
`description_2`	Unknown
`destination_url_campaign_banner`	Unknown
`device`	Unknown
`display_url`	Unknown
`file_name`	Unknown
`final_url`	Unknown
`gender`	Unknown
`hour_of_day`	Unknown
`impressions`	Unknown
`layout`	Unknown
`lifetime_budget`	Unknown
`main_media_format`	Unknown
`measured_impression_rate`	Unknown
`measured_impressions`	Unknown
`media_id`	Unknown
`media_name`	Unknown
`month`	Unknown
`os`	Unknown
`package_name`	Unknown
`paid_video_view_rate_cpv`	Unknown
`paid_video_views_cpv`	Unknown
`pixel_size`	Unknown
`prefecture_id`	Unknown
`prefectures`	Unknown
`responsive_ads_type`	Unknown
`search_keyword`	Unknown
`search_keyword_id`	Unknown
`title`	Unknown
`tracking_url`	Unknown
`video_view_through_rate`	Unknown
`video_views`	Unknown
`video_views_to_100_percentage`	Unknown
`video_views_to_10_sec`	Unknown
`video_views_to_25_percentage`	Unknown
`video_views_to_3_sec`	Unknown
`video_views_to_50_percentage`	Unknown
`video_views_to_75_percentage`	Unknown
`video_views_to_95_percentage`	Unknown
`view_through_conversions`	Unknown
`viewable_clicks`	Unknown
`viewable_ctr`	Unknown
`viewable_ctr_per_panel`	Unknown
`viewable_impression_rate`	Unknown
`viewable_impressions`	Unknown
`viewable_impressions_per_panel`	Unknown
`ward`	Unknown
`ward_id`	Unknown
`week`	Unknown

reach

Column	Type	Keys
`_fivetran_id`	String	PK
`account_id`	Unknown	FK
`ad_group_id`	Unknown	FK
`ad_id`	Unknown	FK
`campaign_id`	Unknown	FK
`account_name`	Unknown
`ad_group_name`	Unknown
`ad_group_user_status`	Unknown
`ad_name`	Unknown
`ad_user_status`	Unknown
`avg_cpc`	Unknown
`avg_cpm`	Unknown
`avg_cpv`	Unknown
`avg_duration_of_video_viewed`	Unknown
`avg_frequency`	Unknown
`avg_vcpm`	Unknown
`avg_video_view_rate`	Unknown
`campaign_buying_type`	Unknown
`campaign_delivery_type`	Unknown
`campaign_end_date`	Unknown
`campaign_goals`	Unknown
`campaign_name`	Unknown
`campaign_start_date`	Unknown
`campaign_user_status`	Unknown
`clicks`	Unknown
`conv_rate`	Unknown
`conv_rate_all`	Unknown
`conv_rate_via_click`	Unknown
`conv_value_via_view_through`	Unknown
`conversions`	Unknown
`conversions_all`	Unknown
`conversions_via_click`	Unknown
`cost`	Unknown
`cost_per_conv`	Unknown
`cost_per_conv_all`	Unknown
`cost_per_conv_via_click`	Unknown
`cross_device_conv`	Unknown
`ctr`	Unknown
`day`	Unknown
`impressions`	Unknown
`lifetime_budget`	Unknown
`measured_impression_rate`	Unknown
`measured_impressions`	Unknown
`package_name`	Unknown
`paid_video_view_rate_cpv`	Unknown
`paid_video_views_cpv`	Unknown
`reaches`	Unknown
`video_view_through_rate`	Unknown
`video_views`	Unknown
`video_views_to_100_percentage`	Unknown
`video_views_to_10_sec`	Unknown
`video_views_to_25_percentage`	Unknown
`video_views_to_3_sec`	Unknown
`video_views_to_50_percentage`	Unknown
`video_views_to_75_percentage`	Unknown
`video_views_to_95_percentage`	Unknown
`viewable_clicks`	Unknown
`viewable_ctr`	Unknown
`viewable_impression_rate`	Unknown
`viewable_impressions`	Unknown