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_money

Converts a Long, Double, String, or equivalent expression to money in the currency of whatever scope it's being evaluated in.

Syntax

to_money(x)

Parameter

X can be a Long, Double, String, or equivalent expression.

If your locale uses a comma to separate decimals, surround any Long, Double, String you enter with quotes. For example, these two formulas are equivalent:

  • To_money(“1,50”) - A comma separates the integer from the decimal, so you need to surround the amount with quotes
  • To_money(1.50) - A period separates the integer from the decimal, so you don't need to surround the amount with quotes 

Examples

  • to_money(Clicks * 0.02) or to_money(Clicks * to_money("0,02"))
    In this example, an advertiser places a value of 2 cents for each click. So the advertiser creates a formula that multiplies the number of clicks by 2 cents and converts the result to money. By placing this formula in a column on the Campaigns tab, the advertiser can compare the value generated by each campaign.

    Both formulas are equivalent. The second formula uses a comma to separate decimals.
     
  • if(Cost > to_money(100.50), "coût élevé", "--")
    or if(Cost > to_money("100,50"), "coût élevé", "--")
    In this example, an advertiser wants to display a notice on the keywords report if the cost of a keyword rises above 100 dollars and 50 cents. So the advertiser creates a formula that converts 100.50 (or "100,50") to money. Then the formula compares the result with the cost of a keyword. If the cost is higher than 100.50, the formula outputs "coût élevé". The advertiser places this formula in a column on the Keywords tab. Then the advertiser uses the column to sort the report and display all expensive keywords at the top of 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
10961667135819718917
true
Search Help Center
true
true
true
true
true
263
false
false