Lets you filter customers based on the number of coupons redeemed in a given time duration.

Basic Options

Following are the basic filter options available for Coupon Redemption.

Redemption Count

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

Duration

Specific dates

Lets you fetch customers based on the number of coupon redemptions during 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 based on their number of coupon redemptions before a specific date
  • After: To get customers based on their number of coupon redemptions after a specific day
  • Between dates: To get customers based on their coupon redemption count during a specific date range (X to Y)

Relative days

Lets you fetch customers with coupon redemption 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 redeemed a specific number of coupons 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 redeemed a specific number of coupons 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 will redeem a specific number of coupons 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 redeemed a specific number of coupons on the current day, calendar week or calendar month
  • Between days:  Fetches customers who redeemed a specific number of coupons 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 redeemed a specific number of coupons x days ago. For example, you can get the customers who redeemed 1 coupon 10 days ago
  • Exactly after x days: Fetches customers who will redeem a specific number of coupons after x days from the current day. For example, you can get the customers who will redeem a specific number of coupons on the 10th day from now. 1 is for tomorrow, 2 for the day after tomorrow and so on


Advanced Options

Besides basic options, you can also use advanced filter options using +/- Fields

Campaign

Lets you filter customers who redeemed coupons of a specific campaign. Click +/- Fields > Select Campaigns > Type your preferred campaign name in the available box and check the campaign to select (you can select multiple campaigns) > Click Select

Discount Code

Lets you filter customers who redeemed a specific coupon. Click +/- Fields > Select Discount Code> Type your preferred coupon code in the available box and check the code to select (you can select multiple coupon codes) > Click Select