Re: Nested where clause and OR clauses

2022-07-12 Thread don....@gmail.com
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 =

Re: Nested where clause and OR clauses

2022-05-11 Thread Kristijan Novaković
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 cus

RE: Nested where clause and OR clauses

2022-05-11 Thread 'Google Ads API Forum Advisor' via Google Ads API and AdWords API Forum
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 tool for the query v