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.

Choose the order ID attribute from the Segment Editor.

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.