Can not output "search_budget_lost_impression_share"?

[m...@flat-inc.jp]

When I try to extract "metrics.search_budget_lost_impression_share" by specifying keyword_view in the FROM clause in the report output of Google Ads API, the following error appears.

----

message: "Cannot select or filter on the following metrics: \ 'search_budget_lost_impression_share \' (could not support requested resources: \ 'KEYWORD_VIEW \'), since metric is incompatible with the resource in the FROM clause or selected segmenting resources."

----

However, if you check the specifications on the following page, you will find that it can be specified.

Which is the correct behavior?

By the way, similar items "metrics.search_budget_lost_top_impression_share" "metrics.search_budget_lost_absolute_top_impression_share"

Can be output.

[Google Ads API Forum Advisor Prod]

Hi,

Thank you for reaching out. So I can better look into the issue, could you provide to me the complete GAQL query you used when you tried to generate the report?

Best regards,
Peter
Google Ads API Team

ref:_00D1U1174p._5001UBl7tP:ref

[m...@flat-inc.jp]

Thank you for your reply.

Here is the query statement:

SELECT customer.descriptive_name, segments.ad_network_type, segments.date, segments.device, campaign.id, ad_group.id, ad_group_criterion.criterion_id, campaign.name, campaign.status, ad_group.name, ad_group.status, ad_group_status. , ad_group_criterion.keyword.match_type, ad_group_criterion.status, ad_group_criterion.cpc_bid_micros, ad_group_criterion.quality_info.quality_score, ad_group_criterion.position_estimates.first_page_cpc_micros, ad_group_criterion.position_estimates.top_of_page_cpc_micros, ad_group_criterion.cpm_bid_micros, ad_group_criterion.final_urls, ad_group_criterion.final_mobile_urls, ad_group_criterion.tracking_url_template, metrics .search_impression_share, metrics.search_rank_lost_impression_share, metrics.search_budget_lost_impression_share, metrics.search_top_impression_share, metrics.search_rank_lost_top_impression_share, metrics.search_search_budget_lost_top_impressivity_i s.search_rank_lost_absolute_top_impression_share, metrics.search_budget_lost_absolute_top_impression_share, metrics.impressions, metrics.clicks, metrics.cost_micros, metrics. segments.ad_network_type IN (SEARCH, SEARCH_PARTNERS) AND segments.date DURING LAST_30_DAYS

Thank you.

2019年6月3日月曜日 17時45分45秒 UTC+9 adsapiforumadvisor:

[Google Ads API Forum Advisor Prod]

Hi,

The metrics.search_budget_lost_impression_share field can only be selected along with the fields listed in the Selectable With dropdown in the field's documentation. That said, other resources, metrics, and segments not included in the list cannot be included in the same SELECT query as this field. I hope this helps.

Thanks and regards,

[m...@flat-inc.jp]

Thank you for your reply.

The sentence I sent earlier was partially missing. I'm sorry.

SELECT customer.descriptive_name , segments.ad_network_type , segments.date , segments.device , campaign.id , ad_group.id , ad_group_criterion.criterion_id , campaign.name , campaign.status , ad_group.name , ad_group.status , ad_group_criterion.keyword.text , ad_group_criterion.keyword.match_type , ad_group_criterion.status , ad_group_criterion.cpc_bid_micros , ad_group_criterion.quality_info.quality_score , ad_group_criterion.position_estimates.first_page_cpc_micros , ad_group_criterion.position_estimates.top_of_page_cpc_micros , ad_group_criterion.cpm_bid_micros , ad_group_criterion.final_urls , ad_group_criterion.final_mobile_urls , ad_group_criterion.tracking_url_template , metrics.search_impression_share , metrics.search_rank_lost_impression_share , metrics.search_budget_lost_impression_share , metrics.search_top_impression_share , metrics.search_rank_lost_top_impression_share , metrics.search_budget_lost_top_impression_share , metrics.search_absolute_top_impression_share , metrics.search_rank_lost_absolute_top_impression_share , metrics.search_budget_lost_absolute_top_impression_share , metrics.impressions , metrics.clicks , metrics.cost_micros , metrics.average_position , metrics.conversions , metrics.conversions_value , metrics.all_conversions , metrics.all_conversions_value , metrics.view_through_conversions , metrics.cross_device_conversions 

FROM keyword_view 

WHERE segments.ad_network_type IN (SEARCH,SEARCH_PARTNERS)   

 AND  segments.date DURING LAST_30_DAYS

Is a complete query statement.

As specified, the resource "keyword_view" is specified but can not be output.

Since almost the same specification "search_budget_lost_top_impression_share" can be output using the above statement, I want it to be possible to output "search_budget_lost_impression_share" as well.

2019年6月3日月曜日 19時28分18秒 UTC+9 adsapiforumadvisor:

[Google Ads API Forum Advisor Prod]

Hi,

My apologies for the confusion. After discussing with the team, it seems that the metrics.search_budget_lost_impression_share field is indeed not supported to be included in the SELECT query for the Keyword View. You may check out the Metrics dropdown instead to see the list of metrics fields that can be retrieved for the said view.

The "Selectable With" dropdown does not really mean that all the metrics/segment fields is selectable with the *view for every FROM resource. Instead, it indicates that there exists at least one FROM resource where you can select those fields along with the other *view fields.