Welcome to the help center for Search Ads 360, a platform for managing search marketing campaigns.  While the help center is available to the public, access to the Search Ads 360 product is available only to subscribing customers who are signed in. To subscribe or find out more, contact our sales team.

ends_with

Evaluates to true if haystack ends with needle.

Syntax

ends_with(haystack, needle)

haystack and needle can be any of the following:

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

Case insensitive

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

Empty character

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

Be aware that all Strings end with an empty (zero-length) String. That is, ends_with("GDN", "") evaluates to true.

Note that ends_with("", "GDN") evaluates to false. That is, an empty String does not end with non-empty Strings.

Examples

  • [ends_with("hook", "fishhook")] is true.

  • If adgroup name ends with "shoes", replace "shoes" with "sneakers":
    [if(ends_with(ad_group, "shoes"), replace(ad_group, len(ad_group) - 4, 5, "sneakers"), ad_group)]

Was this helpful?
How can we improve it?
Search
Clear search
Close search
Google apps
Main menu
Search Help Center
true
263
false