Skip to main content

Google Search Console (GSC) API Connector

Updated today
Google Search Console for WordPress - AndiSites Inc.

πŸ”Ή Summary

This connector pulls organic performance data from Google Search Console, including impressions, clicks, and average position metrics across countries, queries, and pages.

  • Source: google_search_console

  • Connection Label: Bright Analytics

  • Import Type: Scheduled daily job with 3-day lookback

  • Supports: Segmentation by country, search query, and landing page

  • Includes: Core search metrics with calculated average position

  • Granularity: Domain β†’ Country / Query / Page level

  • Purpose: Track organic search performance metrics (impressions, clicks, average position) segmented by query, country, and landing page.

  • Refresh Cadence: Daily

  • Update Modes: Append (for all data tables)

For more information on this integration and use-case follow this link:
​


πŸ”Œ Connection

Connection Details

Key

Description

Required

Type

google_client_secret

Google OAuth Client Secret (hidden)

βœ…

Hidden

google_client_id

Google OAuth Client ID (hidden)

βœ…

Hidden

google_client_scopes

Necessary connection scopes to fetch the data

βœ…

Hidden


πŸ› οΈ Job Configuration

Field

Value

Job Label

Google Search Console

Feed

google_search_console

Status

1 (Active)

Lookback

3 days

First Run Hour

6 AM

Poll Frequency

Every 24 hours

Lookback Window

0

Update Mode

append


🎯 Targets

All targets require the searchconsole_domain input (the full URL of the GSC property).

Table Name

Description

Date Column

Update Mode

googlesearch_data_country

Country-level GSC data

date

append

googlesearch_data_query

Search query-level data

date

append

googlesearch_data_page

Landing page-level data

date

append


🧾 Required Options

Key

Type

Description

Required

searchconsole_domain

text

Full URL of the property in Search Console

βœ…


🧭 Dimensions

Name

Result Fields

Country [GSC]

googlesearch_data_country.country, googlesearch_data_query.country

Query [GSC]

googlesearch_data_query.query, googlesearch_data_page.query

Page [GSC]

googlesearch_data_page.page


πŸ“Š Base Metrics

Name

Formulae

Round

Impressions [GSC]

SUM(impressions) across country, query, page

0

Clicks [GSC]

SUM(clicks) across country, query, page

0

Position [GSC]

SUM(position)/COUNT(*) averaged across country, query, page

2


πŸ”— Joins

  • Datasource Joins: None configured


βœ… Example Use Cases

  • Track organic search performance by geography, query, and landing page

  • Measure visibility and engagement trends in Google search results

  • Identify top-performing search queries and URLs

  • Calculate and benchmark average search position

Did this answer your question?