See All Videos

How to Categorize Pages in Data Studio

By Jessica
September 09, 2020

Grouping together similar pages in reports can be beneficial in some cases. Fortunately, users can create a new field in Google Data Studio that allows them to group pages and give each group a descriptive name of their choice. This simple feature can have a huge impact on the quality of your analysis.

View Transcript

Hello, I’m coming to you today from Anvil Analytics and Insights. Today I wanted to talk about and do a quick demonstration on how to group pages together in Google Data Studio. This is really something that can be done for several different dimensions but in this example like I said we are going to use page views. So for example, if we want to analyze the performance of maybe our blog pages versus our solutions pages versus all other pages on our site we can do that. Now if you just look at the pages or at the page dimension in Google Data Studio it’s going to break all of those up so it’s going to be very hard to really compare each one of those groups to each other, what we can do though is go into resources, manage added data sets, we can click Edit here. Make sure it’s blue if it’s not blue you don’t have the required permissions in order to go in and do this. What we can do is come down here and add a field. We’re gonna give the field a name so we’ll do page groupings (blog solutions other). Now in the formula we can go down here and I’ve already created this formula. Basically what you’re gonna do is create a case statement, so for each one of your lines you’re gonna do contains text, all of our blog pages contain backslash blog in the URL so for any one of those pages we’re gonna tell the system to return blog post page and that’s what we can see then in our table. Then for solutions pages, we’re gonna do the exact same thing with backslash solutions backslash. If that’s in the URL, we’re going to spit out solutions pages. If it’s anything else here, we’re just gonna use the else other and then we’ll go ahead and end that. If you have the green check mark down here at the bottom that is how you know that that formula is good and you’re ready to roll. From there you can go ahead and click Save. Then once it’s saved you can click done and close out. Here you’re gonna go add that custom field that you just created just like you would add anything else so we have page groupings. Then honestly we can get rid of this extra page one that we have here, but you can see exactly how many blog page or blog post page views we had total, how many solutions pages we had in total etc. Now we use this a lot because we have a lot of healthcare companies and so for some of their forms on their site they may have a different form for each one of their specialties. Well in Google Analytics, we don’t want to create a different goal for each one of those specialties because there’s more than 20 and we’ll run out of the goals, so what we do a lot of times is capture all those as one goal and then we break those out based on the destination pages in Google Data Studio, so you can see how many people apply for each one of those different specialties. I hope this helps. I hope you can use this in your analytics and your dashboard processes that you guys have created, if so and you want to continue receiving tips and tricks from us, make sure you go to our website and subscribe to our newsletter and give us a like down at the bottom.

Still need help?

About the Author
Jessica joined the Anvil team after earning her degree in Marketing. She really enjoys getting to work on something different every day in her role, whether that’s helping with a Facebook project or solving an issue in Google Analytics. Her problem-solving prowess extends beyond work, too—she loves games and is her family’s pinochle champ.
More from this author
Ready to start a project?
let's work together