Fetches customers based on the number of expiring points in a specific duration.

Basic Options

Points Range

Lets you fetch on the basis of number of expiring points.

  • Greater than equal: Fetches customers whose number of expiring/expired points are more than or equal to the value specified here
  • Less than equal: Fetches customers whose number of expiring/expired points are less than or equal to the value specified here
  • Equals: Fetches customers whose number of expiring/expired points are equal to the value specified here
  • In the range of: Fetches customers whose number of expiring/expired points are in the range specified here (between min points and max points)

Date

  • Specific dates:  You can fetch customers who are registered in a specific date range
  • Relative days: You can fetch customers who are registered in the last x days/weeks/months

Relative Days

Following are options and sub options available if the duration is chosen as Relative days.

  • In the last x:  Lets you choose the duration in the last x days, in the last x calendar weeks, in the last x calendar months. For example, if you set 2 in the last x calendar week, you will get customers whose points were expired in the last two weeks (Monday - Sunday). This does not include the current week. Similarly, last x calendar month is from 1 to 30/31 and 28/29 for February.

Note: The current calendar week, calendar month or day will not be included when you choose the the last x calendar week, calendar month or day respectively . For example, if you are on the 2nd of a month, and set 1 in the last x calendar month, you will get customers based on the specified condition for the previous month. Current month details will not be included. Same thing will apply for last x day,and last x calendar week

  • In the next x: Lets you build audience group with customers whose points will be 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 points are expiring in the upcoming calendar week (a week is from Monday - Sunday). Similarly, if you say the next 3 calendar months, then you will get customers whose points are expiring in the next 3 calendar months excluding the current month. So 1 is for the next day/week/month, 2 is for next 2 days/calendar weeks/calendar months and so on 

Note: Current calendar week,  calendar month or day will not be included when you choose next calendar week, calendar month or day respectively. For example, if you are on Wednesday and set 1 in the next x calendar weeks, you will get customers based on the specified condition for the upcoming week (Monday until Sunday). Current week details will not be included. Same thing will apply for next x day,and next x calendar month

  • In the current x: Fetches customers whose specified number of points are expiring on the current day, calendar week or calendar month
  • Between days:  Fetches customers whose specified number of points are expiring (or expired) in the last/next x days until the next/last y days (For example, last 30 days until the next 15 days). Current day will not be included
  • Exactly x days ago: Fetches customers whose specified points were expired x days ago. For example, I can get the customers registered 10 days ago. Current day will not be included
  • Exactly after x days: Fetches customers whose specified points are expiring after x days. Current day will not be included in the calculation. For example, I can get customers with at least 50 points expiring on the 10th day. 1 is for tomorrow, 2 for the day after tomorrow and so on

Specific Dates

Following are options and sub options available if the duration is set to Specific Dates.

  • Before: Filters customers whose  specified points were expired before a specific date. Includes the specified date
  • After: Filters customers whose specified points are expiring (or expired) after a specific date. Includes the specified date
  • Between: Filters customers whose specified points are expiring (or expired) during a specific date range. Includes both the dates specified