len

Returns the length of string. Counting starts from 1 (not 0).

Syntax

len(string)

string 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.

Examples

  • [len("Hello World!")] returns 12.

  • [len("")] returns 0.

  • 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?