Data Filter Control Introduction
hi I’m Chris and thanks for joining me here for another video at Digital Metrics Guru. The other day I received a question around the data filtering option that’s available within Google Data Studio.
The question was basically how can I limit what people are able to choose within the data filter control option so the filtering option allows you to see the same data that you have set up in Data Studio but in different views, or even different web properties from Google Analytics?
So I’m going to answer that question today. It’s actually something you don’t take care of right inside Google Data Studio. You do it within Google Analytics. So let’s get right into it.
Applying Filtering in Data Studio
So I’m over here in Google Data studio. I have a pretty simple, straightforward dashboard set up here. We’re looking at traffic, where it’s coming from, and some activity overall on the blog. So what you’ll notice up here is this right here is what is called data filtering option within Google Data Studio.
If I go into edit I’ll show you right where there is the Data Studio filter control is right here on the right. It is a fairly new addition to Google Data Studio, the data filter control here on the left you would just select it and click and drag wherever you want. I’m going to go and show you what’s available within there.
If you click on it you’ll see there’s a connector type. Obviously right now there’s a Google Analytics connector. You also have AdWords, Google Search Console, YouTube, Double Click, Attribution 360, and Double Click for Publishers. It’s all limited to Google products, which makes sense since they can control what you’re seeing. Maybe they’ll expand the data filter control in the future, but probably stick to those core products.
I have Google Analytics selected, obviously it’s already connected to all the data that I have through my email address. The data filter control is like the date selector in how you can select things. I’m going to go back to view and I’m then going to show you what it allows you to do.
Now, on the surface you may not find this really really helpful but there are a lot of people that have used this a lot. I’m not one that uses it too much as most of the reports I create are a lot different from one another. I’m using different data different kinds of data but typically on a very high-level report where you’re looking at traffic sources and overall conversion this would work very well. You can view different things across different clients and across different parts of your business without creating new reports.
Right now it’s selected the default data for this dashboard. This report has a default data source and that’s what it’s pulling from. But right now I’m going to actually select this drop down and you’ll see everything I have access to. It’s the Digital Metrics Guru test, then master, and a couple things of development with user ID, etc.
Selecting a New View
Then down here I have a Digital Metrics Guru Demo account which is the account used with these videos. So I can actually go ahead this isn’t going to show much data at all but I’m going to go ahead and select the master from Digital Metrics Guru demo. In a flash it changes everything up. It now shows all of the same widgets, graphs, and charts that I had before but with a completely different data set.
This is great and you saw how quick that was which really makes it a very powerful tool. So the question that came in however was I don’t want certain people, when they go in to Google Data Studio to see everything that I’m I’m able to see. The great thing is that this isn’t something that’s handled in Data Studio at all, it’s actually handled in Google Analytics. You will only see what you have access to.
So I have another account that has access to everything in the master Digital Metrics Guru but not in the demo account. To see how that works I’m going go to go over and selected a new account. It’s a little bit different instead of the Digital Metrics Guru email address I have Outlook email address there as well. So I come in here and by default I see exactly what we’re seeing in the master view.
When I go and select the data filter control, now all I have access to are the Digital Metrics Guru master, development, and user ID views that we’ve talked about before. There is no demo account.
User Management in Google Analytics
So it’s as simple as that. You really don’t have to do anything in Google Data Studio. What you do is within Google Analytics, I said I had two separate counts here Digital Metrics Guru and then demo. If I go in to user management in Digital Metrics Guru, you’ll see that both email addresses are listed but if I go over to the demo account, only “@digitalmetrics.guru” email is
It’s as simple as adding and taking away access within Google Analytics. Right in the user management you can add, delete, and filter out people from all of those that have access. So that is actually what controls everything within Google Data Studio. It’s as simple as that.
Hopefully this is helpful and allows you to use the data filter control in Google Data Studio more freely. This can help to open up your clients and other areas within your business to faster dashboard consumption. I hope you found this video helpful.