Hi Bharani, would you mind doublechecking both of your answers in this post?
1. The op asked about the metric "conversions". Since "conversions" is of type "double", the only supported operators are > and <: https://developers.google.com/adwords/api/docs/appendix/reports/keywords-performance-report#conversions 2. If you combine two expressions in a WHERE clause with "AND", *both* of them have to be true to yield a result. So your suggested code "*WHERE metrics.conversions > 0 AND metrics.conversions = 0*" is double wrong: "= 0" is not supported with "conversions" and even if it were, the code would always return zero elements. Regards Mat Am Freitag, 13. September 2019 16:47:17 UTC+2 schrieb adsapiforumadvisor: > > Hello Chirag, > > You will be able to achieve this by combining the conditions using AND. > Sample report query is below: > > query: "SELECT ad_group_ad_asset_view.performance_label, asset.id, > campaign.advertising_channel_sub_type FROM ad_group_ad_asset_view WHERE > metrics.conversions > 0 AND metrics.conversions = 0" > Hope this helps! > > Thanks, > Bharani, Google Ads API Team > > ref:_00D1U1174p._5001UHGOI3: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/6d096cdc-6e25-4307-ac42-0f9ce8cebfbe%40googlegroups.com.
