Order Datetime

Order datetime is the date (and time) on which an order was placed.

  • First order date is the date on which the first order was placed by a customer.

  • Latest order date is the date (and time) on which the most recent order was placed by a customer.

  • Second order date is the date on which the second order was placed by a customer.

Examples

The following topics contain examples of using datetimes:

Use in segments

You can access datetime attributes directly from the Segment Editor. To add these attributes to your segments, click Add criteria, select the Transaction Attributes Extended table (for First Order Datetime, Latest Order Datetime, and Second Order Datetime) or the Unified Transactions table (for Order Datetime), apply a condition, and then specify a value.

Choose the first order datetime attribute from the Segment Editor.

Available conditions

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

Note

These attributes have a Datetime data type. All Datetime 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

Avoid using the is condition with these attributes unless you intend to use a specific date, such as “2022-08-22” (“yyyy-mm-dd”).

is after

Recommended

is after uses the selected calendar date to then return all dates that occur after the selected date, excluding the selected date.

is before

Recommended

is before uses the selected date to return all dates that occur before the selected date, excluding the selected date.

is between

Recommended

is between returns dates that exist within a defined start and end date.

For example, all orders made during a holiday shopping window, all orders made during a calendar year, and so on. Combine these attributes and condition with channels, brands, and purchase locations to build more specific audiences.

is not between

is not between returns order dates that exist outside of a defined start and end date.

For example, if you choose August 10, 2022 and August 12, 2022 as your start and end dates, all orders before August 10. 2022 and all orders after August 12, 2022 will be returned.

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.

is on or after

is on or after uses the selected calendar date to return all dates that occur on or after the selected date. Use a relative date to define a rolling window.

For example, use today - 90 days to return orders that have been made during the previous 90 days.

is on or before

is on or before uses the selected calendar date to return all dates that occur on or before the selected date. Use a relative date to define a rolling window.

For example, use today - 1080 days to return orders that were made 3 (or more) years ago.

About relative dates

A relative date is determined at the time a segment is run, where “today” is the day on which the segment is run, and “now” is the date and time on which the segment is run. For example: “today - 2 weeks” or “today - 14 days”.