Gathering location related metrics in Keyword view

[Ahamed Arshad]

Hi there,

below is the query I am placing to gather insights from keyword view, my requirement is to gather country-specific details also get appended to keyword view to ease my extraction needs, but when I request "ad_group_criterion.listing_group.case_value.product_bidding_category.country_code" metrics from keyword-view, I can't able to see any values as output even  the attribute header is invisible, can you please guide me regarding this, for the rest of the attributes I can able to get the required data 

query_keyword="""

    SELECT

    customer.id,

    ad_group_criterion.status,

    ad_group_criterion.keyword.text,

    campaign.advertising_channel_type,

    ad_group_criterion.status, 

 ad_group_criterion.listing_group.case_value.hotel_country_region.country_region_criterion,

    ad_group_criterion.listing_group.case_value.product_bidding_category.country_code,

    ad_group.status,

    ad_group_criterion.keyword.match_type,

    customer.descriptive_name,

    customer.time_zone,

    customer.currency_code,

    ad_group_criterion.quality_info.creative_quality_score, 

    ad_group_criterion.quality_info.quality_score,

    ad_group.id,

    ad_group.name,

    segments.date,

    segments.ad_network_type,

    campaign.id, 

    campaign.labels, 

    campaign.name,

    campaign.status,

    campaign.network_settings.target_content_network, 

    campaign.network_settings.target_search_network,

    metrics.absolute_top_impression_percentage, 

    metrics.active_view_cpm, 

    metrics.active_view_ctr, 

    metrics.active_view_impressions,

    metrics.active_view_measurability, 

    metrics.active_view_measurable_cost_micros, 

    metrics.active_view_measurable_impressions, 

    metrics.active_view_viewability, 

    metrics.all_conversions,

    metrics.all_conversions_by_conversion_date, 

    metrics.all_conversions_from_interactions_rate, 

    metrics.all_conversions_from_interactions_value_per_interaction, 

    metrics.all_conversions_value,

    metrics.all_conversions_value_by_conversion_date, 

    metrics.all_conversions_value_per_cost, 

    metrics.average_cost, 

    metrics.average_cpc, 

    metrics.average_cpe,

    metrics.average_cpm,

    metrics.average_cpv,

    metrics.average_page_views,

    metrics.average_time_on_site, 

    metrics.bounce_rate, 

    metrics.clicks, 

    metrics.conversions, 

    metrics.conversions_by_conversion_date,

    metrics.conversions_from_interactions_rate,

    metrics.conversions_value, 

    metrics.conversions_value_by_conversion_date, 

    metrics.conversions_value_per_cost, 

    metrics.cost_micros, 

    metrics.cost_per_all_conversions,

    metrics.cost_per_conversion,

    metrics.cost_per_current_model_attributed_conversion, 

    metrics.cross_device_conversions, 

    metrics.ctr,

    metrics.current_model_attributed_conversions,

    metrics.current_model_attributed_conversions_value,

    metrics.engagement_rate,

    metrics.engagements,

    metrics.gmail_forwards, 

    metrics.gmail_saves, 

    metrics.gmail_secondary_clicks,  

    metrics.impressions, 

    metrics.interaction_event_types, 

    metrics.interaction_rate,

    metrics.interactions, metrics.percent_new_visitors,

    metrics.search_absolute_top_impression_share,

    metrics.search_budget_lost_absolute_top_impression_share, 

    metrics.search_budget_lost_top_impression_share,

    metrics.search_click_share, 

    metrics.search_exact_match_impression_share,

    metrics.search_impression_share,

    metrics.search_rank_lost_absolute_top_impression_share,

    metrics.search_rank_lost_impression_share, 

    metrics.search_rank_lost_top_impression_share,

    metrics.search_top_impression_share, 

    metrics.top_impression_percentage,

    metrics.value_per_all_conversions,

    metrics.value_per_all_conversions_by_conversion_date,

    metrics.value_per_conversion, 

    metrics.value_per_conversions_by_conversion_date,

    metrics.value_per_current_model_attributed_conversion, 

    metrics.video_quartile_p100_rate,

    metrics.video_quartile_p25_rate,

    metrics.video_quartile_p50_rate, 

    metrics.video_quartile_p75_rate, 

    metrics.video_view_rate, 

    metrics.video_views,

    metrics.view_through_conversions

    FROM keyword_view

    WHERE segments.date BETWEEN '2021-07-16' AND '2021-07-16'

[Google Ads API Forum Advisor]

Hi Ahamed,

Thank you for reaching out. 

Could you confirm if you have looked up the Keywords view of the Google Ads UI and checked whether the field in question indeed has values for the specific rows that were returned in the API?

In addition, could you provide the complete request and response logs, with the request-id? If you haven't yet, logging can be enabled by navigating to the Client libraries > Your client library (ex. Java) > Logging documentation, which you can access from this link. You may then retry your request to generate the logs.

You may then send the requested information via the Reply privately to author option. If this option is not available, you may send the details directly to our googleadsa...@google.com alias instead.

Best regards,

Peter Laurence Napa Oliquino Google Ads API Team

ref:_00D1U1174p._5004Q2MhvPh:ref