View Categories

Customer Filters

Overview of the customer base filtration options

Customer filtration by parameters and filter groups have been added to the customer base

1. Filters include the following parameters:

  • Card balance
  • Device type
  • Card serial number
  • Card status
  • UTM-tag
  • Current number of uses
  • Registration date
  • Email
  • Gender
  • Name
  • Phone
  • Unused rewards
  • Number of stamps
  • Customer birthday

Filters can overlap on an AND/OR condition.

Filter can include:

  • comparison to a specific value (string, number, etc.): equal, not equal, more, less, etc.
  • entering a range of values: e.g. date from – date to
  • entering an array of values: equal to one from the list

For example, the “Card balance” filter

1. Filter Groups are ready-to-use presets based on filters. Each filter in a group can be applied individually or combined

There are currently 3 groups of filters, but they will be added quickly.

The first filter group “RFM – segments” is a method of analysis that allows you to segment customers based on two variables – duration and frequency of visits.

The following visit periods are included in the analysis:

0 to 30 days:

Number of visits from 0 to 3: RFM – Beginners

Number of visits from 4 to 7: RFM – Growths

Number of visits from 8 to 12: RFM – Champions

31 to 60 days:

Number of visits 0 to 3: RFM – Doubtful

Number of visits from 4 to 7: RFM – Medium (borderline)

Number of visits from 8 to 12: RFM – Loyal – Regular

61 to 90 days:

Number of visits 0 to 3: RFM – Sleeping

Number of visits from 4 to 7: RFM – At risk

Number of visits from 8 to 12: RFM – Needs attention

“Health” group contains filters that can be used to sort clients with missing data/not installed cards:

  • Card status not installed
  • Unknown gender
  • Empty birthday

The “Loyalty” filter group includes filters:

  • Card status installed
  • Apple Wallet
  • Wallet Passes
  • Google Pay
  • PWA