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