Bright Analytics

Google Search Console for WordPress - AndiSites Inc.

Google Search Console provides insights into a website’s organic search presence, showing how Google crawls, indexes, and ranks pages. The GSC API enables programmatic access to search performance, URL inspection, and coverage data, supporting SEO reporting, performance analysis, and technical site audits.

The connector focuses on organic search metrics, including clicks, impressions, CTR, average position, and page-level search data.

Clicks, impressions, click-through rate (CTR)

Search appearance (rich results, AMP, video)

- Queries driving traffic
- Page-level performance metrics
- Clicks, impressions, click-through rate (CTR)
- Average position in search results
- Device type (desktop, mobile, tablet)
- Country-level performance
- Search appearance (rich results, AMP, video)

- Indexed vs non-indexed pages
- Indexing status
- Crawl errors
- Mobile usability issues
- Structured data validation
- Last crawl date

- Submitted sitemaps and coverage
- Indexed URLs by sitemap
- Crawl frequency
- Downloaded pages &amp; response codes

Device, country, and search type mappings

- Property-level settings
- Verified domains &amp; subdomains
- URL and query dimensions
- Device, country, and search type mappings

This integration retrieves data at multiple levels: Page, Query, Device, Country and Search type.

Monitor organic search performance over time

Analyse click, impression, CTR, and position trends

Identify high-performing queries and pages

Track mobile usability and structured data health

Support SEO reporting, dashboards, and automated alerts

Audit sitemaps and site coverage for optimisation

- Monitor organic search performance over time
- Analyse click, impression, CTR, and position trends
- Identify high-performing queries and pages
- Detect indexing issues and crawl errors
- Track mobile usability and structured data health
- Support SEO reporting, dashboards, and automated alerts
- Audit sitemaps and site coverage for optimisation

Append (for data table), Refresh (for metadata)

For more information on this integration and use-case follow this <a href="https://brightanalytics.com/connectors/google-search-console-reporting-api/" rel="nofollow noopener noreferrer" target="_blank">link</a>:

___________________________________________________________

All targets require the <code>searchconsole_domain</code> input (the full URL of the GSC property).

- Datasource Joins: None configured

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

- 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

Google Search Console (GSC) API Connector

brightanalytics.com

Find answers and get help from Intercom Support and Community Experts

This site employs cookies and other technologies that we and our third party vendors use to monitor and record personal information about you and your interactions with the site (including content viewed, cursor movements, screen recordings, and chat contents) for the purposes described in our Cookie Policy. By continuing to visit our site, you agree to our {websiteTermsLink}, {privacyPolicyLink} and {cookiePolicyLink}.

This site uses cookies and similar technologies ("cookies") as strictly necessary for site operation. We and our partners also would like to set additional cookies to enable site performance analytics, functionality, advertising and social media features. See our {cookiePolicyLink} for details. You can change your cookie preferences in our Cookie Settings.

We use cookies to make our site work and also for analytics and advertising purposes. You can enable or disable optional cookies as desired. See our {cookiePolicyLink} for more details.

Advertising cookies are set by our advertising partners to collect information about your use of the site, our communications, and other online services over time and with different browsers and devices. They use this information to show you ads online that they think will interest you and measure the ads' performance. Social media cookies are set by social media platforms to enable you to share content on those platforms, and are capable of tracking information about your activity across other online services for use as described in their privacy policies.

These cookies enable the website to provide enhanced functionality and personalisation. They may be set by us or by third party providers whose services we have added to our pages. If you do not allow these cookies then some or all of these services may not function properly.

These cookies are necessary for the website to function and cannot be switched off in our systems.

These cookies allow us to count visits and traffic sources so we can measure and improve the performance of our site. They help us to know which pages are the most and least popular and see how visitors move around the site.

You have the right to opt out of the sale of your personal information. See our {cookiePolicyLink} for more details about how we use your data.

Your Privacy Choices

We use cookies to enhance your experience. You can customize your cookie preferences below. See our {cookiePolicyLink} for more details.

Cookie Settings

Link, Press control-option-right-arrow to exit

Empty Help Center

Uh oh. That page doesn’t exist.

Disappointed

Neutral

Smiley

Thinking...

Searching through sources...

Analyzing...

Tickets submitted through the messenger or by a support agent in your conversation will appear here.

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

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`

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

Key	Type	Description	Required
`searchconsole_domain`	text	Full URL of the property in Search Console	✅

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`

Google Search Console (GSC) API Connector

Overview

Search Performance Data

URL Inspection & Coverage

Sitemaps & Crawl Stats

Metadata & Reference Data

Granularity

Purpose

Refresh Cadence:

Update Modes:

Connection

Job Configuration

Targets

Required Options

Dimensions

Base Metrics

Joins

Example Use Cases

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