Budget Lost Impression Share not working from ad_group

95 views
Skip to first unread message

Melker Holmgren

unread,
Jul 14, 2022, 4:19:10 AM7/14/22
to Google Ads API and AdWords API Forum
Hello,

We are trying to query metrics.search_rank_lost_impression_share and metrics.search_budget_lost_impression_share from ad_group. 
Rank seems to work but budget gives us this error: 

{'errors': [{'errorCode': {'queryError': 'PROHIBITED_METRIC_IN_SELECT_OR_WHERE_CLAUSE'}, 'message': "Cannot select or filter on the following metrics: 'search_budget_lost_impression_share'(could not support requested resources: 'AD_GROUP'), since metric is incompatible with the resource in the FROM clause or other selected segmenting resources."}], 'requestId': 'Pu2agghT15VMXn3Hanro7A'}

When we are using the Google Ads query builder, we get this message:

'metrics.search_budget_lost_impression_share' is not a valid field in the SELECT clause when 'ad_group' is the resource in the FROM clause. Fields in the SELECT must be 'Selectable'.

In the documentation it says that it is selectable. Below you can see our query:

SELECT customer.descriptive_name, customer.time_zone, campaign.advertising_channel_type, campaign.advertising_channel_sub_type, campaign.id, campaign.name, campaign.tracking_url_template, campaign.url_custom_parameters, campaign.final_url_suffix, ad_group.name, ad_group.id, ad_group.type, ad_group.tracking_url_template, ad_group.final_url_suffix, segments.date, metrics.active_view_impressions, metrics.active_view_measurable_cost_micros, metrics.active_view_measurable_impressions, metrics.clicks, metrics.cost_micros, metrics.engagements, metrics.gmail_forwards, metrics.gmail_saves, metrics.gmail_secondary_clicks, metrics.impressions, metrics.impressions, metrics.interactions, metrics.phone_calls, metrics.phone_impressions, metrics.video_views, metrics.top_impression_percentage, metrics.absolute_top_impression_percentage, metrics.search_impression_share, metrics.search_rank_lost_impression_share, metrics.search_budget_lost_impression_share, customer.currency_code FROM ad_group WHERE segments.date BETWEEN '2022-07-13' AND '2022-07-13'

What is the expected behaviour?

Best regards
Melker Holmgren
Developer @ Funnel 


Google Ads API Forum Advisor

unread,
Jul 14, 2022, 9:52:20 AM7/14/22
to mel...@funnel.io, adwor...@googlegroups.com
Hi Melker,

Thank you for reaching out to us.

You may note that to see the metrics and segments that can be put in the same SELECT clause as the fields of ad_group , you can refer to this documentation by clicking “Yes, it is” in the dropdown box.

- The dropdown box specifies in what part of the query you use the resource (ad_group ). For example, you want to get the selectable fields in the ad_group, so you will click "Yes, it is" and the compatible fields will be displayed.

I would also recommend to still use the Google Ads Query Builder and Query Validator tools for constructing queries.

Best regards,
Google Logo
Heidi
Google Ads API Team
 


ref:_00D1U1174p._5004Q2cVz0M:ref
Reply all
Reply to author
Forward
0 new messages