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

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

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.

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

  1. Please reply, is it possible without sharing it gets refresh automatically in my manager laptop and updates whatever changes I have done it.

  2. awesome videos! thanks! I have just one question, I would like to connect my DB (MySQL) to the Google Data Studio, do you know what is the best way or method to do it? I donΒ΄t know if I have to use a partner connector and which one to use

  3. No doubt the most useful, concise and well articulated 11mins of learning for my business this week. Thanks SO much!

  4. Great tutorial! I followed your example using data from Google's merchandise store: https://support.google.com/analytics/answer/6367342?hl=en

  5. Great explanation! Have a question – is it possible to build a chart NOT affected by filter? I would like to build a chart showing overall avg. data so we can compare the filtered data with all website data. For comparison purpose, I also wanna know whether Data Studio provide comparison function beyond date range comparison.

Leave a Reply

Your email address will not be published. Required fields are marked *