Notification

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.

to_string

Converts any numeric data type to a String. 

Syntax

to_string(x)

x can be a constant, Search Ads 360 variable, an expression, or formula column that evaluates to Number, Percent, or Money. All commas in the input number are converted to periods in the output string.

Examples

Number to Strings:

  • to_string(1234.5) returns 1234.5

  • to_string(1,234) returns 1.234

  • to_string(1,234.5) shows an error, since 1.234.5 is not a valid format

Money to Strings:

  • to_string(Revenue) returns 10500.36

  • to_string(Cost + 5,000): if cost is $6.89, the function returns 11.89
    The function first converts 5,000 to 5.000, then adds the result to 6.89 for a total of 11.89.

  • For advertisers with a German language setting:
    to_string(Revenue) returns 10500.36, even though Revenue appears as 10500,36 in the report

Was this helpful?

How can we improve it?

Need more help?

Try these next steps:

true
Search
Clear search
Close search
Google apps
Main menu
7455406390179756420
true
Search Help Center
true
true
true
true
true
263
false
false