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 | |
| Query | Start date | system_metadata.query_date_range_start | The start date of the requested query |
| End date | system_metadata.query_date_range_end | The end date of the requested query | |
| Timezone | system_metadata.query_timezone | The timezone that is supplied to the query | |
| Filters | system_metadata.query_filters | All filters used in the query | |
| Start | system_metadata.query_date_start | When the query was started | |
| End | system_metadata.query_date_end | When the query completed | |
| Duration | system_metadata.query_duration | The duration in seconds of the query | |
| Accounts | system_metadata.query_accounts | A list of accounts of which the data was pulled from | |
| Datasource | Data source logins | system_metadata.data_source_logins | The data source login accounts that were used to authenticate against the data source |
| Data source login owners | system_metadata.data_source_login_owners | The Supermetrics users that created the data source login connections |