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