Google Ads → Google BigQuery: схема данных

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



Была ли эта статья полезной?
Пользователи, считающие этот материал полезным: 0 из 0
Еще есть вопросы? Отправить запрос

0 Комментарии

Войдите в службу, чтобы оставить комментарий.