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

  1. Key - Key is a record in the database.
  2. Key is set - Field which holds the value of an attribute.
  3. Key not set - The field is not present to hold the value of the attribute.
  4. 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.
  5. 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.
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.
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.
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 Jan 2021 & N =3.
From = 12:00:00 AM, 4 Jan 2021.
To = 11:30:30 AM, 7 Jan 2021.

on date

Stored value is
From = Start of day(Date),
To = End of day(Date).
Date is the filter date.

Example: If selected Date = 7 Jan 2021.
From = 12:00:00 AM, 7 Jan 2021.
To = 11:59:59 PM, 7 Jan 2021.

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 Jan 2021 & N =3.
From = 12:00:00 AM, 4 Jan 2021.
To = 11:59:59 PM, 4 Jan 2021.

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 Jan 2021, & N =3.
From = 12:00:00 AM, 10 Jan 2021.
To = 11:59:59 PM, 10 Jan 2021.

is 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 Jan 2021, & Date2 = 15 Jan 2021.
From = 12:00:00 AM, 7 Jan 2021.
To = 11:59:59 PM, 15 Jan 2021.

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 Jan 2021, N1 = 3, & N2 = 5.
From = 12:00:00 AM, 2 Jan 2021.
To = 11:59:59 PM, 4 Jan 2021.

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 Jan 2021, N1 = 3, & N2 = 5.
From = 12:00:00 AM, 10 Jan 2021.
To = 11:59:59 PM, 12 Jan 2021.

before  date

Stored value is
To = End of day(Date - 1 day).
Date is the filter date.

Example: If selected Date = 7 Jan 2021.
To = 11:59:59 PM, 6 Jan 2021.

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 Jan 2021, & N = 3.
To = 11:59:59 PM, 3 Jan 2021.

after  date

Stored value is
From = Start of day(Date + 1 day)
Date is the filter date.

Example: If selected Date = 7 Jan 2021.
From = 12:00:00 AM, 8 Jan 2021.

days from now 

Stored value is
from = Start of day(now + (N+1) days)
N is the filter value.

Example: If selected Date = 7 Jan 2021, & N = 3.
From = 12:00:00 AM, 11 Jan 2021.

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 Jan 2021 & N =3.
From = 11:30:30 AM, 7 Jan 2021.
To = 11:59:59 PM, 10 Jan 2021.

is today  

Stored value is
From = Start of day(Today),
To = End of day(Today).

Example: If Now = 11:30:30 AM, 7 Jan 2021.
From = 12:00:00 AM, 7 Jan 2021.
To = 11:59:59 PM, 7 Jan 2021.

exists   The stored value is present.
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.

 

attribute.png

event.png

 

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:
  1. Entire Analytics Suite
  2. 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.
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.
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).

Was this article helpful?
1 out of 1 found this helpful