Product catalogs

A product catalog represents data that describes purchased items, including unique identifiers, stock keeping units (SKUs), and other product attributes.

Important

A product catalog is most often available from the Unified Itemized Transactions table, but may also be available from other tables in your database.

Items in your product catalog are semantically tagged in the data sources that were made available to Amperity, after which it is available from the Unified Itemized Transactions table.

You can add product catalog attributes to a segment from the Segment Editor. Click Add condition, and then choose Attributes.

Enter “product” into the search feature to filter the list of available attributes. Choose a product catalog to add the attribute to a segment. Select an operator, and then finish defining the conditions for how this attribute should be applied to the segment.

Available operators

The following table lists the operators that are available to product catalog attributes.

Note

Product catalog attributes have a String data type. All String data types share the same set of operators. Recommended operators for this attribute are identified with “ More useful” and operators with more limited use cases are identified with “ Less useful”.

Operator	Description
contains	More useful Returns customer records with values that match a string of characters. For example: a list that specifies “shorts” and “shoes” will return customers who have purchased “shorts” and “shoes”, but not “pants” or “socks”.
does not contain	Returns customer records with values that do not match a string of characters. For example: A list that specifies “shorts” and “shoes” will return customers who have purchased “pants” or “socks”, but not “shorts” and “shoes”. “sh” will return “pants” and “socks”, but not “shirts” or “shorts”.
ends with	Returns customer records with values that end with the specified characters.
is empty	Less useful Returns customer records that do not have a value in this field.
is exactly	More useful Returns all customer records with values that match the specified characters. For example, “shorts” will return “shorts” and not “pants”, “shirts”, or “socks”.
is not empty	Returns customer records that have a value in this field.
is not exactly	Returns customer records that do not match the specified characters. For example: “shorts” will return “pants”, “shirts”, and “socks”.
starts with	Returns customer records that start with the specified characters.