Google Search Console Data Studio Template

Google Data Studio Template for Search Console 13

Hello everyone. Welcome back to our Google Data Studio now known as Looker Studio series of tutorials. In this tutorial, we will learn to set up Google Data Studio Template for Search console using a third-party connector from Porter.com

Today, we will learn how to set up an on-page SEO template for the search console in Google Data Studio.

We are using a third-party connector here, you can copy the template from here and then copy the report to get started.

The report is already been made as a template we will take this as a copy and will edit it fully, we will change the metrics, dimensions, dates, logos, icons, color themes, and everything we need to change to make a more personalized and customized report for our client, employer, or for our own business.

Importance of Search Console template for Data Studio

We have to run so many things in a single month, for example, if you are working in an organization, you need to make so many reports for each campaign and you need to show all the aspects, the digital marketing campaign insights, the SEO insights, social media insights, paid vs organic channels insights, and so on. So, to manage so many things we need to have some pre-made templates that help us y saving our time and effort, having a good pre-made template helps us to focus only on the metrics, dimensions, and customization of the report as per the brand or business theme.

Today we have a third-party connector from porter, and we will use the Search Console to add and then customize this template for free. It’s a free template and its public means that we can copy it and take all the authority to change the data source, colors, metrics, dimensions, custom fields, charts, design, and overall layout of the file, and then share them in the restricted mode to only people who authorizes to see or edit the report. So this is why we need a Google Data Studio template for Search Console.

See also  How to Use Conditional Formatting in Google Data Studio

How to use Google Search Console Data Studio Template

There are simple steps only to get and then set up the Google Data Studio template for the search console. We simply need to visit the above link to copy the template, and then it’s all ours. We will customize it by any means, we will change the design, and we will cover everything to make it a fully personalized version for our client, boss, or ourselves. Let’s start learning to set up the Google Data Studio Template for Search Console.

Import Google Search Console to Data Studio

In this section, we will learn how to set up a Google Data Studio template for search console and install the Google Search Console in Google Data Studio templates. This tutorial will help you to set up Google Data Studio On-page SEO report template with Google Search Console data, we will end up making a report as I referred to above in the link.

When accessing a Google Data Studio template, open the report and then click the copy icon located in the top-right corner of the page.

Step 1

Open this link to get the Template

Google Data Studio Template for Search Console 1

Step 2

Authorize the Google Search Console for your report on the left side first drop-down button in the report.

Sign in with your Google Account and select the Default option

Google Data Studio Template for Search Console 2

Google Data Studio Template for Search Console 3

Google Data Studio Template for Search Console 4

Step 3

Click on the copy button on the top right side of the report, or inside the three vertical dots in the same position.

Google Data Studio Template for Search Console 5

Step 4

A pop-up window will appear. The pop-up shows you the actual data sources of the template and the new ones that need to be added.

Google Data Studio Template for Search Console 6

Here, this template requires two data sources (we can use sample data sources as well)

Click the dropdown menu of the first data source in the New Data source section and select a data source, then do it for the second drop-down as well and select another data source.

Google Data Studio Template for Search Console 7

Note: If you don’t have a website then you can use sample AdWords, YouTube, or Analytics data to practice. You will have a lot of data sources to connect with. If it’s your first time using Google Data Studio, then you will have to sign in or sign up with a Google or G-Suite account.

Pro Tip: Google Search Console connector has only two instances: one is URL and the second is Site.

Step 5

After you’re done with all the settings, now you simply need to Click on Copy Report button

Google Data Studio Template for Search Console 8

Step 6

The report will open in a new tab, you can rename the file and now it’s all yours, you can still change the data sources, the colors, the customization, charts, controls and filters, and everything you can see on the report.

Google Data Studio Template for Search Console 9

Now in the next section, we will customize the report and make it a fully new report from scratch.

Google Data Studio Template for Search Console – Personalize the report

In this section, we will learn to set up Google Data Studio Template for the Search console and to personalize the report in our account. So firstly, the reports look like this as you copied them from the porter source.

Now it’s totally up to the user what personalization they want to do with this report.

So, I will show some general customization that can be done mostly after we import some kind of template in Google Data Studio.

Now as we are started with the template, the first important thing is to set up the data types

Step 1

Go to Resources > Managed added data sources

Go to Edit and change the data types where needed.

Google Data Studio Template for Search Console 10

Note: Step 1 only works if you have genuine website data on your report, if you are using sample data for Google AdWords, YouTube, or Google Analytics then you can skip this step.

Now, we first need to change the colors of the overall report

Step 2

Changing the colors of the report as per our brand colors

Let’s say my brand colors are orange, sky blue, and black.

To do this. Select the element, and then go to the Style tab inside the Control Sidebar

Google Data Studio Template for Search Console 11

Google Data Studio Template for Search Console 12

Pick a text color from the Font color dropdown, then scroll down and pick a fill color, or background color from the background drop-down.

Google Data Studio Template for Search Console 13

Google Data Studio Template for Search Console 14

 

Then below, you have a border color drop-down from where you can select a color for the border.

Google Data Studio Template for Search Console 15

Step 3

More properties of borders

Just below the background color drop-down, you have a border-radius drop-down, here you can set the rounded or sharp corners for your border in pixels.

Google Data Studio Template for Search Console 16

Then just below it, you have another drop-down for the border fill opacity, you set the opacity level from 0% to 100%

Google Data Studio Template for Search Console 17

Below you have a drop-down for border weight, you can set the thickness of the border here

Google Data Studio Template for Search Console 18

Then, another drop-down for the border style, here you can select Solid, dashed, dotted, or double style for your border.

Google Data Studio Template for Search Console 19

Step 4

Changing the brand logo image

To change it, select the already added logo on the report, then in the Image properties sidebar, you can click on the Image file button and choose a new image to add as your brand logo

Google Data Studio Template for Search Console 20

Google Data Studio Template for Search Console 21

Step 5

Removing unnecessary elements. To remove any element, simply select the element and press the Delete key from the keyboard

Google Data Studio Template for Search Console 22

Step 6

Adding new filters and controls as per your need. Go to Add a Control button > Select the type of Control you want to add > click on it to add to your report.

Google Data Studio Template for Search Console 23

Then you need to set it up by adding a dimension and a metric to it

Google Data Studio Template for Search Console 24

Step 7

Removing unnecessary or invalid metrics and dimensions. If you see any element with an error, (it shows a setting icon and a “Show details” text), remove it by selecting and pressing the delete key or if you want to keep them you can change the dimension or metric to remove the error.

Google Data Studio Template for Search Console 25

Step 8

Create new charts, and remove the unwanted charts

Google Data Studio Template for Search Console 26

To create new charts, click on the Add a chart button, and then select any chart from the list to add to your report.

You can also go to Insert > then select the chart from the list

Google Data Studio Template for Search Console 27

Step 9

Set up your new metrics and dimensions on already created charts. To change the metric, select the chart and go to Dimension in the Setup tab, click on it and pick a new dimension from the list.

Google Data Studio Template for Search Console 28

Below it, you have the metric section, do the same to change the metric.

Google Data Studio Template for Search Console 29

Important Notes

  • You need to have a website to use the search console template.
  • When you don’t have a website, you can practice this template over a sample data source
  • When authorizing Google Search Console to install it to Google Data Studio, select the appropriate google account on which your website is created.

See also  How to Create a Leaderboard in Google Data Studio [Guide 2023]

Frequently Asked Questions

Can I use Google Analytics Data on Search console template?

Yes, you can use any data on any template, but the thing is very simple, the template is designed for the Search Console so the Search console data will work accurately on this template, but not having a website and using a sample data source on this template will also work fine. It’s valid and legit to use any data source on it including Google Analytics data.

Conclusion

So this was the first template in our Google Data Studio series. We learned to set up Google Data Studio Template for Search console. I also emphasized the customization and personalizing options after importing the template on your account. This was a complete guide, and I hope you like it. If you find it useful, please like and share your query below in the comments. Thanks for reading. Keep learning with Office Demy.

Content Protection by DMCA.com

M. Shaiq Ansari

Hi, I am Shaiq. A young and self-motivated content writer having years of experience expertise in MS Office suite, Google docs Editor Suite. I have a technical education background that empowers me to stand out in today's digital world. I am currently a freelance content creator and a part of a local digital marketing agency in Karachi Pakistan.

OfficeDemy.com
Logo
Enable registration in settings - general