Advice and answers from the Advanced Web Ranking Team

Search for articles

Search for articles

Search for articles

Looker Studio (Google Data Studio) Data Source Setup

The article offers you guidance on configuring Advanced Web Ranking (AWR) as a data source in Looker Studio and setting up reports to access data source mappings.

To add AWR as a Data Source, navigate to Account Settings - Connectors & API and click on Connect to Google Data Studio

how-to-add-AWR-as-a-data-source-in-Google-Looker-Studio

This will direct you to the new data source form, where you can add the details for the AWR Connector:

  • Enter the AWR API key

  • Choose the Report Type

  • Visibility Date Comparison (check sample

  • Visibility Evolution In Time (check sample)

  • Keyword Ranking Date Comparison (check sample)

  • Keyword Ranking Evolution In Time (check sample)

  • Market Share Evolution In Time (check sample)

  • Enter the project name that you want to connect and follow the filtering and sorting preferences available for each report type. 

With the Visibility report types, you can merge data from multiple projects to the same report, then you can filter the projects by name with partial match, or by project tag.

With the Visibility report types, you can merge data from multiple projects to the same report, then you can filter the projects by name with partial match, or by project tag.

With the Visibility report types, you can merge data from multiple projects to the same report, then you can filter the projects by name with partial match, or by project tag.

Data Source Setup sample for Visibility in time

data-source-setup-sample-for-visibility-in-time

Data Source Setup sample for Keyword Rankings date comparison

data-source-setup-sample-for-keyword-rankings-date-comparison

Data Source Setup sample for Market Share date comparison

data-source-setup-sample-for-market-share-date-comparison

For the Market Share data sources, one search engine and keyword group input can be selected at a time. To allow these inputs to be modified in the reports, make sure to enable the related filters as shown above.

For the Market Share data sources, one search engine and keyword group input can be selected at a time. To allow these inputs to be modified in the reports, make sure to enable the related filters as shown above.

For the Market Share data sources, one search engine and keyword group input can be selected at a time. To allow these inputs to be modified in the reports, make sure to enable the related filters as shown above.

Then just add a name for your data source and click Connect

Once the new entry is created successfully, it will list the mapping options for the metrics and dimensions available for the report type you have selected, giving you the possibility to update the type, aggregation method and description for each filed. 

Data Source Mapping sample for Visibility Evolution In Time

data-source-mapping-sample-for-visibility-evolution-in-time

Data Source Mapping sample for Keyword Ranking Date Comparison 

data-source-mapping-sample-for-keyword-ranking-date-comparison

Data Source Mapping sample for Keyword Ranking Date Comparison

data-source-mapping-sample-for-keyword-ranking-date-comparison-1

From this step, you can further create a new report based on the newly created data source, or you can add the data source to an existing report. 

See related resources

Google API Disclosure

AWR's use and transfer to any other app of information received from Google APIs will adhere to Google API Services User Data Policy, including the Limited Use requirements.

Do you have any other questions? Don’t hesitate to get in touch and we will keep building the FAQ.

Unlock Your 30-Day Free Trial!

Get accurate & uninterrupted rankings worldwide for any market—not just Google. No credit card required.

stay in the loop

Subscribe for more inspiration.