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.

[ARTICLE] if_not_finite_number

Evaluates value. If value is not a finite number, the function evaluates alternate. Otherwise, the function returns value.

This function is mostly intended to handle metrics that return NaN (not a number) when the data isn't available, such as Avg_pos. However, you can also use the function to handle complex formulas that might return an infinite number.


if_not_finite_number(value, alternate)
value and alternate can be an expression, a number, or any Search Ads 360 variable that is a number.

You can nest this function to create an if/then/else evaluation.


  • Returns the "organic average position." If "organic average position" isn't available, Search Ads 360 reports NaN. In that case, the function returns "paid average position," or 0 if "paid average position" isn't available:
    if_not_finite_number(Organic_avg_pos, if_not_finite_number(Paid_avg_pos,0))

Was this helpful?
How can we improve it?
Clear search
Close search
Google apps
Main menu
Search Help Center