AI-generated Key Takeaways
-
Google Ads Query Language queries consist of optional and required clauses such as SELECT, FROM, WHERE, ORDER BY, LIMIT, and PARAMETERS.
-
Various operators can be used in the WHERE clause for conditions, including comparison, containment, and pattern matching operators.
-
Field names, resource names, strings, numbers, and literals follow specific syntax rules defined by regular expressions.
-
Specific rules and limitations apply to the
REGEXP_MATCHandLIKEoperators.
Here is the Google Ads Query Language grammar reference (in regular expression notation):
Query -> SelectClause FromClause WhereClause ? OrderByClause ? LimitClause ? ParametersClause ? SelectClause -> SELECT FieldName (, FieldName ) * FromClause -> FROM ResourceName WhereClause -> WHERE Condition ( AND Condition ) * OrderByClause -> ORDER BY Ordering (, Ordering ) * LimitClause -> LIMIT PositiveInteger ParametersClause -> PARAMETERS Literal = Value (, Literal = Value ) * Condition -> FieldName Operator Value 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 Value -> Literal | LiteralList | Number | NumberList | String | StringList | Function Ordering -> FieldName ( ASC | DESC ) ? FieldName -> [ a - z ] ( [ a - zA - Z0 - 9. _ ] ) * ResourceName -> [ a - z ] ( [ a - zA - Z_ ] ) * StringList -> ( String (, String ) * ) LiteralList -> ( Literal (, Literal ) * ) NumberList -> ( Number (, Number ) * ) PositiveInteger -> [ 1 - 9 ] ( [ 0 - 9 ] ) * Number -> - ? [ 0 - 9 ]+ (. [ 0 - 9 ] [ 0 - 9 ]* ) ? String -> ( ' Char* ' ) | ( " Char* " ) Literal -> [ a - zA - Z0 - 9_ ]* 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
?
indicates an optional element
*
means zero or more; +
means one or more
(xxxxxx)
indicates a grouping
[a-z0-9]
signifies character ranges
|
stands for "or"
Rules and limitations
-
The
REGEXP_MATCHoperator uses RE2 syntax . -
To match a literal
[,],%, or_using theLIKEoperator, surround the character in square brackets. For example, the following condition matches allcampaign.namevalues that start with[Earth_to_Mars]:campaign . name LIKE '[[]Earth[_]to[_]Mars[]]%' -
The
LIKEoperator can only be used on a string field, not an array.
