In the latest episode of hack, my growth, we take a look at google data studio and how we can use this tool to create meaningful and actionable marketing reports and, as a bonus, i'm going to give you a free template.
You can use to get started right away. There's, a number of options when it comes to creating reports in the marketing realm there's. Lots of tools out there that you can use to inspect your data go deeper with your data, build dashboards scorecards.
The thing is, it can often be very confusing, and a lot of these tools have restrictions things that you can and cannot do now. The cool thing about google data studio is there's, a ton of functionality, it links to tons of different connectors and tools, and it really helps those who don't have really an advanced understanding of data or databases to create meaningful Reports the great thing about google data studio is you can build one report that looks the same across every single page, so, whether you're pulling data from google analytics or search console, or maybe from hubspot or semrush, it can all be formatted in The same way, giving you a really crisp clear: look when you're reporting to clients or other members of your team, so let's.
Take a look at the template that we created and how you can begin to use it today and leverage data studio to create actionable reports. What i'm, looking at right now, is the seo report template that we've built on data studio.
It's, a two page report that a client or user can go through and get some meaningful information from now. This was built, like i said, using google data studio. If you don't have an account, you just go to datastudio.
google.com and sign up or log in with your google id, and it will set you up now right now we're. Just using default information from google themselves as a sample, but, as you can see, we & # 39. Ve got a couple things in this report.
You can add your logo up top here, we've, got channels that we can filter through so social referral, all the different traffic channels. So if you only want to look at organic, you can just click this and actually filter all of the data to organic itself.
We & # 39. Ve also got another filter up here with our time frame. Now, one of the things i really like about data studio is: it gives you a much broader control over your time frame. There's, a lot of tools on the market that don't, allow you to create custom time ranges, and that can be really frustrating.
When you want to see. You know the impact over a year or maybe over two years, and this will allow you to do that as long as you have that data within your google analytics account as we walk down to this report, i'm, going to turn all these On so you can see it all.
We've got the traffic sources section, so this is breaking down all the different sources: the sessions, the new sessions, bounce rate and the pages per session. So we can see how each one of these channels is actually performed and we can compare organic versus other channels now.
This is helpful. If you're an seo, because you can show the impact and the weight that organic has in their overall marketing strategy, when you're, just looking at the gains in organic, it doesn & # 39.
T really put it into context with all of the other channels that that client may be using. So when you can pull this out and say, hey organic is actually driving you. The most traffic organic also has a relatively good page per session rate.
It's, got a lower bounce rate and start to tie some of the story to how organic's. Helping the brand overall. This this uh donut chart over here just shows um. You know the comparative values of each one of these channels and a more visual form.
Sometimes it's easier to see for a client to really see how much more organic is than let's say you know social down below this. We have a top performing content list. We've got page title, the page url itself.
Pageview is the average time and the bounce rate. Now. This is really helpful for content and understanding. What type of content is not just driving traffic, but it's, also engaging users as well. The reason i like to have the page title in here is: we typically have keywords in our page title, so we can use these to go and see how these these pages are performing in search as well.
So if we look, we can see the page view. We can also filter this, though, by average time say, which page do people spend the most time on? Well, if there's only one page view, then it's, not really helpful right, because you know that's.
One person, so we want to look for pages. Maybe that, have you know a lot of views, but also spend time on the site. We can also filter by bounce rate as well, to help give us a better understanding of which pages have a lower bounce rate.
In y, sometimes there & # 39, ll, be a null, and if this is in here, you can actually create a filter to extract or remove the null. So you don't actually see that in the report on page two, it's, the search visibility.
So here we're, pulling in search console both the site and the url data. Now you'll, see when we go to connect this to our own data, and i'll walk you through that you & # 39. Ll have to use two different types of search, console connectors, but again we have the filter up.
Here for the date we don't have the channel filter because it's, a search console, so we're only looking at searches, we've got a graph here that shows impressions and clicks, and then We have a score card that pulls in site ctr and average positions with the rest over here.
If you look at the landing pages section right here, we're, pulling out your top pages or the top pages in search. We'll. Look at the impressions and then the change over that time period. The url clicks the change over that time period, the url ctr and the change over the time period.
Again it helps us to analyze, which pages are performing well. What type of traffic are they getting? Are they generating clicks actually visits to our site? So we really want to see that here now, if we scroll down below a little bit further, we'll, see the queries that we're pulling out and we can look at their average position.
The amount of impressions, the clicks and the ctr that they're getting, and we can also see down here just a graph of our overall average position over time, and this is helpful to track to see. Are you trending in the right direction? Are? Are you increasing your average position? Are you decreasing and you're, starting to earn more visibility for those terms in you know, positions one through ten, so now that we've walked through a little bit of what this report looks like.
How would we use this report? So we would go up here and we would hit this button right here. That says, make a copy. Now, when we make a copy, we're, going to need to hook up our own data sources as you can see it's.
Going to tell you the data sources that are being used in this report and if you go ahead and connect yours in this stage, it will actually allow you to pool all of that in directly without having to go and connect it to the report.
You'll, just do it here and it'll make it look awesome for you right away so to create a new data source. We just go ahead and hit this drop down button and, as you can see, i have some obviously populated in here, because i've.
I've done this a couple times, but i'm, going to go ahead and show you how it works. So we're going to hit, create new data source, and in this case it needs to be google analytics, and i need to find my account.
They've got a great search bar up here. I can find a account here. Select the property select the view that you want and then you hit connect. Google now is connecting this data source. One thing that i really recommend you do up here at the top.
It'll, always say like whatever your view is so i like to actually describe this a little bit better, because you can go back and see all your different data sources in data studio as well. So i like to use the the site title and then what the data source is.
Another thing i like a lot about data studio as you can see it's, pulling in all of the google analytics dimensions when you're using a third-party tool. Sometimes you are limited to the amount of dimensions and metrics.
You can pull in like like tableau depending on the combination. You're limited power. Bi, you're limited some of the other sources. You know you have to kind of pull them in in different buckets. When you use data studio, you can pull them all right in and begin to work with those those reports, click the add to report button, and now that is connected.
The next thing we have to do is we want to do search, console data and, as you see this one says cite - and this one says url - we need both of these connections in order to make this work, we'll, follow the exact same Process as we did before, we'll, create a new data source.
We'll, now find search, console and you go ahead and search your site. Click. The right one and hit connect, and again you'll, want to do search, console search control will give you the domain, but i think you should also add something like site, so you know which type of connection it is and once again we want To do search console - and this time we want to select the url property url impressions and hit connect again just update this, so we know exactly which one we're talking about and hit add to report.
Now we can hit copy this report in google data studio will create a copy, but it will create a copy using our data sets only the data sets we have available so up here. You can re-title your report to you, know the brand you're working with [, Music ] and then make sure everything looks good.
I always like to go through and make sure that everything is working and working the way that it should on both pages up. Here is the other page, and it looks good as you see it,'s a new site, so there's, not a lot going on with this one right now now.
One thing that we we want to be able to do is share this with our client or share internally now, data studio has ramped up their permissions. So when you go to share like a view here - and you share this with a client, you have to make sure that you give them access to this report.
Otherwise they won't, be able to see it. You can't just share the link, so you got to add the people who you want to be able to view, or you can change the manage access here and you can actually allow this for people who have the link right.
So anybody with the link can view it or you can make it open on the web. If you need to as well that's, a really important thing to make sure that your data comes across and people can actually view it.
They're, not just getting a blank page. Any of this stuff is editable, though just so you know in data studio like up here. If you want to change the logo, you can just click on the logo and delete this image file and upload a new one.
If you want to change the filter or the default ranges, you can do that here it's very flexible, allows you to do a number of things like i said before, you can add all different types of data. There's, a ton of different data.
If i go to this add data button, you can see just the native connectors from google, you've got analytics and ads and sheets big queries quite a bit of stuff here that you can attach to then there's. A number of partner connections um, like i said there's there's, one for sem rush.
There's, ones for all different types: super metrics, if you're using them twitter and facebook. So this tool is very uh, very diverse and very large. There's, a ton of different options. There's, a huge amount of people in the partner community who are building different visualizations as well that are not stock or standard within the google data studio setup.
So this report will help you get started, but don't, let it be the only place that you go. You know push yourself, try things break stuff, you know and see how it works. Uh, that's, the best way to learn how to use these programs and get more out of them.
You know and uh. I really like this. You know idea from austin kalani, where you steal, like an artist right, see what other people are doing and leverage that information and create something new of your own, based on what you've learned from them.
So i hope you found this video helpful. If you have any issues with the template or any questions about data studio, we would love to continue that conversation with you. So please comment below and until next time, happy marketing, [, Music ].