Search Console

• Introduction
  • An example of operation
  • Data schema
• Configuration
  • Before you start
  • WitCloud access to Search Console
  • Start creating the module
  • Initial settings
  • Setting the module in the schedule

Introduction

The search console module allows you to automatically collect data about site's impressions, clicks, and position on Google Search.

An example of operation

1. First we grant access to WitCloud service account in Search Console panel
2. We configure the module in the WitCloud platform
3. We set the module on the schedule - the data will be collected and stored in witcloud dataset
4. After the table is processed, you can use other reporting modules or combine it with analytics

Data schema

Two tables appear in your dataset:

1. search_console_analytics

Expand for the data schema

Field name	Type	Mode
date	DATE	NULLABLE
query	STRING	NULLABLE
page	STRING	NULLABLE
country	STRING	NULLABLE
device	STRING	NULLABLE
clicks	INTEGER	NULLABLE
impressions	INTEGER	NULLABLE
position	FLOAT	NULLABLE

2. search_console_totals

Expand for the data schema

Field name	Type	Mode
date	DATE	NULLABLE
clicks	INTEGER	NULLABLE
impressions	INTEGER	NULLABLE
ctr	FLOAT	NULLABLE
position	FLOAT	NULLABLE

Configuration

Before you start

Make sure you have your verified your site owership in Search Console panel

You can find a description of this process here link (opens new window)

WitCloud access to Search Console

In order for Witcloud to be able to get information from the search console, we need to give it appropriate access.

From the menu on the left, select the Settings tab, then click the Projects sub tab.

Navigate to project details page by clicking on the gear.

Copy the email address of the service account.

Go to the Google Search Console panel link (opens new window) and click on settings tab. Make sure you have the correct domain selected.

Click on Users and permissions tab.

Click on ADD USER button.

Paste previously copied service account email, choose Full or Restricted as permission and click ADD button.

Everything is ready! From now on, the witcloud can access data from the Search Console

Start creating the module

From the menu on the left select the Collect tab, then click the Add new data Collect button.

Select Search Console from the list of available modules

Initial settings

Fill out the modules form and click on finish button.

Collect name - the name of our module. It will be visible under this name elsewhere on the platform.

Site url - your website address.

Setting the module in the schedule

Your module is now created in WitCloud 📊. The final step is to determine the time range for which you need to retrieve historical data. The schedule for retrieving current data will be created automatically.

Enter the appropriate range and click the Finish button.