Early repeat purchasers

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 purchase within 90 days out of your one-time buyer campaign and into other campaigns.

The following sections describe using the the visual Query Editor to build a query that returns a list of customers who are early repeat purchasers.

Open the Visual Query Editor.

Open the visual Query Editor, look in the lower-right of the page and make sure your customer 360 database is selected.

Use your customer 360 database to build queries.
Find early repeat purchasers.

To identify customers who have made an early repeat purchase, choose the Amperity ID and Early Repeat Purchaser attributes from the Transaction Attributes Extended table. Set the condition for Amperity ID to “is not NULL” and the condition for Early Repeat Purchaser to “is true”:

Find early repeat purchasers.
Run the query.

Run the query to validate the syntax, and then review the results.

Save your segment.

You’re done! Give your query a name that clearly describes the purpose. For example: “Early Repeat Purchasers”.

Click the Activate button in the top right corner of the visual Query Editor.


Use the Early Repeat Purchaser attribute as a leading indicator for overall conversion rate of one-time buyers to repeat customers, even when it does not capture the total number of one-time buyers who have returned to purchase again.