Close



Frequently Asked Questions



Frequently Asked Questions

Clients



Clients

Users



Users

Insights



Insights

Insight | Google Search Console

Google Search Console

Insight | Google Business Profile

Google Business Profile

Insight | Google Ads

Google Ads

Insight | Google Analytics

Google Analytics

Insight | Website

Website

Insight | Facebook Ads

Facebook Ads

Insight | Microsoft Ads

Microsoft Ads

Automation Jobs



Automation Jobs

Automation | Google Search Console

Google Search Console

Automation | Google Business Profile

Google Business Profile

Automation | Google Ads

Google Ads

Automation | Google Analytics

Google Analytics

Automation | Website

Website

Automation | Facebook Ads

Facebook Ads

Automation | Microsoft Ads

Microsoft Ads

KPI Management



KPI Management

KPI Management | Google Analytics

Google Analytics

KPI Management | Google Ads

Google Ads

KPI Management | Google Business Profile

Google Business Profile

KPI Management | Facebook Ads

Facebook Ads

KPI Management | Microsoft Ads

Microsoft Ads

KPI Management | Google Sheets

Google Sheets

Budget Tracking



Budget Tracking

Budget Tracking | Google Sheets

Google Sheets

Anomaly Detection



Anomaly Detection

Data Warehouse



Data Warehouse

Data Warehouse | Google Looker Studio

Google Looker Studio

Data Warehouse | BigQuery

Google BigQuery

Data Warehouse | Google Business Profile

Google Business Profile (Formerly Google My Business)

Data Warehouse | Google Search Console

Google Search Console

Data Warehouse | Facebook Ads

Facebook Ads

Local Listings



Local Listings

Reviews



Reviews

Settings



Settings

Integrations



Integrations

Integrations | Google Looker Studio

Google Looker Studio

Integrations | Slack

Slack

Integrations | Zapier

Zapier

Integrations | Make

Make

Integrations | Webhook

Webhook

Comments



Comments

Comments | Slack

Slack

Extensions



Extension

Extension | Explorer

Branch Explorer

Recent Updates



Account Settings

Settings

Acknowledging and Resolving Insights

Insights

Add comment from Slack

Comments | Slack

Adding a User

Users

An overview of Local Listings

Local Listings

An overview of Reviews

Reviews

Analysis

Anomalies Bulk Action

Anomaly Detection

Anomaly Algorithm

Anomaly Detection

Integrations | Webhook

Anomaly Detection Insight

Insights

Anomaly Detection Settings

Anomaly Detection

Anomaly Job Common Errors

Anomaly Detection

Attributes

Local Listings

Authentication

Integrations | Make

Auto Resolving

Insights

Automatic Schema Updates

Data Warehouse

Automation Job Common Errors

Automation Jobs

Automation: Facebook Ads Destination URL Checker

Integrations | Webhook

Automation: Google Ads Change History

Integrations | Webhook

Automation: Google Ads Destination URL Checker

Integrations | Webhook

Automation: Google Analytics Change History

Integrations | Webhook

Automation: Google Business Profile Answer

Integrations | Webhook

Automation: Google Business Profile Change History

Integrations | Webhook

Automation: Google Business Profile Pending Updates

Integrations | Webhook

Automation: Google Business Profile Question

Integrations | Webhook

Automation: Google Review

Integrations | Webhook

Automation: Google Review Change History

Integrations | Webhook

Automation: Microsoft Ads Destination URL Checker

Integrations | Webhook

Automation: Page Status Checker

Integrations | Webhook

Automation: Robots.txt Change Detection

Integrations | Webhook

Automation: Search Console Activity

Integrations | Webhook

Automation: Search Console Keyword Movement

Integrations | Webhook

Automations Bulk Action

Automation Jobs

Budget Campaign Dynamic Filter

Budget Tracking

Budget Tracking

Budget Tracking

Budget Tracking

Integrations | Webhook

Budget Tracking

Budget Tracking

Local Listings

Local Listings | Media

Calendar

Social Posts

Cancel Subscription

Settings

Google Search Console Fields

‍
‍

Transferring your Search Console data into Google Big Query is quick and easy. To make analyzing easy in Google Data Studio the data is broken down into entities, within a single table. Each entity represents a type of data.

The process of moving your data into Big Query begins by fetching your historic data, with the timeframes of each entity shown below. After this a daily update is performed, some entities have a delay to when new data is available and is also shown in the table below.

Table of Contents

Entity date ranges for syncing
All Entities Fields
Basic Fields
Query Fields
Page Fields
Sitemap Fields

‍

How to create a Data Studio Report for Google Search Console

‍

Entity date ranges for syncing

Entity	Historic Data Period	Daily Update Schedule
Basic	From 16 months ago up to 3 days ago	3 days ago
Page	From 16 months ago up to 3 days ago	3 days ago
Query	From 16 months ago up to 3 days ago	3 days ago
Sitemap	Current day	Current day

‍

All Entities

Field	Type	Description
entityType	String	Grouping of the data (Basic, Query, Page, Sitemap)
date	Date	Date of the search in Pacific Time Zone (PT)
searchType	String	Which search tab contained the link seen by the user
device	String	The type of device on which the user is searching
country	String	The country where the search came from
searchAppearance	String	The specific search result type or feature
insertId	String	Composite key of the data

‍

Basic

Field	Type	Description
query	String	Search string that users searched for on Google
page	String	The final URL linked by a Search result after any skip redirects
clicks	Integer	Count of clicks from a Google search result that landed the user on your property
impressions	Integer	How many links to your property a user saw on Google search results. Impressions are counted when the user visits that page of results, even if the result was not scrolled into view.
CTR	Float	Click-through rate: The click count divided by the impression count
position	Float	The position of the topmost link to your property in search results, averaged across all queries in which your property appeared

‍
Query

Field	Type	Description
queryClicks	Integer	Count of clicks from a Google search result that landed the user on your property, aggregated by query.
queryImpressions	Integer	How many links to your page a user saw on Google search results. Impressions are counted when the user visits that page of results, even if the result was not scrolled into view. Its value is aggregated by query.
queryCTR	Float	Click-through rate: The click count divided by the impression count. Its value is aggregated by query.
queryPosition	Float	The position of the topmost link to your page in search results, averaged across all queries in which your property appeared. Its value is aggregated by query.

‍

Page

Field	Type	Description
pageClicks	Integer	Count of clicks from a Google search result that landed the user on your page
pageImpressions	Integer	How many links to your page a user saw on Google search results. Impressions are counted when the user visits that page of results, even if the result was not scrolled into view.
pageCTR	Float	Click-through rate: The click count divided by the impression count
property	String	Website URL
pagePosition	Float	The position of the topmost link to your page in search results, averaged across all queries in which your property appeared
wordsInQuery	Integer	Number of words in the query
protocol	String	Transfer protocol of the page (http or https)
hostName	String	Hostname of the page
pagePath1	String	First level directory of the page
pagePath2	String	Second level directory of the page
pagePath3	String	Third level directory of the page
pagePath4	String	Fourth level directory of the page
queryParameter	String	Query parameters of the page
anchorTag	String	Anchor tag of the page

‍

Sitemap

Field	Type	Description
sitemapPath	String	The URL where the sitemap is posted, relative to the property root.
sitemapLastSubmitted	String	The date when the sitemap was last submitted to Google using this report
sitemapPending	Boolean	If true, the sitemap has not been processed.
sitemapList	Boolean	If true, the sitemap is a collection of sitemaps.
sitemapType	String	The type of sitemap. (Possible Options: Sitemap: Sitemap in XML or text format, Sitemap index: A sitemap of sitemaps, RSS: Sitemap in RSS feed format, Atom: Sitemap in Atom feed format or Unknown)
sitemapLastDownloaded	String	Date & time in which this sitemap was last downloaded. Date format is in RFC 3339 format (yyyy-mm-dd).
sitemapWarnings	Integer	The number of warnings in the sitemap.
sitemapErrors	Integer	Number of errors in the sitemap. These are issues with the sitemap itself that need to be fixed before it can be processed correctly.
sitemapContentType	String	The specific type of content in this sitemap (androidApp, image, iosApp, mobile, news, pattern, video, web)
sitemapContentSubmitted	Integer	Date & time in which this sitemap was submitted. Date format is in RFC 3339 format (yyyy-mm-dd).
sitemapContentIndexed	Integer	The number of URLs from the sitemap that were indexed (of the content type)

‍

Was this article helpful?



Nice one!

Thanks a lot for your feedback! If you’d like a member of our support team to respond to you, please send a message here



Please try again

Oops! Something went wrong while submitting the form.



Nice one!

Thanks a lot for your feedback! If you’d like a member of our support team to respond to you, please send a message here



Please try again

Oops! Something went wrong while submitting the form.

Help Center

Google Search Console Fields

Entity date ranges for syncing

All Entities

Basic

‍Query

Page

Sitemap

‍
Query