Supermetrics brings all your marketing data into Google Sheets, Google Data Studio, Excel, BigQuery, Snowflake, Redshift, Azure

Dimension list for Google Search Console

69 dimensions available

CategoryFieldCodeDescription
TIMEYearYearYear, e.g. 2017
MonthYearmonthYear and month, e.g. 2017|06
Week (Sun-Sat)YearweekYear and week for US-style Sunday-Saturday weeks, e.g. 2017|08
Week (Mon-Sun)YearweekisoYear and week for ISO standard Monday-Sunday weeks, e.g. 2017|08
Year of week (Mon-Sun)YearOfISOweekYear of week for ISO standard Monday-Sunday weeks, e.g. 2017
Week (Mon-Sun)weekisoISO week number, e.g. 51
Week (Sun-Sat)weekUS week number, e.g. 51
Week (Mon-Sun, dates)yearweekiso_daterange
MonthMonthMonth, e.g. 6
Day of monthdayOfMonthDay of month, e.g. 2
Day of weekdayOfWeekWithNameDay of week number & name for US-style Sunday-Saturday weeks, e.g. 0 Sunday
DateDateDate, e.g. 2017-01-31
SEARCH QUERYSearch queryqueryThe search query that resulted in a search impression
Branded vs. non-branded search queriesbranded_vs_nonbrandedCategorises 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
# of words in search querywords_in_queryCounts the number of words in a search query
Search typesearchTypeSeparates web, image and mobile search
Search appearancesearchAppearance
SERP position (rounded avg.)position_dimOrganic position in Google search results. We take the average position per keyword and round it to the closest integer
SERP position (rounded avg., paged)position_dim_pageOrganic 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
LANDING PAGEFull URLpageThe landing page on your site
ProtocolprotocolTransfer protocol extracted from the landing page URL. Either http or https
HostnamehostnameHostname 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'
PathpagepathPage 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'
Directory level 1pathlevel1Top-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'
Directory level 2pathlevel2Directory 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'
Directory level 3pathlevel3Directory 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'
Directory level 4pathlevel4Directory 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'
Query parametersqueryparamsQuery 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'
AnchoranchorThe 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'
LANDING PAGE ANALYSISLanding page title tagpage_title_tagExtracts the title tag from the landing page
Landing page H1 tagpage_h1_tagExtracts the first H1 tag from the landing page
Landing page meta description tagpage_tag_meta_descriptionExtracts the meta description tag from the landing page
Landing page canonical tagpage_tag_canonicalExtracts the the canonical URL tag from the landing page
Landing page meta viewport tagpage_tag_meta_viewportExtracts the meta viewport tag from the landing page
Landing page meta content type tagpage_tag_meta_content_typeExtracts the meta content type tag from the landing page
Landing page meta robots tagpage_tag_meta_robotsExtracts the meta robots tag from the landing page
Landing page Google Tag Manager IDpage_tag_gtm_idExtracts all Google Tag Manager (GTM) IDs from the landing page
Landing page Google Analytics UA IDpage_tag_ga_ua_idExtracts all Google Analytics Universal Analytics (UA) IDs from the landing page
Landing page contains search termpage_contains_search_termChecks whether the landing page contains the search keyword anywhere in the html
Landing page title tag contains search termpage_title_tag_contains_search_termChecks whether the landing page contains the search keyword in the title tag
Landing page meta description contains search termpage_meta_description_contains_search_termChecks whether the landing page contains the search keyword in the meta description tag
OTHERSiteprofile
Devicedevice
SITEMAPSLast downloadedlastDownloaded
Last submittedlastSubmitted
Pathpath
Is sitemaps indexisSitemapsIndex
GEOCountrycountryname
Country codecountry3-letter country code (ISO 3166-1 alpha-3)
DEPRECATEDGooglebot user agenterrorcounts_platformPlease note that this field will be removed on 2020-12-31
Error categoryerrorcounts_errorCategoryPlease note that this field will be removed on 2020-12-31
Error categoryerrorCategoryPlease note that this field will be removed on 2020-12-31
Containing sitemapscontainingSitemapsPlease note that this field will be removed on 2020-12-31
Response coderesponseCodePlease note that this field will be removed on 2020-12-31
Last crawledlast_crawledPlease note that this field will be removed on 2020-12-31
Page URLpageUrlPlease note that this field will be removed on 2020-12-31
First detectedfirst_detectedPlease note that this field will be removed on 2020-12-31
Crawl dateerrorcounts_datePlease note that this field will be removed on 2020-12-31
Linked from URLslinkedFromUrlsPlease note that this field will be removed on 2020-12-31
QueryStart datesystem_metadata.query_date_range_startThe start date of the requested query
End datesystem_metadata.query_date_range_endThe end date of the requested query
Timezonesystem_metadata.query_timezoneThe timezone that is supplied to the query
Filterssystem_metadata.query_filtersAll filters used in the query
Startsystem_metadata.query_date_startWhen the query was started
Endsystem_metadata.query_date_endWhen the query completed
Durationsystem_metadata.query_durationThe duration in seconds of the query
Accountssystem_metadata.query_accountsA list of accounts of which the data was pulled from
DatasourceData source loginssystem_metadata.data_source_loginsThe data source login accounts that were used to authenticate against the data source
Data source login ownerssystem_metadata.data_source_login_ownersThe Supermetrics users that created the data source login connections