Import data from Google Search Console into KNIME Analytics Platform

Open Source software extension for KNIME

View on GitHub Search Analytics Authenticator node connected to the Search Analytics Query node
Install Nodes
  1. Open KNIME
  2. Click on "Preferences" in the top right corner
  3. On the left side, navigate to "Install/Update" and "Available Software Sites"
  4. Click "Add"
  5. Enter "Search Analytics" into the "Name" field
  6. 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
  7. Close the dialog by clicking "Add"
  8. Close the preferences dialog by clicking "Apply and Close"
  9. Click on "Menu" in the top right corner and then on "Install extensions"
  10. Select the checkbox besides "Search Analytics Node" and follow the installation process by clicking "Next"
  11. In the "Trust Authorities" dialog, click "Select All" and then "Trust Selected"
  12. In the "Trust Artifacts" dialog, check the shown fingerprint matches the one listed below and click "Select All" and then "Trust Selected"
  13. After the installation is finished, you are asked to restart KNIME

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

  1. Search for "Search Analytics" in the node repository, drag the "Search Analytics - Authenticator" and "Search Analytics - Query" nodes into the workflow editor and connect their ports.
  2. Authenticate yourself by executing the Authenticator node. Your browser will open. Select a Google account with access to the property of interest. Rest assured, we won't have access to your data. Close the browser once you've confirmed granting read-only access to the node.
  3. You can now query the performance data. The usual Search Console settings can be made. Open the Query node configuration dialogue and select the property you want to retrieve the data from. After configuration, execute the node to retrieve the respective data.
    Note that your available properties are only listed in the Query node's configuration dialog after you successfully authenticate yourself by completing step two.

For a more detailed explanation of the parameters, have a look at Google's documentation.

This extension utilizes the Search Analytics API of the Google Search Console to retrieve your search traffic data in KNIME.

To get started, you must authenticate yourself with the API using the Authenticator node and specify the data you want in the Query node.

  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