Google Ads Predicates
You are looking at an older version of the documentation. The latest version is found here.
The following keywords can be used as predicates in Google Ads reports:
| Enumeration | Description |
|---|---|
EQUALS | Checks if the field is equal to the given value. This operator is used with integers, dates, booleans, strings, enums, and sets. |
NOT_EQUALS | Checks if the field does not equal the given value. This operator is used with integers, booleans, strings, enums, and sets. |
IN | Checks if the field is equal to one of the given values. This operator accepts multiple operands and is used with integers, booleans, strings, and enums. |
NOT_IN | Checks if the field does not equal any of the given values. This operator accepts multiple operands and is used with integers, booleans, strings, and enums. |
GREATER_THAN | Checks if the field is greater than the given value. This operator is used with numbers and dates. |
GREATER_THAN_EQUALS | Checks if the field is greater or equal to the given value. This operator is used with numbers and dates. |
LESS_THAN | Checks if the field is less than the given value. This operator is used with numbers and dates. |
LESS_THAN_EQUALS | Checks if the field is less or equal to than the given value. This operator is used with numbers and dates. |
STARTS_WITH | Checks if the field starts with the given value. This operator is used with strings. |
STARTS_WITH_IGNORE_CASE | Checks if the field starts with the given value, ignoring case. This operator is used with strings. |
CONTAINS | Checks if the field contains the given value as a substring. This operator is used with strings. |
CONTAINS_IGNORE_CASE | Checks if the field contains the given value as a substring, ignoring case. This operator is used with strings. |
DOES_NOT_CONTAIN | Checks if the field does not contain the given value as a substring. This operator is used with strings. |
DOES_NOT_CONTAIN_IGNORE_CASE | Checks if the field does not contain the given value as a substring, ignoring case. This operator is used with strings. |
CONTAINS_ANY | Checks if the field contains any of the given values. This operator accepts multiple values and is used on sets of numbers or strings. |
CONTAINS_ALL | Checks if the field contains all of the given values. This operator accepts multiple values and is used on sets of numbers or strings. |
CONTAINS_NONE | Checks if the field contains none of the given values. This operator accepts multiple values and is used on sets of numbers or strings. |
Keywords CONTAINS_ANY, CONTAINS_ALL, CONTAINS_NONE, UNKNOWN can only be used with labels.
Fields whose data type is double can be used only with the following operators in predicates: LESS_THAN or GREATER_THAN.