Google Data Studio - create amazing digital marketing reports for free | Sharon Hayward | Skillshare

Playback Speed

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

Google Data Studio - create amazing digital marketing reports for free

teacher avatar Sharon Hayward

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

    • 1.

      How Data Studio can help your business


    • 2.

      Sample dashboard


    • 3.

      The sources of data compatible with Data Studio


    • 4.

      Connecting a data source


    • 5.

      Graphs - auditing and editing


    • 6.

      Scorecard data - adding and editing


    • 7.

      Charts & creating a theme for your dashboard


    • 8.

      Tables - auditing and editing


    • 9.

      Custom filters


    • 10.

      Styling options for your dashboard


    • 11.

      Sharing your report


    • 12.

      And finally


    • 13.

      Don't miss this bit


  • --
  • Beginner level
  • Intermediate level
  • Advanced level
  • All levels

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.





About This Class

“It’s hard to win a match if you don’t know the score”.  Unless you know how your marketing activities are performing, how do you know where to focus your efforts and budget?

This class is aimed at business owners or marketing professionals looking to get a better understanding of marketing performance, to help them identify where they are in the game. You will learn how to use Google Data Studio to create a professional dashboard combining various website and marketing performance metrics in a stylish and professional way.  

Google Data Studio auto-updates your reports in real time, so you only need to build a template once. Then you can refer to it in meetings, you can email view-only reports to stakeholders and you can track trends and you can even embed sections of the reports into other webpages - all without having to export and manipulate data ever again!

If you would like to follow along and build your own dashboard for your own business you will need a Google account which must have access to data from at least one data source, for example Google Analytics, Google Ads or Google Search Console.

Meet Your Teacher

Level: Intermediate

Class Ratings

Expectations Met?
  • 0%
  • Yes
  • 0%
  • Somewhat
  • 0%
  • Not really
  • 0%

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.


1. How Data Studio can help your business: Hi, I'm Sharon on today. I'm going to show you how to use Google Data Studio to set up a dashboard to report when your digital marketing performance. So what is Google Data Studio Festival? As the name suggests, it's a tool from Google on. It's completely free, which is a definite advantage on It's a very powerful way of aggregating data from lots of different sources, such as Google Analytics for your website performance. Google ads in case you doing any paid ads, Google Search console for your organic traffic reports and numerous other sources of information, and you can bring it all together into a single, easy to view report. You can completely customize the look of your dashboard using your own company logo photos Backgrounds on set up here in color theme so it looks very, very professional, completely on brand and relevant to you. You can share your dashboard report with colleagues on Do. You can also choose the date range that you want to report to a show for. You can set a fixed window of dates so all users will see exactly the same information. Or you can use a variable date such as the last 30 days or year to date, which means every time you log in, Google Data Studio has automatically updated all the information. This is a really, really versatile tool on If you're currently creating monthly reports on how various marketing activity is working for you, Simply setting up one data studio report means you'll no longer have to repeatedly keep pulling off. The same information is every time you log in, it will simply be updated. So it's a really powerful, sweet Andi Let's get started. 2. Sample dashboard : So here I want to show you an example off a completed data studio dashboard. This entire report has been created using sample data in Google Analytics on for the rest of the sessions in this class, I'm going to show you how to recreate this exact report using the sample data that's available to you in data studio. Of course, you can add your own data source and create a dashboard in parallel with information that's relevant to your business. This view is the view that the recipients of your report would see if you share it. If we click on the edit button here, which will do later, this will take you into the space toe, edit the dashboard. Obviously, when you share this report they will not have access to the edit button. They will simply view this overview. So let me give you a guided tour. This is the way that the report would open up. This is Page One website overview. We've got space for a logo to brand the report and dashboard. I've added an image on the background just to create some styling which may be in line with your brand. You can give the entire report a title, or each page could have a separate title relating to the information within the page. There's also an opportunity to select a date range, which will override the default dates that I've set the report up to use. So let's have a look at this page the top half here we can see there's a time. Siri's graph, which shows website visitors by date and also bounce rate visitors it plotted on the Left Axis bounce rate, is plotted on the right hand access. Unlike most dashboards, this is fully interactive as you move your mouse over the dates get you an actual reading for the values. In addition, you see the three dots at the side. If you click on that, thin, users are actually able to download a CSP or Excel file or export the data into Google sheets in order to perhaps interrogated further in the center of this dashboard screen. Here, there's a number of what's called scorecard metrics. These air snapshot metrics, which also include a period on period comparison value. Here we look at sessions the percentage of new sessions, sessions per user, bounce rate, average session duration and pages procession as key performance indicators. But you may wish to change that. For your own data, we have a pie or doughnut chart showing the percentage of sessions by device so you can keep an eye on what formats of technology people using to view your website. We can look at geographic reports are not high, identify cities with the most and least visitor sessions, and we conciliate bar graphs during perhaps demographics of website users. I have sent this report up to show a default last 28 days, and you can see the graph here runs on a period representing the last 28 days. One of the great things about Google Data Studio is if you are asked regularly to create a report such as, Maybe your manager asks you for a Monday morning report to show performance for the last week. You can set up a dashboard like this, send it to your manager, and they will be able to select the date range themselves, so you will never have to keep repeatedly pulling off the same information. Clicking on this date selector brings up an option toe. Either pick fixed window of dates intensively, you can use various metrics such as the last seven days, 14 days, snap short dates, the whole combination of different options, including this quarter to date, year to date this year and so on. If we click this year, then the date. The data shows no only the performance so far this year, but also allow space for future values to be updated. And you can see clearly how the numbers here have also updated to reflect the larger date period. Selected page two I like to drill down a little bit deeper. The first thing you want to know when you're looking at your website performance, but where your website visitors come from. Here we have a table which shows the medium on the different mediums. That traffic has arrived at the site by the corresponding number of sessions, the percentage change in the previous period, the percentage of new sessions and change and bounce, rate and change. Perhaps you've completed referral campaigns. You'd like to know a little bit more about which sites are referring traffic to your website. This table here shows the top referral sources. We've created this table by using all data that comes to the website and filtering only the traffic source, which has a medium off referral. You can see that there are many more referrals than a shown on this screen. This shows the top 10 but there's 315 different refers. And again the interactive nature off a data studio dashboard is you can simply click through on view the additional information. I've also added a country selector with a little descriptor of how to use the filter tap. Perhaps if you have a global business, a country selector would be relevant for you. Alternatively, if you're located in just one country, maybe you'd look at city or region. You would use this to identify, maybe just drilling down on only viewing the traffic that comes from one of thes particular countries. There's also the opportunity to add a text box into the dashboard so you can write your own commentary. If you're sending the report out on a regular basis, let's take a look at Page three Page three. I've set up you for looking at Google ad performance. You'll see that the styling is consistent across all of the pages, although the layout of data within each dashboard page is flexible on this page. I've used a multi metric table to show which campaigns are delivering which performance metrics clicks. Click through rate conversions, conversion rate, cost per click and the total spend on that campaign. The data in this table has actually come from Google ads showing how seamlessly different data sources could be combined into one dashboard at a glance. You would have no idea that the data in this table comes from a different source than the data in this table. Another feature of the interactive tables or if you have no rose and you wish to show on your dashboard. There's also a scroll bar to allow users to scroll down. Depending on the marketing activity that your brand is actually undertaking. You may wish to have additional pages, perhaps looking at the contribution of social media marketing or even your email performance. If you choose to use a connector to your email marketing software, okay, hopefully that gives you a nice idea of what you can actually achieve with data studio 3. The sources of data compatible with Data Studio: Okay, now we've seen what a data studio dashboard can look like. Let's have a go but creating our own. So the first step is to start with some planning on, like everything in marketing is best to start by considering your audience. Who is actually going to see this dashboard? Is it just for you and your own personally reporting use? Are you going to present it in a meeting? And who's going to be in that meeting? Are you going to need it toe? Add a commentary before distributing it, Then think about what do you audience need to know? What level of detail do they have a particular area or special ism that they're going to want to focus on. For example, if you're sending the report to regional managers, you might want to consider adding a filter so that they can look at the information that's relevant to then. So once we've considered our audience next, you want to start to look at what data sources you might want to include. There's a number of free options available, and it probably won't surprise you. That is part of the Google Sweet Data studio integrates seamlessly with a wide range of other Google products shown here today, I'm going to focus on analytics and Google ads. Aziza, probably the most widely used. You can also include data from a wide range of other sources, such as being Facebook instagram linked in male chimp on many others. But you will need to purchase and set up 1/3 party connector next up. You'd want to consider what data is available from each of thes sources on the order that you'd like to display it in. From my sample report, you'll have seen that I like to start with General Website Analytics on, then drill down deeper into specific areas of information. And finally, you want to consider the way that you present the information. Make sure you use a mix of graphs and tables and charts is this creates a much more visually interesting dashboard 4. Connecting a data source: Okay, that's the planning bit done. Let's get started. Search for Google Data Studio or head to data studio dot google dot com. Don't forget, you'll need to sign in using a Google account that has access to at least one of the data sources that we just talked about. Okay, you should now be looking at your data studio home page. There's lots of supporting resources and information how to get the most out of data studio . You can click on the question mark icon to bring up the help menu further down. There's a selection of video tutorials, and also you should open up if it's your first time using data studio with a Welcome to data studio start here report, which you can click on, and it gives you some helpful advice on how to get started. I'll let you explore all of these in your own time, but for now I'm going to give you a quick tour, and then we're gonna dive straight in. The top section here has ah number of templates that you couldn't see. The Acme Marketing One gives some ideas on how you might present the type of data and information that comes from Google analytics. The search console report is the same, but from data from search console on the Google ads, overview gives you some of the ideas on how you might present information about your ad campaigns. In fact, there's a number of additional adverts as well to give you some ideas of how you might want to report data in future. If you click into any of thes templates, you can use the template by clicking on the used template button. It makes a copy of it, and you simply change the data source to be your own data, which will then keep all the formatting. But change all the data to your own. Once you're set up and running, you'll have a number of data sources, which will appear here on. This is where you have connected your data studio with your analytics, AdWords or other third party data providers here. Connected data. This is where you can see the range of different connectors available. Keep scrolling down through the Google owned ones, the partner connectors and finally, at the bottom. There's also some open source connectors, right head back to the home page. Let's get started, so we can either duplicate one of the existing templates and then edit the data. We can select a new blank report. Okay, the first thing you need to do is associate the report with a data source. You Can I, The select a data source that you may previously have loaded up. You can create the new data source by clicking at the bottom here on then, selecting the source that you would like to use very mind. You will need to log into that particular source as well. For the purposes off this demonstration, I'm going to use the sample Google Analytics data once you collect it. Then we added to the report So initially, what you see in front of you is your dashboard canvas, which is ah, transparent background with a grid to help you, ah, line all the different reporting elements at any point as well. If you click on the background brings up this layout and theme menu, the layout enables you to choose the size of your dashboard. I prefer to use the 16 by nine landscape version. The U. S. A. U s full by three version is slightly deeper and not so wide that you can also use the custom setting to create a dashboard of your own bespoke size. There's another a number of other options, and in the theme option, you can switch between a simple white and a simple dark background. Using the dark theme automatically means all the label text is in a light color, so it's inverse and easier to see. But we'll start with simple at the top of the page along this menu bar here. These are, obviously, add a page. You can have multiple pages within the report and other pages. Quite straightforward, quite self explanatory. Undo. Redo on then. Here. These are the different types of elements that you can insert into your report so you have , ah, line girl for bar graph multiple different format graphs, pie charts, tables, visual map scorecard, various other different formats as well as well, and the option to draw rectangles and circles, which is useful for annotating your own data. Presently, I like start by adding in the logo of the company that the report is four in the top left hand corner. You would do this by selecting the image icon during the place marker and then selecting a file for now because we're using sample data. I'm going to draw a rectangle as a placeholder for the logo. Andi, color it in In this nice aquamarine color, you may also want to use the text box feature Teoh give you a reporter title. And once you have entered your your text, you have the option over on the right hand side. Women, the properties. So you can, of course, control font size, change choice. So it is Ah, front that you particularly feel, represents your brand. That's where you select it on again. You can choose font color style on the alignment and even hyperlink it. Okay, so we've created a new data studio canvas. We've connected our first data source. We've started to add some customized styling and next we're going to add some data elements 5. Graphs - auditing and editing: Okay, let's start to look at how we might combine different elements into a single report when we're looking at our website data. One of the most interesting things toe. See how website visits are trending over time? What I have done here is if you select time Siris on draw a graph, it automatically fills out A default graph, which is data of on automatic date range, which is the last 28 days on is actually showing sessions and it's in date order. So the dimension field is date. The metric is sessions on the date range is 28 days. Now we can use this feature here. These little arrows enable us toe turn on a compare feature. So depending on what's most important to you, you might want to look at websites sessions versus previous period which is shown in the pail line here, which would show that um, this website is is up versus the previous period on. You can also select previous year those of you who are used to using Google Analytics, you'll notice that you cannot specify the dates for previous year. Okay, let's say we don't want to look at, uh previous. We just want to look at the current period. Now this particular graph is looking at sessions. If you want to change what the metric that's being shown in the chart is, there's a couple of ways to do that. One option is you simply click on the word sessions, and this brings up a group of metrics on. If you click into any of the groups, it expands with the different metrics available. So in the session group the recessions, which is currently selected, you could also look at average session duration, bounce rate, um, many different fields under the user field. We see the number of users, as well as the number of new users through select users instead of sessions. The graph changes to show uses instead of sessions. No, when you're in this, because we clicked on the metric, if you click on something different here, it changes it. It doesn't have it. If you'd like to see users on sessions, we simply click in the ad metric box, scroll down to sessions, add sessions, and now we have both sets of information available. However, you might say well uses and sessions having these two sets of information. The same girl doesn't really tell us very much. So actually, let's change sessions. The bounce right and you can see straightaway. That bounce rate is the red line at the bottom, which is barely legible. What we really need to do is play bounce, rate and the other access and the way that we do This is you up for style at the top menu here. Everything on the left data is about the source of data. The nature of the data, the way that data is presented, is controlled under the style tab heading here So we can see that the very first day to Siri's, which is the blue line, is shown on the left hand axis. And if we scroll down the red line, which is the second Siris of data, we can actually apply that to the right taxes. And now we can see that we can actually see the data and it's much more much more meaningful. We can easily extend the graph so it fits into the space available on again. Under the style function, we might actually want to give it a background instead of a transparent background. So we would scroll down through the options here. Background on border, click on the drop down our let's have a white background on the border shadow. If you want to give our charter heading, we simply select the text field, draw the text and then type in all heading I'm Once again we would film at this, using the style options that are presented to us on the right hand sides, you know, So change the margin on the inside, using these padding variables. Here it's so now we've learned how to add a time series chart. Choose the metrics. Change the axis on apply styling options. 6. Scorecard data - adding and editing: Sometimes it's more useful to see a snapshot value rather than a trend over time. That's where we use the school card metric. So select school card on, then click to draw. Once again, it defaults with the value of sessions. Sessions may or may not be what you want to show, but we'll start with that for now. In this particular view, it's very easy to include a a period on period comparison. In fact, for here we're going to go. Previous period previous year missed the previous year. Onda automatically fills in this little arrow conveniently color coded everything down is in red. Everything up is in green to show your sessions and how they have performed. Now let's just the size of the box to the text. We can update the mignon. There's the green and the red. We can update the styling so we'll go with a white background again on a border shadow on, and then we can simply use the keyboard shortcuts of copy and paste. But this time we'll just change. It's the session number two, a number Siris of other metrics that are likely to be useful when looking at the top level of your looks like performance so we can look at percentage new sessions to give us an idea on how well we're reaching new audiences for the controlling and paste again percent. Let's say now we want to look at how many sessions there are per user so rather than searched all the fields because simply use the quick search here to see if that field already exists. Oh, on what we have here is a number of sessions per user. So because that's the field we want to use, we can simply click and drag on Drop it to replace the metric that we wanted to look at. Now that metrics actually doesn't really fit within our formatting. And so, if you harbor here over the au t standing for auto to get the pencil edit feature, click on that we can rename it so we can say sessions per user. And now that fits within our our styling Boggs. In fact, you can use this to rename any of the metrics. So if you don't like users and what do you something like people or visitors, or whatever your internal languages, then you can you can make that change like that. So let's add in a few more school board metrics. Okay, so now we've seen how to add and format scorecard data elements, as well as how to use the dragon drop feature as a way to quickly find and replace dimension data. 7. Charts & creating a theme for your dashboard: some other features that we might like to add to this report might be the performance by device. So when we could have a pie chart, which so shows that devices that people are using to view our site so we select our graph type, draw it by default is giving us the acquisition channel, which we don't want. In this case, we're going to change from dimension down to platform or device, scroll down a little bit further to see device category, and there we have desktop mobile or tablet. Now I'd like to change the color of this chart so that the Blue desktop is denoted by the same Akwa Marine as my logo. So once again, we click into the report to style four month thing by slice order rather than the fixed I mentioned Click All Blue, the first color I want to change Click on the color I want to change it to, and it's that simple. We can also change the pie chart to be more like a here, like a doughnut with the gap in the middle, which creates a nice visual look. Okay, what else might we want to choose? Maybe we'd like to see geographically where visitors are coming from. So we select g o map, draw the area which we would like our our map to fill by default. It comes up with a global at present ation. All right we might want to do is only look at cities instead of this the country code. We could look at Continents City, break it right down to different the different areas. So we're going to look at city now by default. The report shows cities within America, and that's because it's defined by this Zoom Area section. Here. We can click on that. However, Andi scrolling up, we'll take us to the different options and will select United Kingdom. So once again, we can see that by default. The geographical map has Bean presented using this default blue color, and I want to use the greeny version of that color so we actually have quite a few options for editing and formatting this geographical map. Once again, make sure the geographical map is selected and click on the style tab. Our options here are we can change the maximum color value to our greeny color, which automatically changes the colors and the density of for colored circles. Now, other things you could do is, if you like the landmass to be more visible than the dateless value section here we can select, then use a darker shade of gray in orderto introduce a little bit more contrast into our chart. Something else that you might want to do is actually identified, perhaps, where your marketing needs a bit more effort on. Look at areas where there are low amounts of traffic, as opposed to just high amounts. Now the low traffic cities are currently denoted in a very, very pale color. Eso they're not really visible. But once again we can. Instead of changing the maximum color, the middle color. We can focus on the minimum value and change the color here to something that's a little bit more prominent. And now you have ah, much clearer geographical representation of where your top performing and also your weakest performing areas are. Instead of clicking on a chart and editing the color, something else that we can do is change the actual theme of the entire presentation. So if you click on the general background, the theme option is presented instead of the style menu on At this point, we can choose our secondary color to be our are chosen green color and the first value this chosen in a chart pallet. We can also replace that with with our green as well. So now if I were to draw the charter gain, for example, you would see that by default, it actually uses the greeny color that that we actually wanted to use in the first place. We've now looked at creating and editing time. Siri's graph scorecard data pie charts, green geographical maps Let's now have a quick look at a bar chart. Select the chart type that you wish to draw, draw it into the allocated space. And once again, it's time to select the dimensions in the metrics that we wish to review. So once again, the default values here are the source of traffic on the number of sessions by source of traffic. This is quite a nice chart, but we're going to look a acquisition on the next page. So for now I want to look at the demographic of the website and looking at it by gender as I want to change the values on the access. I want to change the dimension, not the metric. So in this case instead of the medium, I would like to see something about my audience on a gain instead of sessions, we can now change the metric to be uses, which now gives us a nice snapshot off our audience. 8. Tables - auditing and editing: the final type of element that I'd like to show you in this skill share class is about adding a table. A table is a fantastic way to show multiple metrics in one single place, and this is the table feature here. So we've run out of space in our report at the moment. So what we'll do is we'll at a page. And here we have Page two. We select our table from the reporting elements available, created space for it. On by default, you can see that it's come up using our desired color theme on it shows medium off acquisition on the number of sessions that equates to each medium type. At this point, we can start to form at the table. What we might say is, in addition to sessions, we would also like to know the percentage of new sessions by medium. We may also want to look at all the metrics such as bounce rate, and we can also include the comparison feature within the table in the table format. It does this by creating an extra column showing percentage Delta change for each of the different metrics selected. So let's try to make this a little bit more presentable. Weaken manually. Adjust the column widths simply by clicking and dragging instead of media. If we don't wish to look at it by median, we may look by source and medium, which gives us a more detailed breakdown. Well, potentially just source within the table. You can choose how many rows are actually visible on a page. There's two ways of doing this. You can either manually edit the size of the table to show a visible number, although even when we do this, they're still 100 rose available per page, so that seems a little bit contradictory. But what that effectively means is that users will have the option to squall within the table to see up to 100 items within a page before they need to tap over to the second page . We can have a look using the view mode into the preview, which is how other people will see the report once we've shared it. On what you can see here is all those only 13 rose are available within our editor. A scroll bar has come up on. We can scroll all the way down to see up to 100 different elements After 100 we need to create the second page within the table, which again shows 100 elements. We returned to the editing screen. This is how we can. We can control the number available here now to show the top 10 traffic sources. You would limit this to rose per page of 10 on Edit the Table to be the correct size. Obviously, there is the multiple page feature so that users could flick through additional data if they wished to. 9. Custom filters: let's get back to the medium as this gives us a really simple summary on, Let's say that we're particularly interested in finding it more information out about the referral data, and we'd actually like to just filter and see which traffic is available from referral. If we use so sand medium, we will get the referral type will be shown, but it will show different source and medium combinations. So the way that we can do this is we may decide toe inset another table. We wish to show our traffic source, but then at this point, we now want to create a filter. So we scroll down under the data tab on the right hand side on what we could have. The option here is to add a filter. So the filter, maybe that you include data, exclude data. We can create your own parameters. We want to only include medium, which is equal two referral. We'll name our filters so that we can reference it in future and potentially apply it to other graphs. Now we can see within our table it's filtered, so it only shows the data with source on the medium so you can be confident that we're looking at the correct data now that we're confident we may wish to remove the word referral from this list in order to avoid duplicating. So instead we can simply select source, which presents us with exactly the same data as we already had. But without the extra referral information on, we're confident that it's the correct data. Okay, so now we know how toe on the table, change the metrics or dimensions on. We know how to limit the amount of data with shown within a table. We've also learned how to create our own custom filters. So happy that's giving you a good introduction into how to create the first page of the report. Were lots of information relevant to your website on the top level information associate ID with your website performance. So hopefully you've been following along and you've now created your own report using your own website analytics data on Be great. If you'd like to share that with us all in the project section within school ship and submit that, then we can see the creative ways that everybody has used to present their works like data 10. Styling options for your dashboard: So now you know how to create your own dashboard. You know how to start a new dashboard or copy an existing template? You know what types of data sources are available to use and combine into Google Data Studio and us, and I had to add a new data source into your dashboard. We've looked at the different reporting types, so we've looked at grass tables, charts on maps, and we've also looked at how the customized the data that each of these shows by choosing different metrics by mentions on deploying custom filters. So now the best thing you can do is start to try to build your own reports, attach your own data sources and try and actually create a dashboard of information that is a very relevance to you. However, in this section I'm just going to show you some tips for how toe style eyes your dashboard to make it visually engaging and on ground. Let's have a look at style, izing our reports and are dashboards and customizing them to look a little bit different and unique for our own brand. There's a number of ways you could do this one way. For example, is, you may wish to include a background color or background image. Let's say we're going to include a background image. Select the image to draw the area off our background. We have been are invited to select a file you may have some imagery which is relevant to your brand on would be particularly meaningful. Preserving aspect ratio means that the image will present itself on screen in its original format. On not maybe, filled the space that is available in order to stretch this image across to fill the whole page. Simply UnTech preserve aspect ratio. At this point, obviously, I'd like to send it to the back of the report behind all of my reporting features. Or, if you'd like to make an actual background, make it report level depending on the size off your image. This may take a few seconds to populate, so that looks quite smart, although perhaps it's almost too colorful on distracting, so we could apply the image just to the top section on, perhaps would like to highlight the different sections within the site. Potentially, we could use a, uh, rectangle, which automatically now populates in our chosen theme colors and If we select order center back, this highlights nicely. Our scorecard data. It's edit how that appears. And finally, let's create a white background in order to obscure all off the grid lines. And there we have Page one off our report. We may wish to copy the styling features, is in control and copy and paste those on to our second page in order to ensure consistency because the graphic has already been set us a report level that will, by default, appear on all pages. Let's continue transom titles and headings. At this stage, it's also worth starting toe. Add in some controllers for your report viewers, so we could look a a date range selector. We could go up in the header from style that we may also want to add a user feel to control and possibly some highlighter features. And maybe at this date you may even want toe add in. Some commentary boxes are just copy the date selector through to the front page as well, and now we have pretty much a finalized dashboard 11. Sharing your report: Now you're ready to preview your report. Click the view button in the top corner and you get to see the report. As you use as well. Make sure the data all appears, as you expect it to, that your pages, if numbered, are in the right order and have meaningful titles, and that everything lines up and looks professional. Once you're satisfied, the next thing to do is to share your report. Use a little symbol off the plus and the person sign where your ableto either provide email addresses or the names of people using their Google account. Or, of course, in the normal Google Way. You can share a link and specify the privacy settings that go with that. One of the great things remember is you're sharing a link to this report. So at any stage, if you want to add in additional data sources, new reports, new pages, restructure the report, then you can do so. And whenever your viewer next logs into view the report, they'll simply sit with all the changes made 12. And finally: and finally, just to say Thank you so much for watching This has been my first skill shared video. I am planning on doing a series of videos aimed at the SME business owners and entrepreneurs. I'm hoping to cover topics such as Google analytics, Google ads and re marketing Google Tack manager. But if there's any other subjects that you particularly like me to cover, then please do drop me a line on try incorporate those on. If you subscribe to my channel, then you were the first to hear when they're released. 13. Don't miss this bit: so hopefully does giving him really okay. Are you helping me edit this video? Thanks. In one single dashboard, you can show all your key digital marketing information in a professional. Uh uh.