Google Search Ads 360

Explore the interactive ERD

Table & Field Reference

customer_report_hourly

Column	Type	Keys
`_fivetran_id`	String	PK
`date`	LocalDate	PK
`customer_id`	Long	PKFK
`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	PKFK
`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	PKFK
`ad_group_id`	Long	FK
`bidding_strategy_id`	Long	FK
`campaign_id`	Long	FK
`ad_group_criterion_criterion_id`	Long
`historical_quality_score`	Long

Column	Type	Keys
`id`	Long	PK
`customer_id`	Long	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`name`	String

campaign_device_report

Column	Type	Keys
`_fivetran_id`	String	PK
`date`	LocalDate	PK
`customer_id`	Long	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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