Register for one of our Google Ads API Migration Workshops (October 5, 2021 - October 14, 2021)

Case Sensitivity

The Google Ads Query Language lets you filter the returned data set with a number of different operators. When filtering on string values, the default case sensitivity of each operator will play an important part in correctly filtering your results.

Operators Case Sensitivity
= or != Case sensitive
(NOT) IN Case sensitive
(NOT) LIKE Case insensitive
CONTAINS (...) Case sensitive
REGEXP_MATCH Optionally Both
SELECT campaign.id
FROM campaign
WHERE campaign.name REGEXP_MATCH "(?i).*test.*"