This filter lets you build audience group based on the number of expired points. 

Basic options available:

The following are the basic or mandatory options available for expired points.

Points Range

  • Greater than equal: Include/exclude customers whose number of points getting expired are more than the number specified herein 
  • Less than equal: Include/exclude customers whose number of points getting expired are less than the number specified herein
  • Equals: Include/exclude customers with the exact number of points getting expired 
  • In the range of:  Include/exclude customers whose expiring points are in a specific range (Min points to Max points)

Advanced Options

Advanced options are optional filters that you can use for expired points. Click +/- Fields to see the advanced filter options available

Date:

  • Specific dates:  You can fetch customers whose specific number of points are expired in a specific date range
  • Relative days: You can fetch customers whose specific number of points are expired 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:  You can choose the duration in the last x days, calendar weeks or calendar months. For example, if you set 2 in the last x calendar week,   you will get customers whose specific number of points are expired in the previous 2 calendar weeks excluding the current week. A week is from Monday - Sunday, and a month is from 1-30/31 and 27/28 for Feb. So, 1 is to consider the previous day, calendar week or calendar month, 2 is to consider previous 2 calendar weeks or months and so on

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 

  • In the next x: Lets you build audience group whose specified range of points 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 specified range of points (points range) 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 with the specified points expiry range 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

  • In the current x: Fetches customers whose specified range of points are expiring on the current day, calendar week or calendar month
  • Between days:  Fetches customers whose specified range of points were 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 in the calculation of the number of days

Note: When you use between days of last ___ to last ___ say x and y respectively, the value of x should always be greater than y. For example, between last 10 days and last  5 days. Similarly, when you use next x days and next y days, the value of x should be less than y

  • Exactly x days ago: Fetches customers that registered x days ago (current day will not be included). For example, I can get the customers registered 10 days ago excluding the current day
  • Exactly after x days: Fetches customers who will be registered after x days excluding the current day. For example, I can get the customers who will be registered on the 10th day excluding today. 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. This lets you filter the specified range of points that are expired or getting expired in a specified date range.

  • Before: To consider all dates before a specific date (includes the specified date)
  • After: To consider dates after a specific date (includes the specified date)
  • Between: To consider a specific date range (includes the specified dates)

Promotion Name

You can further filter the specified range of expired points of a specific promotion. You can also choose multiple promotions to get customers based on the expired points of selected promotions.

Click +/- Fields > Check Promotion Name > You will see the promotion name drop-down box. Select desired promotions from the available list.

Promotion Type

You can further filter the specified range of expired points of a specific promotion type - bill, transaction, line-item, and customer. You can also select multiple promotion types.

Click +/- Fields > Check Promotion Type> You will see the promotion type drop-down box. Select desired promotion types from the available list.

Points Awarded Type

You can further filter based on the type of awarded points that are expired/expiring. You will have points awarded at bill, line item, bill promotion, line-item promotion, and customer promotion. You can also select multiple points awarded types.

Click +/- Fields > Check Points Awarded Type> You will see the points awarded type drop-down box. Select the desired awarded types from the available list.