Hi, Thanks for the help. I tried the query but got the error like below.
error_code { query_error: PROHIBITED_SEGMENT_IN_SELECT_OR_WHERE_CLAUSE } message: "Cannot select or filter on the following segments: \'segments.conversion_action\'(could not support requested resources: \'AD_GROUP_AD_ASSET_VIEW\', \'AD_GROUP_AD_ASSET_VIEW\'), since segment is incompatible with the resource in the FROM clause or other selected segmenting resources." Looks like 'conversion_action' is not a segmentable field according to the doc. Can you kindly help check again? On Saturday, May 30, 2020 at 3:20:29 AM UTC+8, adsapiforumadvisor wrote: > > Hi, > > Thanks for reaching out. With regards to your concern, you can query all > of that info from the ad_group_ad_asset_view > <https://developers.google.com/google-ads/api/fields/v2/ad_group_ad_asset_view> > > report and you can pull fields from the reports in the "attributed > resources”, Please see the below query to get the data what you are > looking for. > > Query: > SELECT Ad_group_ad_asset_view.ad_group_ad,asset.id,campaign.name, > asset.type,Ad_group_ad_asset_view.asset, > ad_group_ad_asset_view.performance_label,metrics.impressions,metrics.clicks,segments.conversion_action > FROM ad_group_ad_asset_view > WHERE segments.date DURING LAST_MONTH > > Let me know if you have any questions. > > Thanks, > Nirmita Patel Google Ads Team > > > > > > ref:_00D1U1174p._5004Q1zsmKa:ref > -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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 "AdWords API and Google Ads 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/29429e17-c7f3-42b3-9571-4c53ae892029%40googlegroups.com.