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.

Choose an order frequency interval attribute from the Segment Editor.

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.