Import data from Google Search Console into KNIME Analytics Platform

Open Source software extension for KNIME

View on 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

Install Nodes
Step 1: Add Update Site
  1. In KNIME, go to "Preferences" and navigate to "Install/Update" > "Available Software Sites"
  2. Click "Add"
  3. Enter "Search Analytics" into the "Name" field
  4. Depending on your KNIME version, copy one of the following URLs into the "Location" field: https://install.searchanalyticsnode.com/5.3 https://install.searchanalyticsnode.com/5.4
  5. Close the dialogs by clicking "Add", then "Apply and Close"
Step 2: Install Extension
  1. Click on "Menu" > "Install extensions"
  2. Find "Search Analytics Node", select it, and follow the installation process by clicking "Next"
  3. In the "Trust Authorities" dialog, click "Select All" and then "Trust Selected"
  4. In the "Trust Artifacts" dialog, check the shown fingerprint matches the one listed below and click "Select All" and then "Trust Selected"
  5. After the installation is finished, you are asked to restart KNIME

For enhanced security, all releases are PGP signed with the following fingerprint: 76A8E4458F55023A6D290D09DFC4494DAA96D6A6

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. 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

Feedback

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