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 this attribute are identified with “  More useful” and conditions with more limited use cases are identified with “  Less useful”.

Condition

Description

is

Returns customer records with values that match the specified order frequency.

is between

  More useful

Returns customer records with values that are between the specified order frequency.

is greater than

  More useful

Returns customer records with values that are greater than the specified order frequency, not including the order frequency.

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

Returns customer records with values that match the order frequency that are specified in a list.

is less than

  More useful

Returns customer records with values that are less than the specified order frequency, not including the order frequency.

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

  Less useful

Returns customer records with values that do not match the specified order frequency.

is not between

  Less useful

Returns customer records with values that are not between the specified order frequency, not including the order frequency.

is not in list

  Less useful

Returns customer records with values that do not match the order frequency that is specified in the list.

is not NULL

Returns customer records that have a value.

is NULL

Returns customer records that do not have a value.