How to Use the SEO Audit Template in Google Data Studio

This article describes how to use a technical SEO audit report template in Google Data Studio based on data from Netpeak Spider. The report provides visualizations of important audit metrics and allows you to filter the data.

To use a template for your project, copy it and connect your data source. Below is a step-by-step guide of how to do this.

Anyone can use this step-by-step tutorial, but it would be best to have a basic knowledge of Google Data Studio.

First you need to create a Google Data Studio account (free).

How to copy a template

First, you need to prepare the data that you will load into the report.

If you are new to Data Studio, we recommend crawl the website in Netpeak Spider with all parameters switched on in the sidebar. Then the export will have all the necessary parameters and no errors will occur in the template. If you are already advanced Data Studio user, you can disable some parameters, but then edit or delete elements in the template, where errors will occur.

The template uses two reports from Netpeak Spider: "Parameters for Google Data Studio" and "URL and their issues". They must first be exported from Netpeak Spider in order to import them into the template.

The easiest way is to export data to Google Drive, because it is then easy to import files from it into Data Studio. But other formats can be used as well.

Here is an example of export settings in Netpeak Spider:

To export a report from the program, first select 'Parameters for Data Studio' in the export menu.

Then, in the same Export menu, in the "Special issue reports" group, click "URL and their issues".

Next, you need to copy the report template and load the data into it.

In the template, click in the upper right corner on the menu and there select "Make a copy".

You need to connect a new data sources. These are the files that we exported at the very beginning.

An example of creating data sources from Google Drive will be shown below.

To connect the first file, click on the name of the first new data source and select 'Create data source' in the drop-down menu.

In the new window click on the appropriate source. In my example, this is Google Sheets.

Then select a connector. You can use the search form.

If your file is not in the search (this sometimes happens), then click on the 'Open from Google Drive' item in the left menu and find your file in the window.

After selecting a connector, click the 'Link' button in the upper right corner.

Then click the 'Add to report' button in the upper right corner.

Repeat the same steps for the second file, so that in the end your new data sources are error free.

And then click "Copy report".

That's it, your data has been added to the template. Now go through all the pages of the template to make sure that the diagrams and other elements are working correctly.