Google Data Studio - Build Beautiful Digital Marketing Reports For Free | James Foster | Skillshare

Playback Speed


  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x

Google Data Studio - Build Beautiful Digital Marketing Reports For Free

teacher avatar James Foster, Digital Marketer

Watch this class and thousands more

Get unlimited access to every class
Taught by industry leaders & working professionals
Topics include illustration, design, photography, and more

Watch this class and thousands more

Get unlimited access to every class
Taught by industry leaders & working professionals
Topics include illustration, design, photography, and more

Lessons in This Class

10 Lessons (30m)
    • 1. Introduction

      1:15
    • 2. Class Project

      0:45
    • 3. What is Google Data Studio?

      0:59
    • 4. Getting Started With A New Report

      3:42
    • 5. Scorecards

      4:46
    • 6. Time Series Graphs

      2:55
    • 7. Tables

      5:50
    • 8. Pie Charts

      4:43
    • 9. Filters

      4:11
    • 10. Class Re Cap

      1:21
  • --
  • Beginner level
  • Intermediate level
  • Advanced level
  • All levels
  • Beg/Int level
  • Int/Adv level

Community Generated

The level is determined by a majority opinion of students who have reviewed this class. The teacher's recommendation is shown until at least 5 student responses are collected.

116

Students

--

Projects

About This Class

In this class, I am going to teach you how to use Google Data Studio to build beautiful and insightful digital marketing reports for your company and your clients.

Google Data Studio is a free tool that allows you to integrate all of your digital marketing channels into one cohesive, always up-to-date report. Using data visualisation to see key metrics at a glance whilst also providing significantly insightful information that is easy to digest. 

This class is for any digital marketer that wants to easily understand their digital marketing performance whilst gaining insightful information that may have otherwise been overlooked. The lessons learned in this class can also have a benefit if you’re a freelancer or work in an agency and receive frequent questions from clients - in most cases, your new Google Data Studio report will answer these questions for you.

The skills learned in this class will allow you to gain more transparency on your digital marketing activities and once learned, can be used over and over again. Freelancers and agency workers will find significant benefit out of learning this skill and will be able to re-produce high-quality reports for all of their clients with ease. The more you use Google DataStudio, the more you will learn, I almost always learn something new every time I use the tool, even if this just a keyboard shortcut that saves a few clicks.

Applying the skills learned in this class is extremely simple, all you will need are the following:

  • Laptop / Computer
  • Web browser (I’d recommend Google Chrome)
  • Google account
  • Access to your company’s / clients’ digital marketing accounts (Google Analytics, Google Ads etc)

Meet Your Teacher

Teacher Profile Image

James Foster

Digital Marketer

Teacher

Hello there,

I'm James. I'm a digital marketer based in the UK. I mainly focus on Pay Per Click (PPC) advertising through Google Ads & Microsoft Advertising.

I spend most of my free time trying to learn new skills or experimenting with new digital marketing avenues to further develop my skill set. 

I am working on a range of Skillshare classes to share the skills I have learned throughout my time working in digital marketing to help fellow digital marketers out there.

I hope you find my content useful! If you have any questions or have any requests for me then please drop me a message or email and I'll see what I can do.

See full profile

Class Ratings

Expectations Met?
  • Exceeded!
    0%
  • Yes
    0%
  • Somewhat
    0%
  • Not really
    0%
Reviews Archive

In October 2018, we updated our review system to improve the way we collect feedback. Below are the reviews written before that update.

Why Join Skillshare?

Take award-winning Skillshare Original Classes

Each class has short lessons, hands-on projects

Your membership supports Skillshare teachers

Learn From Anywhere

Take classes on the go with the Skillshare app. Stream or download to watch on the plane, the subway, or wherever you learn best.

Transcripts

1. Introduction: Hi, I'm James. I'm additional marketer based in the UK Focus Manual Pay Search on Google Ads. In this class, I'll be teaching you how to create easy to digest and insightful dish remarks in reports like the one below for free using Google into studio in the class, we'll be covering what Cooper Date studio is over given over the other tool. What it is useful. How to get started with the new report connecting data sources such as Google ads and Google Analytics. And how to use design elements within the tool to format. The report. How you would like scorecards allowing you to keep in our key metrics at a quick glance. Time series graphs allowing to see specific metrics over a given date range table was allowed. Just get a more in depth look at your marketing activities to identify campaigns are performing well on ones that could do some work. Pie charts What we're creating a device breakdown using pie charts allowing to see which devices used harvesting our website from on how their behavior varies based on the device filters, allowing us to create reports based on different traffic sources, such as organic traffic or paid traffic, and I was showing some tips and tricks that I've learned for used validate studio that have allowed me to save some time increasing reports. I look forward to seeing you in the class. 2. Class Project: Hello. Welcome to the class will start going over the class project, which is to correct the Google data Studio reports. I've chosen this project as it will allow you to take skills. You flight in the class and apply them to a real world scenario before diving into the main . Listen to this class. I would recommend you set up your own reports. You're ready to start personal skills into action, but recovery, how to do this in the next lesson? To complete the project, we need to have access to a Google Analytics account. If you do not have access to one, you can use the Google Merchandise Store demo account to experiment with. I've included a link in the project description, which explains how you can gain access to this. I would recommend you for the project through the class and implement each of the lessons learned at the end of that lesson before proceeding on. As this will keep the skills fresh in your mind. However, it's entirely up to you how you complete the project. I look forward to seeing the project you create 3. What is Google Data Studio?: Hello. In this lesson, it were recovering. What good would a tissue is on what it is useful. Google Data Shooter is a tool provided by Google. Allow me to pull through a data for more your various marks and activities, allowing to see that one cohesive dish. Remarks and report in the class were connected to Google Analytics, but the tour provides capability to connect to a wide range of you'll connectors such as Google ads, search console search as 3 60 YouTube analytics and many more. There are also some third party connectors, some of which we are a paid subscription. Wherever the middle age collects were further range of data sources such as Facebook ads linked in at big odds, they just shoot. It also provides a vast range of design elements, allowing you to make your reports your dick to you on a corporate, your companies branding within them what we go through some of these four months into always in the class. However, I would encourage you to play around with these tools and see what you create. In this lesson, we have covered what good would that shooter is? What it is useful in the next lesson What we're getting hands on and get started with our own new report. I look forward to see you in the next lesson. 4. Getting Started With A New Report: Hello. In this lesson, we're recovering. How to get started with the new report. We'll be setting up basic design of report, including ahead of title and date Ray. Select Up. We will also be connected to Google Analytics as data source. To get started, we will either have to select one of these pre defined templates or create a new report from scratch. Well, we started by creating a plan. So I go ahead and click on that will now be asked. Connect with data source for this example we collection to get around. Let it soak Leconte Planalytics I will not be asked. You select the data source that would want to connect to So in this case, the demo account for Google Merchandise Store will collect the master view. We'll add that to our report. That's report so it's out of the table for port will just remove that we can happen in later. So now operated on the report on added Google Analytics. That's data source. So when our name our reports So it's cool this pupil merchandise store this tool marketing holes. So it's not put our report on the tart star Paul. It's when I got out ahead up to do that, we'll go to insert on what? Select rectangle. We just place it somewhere around the top of the page. What? You big make sure it stands out. So this is where we see the design tools and data shooter for the first time so we could change the color of the background of the rectangle. So I'm just gonna go ahead and select a dark green Will Smith Too dark. So for something a bit lighter. So now we've got our header image. We now that I had some text to title this So I'm gonna go to insert again and then text choose very like our text. So it's coming up quite small. What type? In our toilet which I'll call my digital marketing report. And then we can change the color which I'm gonna make my white to color on this background make it a bit bigger. So I go for 40 and I'll change the funds on make it bold. So let me go Sent to this. So we now go our head of rectangle background on our title and I gotta add a eight brain selector which will allow reports always be up to date. Allow the user to select the daybreak they want to view the data for. So do that again. Go to insert and then we're gonna slip date range, and we'll put this here, talk it. So here we can see the default date range. So this is awful. I'm just gonna select mind to be, uh let's go with this month, this example. And then we can also change the start, So I'm not really fat of the black writing on the green background. So I'm gonna go ahead and change mine to be white color. Let's go. So would now go ahead of image created. So if you go to view well, they'll see our report. We got to see how that date range selected looks, so we can either manually select dates using the come to view what we can select one of the pre defined date ranges using the drop down menu. So so far, we've created our new reports connected to Google analytics and created a title and a growing selector talk for a port to make it easy to understand. In the next lesson, we're going over scorecards which will allow seat key metric to the quick glance. I look forward to seeing you in the next lesson. 5. Scorecards: in this lesson. What Recovering scorecards, which allowed to keep our key metrics at a quick glance, we'll be adding school calls for sessions revenue, Ecommerce conversion rate, Africa Sessions Ray Shit bounce right before we get started, but guns out of subheading to explain school cause so that's covered in the previous video . We'll go to inserts and then text. No, it's literally one of Texaco, and we just call it a key metrics. I just changed the phones, sighs on the color. I will make a boat. We just cut that up here. So if nobody ties already, so we now start creating art school calls. So to do this again, what about insert? I was that school car and what she's we want to place in school card. So we'll put it here, for example, so we could see its pre defined new users as the metrics to show. So to change, this will go over to the right campaign, where we can see the data that we're using click on new users were presented with all the metrics that we can select. So to save time, I recommend typing in sessions in the search bar, the search tour isn't exactly amazing because it doesn't give you the exact measure. The water first, you can see with a quick scroll we could find the one we're looking for. So here we go sessions for a select sessions. We see that in the last. But so far this month, we've had 26,301 sessions on our website. So it's also worth noting that the default date range will select which they wrote. This uses. So in order to make sure we're using the date range to sprayed up here when it's make sure this is set to auto, which in this case is already is. So that's all good if you wanted to. Other comparison to say how this works last month for how was last year? We could add this in here by splitting previous year. Apply so that we see that now actually directly down 60% on sessions, so that's not good. But it helps you to identify how the websites performing compared to a previous time. So when I just had some style to this so we'll go to here on, we will change the, uh to the labels still change this font to be, uh, Blatter, Like the rest of our stuff. I just changed colors. Be this. Here we go. We've now got one scorecard. So in order to save time, I'd recommend copying and pasting this. So to copy this on a map, you press. Come on. Sea or window, she press control. See? So a copy this and then paste it on Mac again. You'd press command V on a windows. You press control V. So what is paces in here? And we could see we've got another school card with all the style elements. Exactly the same as before. So anything we need to do here is to change the metrics. What? Well, let's display. So for this one, we were using revenue. So if you type in here revenue again, it doesn't pull it up. Talk to search, just like annoying. But here we go. We could see revenue here, so it's let's on revenue. So you can see that so far this month, we've had $2106 worth of revenue for the website again, this is 64% down last year, so that's not positive. But it helps us to highlight how foreign based on the previous year So we can, you know, get then again, go ahead and repeat this process for the remaining school costs. So just copy. This will make this one equal Merce conversion rate Every guy. So X equals rates are so that's positive. Oh, copy this again. Put this here in line with the rest. But this one is Africa. Session duration. Here we go. So average restoration is up as well. So that's positive. And then again, finally, copy and paste this one final time at a school cart. Full bounce rates. Here we go without a little off. School cards were just spaces out evenly by selecting all of the scorecards, going out to talk, left, not arrange, and then distribute and then additionally horizontally. This will allow us have even spacing throughout. All of our school cards met presentation that much more professional. So there you go now, but all our scorecard with comparison metrics how they were performing based on the previous year on again, review or poor, we can change this date range to say, uh, last month's because he held the veterans before last month, so excited Update what's massively not to change anything, all right, which is great. So in this lesson, we've covered house create scorecards. The key metrics which allow us to see how key metrics are performing at a quick glance in the next lesson will be covering time. Serious graphs. And I don't want to see how specific metrics of performance over given date rage I look forward singing than its lesson. 6. Time Series Graphs: in this lesson. What recovering time? Serious graphs allowing us to see how specific metrics performance over a given date range in this example will be creating a time series graph sessions and revenue. We set to go off to update based on day translator in the top right of the report to get started just like they did with scorecards, with guys at some headed said to save time, we just copied one we created earlier. So we do that by committing commodity, so that would go good. Are due title in. Just place it down here, huh? We'll just call this what the graph is going to be showing. So sessions that revenue over time. So stop heading. You could go in and create our core office. So to do this, we go to insert time series and select where we like our crafted be so we could see our graph here. However, it's slightly on the smaller side. So we're gonna use the points on the graph to expand this across the whole width of the report. That makes a bit bigger. So as we could see, the graph is defaulted to showing sessions. So to add revenue to this will go up to the right hand pain metric and find revenue. So that's revenue. We can see. Revenue has been added as a light blue line, so we're gonna make revenue appear as fast, make it easy to identify socially. It will go to the stole pain. We're too serious, too. That's what revenue is almost Let those so we can all see revenue is balls. I would also select this building right axis, so the parts are much easier to see. I was able to see a breakdown of the revenue per day here on the right hand side of the graph to I would just change the colors to be more in line with the rest of colors in our report. So for these to be green, this one's beer I don't agree. Maybe yeah, we got. So if you go to view our port now, we cannot see that report is showing us. So example the July 6 we can see it. We had 3138 sessions, and from that we got $778 in revenue. If we put this to last month will be other see it's high month data. So in your last identify peaks easily so we can see. On June 15th we got $761 in revenue, which was the best day last month. So as this will always update based on our date range here so we could see a whole year or lost courts, for example. There we go. So this allows us to keep our always at ST with what we slept in ours. Catering selector. So in this lesson, we've covered time series graphs and we create to the time series go after show sessions and revenue over time in the next lesson will be covering tables. But I want to get more in depth. Look how campaigns are performing. I look forward to seeing you in the next lesson. 7. Tables: Hello. In this lesson, we're covering how to create tables. We'll be crazy table to show us how Google ads campaigns up before May will be able to see key metrics for each campaign. Our table containing metrics cost revenue impressions clicks click through rates on return them and spend or borrow us. We just got off our table to be a heat map, allowing us identify stand up metrics with these. Before we get started, we could see that we're running out of space on the page. So it's a fix this issue gonna go up to page that's that's current page settings style and then change, the highest to be will put to thousands. We've got some extra space so we can now see but up much longer space to work with So as we did before with our school cards and time serious Graaff Crater subheading by copying and pasting when we've made previously bringing that down here I will just call this bugle That's campaign performance. So now we've got subheading. We're all ready to go start creating table, so to insert, find table and shoes, we want to stay with big. Put it here that will expand this across the whole width of the report. So it was here. It's given us days and sessions as a default as we're gonna be creating what for? A campaign will change. I thought I mentioned to be campaign. I will now be able to enter the metrics you want to include, so we'll start with cost revenue impressions. School clicks on click through Rate prepares to CTR. We don't have a metric by default for robots so greatly calculated. Feel that by going to I've metric and then create filled, we call it Ross over revenues divided by cost. What this displays percentage that would change the type from number two sense. Now click apply. We can all see our Rose has poured through each of the campaigns. So in order for all of the titles for each column to show or go right, click resize columns fits the data so we can. Actually, all of the campaigns and columns are perfectly aligned. I went out there start of the table to be in line with the rest of the start of our report . So what is that like an excuse style change. Our table had a font color to be right fall to be that so every guy I would change on table had a cover to be the same size as our head of our hope. Change our table labels wants to pay. That's a as well. That would change the color of that to be in line with the rest of our pool. So this is where we're now able to start Crestar heat map. So if you scold out here to see down here, we could see the metrics. So what changed? Calling one. It will see this number here. We're trying to this to heat map we can see here is put in a heat map but isn't blue. So if we just trained to this color so agree, I cannot see a heat map cost, which allows us to identify which campaigns spent the most. But I do the same for the remaining metrics. Oh, heat map changes to green. Same again. There goes. We've now got a heat map for all of our different columns. However, you might have noticed down here we have a campaign called Not Set, so we want to exclude that in our table. So to do that will come back to Peter, go down to filter, table, filter and click. Add a filter. I am not to call this exclude notes Set campaign. I will change this to B exclude Campaign contains I'm pretty not set and then click save so we cannot see that campaigners removed from our table. So if I click view a viewer report with our table in it with a heat map identified, all of the metrics of our campaigns were easily identified. Which metrics are standing out so we can see that the Parral campaign what in the most revenue that spent march but slightly lessen the biggest spender but Marshall spend. We can also say that this has the highest for our support campaigns to this will always update with our their intellect with top. So we want to see how they for the last month, we just certain last month click apply scored onto our table. We can see that last month it was the usual campaign that did the best I was for the campaigns. So that way now our table for our Google ads campaigns so in this lesson we've covered helps create tables in this example reviews Google ads. Campaigns were also created a heat map to identify it. Stand out metrics. We've also created a filter to exclude, not set campaigns to make what table it's easy to understand. In the next lesson, we're recovering pie charts. I look forward to seeing you in the next lesson. 8. Pie Charts: Hello In this lesson will be covering pie charts. We will be creating three pie charts to provide us with a device breakdown. This will allow us to see which devices users are accessing our website from another behavior. Various placing. The device that they use to get started, as we have about previous lessons will get started by creating a subheading for a pie chart . So go ahead and copy this one. Is this right down here? I will call this device three tell as our prototypes won't be clear. Exactly. The magic were displaying will create another subhead of each of our pie charts in orderto alive. But I want to identify which metric they're representing. So bring this down here slightly. I would just call this sessions are I think device. So now I got off subheadings done. Be ready to start creating our first pie shop to do this. What insert? That's that's part shots. She's really wants a partial to go. So I put it here. I would consider issues campaign by default unless we want to create a device breakdown which range what I mentioned to be device category here we see our device category here. So what? I'll change your metrics to be sessions we cannot see with sessions with these devices. Percentage so we can see that 71.5% of sessions have happened on desktop. In order to make this interact with the rest of our reports and change the colors we'll go to style, I would change the colors be single color, which is the main kind of our report, said the green we used earlier. So now the stars within today with a report which changed the phones. That's don't make this so great. I went to the same down here as well. So now it was done next week on the bulk of our work. So we can all just highlight this by dragging your mouse over the subheading and the pie shop and copy of pacing the entirety of it. Move this slightly next to it. I would change this. Want to be revenue my device. So there's a data change, the metric to be ready. So that's revenue so we can all see a revenue split by device. However, we could see that the legend isn't in line the other part shop, so it always make sure that it's easy to read will change our legend by going to our first graph Clinton sort. Changing the sorts be by device category, and then we'll put a sending. So that way it will always read to stop mobile tablet. So we do the same for this graph sort by device category, sending then a guy so we can all see that 66.5% of our revenue comes from Mobile. Which is interesting considering the number of sessions on my well is much less so that we've got our revenue and sessions. Part shots would copy this one. Hey, sit next to it. Bring this one over here and for a final part child creating one for conversion rates. With this conversion rate by device, that's we don't. Before, we just changed our metric from revenue to be equal. Most conversion rate. That's conversion rates have consented in itself. We want to make that clear to see it's a style and there will call. This change will go to the label on. We'll change it from percentage to be the value. So that way we can see the conversion rate for each device so we can see here that tablet converts the best, their stock reversing the laced, which is interesting compared to the proportion of sessions from desktop. There we go. Now are we have your reports and CR three point shots for a device. Right now this paints a really clear picture of how the users are coming to our side on how the behavior varies. So you can see here that 71.5% of sessions happening desktop about only accounted for 20% of the revenue. I don't desktop users actually converted the worst with the conversion rate no point No. Five. So in this lesson, we've created pie charts to show the price breakdown to show which devices are used as a visiting our website from and how their behaviour various base of the devices they're using in the next fatherless that will be covering filters. I look forward to seeing you in the next lesson 9. Filters: hello in this lesson will be created. Filters touching. This woman created our time. Siri's graph earlier. But in this lesson, we're going more in depth. We're looking at creating a new page for a poor to show only statistics for paid traffic. The reason I have chosen to cement the report I paid traffic is due to the table crazed earlier for Google ads campaigns forever. If you wanted to, you could create a filter for organic traffic. Interested, Updated table to show something more revenue. So get started. Forgot to page more juice. Okay, Our existing page. When I go to see your page food in the top left corner, we could see page while a copy of page one. We'll just rename it quickly to make them clearer. So on the first page traffic horse, I'm a lot second page paid traffic reports. So now we will also just change. All sports was here and we'll update off. First base tries to try it report. So now we're going to our patron. Better start creating our filters now. So start with Qatar will select our scorecard. Patrick, for sessions. Well, come down to here where we have thoughts. Option. Click. Add a filter. We'll create filter what's called a filter Hayes traffic. We want to include the source. Medium Contains Google CPC. So this will show paid traffic from Google who want to show all pay traffic will be. Just remove the Google from the front and this would show all paid traffic. You would show organic traffic that you would just change the CPC to be organic and again the same thing with you. Go slash organic or just a mechanic so we'll save our filter will see our sessions. Metric updates. We can actually only had 609 sessions this month from paid traffic, so we can now go through update all of off scorecards to include this filter. There we go. So now all of our scorecards are only showing tater paint traffic from Google. We could do the same thing for our time. Serious girl from a day earlier that you felt up traffic never go. Same thing with this, However, I don't think it's worth updating this table as this is only showing data from the campaigns anyway which are paid, traffics or leave. This has be at the time day and will come down to a pie charts and we'll start applying filters here too. That's interesting here, so we could see revenue all over. Revenue has come from mobile this month. So far from pay traffic never got. So now we can view are bought for paid traffic. We can also go up here to our page. You weaken slept, but we want to see all traffic or pay traffic. And, as with our original port will also be able to change the state range. So if you want to look at last month, paid traffic report, every goes, we could see it last month, state paid traffickers. Well, there we go. So in this lesson, we've covered house, create filters. We created a very basic filled just to filter out all traffic over than paid. You wanted changes to organic it the same thing with covered. How to do that? This is a final lesson. The class in the next class will be re capping alert. So far, I look forward to seeing you there 10. Class Re Cap: Hello. We've now reached the end of the class. I would recap on what we've learned. He started off by going over Google Data Studio on what it is useful with ankle started with a new report from scratch and connects our reports. Google Analytics report later. Once we create Star Port, where the head of using a rectangle as in title text and added a date rain selector to keep our report always up to date. Now that we've set up the basic design of our poor move onto creating scorecards, allowing us to see dates for key metrics of the quick loss. In order to contextualize our data, we insert a time series graph. This showed US sessions and revenue over time and also updated automatically with a data rate selector moving forward. We focus on a specific elements of artist remarking efforts are Google ads campaigns. We created a table to show how our campaigns are performing on the date of the key metrics within them, we added a heat map toward table toe. Allow us to identify stand up data easily with enter carport, step further by adding pie charts to show which devices used accessing our website from and how their behaviour various based on the device they're using in our finalists that we covered creating filters and set up a separate report to show dates for only paid traffic. Thank you for taking the time to complete my class. I hope you've learned something useful. I look forward to seeing your completed project showcasing how you've created your own report using data studio.