Import data from Google Search Console into KNIME Analytics Platform

Open Source software extension for KNIME

KNIME Hub GitHub
Authenticator Node in KNIME

Authenticator Node

Handles the authentication with Google's API

Query Node in KNIME

Query Node

Retrieves search performance data, including impressions, clicks, and more

URL Inspection Node in KNIME

URL Inspection Node

Retrieves indexing information and issues, including last crawl time, referring URLs, and more

Property Details Node in KNIME

Property Details Node

Retrieves Google Search Console properties, including property type, verification status, and more

Install Nodes
  1. In KNIME click on "Menu" > "Install extensions"
  2. Find "Search Analytics Node", select it, and follow the installation process by clicking "Next"
  3. After the installation is finished, you are asked to restart KNIME

The demo workflow walks you through the available nodes, showing how each one works.

Download Workflow - Show Screenshot of Workflow

This extension leverages the Google Search Console API to provide valuable insights into your website's ranking in KNIME.

With read-only access to your property, it securely transfers data directly from Google to your local machine - ensuring that only you have access.

  1. Open KNIME
  2. Click on "Help" in the top right corner
  3. Click on "About KNIME Analytics Platform"
  4. Click on "Installation Details"
  5. Select "Search Analytics Node" and click "Uninstall..."
  6. Click on "Finish"
  7. Click on "Preferences" in the top right corner
  8. On the left side, navigate to "Install/Update" and "Available Software Sites"
  9. Only if listed, select "Search Analytics" and click "Remove"

The Google Search Console is an essential tool for SEO to understand how websites rank in Google Searches and how the search engine perceives it. The performance report presents data collected from real searches.

KNIME allows to analyze large data sets with visual workflows. However, the direct export option within the Google Search Console is limited to only 1,000 lines per download.

With the Search Analytics nodes, performance data from your website can be retrieved directly from within the KNIME Analytics Platform. This is the only native API integration for the Search Console in KNIME, making it an invaluable tool for SEO professionals.

Using these nodes in KNIME to access data from the Google Search Console is a breeze. There are no settings to configure in the Search Console for using the nodes, making the process incredibly user-friendly.

Try the extension and discover exciting insights into your website's search traffic data!

Search Analytics is the name of the endpoint for querying performance data in Google's Search Console API. To keep it simple and accurate, we named this extension after the endpoint it accesses. That's it!

KNIME version 5.3 is affected by a bug when using the date selection tool, which we use when specifying a custom date range. The date selection dialog may close instantly or not apply input from the mouse. You can mitigate this issue by manually entering the dates with your keyboard or upgrading KNIME to version 5.4. Please note that this issue is caused by KNIME, not the extension.

Features

Upgrade to Pro

Flame icon indicating list entry

Query Node: Remove the 100,000 row cap

Flame icon indicating list entry

URL Inspection Node: Up to 10x faster with parallel execution

Interested in a license key? Reach out at hello@searchanalyticsnode.com

Feedback

Help us improve! We value your opinion - share your feedback at hello@searchanalyticsnode.com