Query grammar reference

    • This document provides a comprehensive grammar reference for the Search Ads 360 Query Language.

    • The language allows users to query data using a structured syntax including clauses like SELECT , FROM , WHERE , ORDER BY , LIMIT , and PARAMETERS .

    • Various data types like numbers, strings, and lists are supported within the query structure for filtering and data retrieval.

    • Specific operators and functions enable detailed data manipulation, such as date ranges ( LAST_30_DAYS ) and pattern matching ( REGEXP_MATCH ).

    • The provided table details the syntax and components of the query language, along with explanations of special characters and usage examples.

    The table below contains a complete Search Ads 360 Query Language grammar reference.

    Grammar reference
    Query
    SELECT clause 
    SELECT FIELD_NAME 
(, FIELD_NAME 
)*
    FROM clause 
    FROM RESOURCE_NAME
    WHERE clause 
    WHERE CONDITION 
(AND CONDITION 
)*
    ORDER BY clause 
    ORDER BY ORDERING 
(, ORDERING 
)*
    LIMIT clause 
    LIMIT POSITIVE_INTEGER
    PARAMETERS clause 
    PARAMETERS LITERAL 
= VALUE 
(, LITERAL 
= VALUE 
)*
    Field name
    [a-z] ([a-zA-Z0-9._])*
    Resource name
    [a-z] ([a-zA-Z_])*
    Condition
    FIELD_NAME OPERATOR VALUE
    Ordering
     FIELD_NAME 
(ASC | DESC)?
    Operator
    = | != | > | >= | < | <= | IN | NOT IN | LIKE | NOT LIKE | CONTAINS ANY |
    CONTAINS ALL | CONTAINS NONE | IS NULL | IS NOT NULL | DURING | BETWEEN |
    REGEXP_MATCH | NOT REGEXP_MATCH
    Function
    LAST_14_DAYS | LAST_30_DAYS | LAST_7_DAYS | LAST_BUSINESS_WEEK | LAST_MONTH |
    LAST_WEEK_MON_SUN | LAST_WEEK_SUN_SAT | THIS_MONTH | THIS_WEEK_MON_TODAY |
    THIS_WEEK_SUN_TODAY | TODAY | YESTERDAY
    Value
     LITERAL 
| LITERAL_LIST 
| NUMBER 
| NUMBER_LIST 
| STRING 
| STRING_LIST 
| FUNCTION
    Positive integer
    [1-9] ([0-9])*
    Number
    -? [0-9]+ (. [0-9] [0-9]*)?
    String
    (' Char* ') | (" Char* ")
    Literal
    [a-zA-Z0-9_]*
    String list
    ( STRING 
(, STRING 
)* )
    Literal list
    ( LITERAL 
(, LITERAL 
)* )
    Number list
    ( NUMBER 
(, NUMBER 
)* )

    Key:

    • ? indicates an optional element.
    • * means zero or more
    • + means one or more.
    • (xxxxxx) indicates a grouping.
    • [a-z0-9] indicates a character range.
    • Char indicates any character.
    • | stands for "or".
    • The REGEXP_MATCH operator uses RE2 syntax .

    • To match a [ , ] , % , or _ literal using the LIKE operator, surround the character in square brackets. For example, the following condition matches all campaign.name values that start with [Earth_to_Mars] :

        WHERE 
  
 campaign 
 . 
 name 
  
 LIKE 
  
 '[[]Earth[_]to[_]Mars[]]%'
    Design a Mobile Site
    View Site in Mobile | Classic
    Share by: