This filter customers based on their avg basket size (in range, minimum/maximum) for their transactions during Lifetime and Specific/Relative dates.
a) Specific Dates:To be used when the user know exact date of an event.
Between dates
Scenario: Target all the customers whose ABS for transactions between 1st Jan till 19th Jan.
Filter: All the customers whose ABS is in range with defined size between 1st Jan to 19th Jan.
Start date(01/01/18) 00:00 am End date(19/01/18) 11.59pm
After date
Scenario: Target all the new customers ABS ( who transacted last month)
Filter: All the customers's ABS who have transacted after 1st Dec.
Start date(01/12/2017) 00:00 am End date (current date) 11.59pm
Before date
Scenario: Target all the customers who have transacted before 1st Dec.
Filter: All the customers ABS ho have transacted on or before 1st Dec.
Start date(01/12/2017) 00:00 am End date (current date) 11.59pm
b) Relative Dates
More Than X Days Ago
Scenario 2: Target all the customers who did not registered in last 60 days
Filter: All the customers ABS who last transacted 60 days ago
Start date(18/11/17) 00:00 am End Date (current date -80 days) 11.59pm
In the Last X Days
Scenario: Target all the customers who transacted last week.
Filter: All the customers who last transacted 7 days ago.
Start date(current date - 7 days i.e 13/01/18) 00:00 am End date (current date i.e 19/01/18) 11.59pm
Exactly before X days
Scenario: Target all the customers who registered in last 30 days.
Filter: All the customers who registered exactly before 30 days
Start Date(current date - 30 days i.e 19/12/17) 00:00 am End Date (current - day 19/01/18) 11.59 pm
Between days
Scenario:Target all the customers who have registered at the selected store, zone,or city between 1st Jan to 19th Jan.
Filter: All the customers who have registered between 1st Jan to 19th Jan.
Start date(01/01/18) 00:00 am End date(19/01/18) 11.59pm
c) Lifetime Dates
Scenario: Target all the customers since their first registration at the selected store, zone,or city