Coupons are issued to customers through Campaigns or Loyalty module. These coupons will have a fixed validity. You can get the list of customers whose coupons are expiring in a specific period.

Basic Options

Number of expiring coupons

  • Greater than equal: To filter customers whose number of expiring coupons are greater than or equal to the value you specify
  • Less than equal: To filter customers whose whose number of expiring coupons are less than or equal to the value you specify
  • Equals: To filter customers whose number of expiring coupons are equal to the value you specify
  • In range of: To filter customers whose number of expiring coupons are 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 the number of expiring coupons before a specific date
  • After: To get customers based on their number of expiring coupon after a specific day
  • Between dates: To get customers based on the number of expiring coupons during a specific date range (X to Y)

Relative days

Lets you fetch customers based on the number of expiring coupons in relative days, weeks or months. If you do not have specific dates, you can use relative days to fetch customers.  The following are the options available for relative days.

  • In the next x: Lets you get customers whose specific number of coupons are expiring 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 whose specific number of coupons are expiring 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 whose specific number of coupons are expiring on the current day, calendar week or calendar month
  • Between days:  Fetches customers whose specific number of coupons are expiring between 'the last x days` and 'the next y days' (For example, last 30 days until the next 15 days)
  • Exactly after x days: Fetches customers whose specific number of coupons are expiring after x days from the current day. For example, you can get the customers whose specific number of coupons are expiring on the 10th day from now. 1 is for tomorrow, 2 for the day after tomorrow and so on