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)]