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