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 add order frequency interval attributes to a segment from the Segment Editor. Click Add condition, and then choose Attributes.

Select attributes.

Enter “order frequency” into the search feature to filter the list of available attributes. Choose an interval to add the attribute to a segment. Select an operator, and then finish defining the conditions for how this attribute should be applied to the segment.

Available operators

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

Note

These attributes have an Integer data type. All Integer data types share the same set of operators. Recommended operators for this attribute are identified with “ More useful” and operators with more limited use cases are identified with “ Less useful”.

Operator

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.