Supermetrics brings all your marketing data into Google Sheets, Google Data Studio, Excel, BigQuery, Snowflake, Redshift, Azure
| Category | Field | Code | Type | Description |
|---|---|---|---|---|
| TIME | Year | Year | dim | Year, e.g. 2017 |
| Month | Yearmonth | dim | Year and month, e.g. 2017|06 | |
| Week (Sun-Sat) | Yearweek | dim | Year and week for US-style Sunday-Saturday weeks, e.g. 2017|08 | |
| Week (Mon-Sun) | Yearweekiso | dim | Year and week for ISO standard Monday-Sunday weeks, e.g. 2017|08 | |
| Year of week (Mon-Sun) | YearOfISOweek | dim | Year of week for ISO standard Monday-Sunday weeks, e.g. 2017 | |
| Week (Mon-Sun) | weekiso | dim | ISO week number, e.g. 51 | |
| Week (Sun-Sat) | week | dim | US week number, e.g. 51 | |
| Week (Mon-Sun, dates) | yearweekiso_daterange | dim | ||
| Month | Month | dim | Month, e.g. 6 | |
| Day of month | dayOfMonth | dim | Day of month, e.g. 2 | |
| Day of week | dayOfWeekWithName | dim | Day of week number & name for US-style Sunday-Saturday weeks, e.g. 0 Sunday | |
| Date | Date | dim | Date, e.g. 2017-01-31 | |
| SEARCH QUERY | Search query | query | dim | The search query that resulted in a search impression |
| Branded vs. non-branded search queries | branded_vs_nonbranded | dim | 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 | dim | Counts the number of words in a search query | |
| Search type | searchType | dim | Separates web, image and mobile search | |
| Search appearance | searchAppearance | dim | ||
| SERP position (rounded avg.) | position_dim | 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 | dim | 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 | dim | The landing page on your site |
| Protocol | protocol | dim | Transfer protocol extracted from the landing page URL. Either http or https | |
| Hostname | hostname | dim | 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 | dim | 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 | dim | 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 | dim | 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 | dim | 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 | dim | 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 | dim | 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 | dim | 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 | dim | Extracts the title tag from the landing page |
| Landing page H1 tag | page_h1_tag | dim | Extracts the first H1 tag from the landing page | |
| Landing page meta description tag | page_tag_meta_description | dim | Extracts the meta description tag from the landing page | |
| Landing page canonical tag | page_tag_canonical | dim | Extracts the the canonical URL tag from the landing page | |
| Landing page meta viewport tag | page_tag_meta_viewport | dim | Extracts the meta viewport tag from the landing page | |
| Landing page meta content type tag | page_tag_meta_content_type | dim | Extracts the meta content type tag from the landing page | |
| Landing page meta robots tag | page_tag_meta_robots | dim | Extracts the meta robots tag from the landing page | |
| Landing page Google Tag Manager ID | page_tag_gtm_id | dim | Extracts all Google Tag Manager (GTM) IDs from the landing page | |
| Landing page Google Analytics UA ID | page_tag_ga_ua_id | dim | Extracts all Google Analytics Universal Analytics (UA) IDs from the landing page | |
| Landing page contains search term | page_contains_search_term | dim | 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 | dim | 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 | dim | Checks whether the landing page contains the search keyword in the meta description tag | |
| OTHER | Site | profile | dim | |
| Device | device | dim | ||
| SITEMAPS | Last downloaded | lastDownloaded | dim | |
| Last submitted | lastSubmitted | dim | ||
| Path | path | dim | ||
| Is sitemaps index | isSitemapsIndex | dim | ||
| GEO | Country | countryname | dim | |
| Country code | country | dim | 3-letter country code (ISO 3166-1 alpha-3) | |
| DEPRECATED | Googlebot user agent | errorcounts_platform | dim | Please note that this field will be removed on 2020-12-31 |
| Error category | errorcounts_errorCategory | dim | Please note that this field will be removed on 2020-12-31 | |
| Error category | errorCategory | dim | Please note that this field will be removed on 2020-12-31 | |
| Containing sitemaps | containingSitemaps | dim | Please note that this field will be removed on 2020-12-31 | |
| Response code | responseCode | dim | Please note that this field will be removed on 2020-12-31 | |
| Last crawled | last_crawled | dim | Please note that this field will be removed on 2020-12-31 | |
| Page URL | pageUrl | dim | Please note that this field will be removed on 2020-12-31 | |
| First detected | first_detected | dim | Please note that this field will be removed on 2020-12-31 | |
| Crawl date | errorcounts_date | dim | Please note that this field will be removed on 2020-12-31 | |
| Linked from URLs | linkedFromUrls | dim | Please note that this field will be removed on 2020-12-31 | |
| SITEMAPS | Submitted URLs | submitted | met | The number of URLs in the sitemap |
| Indexed URLs | indexed | met | The number of URLs from the sitemap that were indexed | |
| Warnings | warnings | met | The number of warnings for the sitemap. These are generally non-critical issues with URLs in the sitemaps | |
| Errors | errors | met | 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 | |
| SEARCH QUERIES | Impressions | impressions | met | |
| Clicks | clicks | met | ||
| CTR (%) | ctr_perc | met | Click Through Rate (clicks divided by impressions) | |
| Average position | position | met | Average organic position in Google search results | |
| Position | position_rounded | met | The average SERP position rounded to the nearest integer | |
| Position | position_rounded_page | met | The average SERP position rounded to the nearest integer and grouped by results page number | |
| PositionsSum | PositionsSum | met | ||
| # of words in search query | words_in_query_met | met | Counts the number of words in a search query | |
| DEPRECATED | Error count | errorcounts_errorCount | met | Please note that this field will be removed on 2020-12-31 |