Google Ads → Google BigQuery: data schema

account_labels

Field name	Type
customer_id	INTEGER
customer_label_label	STRING
customer_label_customer	STRING
customer_label_resource_name	STRING

ad_group_ad_labels

Field name	Type
label_id	INTEGER
label_name	STRING
ad_group_id	INTEGER
ad_group_ad_ad_id	INTEGER
label_resource_name	STRING
ad_group_ad_ad_resource_name	STRING
ad_group_ad_label_resource_name	STRING

ad_group_criterion_labels

Field name	Type
label_id	INTEGER
ad_group_id	INTEGER
ad_group_criterion_label_label	STRING
ad_group_criterion_criterion_id	INTEGER
ad_group_criterion_label_resource_name	STRING
ad_group_criterion_label_ad_group_criterion	STRING

ad_group_labels

Field name	Type
label_id	INTEGER
label_name	STRING
ad_group_id	INTEGER
label_resource_name	STRING
ad_group_resource_name	STRING
ad_group_label_resource_name	STRING

audience

Field name	Type
audience_id	INTEGER
customer_id	INTEGER
audience_name	STRING
audience_status	STRING
audience_dimensions	STRING
audience_description	STRING
audience_resource_name	STRING
audience_exclusion_dimension	STRING

campaign_labels

Field name	Type
label_id	INTEGER
label_name	STRING
campaign_id	INTEGER
label_resource_name	STRING
campaign_resource_name	STRING
campaign_label_resource_name	STRING

labels

Field name	Type
label_id	STRING
label_name	STRING
customer_id	INTEGER
label_status	STRING
label_resource_name	STRING
label_text_label_description	STRING
label_text_label_background_color	STRING

user_interest

Field name	Type
user_interest_name	STRING
user_interest_resource_name	STRING
user_interest_taxonomy_type	STRING
user_interest_availabilities	STRING
user_interest_launched_to_all	BOOLEAN
user_interest_user_interest_id	INTEGER
user_interest_user_interest_parent	STRING

account_performance_report

Field name	Type
customer_id	INTEGER
metrics_ctr	FLOAT
segments_date	DATE
segments_week	STRING
segments_year	INTEGER
metrics_clicks	INTEGER
segments_month	STRING
segments_device	STRING
customer_manager	BOOLEAN
segments_quarter	STRING
customer_time_zone	STRING
metrics_average_cpc	FLOAT
metrics_average_cpe	FLOAT
metrics_average_cpm	FLOAT
metrics_average_cpv	FLOAT
metrics_conversions	FLOAT
metrics_cost_micros	INTEGER
metrics_engagements	INTEGER
metrics_impressions	INTEGER
metrics_video_views	INTEGER
metrics_average_cost	FLOAT
metrics_interactions	INTEGER
segments_day_of_week	STRING
customer_test_account	BOOLEAN
customer_currency_code	STRING
metrics_active_view_cpm	FLOAT
metrics_active_view_ctr	FLOAT
metrics_all_conversions	FLOAT
metrics_engagement_rate	FLOAT
metrics_video_view_rate	FLOAT
metrics_interaction_rate	FLOAT
segments_ad_network_type	STRING
customer_descriptive_name	STRING
metrics_conversions_value	FLOAT
metrics_cost_per_conversion	FLOAT
metrics_value_per_conversion	FLOAT
customer_auto_tagging_enabled	BOOLEAN
metrics_all_conversions_value	FLOAT
metrics_active_view_impressions	INTEGER
metrics_active_view_viewability	FLOAT
metrics_interaction_event_types	STRING
metrics_search_impression_share	FLOAT
metrics_content_impression_share	FLOAT
metrics_cost_per_all_conversions	FLOAT
metrics_cross_device_conversions	FLOAT
metrics_view_through_conversions	INTEGER
metrics_active_view_measurability	FLOAT
metrics_value_per_all_conversions	FLOAT
metrics_search_rank_lost_impression_share	FLOAT
metrics_active_view_measurable_cost_micros	INTEGER
metrics_active_view_measurable_impressions	INTEGER
metrics_content_rank_lost_impression_share	FLOAT
metrics_conversions_from_interactions_rate	FLOAT
metrics_search_budget_lost_impression_share	FLOAT
metrics_search_exact_match_impression_share	FLOAT
metrics_content_budget_lost_impression_share	FLOAT
metrics_all_conversions_from_interactions_rate	FLOAT

accounts

Field name	Type
customer_id	INTEGER
segments_date	DATE
customer_manager	BOOLEAN
customer_time_zone	STRING
customer_test_account	BOOLEAN
customer_currency_code	STRING
customer_resource_name	STRING
customer_descriptive_name	STRING
customer_final_url_suffix	STRING
customer_has_partners_badge	BOOLEAN
customer_optimization_score	FLOAT
customer_auto_tagging_enabled	BOOLEAN
customer_tracking_url_template	STRING
customer_optimization_score_weight	FLOAT
customer_remarketing_setting_google_global_site_tag	STRING
customer_call_reporting_setting_call_conversion_action	STRING
customer_call_reporting_setting_call_reporting_enabled	BOOLEAN
customer_pay_per_conversion_eligibility_failure_reasons	STRING
customer_call_reporting_setting_call_conversion_reporting_enabled	BOOLEAN

ad_group_ad_report

Field name	Type
ad_group_id	INTEGER
campaign_id	INTEGER
customer_id	INTEGER
metrics_ctr	FLOAT
ad_group_name	STRING
campaign_name	STRING
segments_date	DATE
segments_week	STRING
segments_year	INTEGER
metrics_clicks	INTEGER
segments_month	STRING
ad_group_status	STRING
campaign_status	STRING
segments_quarter	STRING
ad_group_ad_ad_id	INTEGER
ad_group_ad_status	STRING
customer_time_zone	STRING
ad_group_ad_ad_type	STRING
metrics_average_cpc	FLOAT
metrics_average_cpe	FLOAT
metrics_average_cpm	FLOAT
metrics_average_cpv	FLOAT
metrics_bounce_rate	FLOAT
metrics_conversions	FLOAT
metrics_cost_micros	INTEGER
metrics_engagements	INTEGER
metrics_gmail_saves	INTEGER
metrics_impressions	INTEGER
metrics_video_views	INTEGER
ad_group_ad_ad_group	STRING
metrics_average_cost	FLOAT
metrics_interactions	INTEGER
segments_day_of_week	STRING
ad_group_base_ad_group	STRING
campaign_base_campaign	STRING
customer_currency_code	STRING
metrics_gmail_forwards	INTEGER
ad_group_ad_ad_strength	STRING
metrics_active_view_cpm	FLOAT
metrics_active_view_ctr	FLOAT
metrics_all_conversions	FLOAT
metrics_engagement_rate	FLOAT
metrics_video_view_rate	FLOAT
metrics_interaction_rate	FLOAT
segments_ad_network_type	STRING
ad_group_ad_ad_final_urls	STRING
customer_descriptive_name	STRING
metrics_conversions_value	FLOAT
ad_group_ad_ad_display_url	STRING
metrics_average_page_views	FLOAT
metrics_cost_per_conversion	FLOAT
ad_group_ad_ad_app_ad_images	STRING
ad_group_ad_ad_image_ad_name	STRING
metrics_average_time_on_site	FLOAT
metrics_percent_new_visitors	FLOAT
metrics_value_per_conversion	FLOAT
metrics_all_conversions_value	FLOAT
metrics_gmail_secondary_clicks	INTEGER
ad_group_ad_ad_app_ad_headlines	STRING
ad_group_ad_ad_text_ad_headline	STRING
metrics_active_view_impressions	INTEGER
metrics_active_view_viewability	FLOAT
metrics_interaction_event_types	STRING
metrics_video_quartile_p25_rate	FLOAT
metrics_video_quartile_p50_rate	FLOAT
metrics_video_quartile_p75_rate	FLOAT
ad_group_ad_ad_device_preference	STRING
ad_group_ad_ad_final_mobile_urls	STRING
metrics_cost_per_all_conversions	FLOAT
metrics_cross_device_conversions	FLOAT
metrics_video_quartile_p100_rate	FLOAT
metrics_view_through_conversions	INTEGER
ad_group_ad_ad_image_ad_image_url	STRING
ad_group_ad_ad_image_ad_mime_type	STRING
metrics_active_view_measurability	FLOAT
metrics_top_impression_percentage	FLOAT
metrics_value_per_all_conversions	FLOAT
ad_group_ad_ad_added_by_google_ads	BOOLEAN
ad_group_ad_ad_app_ad_descriptions	STRING
ad_group_ad_ad_image_ad_pixel_width	INTEGER
ad_group_ad_ad_text_ad_description1	STRING
ad_group_ad_ad_text_ad_description2	STRING
ad_group_ad_ad_app_ad_youtube_videos	STRING
ad_group_ad_ad_image_ad_pixel_height	INTEGER
ad_group_ad_ad_tracking_url_template	STRING
ad_group_ad_ad_url_custom_parameters	STRING
ad_group_ad_ad_expanded_text_ad_path1	STRING
ad_group_ad_ad_expanded_text_ad_path2	STRING
ad_group_ad_ad_app_ad_mandatory_ad_text	STRING
ad_group_ad_ad_app_ad_html5_media_bundles	STRING
ad_group_ad_ad_responsive_search_ad_path1	STRING
ad_group_ad_ad_responsive_search_ad_path2	STRING
ad_group_ad_policy_summary_approval_status	STRING
metrics_active_view_measurable_cost_micros	INTEGER
metrics_active_view_measurable_impressions	INTEGER
metrics_conversions_from_interactions_rate	FLOAT
ad_group_ad_ad_expanded_text_ad_description	STRING
ad_group_ad_ad_expanded_text_ad_description2	STRING
metrics_current_model_attributed_conversions	FLOAT
ad_group_ad_ad_responsive_search_ad_headlines	STRING
ad_group_ad_ad_system_managed_resource_source	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_responsive_display_ad_headlines	STRING
metrics_all_conversions_from_interactions_rate	FLOAT
ad_group_ad_ad_responsive_display_ad_main_color	STRING
ad_group_ad_ad_responsive_display_ad_promo_text	STRING
ad_group_ad_ad_responsive_display_ad_logo_images	STRING
ad_group_ad_ad_responsive_search_ad_descriptions	STRING
ad_group_ad_ad_responsive_display_ad_accent_color	STRING
ad_group_ad_ad_responsive_display_ad_descriptions	STRING
ad_group_ad_ad_responsive_display_ad_price_prefix	STRING
ad_group_ad_ad_responsive_display_ad_business_name	STRING
ad_group_ad_ad_responsive_display_ad_long_headline	STRING
metrics_current_model_attributed_conversions_value	FLOAT
ad_group_ad_ad_responsive_display_ad_format_setting	STRING
ad_group_ad_ad_responsive_display_ad_youtube_videos	STRING
metrics_cost_per_current_model_attributed_conversion	FLOAT
ad_group_ad_ad_expanded_dynamic_search_ad_description	STRING
ad_group_ad_ad_responsive_display_ad_marketing_images	STRING
metrics_value_per_current_model_attributed_conversion	FLOAT
ad_group_ad_ad_legacy_responsive_display_ad_logo_image	STRING
ad_group_ad_ad_legacy_responsive_display_ad_main_color	STRING
ad_group_ad_ad_legacy_responsive_display_ad_promo_text	STRING
ad_group_ad_ad_responsive_display_ad_square_logo_images	STRING
ad_group_ad_ad_legacy_responsive_display_ad_accent_color	STRING
ad_group_ad_ad_legacy_responsive_display_ad_price_prefix	STRING
ad_group_ad_ad_responsive_display_ad_call_to_action_text	STRING
ad_group_ad_ad_legacy_responsive_display_ad_business_name	STRING
ad_group_ad_ad_legacy_responsive_display_ad_long_headline	STRING
ad_group_ad_ad_responsive_display_ad_allow_flexible_color	BOOLEAN
ad_group_ad_ad_legacy_responsive_display_ad_format_setting	STRING
ad_group_ad_ad_legacy_responsive_display_ad_short_headline	STRING
ad_group_ad_ad_legacy_responsive_display_ad_marketing_image	STRING
ad_group_ad_ad_responsive_display_ad_square_marketing_images	STRING
ad_group_ad_ad_legacy_responsive_display_ad_square_logo_image	STRING
ad_group_ad_ad_legacy_responsive_display_ad_call_to_action_text	STRING
ad_group_ad_ad_legacy_responsive_display_ad_allow_flexible_color	BOOLEAN
ad_group_ad_ad_legacy_responsive_display_ad_square_marketing_image	STRING

ad_group_ads

Field name	Type
ad_group_id	INTEGER
segments_date	DATE
ad_group_ad_ad_id	INTEGER
ad_group_ad_labels	STRING
ad_group_ad_status	STRING
ad_group_ad_ad_name	STRING
ad_group_ad_ad_type	STRING
ad_group_ad_ad_group	STRING
ad_group_ad_ad_hotel_ad	STRING
ad_group_ad_ad_strength	STRING
ad_group_ad_ad_final_urls	STRING
ad_group_ad_resource_name	STRING
ad_group_ad_ad_display_url	STRING
ad_group_ad_ad_app_ad_images	STRING
ad_group_ad_ad_call_ad_path1	STRING
ad_group_ad_ad_call_ad_path2	STRING
ad_group_ad_ad_image_ad_name	STRING
ad_group_ad_ad_final_app_urls	STRING
ad_group_ad_ad_local_ad_path1	STRING
ad_group_ad_ad_local_ad_path2	STRING
ad_group_ad_ad_local_ad_videos	STRING
ad_group_ad_ad_url_collections	STRING
ad_group_ad_ad_app_ad_headlines	STRING
ad_group_ad_ad_final_url_suffix	STRING
ad_group_ad_ad_text_ad_headline	STRING
ad_group_ad_ad_call_ad_headline1	STRING
ad_group_ad_ad_call_ad_headline2	STRING
ad_group_ad_ad_device_preference	STRING
ad_group_ad_ad_final_mobile_urls	STRING
ad_group_ad_ad_shopping_smart_ad	STRING
ad_group_ad_ad_image_ad_image_url	STRING
ad_group_ad_ad_image_ad_mime_type	STRING
ad_group_ad_ad_local_ad_headlines	STRING
ad_group_ad_ad_added_by_google_ads	BOOLEAN
ad_group_ad_ad_app_ad_descriptions	STRING
ad_group_ad_ad_shopping_product_ad	STRING
ad_group_ad_ad_call_ad_call_tracked	BOOLEAN
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_phone_number	STRING
ad_group_ad_ad_image_ad_pixel_width	INTEGER
ad_group_ad_ad_local_ad_logo_images	STRING
ad_group_ad_ad_text_ad_description1	STRING
ad_group_ad_ad_text_ad_description2	STRING
ad_group_ad_ad_app_ad_youtube_videos	STRING
ad_group_ad_ad_call_ad_business_name	STRING
ad_group_ad_ad_image_ad_pixel_height	INTEGER
ad_group_ad_ad_legacy_app_install_ad	STRING
ad_group_ad_ad_local_ad_descriptions	STRING
ad_group_ad_ad_tracking_url_template	STRING
ad_group_ad_ad_url_custom_parameters	STRING
ad_group_ad_ad_expanded_text_ad_path1	STRING
ad_group_ad_ad_expanded_text_ad_path2	STRING
ad_group_ad_ad_app_ad_mandatory_ad_text	STRING
ad_group_ad_ad_app_engagement_ad_images	STRING
ad_group_ad_ad_app_engagement_ad_videos	STRING
ad_group_ad_ad_local_ad_call_to_actions	STRING
ad_group_ad_ad_call_ad_conversion_action	STRING
ad_group_ad_ad_local_ad_marketing_images	STRING
ad_group_ad_ad_video_ad_in_feed_headline	STRING
ad_group_ad_policy_summary_review_status	STRING
ad_group_ad_ad_app_ad_html5_media_bundles	STRING
ad_group_ad_ad_image_ad_preview_image_url	STRING
ad_group_ad_ad_responsive_search_ad_path1	STRING
ad_group_ad_ad_responsive_search_ad_path2	STRING
ad_group_ad_ad_video_responsive_ad_videos	STRING
ad_group_ad_ad_app_engagement_ad_headlines	STRING
ad_group_ad_ad_smart_campaign_ad_headlines	STRING
ad_group_ad_policy_summary_approval_status	STRING
ad_group_ad_ad_expanded_text_ad_description	STRING
ad_group_ad_ad_image_ad_preview_pixel_width	INTEGER
ad_group_ad_ad_video_ad_out_stream_headline	STRING
ad_group_ad_ad_expanded_text_ad_description2	STRING
ad_group_ad_ad_image_ad_preview_pixel_height	INTEGER
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_responsive_ad_headlines	STRING
ad_group_ad_ad_app_engagement_ad_descriptions	STRING
ad_group_ad_ad_display_upload_ad_media_bundle	STRING
ad_group_ad_ad_responsive_search_ad_headlines	STRING
ad_group_ad_ad_smart_campaign_ad_descriptions	STRING
ad_group_ad_ad_system_managed_resource_source	STRING
ad_group_ad_ad_call_ad_disable_call_conversion	BOOLEAN
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_responsive_display_ad_headlines	STRING
ad_group_ad_ad_video_ad_out_stream_description	STRING
ad_group_ad_ad_responsive_display_ad_main_color	STRING
ad_group_ad_ad_responsive_display_ad_promo_text	STRING
ad_group_ad_ad_video_responsive_ad_descriptions	STRING
ad_group_ad_policy_summary_policy_topic_entries	STRING
ad_group_ad_ad_responsive_display_ad_logo_images	STRING
ad_group_ad_ad_responsive_search_ad_descriptions	STRING
ad_group_ad_ad_call_ad_conversion_reporting_state	STRING
ad_group_ad_ad_responsive_display_ad_accent_color	STRING
ad_group_ad_ad_responsive_display_ad_descriptions	STRING
ad_group_ad_ad_responsive_display_ad_price_prefix	STRING
ad_group_ad_ad_video_ad_in_stream_action_headline	STRING
ad_group_ad_ad_video_responsive_ad_long_headlines	STRING
ad_group_ad_ad_responsive_display_ad_business_name	STRING
ad_group_ad_ad_responsive_display_ad_long_headline	STRING
ad_group_ad_ad_video_responsive_ad_call_to_actions	STRING
ad_group_ad_ad_responsive_display_ad_format_setting	STRING
ad_group_ad_ad_responsive_display_ad_youtube_videos	STRING
ad_group_ad_ad_call_ad_phone_number_verification_url	STRING
ad_group_ad_ad_video_responsive_ad_companion_banners	STRING
ad_group_ad_ad_expanded_dynamic_search_ad_description	STRING
ad_group_ad_ad_responsive_display_ad_marketing_images	STRING
ad_group_ad_ad_video_ad_in_stream_action_button_label	STRING
ad_group_ad_ad_expanded_dynamic_search_ad_description2	STRING
ad_group_ad_ad_legacy_responsive_display_ad_logo_image	STRING
ad_group_ad_ad_legacy_responsive_display_ad_main_color	STRING
ad_group_ad_ad_legacy_responsive_display_ad_promo_text	STRING
ad_group_ad_ad_shopping_comparison_listing_ad_headline	STRING
ad_group_ad_ad_legacy_responsive_display_ad_description	STRING
ad_group_ad_ad_responsive_display_ad_square_logo_images	STRING
ad_group_ad_ad_legacy_responsive_display_ad_accent_color	STRING
ad_group_ad_ad_legacy_responsive_display_ad_price_prefix	STRING
ad_group_ad_ad_responsive_display_ad_call_to_action_text	STRING
ad_group_ad_ad_legacy_responsive_display_ad_business_name	STRING
ad_group_ad_ad_legacy_responsive_display_ad_long_headline	STRING
ad_group_ad_ad_responsive_display_ad_allow_flexible_color	BOOLEAN
ad_group_ad_ad_legacy_responsive_display_ad_format_setting	STRING
ad_group_ad_ad_legacy_responsive_display_ad_short_headline	STRING
ad_group_ad_ad_legacy_responsive_display_ad_marketing_image	STRING
ad_group_ad_ad_display_upload_ad_display_upload_product_type	STRING
ad_group_ad_ad_responsive_display_ad_square_marketing_images	STRING
ad_group_ad_ad_legacy_responsive_display_ad_square_logo_image	STRING
ad_group_ad_ad_legacy_responsive_display_ad_call_to_action_text	STRING
ad_group_ad_ad_legacy_responsive_display_ad_allow_flexible_color	BOOLEAN
ad_group_ad_ad_legacy_responsive_display_ad_square_marketing_image	STRING
ad_group_ad_ad_responsive_display_ad_control_spec_enable_autogen_video	BOOLEAN
ad_group_ad_ad_responsive_display_ad_control_spec_enable_asset_enhancements	BOOLEAN

ad_group_bidding_strategies

Field name	Type
ad_group_id	INTEGER
segments_date	DATE
bidding_strategy_id	INTEGER
bidding_strategy_name	STRING
bidding_strategy_type	STRING
bidding_strategy_status	STRING
bidding_strategy_enhanced_cpc	STRING
bidding_strategy_currency_code	STRING
bidding_strategy_resource_name	STRING
bidding_strategy_campaign_count	INTEGER
bidding_strategy_effective_currency_code	STRING
bidding_strategy_target_roas_target_roas	FLOAT
bidding_strategy_aligned_campaign_budget_id	INTEGER
bidding_strategy_non_removed_campaign_count	INTEGER
bidding_strategy_target_cpa_target_cpa_micros	INTEGER
bidding_strategy_target_cpa_cpc_bid_floor_micros	INTEGER
bidding_strategy_target_impression_share_location	STRING
bidding_strategy_target_roas_cpc_bid_floor_micros	INTEGER
bidding_strategy_target_spend_target_spend_micros	INTEGER
bidding_strategy_target_cpa_cpc_bid_ceiling_micros	INTEGER
bidding_strategy_target_roas_cpc_bid_ceiling_micros	INTEGER
bidding_strategy_target_spend_cpc_bid_ceiling_micros	INTEGER
bidding_strategy_maximize_conversion_value_target_roas	FLOAT
bidding_strategy_maximize_conversions_target_cpa_micros	INTEGER
bidding_strategy_maximize_conversions_cpc_bid_floor_micros	INTEGER
bidding_strategy_maximize_conversions_cpc_bid_ceiling_micros	INTEGER
bidding_strategy_maximize_conversion_value_cpc_bid_floor_micros	INTEGER
bidding_strategy_target_impression_share_cpc_bid_ceiling_micros	INTEGER
bidding_strategy_maximize_conversion_value_cpc_bid_ceiling_micros	INTEGER
bidding_strategy_target_impression_share_location_fraction_micros	INTEGER

ad_groups

Field name	Type
ad_group_id	INTEGER
campaign_id	INTEGER
ad_group_name	STRING
ad_group_type	STRING
segments_date	DATE
ad_group_labels	STRING
ad_group_status	STRING
ad_group_campaign	STRING
metrics_cost_micros	INTEGER
ad_group_target_roas	FLOAT
ad_group_base_ad_group	STRING
ad_group_resource_name	STRING
ad_group_cpc_bid_micros	INTEGER
ad_group_cpm_bid_micros	INTEGER
ad_group_cpv_bid_micros	INTEGER
ad_group_ad_rotation_mode	STRING
ad_group_final_url_suffix	STRING
ad_group_target_cpa_micros	INTEGER
ad_group_target_cpm_micros	INTEGER
ad_group_effective_target_roas	FLOAT
ad_group_tracking_url_template	STRING
ad_group_url_custom_parameters	STRING
ad_group_percent_cpc_bid_micros	INTEGER
ad_group_effective_target_cpa_micros	INTEGER
ad_group_effective_target_cpa_source	STRING
ad_group_optimized_targeting_enabled	BOOLEAN
ad_group_display_custom_bid_dimension	STRING
ad_group_effective_target_roas_source	STRING
ad_group_excluded_parent_asset_field_types	STRING
ad_group_targeting_setting_target_restrictions	STRING

campaign_bidding_strategies

Field name	Type
campaign_id	INTEGER
customer_id	INTEGER
segments_date	DATE
bidding_strategy_id	INTEGER
bidding_strategy_name	STRING
bidding_strategy_type	STRING
bidding_strategy_status	STRING
bidding_strategy_enhanced_cpc	STRING
bidding_strategy_currency_code	STRING
bidding_strategy_resource_name	STRING
bidding_strategy_campaign_count	INTEGER
bidding_strategy_effective_currency_code	STRING
bidding_strategy_target_roas_target_roas	FLOAT
bidding_strategy_aligned_campaign_budget_id	INTEGER
bidding_strategy_non_removed_campaign_count	INTEGER
bidding_strategy_target_cpa_target_cpa_micros	INTEGER
bidding_strategy_target_cpa_cpc_bid_floor_micros	INTEGER
bidding_strategy_target_impression_share_location	STRING
bidding_strategy_target_roas_cpc_bid_floor_micros	INTEGER
bidding_strategy_target_spend_target_spend_micros	INTEGER
bidding_strategy_target_cpa_cpc_bid_ceiling_micros	INTEGER
bidding_strategy_target_roas_cpc_bid_ceiling_micros	INTEGER
bidding_strategy_target_spend_cpc_bid_ceiling_micros	INTEGER
bidding_strategy_maximize_conversion_value_target_roas	FLOAT
bidding_strategy_maximize_conversions_target_cpa_micros	INTEGER
bidding_strategy_maximize_conversions_cpc_bid_floor_micros	INTEGER
bidding_strategy_maximize_conversions_cpc_bid_ceiling_micros	INTEGER
bidding_strategy_maximize_conversion_value_cpc_bid_floor_micros	INTEGER
bidding_strategy_target_impression_share_cpc_bid_ceiling_micros	INTEGER
bidding_strategy_maximize_conversion_value_cpc_bid_ceiling_micros	INTEGER
bidding_strategy_target_impression_share_location_fraction_micros	INTEGER

campaign_budget

Field name	Type
campaign_id	INTEGER
customer_id	INTEGER
metrics_ctr	FLOAT
segments_date	DATE
metrics_clicks	INTEGER
campaign_budget_id	INTEGER
metrics_average_cpc	FLOAT
metrics_average_cpe	FLOAT
metrics_average_cpm	FLOAT
metrics_average_cpv	FLOAT
metrics_conversions	FLOAT
metrics_cost_micros	INTEGER
metrics_engagements	INTEGER
metrics_impressions	INTEGER
metrics_video_views	INTEGER
campaign_budget_name	STRING
campaign_budget_type	STRING
metrics_average_cost	FLOAT
metrics_interactions	INTEGER
campaign_budget_period	STRING
campaign_budget_status	STRING
metrics_all_conversions	FLOAT
metrics_engagement_rate	FLOAT
metrics_video_view_rate	FLOAT
metrics_interaction_rate	FLOAT
metrics_conversions_value	FLOAT
metrics_cost_per_conversion	FLOAT
metrics_value_per_conversion	FLOAT
campaign_budget_amount_micros	INTEGER
campaign_budget_resource_name	STRING
metrics_all_conversions_value	FLOAT
campaign_budget_delivery_method	STRING
campaign_budget_reference_count	INTEGER
metrics_interaction_event_types	STRING
metrics_cost_per_all_conversions	FLOAT
metrics_cross_device_conversions	FLOAT
metrics_view_through_conversions	INTEGER
campaign_budget_explicitly_shared	BOOLEAN
metrics_value_per_all_conversions	FLOAT
campaign_budget_total_amount_micros	INTEGER
campaign_budget_has_recommended_budget	BOOLEAN
metrics_conversions_from_interactions_rate	FLOAT
campaign_budget_aligned_bidding_strategy_id	INTEGER
metrics_all_conversions_from_interactions_rate	FLOAT
campaign_budget_recommended_budget_amount_micros	INTEGER
segments_budget_campaign_association_status_status	STRING
segments_budget_campaign_association_status_campaign	STRING
campaign_budget_recommended_budget_estimated_change_weekly_views	INTEGER
campaign_budget_recommended_budget_estimated_change_weekly_clicks	INTEGER
campaign_budget_recommended_budget_estimated_change_weekly_cost_micros	INTEGER
campaign_budget_recommended_budget_estimated_change_weekly_interactions	INTEGER

campaigns

Field name	Type
campaign_id	INTEGER
metrics_ctr	FLOAT
campaign_name	STRING
segments_date	DATE
segments_hour	INTEGER
metrics_clicks	INTEGER
campaign_labels	STRING
campaign_status	STRING
campaign_end_date	STRING
campaign_manual_cpm	STRING
campaign_manual_cpv	STRING
campaign_start_date	STRING
metrics_average_cpc	FLOAT
metrics_average_cpm	FLOAT
metrics_conversions	FLOAT
metrics_cost_micros	INTEGER
metrics_impressions	INTEGER
metrics_video_views	INTEGER
metrics_average_cost	FLOAT
metrics_interactions	INTEGER
campaign_payment_mode	STRING
campaign_base_campaign	STRING
campaign_resource_name	STRING
campaign_frequency_caps	STRING
campaign_serving_status	STRING
metrics_active_view_cpm	FLOAT
metrics_active_view_ctr	FLOAT
campaign_campaign_budget	STRING
campaign_experiment_type	STRING
segments_ad_network_type	STRING
campaign_bidding_strategy	STRING
campaign_final_url_suffix	STRING
metrics_conversions_value	FLOAT
campaign_optimization_score	FLOAT
metrics_cost_per_conversion	FLOAT
metrics_value_per_conversion	FLOAT
campaign_budget_amount_micros	INTEGER
campaign_bidding_strategy_type	STRING
campaign_tracking_url_template	STRING
campaign_url_custom_parameters	STRING
metrics_active_view_impressions	INTEGER
metrics_active_view_viewability	FLOAT
metrics_interaction_event_types	STRING
campaign_target_roas_target_roas	FLOAT
metrics_video_quartile_p100_rate	FLOAT
campaign_advertising_channel_type	STRING
metrics_active_view_measurability	FLOAT
campaign_accessible_bidding_strategy	STRING
campaign_app_campaign_setting_app_id	STRING
campaign_advertising_channel_sub_type	STRING
campaign_shopping_setting_merchant_id	INTEGER
campaign_target_cpa_target_cpa_micros	INTEGER
campaign_hotel_setting_hotel_center_id	INTEGER
campaign_shopping_setting_enable_local	BOOLEAN
campaign_tracking_setting_tracking_url	STRING
campaign_ad_serving_optimization_status	STRING
campaign_app_campaign_setting_app_store	STRING
campaign_video_brand_safety_suitability	STRING
campaign_manual_cpc_enhanced_cpc_enabled	BOOLEAN
campaign_target_cpa_cpc_bid_floor_micros	INTEGER
campaign_dynamic_search_ads_setting_feeds	STRING
campaign_percent_cpc_enhanced_cpc_enabled	BOOLEAN
campaign_real_time_bidding_setting_opt_in	BOOLEAN
campaign_target_impression_share_location	STRING
campaign_target_roas_cpc_bid_floor_micros	INTEGER
campaign_target_spend_target_spend_micros	INTEGER
campaign_vanity_pharma_vanity_pharma_text	STRING
campaign_commission_commission_rate_micros	INTEGER
campaign_excluded_parent_asset_field_types	STRING
campaign_target_cpa_cpc_bid_ceiling_micros	INTEGER
metrics_active_view_measurable_cost_micros	INTEGER
metrics_active_view_measurable_impressions	INTEGER
campaign_percent_cpc_cpc_bid_ceiling_micros	INTEGER
campaign_shopping_setting_campaign_priority	INTEGER
campaign_target_roas_cpc_bid_ceiling_micros	INTEGER
campaign_target_spend_cpc_bid_ceiling_micros	INTEGER
campaign_maximize_conversion_value_target_roas	FLOAT
campaign_network_settings_target_google_search	BOOLEAN
campaign_targeting_setting_target_restrictions	STRING
campaign_dynamic_search_ads_setting_domain_name	STRING
campaign_maximize_conversions_target_cpa_micros	INTEGER
campaign_network_settings_target_search_network	BOOLEAN
campaign_network_settings_target_content_network	BOOLEAN
campaign_dynamic_search_ads_setting_language_code	STRING
campaign_selective_optimization_conversion_actions	STRING
campaign_target_cpm_target_frequency_goal_time_unit	STRING
campaign_local_campaign_setting_location_source_type	STRING
campaign_vanity_pharma_vanity_pharma_display_url_mode	STRING
campaign_target_cpm_target_frequency_goal_target_count	INTEGER
campaign_network_settings_target_partner_search_network	BOOLEAN
campaign_target_impression_share_cpc_bid_ceiling_micros	INTEGER
campaign_app_campaign_setting_bidding_strategy_goal_type	STRING
campaign_geo_target_type_setting_negative_geo_target_type	STRING
campaign_geo_target_type_setting_positive_geo_target_type	STRING
campaign_target_impression_share_location_fraction_micros	INTEGER
campaign_dynamic_search_ads_setting_use_supplied_urls_only	BOOLEAN
campaign_optimization_goal_setting_optimization_goal_types	STRING

click_view

Field name	Type
ad_group_id	INTEGER
campaign_id	INTEGER
customer_id	INTEGER
ad_group_name	STRING
campaign_name	STRING
segments_date	DATE
click_view_gclid	STRING
click_view_keyword	STRING
click_view_ad_group_ad	STRING
segments_ad_network_type	STRING
click_view_keyword_info_text	STRING
click_view_keyword_info_match_type	STRING
campaign_network_settings_target_google_search	BOOLEAN
campaign_network_settings_target_search_network	BOOLEAN
campaign_network_settings_target_content_network	BOOLEAN
campaign_network_settings_target_partner_search_network	BOOLEAN

display_keyword_performance_report

Field name	Type
ad_group_id	INTEGER
campaign_id	INTEGER
customer_id	INTEGER
metrics_ctr	FLOAT
ad_group_name	STRING
campaign_name	STRING
segments_date	DATE
segments_week	STRING
segments_year	INTEGER
metrics_clicks	INTEGER
segments_month	STRING
ad_group_status	STRING
campaign_status	STRING
segments_device	STRING
segments_quarter	STRING
customer_time_zone	STRING
metrics_average_cpc	FLOAT
metrics_average_cpe	FLOAT
metrics_average_cpm	FLOAT
metrics_average_cpv	FLOAT
metrics_conversions	FLOAT
metrics_cost_micros	INTEGER
metrics_engagements	INTEGER
metrics_gmail_saves	INTEGER
metrics_impressions	INTEGER
metrics_video_views	INTEGER
metrics_average_cost	FLOAT
metrics_interactions	INTEGER
segments_day_of_week	STRING
ad_group_base_ad_group	STRING
campaign_base_campaign	STRING
customer_currency_code	STRING
metrics_gmail_forwards	INTEGER
metrics_active_view_cpm	FLOAT
metrics_active_view_ctr	FLOAT
metrics_all_conversions	FLOAT
metrics_engagement_rate	FLOAT
metrics_video_view_rate	FLOAT
metrics_interaction_rate	FLOAT
segments_ad_network_type	STRING
ad_group_criterion_status	STRING
campaign_bidding_strategy	STRING
customer_descriptive_name	STRING
metrics_conversions_value	FLOAT
ad_group_criterion_negative	BOOLEAN
metrics_cost_per_conversion	FLOAT
metrics_value_per_conversion	FLOAT
ad_group_criterion_final_urls	STRING
metrics_all_conversions_value	FLOAT
campaign_bidding_strategy_type	STRING
metrics_gmail_secondary_clicks	INTEGER
ad_group_criterion_criterion_id	INTEGER
ad_group_criterion_keyword_text	STRING
metrics_active_view_impressions	INTEGER
metrics_active_view_viewability	FLOAT
metrics_interaction_event_types	STRING
metrics_video_quartile_p25_rate	FLOAT
metrics_video_quartile_p50_rate	FLOAT
metrics_video_quartile_p75_rate	FLOAT
metrics_cost_per_all_conversions	FLOAT
metrics_cross_device_conversions	FLOAT
metrics_video_quartile_p100_rate	FLOAT
metrics_view_through_conversions	INTEGER
metrics_active_view_measurability	FLOAT
metrics_value_per_all_conversions	FLOAT
ad_group_criterion_final_mobile_urls	STRING
ad_group_criterion_keyword_match_type	STRING
ad_group_criterion_tracking_url_template	STRING
ad_group_criterion_url_custom_parameters	STRING
metrics_active_view_measurable_cost_micros	INTEGER
metrics_active_view_measurable_impressions	INTEGER
metrics_conversions_from_interactions_rate	FLOAT
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_targeting_setting_target_restrictions	STRING
metrics_all_conversions_from_interactions_rate	FLOAT

display_topics_performance_report

Field name	Type
ad_group_id	INTEGER
campaign_id	INTEGER
customer_id	INTEGER
metrics_ctr	FLOAT
ad_group_name	STRING
campaign_name	STRING
segments_date	DATE
segments_week	STRING
segments_year	INTEGER
metrics_clicks	INTEGER
segments_month	STRING
ad_group_status	STRING
campaign_status	STRING
segments_device	STRING
segments_quarter	STRING
customer_time_zone	STRING
metrics_average_cpc	FLOAT
metrics_average_cpe	FLOAT
metrics_average_cpm	FLOAT
metrics_average_cpv	FLOAT
metrics_conversions	FLOAT
metrics_cost_micros	INTEGER
metrics_engagements	INTEGER
metrics_gmail_saves	INTEGER
metrics_impressions	INTEGER
metrics_video_views	INTEGER
metrics_average_cost	FLOAT
metrics_interactions	INTEGER
segments_day_of_week	STRING
ad_group_base_ad_group	STRING
campaign_base_campaign	STRING
customer_currency_code	STRING
metrics_gmail_forwards	INTEGER
metrics_active_view_cpm	FLOAT
metrics_active_view_ctr	FLOAT
metrics_all_conversions	FLOAT
metrics_engagement_rate	FLOAT
metrics_video_view_rate	FLOAT
metrics_interaction_rate	FLOAT
segments_ad_network_type	STRING
topic_view_resource_name	STRING
ad_group_criterion_status	STRING
campaign_bidding_strategy	STRING
customer_descriptive_name	STRING
metrics_conversions_value	FLOAT
ad_group_criterion_negative	BOOLEAN
metrics_cost_per_conversion	FLOAT
metrics_value_per_conversion	FLOAT
ad_group_criterion_final_urls	STRING
ad_group_criterion_topic_path	STRING
metrics_all_conversions_value	FLOAT
campaign_bidding_strategy_type	STRING
metrics_gmail_secondary_clicks	INTEGER
ad_group_criterion_bid_modifier	FLOAT
ad_group_criterion_criterion_id	INTEGER
metrics_active_view_impressions	INTEGER
metrics_active_view_viewability	FLOAT
metrics_interaction_event_types	STRING
metrics_video_quartile_p25_rate	FLOAT
metrics_video_quartile_p50_rate	FLOAT
metrics_video_quartile_p75_rate	FLOAT
metrics_cost_per_all_conversions	FLOAT
metrics_cross_device_conversions	FLOAT
metrics_video_quartile_p100_rate	FLOAT
metrics_view_through_conversions	INTEGER
metrics_active_view_measurability	FLOAT
metrics_value_per_all_conversions	FLOAT
ad_group_criterion_final_mobile_urls	STRING
ad_group_criterion_topic_topic_constant	STRING
ad_group_criterion_tracking_url_template	STRING
ad_group_criterion_url_custom_parameters	STRING
metrics_active_view_measurable_cost_micros	INTEGER
metrics_active_view_measurable_impressions	INTEGER
metrics_conversions_from_interactions_rate	FLOAT
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_targeting_setting_target_restrictions	STRING
metrics_all_conversions_from_interactions_rate	FLOAT

geographic_report

Field name	Type
ad_group_id	INTEGER
customer_id	INTEGER
segments_date	DATE
customer_descriptive_name	STRING
geographic_view_location_type	STRING
geographic_view_country_criterion_id	INTEGER

keyword_report

Field name	Type
ad_group_id	INTEGER
campaign_id	INTEGER
customer_id	INTEGER
metrics_ctr	FLOAT
segments_date	DATE
metrics_clicks	INTEGER
metrics_conversions	FLOAT
metrics_cost_micros	INTEGER
metrics_impressions	INTEGER
metrics_interactions	INTEGER
ad_group_criterion_type	STRING
customer_descriptive_name	STRING
metrics_conversions_value	FLOAT
ad_group_criterion_negative	BOOLEAN
campaign_bidding_strategy_type	STRING
ad_group_criterion_criterion_id	INTEGER
ad_group_criterion_keyword_text	STRING
metrics_active_view_impressions	INTEGER
metrics_active_view_viewability	FLOAT
metrics_interaction_event_types	STRING
metrics_historical_quality_score	INTEGER
metrics_view_through_conversions	INTEGER
metrics_active_view_measurability	FLOAT
ad_group_criterion_keyword_match_type	STRING
metrics_active_view_measurable_cost_micros	INTEGER
metrics_active_view_measurable_impressions	INTEGER
ad_group_criterion_position_estimates_first_page_cpc_micros	INTEGER
ad_group_criterion_position_estimates_first_position_cpc_micros	INTEGER

shopping_performance_report

Field name	Type
ad_group_id	INTEGER
campaign_id	INTEGER
customer_id	INTEGER
metrics_ctr	FLOAT
ad_group_name	STRING
campaign_name	STRING
segments_date	DATE
segments_week	STRING
segments_year	INTEGER
metrics_clicks	INTEGER
segments_month	STRING
ad_group_status	STRING
campaign_status	STRING
segments_device	STRING
segments_quarter	STRING
metrics_average_cpc	FLOAT
metrics_conversions	FLOAT
metrics_cost_micros	INTEGER
metrics_impressions	INTEGER
segments_click_type	STRING
segments_day_of_week	STRING
segments_product_brand	STRING
segments_product_title	STRING
metrics_all_conversions	FLOAT
segments_ad_network_type	STRING
segments_product_channel	STRING
segments_product_country	STRING
segments_product_item_id	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
customer_descriptive_name	STRING
metrics_conversions_value	FLOAT
segments_product_language	STRING
segments_product_store_id	STRING
segments_product_condition	STRING
metrics_cost_per_conversion	FLOAT
metrics_value_per_conversion	FLOAT
segments_product_merchant_id	INTEGER
metrics_all_conversions_value	FLOAT
segments_product_aggregator_id	INTEGER
metrics_cost_per_all_conversions	FLOAT
metrics_cross_device_conversions	FLOAT
segments_product_category_level1	STRING
segments_product_category_level2	STRING
segments_product_category_level3	STRING
segments_product_category_level4	STRING
segments_product_category_level5	STRING
metrics_value_per_all_conversions	FLOAT
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_channel_exclusivity	STRING
metrics_conversions_from_interactions_rate	FLOAT
metrics_all_conversions_from_interactions_rate	FLOAT

user_location_report

Field name	Type
campaign_id	INTEGER
customer_id	INTEGER
metrics_ctr	FLOAT
ad_group_name	STRING
campaign_name	STRING
segments_date	DATE
segments_week	STRING
segments_year	INTEGER
metrics_clicks	INTEGER
segments_month	STRING
ad_group_status	STRING
campaign_status	STRING
segments_quarter	STRING
customer_time_zone	STRING
metrics_average_cpc	FLOAT
metrics_average_cpm	FLOAT
metrics_average_cpv	FLOAT
metrics_conversions	FLOAT
metrics_cost_micros	INTEGER
metrics_impressions	INTEGER
metrics_video_views	INTEGER
metrics_average_cost	FLOAT
metrics_interactions	INTEGER
segments_day_of_week	STRING
ad_group_base_ad_group	STRING
campaign_base_campaign	STRING
customer_currency_code	STRING
metrics_all_conversions	FLOAT
metrics_video_view_rate	FLOAT
metrics_interaction_rate	FLOAT
segments_ad_network_type	STRING
customer_descriptive_name	STRING
metrics_conversions_value	FLOAT
metrics_cost_per_conversion	FLOAT
metrics_value_per_conversion	FLOAT
metrics_all_conversions_value	FLOAT
metrics_interaction_event_types	STRING
metrics_cost_per_all_conversions	FLOAT
metrics_cross_device_conversions	FLOAT
metrics_view_through_conversions	INTEGER
user_location_view_resource_name	STRING
metrics_value_per_all_conversions	FLOAT
user_location_view_targeting_location	BOOLEAN
user_location_view_country_criterion_id	INTEGER
metrics_conversions_from_interactions_rate	FLOAT
metrics_all_conversions_from_interactions_rate	FLOAT

search_term_report

Field name	Type
segments_date	DATE
metrics_clicks	INTEGER
segments_device	STRING
ad_group_ad_ad_id	INTEGER
metrics_conversions	FLOAT
metrics_cost_micros	INTEGER
metrics_impressions	INTEGER
metrics_interactions	INTEGER
search_term_view_status	STRING
segments_ad_network_type	STRING
search_term_view_ad_group	STRING
search_term_view_search_term	STRING
search_term_view_resource_name	STRING
segments_search_term_match_type	STRING

bidding_strategy

Field name	Type
customer_id	INTEGER
metrics_ctr	FLOAT
segments_date	DATE
metrics_clicks	INTEGER
bidding_strategy_id	INTEGER
metrics_average_cpc	FLOAT
metrics_average_cpm	FLOAT
metrics_conversions	FLOAT
metrics_cost_micros	INTEGER
metrics_impressions	INTEGER
bidding_strategy_name	STRING
bidding_strategy_type	STRING
bidding_strategy_status	STRING
metrics_cost_per_conversion	FLOAT
bidding_strategy_currency_code	STRING
bidding_strategy_resource_name	STRING