Groups
Groups
Sign in
Groups
Groups
(Deprecated) Google Ads API and AdWords API Forum
Conversations
Labels
About
Send feedback
Help
A compound WHERE clause in GAQL?
14 views
Skip to first unread message
EladB
unread,
Feb 10, 2022, 8:51:36 AM
2/10/22
Reply to author
Sign in to reply to author
Forward
Sign in to forward
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
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 PM
2/10/22
Reply to author
Sign in to reply to author
Forward
Sign in to forward
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to adwor...@googlegroups.com
Hi Elad,
Google Ads Query Language Grammar
shows it only supports 'and' in the 'where' clause.
Regards,
Aryeh
Google Ads API Team
ref:_00D1U1174p._5004Q2W63WD:ref
Reply all
Reply to author
Forward
0 new messages