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 article helpful?
How can we improve it?