Lesson info

In this video you'll learn how to use "OR" and "AND" logic attribute in a correct way. We'll as well focus on the mysterious option "True for multiple filters in the same event occurrence".

Lesson transcript

In this video we’re going to go get deeper into options available in the filtering section. We already know it’s very often the case that we need to combine different filters for the same attribute, different filters for different attributes or the mix of those. Let’s try it out now. I want to see all users from United States OR Brazil. As these two conditions are related to the same attribute, I’m specifying it directly here and setting the logic condition to OR. , because if we set it to AND there’d be no users as one attribute cannot have 2 different values at one moment. And now we see all those being from US or Brazil in the main table. Now, let’s assume I want to combine two filters related to different attributes. I need all users from US with email address ending with .com. In this case I’m setting up the logic condition up here to AND, as I’m combining two filters for DIFFERENT attributes. And let’s now apply those two rules at once. So I’m gonna filter out all users from US OR Brazil AND with email addresses ending with .com. If you’d set a filter logic at the top to OR, we’d see here users coming from US or Brazil, and in addition all users that have emails ending with.com, regardless of they country. Let’s now go down and focus on this field available to tick saying “True for multiple filters available in the same event occurrence”. Sounds a little mysterious, right? Let’s work it out then! Assume a user downloads a few ebooks from your blog, so let’s say he selects an “An Ultimate Office Makeover” which is 62-pages long and whose author is James Cromwell. He also goes for a shorter file on “10 Simple Tricks to Make Your Office More Like Home” with 25 pages and written by Alexandra Thompson. You have an event set up in your user.com app so that an event is performed each time a given file is downloaded and custom attributes related to them are being saved, such as number of pages, title and author. So let’s filter out all users that downloaded any file. As you know there are 3 standard event attributes you can filter each event by - first occurance, last occurance or count of occurances. I’m filtering out users for whom the event has occured today for the last time and wee see her here. After entering the user profile of Amanda Smith, we see that both event occurrances with values of additional event attributes have been added to the timeline. So we see the one whose author is Alexandra Thompson, which has 25 pages and is entitled “10 Simple Tricks to MAke Your Office More Like Home” and the second one below - written by James Cromwell, having 62 pages, wntitled “An Ultimate Office Makeover”. A cool thing about events is that you can also filter users basing on the custom event attributes that are saved inside a given event. So let’s try it out. I want all users that downloaded a file longer than 10 pages and whose author is “James Cromwell” and we see the user appears here. Ok, so let’s go further with our case. Let’s now assume there was also another user at your site and downloaded another ebook - titled “2019 Fall Trends in Office Fashion” written by James Cromwell and, similarly to the one downloaded by the first user - having also 25 pages. So as a summary: our first user Amanda Smith downloaded an ebook of 62 pages by James Cromwell and a one of 25 pages by Alexandra Thompson, while the second user - a file of 25 pages by James Cromwell. Let’s now filter out users that downloaded an ebook of 25 pages and written by James Cromwell. And… we see that both users are displayed in the results!!! But as you remember the first one hasn’t downloaded an ebook of 25 pages written by James Cromwell!!! Yes, it’s true that she had downloaded an ebook of 25 pages and something written by James Cromwell but those two filters are true for 2 different files downloaded by her. It’s not what I wanted to filter out though. I wanted users who downloaded an ebook of 25 pages written by James Cromwell. And that’s when this option here will be extremely useful. To apply multiple filters in the same event occurrence only, simply tick that field after specifying rules for event attributes, and after clicking on search we see now there is only one and correct user displayed and he did download an ebook of 25 pages by James Cromwell. So we’ve discussed additional possibilities in the users’ filters. Thanks for listening!