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. These semantic tags generate a standard output table named Unified Product Catalog. This table is frequently joined to the Unified Itemized Transactions table to ensure that the items in your product catalog are available to you when you build segments.

Use in segments

You can access product catalog attributes directly from the Segment Editor. To add these attributes to your segment, click Add criteria, select the Unified Itemized Transactions table, select one of your product catalog attributes, apply a condition, and then specify a value.

Available conditions

The following table lists the conditions 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 conditions. Recommended conditions for product catalog attributes are identified with “  Recommended” and conditions with more limited use cases are identified with “  Not recommended”.

Condition	Description
is	Recommended is to return an audience that is associated with the specified product catalog attribute. For example, “shorts” will return “shorts” and not “pants”, “shirts”, or “socks”.
is blank	Not recommended is blank to return an audience that is not associated with any product catalog attribute.
is in list	Recommended is in list to return an audience that is associated with any product catalog attribute in the list. For example: a list that specifies “shorts” and “shoes” will return customers who have purchased “shorts” and “shoes”, but not “pants” or “socks”.
is like	Recommended is like to return an audience that is associated with any product catalog attribute that shares the same set of specified characters. For example: “sh” will return “shirts” and “shorts”, but not “pants” or “socks”.
is not	Not recommended is not to return an audience that is associated with any product catalog attribute that is not the specified product catalog attribute. For example: “shorts” will return “pants”, “shirts”, and “socks”.
is not in list	Not recommended is not in list to return an audience that is not associated with any product catalog attribute in the list. For example: a list that specifies “shorts” and “shoes” will return customers who have purchased “pants” or “socks”, but not “shorts” and “shoes”.
is not like	Not recommended is not like to return an audience that is not associated with any product catalog attribute that shares the same set of specified characters. For example: “sh” will return “pants” and “socks”, but not “shirts” or “shorts”.
is not blank	Not recommended is not blank to return an audience that is associated with any product catalog attribute.
is not NULL	Not recommended is not NULL returns product catalog attribute records that have a value.
is NULL	is NULL returns product catalog attribute records that do not have a value.