Order IDs¶
An order ID is the unique identifier for the order and links together all of the items that were part of the same transaction. When an item has been returned or when an order has been cancelled, the order ID is the unique identifier for the original order, including the returned or cancelled items.
First order ID is the order ID for the first order that was made by a customer.
Latest order ID is the order ID for the most recent order that was made by a customer.
Second order ID is the order ID for the second order that was made by a customer.
You can access order ID attributes directly from the Segment Editor. To add these attributes to your segments, click Add criteria, select the Transaction Attributes Extended table (for First Order ID, Latest Order ID, and Second Order ID) or the Unified Transactions table (for Order ID), apply a condition, and then specify a value.

Available conditions¶
The following table lists the conditions that are available to order ID attributes.
Note
Order ID attributes have a String data type. All String data types share the same set of conditions. Recommended conditions for order ID attributes are identified with “ Recommended” and conditions with more limited use cases are identified with “ Not recommended”.
Condition |
Description |
---|---|
is |
is returns an audience that is associated with a specific order ID. |
is blank |
is blank returns an audience that is not associated with any order IDs. |
is in list |
is in list returns an audience that is associated with any order ID that is in the specified list. |
is like |
is like returns an audience that is associated with any order ID that shares the same set of specified characters. |
is not |
is not returns an audience that is associated with any order that is not the specified order ID. |
is not blank |
is not blank returns an audience that is associated with any order ID. |
is not in list |
is not in list returns an audience that is not associated with any order ID in the list. |
is not like |
is not like returns an audience that is not associated with any order ID that shares the same set of specified characters. |
is not NULL |
is not NULL returns customer records that have an order ID. |
is NULL |
is NULL returns customer records that do not have an order ID. |