Hello, We are trying to fetch Campaign, Adgroup, SearchKeyword wise data and able to get the same in UI but unable to do the same in API. Attached the screenshot for the query we built in the UI. In the API, we tried multiple queries :
- SELECT customer.id, customer.currency_code, ad_group.id, ad_group.name, campaign.id, campaign.name, segments.keyword.info.text, metrics.clicks, metrics.cost_micros, metrics.conversions, metrics.engagements, metrics.impressions, metrics.view_through_conversions, metrics.search_impression_share, metrics.top_impression_percentage, metrics.absolute_top_impression_percentage FROM ad_group_ad got below error : - 'metrics.search_impression_share' is not a valid field in the SELECT clause when 'ad_group_ad' is the resource in the FROM clause. Fields in the SELECT must be 'Selectable'. With this : - SELECT customer.id, customer.currency_code, ad_group.id, ad_group.name, campaign.id, campaign.name, segments.keyword.info.text, metrics.clicks, metrics.cost_micros, metrics.conversions, metrics.engagements, metrics.impressions, metrics.view_through_conversions, metrics.search_impression_share, metrics.top_impression_percentage, metrics.absolute_top_impression_percentage FROM ad_group Error : - 'segments.keyword.info.text' 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'. Query : - SELECT customer.id, customer.currency_code, ad_group.id, ad_group.name, campaign.id, campaign.name, segments.keyword.info.text, metrics.clicks, metrics.cost_micros, metrics.conversions, metrics.engagements, metrics.impressions, metrics.view_through_conversions, metrics.search_impression_share, metrics.top_impression_percentage, metrics.absolute_top_impression_percentage FROM search_term_view Error : - 'metrics.search_impression_share' is not a valid field in the SELECT clause when 'search_term_view' is the resource in the FROM clause. Fields in the SELECT must be 'Selectable'. So basically we've tried out multiple scenarios and multiple resources yet unable to get the exact data that I got from the API [As in Screenshot]. Can someone please help. -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog: https://googleadsdeveloper.blogspot.com/ =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ You received this message because you are subscribed to the Google Groups "AdWords API and Google Ads API Forum" group. To post to this group, send email to adwords-api@googlegroups.com To unsubscribe from this group, send email to adwords-api+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/adwords-api?hl=en --- You received this message because you are subscribed to the Google Groups "Google Ads API and AdWords API Forum" group. To unsubscribe from this group and stop receiving emails from it, send an email to adwords-api+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/f5dcc850-1329-4143-bbc0-ac988107b396n%40googlegroups.com.