Skip to main content

How to use our Looker Studio connectors

Step-by-step guide on how to pull data from SEOmonitor (API) into Looker Studio

The feature described in this article might be available only for Tracked Campaigns. Learn more.

SEOmonitor has key metrics such as Visibility and Opportunity scores, to help you make data-driven SEO decisions. Your campaign data, along with these metrics can be accessed in multiple ways: our API, CSV exports, Google Sheets reports, and Looker Studio connectors.

Here's how you can use our Looker Studio connectors to bring your campaign data from SEOmonitor into Looker Studio, so you can combine and analyze data from other sources, leveraging Looker Studio's reporting features. This includes analyzing campaign visibility data to track keyword performance and trends effectively.

  1. Login to your Looker Studio account and select Create > Data source.

  2. In the Search bar, enter 'seomonitor' and choose the suitable connector based on the data that you want to import.

View the list of available connectors and their data. 3. Click on Authorize to allow Looker Studio to use our connector.

  1. Enter your API token and select Submit.


Note: To generate your API token, click on the top-right dropdown and select Edit Profile. On the Edit screen, click on 'Generate API Token'. If your API token is already generated, click on 'Copy' and paste it on Looker Studio while creating the Data source. If you have already installed the connector, to add the API token, select the connector settings and click on Revoke access to remove the connector. Install the connector again with the API token.


  1. Edit the report by choosing and editing the fields that you want to see in your report, and then click Create Report.

  2. Your report is now ready to be viewed.

Visualization Options

  1. Vertical Bar Charts: Use vertical bar charts to represent trends over time effectively, as the Daily Visibility endpoint does not support time series charts.

  2. Table Visualization: Display visibility data in a tabular format using Looker Studio’s table visualization feature. While it may not replicate a traditional spreadsheet layout, it provides a comparable way to organize and view your data.

FAQs

  1. What data can I import using the Looker Studio connectors? You can use one of the following connectors:

  • Campaign: To view the performance of your keyword groups in terms of their Visibility, daily keyword ranks, page-wise and overall website Visibility, and the performance of your keywords in terms of their organic traffic and conversions.

  • Competition: To view each of your competitor's rankings and rank changes for each device against yours, and compare their daily Visibility trend against yours.

  • Organic Traffic: To view the sessions, conversions and revenue your brand and non-brand keywords brought.

  • Forecast: To view the traffic estimated by your forecast scenario against the inertial and the actual traffic, along with the objective status, if applicable.- Limitations and Workarounds: The Daily Visibility endpoint lacks a date-type dimension, making it incompatible with time series charts. Use vertical bar charts as an alternative.- Handling Large Datasets: Use Looker Studio’s pagination feature to navigate and manage large datasets efficiently, ensuring smooth performance even with over 100 groups or thousands of keywords.- Daily Visibility: To pull visibility data directly into Looker Studio for further analysis and visualization. This endpoint is particularly useful for tracking keyword performance and trends over time.

Available templates:

For any questions, you can reach out to us via the in-app chat or by email.

(For indexing purposes, we will also refer to this as Google DataStudio.)

Download the Reference guide below for a list of all the data points for the available connectors:

Did this answer your question?