Fetches customers based on the number of transactions returned during a specific duration.


Available Options


The following are the different basic options available to filter the customer list. All options are available by default. There are no advanced options for  this filter.

Return Amount/Count

  • Greater than equal: Filters customers whose return transaction amount/count is greater than or equal to the value you specify
  • Less than equal: Filters customers whose return transaction amount/count is less than or equal to the value you specify
  • Equals: Filters customers whose return transaction amount/count is equal to the value you specify
  • In range of: Filters customers whose return transaction amount/count is in between the values you specify

Duration

Lets you filter customers based on the return transaction amount or count during a specified period. You can choose duration either by specific dates or by relative days.

Specific dates

Lets you fetch customers return transaction amount or count based on a specific date range. You can use this option if you are specific about the dates. For example, event date. You will see the following sub-options for specific dates.

  • Before: To get customers with a specific return transaction amount or count before a specific date
  • After: To get customers with a specific return transaction amount or count after a specific date
  • Between dates: To get customers with a specific return transaction amount or count during a specific date range (X to Y)

Relative days

Lets you fetch customers with the return transaction amount or 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 returned a specific number of transactions 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 will return a specific number of transactions 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 returned a specific number of transactions or a specific transaction amount in the upcoming calender 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 returned a specific transaction amount/count on the current day, calendar week or calendar month
  • Between days:  Fetches customers  who returned a specific number of transactions or a specific transaction amount 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 made a specific number of transactions 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 return a specific number of transactions or a specific transaction amount after x days from the current day. For example, you can get the customers who will return 1 transaction on the 10th day from now. 1 is for tomorrow, 2 for the day after tomorrow and so on