Search Ads 360 function list
Use the functions described in the table below to create formulas in Search Ads 360 formula columns or templates in an inventory plan.
Some functions can only be used in formula columns that contain engine or conversion metrics, while other functions can only be used in formulas or formula columns that contain inventory data. When you're creating formulas, Search Ads 360 shows only the functions that are valid for the current context.
| Type | Function | Description |
|---|---|---|
| Comparison | =, <>, <, >, <=, and >= | Compares two data items and evaluates to true or false. Learn more. |
| Conversion | to_money(x) | Converts a Long, Double, or String (or equivalent expression) to Money in the advertiser’s currency. Learn more. |
| Conversion | to_number(x) | Converts Money or a String to a number. Learn more. |
| Conversion | to_percent(x/y) | Converts a ratio, number, or String to a percent. Learn more. |
| Conversion | to_string(x) | Converts any numeric data type to a String. Follows the conventions of the advertiser's locale and currency. Learn more. |
| Dates | add_days(date, number-of-days) | Adds number-of-days to the date. Use negative to count backwards. Learn more |
| Date | calendar_months(numberOfMonths) | Returns the current month, or counts forward or backwards a specified number of months. Can only be used as the second date parameter in for_date_range(date, date). Learn more. |
| Date | calendar_weeks(numberOfWeeks, [startDay]) | Returns the current week, and can count forward or backwards a specified number of additional weeks. Can only be used as the second date parameter in for_date_range(date, date). Learn more. |
| Date | end_date - start_date (Date subtraction) | Calculates the number of days between two dates. Learn more. |
| Date | date(year, month, date) | Returns a specific date in the advertiser’s time zone. Learn more. |
| Date | day(date) | Returns the 1 or 2-digit day of the month from the specified date. Learn more. |
| Date | days(-x) | Counts backwards the specified number of full days starting from the most recent midnight. Can only be used as a duration parameter in for_date_range(). Learn more. |
| Date | for_date_range( | Specifies days to operate on. For example, Clicks.for_date_range(Last_30_days()) returns the number of clicks in the last 30 days.Learn more. |
| Date | from_date() | Returns the date at the beginning of the report’s current time range. Learn more. |
| Date | last_30_days() | Counts backwards 30 days starting from the most recent midnight. Can only be used as a range parameter in for_date_range(). Learn more. |
| Date | last_7_days() | Counts backwards 7 days starting from the most recent midnight. Can only be used as a range parameter in for_date_range(). Learn more. |
| Date | last_month() | Returns a range of the most recent full month. Can only be used as a range parameter in for_date_range(). Learn more. |
| Date | last_week([startDay]) | Returns a range of the most recent full week starting from Sunday or some other day you specify. Can only be used as a range parameter in for_date_range(). Learn more. |
| Date | month(date) | Returns the 1 or 2-digit month from the specified date. Learn more. |
| Date | months(-x) | Counts backwards the specified number of months. Can only be used as a duration parameter in for_date_range(). Learn more. |
| Date | num_days() | Returns the number of days in the report scope. Learn more. |
| Date | to_date() | Returns the date at the end of the report’s current time range. Learn more. |
| Date | today() | Returns today’s date in the advertiser’s time zone. Learn more. |
| Date | weekday(date, [week_start_day]) | Returns the day of the week (1 through 7) for the specified date. Learn more. |
| Date | weeknum(date, [week_start_day]) | Returns the week number (1 through 52, 53, or 54) for the specified date. Learn more. |
| Date | year(date) | Returns the 4-digit year from the specified date. Learn more. |
| Date | yesterday() | Returns yesterday’s date in the advertiser’s time zone. Learn more. |
| Error handling | if_not_finite_number(value, alternate) | Evaluates value. If value is not a number or a finite number, the function evaluates alternate. Otherwise, the function returns value. Learn more. |
| Error handling | if_error(value, alternate) | Evaluates value. If value returns an error, the function evaluates alternate. Otherwise, the function returns value. Learn more. |
| Error handling | is_error(value) | Evaluates to true if value is an error. Learn more. |
| Inventory | any(ATTRIBUTE) | Chooses a value for an inventory attribute from one of the items selected by a template. This function may output a different value each time it runs. Learn more |
| Inventory | any_with_max(RETURN-ATTRIBUTE, MAX-ATTRIBUTE) | Finds a group of items that share the highest value for a specific attribute, and then selects one of those items and returns the value of another attribute. Learn more |
| Inventory | any_with_min(RETURN-ATTRIBUTE, MIN-ATTRIBUTE) | Finds a group of items that share the lowest value for a specific attribute, and then selects one of those items and returns the value of another attribute. Learn more |
| Inventory | clean_keyword(in-string, replacement-string) | Scans in-string and replaces characters that Google Ads does not support for keyword text with replacement-string. Learn more |
| Inventory | count_with_max(ATTRIBUTE, MAX-ATTRIBUTE) | Finds a group of items that specify the highest value for a specific attribute, and then returns the number of items that also share the same value of another attribute. Learn more |
| Inventory | count_with_min(ATTRIBUTE, MIN-ATTRIBUTE) | Finds a group of items that specify the lowest value for a specific attribute, and then returns the number of items that also share the same value of another attribute. Learn more |
| Inventory | max_with_max(RETURN-ATTRIBUTE, MAX-ATTRIBUTE) | Finds a group of items that share the highest value for a specific attribute, and then returns the highest value of another attribute. Learn more |
| Inventory | max_with_min(RETURN-ATTRIBUTE, MIN-ATTRIBUTE) | Finds a group of items that share the lowest value for a specific attribute, and then returns the highest value of another attribute. Learn more |
| Inventory | min_with_max(RETURN-ATTRIBUTE, MAX-ATTRIBUTE) | Finds a group of items that share the highest value for a specific attribute, and then returns the lowest value of another attribute. Learn more |
| Inventory | min_with_min(RETURN-ATTRIBUTE, MIN-ATTRIBUTE) | Finds a group of items that share the lowest value for a specific attribute, and then returns the lowest value of another attribute. Learn more |
| Inventory | min(ATTRIBUTE) ormax(ATTRIBUTE) | Returns the minimum or maximum value of a numeric inventory attribute among all items generated by an inventory template.. Learn more |
| Inventory | reduce_words(string, max_length, delimiter, [delimiter], ...) | Returns as many characters as possible, starting from the beginning of a string and counting up to (but not including) a delimiter, while staying within max_length. If the string is already within max_length, the function returns string exactly as it was passed in. Learn more. |
| Inventory | count() | Returns the number of unique inventory items selected by an inventory template's multipliers and filters. Learn more |
| Inventory | lenb(string) | Returns the number of bytes in an inventory attribute or string. Learn more |
| Inventory | regex_extract(string, regular_expression) | Searches a string and returns text that matches a regular_expression. Learn more. |
| Inventory | regex_match(string, regular_expression) | Evaluates as true if string matches all or part of a regular_expression. Use this function as a condition in the if function. Learn more. |
| Inventory | regex_replace(string, regular_expression, new_text) | Searches a string for text that matches a regular_expression, then replaces the matching text with new_text. Learn more. |
| Inventory | searchb(needle, haystack) | Returns the starting position in bytes of the first instance of needle in haystack. Returns null if needle is not in haystack. Learn more |
| Inventory | substitute_all(ATTRIBUTE, "to text", "from text", "from text 2", "from text 3") | Replaces multiple values of an inventory attribute with a single value. Learn more |
| Inventory | title_case(string) | Converts string to title case. You can specify an inventory attribute such as BRAND or a static string. Learn more |
| Label | has_label("label") | Evaluates to true if the function appears in a row that has been tagged with the specified label. Learn more. |
| Logic | and(x, y, ...) | Logical AND. Evaluates to true if all parameters are true. Learn more. |
| Logic | if(condition, true, else) | Evaluates a condition and returns one value if the condition is true, and a different value if the condition is false. Learn more. |
| Logic | not(x) | Logical NOT. Evaluates to true if the parameter is false. Learn more. |
| Logic | or(x, y, ...) | Logical inclusive OR. Evaluates to true if any parameter is true. Learn more. |
| Math | ceiling(x) | Returns the smallest integer greater than x. Learn more. |
| Math | floor(x) | Returns the greatest integer less than x. Learn more. |
| Math | +, -, *, and / | Standard arithmetic operators. Learn more. |
| Math | round(x) | Rounds to the nearest integer. Learn more. |
| Math | -variable | Negates a variable value. For example, -Daily_budget returns the negative value of the daily budget. |
| Segments | for_device_type(type) | Specifies one or more device types to operate on. Learn more. |
| Segments | for_date_range( | Specifies days to operate on. For example, Clicks.for_date_range(Last_30_days()) returns the number of clicks in the last 30 days.Learn more. |
| Text | unescape("URL") | Decodes a URL that has been URL encoded. Learn more. |
| Text | bmm(string) | Adds the "+" character to the beginning of each word of string. Use in keyword templates to add the broad match modifier to each keyword term. Learn more.Some broad match modifier behavior moved to the phrase match typeIn conjunction with Google Ads, Microsoft Advertising, and Yahoo! Japan, Search Ads 360 will soon end support for creating broad match modifier keywords in manual campaigns and keyword templates in inventory campaigns. If a keyword template specifies the broad match modifier and Search Ads 360 is required to generate a new keyword, Search Ads 360 will generate a new phrase match keyword instead of a broad match keyword. Learn more. |
| Text | & | Concatenates two Strings (pieces of text). Learn more. |
| Text | contains(needle, haystack) | Evaluates to true when needle is a substring of haystack, or when needle is the same as haystack. Learn more. |
| Text | ends_with(haystack, needle) | Evaluates to true if haystack ends with needle. Learn more. |
| Text | is_empty(string) | Evaluates to true if string is zero-length. Learn more. |
| Text | left(string, length) | Returns the first length characters in string counting from the beginning of the string. Learn more. |
| Text | len(string) | Returns the length of string. Learn more. |
| Text | lower(string) | Returns string in all lower case. Learn more. |
| Text | mid(string, start, length) | Returns a substring of string starting at the start character and counting length characters. Learn more. |
| Text | replace(string, start, length, new_text) | Replaces characters in string with new_text, starting at position start and counting length characters. Learn more. |
| Text | right(string, length) | Returns the first length characters in string counting from the end of the string. Learn more. |
| Text | search(needle, haystack) | Returns the starting position of the first instance of needle in haystack, counting from the beginning of the string. Learn more. |
| Text | starts_with(haystack, needle) | Evaluates to true if haystack begins with needle. Learn more. |
| Text | substitute(haystack, needle, replacement [, occurrence]) | Substitutes all instances of needle in haystack with replacement. Specify occurrence to indicate which instance of needle to replace. Learn more. |
| Text | trim(string) | Removes all whitespace from the beginning and end of string and removes any double spacing between words in string. Learn more. |
| Text | upper(string) | Returns string in all upper case. Learn more. |
| Try your keywords on Google Web Search. | ||