# Yahoo Display Ads on Yahoo Japan schema ERD

Table and field reference for the Fivetran Yahoo Display Ads on Yahoo Japan connector.

## Table & Field Reference

### conversion_tracker

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | PK, FK |
| 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 | PK, FK |
| conversion_group_id | Unknown | PK, FK |
| 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 | PK, FK |
| base_account_id | Unknown |  |
| name | Unknown |  |

### ad_group_ad_label

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| account_id | Unknown | PK, FK |
| ad_group_ad_id | Unknown | PK, FK |
| color | Unknown |  |
| description | Unknown |  |
| id | Unknown |  |
| name | Unknown |  |

### ad_group_ad

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | PK, FK |
| 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 | PK, FK |
| campaign_id | Unknown | PK, FK |
| color | Unknown |  |
| description | Unknown |  |
| id | Unknown |  |
| name | Unknown |  |

### campaign

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | PK, FK |
| 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 | PK, FK |
| ad_group_id | Unknown | PK, FK |
| color | Unknown |  |
| description | Unknown |  |
| id | Unknown |  |
| name | Unknown |  |

### ad_group

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | PK, FK |
| 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 |  |

### ad

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

## Relationships

- conversion_tracker(account_id) → account(id)
- conversion_group_conversion(conversion_group_id) → conversion_group(id)
- conversion_group_conversion(account_id) → conversion_group(account_id)
- conversion_group_conversion(conversion_tracker_id) → conversion_tracker(id)
- conversion_group(account_id) → account(id)
- ad_group_ad_label(ad_group_ad_id) → ad_group_ad(id)
- ad_group_ad_label(account_id) → ad_group_ad(account_id)
- ad_group_ad(campaign_id) → campaign(id)
- ad_group_ad(ad_group_id) → ad_group(id)
- ad_group_ad(account_id) → account(id)
- campaign_label(campaign_id) → campaign(id)
- campaign_label(account_id) → campaign(account_id)
- campaign(conversion_tracker_id) → conversion_tracker(id)
- campaign(account_id) → account(id)
- campaign(ad_group_id) → ad_group(id)
- ad_group_label(ad_group_id) → ad_group(id)
- ad_group_label(account_id) → ad_group(account_id)
- ad_group(campaign_id) → campaign(id)
- ad_group(base_account_id) → account(base_account_id)
- ad_group(account_id) → account(id)
- ad(campaign_id) → campaign(id)
- ad(ad_id) → ad_group_ad(id)
- ad(ad_group_id) → ad_group(id)
- ad(account_id) → account(id)
- reach(campaign_id) → campaign(id)
- reach(ad_id) → ad_group_ad(id)
- reach(ad_group_id) → ad_group(id)
- reach(account_id) → account(id)