contains

Returns True when haystack text string contains needle

Syntax

contains(needle, haystack)

haystack and needle can be any of the following:

Static text, such as "GDN".
A Search Ads 360 variable that is a String, such as Keyword, Campaign, and so on.
An expression or formula column that returns a String.

Text comparisons are case insensitive. That is, contains("gdn", "GDN") evaluates to true.

If you include an expression or formula column in this function, the expression or formula column could evaluate to an empty text string.

Be aware that all Strings end with an empty (zero-length) String. For example, ends_with("GDN", "") will evaluate to true.

On the other hand, ends_with("", "GDN") evaluates to false. An empty text string does not end with non-empty text strings.

[contains("hook", "fishhook")]
evaluates to true
If a keyword contains "hoopers", display "brand". For other keywords, display "non-brand":
[if(contains("hoopers", keyword), "brand", "non-brand")]
If a keyword contains "hoopers" and is contained in a campaign that starts with "US", display "US brand":
[if(and(contains("hoopers", keyword), starts_with(campaign, "US")), "US brand", "non-brand")]
If campaign contains "Shopping" or "GDN" or "RLSA", display "budget 1", for others display "budget 2":
[if(or(contains("Shopping", campaign), contains("GDN", campaign), contains("RLSA", campaign)), "budget 1", "budget 2")]

How can we improve it?