Is returned?

A flag that indicates if the item was returned.

You can access is return directly from the Segment Editor. To add this attribute to your segment, click Add criteria, select the Unified Itemized Transactions table, select the Is Return attribute, and then apply a condition.

Choose the is returned attribute from the Segment Editor.

Available conditions

The following table lists the conditions that are available to this attribute.


This attribute has a Boolean data type. All Boolean data types share the same set of conditions. Recommended conditions for this attribute are identified with “  Recommended” and conditions with more limited use cases are identified with “  Not recommended”.



is false


is false returns a list of customers who did not return an item.


Add Is Returned to your segment, and then set the condition to is false to ensure that your segment does not contain any returned items.

is not NULL

is not NULL returns a list of customers who returned an item or who did not return an item.


is NULL returns customer records that do not have information about returned items.

is true


is true returns a list of customers who returned an item.