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' 

Tag:google-ads-api, google-ads-script

3 comments.

  1. Дмитро Булах

    WHERE clause may only contain AND conditions https://developers.google.com/google-ads/api/docs/query/grammar

  2. user23470737

    OR for string fields can be simulated with REGEXP_MATCH. But in very this case using AND within 2-3 queries is the only way. GAQL is very flat QL.

    1. Community

      Your answer could be improved with additional supporting information. Please edit to add further details, such as citations or documentation, so that others can confirm that your answer is correct. You can find more information on how to write good answers in the help center.

Add a new comment.