Transcripts
1. Intro and Project Overview: Hi there, My name
is machine hours. And on this course
I'm going to show you how to use Google Data Studio, which is now known as
googled Lukert Studio, to create your first
interactive dashboard. Look, your studio is a very powerful but
user-friendly tool that allows you to create
interactive dashboards that can be easily
shared with your team. Came to very helpful to get an overview of how
your website is doing and also to improve
visibility of your work. So let's get started. This is the part that we're
going to create together on this course, has two pages. The first one is an overview
where you can select the range to SI sessions by
channel or get an extension, month essentials by device and sessions by
province or state. The best part is that you're gonna do this using
our own data. The second page is a simple
date range comparison. On this case, I'm comparing
sessions from Q4, 2022 versus Q3 2022. After you're done
creating a dashboard, make sure to create a project, to share your work
with your classmates, and also to get
feedback from me. You can create a project by
clicking on Create Project, a bloated screenshot from your
dashboard, adding a title, description and even a link
to the live dashboards. Dashboard includes data that you don't want to
share with others. Makes sure to click, Make this project private.
2. Using a sample dashboard: To get started, go to
lookers studio.google.com. You might have to login if
you're not logged in yet. And you will see the templates that are
currently available. You'll have a blank
report after report, and choose sample dashboards. Let's start by looking at the Acme marketing
simple dashboard. This dashboard gives a
pretty good overview of the capabilities
of looker stadium. So you can see here e.g. users sessions and bounce rate. And this is data from
Google Analytics. This is comparison data with the against the
previous period. Here's a chart about how
sessions are training. And here is a map with
sessions per country. You can see which
channels are driving engagement and also
engagement by age and gender. Actually the gender
charged right now, it's not working on
the sample report, but it's pretty similar to
the distribution here by age. You can also use
this button here. Use my own data to duplicate
this dashboard and create a dashboard using
our own data rather than the sample
data from Google.
3. Connecting Google Analytics: Now let's create
our first report from scratch to do that, returned to the main page, lookers studio.google.com
and click on Blank Report. The first thing we're
gonna do is connect our lookers teacher dashboard
with Google Analytics. So to do that, just click on the session
Google connectors. Click Google Analytics. And you will have to authorize Lukert studio to access
your Google Analytics data. To do that, just
click Authorize. And you can select which
account you want to use. Here I have simple accounts
from my own websites. But for the purpose
of this course, I'm going to use
the demo account, which is Google cent, which is sample data
directly from Google. And then just click, Add and Add to Report. Let's say your Google
Analytics account is now connected to your
lookers studio dashboard.
4. Selecting a date range: The first thing I like
to do when creating a new lookers pseudo dashboard
is adding a date range because this means that each
range will be applied to all the charts and
tables are on this page, unclass you want otherwise. So to do that, Let's
start by deleting this simple table here and
clicking on add a control. And date range control. Just dragged and dropped. And now you can change the auto date range here to
the date range that you want. For this dashboard, I'm going to create tables using data from 2022 to let select the
whole year starting on January 1st and ending on
December 31st. And apply. Now Aldi and now
all the charts and tables on this page will
reflect this date range.
5. Creating your first chart: Now let's create
our first chart. A pretty standard chart
that is helpful for most businesses is a chart
showing sessions by channel. So let's do that. You start by clicking Insert and time series chart,
then drag-and-drop. Now this chart is showing views. This is not exactly
what we want. Let's go to the right here
where you see metric, click views and
search for sessions. Voila, now we can see
this sessions for 2022, but you want something
slightly different. We want sessions by channel. So to do that, we need to
add a breakdown dimension. So you click here and
you search by channel. This chart is a little
bit busy right now. It might be more helpful to group these sessions by month. To do that, you go to dimension, date and click right
on the pencil here. Type date, click date and time. And change here for year, month. You can also select different time periods if
that's more helpful for you. Thanks. Year, quarter,
or even week. Now we are seeing sessions here. By each month. That is a more clean chart that might be more
helpful for you.
6. Using filters: Say that you want to
keep a closer eye on organic search because SEO
is very important for you. So let's copy and paste this
trout that you already have by going to Edit,
Copy, Edit, paste. Or you can always
use some shortcuts from your keyboards such as
Control C and Control V, or Command C and Command
V. If you're on a Mac, you can see here that this
chart is overflowing. So let's reduce both strikes. You can select more
than one child at a time by just
clicking and dragging. And now let's reduce
both chunks at a time. Both tracks at the same time, and aligning them on
the center of the page. Let's click on our new chart, removing our
breakdown dimension. Now let's add a filter for
organic traffic to the debt. Let's scroll down and
click on add a filter. Let's include select field. Let's search for channel. Select a condition. Let's click on Contains
organic search and save it as not working because it's
not showing any data. Let's find out why that is. So let's click on the chart. Let's scroll down and
click on Edit Filter. Oh, it looks like we forgot
to capitalize organic search. You can see here on our left chart that organic
search is capitalized, and that's how Google Analytics writes our dimensions and the parking that we match exactly how Google Analytics for rights on
different dimensions. So in this case, we need to
capitalize organic search. You can use contains here or
you can also use equal to. Because in this case, we're matching our
filter exactly to how the Google Analytics
metric is written. Now it is working.
7. Creating a pie chart: Now let's say that
you wanted to create a chart to check if most of your visitors are
coming from desktop or mobile. To do that, let's
create a pie chart. Go to Insert and Chart. Click and drag. And let's just make sure that
the Chinese are aligned. Then we go here to
dimension inches device category. And that's it. Here we can see the 93.7% of the traffic to our website is
coming from mobile.
8. Creating a map: Finally, let's create a
map so we can see from each state or country most of
our users are coming from. So if we go to Insert, and in this case we're
going to use the GI tract. Let's resize. This map is already showing
sessions by country. So if we want to change that, we can go here and
select a region. And the default region
is the United States, but can also change the zoom area here to
show different countries. So let's say that we
want to show candidate. So we're seeing here sessions
by province in Canada.
9. Using labels: It's important to
label your report and all your charts
so stake holders can know what data is being shown and where
data is coming from. So let's insert this tried to
prevent and the ego is the sessions by channel. We can select the font size, color, and font time. Though. We want to
copy and paste. Labeled this chart as organic
sessions five months, and labeled the bottom
charts as well. Sessions by device. And sessions by. This makes our report
a lot more organized. You can also add a main label. Your whole report. Let's say my website overview. Perhaps you want to choose
a bigger font size in bold.
10. Comparing date ranges: The last thing I wanted
to show you is how to compare different date ranges. To do that, I just
created a new page and duplicated the organic
sessions chart that we created before. You can click on the chart. So let's say that I want to do a quarterly analysis comparing the last quarter of 2022 with
the third quarter of 2022. To do that, let's probe
down to date range. Custom select October
1st to December 31st. There's a comparison date range. Let's choose previous period, which is July 1st
to September 30th. Apply. In this triad is
a little bit simple, so you might want to change
it for a weekly view instead. So let's go to data
and time ear wick. This shows trains for the last quarter of 2022 with the third part
of this same ear.
11. Naming and sharing: Make sure to label your report all your pages before sharing. So you can click
here to select all. But summing this
as my first part. Let's also rename our pages. This one, name it as q4 versus Q3 2020 to close. And now this dashboard is ready to be filled and share
it with whoever you want. To do that you can just click, Share and select whoever you want to share
your dashboard with.
12. Ending: You should now have
your first dashboard ready to be used and shared. But don't stop there. There's so much more
than Lucas tutor can do. You can connect
other sources like Google Search Console and change fonts and colors to better
align with your brand. Thanks so much for
watching. Bye.
Mathias Neves
