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 about syntax for functions.


  • RETURN-ATTRIBUTE: Any type of standard attribute or custom attribute (number, text, or other types). The function returns the lowest value of this attribute for one of the selected items.
  • MIN-ATTRIBUTE: Any type of standard attribute or custom attribute (number, text, or other types), though typically you specify numeric or monetary attribute. The function selects all items that share the lowest value of this attribute.

    If you specify a text attribute, the function first sorts by lexicographic order, then it selects items at the beginning of the sort list.

Learn more about referring to inventory attributes.


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

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, 
[to_string(min_with_min(DISCOUNT, 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. Scans the DISCOUNT column for "Crew socks", "Dress socks", and "Knee-high socks" and returns the lowest value.

In this example, the function returns 15 ("Knee-high socks" have a 15% discount).

Was this helpful?
How can we improve it?