Converts a ratio, number, or String to a percent.
Specify a String if an advertiser’s locale settings uses a comma to separate decimals (such as German).
Syntax
to_percent(x)
Examples
-
to_percent((Quality_score_current - Quality_score_average)/Quality_score_average)
-
If another formula column outputs a number that’s actually a percentage, you can convert the number to a percent:
To_percent(c:”CustomConversions”)
-
If an advertiser’s locale uses a comma to separate decimals (such as German), you’ll need to specify a String to convert a localized number or percent to a percent that Search Ads 360 recognizes:
To_percent(“10,67”) is 10.67% To_percent(“14,5%”)
:
evaluates to 14.5%Caution
If you used these two functions for an advertiser in the US, the expressions would evaluate to 1067% and 1450% respectively. Make sure you use commas and decimals in accordance with each advertiser’s locale setting.