Google Search Console fields

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

Supermetrics brings all your Google Search Console data into Google Sheets, Looker Studio, Power BI, Excel, BigQuery, Snowflake, Redshift, Azure

10 metrics72 dimensions

DATASOURCE

dataSourceName
Field label 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
Destinations API, Data warehouse
system_metadata.data_source_logins
Field label Data source logins
Description The data source login accounts that were used to authenticate against the data source
Field type dimension
Data type string.text.json
system_metadata.data_source_login_owners
Field label Data source login owners
Description The Supermetrics users that created the data source login connections
Field type dimension
Data type string.text.json

DEPRECATED

errorcounts_platform
Field label Googlebot user agent
Field type dimension
Data type string.text.value
🚫 Deprecated Deprecated on 2020-12-31
errorcounts_errorCategory
Field label Error category
Field type dimension
Data type string.text.value
🚫 Deprecated Deprecated on 2020-12-31
errorCategory
Field label Error category
Field type dimension
Data type string.text.value
🚫 Deprecated Deprecated on 2020-12-31
containingSitemaps
Field label Containing sitemaps
Field type dimension
Data type bool
🚫 Deprecated Deprecated on 2020-12-31
responseCode
Field label Response code
Field type dimension
Data type int.number.value
🚫 Deprecated Deprecated on 2020-12-31
last_crawled
Field label Last crawled
Field type dimension
Data type string.time.date
🚫 Deprecated Deprecated on 2020-12-31
pageUrl
Field label Page URL
Field type dimension
Data type string.text.url
🚫 Deprecated Deprecated on 2020-12-31
first_detected
Field label First detected
Field type dimension
Data type string.time.date
🚫 Deprecated Deprecated on 2020-12-31
errorcounts_date
Field label Crawl date
Field type dimension
Data type string.time.date
🚫 Deprecated Deprecated on 2020-12-31
linkedFromUrls
Field label Linked from URLs
Field type dimension
Data type string.text.url
🚫 Deprecated Deprecated on 2020-12-31
errorcounts_errorCount
Field label Error count
Field type metric
Data type int.number.value
🚫 Deprecated Deprecated on 2020-12-31

GEO

countryname
Field label Country
Field type dimension
Data type string.geo.country
country
Field label Country code
Description 3-letter country code (ISO 3166-1 alpha-3)
Field type dimension
Data type string.geo.country.twolettercode

LANDING PAGE

page
Field label Full URL
Description The landing page on your site
Field type dimension
Data type string.text.url
protocol
Field label Protocol
Description Transfer protocol extracted from the landing page URL. Either http or https
Field type dimension
Data type string.text.value
hostname
Field label 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
pagepath
Field label 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
Field label 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
Field label 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
Field label 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
Field label 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
queryparams
Field label 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
anchor
Field label 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

LANDING PAGE ANALYSIS

page_title_tag
Field label Landing page title tag
Description Extracts the title tag from the landing page
Field type dimension
Data type string.text.value
page_h1_tag
Field label Landing page H1 tag
Description Extracts the first H1 tag from the landing page
Field type dimension
Data type string.text.value
page_tag_meta_description
Field label Landing page meta description tag
Description Extracts the meta description tag from the landing page
Field type dimension
Data type string.text.value
page_tag_canonical
Field label Landing page canonical tag
Description Extracts the the canonical URL tag from the landing page
Field type dimension
Data type string.text.value
page_tag_meta_viewport
Field label Landing page meta viewport tag
Description Extracts the meta viewport tag from the landing page
Field type dimension
Data type string.text.value
page_tag_meta_content_type
Field label Landing page meta content type tag
Description Extracts the meta content type tag from the landing page
Field type dimension
Data type string.text.value
page_tag_meta_robots
Field label Landing page meta robots tag
Description Extracts the meta robots tag from the landing page
Field type dimension
Data type string.text.value
page_tag_gtm_id
Field label Landing page Google Tag Manager ID
Description Extracts all Google Tag Manager (GTM) IDs from the landing page
Field type dimension
Data type string.text.value
page_tag_ga_ua_id
Field label Landing page Google Analytics UA ID
Description Extracts all Google Analytics Universal Analytics (UA) IDs from the landing page
Field type dimension
Data type string.text.value
page_contains_search_term
Field label Landing page contains search term
Description Checks whether the landing page contains the search keyword anywhere in the html
Field type dimension
Data type string.text.value
page_title_tag_contains_search_term
Field label Landing page title tag contains search term
Description Checks whether the landing page contains the search keyword in the title tag
Field type dimension
Data type string.text.value
page_meta_description_contains_search_term
Field label Landing page meta description contains search term
Description Checks whether the landing page contains the search keyword in the meta description tag
Field type dimension
Data type string.text.value

OTHER

profile
Field label Site
Field type dimension
Data type string.text.value
device
Field label Device
Field type dimension
Data type string.text.value

QUERY

system_metadata.query_date_range_start
Field label Start date
Description The start date of the requested query
Field type dimension
Data type string.time.date
system_metadata.query_date_range_end
Field label End date
Description The end date of the requested query
Field type dimension
Data type string.time.date
system_metadata.query_timezone
Field label Timezone
Description The timezone that is supplied to the query
Field type dimension
Data type string.time.timezone
system_metadata.query_filters
Field label Filters
Description All filters used in the query
Field type dimension
Data type string.text.json
system_metadata.query_date_start
Field label Start
Description When the query was started
Field type dimension
Data type string.time.datetime
system_metadata.query_date_end
Field label End
Description When the query completed
Field type dimension
Data type string.time.datetime
system_metadata.query_duration
Field label Duration
Description The duration in seconds of the query
Field type dimension
Data type int.duration.seconds
system_metadata.query_accounts
Field label Accounts
Description A list of accounts of which the data was pulled from
Field type dimension
Data type string.text.json

SEARCH QUERIES

impressions
Field label Impressions
Field type metric
Data type int.number.value
clicks
Field label Clicks
Field type metric
Data type int.number.value
ctr
Field label CTR
Description Click Through Rate (clicks divided by impressions)
Field type metric
Data type float.number.ratio
position
Field label Average position
Description Average organic position in Google search results
Field type metric
Data type float.number.value
words_in_query_met
Field label # of words in search query
Description Counts the number of words in a search query
Field type metric
Data type int.number.value

SEARCH QUERY

query
Field label Search query
Description The search query that resulted in a search impression
Field type dimension
Data type string.text.value
branded_vs_nonbranded
Field label Branded vs. non-branded search queries
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
words_in_query
Field label # of words in search query
Description Counts the number of words in a search query
Field type dimension
Data type string.text.value
searchType
Field label Search type
Description Separates web, image and mobile search
Field type dimension
Data type string.text.value
searchAppearance
Field label Search appearance
Field type dimension
Data type string.text.value
position_dim
Field label SERP position (rounded avg.)
Description Organic position in Google search results. We take the average position per keyword and round it to the closest integer
Field type dimension
Data type int.number.value
position_dim_page
Field label SERP position (rounded avg., paged)
Description Organic position in Google search results. We take the average position per keyword and round it to the closest integer for positions 1-10, and group by ten for further positions
Field type dimension
Data type string.text.value

SITEMAPS

lastDownloaded
Field label Last downloaded
Field type dimension
Data type string.time.date
lastSubmitted
Field label Last submitted
Field type dimension
Data type string.time.date
path
Field label Path
Field type dimension
Data type string.text.url
isSitemapsIndex
Field label Is sitemaps index
Field type dimension
Data type bool
submitted
Field label Submitted URLs
Description The number of URLs in the sitemap
Field type metric
Data type int.number.value
indexed
Field label Indexed URLs
Description The number of URLs from the sitemap that were indexed
Field type metric
Data type int.number.value
warnings
Field label 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
errors
Field label 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

TIME

today
Field label Today
Description Today's date, e.g. 2017-01-31
Field type dimension
Data type string.time.date
Destinations API, Data warehouse
Year
Field label Year
Description Year, e.g. 2017
Field type dimension
Data type string.time.year
Yearmonth
Field label Month
Description Year and month, e.g. 2017|06
Field type dimension
Data type string.time.yearmonth
Yearweek
Field label Week (Sun-Sat)
Description Year and week for US-style Sunday-Saturday weeks, e.g. 2017|08
Field type dimension
Data type string.time.yearweek
Yearweekiso
Field label Week (Mon-Sun)
Description Year and week for ISO standard Monday-Sunday weeks, e.g. 2017|08
Field type dimension
Data type string.time.yearweekiso
YearOfISOweek
Field label Year of week (Mon-Sun)
Description Year of week for ISO standard Monday-Sunday weeks, e.g. 2017
Field type dimension
Data type string.time.year
weekiso
Field label Week (Mon-Sun)
Description ISO week number, e.g. 51
Field type dimension
Data type string.time.weekiso
week
Field label Week (Sun-Sat)
Description US week number, e.g. 51
Field type dimension
Data type string.time.week
yearweekiso_daterange
Field label Week (Mon-Sun, dates)
Field type dimension
Data type string.text.value
Month
Field label Month
Description Month, e.g. 6
Field type dimension
Data type string.time.month
dayOfMonth
Field label Day of month
Description Day of month, e.g. 2
Field type dimension
Data type string.time.dayofmonth
dayOfWeekWithName
Field label Day of week
Description Day of week number & name for US-style Sunday-Saturday weeks, e.g. 0 Sunday
Field type dimension
Data type string.time.dayofweek
Date
Field label Date
Description Date, e.g. 2017-01-31
Field type dimension
Data type string.time.date
hour
Field label Hour
Description Hour in a 24-hour clock, e.g. 18. Can only be used with date ranges of 10 days or less
Field type dimension
Data type string.time.hour