A compound WHERE clause in GAQL?

14 views
Skip to first unread message

EladB

unread,
Feb 10, 2022, 8:51:36 AM2/10/22
to Google Ads API and AdWords API Forum
Hi

Could you please confirm GQAL doesn't support `compound WHERE clause`?


```
 FROM group_placement_view\
 WHERE\
    metrics.impressions >= 10000 \
    AND (metrics.video_view_rate < 10' OR metrics.average_cpm > 10000 )
```

and not event `OR` as non-compound clause?

```
    metrics.average_cpm\
 FROM group_placement_view\
 WHERE\
    metrics.impressions >= 10000 \
    OR metrics.video_view_rate < 10'
```
Thanks!

Google Ads API Forum Advisor

unread,
Feb 10, 2022, 4:29:25 PM2/10/22
to adwor...@googlegroups.com
Hi Elad,

Google Ads Query Language Grammar  shows it only supports 'and' in the 'where' clause.

Regards,

Google Logo
Aryeh
Google Ads API Team
 


ref:_00D1U1174p._5004Q2W63WD:ref
Reply all
Reply to author
Forward
0 new messages