This filters out the customers on the basis of their average transaction value for a specific product during a defined time period.

Example: Customers who buy Yogurt more than $40 per bill in July.  Assume, Zoe has bought Yogurt as mentioned in the following table:

Transaction Date

Amount

July 5

$10

July 6

$50

July 10

$70

 Zoe will be selected as by logic, 10+50+70 = 130 and 130/3 = (>40).

 

Product

Select the product, attribute or category that you want to consider for average item value.

  • Category: Lets you get customers by their average basket value in a specific category. The options you see are based on the category defined for the org. You can filter the results further using either any product of the selected categories or products with specific attributes. Attributes are that configured for your product hierarchy such as brand name, image URL, price, and style.
  • Sub Category: Lets you get customers by their average basket value in a specific product sub category. You can filter the results further using either any product of the selected sub category(s) or products with specific attributes. Attributes are that configured for your product hierarchy such as brand name, image URL, price, and style.
  • Item Code: Lets you get customers by their average basket value of a specific item category. You can choose item code either by uploading item codes (upload list), fetching manually (enter values) or by product attributes such as brand name, image URL, price, style, and so on (based on attribute).


Duration

Choose your preferred duration for which the transactions has to be considered. For example, you can get customers by average value of pizza purchased during the last 3 months.

Lifetime

Lets you get customers based on their average transaction value from all the purchases made till date.

Specific Dates

Lets you get customers based on their average basket size for a specific date range. Use this when you know the date of the event.

Following options and sub-options available for Specific Dates.

  • Before: Lets you get customers based on their ABS value before a specific date, including the date mentioned
  • After: Lets you get customers based on their ABS value after a specific date, including the date mentioned
  • Between: Filters customers based on their ABS value between a specific date range, including both the dates mentioned. For example, target customers whose ABS is 5 between Jan 1, 2109 and Jan 21, 2019 including 1st and 21st.

Relative days

Lets you fetch customers with transaction count based the relative days, weeks or months. If you do have specific dates, you can use relative days to fetch customers. The following are the options available for relative days.

  • In the last x:  Lets you choose the duration in the last x days, in the last x calendar weeks or in the last x calendar months. For example, if you set in the last x calendar week as 10.  You will get customers who purchased a specific item(s) in the last ten weeks (Monday - Sunday). Similarly, last x calendar month is from 1 to 30/31.
  • In the next x: Lets you get customers who purchased a specific product or category in the next x days, calendar weeks or calendar months. For example, if you set 1 in the next x calendar week,  you will get customers who purchased a specific product(s) in the upcoming calendar week (which is Monday - Sunday). Similarly, if you say the next 3 calendar months, then it will be third month from  now (that is, 1 for next month, 2 for next to next month and so forth).
  • In the current x: Fetches customers who purchased a specific product or category on the current day, calendar week or calendar month
  • Between days:  Fetches customers  who purchased a specific product or category between 'the last x days` and 'the next y days' (For example, last 30 days until the next 15 days)
  • Exactly x days ago: Fetches customers who purchased a specific product or category x days ago. For example, you can get the customers who made 2-5 transactions 10 days ago
  • Exactly after x days: Fetches customers who will purchase a specific product or category after x days from the current day. For example, you can get the customers who will purchase men trousers on the 10th day from now. 1 is for tomorrow, 2 for the day after tomorrow and so on


ATV Range

Set your preferred average transaction value using the options available.

  • Greater than equal: Get customers whose average transaction value is greater than or equal to the value you specify
  • Less than equal: Get customers whose average transaction value is less than or equal to the value you specify
  • Equals: Get customers whose average transaction value size is equal the value you specify
  • In range of:  Get customers whose average transaction value is between a specific range (including minimum and maximum value you specify). For example, if you specify 50-100, you will get customers whose average transaction value greater than or equal to 50 and less than or equal to 100