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)

Add Google Search Console as a data source on Kondado

Connect your Google Search Console account to Kondado to extract search performance data and load it into your data warehouse or BI tool.

1

Access the data source setup in Kondado

Log in to Kondado and navigate to the add data sources section. Select the Google Search Console connector to begin the integration.

2

Authorize your Google account

Click the "AUTHORIZE" button and select the Google account that manages your Search Console properties. Ensure you check ALL required permissions on the consent screen before clicking Continue.

3

Name and save the connection

After being redirected back to Kondado, give your data source a descriptive name and click SAVE to finalize the connection.

4

Create pipelines to your destination

Build pipelines to send Google Search Console data to your preferred destination, such as a data warehouse, data lake, or BI tool for analysis and reporting.

Frequently asked questions

What data does the Google Search Console integration bring into Kondado?▼

The integration extracts ultra-granularized data including site URLs, permission levels, search queries, countries, devices, pages, impressions, clicks, CTR, and position metrics. This differs from the aggregated view in the native Google Search Console interface. You can explore pre-built reports for Google Search Console to see how this data is structured.

Why is there a delay in the data from Google Search Console?▼

Due to API limitations imposed by Google, the data returned through the integration has a delay of at least 48 hours. This is not a Kondado limitation but a restriction from Google's Search Console API itself.

What time zone is the Google Search Console data reported in?▼

All data from the Google Search Console integration is reported in PT Pacific Time (UTC – 7:00/8:00 depending on daylight saving time). Keep this in mind when comparing with other data sources or scheduling reports.

Do I need to grant all permissions during authorization?▼

Yes. On the Google consent screen, you must check ALL permissions that are requested. Skipping any required permission will prevent the integration from functioning correctly and extracting your search performance data.

Can I send Google Search Console data to Google Data Studio?▼

Yes. After connecting the source, you can create pipelines to various destinations including Google Data Studio for visualization and dashboard creation, among other supported destinations.

Written by

Thassyo Pereira·Published 2023-07-17·Updated 2026-04-25