Days since latest order¶
Days since latest order measures the number of days that have elapsed since a customer has placed an order.
To find the number of days that have elapsed since a customer’s most recent order, start with the Days Since Latest Order attribute in the Transaction Attributes Extended table, and then set its condition to is between.

After the attribute appears in your segment, specify the number of days. For example, to find customers for whom 90 days have elapsed since their latest order:

Available conditions¶
The following table lists the conditions that are available to this attribute.
Note
This attribute has a Integer data type. All Integer data types share the same set of conditions. Recommended conditions for this attribute are identified with “ Recommended” and conditions with more limited use cases are identified with “ Not recommended”.
Condition |
Description |
---|---|
is |
is returns customer records with dates that match the specified date. |
is between |
Recommended is between returns customer records with dates that are between the specified dates, not including the specified date. Tip A churn prevention campaign must measure the time that has elapsed since a customer’s most recent order and the current date. Use the in between operator along with relative date ranges to associate customers to specific stages within your churn prevention campaign. For example: if your churn prevention campaign has stages at 14 days and 1 month after the customer’s most recent purchase, add the following criteria to the 14-day segment: "Days Since Latest Order" is between 0 and 14
and the following criteria to the 1-month segment "Days Since Latest Order" is between 0 and 30
|
is greater than |
is greater than returns customer records with dates that are greater than the specified date, not including the specified date. |
is greater than or equal to |
is greater than or equal to returns customer records with dates that are greater than or equal to the specified date, including the specified date. |
is in list |
is in list returns customer records with dates that match the dates that are specified in the list. |
is less than |
Recommended is less than returns customer records with dates that are less than the specified date, not including the specified date. |
is less than or equal to |
Recommended is less than or equal to returns customer records with dates that are less than or equal to the specified date, including the specified date. |
is not |
Not recommended is not returns customer records with date that do not match the specified date. |
is not between |
Not recommended is not between returns customer records with dates that are not between the specified dates, not including the specified date. |
is not in list |
Not recommended is not in list returns customer records with dates that do not match the dates that are 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. |