Supermetrics brings all your marketing data into Google Sheets, Google Data Studio, Excel, BigQuery, Snowflake, Redshift, Azure
Category | Field | Code | Description |
---|---|---|---|
TIME | Year | Year | Year, e.g. 2017 |
Month | Yearmonth | Year and month, e.g. 2017|06 | |
Week (Sun-Sat) | Yearweek | Year and week for US-style Sunday-Saturday weeks, e.g. 2017|08 | |
Week (Mon-Sun) | Yearweekiso | Year and week for ISO standard Monday-Sunday weeks, e.g. 2017|08 | |
Year of week (Mon-Sun) | YearOfISOweek | Year of week for ISO standard Monday-Sunday weeks, e.g. 2017 | |
Week (Mon-Sun) | weekiso | ISO week number, e.g. 51 | |
Week (Sun-Sat) | week | US week number, e.g. 51 | |
Week (Mon-Sun, dates) | yearweekiso_daterange | ||
Month | Month | Month, e.g. 6 | |
Day of month | dayOfMonth | Day of month, e.g. 2 | |
Day of week | dayOfWeekWithName | Day of week number & name for US-style Sunday-Saturday weeks, e.g. 0 Sunday | |
Date | Date | Date, e.g. 2017-01-31 | |
SEARCH QUERY | Search query | query | The search query that resulted in a search impression |
Branded vs. non-branded search queries | branded_vs_nonbranded | 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 | |
# of words in search query | words_in_query | Counts the number of words in a search query | |
Search type | searchType | Separates web, image and mobile search | |
Search appearance | searchAppearance | ||
SERP position (rounded avg.) | position_dim | Organic 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_page | 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 | |
LANDING PAGE | Full URL | page | The landing page on your site |
Protocol | protocol | Transfer protocol extracted from the landing page URL. Either http or https | |
Hostname | hostname | 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' | |
Path | pagepath | 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' | |
Directory level 1 | pathlevel1 | 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' | |
Directory level 2 | pathlevel2 | 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' | |
Directory level 3 | pathlevel3 | 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' | |
Directory level 4 | pathlevel4 | 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' | |
Query parameters | queryparams | 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' | |
Anchor | anchor | 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' | |
LANDING PAGE ANALYSIS | Landing page title tag | page_title_tag | Extracts the title tag from the landing page |
Landing page H1 tag | page_h1_tag | Extracts the first H1 tag from the landing page | |
Landing page meta description tag | page_tag_meta_description | Extracts the meta description tag from the landing page | |
Landing page canonical tag | page_tag_canonical | Extracts the the canonical URL tag from the landing page | |
Landing page meta viewport tag | page_tag_meta_viewport | Extracts the meta viewport tag from the landing page | |
Landing page meta content type tag | page_tag_meta_content_type | Extracts the meta content type tag from the landing page | |
Landing page meta robots tag | page_tag_meta_robots | Extracts the meta robots tag from the landing page | |
Landing page Google Tag Manager ID | page_tag_gtm_id | Extracts all Google Tag Manager (GTM) IDs from the landing page | |
Landing page Google Analytics UA ID | page_tag_ga_ua_id | Extracts all Google Analytics Universal Analytics (UA) IDs from the landing page | |
Landing page contains search term | page_contains_search_term | Checks whether the landing page contains the search keyword anywhere in the html | |
Landing page title tag contains search term | page_title_tag_contains_search_term | Checks whether the landing page contains the search keyword in the title tag | |
Landing page meta description contains search term | page_meta_description_contains_search_term | Checks whether the landing page contains the search keyword in the meta description tag | |
OTHER | Site | profile | |
Device | device | ||
SITEMAPS | Last downloaded | lastDownloaded | |
Last submitted | lastSubmitted | ||
Path | path | ||
Is sitemaps index | isSitemapsIndex | ||
GEO | Country | countryname | |
Country code | country | 3-letter country code (ISO 3166-1 alpha-3) | |
DEPRECATED | Googlebot user agent | errorcounts_platform | Please note that this field will be removed on 2020-12-31 |
Error category | errorcounts_errorCategory | Please note that this field will be removed on 2020-12-31 | |
Error category | errorCategory | Please note that this field will be removed on 2020-12-31 | |
Containing sitemaps | containingSitemaps | Please note that this field will be removed on 2020-12-31 | |
Response code | responseCode | Please note that this field will be removed on 2020-12-31 | |
Last crawled | last_crawled | Please note that this field will be removed on 2020-12-31 | |
Page URL | pageUrl | Please note that this field will be removed on 2020-12-31 | |
First detected | first_detected | Please note that this field will be removed on 2020-12-31 | |
Crawl date | errorcounts_date | Please note that this field will be removed on 2020-12-31 | |
Linked from URLs | linkedFromUrls | Please note that this field will be removed on 2020-12-31 |