count_with_min

Finds a group of items that share the lowest value for a specific attribute, and then returns the number of items that also share the same value of another attribute.

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

Syntax

count_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.

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

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,
[count_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 counts how many items specify the same value.
In this example, the function returns 2 ("Crew socks" and "Dress socks" both have a 20% discount).
  • In an ad template,
[count_with_min(TITLE, PRICE)
returns 1, since all items with the lowest price have unique titles.

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