I second this request we would like to do query like SELECT ad_group_ad.ad.name, ad_group_ad.ad.call_ad.headline1, ad_group_ad.ad.expanded_text_ad.headline_part1,
FROM ad_group_ad WHERE ad_group.status IN ('ACTIVE', 'PAUSED') AND (metrics.cost_micros > 0 OR metrics.clicks > 0) AND segments.date = '2022-07-01' but can't do this.. On Wednesday, May 11, 2022 at 6:52:06 PM UTC+3 elda...@gmail.com wrote: > Here is an example where OR could be useful: > SELECT customer.id, metrics.impressions, metrics.all_conversions FROM > customer where metrics.impressions != 0 or metrics.all_conversions != 0 > (using *and *in stead of *or *is valid) > > That same query is where nesting is required, for example: > SELECT customer.id, metrics.impressions, metrics.all_conversions FROM > customer where segments.date >= '2022-04-01' and segments.date <= > '2022-04-30' and (metrics.impressions != 0 or metrics.all_conversions != 0) > > On Wednesday, May 11, 2022 at 4:56:53 PM UTC+2 adsapi wrote: > >> Hello Kristijan, >> >> Thanks for reaching out to the Google Ads API support. I am afraid if it >> is allow to do that because all reports GAQL queries are predefined and has >> to be selectable. In case if you want to check on your end then please >> refer to the Google Ads Query Builder >> <https://developers.google.com/google-ads/api/fields/v10/query_validator?hl=en> >> >> tool for the query validation on Google Ads API. Please share your GAQL >> query with us so we can also validate for you. Let me know if you have any >> questions on this. >> >> Please send the requested details via the Reply privately to the author >> option. If this option is not available, you may send the details directly >> to our <https://groups.google.com/>googleadsa...@google.com alias by >> referring to this thread. >> >> Best regards, >> > [image: Google Logo] >> Jakeia Sabrina >> Google Ads API Team >> >> ref:_00D1U1174p._5004Q2arRmI: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 "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/1b45493a-cdbf-4d4c-b12a-c9de5998332an%40googlegroups.com.