Early Repeat Purchaser

Early repeat purchasers represent the percentage of first-time buyers who returned to make a second purchase within 90 days.

Use the Early Repeat Purchaser attribute to build segments that support campaigns that turn one-time buyers into repeat customers. Compare your one-time buyers with early repeat purchasers. Move customers who have made a repeat purchaser within 90 days out of your one-time buyer campaign and into other campaigns.

Tip

A one-time buyer could, in theory, make their elusive second purchase 60 days or 600 days after their first purchase. For early repeat purchaser to be a useful metric you cannot wait 600 days. Amperity defaults to 90 days; many customers choose to use a shorter time window.

To use a shorter time window, ask your DataGrid Operator to update the Transaction Attributes Extended table for your preferred value. For example, to use 60 days as the definition for an early repeat purchaser, change the current value to 60:

CASE
  WHEN DATEDIFF(attrs.second_order_datetime, attrs.first_order_datetime) <= 60 THEN true
  WHEN DATEDIFF(attrs.second_order_datetime, attrs.first_order_datetime) > 60 THEN false
  WHEN DATEDIFF(CURRENT_DATE(), attrs.first_order_datetime) > 60 THEN false
END AS `early_repeat_purchaser`

Use in segments

To find early repeat purchasers, start with the Early Repeat Purchaser attribute in the Transaction_Attributes_Extended table, and then set its condition to is true.

Choose the early repeat purchaser attribute from the Segment Editor.

Available conditions

The following table lists the conditions that are available to this attribute.

Note

This attribute has a Boolean data type. All Boolean 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 false

Recommended

is false filters your segment to contain customers who have not made a second purchase within the timeframe that defines an early repeat purchaser. By default this timeframe is “within 90 days”.

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 true

Recommended

is true filters your segment to contain customers who have made a second purchase within the timeframe that defines an early repeat purchaser. By default this timeframe is “within 90 days”.