Data Studio is a great way to join SEO data from different sources into beautiful, comprehensive report panels. If you’re already using it, you’ll be glad to know that we’ve just launched a connector for Advanced Web Ranking. Tada! 🙂

Google Data Studio Integration with AWR

This enables you to extract 世界杯滚球平台 Visibility metrics automatically from AWR projects and upload them directly to your GDS reports.

Requirements on the specific metrics and dimensions made available came from Ian Macfarlane , Head of SEO, and the team at Digitas UK . They’ve been working with us for a few years, and brought a strong contribution to this project drawing a clear picture for an efficient data integration.

In this article, you’ll learn how to set up the Data Sources, what are the differences between the Report Types available from AWR, and you’ll also get a peak at some SEO report samples that were built by awesome AWR customers who were on board of our User Testing program.

So let’s see how it works!

Easy setup

advanced web ranking, google data studio setup.

The GDS connector is available through 世界杯滚球平台. Hence it’s accessible to all AWR users with Agency subscriptions or higher, as well as to all subscribers of a yearly AWR plan .

You’ll notice there are three project filtering options when creating the new Data Source:

  • Project name (exact match) – this option is recommended for SEO teams that associate each customer to a single AWR project.
  • Project name (partial match) – this option is dedicated for teams that manage customers with multiple Business Units in separate projects, and need to report visibility data under one roof.
  • Project tag – this option is built for SEO directors, fetching data from multiple AWR projects that are grouped by tags for each team in charge.

When it comes to mapping, it’s important to define the aggregation method for each metric exactly as you want the values to be further shown in the GDS report.

The metrics available from AWR come with two aggregation methods by default:

  • Average –  used for Visibility percent , Click share and Average rank .
  • Sum – used for the Visibility score , Estimated visits , as well as the rank position distribution and changes metrics.

For example, if you have a weekly updated project and look at a GDS report across 30 days, the Average metrics will show values computed as arithmetic average across the update dates available within this time interval, while the Sum metrics will show values that add up together the numbers recorded on each of the updates available.

Report types

There are two types of visibility reports currently available with the AWR connector:

  • Visibility multiple dates – showing the website’s organic visibility trend across the multiple dates in time chosen for the report. Check out a multiple dates report sample here
  • Visibility date comparison – for recurring reporting, showing visibility at the current date (or any other date you prefer) as compared with another date in the past. You can find a report sample of this visibility report here.

When setting up the widgets, you can choose from a large set of visibility metrics to upload, across multiple dimensions, depending on the type of reporting you are going after. The samples we built take data from one AWR project, with multiple websites, search engines and keyword groups that can be refined on-demand directly on the GDS side.

Visibility in Time - GDS

You can find the complete list of SEO metrics to track in the feature documentation page .

Report Samples

As promised, here are the reports that were built together with our customers taking part in the User Test project.

Note that the actual values shared below do not represent Customer Data. They are retrieved from an AWR test account.

Keyword Changes Analysis

Keyword Changes Analysis - GDS

This report page was built by Steve Ollington , Search Engine Strategist Global Services at VMware .

The focus is on the search visibility performance with positive vs. negative trends in time, for the keywords set monitored with AWR. The KPIs at the top sum up the values recorded for each ranking refresh that was performed across the time interval on the report, which are listed on the table below.

The time interval can be changed in the report on-demand. When doing so, the AWR stats will be refreshed accordingly in a few seconds, up to a few minutes (depending on the amount of data to be processed for the new date range selected).

The full report that Steve has created includes KIPs and granular keyword & landing page data also from Google Analytics and Search Console, on separate pages.

Competitor Visibility & Estimated Traffic Analysis

Competitor Visibility & Estimated Traffic Analysis - GDS

This report was built together with Bogdan Mitrache , Head of Product at Advanced Installer (our sister product).

The keyword set that he is monitoring with AWR is organized in three main categories: All keywords , Competitor keywords (this includes all keywords for which competitor domains are listed in the search results, including their branded terms) and Common keywords (this is the intersection of and the competitor ranked keywords).

The focus on the report is on comparing the visibility and estimated traffic performance against the competitor, with split by keyword category. On each report page, the filters by search engine, website and keyword group are applied directly at widget level.

Estimated Traffic Analysis - GDS - filters

Position Rank Distribution

Search Visibility - GDS

This report page was built together with Syed Shehzad , Senior SEO Manager at the Bauer Media SEO Agency .

The focus is on evaluating the rank distribution of the customer domain, to prove the effectiveness of the search engine optimization strategy. Basically, the bar charts quickly show how many keywords are of first position, top 3 – top 20, out of the total ranked keywords.

While AWR shows this information only as integer numbers, it can be displayed in GDS as number, or percent from the Ranked keywords, or from Total keywords tracked in the project. This is available with the help of the Calculated fields.  

Here is a quick example:

GDS - formula

Back to you

That’s all for now. Thanks everyone who contributed for their help, it’s been an amazing experience to work together on the project! And hope you’ve found inspiration in these examples and you’ll be sharing your own report samples and feedback with us soon.

If you’re new to AWR, sign up for a free 30 day trial and see how the new feature works with your own ranking data.

  1. Thx for the article! But when I try to display the visibility score of a project for a longer period (e.g. 1 year) in Google Data Studio I get an error. Any issues known regarding that?

  2. Hi,

    Thanks for the connector !! Very useful.
    However, the download of datas is very slow even for a simple datatable.
    Is there a way to speed it up ?

    Besides, do you plan to make keyword available as dimension ?

    Thanks again

  3. Love this new feature – as I’m a massive, massive fan of Google Data Studio. A bit tricky to setup at first, but you can get some nice visualisations from this.

  4. Hello! Big fan of Google Data Studio AND of AWR. Have used AWR as my keyword rank tracking tool for several years and find it to be the most reliable and cost-effective tool out there.

    I would LOVE an addition to this integration which includes keyword level data to show keyword rankings within Google Data Studio.

    Is there a plan to add on Keyword Ranking reports to this connector in the future?

    Crossing my fingers!


    1. Hey Mitch,

      Thank you so much for sharing your thoughts! We’re on it 🙂 Adding support for keyword as dimension is next on our list for the GDS connector.

      1. Hey Aura – Are there any updates to this integration or sense of a timeline for possible integration of keyword level data and rankings? Would love to hear about it!



  5. Hi Alexandre,

    Of course! We’ll make sure to announce the release by email for all our customers and blog subscribers.

    Thank you 🙂

        1. Hello Aura,

          Thank you very much.

          Could you make a sample of Google Data Studio Report with 2 new report types ?

  6. Hi Aura,

    I want to ask you if the using of the connector for Advanced Web Ranking costs KW units. I mean, in addition to credits for keywords tracking that I normally use in AWR.



    1. Hi Nicola,

      Nope 🙂 The connector does not consume additional credits, and it does not have limitations regarding the number of calls, shared with the AWR Developer 世界杯滚球平台.

      Thank you 🙂

Comments are closed.

Stay updated

Get email updates on exclusive tips, strategies, and original research that help you boost organic rankings for clients.

You May Also Like