Amazing Google Analytics Dashboards Using Data Studio

if you're using google analytics without data studio you need to stop now and fix it my name is tanya zapkina and i've been working in marketing analytics for over 15 years in this video i will show you how to create your own amazing dashboard for your website using google data studio and i will even share my own template with you you will be able to customize your reports and see what an amazing product google data studio is keep on watching let's start with google data studio i have my test account in here and i have given it an access to my own website's google analytics data so now i'm going to go in here and i'm going to type data studio dot google.com and that's it so this is what you get when you first log on into google data studio and this is a place where you can create dashboards and reports based on any data not just google analytics data this is similar to tableau if you have ever used that because it sits on top of a database and it's a reporting environment it's where you can create tables and charts based on the underlying data so let's get started we're going to click on blank report in here let's just create a report and our environment is asking us to add data and this is the the type of data that you can use with data studio there's a lot of data sources but google analytics is number one and for a reason we're gonna choose our data okay it's going to appear as all website data add to report that's it we have connected our data and we have our first table in the report if you have gotten to this point in this presentation you're going to be able to do your own report from here now let's go over the parts of the data studio report first of all there is a report itself and report has report settings and the settings are of course a data source now we've added this data source to this table but not the report itself what i can go in here and i can see added data sources so this report has this one data source added and i can edit in here the other option that it has is the date range and there's autodate range and there's a custom date range and that applies as a default to the whole report to every t new table that you add in every table however you can change the default into something else there's also a filter so a filter allows you to filter the whole report for something for example you can have a report on organic search traffic only and that would just limit the whole report to that another thing that it has and it's not populating right now because i do not have custom analysis segments is the google analysis segment so google analysis segments is something that you can create in google analytics in under the administration panel it's right here in the administration panel in the view you can click on personal tools and assets and create a segment which would be accessible from your data studio isn't that amazing so now let's go to the current page settings so report consists of pages and you can add another page over here let's add another page there's a second page now we can switch between between pages one and two in here and we can rename it right here so in the current page settings again we have the default data source we have the date range we have the filter and we have the segment okay um the segments stop running so we can quicken here there are preset segments in here you can do organic traffic as a segment or as a filter depending how you want to do it you have three types of things that you can add number one is the chart see in here add a chart and there's all sorts of different types of charts and once you've added the chart let's say you have this table and you want to change it you click on it and on the right side right here you have this menu where you can potentially change settings new users page views broken down by something you can do this this is my website datum do this and under this menu of chart you have the data let's talk about the data the data consists of on the left side there's a data source and you can add another data source join it in and blend the data if you want to that's an advanced option you have dimensions and metrics and you can see that dimensions are kind of in green and metrics are in blue blue are things that are numeric things that you can sum up average into things with them these are your metrics users sessions page views balance rates things like that and then dimensions are categorical breakdowns in this particular case it's page title but it could be a country it could be channel or any of the green ones in here down here again we have the default date range we have a filter option for that particular table so for example i can have a breakdown of countries for one channel versus the other and have them side by side um very helpful if you want to do breakdowns for certain pages you can have a breakdown of channels for one page and then for another next to each other in the same report in data studio you can have these charts side by side and again you have a segment and there's minor options like how you want to sort things and how many for tables how many rows you want to show so that's that's our chart the next one is controls controls are things that you kind of can change in the view view right here right in the upper corner when you look at the report you can change the dates of the report they control the data in your charts and most of them apply for the whole page but sometimes they would apply to a particular chart and other than that you have your design elements and design elements are text images lines rectangles or circles but you also have the themes over here where you can go through and change overall colors and on top of that let's add a rectangle in here you have all the options associated with the style for that and then let's add some text in here you have all of the options associated with the text itself now let's go from edit mode into the view mode that's how it's going to look like in the view mode one of the best options that you can choose is this you can download data for any table or chart onto your computer and that is great because that is an additional analytical option that you can use for further analysis some of that data in google analytics is a little bit tricky to produce but you can produce it here download it do additional analysis with it now there's something missing in here there's something that you don't know about this chart and that is what kind of period of time does it cover we've seen the default date range but we've never seen what it was right so when you create a default report it doesn't tell you what dates are and so the number one thing that you need to remember is add a control date range control and then you click on it over here unfortunately same thing happens here it doesn't tell you what the dates are go back to edit go into here and then click and say i want to have quarter to date yeah so if you go into into this setting and choose your date range then you're gonna see that the dates appear and now when you view guess what you know the date range you have to know the date range otherwise it's not very helpful to have the report at all so another basic basic of good reporting is that you may want to look at your numbers in comparison right now you can kind of see what the number one page is but it's not it's not really clear if that's good or bad or what's going on with these pages over time so what i'm going to do is i'm going to go into this chart and i'm going to change it into this into the line chart which makes it even more confusing but i am going to take out the page title and so this is since the beginning of the year this is the new users and right here i can add a comparison comparison date range and here i can do previous period i can do previous year or some other option i prefer either previous period which is the same number of days but prior to our shown period and previous year is always good so now you can tell that the new users traffic has grown so you've created the report you've saved it just click on here just like any other google product sample report and how do you share it there's a lot of share options and this is another great thing about data studio you can download the report as pdf you can get the report link and share it with somebody or invite people to view it you can share it with somebody in your organization somebody who has access to the data i also would like to show you that in here you need to add sharing options you can tweak that with the sharing you can also do email where basically a snapshot of the report a picture would be shared with people on a certain date and you can schedule it and download as pdf is a great option because this way you don't have to give people access to the report or the data you can just download the report and email it but the best one is you can take a template from anybody on the internet that created a report for google analytics including meme and you can apply to your own data you just can put on your on top of your data and it's going to work because google analytics is fairly standardized so now i'm going to share with you this report as a template and i have my link over here so i'm going to go into another account and i'm just putting the link in here this is a dashboard template and right now it's using sample data what you can do is you can make a copy of that particular template into your data studio and it says sample google analytics data so to get your own data into this report you just click here i am not seeing my google data that's that's fine create a data source google analytics choose your view you click connect and then the magic happens to report there is a copy of my own dashboard for you with your own website data if you like this video give a thumbs up i hope you found it helpful

Channel: Probabilistically

Views: 2,502

Rating: 4.7692308 out of 5

Keywords: google analytics, website report, google data studio, data studio, bi solutions, bi reports, website dashboard, data studio report, google analytics report, google analytics dashboard, GA dashpoard, GA report, site traffic report

Id: xtmu-qU-C8c

Length: 15min 36sec (936 seconds)

Published: Thu May 20 2021