Google Looker Data Studio Integration

Google Looker Data Studio Integration

Google Looker Data Studio Overview

Integrating seoClarity into Looker Studio allows for data to be added to Looker Studio reports and merged with other data sources. Google provides an introductory training to Looker Studio here. 

Background & Requirements for Google Looker Studio

An seoClarity API key and a Google Looker Studio account is required for this integration.  If you have Admin privileges for a profile, you can generate an API key through the Settings page via the Integrations tab. Click the Generate Token link to generate a unique API Key tied to your login and the profile you are working in. seoClarity API keys are specific to the user AND the profile from which they are generated.


Google Looker Studio Integration

Watch this video, or follow the step-by-step instructions below.




1) To access the Connector, search for "seoClarity" in Looker Studio. 
 

2) Select the Connector and configure it by submitting your seoClarity API key.

  1. Data Source name: We recommend setting this to a friendly name such as “seoClarity Tag Summary”. If you have multiple seoClarity profiles you wish to integrate, it is recommended to append the name of your profile to the Data Source name to be able to distinguish them later. For example, “seoClarity Tag Summary – HM.com” vs “seoClarity Tag Summary – AE.com” etc


3) Enter the Domain ID for the profile you wish to view data and the Keyword Tag IDs for the tags in that profile. Domain IDs can be retrieved by contacting support@seoclarity.net and Keyword Tag IDs can be retrieved via the Download All found on the Keyword Tags tab in Rank Intelligence. 


  1. Modifiable Tag ID (Recommended): Leave the “Enter Tag ID” Input box blank and instead check the box for “Allow “Enter Tag IDs” to be modified in reports”. This will allow Tag IDs to be passed as a variable in reports and allow retrieval of data for one or more tag ids from your seoClarity profile.
  2. Specific Tag ID: Specify a single keyword tag ID within the “Enter Tag ID” input box if you would like the data connector to ONLY retrieve and display data from a single Keyword Tag. This will “hard code” the Tag ID for the reports.



4) Once the ID(s) have been entered, select the "Connect" button and select "Allow" when prompted for parameter sharing. confirm the setup by Allow Parameter Sharing in the reports.

 

5) You should see the list of metrics and dimensions available through the seoClarity Connector. Select the "Create Report" button to use the Data Source in a new report and select "Create Report" when prompted.



6) The sample report will now be displayed to help you get started leveraging the Connector. 


 

Google Looker Data Studio Troubleshooting

If you receive an error while trying to connect be sure you are using your unique key that is also unique to the domain you are connecting with. If data will not integrate, check the tag ID is correct for the domain being connected, or contact support@seoclarity.net to check the used token count for the domain. 

seoClarity Google Looker Data Studio Connectors



The native Looker connectors for seoClarity are listed below. For other data points not present in these connectors, the seoClarity API can be integrated into Google Sheets and used as a Data Source for Looker. 

Keyword Tag Summary: Provides Keyword Tag level metrics for one or more tags. Available metrics include: Total Keywords, Average Search Volume, Average Rank, Wtd. Average Rank, Ranking on Page 1, 2, 3, 4, 5, 6, 7, 8, 9 and 10, Count of keywords in position 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, Search Volume in position 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, Count of keywords in Top 1, Top 3, Top 10, Top 50 and Top 100 rank positions, Search Volume of keywords in Top 1, Top 10, and Top 100 rank positions, Share of Voice, and Share of Market. 
  1. By default, metrics INCLUDE Keywords that don’t rank in the Top 100 positions by counting them as 101. If you would like to check the metrics EXCLUDING keywords that don’t rank in the top 100, you can use the corresponding metric: Total keywords without 101, Average Rank without 101, Wtd. Average Rank without 101, Share of Market without 101, and Share of Voice without 101.
Domain Summary Connector: Provides domain-level SEO metrics
Keyword Details Connector: Provides keyword level ranking details
  1. Combined, the Domain level, Tag level and Keyword detail level connectors enable clients to recreate the core ranking reports we provide inside Data Studio
Site Audit (Coming soon): Provides key data from Site Audits such as number of pages crawled, crawl status and issues discovered.

Google Looker Data Studio Limitations

Looker Studio only supports flat structures, like how data is stored in Excel – one row containing complete information for a specific element. This leads to a few challenges with fully leveraging the power of seoClarity’s data in Looker Studio.
  1. Even though you can associate a single keyword to multiple tags in the platform, Looker Studio data types does not allow arrays of keyword tags to be supplied.
  2. A single keyword could belong to multiple keyword tags within seoClarity. Looker Studio’s data format does not allow a way to pass all the tags for a keyword. For each connector, we have made design decisions that aim to provide you the most important views while working within the Looker Studio limitations.

    • Related Articles

    • Integration settings

      Integrations Overview The Integrations tab in Settings provides a variety of options for data integrations with the platform. To access Integration Settings go to the gear icon in the top right corner and then click on Settings. Next click on the ...

    • Google BigQuery Extract

      Overview Integrating seoClarity into BigQuery allows for data to be connected to additional data sources such as Looker Studio (formerly Google Data Studio), Tableau, and Domo among others. Requirements A Google BigQuery account is required to ...

    • How to Integrate seoClarity with Google Data Studio Looker (Video)

      How to Integrate seoClarity with Google Data Studio Looker (Video) <br>

    • How to Integrate seoClarity with Google Data Studio Looker (Video)

      How to Integrate seoClarity with Google Data Studio Looker (Video) <br>

    • Google Search Console Integration

      Google Search Console Integration Overview The objective of this integration is to authenticate a Google Search Console account within seoClarity. This integration takes the place of the previous Google Webmaster Tools integration. Background & ...