Google Search Console (Google Webmasters)

Google Search Console (formerly Webmasters Tools) is a free Google tool that allows you to track your site's performance on Google searches. Its functionalities are:

Search Traffic: Identifies what people are searching for on Google that leads them to click on your site;
Search Appearance: Shows how Google is reading your site's structured data (titles, descriptions, etc.)
Google Index: Works like a library index. Google goes to your site and identifies the keywords that appear the most to position you in the results when such words are searched for;
Other features: Such as warnings of security issues on your site, testing tools, etc.

Adding the data source

To integrate Google Search Console into your database,start ;

by adding the data source on the Kondado platform, following the steps below:

1) Login to Kondado, go to add data sources section and select the Google Search Console data source

2) Click on the “AUTHORIZE” button

3) Select the account you will use

4) On the next screen, check ALL permissions that are required and click Continue

5) You will be redirected to Kondado and all you have to do is give your data source a name and click on SAVE

Now just create your pipelines to send data from Google Search Console to your Data warehouse or Data Lake

Pipelines

Relationship Chart

Gráfico de relacionamento entre tabelas

Websites

Field	Type
permissionlevel	text
siteurl	text

Search Information

Field	Type
siteurl	text
metric_date	date
query	text
country	text
device	text
page	text
impressions	float
clicks	float
ctr	float
position	float

The integration will bring ultra-granularized data, which will result in a different view of the aggregated data that you find directly in the tool. Learn more in this Google article

Due to API limitation, the data returned to the integration has a delay of at least 48 hours

Data is reported in PT Pacific time (UTC – 7:00/8:00)