Google Ads → Google BigQuery: data schema

campaigns

Field name	Type
campaign.accessible_bidding_strategy	STRING
campaign.ad_serving_optimization_status	STRING
campaign.advertising_channel_sub_type	STRING
campaign.advertising_channel_type	STRING
campaign.app_campaign_setting.app_id	STRING
campaign.app_campaign_setting.app_store	STRING
campaign.app_campaign_setting.bidding_strategy_goal_type	STRING
campaign.base_campaign	STRING
campaign.bidding_strategy	STRING
campaign.bidding_strategy_type	STRING
campaign.campaign_budget	STRING
campaign.commission.commission_rate_micros	INTEGER
campaign.dynamic_search_ads_setting.domain_name	STRING
campaign.dynamic_search_ads_setting.feeds	ARRAY
campaign.dynamic_search_ads_setting.language_code	STRING
campaign.dynamic_search_ads_setting.use_supplied_urls_only	BOOLEAN
campaign.end_date	STRING
campaign.excluded_parent_asset_field_types	ARRAY
campaign.experiment_type	STRING
campaign.final_url_suffix	STRING
campaign.frequency_caps	ARRAY
campaign.geo_target_type_setting.negative_geo_target_type	STRING
campaign.geo_target_type_setting.positive_geo_target_type	STRING
campaign.hotel_setting.hotel_center_id	INTEGER
campaign.id	INTEGER
campaign.labels	ARRAY
campaign.local_campaign_setting.location_source_type	STRING
campaign.manual_cpc.enhanced_cpc_enabled	BOOLEAN
campaign.manual_cpm	STRING
campaign.manual_cpv	STRING
campaign.maximize_conversion_value.target_roas	NUMBER
campaign.maximize_conversions.target_cpa_micros	INTEGER
campaign.name	STRING
campaign.network_settings.target_content_network	BOOLEAN
campaign.network_settings.target_google_search	BOOLEAN
campaign.network_settings.target_partner_search_network	BOOLEAN
campaign.network_settings.target_search_network	BOOLEAN
campaign.optimization_goal_setting.optimization_goal_types	ARRAY
campaign.optimization_score	NUMBER
campaign.payment_mode	STRING
campaign.percent_cpc.cpc_bid_ceiling_micros	INTEGER
campaign.percent_cpc.enhanced_cpc_enabled	BOOLEAN
campaign.real_time_bidding_setting.opt_in	BOOLEAN
campaign.resource_name	STRING
campaign.selective_optimization.conversion_actions	ARRAY
campaign.serving_status	STRING
campaign.shopping_setting.campaign_priority	INTEGER
campaign.shopping_setting.enable_local	BOOLEAN
campaign.shopping_setting.merchant_id	INTEGER
campaign.shopping_setting.sales_country	STRING
campaign.start_date	STRING
campaign.status	STRING
campaign.target_cpa.cpc_bid_ceiling_micros	INTEGER
campaign.target_cpa.cpc_bid_floor_micros	INTEGER
campaign.target_cpa.target_cpa_micros	INTEGER
campaign.target_cpm	STRING
campaign.target_impression_share.cpc_bid_ceiling_micros	INTEGER
campaign.target_impression_share.location	STRING
campaign.target_impression_share.location_fraction_micros	INTEGER
campaign.target_roas.cpc_bid_ceiling_micros	INTEGER
campaign.target_roas.cpc_bid_floor_micros	INTEGER
campaign.target_roas.target_roas	NUMBER
campaign.target_spend.cpc_bid_ceiling_micros	INTEGER
campaign.target_spend.target_spend_micros	INTEGER
campaign.targeting_setting.target_restrictions	ARRAY
campaign.tracking_setting.tracking_url	STRING
campaign.tracking_url_template	STRING
campaign.url_custom_parameters	ARRAY
campaign.vanity_pharma.vanity_pharma_display_url_mode	STRING
campaign.vanity_pharma.vanity_pharma_text	STRING
campaign.video_brand_safety_suitability	STRING
campaign_budget.amount_micros	INTEGER
metrics.clicks	INTEGER
metrics.cost_micros	INTEGER
metrics.impressions	NUMBER
metrics.video_quartile_p100_rate	NUMBER
metrics.video_views	NUMBER
segments.date	STRING

ad_group_ads

Field name	Type
ad_group_ad.ad.added_by_google_ads	BOOLEAN
ad_group_ad.ad.app_ad.descriptions	ARRAY
ad_group_ad.ad.app_ad.headlines	ARRAY
ad_group_ad.ad.app_ad.html5_media_bundles	ARRAY
ad_group_ad.ad.app_ad.images	ARRAY
ad_group_ad.ad.app_ad.mandatory_ad_text	STRING
ad_group_ad.ad.app_ad.youtube_videos	ARRAY
ad_group_ad.ad.app_engagement_ad.descriptions	ARRAY
ad_group_ad.ad.app_engagement_ad.headlines	ARRAY
ad_group_ad.ad.app_engagement_ad.images	ARRAY
ad_group_ad.ad.app_engagement_ad.videos	ARRAY
ad_group_ad.ad.call_ad.business_name	STRING
ad_group_ad.ad.call_ad.call_tracked	BOOLEAN
ad_group_ad.ad.call_ad.conversion_action	STRING
ad_group_ad.ad.call_ad.conversion_reporting_state	STRING
ad_group_ad.ad.call_ad.country_code	STRING
ad_group_ad.ad.call_ad.description1	STRING
ad_group_ad.ad.call_ad.description2	STRING
ad_group_ad.ad.call_ad.disable_call_conversion	BOOLEAN
ad_group_ad.ad.call_ad.headline1	STRING
ad_group_ad.ad.call_ad.headline2	STRING
ad_group_ad.ad.call_ad.path1	STRING
ad_group_ad.ad.call_ad.path2	STRING
ad_group_ad.ad.call_ad.phone_number	STRING
ad_group_ad.ad.call_ad.phone_number_verification_url	STRING
ad_group_ad.ad.device_preference	STRING
ad_group_ad.ad.display_upload_ad.display_upload_product_type	STRING
ad_group_ad.ad.display_upload_ad.media_bundle	STRING
ad_group_ad.ad.display_url	STRING
ad_group_ad.ad.expanded_dynamic_search_ad.description	STRING
ad_group_ad.ad.expanded_dynamic_search_ad.description2	STRING
ad_group_ad.ad.expanded_text_ad.description	STRING
ad_group_ad.ad.expanded_text_ad.description2	STRING
ad_group_ad.ad.expanded_text_ad.headline_part1	STRING
ad_group_ad.ad.expanded_text_ad.headline_part2	STRING
ad_group_ad.ad.expanded_text_ad.headline_part3	STRING
ad_group_ad.ad.expanded_text_ad.path1	STRING
ad_group_ad.ad.expanded_text_ad.path2	STRING
ad_group_ad.ad.final_app_urls	ARRAY
ad_group_ad.ad.final_mobile_urls	ARRAY
ad_group_ad.ad.final_url_suffix	STRING
ad_group_ad.ad.final_urls	ARRAY
ad_group_ad.ad.gmail_ad.header_image	STRING
ad_group_ad.ad.gmail_ad.marketing_image	STRING
ad_group_ad.ad.gmail_ad.marketing_image_description	STRING
ad_group_ad.ad.gmail_ad.marketing_image_display_call_to_action.text	STRING
ad_group_ad.ad.gmail_ad.marketing_image_display_call_to_action.text_color	STRING
ad_group_ad.ad.gmail_ad.marketing_image_display_call_to_action.url_collection_id	STRING
ad_group_ad.ad.gmail_ad.marketing_image_headline	STRING
ad_group_ad.ad.gmail_ad.product_images	ARRAY
ad_group_ad.ad.gmail_ad.product_videos	ARRAY
ad_group_ad.ad.gmail_ad.teaser.business_name	STRING
ad_group_ad.ad.gmail_ad.teaser.description	STRING
ad_group_ad.ad.gmail_ad.teaser.headline	STRING
ad_group_ad.ad.gmail_ad.teaser.logo_image	STRING
ad_group_ad.ad.hotel_ad	STRING
ad_group_ad.ad.id	INTEGER
ad_group_ad.ad.image_ad.image_url	STRING
ad_group_ad.ad.image_ad.mime_type	STRING
ad_group_ad.ad.image_ad.name	STRING
ad_group_ad.ad.image_ad.pixel_height	INTEGER
ad_group_ad.ad.image_ad.pixel_width	INTEGER
ad_group_ad.ad.image_ad.preview_image_url	STRING
ad_group_ad.ad.image_ad.preview_pixel_height	INTEGER
ad_group_ad.ad.image_ad.preview_pixel_width	INTEGER
ad_group_ad.ad.legacy_app_install_ad	STRING
ad_group_ad.ad.legacy_responsive_display_ad.accent_color	STRING
ad_group_ad.ad.legacy_responsive_display_ad.allow_flexible_color	BOOLEAN
ad_group_ad.ad.legacy_responsive_display_ad.business_name	STRING
ad_group_ad.ad.legacy_responsive_display_ad.call_to_action_text	STRING
ad_group_ad.ad.legacy_responsive_display_ad.description	STRING
ad_group_ad.ad.legacy_responsive_display_ad.format_setting	STRING
ad_group_ad.ad.legacy_responsive_display_ad.logo_image	STRING
ad_group_ad.ad.legacy_responsive_display_ad.long_headline	STRING
ad_group_ad.ad.legacy_responsive_display_ad.main_color	STRING
ad_group_ad.ad.legacy_responsive_display_ad.marketing_image	STRING
ad_group_ad.ad.legacy_responsive_display_ad.price_prefix	STRING
ad_group_ad.ad.legacy_responsive_display_ad.promo_text	STRING
ad_group_ad.ad.legacy_responsive_display_ad.short_headline	STRING
ad_group_ad.ad.legacy_responsive_display_ad.square_logo_image	STRING
ad_group_ad.ad.legacy_responsive_display_ad.square_marketing_image	STRING
ad_group_ad.ad.local_ad.call_to_actions	ARRAY
ad_group_ad.ad.local_ad.descriptions	ARRAY
ad_group_ad.ad.local_ad.headlines	ARRAY
ad_group_ad.ad.local_ad.logo_images	ARRAY
ad_group_ad.ad.local_ad.marketing_images	ARRAY
ad_group_ad.ad.local_ad.path1	STRING
ad_group_ad.ad.local_ad.path2	STRING
ad_group_ad.ad.local_ad.videos	ARRAY
ad_group_ad.ad.name	STRING
ad_group_ad.ad.resource_name	STRING
ad_group_ad.ad.responsive_display_ad.accent_color	STRING
ad_group_ad.ad.responsive_display_ad.allow_flexible_color	BOOLEAN
ad_group_ad.ad.responsive_display_ad.business_name	STRING
ad_group_ad.ad.responsive_display_ad.call_to_action_text	STRING
ad_group_ad.ad.responsive_display_ad.control_spec.enable_asset_enhancements	BOOLEAN
ad_group_ad.ad.responsive_display_ad.control_spec.enable_autogen_video	BOOLEAN
ad_group_ad.ad.responsive_display_ad.descriptions	ARRAY
ad_group_ad.ad.responsive_display_ad.format_setting	STRING
ad_group_ad.ad.responsive_display_ad.headlines	ARRAY
ad_group_ad.ad.responsive_display_ad.logo_images	ARRAY
ad_group_ad.ad.responsive_display_ad.long_headline	STRING
ad_group_ad.ad.responsive_display_ad.main_color	STRING
ad_group_ad.ad.responsive_display_ad.marketing_images	ARRAY
ad_group_ad.ad.responsive_display_ad.price_prefix	STRING
ad_group_ad.ad.responsive_display_ad.promo_text	STRING
ad_group_ad.ad.responsive_display_ad.square_logo_images	ARRAY
ad_group_ad.ad.responsive_display_ad.square_marketing_images	ARRAY
ad_group_ad.ad.responsive_display_ad.youtube_videos	ARRAY
ad_group_ad.ad.responsive_search_ad.descriptions	ARRAY
ad_group_ad.ad.responsive_search_ad.headlines	ARRAY
ad_group_ad.ad.responsive_search_ad.path1	STRING
ad_group_ad.ad.responsive_search_ad.path2	STRING
ad_group_ad.ad.shopping_comparison_listing_ad.headline	STRING
ad_group_ad.ad.shopping_product_ad	STRING
ad_group_ad.ad.shopping_smart_ad	STRING
ad_group_ad.ad.smart_campaign_ad.descriptions	ARRAY
ad_group_ad.ad.smart_campaign_ad.headlines	ARRAY
ad_group_ad.ad.system_managed_resource_source	STRING
ad_group_ad.ad.text_ad.description1	STRING
ad_group_ad.ad.text_ad.description2	STRING
ad_group_ad.ad.text_ad.headline	STRING
ad_group_ad.ad.tracking_url_template	STRING
ad_group_ad.ad.type	STRING
ad_group_ad.ad.url_collections	ARRAY
ad_group_ad.ad.url_custom_parameters	ARRAY
ad_group_ad.ad.video_ad.in_feed.description1	STRING
ad_group_ad.ad.video_ad.in_feed.description2	STRING
ad_group_ad.ad.video_ad.in_feed.headline	STRING
ad_group_ad.ad.video_ad.in_stream.action_button_label	STRING
ad_group_ad.ad.video_ad.in_stream.action_headline	STRING
ad_group_ad.ad.video_ad.out_stream.description	STRING
ad_group_ad.ad.video_ad.out_stream.headline	STRING
ad_group_ad.ad.video_responsive_ad.call_to_actions	ARRAY
ad_group_ad.ad.video_responsive_ad.companion_banners	ARRAY
ad_group_ad.ad.video_responsive_ad.descriptions	ARRAY
ad_group_ad.ad.video_responsive_ad.headlines	ARRAY
ad_group_ad.ad.video_responsive_ad.long_headlines	ARRAY
ad_group_ad.ad.video_responsive_ad.videos	ARRAY
ad_group_ad.ad_group	STRING
ad_group_ad.ad_strength	STRING
ad_group_ad.labels	ARRAY
ad_group_ad.policy_summary.approval_status	STRING
ad_group_ad.policy_summary.policy_topic_entries	ARRAY
ad_group_ad.policy_summary.review_status	STRING
ad_group_ad.resource_name	STRING
ad_group_ad.status	STRING
segments.date	STRING

keyword_report

Field name	Type
ad_group.id	INTEGER
ad_group_criterion.criterion_id	INTEGER
ad_group_criterion.keyword.match_type	STRING
ad_group_criterion.keyword.text	STRING
ad_group_criterion.negative	BOOLEAN
ad_group_criterion.type	STRING
campaign.bidding_strategy_type	STRING
customer.descriptive_name	STRING
metrics.clicks	INTEGER
metrics.cost_micros	INTEGER
metrics.ctr	NUMBER
metrics.historical_quality_score	INTEGER
metrics.impressions	INTEGER
segments.date	STRING

display_keyword_performance_report

Field name	Type
ad_group.base_ad_group	STRING
ad_group.id	INTEGER
ad_group.name	STRING
ad_group.status	STRING
ad_group.targeting_setting.target_restrictions	ARRAY
ad_group_criterion.criterion_id	INTEGER
ad_group_criterion.effective_cpc_bid_micros	INTEGER
ad_group_criterion.effective_cpc_bid_source	STRING
ad_group_criterion.effective_cpm_bid_micros	INTEGER
ad_group_criterion.effective_cpm_bid_source	STRING
ad_group_criterion.effective_cpv_bid_micros	INTEGER
ad_group_criterion.effective_cpv_bid_source	STRING
ad_group_criterion.final_mobile_urls	STRING
ad_group_criterion.final_urls	STRING
ad_group_criterion.keyword.match_type	STRING
ad_group_criterion.keyword.text	STRING
ad_group_criterion.negative	BOOLEAN
ad_group_criterion.status	STRING
ad_group_criterion.tracking_url_template	STRING
ad_group_criterion.url_custom_parameters	ARRAY
campaign.base_campaign	STRING
campaign.bidding_strategy	STRING
campaign.bidding_strategy_type	STRING
campaign.id	INTEGER
campaign.name	STRING
campaign.status	STRING
customer.currency_code	STRING
customer.descriptive_name	STRING
customer.id	INTEGER
customer.time_zone	STRING
metrics.active_view_cpm	NUMBER
metrics.active_view_ctr	NUMBER
metrics.active_view_impressions	INTEGER
metrics.active_view_measurability	NUMBER
metrics.active_view_measurable_cost_micros	INTEGER
metrics.active_view_measurable_impressions	INTEGER
metrics.active_view_viewability	NUMBER
metrics.all_conversions	NUMBER
metrics.all_conversions_from_interactions_rate	NUMBER
metrics.all_conversions_value	NUMBER
metrics.average_cost	NUMBER
metrics.average_cpc	NUMBER
metrics.average_cpe	NUMBER
metrics.average_cpm	NUMBER
metrics.average_cpv	NUMBER
metrics.clicks	INTEGER
metrics.conversions	NUMBER
metrics.conversions_from_interactions_rate	NUMBER
metrics.conversions_value	NUMBER
metrics.cost_micros	INTEGER
metrics.cost_per_all_conversions	NUMBER
metrics.cost_per_conversion	NUMBER
metrics.cross_device_conversions	NUMBER
metrics.ctr	NUMBER
metrics.engagement_rate	NUMBER
metrics.engagements	INTEGER
metrics.gmail_forwards	INTEGER
metrics.gmail_saves	INTEGER
metrics.gmail_secondary_clicks	INTEGER
metrics.impressions	INTEGER
metrics.interaction_event_types	ARRAY
metrics.interaction_rate	NUMBER
metrics.interactions	INTEGER
metrics.value_per_all_conversions	NUMBER
metrics.value_per_conversion	NUMBER
metrics.video_quartile_p100_rate	NUMBER
metrics.video_quartile_p25_rate	NUMBER
metrics.video_quartile_p50_rate	NUMBER
metrics.video_quartile_p75_rate	NUMBER
metrics.video_view_rate	NUMBER
metrics.video_views	INTEGER
metrics.view_through_conversions	INTEGER
segments.ad_network_type	STRING
segments.date	STRING
segments.day_of_week	STRING
segments.device	STRING
segments.month	STRING
segments.quarter	STRING
segments.week	STRING
segments.year	INTEGER

account_performance_report

Field name	Type
customer.auto_tagging_enabled	BOOLEAN
customer.currency_code	STRING
customer.descriptive_name	STRING
customer.id	INTEGER
customer.manager	BOOLEAN
customer.test_account	BOOLEAN
customer.time_zone	STRING
metrics.active_view_cpm	NUMBER
metrics.active_view_ctr	NUMBER
metrics.active_view_impressions	INTEGER
metrics.active_view_measurability	NUMBER
metrics.active_view_measurable_cost_micros	INTEGER
metrics.active_view_measurable_impressions	INTEGER
metrics.active_view_viewability	NUMBER
metrics.all_conversions	NUMBER
metrics.all_conversions_from_interactions_rate	NUMBER
metrics.all_conversions_value	NUMBER
metrics.average_cost	NUMBER
metrics.average_cpc	NUMBER
metrics.average_cpe	NUMBER
metrics.average_cpm	NUMBER
metrics.average_cpv	NUMBER
metrics.clicks	INTEGER
metrics.content_budget_lost_impression_share	NUMBER
metrics.content_impression_share	NUMBER
metrics.content_rank_lost_impression_share	NUMBER
metrics.conversions	NUMBER
metrics.conversions_from_interactions_rate	NUMBER
metrics.conversions_value	NUMBER
metrics.cost_micros	INTEGER
metrics.cost_per_all_conversions	NUMBER
metrics.cost_per_conversion	NUMBER
metrics.cross_device_conversions	NUMBER
metrics.ctr	NUMBER
metrics.engagement_rate	NUMBER
metrics.engagements	INTEGER
metrics.impressions	INTEGER
metrics.interaction_event_types	ARRAY
metrics.interaction_rate	NUMBER
metrics.interactions	INTEGER
metrics.search_budget_lost_impression_share	NUMBER
metrics.search_exact_match_impression_share	NUMBER
metrics.search_impression_share	NUMBER
metrics.search_rank_lost_impression_share	NUMBER
metrics.value_per_all_conversions	NUMBER
metrics.value_per_conversion	NUMBER
metrics.video_view_rate	NUMBER
metrics.video_views	INTEGER
metrics.view_through_conversions	INTEGER
segments.ad_network_type	STRING
segments.date	STRING
segments.day_of_week	STRING
segments.device	STRING
segments.month	STRING
segments.quarter	STRING
segments.week	STRING
segments.year	INTEGER

ad_group_ad_labels

Field name	Type
ad_group_ad.ad.resource_name	STRING
ad_group_ad_label.resource_name	STRING
label.name	STRING
label.resource_name	STRING

ad_group_ad_report

Field name	Type
ad_group.base_ad_group	STRING
ad_group.id	INTEGER
ad_group.name	STRING
ad_group.status	STRING
ad_group_ad.ad.added_by_google_ads	BOOLEAN
ad_group_ad.ad.app_ad.descriptions	ARRAY
ad_group_ad.ad.app_ad.headlines	ARRAY
ad_group_ad.ad.app_ad.html5_media_bundles	ARRAY
ad_group_ad.ad.app_ad.images	ARRAY
ad_group_ad.ad.app_ad.mandatory_ad_text	STRING
ad_group_ad.ad.app_ad.youtube_videos	ARRAY
ad_group_ad.ad.device_preference	STRING
ad_group_ad.ad.display_url	STRING
ad_group_ad.ad.expanded_dynamic_search_ad.description	STRING
ad_group_ad.ad.expanded_text_ad.description	STRING
ad_group_ad.ad.expanded_text_ad.description2	STRING
ad_group_ad.ad.expanded_text_ad.headline_part1	STRING
ad_group_ad.ad.expanded_text_ad.headline_part2	STRING
ad_group_ad.ad.expanded_text_ad.headline_part3	STRING
ad_group_ad.ad.expanded_text_ad.path1	STRING
ad_group_ad.ad.expanded_text_ad.path2	STRING
ad_group_ad.ad.final_mobile_urls	ARRAY
ad_group_ad.ad.final_urls	ARRAY
ad_group_ad.ad.gmail_ad.header_image	STRING
ad_group_ad.ad.gmail_ad.marketing_image	STRING
ad_group_ad.ad.gmail_ad.marketing_image_description	STRING
ad_group_ad.ad.gmail_ad.marketing_image_display_call_to_action.text	STRING
ad_group_ad.ad.gmail_ad.marketing_image_display_call_to_action.text_color	STRING
ad_group_ad.ad.gmail_ad.marketing_image_headline	STRING
ad_group_ad.ad.gmail_ad.teaser.business_name	STRING
ad_group_ad.ad.gmail_ad.teaser.description	STRING
ad_group_ad.ad.gmail_ad.teaser.headline	STRING
ad_group_ad.ad.gmail_ad.teaser.logo_image	STRING
ad_group_ad.ad.id	INTEGER
ad_group_ad.ad.image_ad.image_url	STRING
ad_group_ad.ad.image_ad.mime_type	STRING
ad_group_ad.ad.image_ad.name	STRING
ad_group_ad.ad.image_ad.pixel_height	INTEGER
ad_group_ad.ad.image_ad.pixel_width	INTEGER
ad_group_ad.ad.legacy_responsive_display_ad.accent_color	STRING
ad_group_ad.ad.legacy_responsive_display_ad.allow_flexible_color	BOOLEAN
ad_group_ad.ad.legacy_responsive_display_ad.business_name	STRING
ad_group_ad.ad.legacy_responsive_display_ad.call_to_action_text	STRING
ad_group_ad.ad.legacy_responsive_display_ad.format_setting	STRING
ad_group_ad.ad.legacy_responsive_display_ad.logo_image	STRING
ad_group_ad.ad.legacy_responsive_display_ad.long_headline	STRING
ad_group_ad.ad.legacy_responsive_display_ad.main_color	STRING
ad_group_ad.ad.legacy_responsive_display_ad.marketing_image	STRING
ad_group_ad.ad.legacy_responsive_display_ad.price_prefix	STRING
ad_group_ad.ad.legacy_responsive_display_ad.promo_text	STRING
ad_group_ad.ad.legacy_responsive_display_ad.short_headline	STRING
ad_group_ad.ad.legacy_responsive_display_ad.square_logo_image	STRING
ad_group_ad.ad.legacy_responsive_display_ad.square_marketing_image	STRING
ad_group_ad.ad.responsive_display_ad.accent_color	STRING
ad_group_ad.ad.responsive_display_ad.allow_flexible_color	BOOLEAN
ad_group_ad.ad.responsive_display_ad.business_name	STRING
ad_group_ad.ad.responsive_display_ad.call_to_action_text	STRING
ad_group_ad.ad.responsive_display_ad.descriptions	ARRAY
ad_group_ad.ad.responsive_display_ad.format_setting	STRING
ad_group_ad.ad.responsive_display_ad.headlines	ARRAY
ad_group_ad.ad.responsive_display_ad.logo_images	ARRAY
ad_group_ad.ad.responsive_display_ad.long_headline	STRING
ad_group_ad.ad.responsive_display_ad.main_color	STRING
ad_group_ad.ad.responsive_display_ad.marketing_images	ARRAY
ad_group_ad.ad.responsive_display_ad.price_prefix	STRING
ad_group_ad.ad.responsive_display_ad.promo_text	STRING
ad_group_ad.ad.responsive_display_ad.square_logo_images	ARRAY
ad_group_ad.ad.responsive_display_ad.square_marketing_images	ARRAY
ad_group_ad.ad.responsive_display_ad.youtube_videos	ARRAY
ad_group_ad.ad.responsive_search_ad.descriptions	ARRAY
ad_group_ad.ad.responsive_search_ad.headlines	ARRAY
ad_group_ad.ad.responsive_search_ad.path1	STRING
ad_group_ad.ad.responsive_search_ad.path2	STRING
ad_group_ad.ad.system_managed_resource_source	STRING
ad_group_ad.ad.text_ad.description1	STRING
ad_group_ad.ad.text_ad.description2	STRING
ad_group_ad.ad.text_ad.headline	STRING
ad_group_ad.ad.tracking_url_template	STRING
ad_group_ad.ad.type	STRING
ad_group_ad.ad.url_custom_parameters	ARRAY
ad_group_ad.ad_group	STRING
ad_group_ad.ad_strength	STRING
ad_group_ad.policy_summary.approval_status	STRING
ad_group_ad.status	STRING
campaign.base_campaign	STRING
campaign.id	INTEGER
campaign.name	STRING
campaign.status	STRING
customer.currency_code	STRING
customer.descriptive_name	STRING
customer.id	INTEGER
customer.time_zone	STRING
metrics.active_view_cpm	NUMBER
metrics.active_view_ctr	NUMBER
metrics.active_view_impressions	INTEGER
metrics.active_view_measurability	NUMBER
metrics.active_view_measurable_cost_micros	INTEGER
metrics.active_view_measurable_impressions	INTEGER
metrics.active_view_viewability	NUMBER
metrics.all_conversions	NUMBER
metrics.all_conversions_from_interactions_rate	NUMBER
metrics.all_conversions_value	NUMBER
metrics.average_cost	NUMBER
metrics.average_cpc	NUMBER
metrics.average_cpe	NUMBER
metrics.average_cpm	NUMBER
metrics.average_cpv	NUMBER
metrics.average_page_views	NUMBER
metrics.average_time_on_site	NUMBER
metrics.bounce_rate	NUMBER
metrics.clicks	INTEGER
metrics.conversions	NUMBER
metrics.conversions_from_interactions_rate	NUMBER
metrics.conversions_value	NUMBER
metrics.cost_micros	INTEGER
metrics.cost_per_all_conversions	NUMBER
metrics.cost_per_conversion	NUMBER
metrics.cost_per_current_model_attributed_conversion	NUMBER
metrics.cross_device_conversions	NUMBER
metrics.ctr	NUMBER
metrics.current_model_attributed_conversions	NUMBER
metrics.current_model_attributed_conversions_value	NUMBER
metrics.engagement_rate	NUMBER
metrics.engagements	INTEGER
metrics.gmail_forwards	INTEGER
metrics.gmail_saves	INTEGER
metrics.gmail_secondary_clicks	INTEGER
metrics.impressions	INTEGER
metrics.interaction_event_types	ARRAY
metrics.interaction_rate	NUMBER
metrics.interactions	INTEGER
metrics.percent_new_visitors	NUMBER
metrics.top_impression_percentage	NUMBER
metrics.value_per_all_conversions	NUMBER
metrics.value_per_conversion	NUMBER
metrics.value_per_current_model_attributed_conversion	NUMBER
metrics.video_quartile_p100_rate	NUMBER
metrics.video_quartile_p25_rate	NUMBER
metrics.video_quartile_p50_rate	NUMBER
metrics.video_quartile_p75_rate	NUMBER
metrics.video_view_rate	NUMBER
metrics.video_views	INTEGER
metrics.view_through_conversions	INTEGER
segments.ad_network_type	STRING
segments.date	STRING
segments.day_of_week	STRING
segments.month	STRING
segments.quarter	STRING
segments.week	STRING
segments.year	INTEGER

ad_group_labels

Field name	Type
ad_group.resource_name	STRING
ad_group_label.resource_name	STRING
label.name	STRING
label.resource_name	STRING

click_view

Field name	Type
ad_group.id	INTEGER
ad_group.name	STRING
campaign.id	INTEGER
campaign.name	STRING
campaign.network_settings.target_content_network	BOOLEAN
campaign.network_settings.target_google_search	BOOLEAN
campaign.network_settings.target_partner_search_network	BOOLEAN
campaign.network_settings.target_search_network	BOOLEAN
click_view.ad_group_ad	STRING
click_view.gclid	STRING
click_view.keyword	STRING
click_view.keyword_info.match_type	STRING
click_view.keyword_info.text	STRING
customer.id	INTEGER
segments.ad_network_type	STRING
segments.date	STRING

geographic_report

Field name	Type
ad_group.id	INTEGER
customer.descriptive_name	STRING
geographic_view.country_criterion_id	INTEGER
geographic_view.location_type	STRING
segments.date	STRING

accounts

Field name	Type
customer.auto_tagging_enabled	BOOLEAN
customer.call_reporting_setting.call_conversion_action	STRING
customer.call_reporting_setting.call_conversion_reporting_enabled	BOOLEAN
customer.call_reporting_setting.call_reporting_enabled	BOOLEAN
customer.conversion_tracking_setting.conversion_tracking_id	INTEGER
customer.conversion_tracking_setting.cross_account_conversion_tracking_id	INTEGER
customer.currency_code	STRING
customer.descriptive_name	STRING
customer.final_url_suffix	STRING
customer.has_partners_badge	BOOLEAN
customer.id	INTEGER
customer.manager	BOOLEAN
customer.optimization_score	NUMBER
customer.optimization_score_weight	NUMBER
customer.pay_per_conversion_eligibility_failure_reasons	ARRAY
customer.remarketing_setting.google_global_site_tag	STRING
customer.resource_name	STRING
customer.test_account	BOOLEAN
customer.time_zone	STRING
customer.tracking_url_template	STRING
segments.date	STRING

display_topics_performance_report

Field name	Type
ad_group.base_ad_group	STRING
ad_group.id	INTEGER
ad_group.name	STRING
ad_group.status	STRING
ad_group.targeting_setting.target_restrictions	ARRAY
ad_group_criterion.bid_modifier	NUMBER
ad_group_criterion.criterion_id	INTEGER
ad_group_criterion.effective_cpc_bid_micros	INTEGER
ad_group_criterion.effective_cpc_bid_source	STRING
ad_group_criterion.effective_cpm_bid_micros	INTEGER
ad_group_criterion.effective_cpm_bid_source	STRING
ad_group_criterion.final_mobile_urls	STRING
ad_group_criterion.final_urls	STRING
ad_group_criterion.negative	BOOLEAN
ad_group_criterion.status	STRING
ad_group_criterion.topic.path	ARRAY
ad_group_criterion.topic.topic_constant	STRING
ad_group_criterion.tracking_url_template	STRING
ad_group_criterion.url_custom_parameters	ARRAY
campaign.base_campaign	STRING
campaign.bidding_strategy	STRING
campaign.bidding_strategy_type	STRING
campaign.id	INTEGER
campaign.name	STRING
campaign.status	STRING
customer.currency_code	STRING
customer.descriptive_name	STRING
customer.id	INTEGER
customer.time_zone	STRING
metrics.active_view_cpm	NUMBER
metrics.active_view_ctr	NUMBER
metrics.active_view_impressions	INTEGER
metrics.active_view_measurability	NUMBER
metrics.active_view_measurable_cost_micros	INTEGER
metrics.active_view_measurable_impressions	INTEGER
metrics.active_view_viewability	NUMBER
metrics.all_conversions	NUMBER
metrics.all_conversions_from_interactions_rate	NUMBER
metrics.all_conversions_value	NUMBER
metrics.average_cost	NUMBER
metrics.average_cpc	NUMBER
metrics.average_cpe	NUMBER
metrics.average_cpm	NUMBER
metrics.average_cpv	NUMBER
metrics.clicks	INTEGER
metrics.conversions	NUMBER
metrics.conversions_from_interactions_rate	NUMBER
metrics.conversions_value	NUMBER
metrics.cost_micros	INTEGER
metrics.cost_per_all_conversions	NUMBER
metrics.cost_per_conversion	NUMBER
metrics.cross_device_conversions	NUMBER
metrics.ctr	NUMBER
metrics.engagement_rate	NUMBER
metrics.engagements	INTEGER
metrics.gmail_forwards	INTEGER
metrics.gmail_saves	INTEGER
metrics.gmail_secondary_clicks	INTEGER
metrics.impressions	INTEGER
metrics.interaction_event_types	ARRAY
metrics.interaction_rate	NUMBER
metrics.interactions	INTEGER
metrics.value_per_all_conversions	NUMBER
metrics.value_per_conversion	NUMBER
metrics.video_quartile_p100_rate	NUMBER
metrics.video_quartile_p25_rate	NUMBER
metrics.video_quartile_p50_rate	NUMBER
metrics.video_quartile_p75_rate	NUMBER
metrics.video_view_rate	NUMBER
metrics.video_views	INTEGER
metrics.view_through_conversions	INTEGER
segments.ad_network_type	STRING
segments.date	STRING
segments.day_of_week	STRING
segments.device	STRING
segments.month	STRING
segments.quarter	STRING
segments.week	STRING
segments.year	INTEGER

shopping_performance_report

Field name	Type
ad_group.id	INTEGER
ad_group.name	STRING
ad_group.status	STRING
campaign.id	INTEGER
campaign.name	STRING
campaign.status	STRING
customer.descriptive_name	STRING
customer.id	INTEGER
metrics.all_conversions	NUMBER
metrics.all_conversions_from_interactions_rate	NUMBER
metrics.all_conversions_value	NUMBER
metrics.average_cpc	NUMBER
metrics.clicks	INTEGER
metrics.conversions	NUMBER
metrics.conversions_from_interactions_rate	NUMBER
metrics.conversions_value	NUMBER
metrics.cost_micros	INTEGER
metrics.cost_per_all_conversions	NUMBER
metrics.cost_per_conversion	NUMBER
metrics.cross_device_conversions	NUMBER
metrics.ctr	NUMBER
metrics.impressions	INTEGER
metrics.value_per_all_conversions	NUMBER
metrics.value_per_conversion	NUMBER
segments.ad_network_type	STRING
segments.click_type	STRING
segments.date	STRING
segments.day_of_week	STRING
segments.device	STRING
segments.month	STRING
segments.product_aggregator_id	INTEGER
segments.product_bidding_category_level1	STRING
segments.product_bidding_category_level2	STRING
segments.product_bidding_category_level3	STRING
segments.product_bidding_category_level4	STRING
segments.product_bidding_category_level5	STRING
segments.product_brand	STRING
segments.product_channel	STRING
segments.product_channel_exclusivity	STRING
segments.product_condition	STRING
segments.product_country	STRING
segments.product_custom_attribute0	STRING
segments.product_custom_attribute1	STRING
segments.product_custom_attribute2	STRING
segments.product_custom_attribute3	STRING
segments.product_custom_attribute4	STRING
segments.product_item_id	STRING
segments.product_language	STRING
segments.product_merchant_id	INTEGER
segments.product_store_id	STRING
segments.product_title	STRING
segments.product_type_l1	STRING
segments.product_type_l2	STRING
segments.product_type_l3	STRING
segments.product_type_l4	STRING
segments.product_type_l5	STRING
segments.quarter	STRING
segments.week	STRING
segments.year	INTEGER

ad_groups

Field name	Type
ad_group.ad_rotation_mode	STRING
ad_group.base_ad_group	STRING
ad_group.campaign	STRING
ad_group.cpc_bid_micros	INTEGER
ad_group.cpm_bid_micros	INTEGER
ad_group.cpv_bid_micros	INTEGER
ad_group.display_custom_bid_dimension	STRING
ad_group.effective_target_cpa_micros	INTEGER
ad_group.effective_target_cpa_source	STRING
ad_group.effective_target_roas	NUMBER
ad_group.effective_target_roas_source	STRING
ad_group.excluded_parent_asset_field_types	ARRAY
ad_group.explorer_auto_optimizer_setting.opt_in	BOOLEAN
ad_group.final_url_suffix	STRING
ad_group.id	INTEGER
ad_group.labels	ARRAY
ad_group.name	STRING
ad_group.percent_cpc_bid_micros	INTEGER
ad_group.resource_name	STRING
ad_group.status	STRING
ad_group.target_cpa_micros	INTEGER
ad_group.target_cpm_micros	INTEGER
ad_group.target_roas	NUMBER
ad_group.targeting_setting.target_restrictions	ARRAY
ad_group.tracking_url_template	STRING
ad_group.type	STRING
ad_group.url_custom_parameters	ARRAY
segments.date	STRING

user_location_report

Field name	Type
ad_group.base_ad_group	STRING
ad_group.name	STRING
ad_group.status	STRING
campaign.base_campaign	STRING
campaign.id	INTEGER
campaign.name	STRING
campaign.status	STRING
customer.currency_code	STRING
customer.descriptive_name	STRING
customer.id	INTEGER
customer.time_zone	STRING
metrics.all_conversions	NUMBER
metrics.all_conversions_from_interactions_rate	NUMBER
metrics.all_conversions_value	NUMBER
metrics.average_cost	NUMBER
metrics.average_cpc	NUMBER
metrics.average_cpm	NUMBER
metrics.average_cpv	NUMBER
metrics.clicks	NUMBER
metrics.conversions	NUMBER
metrics.conversions_from_interactions_rate	NUMBER
metrics.conversions_value	NUMBER
metrics.cost_micros	NUMBER
metrics.cost_per_all_conversions	NUMBER
metrics.cost_per_conversion	NUMBER
metrics.cross_device_conversions	NUMBER
metrics.ctr	NUMBER
metrics.impressions	NUMBER
metrics.interaction_event_types	ARRAY
metrics.interaction_rate	NUMBER
metrics.interactions	NUMBER
metrics.value_per_all_conversions	NUMBER
metrics.value_per_conversion	NUMBER
metrics.video_view_rate	NUMBER
metrics.video_views	NUMBER
metrics.view_through_conversions	NUMBER
segments.ad_network_type	STRING
segments.date	STRING
segments.day_of_week	STRING
segments.month	STRING
segments.quarter	STRING
segments.week	STRING
segments.year	INTEGER
user_location_view.country_criterion_id	INTEGER
user_location_view.resource_name	STRING

campaign_labels

Field name	Type
campaign.resource_name	STRING
campaign_label.resource_name	STRING
label.name	STRING
label.resource_name	STRING

service_accounts

Field name	Type
customer.auto_tagging_enabled	BOOLEAN
customer.call_reporting_setting.call_conversion_action	STRING
customer.call_reporting_setting.call_conversion_reporting_enabled	BOOLEAN
customer.call_reporting_setting.call_reporting_enabled	BOOLEAN
customer.conversion_tracking_setting.conversion_tracking_id	INTEGER
customer.conversion_tracking_setting.cross_account_conversion_tracking_id	INTEGER
customer.currency_code	STRING
customer.descriptive_name	STRING
customer.final_url_suffix	STRING
customer.has_partners_badge	BOOLEAN
customer.id	INTEGER
customer.manager	BOOLEAN
customer.optimization_score	NUMBER
customer.optimization_score_weight	NUMBER
customer.pay_per_conversion_eligibility_failure_reasons	ARRAY
customer.remarketing_setting.google_global_site_tag	STRING
customer.resource_name	STRING
customer.test_account	BOOLEAN
customer.time_zone	STRING
customer.tracking_url_template	STRING