Google Data Studio Tutorial for Beginners

hey there i'm benjamin from love starter in this video i'm going to show you how to get started with google data studio this is my google data studio tutorial for beginners we're going to cover the steps you need to follow to create your very first report we'll look at how to connect a data source to use in your report we'll explore the different ways you can visualize your data for your reports and dashboards and we'll also look at how you can begin to customize and style your reports let's get started [Music] okay so Google data studio lets you present data using a range of visualization options you can use it to create dashboards multi-page reports and more you can also connect different data sources to build your dashboards and reports today we're going to connect Google Analytics but as we'll see there are different options you can use depending on the data you want to use you can find Google Data studio by heading to data studio google.com and we can see here that we're presented with some templates at the top along with recent reports and dashboards we've created let's click create we can see there are options to create a report a data source and an explorer let's select the option to create a report the first thing we need to do is add a data source to our report to do this we need to use a connector this is simply the way we get data into our report we can see that all of the Google connectors are listed first this includes the connectors for Google Analytics Google Ads Google sheets and more scrolling down you can find connectors from other partners this includes a range of connectors from super metrics and other third parties you can use these if there isn't a Google connector available for example if you wanted to include data from Facebook or LinkedIn you would need to use one of these connectors since Google doesn't provide inbuilt connectors for these platforms at the very bottom you'll find open source connectors which are also called community connectors you can search for connectors and you can also select my data sources to use data sources that you have previously connected to other reports I'm going to select Google Analytics as the connector for this report we can then select the Google Analytics account the property and the reporting view we want to use for our report for this example I'm going to make use of the Google Analytics demo account but of course you should use your own Google Analytics reporting view or other data source when you create your own report once we're happy we just need to click Add and then add to report we can see that a table is automatically added to our report and we're looking at the report canvas which is where we build our report across the top of the window we have a range of options for example we can select insert or add a chart to add visualizations to our report since the table is selected we can modify this chart using the panel on the right hand side we can see that the data tab is currently selected this lets us view the data source for the visualization and change the dimensions and metrics used for the visualization there are also a range of other options that give you additional control over what is included or excluded from the chart we're going to create a dashboard that shows us how people are finding our website it's going to include various elements from the Google Analytics acquisition reports let's start by changing the dimension from medium to marketing channels to do this we can click on the current dimension and then search for default channel grouping and select our new dimension we can then see the table updates let's add another metric to our report we can either pull a metric from the column on the right or we can click add metric and then search for the metric we want to add I'm going to search for goal conversion rate and add this to the chart you we can now see the table shows us the different marketing channels sending people to our website the number of sessions for each channel and the goal conversion rate now let's customize how the metrics are presented to do this we need to make sure we have the chart selected and then we need to select the style tab you'll find a range of options for customizing your chart for this example I want to customize the way the metrics are displayed so I'm going to scroll down and look for column 1 then I'm going to select number and change this to bar we can see our chart updates to show a visual comparison for the metric now let's select show number so that we can see the metric included in the table we now have the metric along with a simple visualization okay now let's repeat this for the second metric we need to look for column two and then change number to bar and enable show number that's it now we're going to copy this table to present other data in our dashboard to do this you can use the keyboard shortcuts on your computer or you can select edit then copy and then paste I'm going to modify this table to show all of the referring websites that are sending traffic to our site to do this I'm going to change the dimension so let's select default channel grouping and change this to source now we can see that this does include some referring sites but it also includes other traffic this means we need to apply a filter to the chart to only include referrals there are a couple of ways we can do this we can create a filter inside Google Data studio or we can apply a segment from Google Analytics for this example I'm going to apply a segment to the chart so let's select add a segment we can then choose system segments and select referral traffic that's it we can now say our table is updated to only include referral traffic now we're going to copy our table again we're going to use this table to present the custom campaigns we are tracking into Google Analytics for example our email campaigns and other custom inbound marketing to do this we're going to change the dimension let's select source and change this to campaign now we can see that the first row is not set this is for all of the traffic that isn't being classified as a campaign we'll need to filter this out since there isn't a default segment for campaigns you could head to Google Analytics create a custom segment and then apply that custom segment like we did for the referral table however this time I want to show you how you can use a filter to customize what's included in a chart let's select add a filter let's name the filter exclude unknown campaigns and will change include to exclude now we need to search for campaign then select equal to and enter opening bracket not set closing bracket as the value now let's click Save that's it we can see our table is updated and the first row that previously said not set has been removed let's copy our table again you we're going to use this table to present a list of paid keywords from our Google ads campaigns to do this we need to change the dimension let's select campaign and change this to keyword we can see that the table includes not provided which is for our organic keywords and we can also see not set we will want to remove these from the table so let's add a segment let's select add a segment and then let's select the paid traffic segment we can see this as cleaned up the table but we're still seeing some sessions for not set we can reuse the filter we created for our campaign table and apply it to our paid keyword table so let's select add a filter and add the filter we previously created that's it we now have a table that only includes the paid keywords that are sending people to our website now let's add one more visualization to our report I want to add a stacked bar chart that shows the overall trend for our top five marketing channels to do this let's select add a chart and choose the stacked column chart option we can see that the chart is showing us different traffic sources but I want to see the trend for the date range so we'll need to modify the chart let's start by changing the dimension from medium to date you now we can see that the dates aren't in order so let's change the sort from sessions and change this to date and then we need to select ascending ok so now we can see the dates in order but I want to view more days so let's select the style tab and change the number of bars from 10 to 29 now the chart includes a lot of information and I only want to see the top 5 marketing channels so let's change the series from 10 to 5 finally we need to change the dimension because the chart is showing us the traffic sources and I want to see marketing channels to do this let's select the data tab and change the breakdown dimension from source to default channel grouping that's it we can now see the overall trend for our top five marketing channels and a daily breakdown before we wrap up I want to show you two more things as you begin using Google Data studio first you can adjust the names of dimensions and metrics used in your reports to do this select a chart you can then hover over the metric or dimension you want rename and click on the Edit icon I can now rename the dimension let's name this one referrals and let's also repeat this for my paid keyword table let's change keyword to paid keywords okay finally let's take a look at the default themes available in Google Data studio these allow you to quickly change the style of your report or dashboard to change the theme just click on the canvas so you don't have a chart selected we can now see the default themes that are available this is a quick way to adjust the overall style of your reports that's it we've created a dashboard to understand how people are finding our website using data from Google Analytics [Music] so that's how you can get started with Google data studio before we wrap up this video let's briefly recap on the steps we followed to create our report we started by heading to Google Data studio we connected a data source to use in our report now you actually have the option of connecting multiple data sources to use in your reports and this is something I will cover in my next video once we connect our data source we can then add visualizations to our report and we can then customize what's included and excluded from our report in Google Data studio that's it please take a moment to check out the extra resources below this video how are you using Google Data studio do you have any tips you'd like to add let me know in the comments below and if you found this video helpful please subscribe share it with your friends and hit the like button so I know to make more videos like this see you next time

Channel: Loves Data

Views: 106,176

Keywords:

Id: FkxaBRiXlVc

Length: 14min 8sec (848 seconds)

Published: Mon Mar 23 2020