This is the 15th lesson video from my course The Exact Process For Setting Up Google Analytics – https://www.thequantifiedweb.com/exactga.
I decided to post the videos from the lessons publicly, but I encourage you to log into the course because from within the course you can access the written notes and the checklists, plus access my special offer. The course is completely free to register 🙂
In this lesson, you’ll be learning about how to rearrange the order of your filters in Google Analytics, because there are some filters that only work if you have them in a certain order. Out of order, they might do something unpredictable, particularly the Search and Replace filters. If you’re adding advanced filters in Google Analytics, do make sure you watch this video!
Click to Open Transcription of Video
Welcome to Lesson Fifteen in the Exact Process for Setting Up Google Analytics. Now, we’re going to go through ordering the different filters that we’ve just created so that they’re in the correct order to work correctly. Some of the filters do require them being in a particular order otherwise they won’t work.
So let’s go through and do that. So the first thing you want to do is go to the website here, www.thequantifiedweb.com/exactga and you’re going to type in your email address and click Get Started Today. Now go down to, here we go, Assign the Filter Order. Oops, it’s hidden, there it is.
Alright, so what we’re going to do is we’re just going to reorder the filters that we created and ensure they occur in a different oops, there are some filters that need to be in front of the other filters. Now, this particular image, I actually re-use this for a few different setups so it includes some filters relating to bookings and things. So we don’t have to worry about all of those, let’s just relay through — we’ve just got these at the top here as a reference for my team.
But okay, so let’s go through and Open the Filters page for the Filtered Data No Params view. Now, if you’re just starting this Filtered Data No Params view, we created in an earlier lesson. Now, you’ll see there’s a whole lot of rows here, right there’s sixteen of them whereas it normally shows just ten and we want to click on Assign Filter Order. Alright, so it looks like this.
Now, we want to use the Move up and Move down buttons to change the order of the filters. So just get past anything that isn’t — like basically, if we don’t have it then don’t worry about it. So the first one we want at the top we’ve got Include Valid Hostname and then we’ve got Exclude, we’ve actually changed my business name. And then we’ve got all out Lowercase ones. So yeah we go all of those and then we’ve got all the spam, so those are all fine. And then we’ve only got two actually, we’ve got Remove All Params and Remove Trailing Slashes.
So with some setups, when they have multiple websites we also have Add Hostname to URL, we have some different bookings and things. So in this case, we don’t have an Appointment Token. Alright, we want to make sure that Remove All Params comes before Remove Trailing Slashes, so let’s just check. Yes, we’ve got Remove All Params and Remove Trailing Slashes.
As it turns out I ended up reordering a lot of the procedures so that it should just work but because we use this procedure for various other setups, we do sometimes end up with different things in there. So now we don’t have a Started Booking and Confirmed Booking, so that’s all good and we make sure that Add Hostname to URL is at the very bottom. We don’t have that one in this setup.
So we are actually all good we don’t need to change anything in this particular one. In fact, I might even remove this from the course altogether although this is probably helpful for you if you’re coming up with other filters so you know all of this. So it looks like we don’t need to actually do anything but I will just check for the other filtered one as well just to make sure because we copied over the filters into this one from the other so let’s just see.
Oh no actually, this is completely out of order in this one. So let’s go through and put them in the correct order. Alright so Include Valid Hostname at the top and then we want the Exclude — now, just to give you a knowledge on this. So you can’t have — actually, let me just explain this order. So no, it is good that it is in the course because there’s a couple of different things in there to know.
First of all, you can’t have more than one Include Filter at the same time because if you — when you have an Include what you’re basically saying is we are only going to have this data and no other data. So if you have an Include that has one condition and then you have a different Include that has a completely different condition and they don’t overlap at all then the second condition can never be included in the first condition and you end up with no data at all. I don’t know if that makes any sense.
So if you have two — well it is possible to have two Includes but it will only include the overlap between them. So if you’ve got like one condition that’s got, let’s say you’re saying Include this IP address and then you’ve got another one where you Include this IP address and they’re different IP addresses, then it will try and include everything in this IP address and then it will try to include everything in that IP address but that won’t be there so it will just delete everything.
But if you have Include that has the ability to overlap then it will take the union between the two Includes. Basically, in any case, having more than one Include will give you odd results that you’re not expecting because you might be thinking it’s going to be including them but what it will actually do is exclude everything else first.
And the way that it works out what to exclude is it’s based on the filter order. So whatever comes first is going to get done first and then all of the data in your Google Analytics will be filtered based on that filter and then it moves to the next one. So I always like to do the Include Filters first because that will get rid of everything else that’s not supposed to be in there and then I like to do like any major Excludes after that so then again we’re filtering the data down. It just means that it needs to run the Lowercase and Spam filters on less data which is faster for the service running at.
Then we’re going to perform changes on the data after doing the Include and Excludes. So after doing the Include and Excludes, we’ll then do all the Lowercase and with these Crawler Spam ones, they are actually Excludes as well. So but with the Lowercase and the Crawler Spam, they don’t need to be in a specific order whereas some of these ones at the bottom do.
So this Remove Trailing Slashes, what we’re doing there is we want to remove the slash at the end of a URL and if we have also a, oh we don’t have it in Filtered Data with Params but in the without parameters, we also have a filter that removes the parameters. Now, it’s really important that we remove the trailing slashes after removing the parameters because if we do it the other way around then you’d end up with a trailing slash after removing the parameters. Hopefully, that makes some sense.
So alright, so we’ve got the Include and then we’ve got the Exclude IP Address and then we just got Lowercase and Spam and then all the other stuff that we don’t have anyway. So Lowercase then — that one’s actually a Lowercase one so I’ll put it with all the others. That one’s a Lowercase one so I’ll put it with all the others. It just helps to organize it a little. Then we’ve got all the Spam and then Remove Trailing Slashes at the end. Alright, Save that.
Now, we won’t have any filters in the — we’ve also got Testing and Unfiltered Data but we don’t have filters on those. Alrighty, Oh, I’ve just got ahead of, oh no, that’s a No Params view. Oh yes, just ended with Repeat for any other views that have filters, so we’ve done it.
So that’s actually a very short procedure but it is very important, especially on this page. This is the one where it’s the most important we need to make sure that in the No Param or this one that we definitely have Trailing Slashes being removed after removing all the parameters. So that’s key in this procedure.
Alrighty, well that was a really quick one. The next one that we are going to go through is Checking Destination Goals to make sure that the filters haven’t broken your goals. Alright, so I’ll go through that in the next lesson.
If you liked this video and want to find the next one, look out for How to Check Your Destination Goals are Working. If you’ve applied the filters I recommended in earlier videos some of your destination goals might need to be fixed. This next lesson will show you how to check whether they are working and then fix them so that you don’t accidentally break your analytics setup when you’re applying filters.