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




  • 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

    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?