# Yahoo Search Ads on Yahoo Japan schema ERD

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

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

### ad

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

## Relationships

- campaign_target_list(campaign_id) → campaign(id)
- campaign_target_list(account_id) → account(id)
- ad(campaign_id) → campaign(id)
- ad(ad_group_id) → adgroup(id)
- ad(account_id) → account(id)
- search_query(campaign_id) → campaign(id)
- search_query(ad_group_id) → adgroup(id)
- search_query(keyword_id) → keyword(id)
- search_query(account_id) → account(id)
- keyword(campaign_id) → campaign(id)
- keyword(ad_group_id) → adgroup(id)
- keyword(account_id) → account(id)
- schedule_target(campaign_id) → campaign(id)
- schedule_target(account_id) → account(id)
- adgroup_target_list(campaign_id) → campaign(id)
- adgroup_target_list(ad_group_id) → adgroup(id)
- adgroup_target_list(account_id) → account(id)
- geo(campaign_id) → campaign(id)
- geo(ad_group_id) → adgroup(id)
- geo(account_id) → account(id)
- campaign_asset(campaign_id) → campaign(id)
- campaign_asset(account_id) → account(id)
- adgroup(campaign_id) → campaign(id)
- adgroup(account_id) → account(id)
- geo_target(campaign_id) → campaign(id)
- geo_target(account_id) → account(id)
- webpage_criterion(campaign_id) → campaign(id)
- webpage_criterion(ad_group_id) → adgroup(id)
- webpage_criterion(account_id) → account(id)
- responsive_ads_search_asset(campaign_id) → campaign(id)
- responsive_ads_search_asset(ad_id) → ad(id)
- responsive_ads_search_asset(ad_group_id) → adgroup(id)
- responsive_ads_search_asset(account_id) → account(id)
- landing_page_url(campaign_id) → campaign(id)
- landing_page_url(ad_group_id) → adgroup(id)
- landing_page_url(account_id) → account(id)
- bid_strategy(campaign_id) → campaign(id)
- bid_strategy(account_id) → account(id)
- bid_modifier(account_id) → account(id)
- bid_modifier(ad_group_id) → adgroup(id)
- bid_modifier(campaign_id) → campaign(id)
- adgroup_asset(campaign_id) → campaign(id)
- adgroup_asset(ad_group_id) → adgroup(id)
- adgroup_asset(account_id) → account(id)
- keywordless_query(campaign_id) → campaign(id)
- keywordless_query(ad_group_id) → adgroup(id)
- keywordless_query(account_id) → account(id)
- campaign(account_id) → account(id)