How to use Google's Data Studio to create better SEO reports for your clients

Steps to create better SEO reports with Google's Data Studio

Google Data Studio allows you to create interactive dashboards from different data sources.  
You can integrate data from Google Analytics, Google Adwords, Search Console, Bing Ads, Facebook Ads and 100+ other sources. 

The advantage for clients is that they can just log in to this one place to see all the data. 
It can also be updated (manually for now) in real-time, so they never have to log into any other websites anymore.

There are also custom templates which you can use to easily show your websites audience overview, 
how they were acquired, their behavioural patterns once they reach your website etc. 

I've detailed below how you should go about setting up Google Data Studio to use for creating better SEO reports by integrating with your Google Analytics account. 

Step 1: Sign up for Google Data Studio. 

Go to https://datastudio.google.com and sign in with the same email address that is attached to your Google Analytics and Google Adwords accounts. 




Step 2: Connect your Analytics and Adwords accounts

Click on Data Sources, and then on the + icon on the bottom right corner. 
If you are doing this first time, just follow the steps and grant access and accept their terms of service, and click 'Done' when complete.


Once that is complete you will be taken to a screen which shows you all the possible sources you can pull data from. 
Connect all the data sources you choose. If you are looking at SEO primarily, you only have to connect Google Analytics.


Once you select 'Google Analytics' - just follow the steps to authorise data studio to connect to your Google Analytics account. 
The choose the account, property and view of the specific campaign you want to pull data from - and then click on 'Connect'.




Step 3: Create your Report

Click on 'Create Report' on the top right column, and then follow the steps to connect Google Data Studio with your Google Sheets account. 


Now that you have imported and connected your Google Analytics account with your Google Data studio, you can easily add charts to the dashboard.

Click on 'Add a chart' and choose the ones you wish to display. 


Once you select one, it will be displayed on the dashboard. You can select multiple charts showing different parameters. 

Although its tempting to add many charts to a page, it's best to add only one chart to one page, and a small description telling what the chart is about. 
For example, this chart shows the page views split by the acquisition channel for the last 1 week. 
This makes it easier for your client to digest the information easily. 


Then, add more pages by clicking 'Add New Page' on the top left column.
You can then add a new chart on this new page which show other metrics which are important to your client. 

Explore the tabs on the right, to get more flexibility on which metrics to include in each chart. 

Also, play around with the 'Explore' tab to see all the information thats available for you to include. 


Step 4: Using Custom Templates

Google also has many custom templates which you can use to show the data visually. 

Click on the Data Studio logo on the top left to go back to the main dashboard. 


On you are there, click on 'Report Gallery', and then on 'Marketing Templates' 



You will then see many options to choose from, and once you select one template - you can integrate your data by clicking on the top left dropdown and selecting the property. 
You can also change the dates according to what you want to display. 

The make a copy of this report by clicking on the top right, and then click on 'Create a new report'



This will then open a copy of the same report in your personal data studio account.


Step 5: Sharing the data with the client


There are many options for you to share this with your client. 
You can embed this into your website, or you can share all the pages you have created as a PDF, or share a public link to this report.
You can even add people to this account and give them direct access. 

This is an easy way to add more visuals and interactivity to your SEO reports.


Recent Blogs