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