---
title: "Google Search Console data warehouse table groups"
slug: "google-search-console-data-warehouse-table-groups"
description: "Explore the complete Supermetrics data warehouse table groups for Google Search Console. See all the tables and the fields included in them."
updated: 2026-03-05T14:02:38Z
published: 2026-03-05T14:02:38Z
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.supermetrics.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Google Search Console data warehouse table groups

Search fields<input type="text" id="field-search" placeholder="Search by field name, label, or description…" aria-label="Search fields by name, label, or description" autocomplete="off">

### Table: STANDARD

| \| anchor** \| \| --- \| \| \\| Display name \\| 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](/apidocs/field-data-types#text) \\| \| \| Display name \| 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](/apidocs/field-data-types#text) \| |
| --- |
| anchor** |
| \| Display name \| 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](/apidocs/field-data-types#text) \| |
| Display name | 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](/apidocs/field-data-types#text) |
| \| branded_vs_nonbranded** \| \| --- \| \| \\| Display name \\| Branded vs non-branded \\| \\| --- \\| --- \\| \\| 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](/apidocs/field-data-types#text) \\| \| \| Display name \| Branded vs non-branded \| \| 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](/apidocs/field-data-types#text) \| |
| branded_vs_nonbranded** |
| \| Display name \| Branded vs non-branded \| \| --- \| --- \| \| 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](/apidocs/field-data-types#text) \| |
| Display name | Branded vs non-branded |
| 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](/apidocs/field-data-types#text) |
| \| clicks** \| \| --- \| \| \\| Display name \\| Clicks \\| \\| --- \\| --- \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Clicks \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| clicks** |
| \| Display name \| Clicks \| \| --- \| --- \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Display name | Clicks |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| country** \| \| --- \| \| \\| Display name \\| Country code \\| \\| --- \\| --- \\| \\| Description \\| 3-letter country code (ISO 3166-1 alpha-3) \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) \\| \| \| Display name \| Country code \| \| Description \| 3-letter country code (ISO 3166-1 alpha-3) \| \| Field type \| dimension \| \| Data type \| [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) \| |
| country** |
| \| Display name \| Country code \| \| --- \| --- \| \| Description \| 3-letter country code (ISO 3166-1 alpha-3) \| \| Field type \| dimension \| \| Data type \| [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) \| |
| Display name | Country code |
| Description | 3-letter country code (ISO 3166-1 alpha-3) |
| Field type | dimension |
| Data type | [string.geo.country.twolettercode](/apidocs/field-data-types#geographical) |
| \| countryname** \| \| --- \| \| \\| Display name \\| Country \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.country](/apidocs/field-data-types#geographical) \\| \| \| Display name \| Country \| \| Field type \| dimension \| \| Data type \| [string.geo.country](/apidocs/field-data-types#geographical) \| |
| countryname** |
| \| Display name \| Country \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.geo.country](/apidocs/field-data-types#geographical) \| |
| Display name | Country |
| Field type | dimension |
| Data type | [string.geo.country](/apidocs/field-data-types#geographical) |
| \| dataSourceName** \| \| --- \| \| \\| Display name \\| 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](/apidocs/field-data-types#text) \\| \| \| Display name \| 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](/apidocs/field-data-types#text) \| |
| dataSourceName** |
| \| Display name \| 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](/apidocs/field-data-types#text) \| |
| Display name | 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](/apidocs/field-data-types#text) |
| \| Date** \| \| --- \| \| \\| Display name \\| Date \\| \\| --- \\| --- \\| \\| Description \\| Date, e.g. 2017-01-31 \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Date \| \| Description \| Date, e.g. 2017-01-31 \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Date** |
| \| Display name \| Date \| \| --- \| --- \| \| Description \| Date, e.g. 2017-01-31 \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Display name | Date |
| Description | Date, e.g. 2017-01-31 |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| device** \| \| --- \| \| \\| Display name \\| Device \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Device \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| device** |
| \| Display name \| Device \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Device |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| hostname** \| \| --- \| \| \\| Display name \\| 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](/apidocs/field-data-types#text) \\| \| \| Display name \| 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](/apidocs/field-data-types#text) \| |
| hostname** |
| \| Display name \| 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](/apidocs/field-data-types#text) \| |
| Display name | 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](/apidocs/field-data-types#text) |
| \| impressions** \| \| --- \| \| \\| Display name \\| Impressions \\| \\| --- \\| --- \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Impressions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| impressions** |
| \| Display name \| Impressions \| \| --- \| --- \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Display name | Impressions |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| page** \| \| --- \| \| \\| Display name \\| Landing page \\| \\| --- \\| --- \\| \\| Description \\| The landing page on your site \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.url](/apidocs/field-data-types#text) \\| \| \| Display name \| Landing page \| \| Description \| The landing page on your site \| \| Field type \| dimension \| \| Data type \| [string.text.url](/apidocs/field-data-types#text) \| |
| page** |
| \| Display name \| Landing page \| \| --- \| --- \| \| Description \| The landing page on your site \| \| Field type \| dimension \| \| Data type \| [string.text.url](/apidocs/field-data-types#text) \| |
| Display name | Landing page |
| Description | The landing page on your site |
| Field type | dimension |
| Data type | [string.text.url](/apidocs/field-data-types#text) |
| \| pagepath** \| \| --- \| \| \\| Display name \\| 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](/apidocs/field-data-types#text) \\| \| \| Display name \| 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](/apidocs/field-data-types#text) \| |
| pagepath** |
| \| Display name \| 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](/apidocs/field-data-types#text) \| |
| Display name | 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](/apidocs/field-data-types#text) |
| \| pathlevel1** \| \| --- \| \| \\| Display name \\| 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](/apidocs/field-data-types#text) \\| \| \| Display name \| 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](/apidocs/field-data-types#text) \| |
| pathlevel1** |
| \| Display name \| 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](/apidocs/field-data-types#text) \| |
| Display name | 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](/apidocs/field-data-types#text) |
| \| pathlevel2** \| \| --- \| \| \\| Display name \\| 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](/apidocs/field-data-types#text) \\| \| \| Display name \| 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](/apidocs/field-data-types#text) \| |
| pathlevel2** |
| \| Display name \| 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](/apidocs/field-data-types#text) \| |
| Display name | 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](/apidocs/field-data-types#text) |
| \| pathlevel3** \| \| --- \| \| \\| Display name \\| 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](/apidocs/field-data-types#text) \\| \| \| Display name \| 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](/apidocs/field-data-types#text) \| |
| pathlevel3** |
| \| Display name \| 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](/apidocs/field-data-types#text) \| |
| Display name | 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](/apidocs/field-data-types#text) |
| \| pathlevel4** \| \| --- \| \| \\| Display name \\| 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](/apidocs/field-data-types#text) \\| \| \| Display name \| 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](/apidocs/field-data-types#text) \| |
| pathlevel4** |
| \| Display name \| 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](/apidocs/field-data-types#text) \| |
| Display name | 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](/apidocs/field-data-types#text) |
| \| position** \| \| --- \| \| \\| Display name \\| Average position \\| \\| --- \\| --- \\| \\| Description \\| Average organic position in Google search results \\| \\| Field type \\| metric \\| \\| Data type \\| [float.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Average position \| \| Description \| Average organic position in Google search results \| \| Field type \| metric \| \| Data type \| [float.number.value](/apidocs/field-data-types#number) \| |
| position** |
| \| Display name \| Average position \| \| --- \| --- \| \| Description \| Average organic position in Google search results \| \| Field type \| metric \| \| Data type \| [float.number.value](/apidocs/field-data-types#number) \| |
| Display name | Average position |
| Description | Average organic position in Google search results |
| Field type | metric |
| Data type | [float.number.value](/apidocs/field-data-types#number) |
| \| profile** \| \| --- \| \| \\| Display name \\| Site \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Site \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| profile** |
| \| Display name \| Site \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Site |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| protocol** \| \| --- \| \| \\| Display name \\| Protocol \\| \\| --- \\| --- \\| \\| Description \\| Transfer protocol extracted from the landing page URL. Either http or https \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Protocol \| \| Description \| Transfer protocol extracted from the landing page URL. Either http or https \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| protocol** |
| \| Display name \| Protocol \| \| --- \| --- \| \| Description \| Transfer protocol extracted from the landing page URL. Either http or https \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Protocol |
| Description | Transfer protocol extracted from the landing page URL. Either http or https |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| query** \| \| --- \| \| \\| Display name \\| Search query \\| \\| --- \\| --- \\| \\| Description \\| The search query that resulted in a search impression \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Search query \| \| Description \| The search query that resulted in a search impression \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| query** |
| \| Display name \| Search query \| \| --- \| --- \| \| Description \| The search query that resulted in a search impression \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Search query |
| Description | The search query that resulted in a search impression |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| queryparams** \| \| --- \| \| \\| Display name \\| 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](/apidocs/field-data-types#text) \\| \| \| Display name \| 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](/apidocs/field-data-types#text) \| |
| queryparams** |
| \| Display name \| 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](/apidocs/field-data-types#text) \| |
| Display name | 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](/apidocs/field-data-types#text) |
| \| searchType** \| \| --- \| \| \\| Display name \\| Search type \\| \\| --- \\| --- \\| \\| Description \\| Separates web, image and mobile search \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Search type \| \| Description \| Separates web, image and mobile search \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| searchType** |
| \| Display name \| Search type \| \| --- \| --- \| \| Description \| Separates web, image and mobile search \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Search type |
| Description | Separates web, image and mobile search |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| words_in_query** \| \| --- \| \| \\| Display name \\| Words in search query \\| \\| --- \\| --- \\| \\| Description \\| Counts the number of words in a search query \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Words in search query \| \| Description \| Counts the number of words in a search query \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| words_in_query** |
| \| Display name \| Words in search query \| \| --- \| --- \| \| Description \| Counts the number of words in a search query \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Words in search query |
| Description | Counts the number of words in a search query |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |

### Table: SITEMAPS

| \| dataSourceName** \| \| --- \| \| \\| Display name \\| 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](/apidocs/field-data-types#text) \\| \| \| Display name \| 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](/apidocs/field-data-types#text) \| |
| --- |
| dataSourceName** |
| \| Display name \| 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](/apidocs/field-data-types#text) \| |
| Display name | 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](/apidocs/field-data-types#text) |
| \| Date** \| \| --- \| \| \\| Display name \\| Date \\| \\| --- \\| --- \\| \\| Description \\| Date, e.g. 2017-01-31 \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Date \| \| Description \| Date, e.g. 2017-01-31 \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Date** |
| \| Display name \| Date \| \| --- \| --- \| \| Description \| Date, e.g. 2017-01-31 \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Display name | Date |
| Description | Date, e.g. 2017-01-31 |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| errors** \| \| --- \| \| \\| Display name \\| 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](/apidocs/field-data-types#number) \\| \| \| Display name \| 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](/apidocs/field-data-types#number) \| |
| errors** |
| \| Display name \| 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](/apidocs/field-data-types#number) \| |
| Display name | 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](/apidocs/field-data-types#number) |
| \| indexed** \| \| --- \| \| \\| Display name \\| Indexed URLs \\| \\| --- \\| --- \\| \\| Description \\| The number of URLs from the sitemap that were indexed \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Indexed URLs \| \| Description \| The number of URLs from the sitemap that were indexed \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| indexed** |
| \| Display name \| Indexed URLs \| \| --- \| --- \| \| Description \| The number of URLs from the sitemap that were indexed \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Display name | Indexed URLs |
| Description | The number of URLs from the sitemap that were indexed |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| isSitemapsIndex** \| \| --- \| \| \\| Display name \\| Is sitemaps index \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [bool](/apidocs/field-data-types#primitive) \\| \| \| Display name \| Is sitemaps index \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| |
| isSitemapsIndex** |
| \| Display name \| Is sitemaps index \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| |
| Display name | Is sitemaps index |
| Field type | dimension |
| Data type | [bool](/apidocs/field-data-types#primitive) |
| \| lastDownloaded** \| \| --- \| \| \\| Display name \\| Last downloaded \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Last downloaded \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| lastDownloaded** |
| \| Display name \| Last downloaded \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Display name | Last downloaded |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| lastSubmitted** \| \| --- \| \| \\| Display name \\| Last submitted \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Last submitted \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| lastSubmitted** |
| \| Display name \| Last submitted \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Display name | Last submitted |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| path** \| \| --- \| \| \\| Display name \\| Path \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.url](/apidocs/field-data-types#text) \\| \| \| Display name \| Path \| \| Field type \| dimension \| \| Data type \| [string.text.url](/apidocs/field-data-types#text) \| |
| path** |
| \| Display name \| Path \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.text.url](/apidocs/field-data-types#text) \| |
| Display name | Path |
| Field type | dimension |
| Data type | [string.text.url](/apidocs/field-data-types#text) |
| \| profile** \| \| --- \| \| \\| Display name \\| Site \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Site \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| profile** |
| \| Display name \| Site \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Site |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| submitted** \| \| --- \| \| \\| Display name \\| Submitted URLs \\| \\| --- \\| --- \\| \\| Description \\| The number of URLs in the sitemap \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Submitted URLs \| \| Description \| The number of URLs in the sitemap \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| submitted** |
| \| Display name \| Submitted URLs \| \| --- \| --- \| \| Description \| The number of URLs in the sitemap \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Display name | Submitted URLs |
| Description | The number of URLs in the sitemap |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| warnings** \| \| --- \| \| \\| Display name \\| 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](/apidocs/field-data-types#number) \\| \| \| Display name \| 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](/apidocs/field-data-types#number) \| |
| warnings** |
| \| Display name \| 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](/apidocs/field-data-types#number) \| |
| Display name | 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](/apidocs/field-data-types#number) |

### Table: SEARCH_APPEARANCE

| \| clicks** \| \| --- \| \| \\| Display name \\| Clicks \\| \\| --- \\| --- \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Clicks \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| --- |
| clicks** |
| \| Display name \| Clicks \| \| --- \| --- \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Display name | Clicks |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| dataSourceName** \| \| --- \| \| \\| Display name \\| 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](/apidocs/field-data-types#text) \\| \| \| Display name \| 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](/apidocs/field-data-types#text) \| |
| dataSourceName** |
| \| Display name \| 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](/apidocs/field-data-types#text) \| |
| Display name | 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](/apidocs/field-data-types#text) |
| \| Date** \| \| --- \| \| \\| Display name \\| Date \\| \\| --- \\| --- \\| \\| Description \\| Date, e.g. 2017-01-31 \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Date \| \| Description \| Date, e.g. 2017-01-31 \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Date** |
| \| Display name \| Date \| \| --- \| --- \| \| Description \| Date, e.g. 2017-01-31 \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Display name | Date |
| Description | Date, e.g. 2017-01-31 |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| impressions** \| \| --- \| \| \\| Display name \\| Impressions \\| \\| --- \\| --- \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Impressions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| impressions** |
| \| Display name \| Impressions \| \| --- \| --- \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Display name | Impressions |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| position** \| \| --- \| \| \\| Display name \\| Average position \\| \\| --- \\| --- \\| \\| Description \\| Average organic position in Google search results \\| \\| Field type \\| metric \\| \\| Data type \\| [float.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Average position \| \| Description \| Average organic position in Google search results \| \| Field type \| metric \| \| Data type \| [float.number.value](/apidocs/field-data-types#number) \| |
| position** |
| \| Display name \| Average position \| \| --- \| --- \| \| Description \| Average organic position in Google search results \| \| Field type \| metric \| \| Data type \| [float.number.value](/apidocs/field-data-types#number) \| |
| Display name | Average position |
| Description | Average organic position in Google search results |
| Field type | metric |
| Data type | [float.number.value](/apidocs/field-data-types#number) |
| \| profile** \| \| --- \| \| \\| Display name \\| Site \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Site \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| profile** |
| \| Display name \| Site \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Site |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |