Analytics & SEO
Google Search Console schema
SightShark syncs Google Search Console into a data warehouse you own. It creates 7 tables holding 66 fields, refreshed daily. Search performance at site, page and query level, each split by country, device and search type, plus sitemap submission status.
7 tables / 66 fields / Tables from the production sync
Tables and fields
Every table this connector creates, and every field in it, named as you will query it.
keyword_page_report
11 fields
- site
- date
- country
- device
- page
- query
- search_type
- clicks
- impressions
- ctr
- position
snapshot_sitemap
7 fields
- site
- path
- type
- last_submitted
- last_downloaded
- submitted
- indexed
site_report_by_site
9 fields
- site
- date
- country
- device
- search_type
- clicks
- impressions
- ctr
- position
site_report_by_page
9 fields
- site
- date
- country
- device
- search_type
- clicks
- impressions
- ctr
- position
page_report
10 fields
- site
- date
- country
- device
- page
- search_type
- clicks
- impressions
- ctr
- position
keyword_site_report_by_site
10 fields
- site
- date
- country
- device
- query
- search_type
- clicks
- impressions
- ctr
- position
keyword_site_report_by_page
10 fields
- site
- date
- country
- device
- query
- search_type
- clicks
- impressions
- ctr
- position
Where it lands
Into a warehouse you already own, in a region you pick. The modelling runs inside that project, so nothing leaves your cloud to be transformed and we keep no copy of your history.
- Google BigQuery
- Snowflake
- Databricks
- AWS Redshift
- Azure Synapse
Site analytics counts a conversion its own way and the ad platforms count it theirs, so the same week produces two different answers depending on which tab you opened.
Questions people ask
What tables does SightShark create from Google Search Console?
7 tables, including keyword_page_report, snapshot_sitemap, site_report_by_site. keyword_page_report is one row per site, per page, per query, per country, per device, per day. Every one is listed on this page, with its fields.
Which Google Search Console fields can I get?
All 66 listed fields are on this page, table by table, named as they appear in your warehouse.
How often does Google Search Console data refresh?
Daily. A sync adds to the tables rather than replacing them, so when a platform restates a figure for a day that has already closed, both the original number and the correction stay on record.
Can I join Google Search Console data to my other platforms?
Yes. Every metric is modelled to one name, one type, one grain and one currency, so a query across Google Search Console and another source needs no reconciling of field names first.
Related connectors
Reporting on this data
- 5 min read
Search Console's AI report, and what to tell clients about it.
It answers one question well: how often a client's pages were shown in an AI answer. Do not ask it for the rest.
Read it - 7 min read
How AI assistants choose what to cite.
Mostly the boring things. The text is there without running anything, and the page answers the question it claims to.
Read it - 7 min read
How to report a client's visibility inside AI answers.
Most of it never becomes a visit. What is left is a sample, and a sample is only worth reporting if it has a method.
Read it
Get started
Want Google Search Console in your own warehouse?
A call with someone who can answer the schema questions.