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.

Choose the product category attribute from the Segment Editor.

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.