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_number

Converts Money or a String to a number.

Specify a String if the current scope's locale setting or currency uses a comma to separate decimals (such as Germany or Euro).

Syntax

to_number(x)

Examples

to_number(Revenue)
If an advertiser’s locale uses a comma to separate decimals (such as Germany), you’ll need to specify a String to convert a localized number to a number that Search Ads 360 recognizes:
To_number(“1.234,5”) evaluates to 1234.5

Caution
If you used this function for an advertiser in the US, the expression would result in an error. Make sure you use commas and decimals in accordance with each advertiser’s locale setting.

Was this helpful?

How can we improve it?

Need more help?

Try these next steps:

Clear search

Close search

Google apps

Main menu