Google Ad Manager: Tips and best practices

Configuring filters (PQL)

Enter PQL filter statements in JSON format in the Filter statement field. Examples:

Equality with AND:

[
   "WHERE FIELD_NAME1 = 'value1' AND FIELD_NAME2 = 'value2'"
]

OR list:

[
   "WHERE FIELD_NAME = 'value1' OR FIELD_NAME = 'value2'"
]

IN list:

[
   "WHERE FIELD_NAME IN ('value1', 'value2')"
]

NOT IN list:

[
   "WHERE NOT FIELD_NAME IN ('value1', 'value2')"
]

LIKE wildcard:

[
   "WHERE FIELD_NAME LIKE 'string%'"
]

See the PQL reference: Google Ad Manager documentation.