# Google Search Ads 360 schema ERD

Table and field reference for the Fivetran Google Search Ads 360 connector.

## Table & Field Reference

### customer_report_hourly

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| date | LocalDate | PK |
| customer_id | Long | PK, FK |
| content_budget_lost_impression_share | Double |  |
| content_impression_share | Double |  |
| content_rank_lost_impression_share | Double |  |
| customer_engine_id | String |  |
| hour | Int |  |
| search_budget_lost_impression_share | Double |  |
| search_impression_share | Double |  |
| search_rank_lost_impression_share | Double |  |

### ad_group_conversion_action_and_device_report

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| date | LocalDate | PK |
| customer_id | Long | PK, FK |
| ad_group_id | Long | FK |
| bidding_strategy_id | Long | FK |
| campaign_id | Long | FK |
| all_conversions | Double |  |
| all_conversions_value | Double |  |
| conversion_action_name | String |  |
| cross_device_conversions | Double |  |
| cross_device_conversions_value | Double |  |
| device | String |  |

### keyword_report

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| date | LocalDate | PK |
| customer_id | Long | PK, FK |
| ad_group_id | Long | FK |
| bidding_strategy_id | Long | FK |
| campaign_id | Long | FK |
| ad_group_criterion_criterion_id | Long |  |
| historical_quality_score | Long |  |

### ad

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| customer_id | Long | PK, FK |
| ad_group_id | Long | FK |
| campaign_id | Long | FK |
| creation_time | LocalDateTime |  |
| display_url | String |  |
| engine_id | String |  |
| engine_status | String |  |
| expanded_dynamic_search_ad_description_1 | String |  |
| expanded_dynamic_search_ad_description_2 | String |  |
| expanded_text_ad_description_1 | String |  |
| expanded_text_ad_description_2 | String |  |
| expanded_text_ad_headline | String |  |
| expanded_text_ad_headline_2 | String |  |
| expanded_text_ad_headline_3 | String |  |
| final_urls | String |  |
| labels | String |  |
| last_modified_time | LocalDateTime |  |
| name | String |  |
| status | String |  |
| text_ad_description_1 | String |  |
| text_ad_description_2 | String |  |
| text_ad_headline | String |  |
| type | String |  |

### campaign_report

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| date | LocalDate | PK |
| customer_id | Long | PK, FK |
| bidding_strategy_id | Long | FK |
| campaign_id | Long | FK |
| all_conversions | Double |  |
| all_conversions_value | Double |  |
| average_cpc | Double |  |
| average_cpm | Double |  |
| clicks | Long |  |
| client_account_conversions | Double |  |
| client_account_conversions_value | Double |  |
| client_account_view_through_conversions | Long |  |
| content_budget_lost_impression_share | Double |  |
| content_impression_share | Double |  |
| content_rank_lost_impression_share | Double |  |
| conversions | Double |  |
| conversions_value | Double |  |
| cost_micros | Long |  |
| ctr | Double |  |
| historical_quality_score | Long |  |
| impressions | Long |  |
| search_budget_lost_impression_share | Double |  |
| search_impression_share | Double |  |
| search_rank_lost_impression_share | Double |  |
| visits | Double |  |

### keyword_conversion_action_and_device_report

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| date | LocalDate | PK |
| customer_id | Long | PK, FK |
| ad_group_id | Long | FK |
| bidding_strategy_id | Long | FK |
| campaign_id | Long | FK |
| ad_group_criterion_criterion_id | Long |  |
| ad_group_criterion_engine_id | String |  |
| all_conversions | Double |  |
| all_conversions_value | Double |  |
| conversion_action_name | String |  |
| cross_device_conversions | Double |  |
| cross_device_conversions_value | Double |  |
| device | String |  |

### ad_group_report

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| date | LocalDate | PK |
| customer_id | Long | PK, FK |
| ad_group_id | Long | FK |
| bidding_strategy_id | Long | FK |
| campaign_id | Long | FK |
| content_impression_share | Double |  |
| content_rank_lost_impression_share | Double |  |
| historical_quality_score | Long |  |
| search_impression_share | Double |  |
| search_rank_lost_impression_share | Double |  |

### ad_conversion_action_and_device_report

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| date | LocalDate | PK |
| customer_id | Long | PK, FK |
| ad_group_id | Long | FK |
| ad_id | Long | FK |
| campaign_id | Long | FK |
| ad_group_ad_engine_id | String |  |
| all_conversions | Double |  |
| all_conversions_value | Double |  |
| conversion_action_name | String |  |
| cross_device_conversions | Double |  |
| cross_device_conversions_value | Double |  |
| device | String |  |

### ad_group_device_report

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| date | LocalDate | PK |
| customer_id | Long | PK, FK |
| ad_group_id | Long | FK |
| bidding_strategy_id | Long | FK |
| campaign_id | Long | FK |
| average_cpc | Double |  |
| average_cpm | Double |  |
| clicks | Long |  |
| client_account_conversions | Double |  |
| client_account_conversions_value | Double |  |
| client_account_view_through_conversions | Long |  |
| cost_micros | Long |  |
| ctr | Double |  |
| impressions | Long |  |
| visits | Double |  |

### ad_group_report_hourly

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| date | LocalDate | PK |
| customer_id | Long | PK, FK |
| ad_group_id | Long | FK |
| bidding_strategy_id | Long | FK |
| campaign_id | Long | FK |
| content_impression_share | Double |  |
| content_rank_lost_impression_share | Double |  |
| hour | Int |  |
| search_impression_share | Double |  |
| search_rank_lost_impression_share | Double |  |

### campaign_conversion_action_and_device_report

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| date | LocalDate | PK |
| customer_id | Long | PK, FK |
| bidding_strategy_id | Long | FK |
| campaign_id | Long | FK |
| all_conversions | Double |  |
| all_conversions_value | Double |  |
| conversion_action_name | String |  |
| cross_device_conversions | Double |  |
| cross_device_conversions_value | Double |  |
| device | String |  |

### customer_conversion_action_and_device_report

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| date | LocalDate | PK |
| customer_id | Long | PK, FK |
| all_conversions | Double |  |
| all_conversions_value | Double |  |
| conversion_action_name | String |  |
| cross_device_conversions | Double |  |
| cross_device_conversions_value | Double |  |
| customer_engine_id | String |  |
| device | String |  |

### ad_group

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| customer_id | Long | PK, FK |
| bidding_strategy_id | Long | FK |
| campaign_id | Long | FK |
| ad_group_bid_modifier_bid_modifier | Double |  |
| ad_group_bid_modifier_device_type | String |  |
| cpc_bid_micros | Long |  |
| creation_time | LocalDateTime |  |
| end_date | LocalDate |  |
| engine_id | String |  |
| engine_status | String |  |
| labels | String |  |
| language_code | String |  |
| last_modified_time | LocalDateTime |  |
| name | String |  |
| start_date | LocalDate |  |
| status | String |  |
| targeting_setting_target_restrictions | String |  |

### customer_device_report

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| date | LocalDate | PK |
| customer_id | Long | PK, FK |
| average_cpc | Double |  |
| average_cpm | Double |  |
| clicks | Long |  |
| client_account_conversions | Double |  |
| client_account_conversions_value | Double |  |
| client_account_view_through_conversions | Long |  |
| cost_micros | Long |  |
| ctr | Double |  |
| customer_engine_id | String |  |
| device | String |  |
| impressions | Long |  |
| visits | Double |  |

### bidding_strategy

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| customer_id | Long | PK, FK |
| name | String |  |

### campaign_device_report

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| date | LocalDate | PK |
| customer_id | Long | PK, FK |
| bidding_strategy_id | Long | FK |
| campaign_id | Long | FK |
| average_cpc | Double |  |
| average_cpm | Double |  |
| clicks | Long |  |
| client_account_conversions | Double |  |
| client_account_conversions_value | Double |  |
| client_account_view_through_conversions | Long |  |
| cost_micros | Long |  |
| ctr | Double |  |
| device | String |  |
| impressions | Long |  |
| visits | Double |  |

### campaign

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| customer_id | Long | PK, FK |
| bidding_strategy_id | Long | FK |
| advertising_channel_sub_type | String |  |
| advertising_channel_type | String |  |
| creation_time | LocalDateTime |  |
| end_date | LocalDate |  |
| engine_id | String |  |
| labels | String |  |
| last_modified_time | LocalDateTime |  |
| name | String |  |
| network_settings_target_content_network | Boolean |  |
| network_settings_target_google_search | Boolean |  |
| network_settings_target_partner_search_network | Boolean |  |
| network_settings_target_search_network | Boolean |  |
| start_date | LocalDate |  |
| status | String |  |

### customer_report

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| date | LocalDate | PK |
| customer_id | Long | PK, FK |
| content_budget_lost_impression_share | Double |  |
| content_impression_share | Double |  |
| content_rank_lost_impression_share | Double |  |
| customer_engine_id | String |  |
| historical_quality_score | Long |  |
| search_budget_lost_impression_share | Double |  |
| search_impression_share | Double |  |
| search_rank_lost_impression_share | Double |  |

### ad_device_report

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| date | LocalDate | PK |
| customer_id | Long | PK, FK |
| ad_group_id | Long | FK |
| ad_id | Long | FK |
| campaign_id | Long | FK |
| ad_group_ad_engine_id | String |  |
| average_cpc | Double |  |
| average_cpm | Double |  |
| clicks | Long |  |
| client_account_conversions | Double |  |
| client_account_conversions_value | Double |  |
| client_account_view_through_conversions | Long |  |
| cost_micros | Long |  |
| ctr | Double |  |
| impressions | Long |  |
| visits | Double |  |

### customer

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| account_type | String |  |
| associate_manager_id | Long |  |
| creation_time | LocalDateTime |  |
| currency_code | String |  |
| descriptive_name | String |  |
| engine_id | String |  |
| last_modified_time | LocalDateTime |  |
| manager_id | Long |  |
| status | String |  |
| sub_manager_id | Long |  |
| time_zone | String |  |

### keyword_device_report

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| date | LocalDate | PK |
| customer_id | Long | PK, FK |
| ad_group_id | Long | FK |
| bidding_strategy_id | Long | FK |
| campaign_id | Long | FK |
| ad_group_criterion_criterion_id | Long |  |
| ad_group_criterion_engine_id | String |  |
| average_cpc | Double |  |
| average_cpm | Double |  |
| clicks | Long |  |
| client_account_conversions | Double |  |
| client_account_conversions_value | Double |  |
| client_account_view_through_conversions | Long |  |
| cost_micros | Long |  |
| ctr | Double |  |
| device | String |  |
| impressions | Long |  |
| visits | Double |  |

### campaign_report_hourly

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| date | LocalDate | PK |
| customer_id | Long | PK, FK |
| bidding_strategy_id | Long | FK |
| campaign_id | Long | FK |
| all_conversions | Double |  |
| all_conversions_value | Double |  |
| average_cpc | Double |  |
| average_cpm | Double |  |
| clicks | Long |  |
| client_account_conversions | Double |  |
| client_account_conversions_value | Double |  |
| client_account_view_through_conversions | Long |  |
| content_budget_lost_impression_share | Double |  |
| content_impression_share | Double |  |
| content_rank_lost_impression_share | Double |  |
| conversions | Double |  |
| conversions_value | Double |  |
| cost_micros | Long |  |
| ctr | Double |  |
| hour | Int |  |
| impressions | Long |  |
| search_budget_lost_impression_share | Double |  |
| search_impression_share | Double |  |
| search_rank_lost_impression_share | Double |  |
| visits | Double |  |

## Relationships

- customer_report_hourly(customer_id) → customer(id)
- ad_group_conversion_action_and_device_report(customer_id) → customer(id)
- ad_group_conversion_action_and_device_report(ad_group_id) → ad_group(id)
- ad_group_conversion_action_and_device_report(bidding_strategy_id) → bidding_strategy(id)
- ad_group_conversion_action_and_device_report(campaign_id) → campaign(id)
- keyword_report(customer_id) → customer(id)
- keyword_report(ad_group_id) → ad_group(id)
- keyword_report(bidding_strategy_id) → bidding_strategy(id)
- keyword_report(campaign_id) → campaign(id)
- ad(customer_id) → customer(id)
- ad(ad_group_id) → ad_group(id)
- ad(campaign_id) → campaign(id)
- campaign_report(customer_id) → customer(id)
- campaign_report(bidding_strategy_id) → bidding_strategy(id)
- campaign_report(campaign_id) → campaign(id)
- keyword_conversion_action_and_device_report(customer_id) → customer(id)
- keyword_conversion_action_and_device_report(ad_group_id) → ad_group(id)
- keyword_conversion_action_and_device_report(bidding_strategy_id) → bidding_strategy(id)
- keyword_conversion_action_and_device_report(campaign_id) → campaign(id)
- ad_group_report(customer_id) → customer(id)
- ad_group_report(ad_group_id) → ad_group(id)
- ad_group_report(bidding_strategy_id) → bidding_strategy(id)
- ad_group_report(campaign_id) → campaign(id)
- ad_conversion_action_and_device_report(customer_id) → customer(id)
- ad_conversion_action_and_device_report(ad_id) → ad(id)
- ad_conversion_action_and_device_report(ad_group_id) → ad_group(id)
- ad_conversion_action_and_device_report(campaign_id) → campaign(id)
- ad_group_device_report(customer_id) → customer(id)
- ad_group_device_report(ad_group_id) → ad_group(id)
- ad_group_device_report(bidding_strategy_id) → bidding_strategy(id)
- ad_group_device_report(campaign_id) → campaign(id)
- ad_group_report_hourly(customer_id) → customer(id)
- ad_group_report_hourly(ad_group_id) → ad_group(id)
- ad_group_report_hourly(bidding_strategy_id) → bidding_strategy(id)
- ad_group_report_hourly(campaign_id) → campaign(id)
- campaign_conversion_action_and_device_report(customer_id) → customer(id)
- campaign_conversion_action_and_device_report(bidding_strategy_id) → bidding_strategy(id)
- campaign_conversion_action_and_device_report(campaign_id) → campaign(id)
- customer_conversion_action_and_device_report(customer_id) → customer(id)
- ad_group(customer_id) → customer(id)
- ad_group(bidding_strategy_id) → bidding_strategy(id)
- ad_group(campaign_id) → campaign(id)
- customer_device_report(customer_id) → customer(id)
- bidding_strategy(customer_id) → customer(id)
- campaign_device_report(customer_id) → customer(id)
- campaign_device_report(bidding_strategy_id) → bidding_strategy(id)
- campaign_device_report(campaign_id) → campaign(id)
- campaign(customer_id) → customer(id)
- campaign(bidding_strategy_id) → bidding_strategy(id)
- customer_report(customer_id) → customer(id)
- ad_device_report(customer_id) → customer(id)
- ad_device_report(ad_id) → ad(id)
- ad_device_report(ad_group_id) → ad_group(id)
- ad_device_report(campaign_id) → campaign(id)
- keyword_device_report(customer_id) → customer(id)
- keyword_device_report(ad_group_id) → ad_group(id)
- keyword_device_report(bidding_strategy_id) → bidding_strategy(id)
- keyword_device_report(campaign_id) → campaign(id)
- campaign_report_hourly(customer_id) → customer(id)
- campaign_report_hourly(bidding_strategy_id) → bidding_strategy(id)
- campaign_report_hourly(campaign_id) → campaign(id)