Google Data Studio Reporting for Google Ads Managers | Cameron Ferreira | Skillshare

Playback Speed


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

Google Data Studio Reporting for Google Ads Managers

teacher avatar Cameron Ferreira, Digital Marketing Specialist

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

12 Lessons (1h 13m)
    • 1. Class Introduction

      2:45
    • 2. Creating a Report & Data Sources

      3:09
    • 3. Date Range Selector

      5:59
    • 4. Tables

      10:51
    • 5. Scorecards

      11:08
    • 6. Pie Charts

      7:46
    • 7. Column Charts

      7:29
    • 8. Time Series Charts

      9:01
    • 9. Geo Charts

      4:49
    • 10. Treemaps

      7:43
    • 11. Access, Sharing & Layout

      2:09
    • 12. Class Project

      0:38
  • --
  • 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.

36

Students

--

Projects

About This Class

This course is for all Google Ads Managers who want to create easy to understand and interactive reporting dashboards using Google Data Studio, that they can use for themselves, or that they can share with their clients.

Google Data Studio makes reporting for managers of Google Ads accounts so much easier and makes it fun too, and this course will go through specific use cases for Google Data Studio reporting for Google Ads, and also shed light on some of the basics of using Google Data Studio in general.

You'll learn to create tables, pie charts, column charts and more, and at the end of the class, you'll be able to create and adapt your report dashboards according to your reporting needs.

No prior experience of Google Data Studio is required at all, but some knowledge of basic Google Ads metrics will be useful.

Meet Your Teacher

Teacher Profile Image

Cameron Ferreira

Digital Marketing Specialist

Teacher

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. Class Introduction: Hi there, I'm Cameron and welcome to my class on Google Data Studio for Google Ads Manager's, I'm currently head of digital analytics at a digital marketing agency and have been using Google Data Studio for the past few years. And I'm absolutely obsessed with this. I can spend hours on it each day and I really hope that you're going to feel the same off of this clause. Could go Data Studio is such a powerful tool for account managers, but also for clients. It helps them understand the data better, helps shed lots on the dates a bit, and also helps you as the account manager, save a lot of time on manual reporting, where you would usually have to download an Excel sheets from your Google Ads account, clean them up, rob the email, send them over that. And then also tronic spectral client to understand those Excel sheets as well with Google Data Studio. And you don't have to do that. You can send them a link to the interactive and love dashboard where they can change date ranges, look at different metrics and use photos. And it really helps them understand the data, Sorry, much easier, and also helps you as the account manager, understand the dates. That way you can create visuals and reports on certain types of data that you need for your account management. So in this course, we're grinding guy from the very basics all the way down to creating different types of charts such as pie charts, line charts, tables, and even a bonus charts. At the end, we're going to go through how you can stall your chart, make it fit, the look and the theme, the brand of your clients. So it's really going to help you save time and also provide a lot more value to your clients at the end of the day and the end of the month when it comes down through that reporting day. You also going to have to do your own project where you'll create your own charts and you'll earn a dashboard at the end of each lesson, but try and customize it to your account, your specific needs. So do a table, but maybe add in a couple of other metrics that you might need or replace the metrics that we've used in the clause and rather do it with metrics that you think will be valuable to your clients. Each Google Ads account is different. Use metrics that you find useful in your day-to-day management. And then once you're done with your reports, save it as a PDF, upload it to the project gallery where we can comments, I can share feedback and answer any of your questions. That interactive project is really going to help you immerse yourself in it, get some practical experience, and also have your questions answered that you must have. So I really hope that at the end of this class, you love people Data Studio. As much as I love it. I really am passionate about it and please do the project, get into active and ask questions as much as you want. Thanks very much, and hope you enjoy this class. 2. Creating a Report & Data Sources: In this lesson, we're going to go over creating in your reports, creating your data source for your report, and also discuss data sources a bit more. So we're at Data Studio dot google.com and we're logged in with our Gmail address. If you simply Google, Google Data Studio, you can click on the link that comes up and simply sign in with your Gmail address. That will take you through to this report or this page. Will Google Data Studio where you can create a new reports, manage your data sources, and also create a new data source. We're going to go ahead and create a blank report by pressing the plus button. And it's going to ask us what data source we want to use a data sources, the platform. Firstly, that you want to connect to along with the accounts, that specific account that you want to connect to. And our use case, we're reporting on Google ads. But as you can see, you can choose Google Analytics and you can even connect to Google Sheets. There's hundreds and hundreds of other connectors that you can also use, such as Facebook ads, YouTube Analytics. But we're going to focus on Google ads. So we're going to click that. And right now you can see that we have no accounts connected to this account. Your case will be different because you begin you'll be logging in what the Gmail address that has access to Google Ads accounts. We're going to go ahead and add data. And I'm just going to choose the sample Google Ads Data, which we'll be using for our reports. So then we go, we now have a data source added SAR reports. So that's a simple overview of how to create new reports and how to add a data source. If you want to go back and see your data sources, you simply click on the Google Data Studio icon in the top left. And now you can see, because I've added the sample Google Ads Data Source, it's not sitting there. For each new reports you create with the respective data source. Your data sources will show up in this data sources section, and your reports will show up in this section. If you want to rename your reports, you can simply go into the edit and you can rename it. We'll call this Google Data Studio report Skillshare. So that's an overview of creating a report, creating a data source, and managing your reports and data sources. And I really look forward to getting into the charts with you in the next lessons. 3. Date Range Selector: In this lesson, we're going to go over how you can create your report header, which will include a date range selector and an image or company logo. We're going to go ahead and insert our date range selector. By clicking Insert and scrolling down to date range control. We're going to click into the Canvas, which will place our date range selector on to the report. And we're going to select that default date range. In this report, we're going to choose the last 30 days. But as you can see, there are a whole bunch of other selections that you can choose. We're going to scroll up. And by default, the report will then reports on the last 30 days. And it will report on this unless you actually change the date range while viewing the report. We're then going to start our our date range selector. As you can see when in view mode, it's squared. And that's what we're going to make it a blue with the rounded edges. So we select that by going into the style section. The style tab. Once clicked on the day train selector. And heading down to background and border. We can then choose to add a border shadow, which will add a shadow around the border. And we can then choose the border color. Let's choose a light gray. So as you can see, we now have a date range selector that has nice rounded edges with the border shadow. Let's add some color to the the date range selector. We'll do that by going back into edit mode, clicking on a date range selector, grain to the style tab, and choosing the background color. And this example will make it a dark gray. You can see now hey ever that it's a bit hard to read the text, what the darker background. So let's make our texts watts. Or to show a bit better on this darker background. We click into the data and select, again, go to the style tab, and we select the font color of watts. So now you can see it's a bit easier to read. We're now going to add an a logo. This can be your client's logo, your own logo. And we do this by clicking on insert an image. Dry up the size that you want the logo to be. But don't worry, you can always change this. And then you're going to click Select a file. You'll find the logo and your computer. You can double-click it. And there we go, you have your logo inserted. We can then resize. It's great. So now we have our company logo and our data range selector. One bonus tip is that you can actually right-click this and you can extract the theme from the image. This will extracts the colors that are in the logo for that, you can use it as a theme for the rest of your report, for all the rest of your charts to use the same colors that match your clients or your company logo. Let's select this theme. There's an r change at the end to match the colors of the logo. Let's say we want to change the color of our date range selector to match the color of our clients logo. We can click into the date range selector, go to the style tab, and go to the background color. We now see that we have all the colors of the theme. Let's select the blue from the logo. That looks a lot better and gives a bit of a Brownfield to the report. We can now add a divider. I like to use a rectangle and just stretch it across the whole width of the reports. You can see it's already picks up the blue from the theme, which is great. But you can always change it over here. There we go. We now have our project header. Just a key tip. And a very important one is that if you add other pages to your reports, you'll notice that's the project header is not present. So very important to include these items and make them report level. You'll see now that when we highlight them, right-click and select Make report level. It will then show on the other page. There we go. So this is important because if you change the date range here on page two, it will then change the date range on page one. However, if you haven't made your date range selector report level, it won't do that and you will have to separately functioning date range selectors, which can make the reports a bit confusing. So that's it for your project setup. And I look forward to showing you other charts and upcoming lessons. 4. Tables: In this lesson, we're going to be going over how to create a table. Let's get started. We're going to go to the Insert section and choose table. We then going to click into our Canvas, which will cause the table to appear. You can see that we've been given some predefined metrics and dimensions to work off with. But we're going to edit the submits according to our requirements. In order to resize the table, you simply drag the table to the rods are clicking on one of those little dots on the sides of the table. And it's dragging it all the way across to fit the length of a report. You can see that when you Alon with something above or below, you get a vertical red line. This means that you are a land with another elements above or below the table. Let's go ahead and rely on our columns. So now we see campaign by clicks. That's what this table is reporting on. However, we don't see a total value share. There's an easy way to get that total value do show and that's postulating shows summary row. You'll see that once we click this, we'll get a grand total row. That'll make a table a bit easier to understand, a bit more insightful. Great. So we now see our grand total row. We have in our example. We want to report on cost conversions and cost per conversion bar campaign. Let's go ahead and add in our matrix. We're going to click into the table and go to the metrics section. We're going to remove clicks. And we're going to add in cost. We simply TopHat cost and submit costs from all of the options that appear. Great. So we now see cost-sharing in non-metric column. We can see any dates again. And that's because the table is being sorted by campaign name. Let's go ahead and sort out table. By our cost. We click Insert Table, and we head to the source section of the table. We then select what we want to sort the table on. As you can see, it's being sorted. Bach campaign indicated by the arrow. Let's go ahead and tap hot cost. And we should then see some numbers up here. There we go. We can not see the cost per campaign sorted by cost. So this campaign is the highest cost campaign for the state period. Grades. Let's go ahead and add in the other metrics that we want to report sun, which is conversions. We now see convergence. And then cost per conversion. We now have all of our metrics in the table. You'll notice that the campaigns Paul bit hard to see, especially when the campaign names have the same starts. There's an easy way to fix this and that's by wrapping the text. Very similar. That's how you would wrap text in Microsoft Excel. Let's go ahead into the styling tab for that, we'll click Insert Table, and we'll hit over to the style section. We'll go and look for the table body. And we will choose Wrap text. That makes it a lot easier to understand. We can now see the full campaign name without having to drag the column all the way to the end to make it wide enough. Let's go through all the other styling options that we have. We can choose to change the header background, color. It then when it's dark gray, we can choose to change the font color and the header. We can choose to change the cell border color. Right now, as you can see, there's a very dark cell border color. Personally, I like lots of cell border color, but that's up to you and your preferences. Let's go to the style section and choose a lots of kind of for the cell border color. As you can see, we now have a lots of cell border color, but not too loud where we can't pick it up. Let's go back into edit mode and back into the styling. And let's add a border and bought a shadow. We're going to we're going to take border shadow. We're going to select our border color. And we're going to change the radius of the table that just rounds off the edges and RC. Let's see how that looks now. We can see our border shadow. Border color is a bit darker than before. And we get that Nasser rounded edge on our table as well. Let's go back into edit mode and see what other styling options we have. We can choose to change the size of the fonts. This will make the header font bigger. Let's have a keep it at 14. Sorry, at 12. We now see we can also change the size of the funds in the body. We can also change the color of the actual text in the table. So you're styling options are plenty. If you don't require these row numbers, you can choose to not have them. We'll have a choose to have them. And you can also choose to add heat maps. For example, let's say you once a heatmap for your column to the one, the darker cell colors to be the most conversions. And the lots of cell colors that to be the least for forming a campaigns. In relation to convergence. We can choose heatmap and you will then see some color. There are lots of color cells will be the least number of conversions or PR campaign. And the darker color cells are. The higher converting campaigns. Very nice to do your analysis. What we can also do is use a feature called drill down. And this will allow us to go a bit deeper into our campaign analysis. Let's go ahead and select Joe done. This then allows us to add other dimensions that we can drill down into. Let's choose Add Group. Then, let's choose keyword. Let's go into View mode. Now as you can see, because you've selected drill down, you get these two errors that appear when you hover over the table. If you click down, it will draw down to the ad group level and showed the metrics within each column. You see now how by clicking that, it now reports on ad group level. If you then want to go down to keyword level, you can simply drill down again. You now see it a keyword level. In order to revert back, you can reset or you can drill backup to add group level and then go back up to campaign level. Let's say you only want to see the ad groups from this campaign. You can simply click on the campaign and drill down. This will then only show ad groups from that campaign. For this just makes your reports a lot more interactive and useful. Well, you can do more analysis that rather than just seeing numbers displayed, you can actually dig down and dig into the numbers a bit more. Very handy for your campaign management and reporting. A final quick tip on renaming of metrics and dimensions. And this is not just for tables but for any charts. Because let's say you want to change the name of the dimension or metric in a table, one of the other charts. You can easily do this by selecting the dimension that you want to rename or by selecting the metric that you want to rename. That clicking on this little pencil icon to the left. You can click into that. And instead of merely having campaign, you can States campaign name. Let's say we then want to change a conversions to leads. Let's say that your claim talks in terms of leads and conversions. That being said, this sample dataset could be reporting on sales, but this is just an example. What we can then do is head to the metrics, click on the pencil icon. And it's hotpots sales, which will change its a sales. We then would need to change this metric to cost per conversion, excuse me, cost per sale. And then we now have our rename metrics and dimensions in our table. Which makes it a bit more sense to our clients as these are the metrics that they use when they communicate with you. So that's all we have, put tables and I really look forward to showing you add the charts in the upcoming lessons. 5. Scorecards: In this lesson, we're going to be going over scorecards. Scorecards are great way to get a quick snapshots of key metrics. And we are going to be using clicks, average click-through rate, and average cost-per-click and our examples. So we've made some space and our table here by dragging ITS and realigning the columns. And we're going to go to Insert and click scorecard. We'll click on our canvas. And you can see that we have a predefined metric of cost per conversion. You will notice that what scorecards you only have to select a metric. Because the scorecard is purely reporting on the metric in total. You can have a filter it, but we won't do that in this example. We're going to go and choose clicks. So right now we have a quick snapshots in a scorecard of how many clicks we've received for the month. We're going to go ahead and style it. So we're going to click on Style. And we're going to censor the heading. We're going to censor the metric value. And you'll see that there's an option for comparison. This comparison can be very useful. And we'll go into the data section and head over to this comparison date range. Right now you can see that it says none by default, the scorecard wine compare any date range. But let's say we want to compare the previous period to the date range that we are reporting on, which is the last 30 days at the moment. This will then reports on the previous period before those 30 days. So let's go ahead and add that in. You can manually choose your day trench or you have a predefined sets of date ranges. Yeah. Well, periods, we're going to choose previous period. If you choose previous year, it will compare it to the date range in the year before. We're gonna go and select previous period, however. And you can see now that it adds in a very useful comparison metric at the bottom. We're now going to quickly just add our border, our radius. And let's add some color. We'll click into the scorecard, it over to starling. And we'll change the background color. Let's change it to blue. You can see now though, that the black text doesn't look too grades on the dark blue background. So what we can do is we can change the font color to art. And now we have it where it's a bit easier to understand. Let's say you want to change the font color of the comparison metric. What you can then do is you can navigate to the comparison metrics, styling section, and click on negative change color. Right now it's set to a dark red. We can make it a bit of a lots or it. And they're just a bit easier to see in the darker background. If you wanted to do that. Well, the same with the increase. You can make it a lots of green. And we'll see an example of that increased now. So there we have clicks. Let's say you want to add another two scorecards in. You don't have to go and recreate this whole scorecard. You can simply right-click and copy, and then right-click and paste. You now get the other scorecard. And we're going to choose click-through rate. And there we go. We have another scorecard and a matter of seconds with another metric. And as you can see, we now have a metric where we've increased by 10.4%. We're now going to right-click and you can also go Control C and Control V. And we're going to choose CPC. And then we see the average CPC went down by 1.9%. The clicks went down by zero-point far percents, and the click-through rates went up by 10.4%. Let's just head back to the styling section. One option you can also have, as you don't have to have the comparison metrics reports on percentages. You can have them report on the actual value. So let's show the, show absolute change. Let's check that. You see how changes now, instead of reporting on percentage when we untick it, you can actually see the amount of clicks that you went down. But let's do that for average CPC. So you can see that it changes from percentage to an absolute change. Let's leave it at percentage for our examples. You can then see when you dragging these scorecards, that when this scorecard gets the same distance two away from the scorecard above, it's how there's two lands on the right-hand side of the scorecards that match up. This means that you are the same distance away for all three of the scorecards. And the red line in the middle shows that you are censored with all the scorecards. We can then drag our scorecards by selecting all of them at once and dragging them to meet the middle of the table, you see that red horizontal line. It's saying that we are now in the middle of the table. And that vertical red line on the right-hand side is saying then we are alarmed with the date range selector above it. What you can also do is you can make the scorecards look as if there were one big scorecard. So let's do this. In this example, we'll drag and select all of the scorecards. And we'll head over to the starling section. By selecting all of the scorecards. You Starling all of them at once. We want to remove the borders shadow and the borders. And let's remove the radius from this middle chart. Let's middle scorecard. You will see why in a short, but this is drag them all again. I just want to make sure that the border color on all of the image transparent. Okay, great. We now have our three scorecards with no borders and our middle score card that is simply square. We're now going to drag our score cards into each other to make them look as if they were one. Great. So now we have three scorecards that look like they're one, but they're a bit or too close together. There are things a bit hard to understand and that would defeat the purpose of having an easy to understand dashboard. So let's resize them. Let's drag this one slightly down and drag it to the bottom. That just gives a bit more spacing on the bottom. Let's do the same for this middle scorecard. So to drag the bottom and make it longer, we simply just hover over the middle dots and drag the score card down. Let's do the same for the scorecard. And then let's drag them into each other. So that looks a bit better. But let's just make this one a little bit longer. Drag this one in. There we go. That looks much better right now that we see the padding on the bottom is not equal to the padding on the top of this scorecard. So what we need to do is we need to increase the padding on the top of the scorecard. How we do that is we click on the scorecard on its own. We'll go to the style tab and we head down to the padding section. Padding. We're going to increase the top padding. Let's try 16. That looks much better. It's going to drag this one slightly down. That looks perfect. We're now going to select all of them and just align them to the middle of our table, we get that red horizontal line and that right-hand side vertical line showing that we're aligned with our date range on the top. And then we have three scorecards that look like they're one big scorecard. So that's it for scorecards. And I look forward to showing you other charts in upcoming lessons to make your Google Ads report seeing that much easier with Google Data Studio. 6. Pie Charts: In this lesson, we're going to be going over part charts and some use cases for pie charts for Google ads reporting. In our example, we're going to be reporting on conversions by DeVos category. So let's head over to insert. And we're going to select our chart. We're going to click on SARC Canvas and will be presented with the pie charts with some predefined dimensions and metrics. As you can see Google Data Studio as US campaign as the dimension and clicks as the metric. We're going to go ahead and change both of these. We're going to click into campaign. And we're going to tarp and diverse. You'll see that you don't have to type in the full name of the dimension. You can only tap in the first few letters of it. And whatever starts with these few letters will show. We'll click the bus. Will then change our metric. We want to report some the conversions, but a vast category. So we will look for conversions. And there we go. As you can see, we now have a pie chart showing the percentage of conversions by device category. So as you can see, mobile devices are reporting Nancy far 0.8% of conversions. There's other use cases for this as well. Let's say you want to report on the number of clicks. By DeVos category. You can go Control C, or you can go right-click, copy, right-click and paste. And then you'll just change the metric name, the clicks. And you can then see that 76 percent of clicks have come from mobile devices. Boss 96% of the conversions have come from mobile devices. So this is just another example of a, of a use case for pie charts. Now, little bonus tip is that you don't have to have multiple part charts to see different metrics. You can use a feature called optional metrics. Let's go ahead and delete this. We'll click into our original pie charts and will enable optional metrics. This adds another section where we can add optional metrics that we can report on. So let's say we want to use one part chart to report on conversions, clicks, and cost. We can now and clicks. And we can add cost as optional metrics by selecting this. It now shows this feature here that when we go into view mode, we can click into and we can change the metric that we want to report on. Right now by default, it's reporting on conversions because that's the first metric we've chosen. But if we want to report on cost by device category, we simply go into cost. And you can see that departure changes according to what we've selected. If we want to do clicks, we simply select clicks. So this is a nice way that you don't have to have multiple part charts that take up a lot of space on your Canvas or your reporting dashboard. And you can simply a one part charts that reports on multiple metrics. And you can do this for many other charts as well. Let's go ahead and see what styling options we have, our pie charts. We're going to click into the pop charts and head to the style tab. You can see that we can change the coloring of the part trucks are single color and we can also change the color. Let's do the darker blue. You can now see that the biggest glasses have the darker color, whilst the smallest classes have the larger color of the color that you've chosen. I like to make my pie charts a bit of a donor charts are failures, looks better, but this is a personal preference. You can also change the labeling to a value. So instead of your pie charts having the percentage of conversions, you can show the value of the conversions. So that just changes it to the actual number of conversions or clicks or the actual cost. We will leave it at percentage for now. If you want to change the positioning of your legend, you can choose to not habits. Have it on the rats, can have it on the bottom, or you can have it on the top. I like to have mine on the top. Especially in this scenario, we are marked want to put another charge here an hour then have the legend of that chart as well on the top. You can also change the font color of the legend. We'll keep our that black. You can also then change the number of classes. So let's say you have multiple devices. Let's say there were eight devices for example. Or let's say you're reporting on browser tabs. Let's go ahead. Let's char region. So as you can see, this part chocking get a bit messy because there's multiple different regions that have led to conversions. What you can do is you can limit it and only show the top five regions by conversions. You can see now it only shows fab slices and lumps or other regions that are not in the top 42 others. This is a nice way to make your, your pie chart easier to understand. And just limits the slashes if there's lots of different regions or a categories that you are reporting on. We'll go ahead and change this back to DeVos. And then we have our pie chart reporting on the number of conversions by the bass category that using optional metrics to maximize the usage of our pie charts on our Canvas. So I hope this helped you understand the use cases for pie charts and Google ads reporting. And I look forward to showing you how to maximize the usage of other charts. In our next lessons. 7. Column Charts: In this lesson, we're going to be going over column charts. And in our example, we're going to be reporting on cost by region. So let's go to the Insert section and select column charts. We'll click it into our Canvas. And we will resize column charts fits into this section, next chart, pie charts. And below our table, you can see that we have a predefined campaign dimension along with clicks as the predefined metric, we are going to have a change these to the metrics that we require reporting on. We're going this, select the dimension, top and region. And we're going to change the metric, the cost. And in this use case, this could be our clients. One thing, an easy to understand reports or charts on which regions are being attributed the most spend in the accounts. This gives them a very quick overview. Let's say we want to add in the actual numbers above one, the boss. What palette to make it even easier to understand. We can go to the styling tab after clicking on our table, Our column chart, sorry. And we can then select this Bateson very data labels. Once we click that, you can now see that the values of the cost above the columns, which is very helpful. Then personally like to have no grid lines. And I'll show you how to change those. You can choose to make them lots. Dr. they go very faint there. Or you can choose to have them transparent. You can also change the color of each ball, all the bonds and title. We can make them a darker blue. You can choose to compact the numbers. Let's say these numbers up but see cramped and you want to make them a bit smaller. If you click compacts, it makes the members fits into bit better. You can change the fun SaaS will keep us at 12. Let's see if we make it smaller heart, but let's keep it at 12. You can also then, here's to not have the legend. So let's say you are going to be having a hitting him. Let's insert text. We can name it costs by region. If we have this heading, it is pointless to maybe have this cost label that will go into styling and remove the cost legend. Because we already have the heading on the table. So now we have our table. Some other use cases. I'll maybe you're reporting on country by cost. You can see that United States and Canada, but will revert back to our region. If you wanted to refine this table and your client only wanted to see the top three regions by cost. You can also limit the amounts of column shown on your column charts. Let's click into our table in kind of the styling section. And we then just limit the amount of bars that are shown in the table. Lists will then show the top three regions by cost. If you wanted to top five, you just increase it's above. Another grades and more advanced feature we'll use and column charts is the drill-down feature and draw up feature. So let's have a look at how we can use that within our column charts. Let's say we want to have this column charts reports are not only region but also country. And we don't want to have multiple column charts. Let's then go and increase this back to 10. And then go NCBI data section. What we then want to do is we want to enable the drill-down feature. Let's look at this in view mode quickly. So you can see that rock now when we hover over the charts, we only get the sort feature. There's no arrows to draw down or draw app because we haven't set up the lab for drill-down feature. Let's go back into edit mode. We'll select our table, and we will select drill down. We will then add country. And we'll bring it to the top. And we'll select our drill-down level to be country grade. So you can now see that it's reporting by default on country. Let's go into view mode. We now see that when we hover over the column chart, we see these two errors. When we hover over the down, It's States drill down from Country, Territory to region. Let's click the drop down arrow. You will see that a now goes further into the region, which is very handy instead of having multiple column charts and just having one column charts to report on. Cost by country and cost by region. Let's draw backup. Another thing you can do is you can choose to only select the United States. It will click United States. It highlights the United States. And when we drill down, it'll only show regions from the United States. Let's drill backup, and let's select Canada and drill down. We then only see regions from Canada. This is a powerful feature that allows you to maximize each column charts and each chart for that matter. Instead of having multiple charts to do the same reporting. So that's it for column charts. And I hope you are able to use these new skills and learnings in your own reports. And I'm looking forward to showing you other features on other charts and our upcoming lessons. 8. Time Series Charts: In this lesson we're going to be going over Tom series charts. And I'm going to show you two use cases for your Google Ads reporting. So to kick off, we're going to go to Insert and we're going to select the very first chart, the time series chart. We're going to click into our canvas and will be presented with a time series chart with some predefined dimensions and metrics. You'll notice that the dimension can only be a time-based dimension because at the time series chart, you can choose to have your time series reports on month, day, hour, day, week. For our example though, we're gonna do today. Because in this example we're going to be reporting on the average cost per click for the last seven days. This is a good use case. If you have a client who likes to see and be kept up to date with their average cost-per-click for the previous days. And instead of sending them in Excel sheets each day, you can simply send them this dashboard where they can see the, the average CPC for the last seven days. And an intact of dashboard. Much easier than downloading an Excel sheet from your Google Ads accounts and sending it over to them each day. So we're then going to change our metric right now it's reporting on conversions, which is also quite handy and quite useful for your clients. But we're going to do CPC. We're then going to make it a bit smaller. And then what we're gonna do is we're going to change the date range. Right now. The default date range for the entire report is set to the last 30 days where they're going to make this report, specifically reports on the last seven days. And we'll add in the header saying average CPC for the last seven days. How we do that is we click on the time series chart. We then go Custom and we select the last seven days. For example. You will see now how we only reporting on the last seven days, which is different to these charts that are reporting using the default day train sets for the last 30 days. So that's just an example of how you can Keynes a tri-state range for a specific need. We're then going to go in and we're going to remove these reference lines. And we're going to add in some values to the time series chart. Let's remove the reference lands first. We're gonna make them transparent. And again, this is up to you and your personal preference of styling. We're then going to add a quick border shadow and a border. And we will round off our edges. So now we have our time series charts reporting on the average CPC for the past seven days. Let's go ahead and add in a heading. Will then reposition it just above. Great. Now what if you want to see the actual numbers on the time series chart? There's an easy way to show that you're clicking to the time series chart. Go into styling and you select show data labels. Now you see the actual CPC for each of the days. You can also choose to show the points which will add points to each day, makes it a bit easier to read. And you can also change the color. Let's say we want to make ours a dark LAN. You can change the thickness over here. We'll keep ours APSU. And you can also add a reference line. Now this is a, a bit more of an advanced feature of the time series chart. But let's say your clients aims to keep your average CPC at $1.40. What you can do is you can add a reference line. You can make it a constant value, and you can tap on $1.40. That thing gives you an ever-present lion. And it shows you when you've gone over that target CPC or under it's, this can be good for sales required each day. For example, if you're reporting on sales on your time series chart or cost, for example, if you have a daily budget of a 100 dollars a day, you can set your reference line at a 100 dollars a day and then see when you go over and underneath it. We can also customize it. We can name its target CPC. It then changes the name. We can choose to show the label or not show the label. So when you de-select it, the labeled disappears. When you select it. The label shows. You can choose to also then change the color of it. Let's make cars blue to match the rest of the chart. And you can also make it a solid line or a dotted line, or dashed a we as previously. You can also change the thickness. Let's leave us at CSU. It's quite nice to have a faint line, but noticeable at the same time. So let's go into View mode and have a look at our time series charts. So as you can see, you or your client cannot easily monitor your average CPC based on the past days. Instead of looking into your cans, downloading an Excel sheets and sending it to your clients. This is a whole lot easier. And a very good use case for your Google Ads report saying, I'm going to show another quick example of how you can use the time series chart. Let's say you want to report on accumulates of time series chart and sort of each day. The specific value for each day. You want to see how the revenue clamps, for example. So let's go ahead and add in another time series chart. And let's say we want to see the cumulative revenue for the past seven days. What we could even do it as reports on the cumulative cost. But let's keep it to revenue. We're going to change this today because we want to report on the past seven days. And we want to change this. The total conversion value, which is the metric that you use to show the revenue brought in. And we can then going to change it to a custom date range of the past seven days. Great, so now we have our time series charts, but it's reporting on the value for each specific day. Let's just make our reference lines transparent. And we're now going to change a setting in here to make it cumulative. So you'll see one sweet sec versus cumulative selection. The land is going to grow each day. We're then going to choose to show the points and show the data labels. You now see that the chart reports on the total value building upon each day. It's very handy to see the total revenue brought in over the past seven days and each day has deferred revenue hours. So that's another great use case. And we can then just copy and paste bar and control C and control V. And we can name this cumulative revenue for past seven days. Great, so there's two great examples and use cases for Tom series charts. And I look forward to showing you other charts to use a new Google ads reporting in the upcoming lessons. 9. Geo Charts: In this lesson, we're going to be editing a geo chart. And it's going to show us the cost buck country. So let's go ahead and Insert and select Geo chart. This is gonna give us an OS map that'll visually show the metric that you choose and dark colors. So let's go through an example. Retina, it's reporting on the average CPC dark country. So if we go into view mode, we'll see that it's showing the CPC for Canada and the CPC for the United States. The CPC Canada is higher than the CPC in the United States, so it's a darker blue. We have a one to see the cost or the amount we've spent on Google ads in each of these countries. So all we need to do is change our metric to cost. We then see how changes do not sit states now grabs DACA, and that's because the accounts has spent more than the United States over the date range. Let's go into view and HAVA of each country. So we can see that in the United States, we've spent almost $10 thousand. But in Canada we have spins around $3.5 thousand. And those are the only countries that we've spent. Since gives us visual overview of your metrics that you choose. If you have more campaigns running in other countries, more of these countries will be colored and you can reports on conversion, sales, conversion value, or revenue. It's just a nice way to look at geo-location. And the nozzle visual way. Just some styling options that we can do. We can change the color and change it to purple, for example, will keep us at blue. And you can also change the mid color. So then if you have more countries that have spent the middle ranges will be a yellowy color. But it's always best to keep the colors in the same kind of color codes. But just a little bit lotsa. We can see the darker is high value and the lotsa color is the lower value. Let's look at another use case. Let's say you only want to report on regions in the United States. So you only want to see the United States, yeah, but broken down by region, by spanned. Let's go ahead and change our dimension 2 region. We will then leave our cost as the metric. And we'll simply then zoom in on United States. We're getting era. But let's just refresh our data. Great. We now see each state broken down. And we can see that the highest spending states, all the darker color. If you hover over a state, you'll see the cost because that's what we report saying on the mid-range spenders. A bit of a lotsa color. And then the low range spenders all the lotsa. Just. So another great visual way to see spin by region. Instead of looking at a table in Excel sheets, this is a lot easier to understand and interpret. We'll revert back to our original example. We will choose wild. We just reverts it back by pressing the Undo button. And we'll leave it looking at the whole world. This could show, for example, countries we not targeting and possible in new markets. So they, we have pie charts based on cost. Very useful and handy for you. Google Ads report saying, I look forward to showing you other charts like this in upcoming lessons. 10. Treemaps: In this class we are going to be going over treemaps. In this example, we're going to be reporting on the top search terms by cost. Search terms, as you know, are keeping to monitor and the Google Ads account. And this is a nice way to show the top five or top 10 search terms in your count by spend, costs, by conversions. So let's go ahead and add our TreeMap. We're gonna go to Insert and we're going to look for TreeMap. We're going to click Treemap and click into our Canvas. And we see our predefined dimensions and metrics. This is reporting on total conversion value our country. Now let's just go to you to see how this example Lux. We can see now that the big block United States, has brought in $2200 worth of revenue. In Canada, which is this very small block, has brought an $81 of revenue. So you can see that the block size is proportionate to the metric value. Let's go ahead and change our dimension to the texture. And then let's change this to cost. We can now see all of the different search terms bar crossed. The bigger the block, the more spend the search term has attributed to it. You can see YouTube emerge is the most popular search term, followed by YouTube merchandise us. And then how to make merch for YouTube. So as you can see, very popular search terms around YouTube merchant us. Let's say that we only want to see top 10 search terms. Now this is a good example. A lot of the time our clients might want to see the top 10 search shows because they know how important they are. And instead of sending an Excel sheets every day or every week or every month for that matter. They can have access to those insects have dashboard where they can see it in their own browser without having to rely on you to manually send it. So it's a very, very powerful tool. What we're gonna do is we're going to go into the style section. Sorry, we're gonna go to the of section. And we're gonna, we're gonna change the total number of rows. Let's say we want to do the top ten search terms. Let's select 10. And that will only presents in blocks. You can now see the top 10 search terms by cost. Let's narrow it down further to the top five. So there we go. As you can see, in a very quick view, you see your top five search Germans by cost. If this, for example, is any relevant search term, you can very easily pick it up and add it as a negative keyword. Let's go ahead and style it a bit more. You see that you can change the color. We can make it a dark gray. We can choose to show the branch header or not show the bronchi setup. You'll see when our anserinus, the header will disappear. And you can also choose to not show the scale. Let's make our TreeMap the blue of the theme. And we will leave that Bryan Shader and scale art. We can then add a border with our standard border shadow that we have for the rest of the report. And there we have our tree map showing the top above your search terms. Cost. Again, let's say however you want to use optional metrics and you don't only want to reports on cost. Let's say you also want to report on clicks. And so it's what conversion value that you don't want to have multiple treemaps? Well, like we discussed in a previous lesson, you can also then do a feature called optional metrics. Let's click entire TreeMap and click optional metrics. We then get this optional metrics, but in showing and we can add an additional metrics. Let's start from the clicks, which will most likely be proportionate should search terms. And let's add an auto conversion value. It's going back into view mode. Now you'll, your clients can baseless reports on other metrics. Let's say we want to see the top search terms by conversion value. We now see interestingly that although YouTube emerged was the most popular search term, it hasn't brought in the most revenue. In fact, the top search term by ribbon, you don't include YouTube in them at all. So this is a sound that you might need to maybe lower the bids on those search terms and up the bids on these search terms. But again, you would have to take into accounts. You'll row as you average cost-per-click to make that decision. Let's say, hey, ever that you don't just want to report on cost on this tree map. You also want to use it to report on revenue, the top pop search terms by revenue, for example. You can then use optional metrics. Let's go ahead and click on our tree map and select optional metrics. This will then enable this optional metrics Batson and cause the tissue. We can then, under our optional metrics section, add in the metric total conversion value. We will then go into View minute. Now as you can see, it's reporting on cost. However, if we click this optional Metrics button, we can choose to reports on the total conversion value. As you can see quite interestingly, although YouTube emerge with the most search terms by cost, we can see that sheep graphic tees, vintage clothing, and custom sweatshirts are the top three search terms by revenue. Now this is a good example to show you that although YouTube immersion das was driving a lot of searches and possibly clicks, because there was dropping in the most cost, not bringing in the most revenue. So that's something that you can go in and analyze within your accounts. Wherever, for example, going to disable optional metrics and simply reports on the top, top search terms by cost. When we go and disable this button, this optional Metrics feature will disappear from our charts. And we wind see that total conversion revenue anymore. This thing concludes our lesson on treemaps. 11. Access, Sharing & Layout: In this lesson, we're going to go over sharing your report, providing access to your report, and also changing the actual canvas layouts of your reports. So in order to share your report, you can simply click on the Share button where you'll be able to add e-mail addresses. And then the level of access that you want those email addresses to have. You can select, notify people that when you press send to provide them access, that they get an email notifying them that they've been added. Other ways that you can share your reports as you can download it as a PDF. You can schedule E-mail delivery. You can send a report link. Let's have a look at schedule E-mail delivery. You can choose to send people an email with the reports daily, every weekday, Monday to Friday. Or you can do a custom schedule on. So those are some handy ways to share your reports. Now, we want to change the actual layouts of the canvas on the reports. So you can see that we have a very big gap from the edge of the reports. And at the last chart. Let's go in and click the actual canvas of our reports and select layout. We can then choose to lessen the hearts. Let's try one hundred, seven hundred and see if that works. We close. One hundred six hundred, little bit closer. Let's try 16, 50. And that looks a bit better. If you wanted to change the width of your reports. You can simply change the width. So that's an overview of sharing your reports, providing access, and then also changing the basic layout of the canvas of your reports. 12. Class Project: For your class project, you're going to create your own reporting dashboard using the charts that we've gone through in these lessons. But you can tweak your trots using different dimensions and metrics. There's nothing that beats practical experience. So highly recommend you go through this project and then one standard uploaded as a PDF to the project gallery, where I can provide feedback and answer any of your questions. Thanks so much for going through with my class, and I hope that everything you've learned some as clause can be taken sword your account management on a day-to-day basis and make your role as an account manager that much easier.