Filters in segmentation

Across various pages on the MoEngage dashboard, events, event attributes, and user attributes filters can be used to get to the desired analysis or segment users. To get the right analysis and the right set of users, it's very important to know the filters.

This article explains how these filters work and if there are any different behavior or these filters on different pages.

Data Types

On the MoEngage dashboard, there are 6 primary data types.

String
A string is a sequence of characters. Strings are typically used to represent words and text. Character in a string can be a letter of some alphabet, a digit, a punctuation mark, a blank space, etc.
Boolean
The Boolean data type can have values as true and false.
Numeric
A number is a sequence of digits. Numeric data types are typically used to represent amount, quantity, and price.
Geo Location
Geo-Location represents the location on the map using latitude and longitude.
Date Time
Date time data types represent the date and time for an event or action.
Array
An array is a group of elements. In MoEngage, we have 2 array data types, String Array and Numeric array.

Terms to know

Key - Key is a record in the database.
Key is set - Field which holds the value of an attribute.
Key not set - The field is not present to hold the value of the attribute.
Stored Value - User Behavior or User Property value stored in the MoEngage Application. For example, App/Site Opened, Last Seen, Email Clicked. For more information, refer to Derived Events & Attributes.
Filter Value - The value you choose to filter based on the selected stored value. For example, you can choose the filter at least and type or select the duration or number of times the App/Site is opened.

String Filters

Operator	Explanation
is	The stored value is an exact match with the filter value.
exists	The stored value is present. This includes all values including Empty String and N/A. Filter users or events where the stored value exists (Key is set).
contains	The stored value contains the filter value.
starts with	The stored value starts with the filter value.
ends with	The stored value ends with the filter value.
in the following	The stored value matches one of the filter values.
is not	The stored value is not a match with the filter value. The Filter is applied to all the values of the attribute including the values that are not available (The Key is not set).
does not exist	The stored value is not present. The filter is applied to all the values of the attribute including the values that are not available (The Key is not set).
does not contain	The stored value does not contain the filter value. The filter is applied to all the values in the stored attribute including the values that are not available (The Key is not set).
does not start with	The stored value does not start with the filter value. (Key not set) The filter is applied to all the values of the attribute including the values that are not available (The Key is not set).
does not end with	The stored value does not end with the filter value. The filter is applied to all the values of the attribute including the values that are not available (The Key is not set).
not in the following	The stored value is not a match to any of the filter values. The filter is applied to all the values of the attribute including the values that are not available (The Key is not set).

Boolean Filters

Operator	Explanation
is	The stored value is an exact match with the filter value.
exists	The stored value is present. This includes all values including Empty Boolean and N/A.
does not exist	The stored value is not present (The Key is not set).

Numeric Filters

For the table below - N, N1, and N2 are numeric and N2 > N1.

Operator	Explanation
is equal to	The stored value is an exact match with the filter value.
is not equal to	The stored value is not a match to the filter value. The filter is applied to all the values of the attribute including the values that are not available (The Key is not set).
is between	The stored value is a match between the first filter value and the second filter value. N1 <= Stored value AND Stored value < N2. N1 & N2 are the first and second filter values respectively.
is not between	The stored value is not matched between the first filter value and the second filter value. N1 > stored value OR stored value >= N2. N1 & N2 are the first and second filter values respectively.
is less than	The stored value is lesser than the filter value. Stored value < Filter value
is greater than	The stored value is greater than the filter value. Stored value > Filter value
in the following	The stored value matches one of the filter values.
not in the following	The stored value does not match any of the filter values. The filter is applied to all the values of the attribute including the values that are not available (The Key is not set).
exists	The stored value is present. This includes all values including Empty Numeric and N/A. Filter users or events where the stored value exists (Key is set).
does not exist	The stored value is not present. The filter is applied to all the values of the attribute including the values that are not available (The Key is not set).

Location-triggered Filters

Operator	Explanation
Point with Radius	The stored geolocation value is within the circle defined by the point and the radius.

Date Time Filters

To understand filter operators in date-time data types, we need to first understand a few functions -

now = current timestamp up to milliseconds
start_of_day(timestamp) = 00:00:00 of the selected day/date
end_of_day(timestamp) = 23:59:59 of the selected day/date
n days = n * 24 hours
For the table below - n, n1, and n2 are numeric and n2 > n1.

For example

Let's assume now is 7:30:05 PM, 5 Jan 2001 then
- now - 3 days = now - (3* 24) hours = 7:30:05 PM, 2 Jan 2001
- now + 3 days = now + (3* 24) hours = 7:30:05 PM, 8 Jan 2001
- start of the day (now) = 12:00:00 AM, 5 Jan 2001
- end of the day (now) = 11:59:59 PM, 5 Jan 2001
Let's assume the date is 1 Jan 2001
- start of day (date) = 12:00:00 AM, 1 Jan 2001
- start of day (date + 1 day) = 12:00:00 AM, 2 Jan 2001
- start of day (date - 1 day) = 12:00:00 AM, 31 Dec 2000
- end of day (date) = 11:59:59 PM, 1 Jan 2001
- end of day (date + 1 day) = 11:59:59 PM, 2 Jan 2001
- end of day (date - 1 day) = 11:59:59 PM, 31 Dec 2000

Operator	Filter Value Type	Explanation
in the last	n days	Stored value is From = Start of day(Now - N days), To = Now. N is the filter value. Example: If Now = 11:30:30 AM, 7 Sep 2022 & N = 3. From = 12:00:00 AM, 4 Sep 2022. To = 11:30:30 AM, 7 Sep 2022.
	n hours	Stored value is From = Start of the hour (Now - N hours), To = Now N is the filter value. Example: If Now = 11:30:30 AM, 7 Sep 2022 & N = 3. From = 8:00:00 AM, 7 Sep 2022. To = 11:30:30 AM, 7 Sep 2022.
	n weeks	Stored value is From = Start of the week (Monday of (Now - N weeks)), To = Now N is the filter value. Example: If Now = 11:30:30 AM, 7 Sep 2022 & N = 2. From = 12:00:00 AM, 22 Aug 2022 (Monday) To = 11:30:30 AM, 7 Sep 2022.
	n months	Stored value is From = Start of the month (Now - N months), To = Now N is the filter value. Example: If Now = 11:30:30 AM, 7 Sep 2022 & N = 2. From = 12:00:00 AM, 1 Jul 2022. To = 11:30:30 AM, 7 Sep 2022.
on	date	Stored value is From = Start of day (Date chosen), To = End of day (Date chosen) Example: If Now = 11:30:30 AM, 7 Sep 2022 & Date chosen is today. From = 12:00:00 AM, 7 Sep 2022. To = 11:30:30 AM, 7 Sep 2022.
	days ago	Stored value is From = Start of day (Now - N days), To = End of day (Now - N days) N is the filter value Example: If Now = 11:30:30 AM, 7 Sep 2022 & N=3. From = 12:00:00 AM, 4 Sep 2022. To = 11:59:59 PM, 4 Sep 2022.
	days from now	Stored value is From = Start of day(Now + N days), To = End of day(Now + N days). N is the filter value. Example: If Now = 11:30:30 AM, 7 Sep 2022, & N=3. From = 12:00:00 AM, 10 Sep 2022. To = 11:59:59 PM, 10 Sep 2022.
in between	date	Stored value is From = Start of day(Date 1), To = End of day(Date 2). Date 1 & Date 2 are the start and end dates respectively. Example: If selected Date1 = 7 Sep 2022, & Date2 = 15 Sep 2022. From = 12:00:00 AM, 7 Sep 2022. To = 11:59:59 PM, 15 Sep 2022.
	days ago	Stored value is From = Start of day (Now - N2 days), To = End of day (Now - N1 days). N1 & N2 are the first and second filter values respectively. Example: If Now = 11:30:30 AM, 7 Sep 2022, N1 = 3, & N2 = 5. From = 12:00:00 AM, 2 Sep 2022. To = 11:59:59 PM, 4 Sep 2022.
	days from now	Stored value is From = Start of day(Now + N1 days), To = End of day(Now + N2 days). N1 & N2 are the first and second filter values respectively. Example: If Now = 11:30:30 AM, 7 Sep 2022, N1 = 3, & N2 = 5. From = 12:00:00 AM, 10 Sep 2022. To = 11:59:59 PM, 12 Sep 2022.
before	date	Stored value is To = End of day (Date chosen - 1 day) Example: If Now = 11:30:30 AM, 7 Sep 2022 & Date chosen is today. To = 11:59:59 PM, 6 Sep 2022.
before	days ago	Stored value is To = End of day(Now - (N+1) days) N is the filter value. Example: If Now = 11:30:30 AM, 7 Sep 2022 & N = 3. To = 11:59:59 PM, 3 Sep 2022.
after	date	Stored value is From = Start of day (Date chosen + 1 day), Example: If Now = 11:30:30 AM, 7 Sep 2022 & Date chosen is today. From = 12:00:00 AM, 8 Sep 2022.
after	days from now	Stored value is From = Start of day(now + (N+1) days) N is the filter value. Example: If selected Date = 7 Sep 2022, & N = 3. From = 12:00:00 AM, 11 Sep 2022.
in the next	days	Stored value is From = Now, To = End of day(now + N days). N is the filter value. Example: If Now = 11:30:30 AM, 7 Sep 2022 & N =3. From = 11:30:30 AM, 7 Sep 2022. To = 11:59:59 PM, 10 Sep 2022.
today		Stored value is From = Start of day(Today), To = Now Example: If Now = 11:30:30 AM, 7 Sep 2022. From = 12:00:00 AM, 7 Sep 2022. To = 11:30:30 AM, 7 Sep 2022.
yesterday		Stored value is From = Start of day(Now - 1 day), To = End of day(Now - 1 day) Example: If Now = 11:30:30 AM, 7 Sep 2022. From = 12:00:00 AM, 6 Sep 2022. To = 11:59:59 PM, 6 Sep 2022.
this week		Stored value is From = Start of week (Monday of the current week), To = Now Example: If Now = 11:30:30 AM, 7 Sep 2022. From = 12:00:00 AM, 5 Sep 2022. To = 11:30:30 AM, 7 Sep 2022.
last week		Stored value is From = Start of week (Now - 7 days), To = End of week (Now - 7 days) Example: If Now = 11:30:30 AM, 7 Sep 2022. From = 12:00:00 AM, 29 Aug 2022. (Monday) To = 11:59:59 PM, 3 Sep 2022.
this month		Stored value is From = Start of Month (1st of current month), To = End of Month (Now) Example: If Now = 11:30:30 AM, 7 Sep 2022. From = 12:00:00 AM, 1 Sep 2022. To = 11:30:30 AM, 7 Sep 2022.
last month		Stored value is From = Start of Month (Now - 1 month), To = End of Month (Now - 1 month) Example: If Now = 11:30:30 AM, 7 Sep 2022. From = 12:00:00 AM, 1 Aug 2022. To = 11:59:59 PM, 31 Aug 2022.
exists		The stored value is present. This includes all values including Empty Date Time and N/A. Filter users or events where the stored value exists (Key is set).
does not exist		The stored value is not present. The filter is applied to all the values of the attribute including the values that are not available (The Key is not set).

Special Date Filters

Special date filter filters for a specific hour, weekday, month, date of the month, and date of the year. This is useful for filtering out birthdays across years, and bill date across months.

Special date filters are available in the drop-down next to the date attributes in the User property and in the User behavior section.

Operator	Text on Dashboard	Explanation
Date	Date	Filter the stored dates.
Hour of the day	Daily where the hour/s	Filter the stored dates based on their hour. Use this option to filter dates having specific hour/s e.g. 12 AM - 1 AM. Use this filter to segment all users whose movie time or yoga class time falls between 8 AM - 9 AM.
Day of the week	Weekly where the day/s	Filter the stored dates based on their weekday. Use this option to filter dates of specific weekdays e.g. Monday. Use this filter to segment all users who ordered food or booked a cab on Friday.
Day of the month	Monthly where the day/s	Filter the stored dates based on their day. Use this option to filter dates of a specific day of any month e.g. 5th. Use this filter to segment users whose monthly bill payment date or subscription renewal date is the 15th.
Month of the year	Yearly where the month/s	Filter the stored dates based on their month. Use this option for actions performed on a specific month of any year e.g. January. Use this filter to segment all users whose birthday or yearly subscription expiry is in March.
Date Month	Yearly where the date/s	Filter the stored values based on their date month combination. Use this option to filter dates having a specific date month combination e.g. 01 Feb. This can be used to filter birthdays and anniversaries e.g. segment users whose birthday or billing day is 15 Sep.

Special date filters are available only for user and event attributes where the data type is 'date'. Special date filters are not available in the Affinity Segmentation and analytics filter.

Hour of the day - Daily where the hours

For hours of the day, let’s understand these filters' definitions better with examples.

Operator	Filter Value	Explanation
in the following	--	Hour value of the stored date matches with one of the filter values.
on	hour	Stored value is From = Start of the hour(Hour), To = End of the hour(Hour). Hour is the filter hour. Example: If selected Hour = 12 AM. From = 12:00:00 AM, To = 12:59:59 AM. (Irrespective of the date)
	hours ago	Stored value is From = Start of the hour(Now - N hours), To = End of the hour(Now - N hours). N is the filter value. Example: If Now = 11:30:30 AM & N =3. From = 8:00:00 AM, To = 8:59:59 AM. (Irrespective of the date)
	hours from now	Stored value is From = Start of hour(Now + N hours), To = End of hour(Now + N hours). N is the filter value. Example: If Now = 11:30:30 AM & N =3. From = 02:00:00 PM, To = 02:59:59 PM. (Irrespective of the date)
In between	hour	Stored value is From = Start of the hour(Hour 1), To = End of the hour(Hour 2). Hour 1 & Hour 2 are the start and end hours respectively. Example: If selected Hour1 = 01 AM, & Hour2 = 05 PM. From = 01:00:00 AM, To = 05:59:59 PM. (Irrespective of the date)
	hours ago	Stored value is From = Start of the hour(Now - N2 hours), To = End of the hour(Now - N1 hours). N1 & N2 are the first and second filter values respectively. Example: If Now = 11:30:30 AM, N1 = 3, & N2 = 5. From = 06:00:00 AM, To = 8:59:59 AM. (Irrespective of the date)
	hours from now	Stored value is From = Start of hour(Now + N1 hours), To = End of hour(Now + N2 hours). N1 & N2 are the first and second filter values respectively. Example: If Now = 11:30:30 AM, N1 = 3, & N2 = 5. From = 02:00:00 PM, To = 04:59:59 PM. (Irrespective of the date)
in the last	n hours	Stored value is From = Start of the hour(Now - N hours), To = End of the hour(Now) N is the filter value. Example: If Now = 11:30:30 AM & N =3. From = 8:00:00 AM, To = 11:59:59 AM. (Irrespective of the date)
in the next	n hours	Stored value is From = Start of hour(Now), To = End of hour(Now + N hours) N is the filter value. Example: If Now = 11:30:30 AM & N =3. From = 11:00:00 AM, To = 02:59:59 PM. (Irrespective of the date)

Day of the week - Weekly where the day

For the day of the week, let’s understand these filter definitions better with examples.

Operator	Filter Value	Explanation
is today	--	Stored value is From = Start of weekday(Now), To = End of weekday(Now) Example: If Now = 04:30:30 PM, 1 Jan 2001, Monday. From = Monday 12:00:00 AM, To = Monday 11:59:59 PM. (Irrespective of the date)
in the following	--	The weekday value of the stored date matches with one of the filter weekdays.
on	day	Stored value is From = Start of weekday(Day), To = End of weekday(Day) Day is filter weekday. Example: If Day = Wednesday. From = Wednesday 12:00:00 AM, To = Wednesday 11:59:59 PM. (Irrespective of the date)
	days ago	Stored value is From = Start of weekday(Now - N days), To = End of weekday(Now - N days). N is the filter value. Example: If Now = 04:30:30 PM, 1 Jan 2001, Monday & N = 3 From = Friday 12:00:00 AM, To = Friday 11:59:59 PM. (Irrespective of the date)
	days from now	Stored value is From = Start of weekday(Now + N days), To = End of weekday(Now + N days) N is the filter value. Example: If Now = 04:30:30 PM, 1 Jan 2001, Monday & N = 3 From = Thursday 12:00:00 AM, To = Thursday 11:59:59 PM. (Irrespective of the date)
In between	day	Stored value is From = Start of weekday(Day 1), To = End of weekday(Day 2) Day 1 & Day 2 are the start and end weekdays respectively. Example: If Now = 04:30:30 PM, 1 Jan 2001, Monday. Day 1 = Tuesday & Day 2 = Tuesday. From = Tuesday 12:00:00 AM, To = Thursday 11:59:59 PM. (Irrespective of the date)
	days ago	Stored value is From = Start of weekday(Now - N2 days), To = End of weekday(Now - N1 days). N1 & N2 are the first and second filter values respectively. Example: If Now = 04:30:30 PM, 1 Jan 2001, Monday. N1 = 2 & N2 = 4. From = Thursday 12:00:00 AM To = Saturday 11:59:59 PM (Irrespective of the date)
	days from now	Stored value is From = Start of weekday(Now + N1 days), To = End of weekday(Now + N2 days) N1 & N2 are the first and second filter values respectively. Example: If Now = 04:30:30 PM, 1 Jan 2001, Monday. N1 = 2 & N2 = 4. From = Wednesday 12:00:00 AM, To = Friday 11:59:59 PM. (Irrespective of the date)
in the last	N days	Stored value is From = Start of day(Now - N days), To = End of day(Now) N is the filter value. Example: If Now = 04:30:30 PM, 1 Jan 2001, Monday & N = 3. From = Friday 12:00:00 AM, To = Monday 11:59:59 PM. (Irrespective of the date)
in the next	N days	Stored value is From = Start of the day (Now), To = End of day(Now + N days) N is the filter value. Example: If Now = 04:30:30 PM, 1 Jan 2001, Monday & N = 3. From = Monday 12:00:00 AM, To = Thursday 11:59:59 PM. (Irrespective of the date)

Day of the month - Monthly where the day

For the day of the week, let’s understand these filter definitions better with examples.
Here Date(DD) numerical date value e.g. 11, 23, 05.

Operator	Filter Value	Explanation
is today	--	Stored value is From = Start of day(Now), To = End of day(Now) Example: If Now = 4:30 PM, 11 Jan 2001. From = 11th 12:00:00 AM To = 11th 11:59:59 PM (Irrespective of the month & year)
in the following	--	Date(DD) value of the stored date matches with one of the filter dates.
on	day	Stored value is From = Start of day(Date), To = End of day(Date) Date(DD) is the filter date. Example: If selected Date = 7th. From = 7th 12:00:00 AM, To = 7th 11:59:59 PM. (Irrespective of the month & year)
	days ago	Stored value is From = Start of day(Now - N days), To = End of day(Now - N days). N is the filter value. Example: If Now = 4:30 PM, 11 Jan 2001 & N = 3. From = 8th 12:00:00 AM, To = 8th 11:59:59 PM. (Irrespective of the month & year)
	days from now	Stored value is From = Start of day(Now + N days), To = End of day(Now + N days) N is the filter value. Example: If Now = 4:30 PM, 11 Jan 2001 & N = 3. From = 14th 12:00:00 AM, To = 14th 11:59:59 PM. (Irrespective of the month & year)
In between	day	Stored value is From = Start of day(Date1), To = End of day(Date2) Date1(DD) & Date 2(DD) are the start and end dates respectively. Example: If Date1 = 14th & Date2 = 23rd. From = 14th 12:00:00 AM, To = 23rd 11:59:59 PM. (Irrespective of the month & year)
	days ago	Stored value is From = Start of day(Now - N2 days), To = End of day(Now - N1 days). N1 & N2 are the first and second filter values respectively. Example: If Now = 4:30 PM, 11 Jan 2001, N1 = 11 & N2=19. From = 23rd 12:00:00 AM, To = 31th 11:59:59 PM. (Irrespective of the month & year)
	days from now	Stored value is From = Start of day(Now + N1 days), To = End of day(Now + N2 days). N1 & N2 are the first and second filter values respectively. Example: If Now = 4:30 PM, 11 Jan 2001, N1 = 11 & N2=19. From = 22nd 12:00:00 AM, To = 30th 11:59:59 PM. (Irrespective of the month & year)
in the last	N days	Stored value is From = Start of day(Now - N days), To = End of day(Now). N is the filter value. Example: If Now = 4:30 PM, 11 Jan 2001 & N = 3. From = 8th 12:00:00 AM, To = 11th 11:59:59 PM. (Irrespective of the month & year)
in the next	N days	Stored value is From = Start of the day (Now), To = End of day(Now + N days). N is the filter value. Example: If Now = 4:30 PM, 11 Jan 2001 & N = 3. From = 11th 12:00:00 AM, To = 14th 11:59:59 PM. (Irrespective of the month & year)

Month of the year - Yearly where the month

For the month of the year, let’s understand these filters' definitions better with examples.

Operator	Filter Value	Explanation
is this month	--	Stored value is From = Start of month(Now), To = End of month(Now) Example: If Now = 4:30 PM, 11 Jan 2001. From = 1st Jan 12:00:00 AM To = 31st Jan 11:59:59 PM (Irrespective of the year)
in the following	--	The month value of the stored date matches one of the filter months.
on	month	Stored value is From = Start of month(Month), To = End of month(Month) Month is the filter month. Example: If selected Month = May. From = 1st May 12:00:00 AM To = 31st May 11:59:59 PM (Irrespective of the year)
	months ago	Stored value is From = Start of month(Now - N months), To = End of month(Now - N months) N is the filter value. Example: If Now = 4:30 PM, 11 Jan 2001 & N = 3. From = 1st Oct 12:00:00 AM, To = 30th Oct 11:59:59 PM. (Irrespective of the year)
	months from now	Stored value is From = Start of month(Now + N months), To = End of month(Now + N months). N is the filter value. Example: If Now = 4:30 PM, 11 Jan 2001 & N = 3. From = 1st Apr 12:00:00 AM, To = 30th Apr 11:59:59 PM. (Irrespective of the year)
In between	month	Stored value is From = Start of month(Month 1), To = End of month(Month 2). Month1 & Month2 are the start and end months respectively. Example: If Month1 = March, Month2= October. From = 1st Mar 12:00:00 AM, To = 30th Oct 11:59:59 PM. (Irrespective of the year)
	month ago	Stored value is From = Start of month(Now - N2 months), To = End of month(Now - N1 months). N1 & N2 are the first and second filter values respectively. Example: If Now = 4:30 PM, 11 Jan 2001, N1 = 4 & N2 = 7. From = 1st Jun 12:00:00 AM, To = 30th Sep 11:59:59 PM. (Irrespective of the year)
	month from now	Stored value is From = Start of month(Now + N1 months), To = End of month(Now + N2 months). N1 & N2 are the first and second filter values respectively. Example: If Now = 4:30 PM, 11 Jan 2001, N1 = 4 & N2 = 7. From = 1st May 12:00:00 AM, To = 31th Aug 11:59:59 PM. (Irrespective of the year)
in the last	n months	Stored value is From = Start of month(Now - N months), To = End of month(Now). N is the filter value. Example: If Now = 4:30 PM, 11 Jan 2001 & N = 3. From = 1st Oct 12:00:00 AM, To = 31th Jan 11:59:59 PM. (Irrespective of the year)
in the next	n months	Stored value is From = Start of month(Now), To = End of month(Now + N months). N is the filter value. Example: If Now = 4:30 PM, 11 Jan 2001 & N = 3. From = 1st Jan 12:00:00 AM, To = 30th Apr 11:59:59 PM. (Irrespective of the year)

Date-Month of the year - Yearly where the date

For the date month of the year, let’s understand these filters' definitions better with examples.

Operator	Filter Value	Explanation
is today	--	Stored value is From = Start of day(Now), To = End of day(Now) Example: If Now = 4:30 PM, 11 Jan 2001. From = 11th Jan 12:00:00 AM, To = 11th Jan 11:59:59 PM. (Irrespective of the year)
on	date month	Stored value is From = Start of day(Date-Month), To = End of day(Date-Month). Example: If Date-Month = 04 May. From = 4th May 12:00:00 AM, To = 4th May 11:59:59 PM. (Irrespective of the year)
	days ago	Stored value is From = Start of day(Now - N days), To = End of day(Now - N days) N is the filter value. Example: If Now = 11 Jan 2001, 4:29 PM & N = 3. From = 8th Jan 12:00:00 AM, To = 8th Jan 11:59:59 PM. (Irrespective of the year)
	days from now	Stored value is From = Start of day(Now + N days), To = End of day(Now + N days). N is the filter value. Example: If Now = 11 Jan 2001, 4:29 PM & N = 3. From = 14 Jan 12:00:00 AM, To = 14 Jan 11:59:59 PM. (Irrespective of the year)
In between	day	Stored value is From = Start of day(Date-Month1), To = End of day(Date-Month2) Date-Month1 & Date-Month2 are the starts and end days respectively. Example: If Date-Month1 = 03 March, & Date-Month1 = 10 October. From = 3rd Mar 12:00:00 AM, To = 10th Oct 11:59:59 PM. (Irrespective of the year)
	days ago	Stored value is From = Start of day(Now - N2 days), To = End of day(Now - N1 days). N1 & N2 are the first and second filter values respectively. Example: If Now = 11 Jan 2001, 4:29 PM. N 1 = 4 & N2 = 7. From = 4th Jan 12:00:00 AM, To = 7th Jan 11:59:59 PM. (Irrespective of the year)
	days from now	Stored value is From = Start of days(Now + N1 days), To = End of days(Now + N2 days). N1 & N2 are the first and second filter values respectively. Example: If Now = 11 Jan 2001, 4:29 PM. N 1 = 4 & N2 = 7. From = 15th Jan 12:00:00 AM, To = 18th Jan 11:59:59 PM. (Irrespective of the year)
in the last	N days	Stored value is From = Start of days(Now - N days), To = End of days(Now). N is the filter value. Example: If Now = 11 Jan 2001, 4:29 PM & N = 3. From = 8th Jan 12:00:00 AM, To = 11th Jan 11:59:59 PM. (Irrespective of the year)
in the next	N days	Stored value is From = Start of days(Now), To = End of days(Now + N days). N is the filter value. Example: If Now = 11 Jan 2001, 4:29 PM & N = 3. From = 11th Jan 12:00:00 AM, To = 14th Jan 11:59:59 PM. (Irrespective of the year)

Array Filters

Two types of array filters are available.

Array filters are not supported for:

Entire Analytics Suite
Triggers, Preference management, Conversion goal, and Personalization attributes

Array of Strings

Description for array filters for string -

Filter Name	Explanation
(any of) is	One of the stored values of the array is an exact match with the filter value.
(all of) is	All of the stored values of the array are an exact match with the filter value.
is not	All stored values of the array do not match with the filter value. The filter is applied to all the values of the attribute including the values that are not available (The Key is not set).
exists	The stored value is present. This includes all values including Empty Array and N/A. Filter users or events where the stored value exists (Key is set).
does not exist	The stored value is not present. The filter is applied to all the values of the attribute including the values that are not available (The Key is not set).
(any of) contains	One of the stored values of the array contains the filter value.
(all of) contains	All of the stored value contains filter value
does not contain	All of the stored value does not contain filter value. The filter is applied to all the values of the attribute including the values that are not available (The Key is not set).
(any of) starts with	Any of the stored values start with the filter value.
(all of) starts with	All of the stored value starts with the filter value.
does not start with	All of the stored does not start with the filter value. The filter is applied to all the values of the attribute including the values that are not available (The Key is not set).
(any of) ends with	Any of the stored values end with the filter value.
(all of) ends with	All of the stored value ends with the filter value.
does not end with	All of the stored does not end with the filter value. The filter is applied to all the values of the attribute including the values that are not available (The Key is not set).
(any of) in the following	Any of the stored values is an exact match for at least one of the filter values.
(all of) in the following	Stored values are an exact match for all the filter values.
not in the following	All of the stored value is not match any of the filter values. The filter is applied to all the values of the attribute including the values that are not available (The Key is not set).

Array of Numbers

Description for array filters for numeric values -

Filter Name	Explanation
(any of) is equal to	One of the stored values of the array is an exact match with the filter value
(all of) is equal to	All of the stored values of the array are an exact match with the filter value
is not equal to	All stored values of the array do not match with the filter value. Stored value includes the attributes where value does not exist (Key is not set).
(any of) is between	One of the stored values of the array is a match between the first filter value and the second filter value. N1 <= at least one of the stored values of the array AND the same value is < N2. N1 & N2 are the first and second filter values respectively.
(all of) is between	All of the stored value of the array is a match between the first filter value and the second filter value. N1 <= all stored values of the array AND all stored values of the array < N2. N1 & N2 are the first and second filter values respectively.
is not between	None of the stored values of the array matches between the first filter value and the second filter value. N1 > all stored values of the array OR all stored values of the array >= N2. N1 & N2 are the first and second filter values respectively.
(any of) is less than	One of the stored values of the array is lesser than the filter value.
(all of) is less than	All of the stored values of the array are lesser than the filter value.
(any of) is greater than	One of the stored values of the array is greater than the filter value.
(all of) is greater than	All of the stored values of the array are greater than the filter value.
(any of) in the following	Any of the stored values is an exact match for at least one of the filter values.
(all of) in the following	Stored values of the array are an exact match for all the filter values.
not in the following	Any of the stored values is not a match to any of the filter values. The filter is applied to all the values of the attribute including the values that are not available (The Key is not set).
exists	The stored value is present. This includes all values including Empty Array and N/A. Filter users or events where the stored value exists (Key is set).
does not exist	The stored value is not present in the filter value (Key not set).
(all of) in the following	Stored values are an exact match for all the filter values.
not in the following	All of the stored value is not match any of the filter values. The filter is applied to all the values of the attribute including the values that are not available (The Key is not set).