Order frequency intervals

Order frequency is the total number of orders that that a customer has made during the specified interval. Order frequencies are available at the following intervals:

• L30D Order Frequency (30 days)

• L3M Order Frequency (3 months)

• L6M Order Frequency (6 months)

• L12M Order Frequency (12 months)

• LY12M Order Frequency (12-to-24 months)

• Lifetime Order Frequency (Lifetime)

Use in segments

You can access order frequency intervals directly from the Segment Editor. To add these attributes to your segment, click Add criteria, select the Transaction Attributes Extended table, select an order frequency interval, and then apply a condition.

Available conditions

The following table lists the conditions that are available to these attributes.

Note

These attributes have an Integer data type. All Integer data types share the same set of conditions. Recommended conditions for these attributes are identified with “  Recommended” and conditions with more limited use cases are identified with “  Not recommended”.

Condition	Description
is	is returns customer records with values that match the specified order frequency.
is between	Recommended is between returns customer records with values that are between the specified order frequency.
is greater than	Recommended is greater than returns customer records with values that are greater than the specified order frequency, not including the order frequency.
is greater than or equal to	is greater than or equal to returns customer records with values that are greater than or equal to the specified order frequency, including the order frequency. Tip Use the Lifetime Order Frequency with the **is greater than or equal to condition to identify unique customers who have made at least one purchase. Set the value of is greater than or equal to to the number of purchases you want to be the minimum lifetime order frequency for this segment.
is in list	is in list returns customer records with values that match the order frequency that are specified in a list.
is less than	Recommended is less than returns customer records with values that are less than the specified order frequency, not including the order frequency.
is less than or equal to	is less than or equal to returns customer records with values that are less than or equal to the specified order frequency, including the order frequency.
is not	Not recommended is not returns customer records with values that do not match the specified order frequency.
is not between	Not recommended is not between returns customer records with values that are not between the specified order frequency, not including the order frequency.
is not in list	Not recommended is not in list returns customer records with values that do not match the order frequency that is specified in the list.
is not NULL	is not NULL returns customer records that have a value.
is NULL	is NULL returns customer records that do not have a value.