Google Data Studio Tutorial (2019) πŸ“Š – How to build a Dashboard with GDS

Google Data Studio is Google’s prime tool to build Data Visualisations. Today, Ahmad of Siavak is going to show us how to make the most of this Analytics tool and build a quick dashboard for us.

πŸ”— Links:

Google Data Studio Tutorial Playlist – https://www.youtube.com/watch?v=R0rV4ZS-ruQ&list=PLgr_8Hk8l4ZGijmrFPjYSeKwLbnsqwq1e

Google Data Studio – https://datastudio.google.com/navigation/reporting

πŸŽ“ Learn more from Measureschool: https://measureschool.com/products

πŸ”€ GTM Copy Paste https://chrome.google.com/webstore/detail/gtm-copy-paste/mhhidgiahbopjapanmbflpkcecpciffa

πŸš€Looking to kick-start your data journey? Hire us: https://measureschool.com/services/

πŸ“š Recommended Measure Books: https://kit.com/Measureschool/recommended-measure-books

πŸ“· Gear we used to produce this video: https://kit.com/Measureschool/measureschool-youtube-gear

πŸ‘ FOLLOW US
Facebook: http://www.facebook.com/measureschool
Twitter: http://www.twitter.com/measureschool
LinkedIn: https://www.linkedin.com/company/measureschool

It’s 2019. And one of the hottest products from the Google Analytics line is probably Google Data Studio. They have improved the tool so much over the last few months and over the last few years that I wanted to update our tutorial on Google Data Studio. Now, I’ve asked Ahmad to come up with a quick overview video on talking you through the most important features of Google Data Studio, how to build a dashboard with it, and go through the general process of creating a dashboard and sharing it out to your stakeholders. Now, this is by no means a complete tutorial. All the features that are out there, and Google Data Studio this will take far too long. But we have a playlist on Google Data Studio where we explain certain features in mode, so check those out as well if you’re interested. But for now, we got lots to cover, so Ahmad take it away.

Thanks, Julian. This is Ahmad from Siavak. And in this video, I’m going to give you a quick overview of Google Data Studio. Data Studio is a free tool from Google that allows you to connect to and pull data from different data sources like Google Analytics, Google Ads, Facebook Ads, or even Google Sheets, and then easily create visual reports to share with your clients, stakeholders and team members. In this video, I’m going to show you many features of Google Data Studio as we create this awesome ecommerce reports together. Exciting, isn’t it? Let’s dive in and see how it works. This is the main interface of Google Data Studio. We can see your previous reports in the middle and at the top, you can choose to start with a template or create a blank report.

We are going to start with creating a blank report. The first thing we need to do is to connect our report to a data source. We can do it by clicking on Create new data source. Google Data Studio can connect to a lot of different data sources. There are free connectors available for Google products, such as Google Ads, Google Analytics, Google Sheets, or even Google Bitquery. And for everything else, we can use partner connectors. Partner connectors allow us to connect to many different data sources like Bing, Facebook, Instagram, Adroll, etc. For the purpose of this tutorial, we’re going to hit cancel. And it starts with the sample Google Analytics data provided with Google. collect data reports, and we are good to go. First things first,let’s give our report a name.

Next, let’s add the header. We started creating a rectangle, resizing it and changing its color. Next, we’re going to add a title. You can select the text, change the color, and change the size of the font, and also resize the widget and move it to better place. Now let’s add some numbers to our reports by adding some scorecards. Score points are good for showing KPIs or key performance indicators. Basically, any number. I’m going to head to is style tab to give our scorecard a border and round the corners. Let’s adjust the padding as well. And then I’m going to head over to the data and enable the date range comparison. So I’m going to compare this metric to the previous period. And here he appears. Now that we are happy with the scorecards, we can duplicate and create more. This retains the styling and the configuration for the date. The only thing we need to do is to change the metric. For this one, let’s choose transactions. We can drag it over to replace the metric. Or we can continue this process to make more scorecards. For this, I’d like to have product detail list. Drag and drop, and we’re done. Next one is a revenue.

And I’m going to change this one to show a compact number. Next up average order value. So as you can see, I can just type in here to search for all the metrics that are available in my data set. It’s a drag and drop them to the left to change the metric. Now let’s create some room for our final metric which is ecommerce conversion rate. I’m using my keyboard to move the scorecards around. And I can even control C and control V on my keyboard to copy and paste and create a new ecommerce. Now let’s see from which countries are we getting our revenue from. For this purpose, I’m going to add a map to the report. Now each shade represent the number of sessions, but we’d like to replace it with revenue. See which country bringing more revenue to our commerce store. And just to make it clear for the end user that what metric is being represented by this graph. Let’s add a title and call it revenue by country. Next, let’s see some trends. By adding a time series charts to our report. Just like the scorecards above, I’m going to give it a border and also change the radius for the corners. Let’s decide what numbers do we want to show on this chart. I’m going to head over to the Data tab and search for some metrics. I want sessions to be either, but they also want to see product detail we use product adds to cart and transactions.

Let’s duplicate this and create another chart for revenue. Right click and select Duplicate. Ok. So now I’m going to remove the metrics and replace the final one because I’d like to see the trend of revenue over time. But for this chart, I’d like to see how revenue builds up over time during this time period. Now if you’re going to duplicate this and create not a chart to show e-commerce conversion rates over time. I’m using my keyword to move this around. Just like before, you can head over to the Data tab, search for metric and replace the metric on the chart by dragging dropping the new metric over the previous one. For this one, however, I don’t want it to be cumulative. So uncheck this but I do like to see a trend line. Cool, isn’t it. Now let’s add a pie chart. To see the distribution between male and female users. Drag it over here choose gender as the dimension for this pie chart, and we can leave the metric to be the number of sessions. I’m going to head over to style tab. But I want to move the legend over the top just to make some room for the next visualization we want to create.

Now let’s use this space to create another chart and see which cities are we getting the most revenue from. For this purpose. let’s choose the bar chart, the horizontal bar chart. Move it here, resize it to fit, adjust the size to make room for the name of the cities, changed the metric to revenue. Premium sessions and change a dimension to city. Our ultimate commerce reports is almost finished. Let’s see how does it look for the end user. Looks nice, doesn’t it. But there is a problem. This report is a static and the user cannot interact with it. They cannot choose the time period or take a look at different segments of data. So let’s go back to edit mode and add some features and interactivity to this report. The first thing we’re going to do is to allow the end user to change the time period after report. And this is done by adding a date control filter just like this. Going to head over to this time tab and change some colors to make it visible. Now, the reviewer of the report can easily choose the timeframe for which they want to look at this report just like this. Now let’s go back to edit mode and add some more cool features to this report. I’m going to select these all, bring them down to make some room for the extra features we’re going to add.

First, we’re going to add a drop down menu that allows users to take a look at traffic from different source mediums. This is done by adding a filter control to report. By default it sets to medium as its dimension, we’re going to change it to source medium. Again, we’re simply dragging and dropping. Next, I’m going to duplicate this. Create another one for device category, which basically means desktop, mobile or tablet and allows them to look at traffic only from desktop devices, the tablets or mobiles. And finally, I’m going to duplicate again and allow the end user to filter my user time. Which basically means is that the new user or a returning users. Now let’s review our report again and see how does it look. Now it’s possible for the end user to filter this report base on any of these criteria. For example, they can choose to only look at desktop traffic. And all the numbers and charts will be updated to reflect the choice.

Now that we created this ultimate ecommerce report together, it is time to share it with others. Let’s take a look at different sharing options we have access to in Data Studio. The first option is to download the report as a PDF form. And we can even protect it with a password. The next option is to set up automatic delivery of the report via email. So Data Studio, emails a PDF version of this report to the email addresses that you choose on a daily, weekly or monthly basis. We can simply create a link to this report. Or we can share it with other people, just like any other Google Drive document. Just like a Google doc or Google Sheet, you can get a shareable link, or you can share this report with the specific emails. So as you can see, there are lots of options for you to share a report with the people who need to review it. Okay, I hope you’ve enjoyed today’s video, in which we learned how to use Google Data Studio to connect to a data source and create a beautiful, interactive and fully functional report and share it with others in about 15 minutes. I’m going to post a link to this report in the descriptions. So you can review it and grab a copy for yourself to play around with. To make a copy of the report inside your own Google Data Studio account, simply click on this little icon. That’s it for today. Thanks for watching.

All right, so there you have it. This is a quick overview on Google Data Studio, how you can use it and hopefully you know now if you should use it for building your dashboard. It’s pretty easy actually. But there are some quirks of it. So I also encourage you to check out our playlist which I’ve linked up right over there which will show you a few more details of Data Studio and a few more specific details on how you can utilize the tool for effective dashboard building. And as always, if you haven’t yet, consider subscribing right over there to our channel because we bring you new videos just like this one every week. Now my name is Julian. See in the next one.

SHOW MORE...

Leave a Comment

avatar
 
smilegrinwinkmrgreenneutraltwistedarrowshockunamusedcooleviloopsrazzrollcryeeklolmadsadexclamationquestionideahmmbegwhewchucklesillyenvyshutmouth