See other articles
Data Warehouse

Data Source — Google Search Console

Metric Field Notes

All Entities

Field Type Description

entityType

TextString Grouping of the data (Query, Page, Sitemap)

date

CalendarDate Date of the search in Pacific Time Zone (PT)

searchType

TextString Which search tab contained the link seen by the user

device

TextString The type of device on which the user is searching

country

TextString The country where the search came from

searchAppearance

TextString The specific search result type or feature

insertId

TextString Composite key of the data

Query

Field Type Description

query

TextString Search string that users searched for on Google

page

TextString The final URL linked by a Search result after any skip redirects

clicks

NumericInteger Count of clicks from a Google search result that landed the user on your property

impressions

NumericInteger 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

NumericFloat Click-through rate: The click count divided by the impression count

position

NumericFloat The position of the topmost link to your property in search results, averaged across all queries in which your property appeared

Page

Field Type Description

pageClicks

NumericInteger Count of clicks from a Google search result that landed the user on your page

pageImpressions

NumericInteger 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

NumericFloat Click-through rate: The click count divided by the impression count

pagePosition

NumericFloat The position of the topmost link to your page in search results, averaged across all queries in which your property appeared

wordsInQuery

NumericInteger Number of words in the query

protocol

TextString Transfer protocol of the page (http or https)

hostName

TextString Hostname of the page

pagePath1

TextString First level directory of the page

pagePath2

TextString Second level directory of the page

pagePath3

TextString Third level directory of the page

pagePath4

TextString Fourth level directory of the page

queryParameter

TextString Query parameters of the page

anchorTag

TextString Anchor tag of the page

Sitemap

Field Type Description

sitemapPath

TextString The URL where the sitemap is posted, relative to the property root.

sitemapLastSubmitted

TextString The date when the sitemap was last submitted to Google using this report

sitemapPending

BooleanBoolean If true, the sitemap has not been processed.

sitemapList

BooleanBoolean If true, the sitemap is a collection of sitemaps.

sitemapType

TextString 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

TextString Date & time in which this sitemap was last downloaded. Date format is in RFC 3339 format (yyyy-mm-dd).

sitemapWarnings

NumericInteger The number of warnings in the sitemap.

sitemapErrors

NumericInteger 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

TextString The specific type of content in this sitemap (androidApp, image, iosApp, mobile, news, pattern, video, web)

sitemapContentSubmitted

NumericInteger Date & time in which this sitemap was submitted. Date format is in RFC 3339 format (yyyy-mm-dd).

sitemapContentIndexed

NumericInteger 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.

Sorry about that. What did you find most unhelpful?
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.

See all categories

Data Warehouse

Metric Field Notes

All Entities

Field Type Description

entityType

TextString Grouping of the data (Query, Page, Sitemap)

date

CalendarDate Date of the search in Pacific Time Zone (PT)

searchType

TextString Which search tab contained the link seen by the user

device

TextString The type of device on which the user is searching

country

TextString The country where the search came from

searchAppearance

TextString The specific search result type or feature

insertId

TextString Composite key of the data

Query

Field Type Description

query

TextString Search string that users searched for on Google

page

TextString The final URL linked by a Search result after any skip redirects

clicks

NumericInteger Count of clicks from a Google search result that landed the user on your property

impressions

NumericInteger 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

NumericFloat Click-through rate: The click count divided by the impression count

position

NumericFloat The position of the topmost link to your property in search results, averaged across all queries in which your property appeared

Page

Field Type Description

pageClicks

NumericInteger Count of clicks from a Google search result that landed the user on your page

pageImpressions

NumericInteger 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

NumericFloat Click-through rate: The click count divided by the impression count

pagePosition

NumericFloat The position of the topmost link to your page in search results, averaged across all queries in which your property appeared

wordsInQuery

NumericInteger Number of words in the query

protocol

TextString Transfer protocol of the page (http or https)

hostName

TextString Hostname of the page

pagePath1

TextString First level directory of the page

pagePath2

TextString Second level directory of the page

pagePath3

TextString Third level directory of the page

pagePath4

TextString Fourth level directory of the page

queryParameter

TextString Query parameters of the page

anchorTag

TextString Anchor tag of the page

Sitemap

Field Type Description

sitemapPath

TextString The URL where the sitemap is posted, relative to the property root.

sitemapLastSubmitted

TextString The date when the sitemap was last submitted to Google using this report

sitemapPending

BooleanBoolean If true, the sitemap has not been processed.

sitemapList

BooleanBoolean If true, the sitemap is a collection of sitemaps.

sitemapType

TextString 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

TextString Date & time in which this sitemap was last downloaded. Date format is in RFC 3339 format (yyyy-mm-dd).

sitemapWarnings

NumericInteger The number of warnings in the sitemap.

sitemapErrors

NumericInteger 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

TextString The specific type of content in this sitemap (androidApp, image, iosApp, mobile, news, pattern, video, web)

sitemapContentSubmitted

NumericInteger Date & time in which this sitemap was submitted. Date format is in RFC 3339 format (yyyy-mm-dd).

sitemapContentIndexed

NumericInteger The number of URLs from the sitemap that were indexed (of the content type)