Share your feedback about the Google Ads (AdWords) API. Take the 2021 AdWords API and Google Ads API Annual Survey.

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.*"