Google Search Console data warehouse table groups

  • Updated on Sep 18, 2025
  • Published on Aug 5, 2025
Prev Next

Table: STANDARD

anchor
Display name Anchor
Description The anchor extracted from the landing page URL. If the full URL is 'https://supermetrics.com/products/googlesheets/index.html?utm_campaign=test#pricing', this dimension would return 'pricing'
Field type dimension
Data type string.text.value
branded_vs_nonbranded
Display name Branded vs non-branded
Description Categorises search queries into branded or non-branded. You can set your own brand terms, or if you don't, we use your domain name as the brand term
Field type dimension
Data type string.text.value
clicks
Display name Clicks
Field type metric
Data type int.number.value
country
Display name Country code
Description 3-letter country code (ISO 3166-1 alpha-3)
Field type dimension
Data type string.geo.country.twolettercode
countryname
Display name Country
Field type dimension
Data type string.geo.country
dataSourceName
Display name Data source
Description The name of the source for this data, as listed on supermetrics.com/docs
Field type dimension
Data type string.text.value
Date
Display name Date
Description Date, e.g. 2017-01-31
Field type dimension
Data type string.time.date
device
Display name Device
Field type dimension
Data type string.text.value
hostname
Display name Hostname
Description Hostname extracted from the landing page URL. If the full URL is 'https://supermetrics.com/products/googlesheets/index.html?utm_campaign=test#pricing', this dimension would return 'supermetrics.com'
Field type dimension
Data type string.text.value
impressions
Display name Impressions
Field type metric
Data type int.number.value
page
Display name Landing page
Description The landing page on your site
Field type dimension
Data type string.text.url
pagepath
Display name Path
Description Page path extracted from the landing page URL. If the full URL is 'https://supermetrics.com/products/googlesheets/index.html?utm_campaign=test#pricing', this dimension would return '/products/googlesheets/index.html'
Field type dimension
Data type string.text.value
pathlevel1
Display name Directory level 1
Description Top-level directory extracted from the landing page URL. If the full URL is 'https://supermetrics.com/products/googlesheets/index.html?utm_campaign=test#pricing', this dimension would return 'products'
Field type dimension
Data type string.text.value
pathlevel2
Display name Directory level 2
Description Directory path until the 2nd level extracted from the landing page URL. If the full URL is 'https://supermetrics.com/products/googlesheets/index.html?utm_campaign=test#pricing', this dimension would return 'products/googlesheets'
Field type dimension
Data type string.text.value
pathlevel3
Display name Directory level 3
Description Directory path until the 3rd level extracted from the landing page URL. If the full URL is 'https://supermetrics.com/products/googlesheets/index.html?utm_campaign=test#pricing', this dimension would return 'products/googlesheets'
Field type dimension
Data type string.text.value
pathlevel4
Display name Directory level 4
Description Directory path until the 4th level extracted from the landing page URL. If the full URL is 'https://supermetrics.com/products/googlesheets/index.html?utm_campaign=test#pricing', this dimension would return 'products/googlesheets'
Field type dimension
Data type string.text.value
position
Display name Average position
Description Average organic position in Google search results
Field type metric
Data type float.number.value
profile
Display name Site
Field type dimension
Data type string.text.value
protocol
Display name Protocol
Description Transfer protocol extracted from the landing page URL. Either http or https
Field type dimension
Data type string.text.value
query
Display name Search query
Description The search query that resulted in a search impression
Field type dimension
Data type string.text.value
queryparams
Display name Query parameters
Description Query parameters extracted from the landing page URL. If the full URL is 'https://supermetrics.com/products/googlesheets/index.html?utm_campaign=test#pricing', this dimension would return 'utm_campaign=test'
Field type dimension
Data type string.text.value
searchType
Display name Search type
Description Separates web, image and mobile search
Field type dimension
Data type string.text.value
words_in_query
Display name Words in search query
Description Counts the number of words in a search query
Field type dimension
Data type string.text.value

Table: SITEMAPS

dataSourceName
Display name Data source
Description The name of the source for this data, as listed on supermetrics.com/docs
Field type dimension
Data type string.text.value
Date
Display name Date
Description Date, e.g. 2017-01-31
Field type dimension
Data type string.time.date
errors
Display name Errors
Description The number of errors in the sitemap. These are issues with the sitemap itself that need to be fixed before it can be processed correctly
Field type metric
Data type int.number.value
indexed
Display name Indexed URLs
Description The number of URLs from the sitemap that were indexed
Field type metric
Data type int.number.value
isSitemapsIndex
Display name Is sitemaps index
Field type dimension
Data type bool
lastDownloaded
Display name Last downloaded
Field type dimension
Data type string.time.date
lastSubmitted
Display name Last submitted
Field type dimension
Data type string.time.date
path
Display name Path
Field type dimension
Data type string.text.url
profile
Display name Site
Field type dimension
Data type string.text.value
submitted
Display name Submitted URLs
Description The number of URLs in the sitemap
Field type metric
Data type int.number.value
warnings
Display name Warnings
Description The number of warnings for the sitemap. These are generally non-critical issues with URLs in the sitemaps
Field type metric
Data type int.number.value

Table: SEARCH_APPEARANCE

clicks
Display name Clicks
Field type metric
Data type int.number.value
dataSourceName
Display name Data source
Description The name of the source for this data, as listed on supermetrics.com/docs
Field type dimension
Data type string.text.value
Date
Display name Date
Description Date, e.g. 2017-01-31
Field type dimension
Data type string.time.date
impressions
Display name Impressions
Field type metric
Data type int.number.value
position
Display name Average position
Description Average organic position in Google search results
Field type metric
Data type float.number.value
profile
Display name Site
Field type dimension
Data type string.text.value