any_with_min

any_with_min returns a value from an item that has the lowest value for a specified attribute.

Note: This function is only available in Templates and can’t be used in Reporting.

Syntax

any_with_min(value, order_value)

Parameters

  • value: Any type of attribute or column (number, text, or boolean). The function returns the highest value of this attribute for one of the selected items.
  • order_value: Any type of standard attribute or custom attribute (number, text, or boolean), though typically you specify numeric or monetary attribute. The function selects all items that share the highest value of this attribute.

Example

An ad group that's scoped to the "MyBrand" brand contains the following items:

BRAND

TITLE

PRICE

DISCOUNT

MyBrand

Red shoes

$10.00

10%

MyBrand

Yellow shoes

$10.00

10%

MyBrand

Blue shoes

$10.00

5%

MyBrand

Crew socks

$5.00

20%

MyBrand

Dress socks

$5.00

20%

MyBrand

Knee-high socks

$5.00

15%

In an ad template, [any_with_min(TITLE, PRICE)] does the following:

  1. Scans the PRICE column and finds the items that share the lowest price.
    In this case, the function selects "Crew socks", "Dress socks", and "Knee-high socks" (which all specify a price of $5).
  2. Returns the value of the TITLE attribute for one of those items. That is, the function returns either "Crew socks", "Dress socks", or "Knee-high socks".

Related links

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
736248276065109683
true
Search Help Center
true
true
true
true
true
5055977
false
false