Most frequent order

Most Frequent Order returns the products that each of your customers ordered most frequently during your chosen date range and at the frequency you have defined. For example, return a list of customers whose most frequent purchase within the last 30 days was tacos:

Important

You must choose at least one product attribute – category, subcategory, description, or gender – and/or a store ID.

After you choose at least one product and specify a date range you may apply filters to associate your customers orders with specific products, brands, channels, and stores. For example, return a list of customers who most frequently ordered deluxe tacos in Goleta, CA.

What are purchase behaviors?

Purchase behaviors are a feature of Amperity that are built on top of standard output for transactions (orders and items). Purchase behaviors require standardized product catalog field names to be present in your standard output for transactions.

Use purchase behaviors in segments to return a list of customers, and then filter that list of customers by any combination of brand, channel, individual items in your product catalog, and store.

Purchase behaviors are available for first order, has not purchased, has purchased, most frequent order, repeat order, and total value of orders.

How most frequent order works

Most Frequent Order represents a common approach people use when they build segments: figure out what your customers purchased most often within a certain time window, and then associate that list of customers to your marketing campaigns.

Most Frequent Order is a compound attribute, which means that it’s built from a combination of attributes that already exist in your data, and then appears as a single attribute that you can choose from the Segment Editor.

With this attribute, you can focus less on SQL and more on finding answers that align to your marketing goals and strategies. Purchase behavior attributes simplify the number of steps that are required to associate a list of customers to your products, stores, channels, and brands.

Tip

For more information about how Most Frequent Order works, including an explanation of the SQL that runs behind the Segment Editor, review the Most Frequent Order topic in the Amperity A-Z reference.

Use most frequent order in a segment

To find all customers who made their first order within a specified date range, start with the Most Frequent Order attribute located under Transactional Behaviors:

After the attribute appears in your segment, select at least one of product category, product subcategory, product gender, or store ID, and then choose a date range:

After you specify a date range you may apply filters to associate these customers to specific products, brands, channels, and stores.

Example: Who likes to buy shoes?

In the following example uses Most Frequent Order to return a list of customers who have frequently purchased your brand of women’s shoes from your store: