Total value of orders¶
Total Value of Orders adds together all of the revenue for all of the items that customers purchased across all orders that match the value and occurred during your chosen date range. For example, return all customers who spent more than $100 during the previous six months:
After you specify a value and date range you may apply filters to associate these customers to specific products, brands, channels, and stores. For example, return all customers who spent at least 100 dollars within the previous six months on chewing gum and purchased from your website.
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 total value of orders works¶
Total Value of Orders represents a common approach people use when they build segments: find my customers by spend across a time window, and then associate those customers to specific products and brands.
Total Value of Orders 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 Total Value of Orders works, including an explanation of the SQL that runs behind the Segment Editor, review the Total Value of Orders topic in the Amperity A-Z reference.
Use total value of orders in a segment¶
To find the total values of orders for customers who made orders within a specified date range, start with the Total Value of Orders attribute located under Transactional Behaviors:
After the attribute appears in your segment, specify the value condition and choose a date range:
After you specify a value and date range you may apply filters to associate these customers to specific products, brands, channels, and stores.
Example: More than $500 on shoes¶
In the following example uses Total Value of Orders to return a list of customers who have spent at least $500 on shoes in the previous year:
