Google Search Console Field Reference

Sample
https://connectors.windsor.ai/searchconsole?api_key=[your API key]&date_preset=last_7d&fields=site,query,clicks,position,ctr,impressions&_renderer=csv
Fields
ID | Type | Name | Description |
---|---|---|---|
account_id | TEXT | Account ID | The Site |
account_name | TEXT | Account Name | The Site |
anchor | TEXT | Anchor | Anchor of the Page, e.g. if site is https://abc.foo.bar/a.html#anchor1 then this is 'anchor1' |
branded_vs_nonbranded | TEXT | Branded vs Non-Branded | The value is "branded" if the domain name is included in the search query, otherwise it's "nonbranded" |
clicks | NUMERIC | Clicks | The Number of Clicks |
country | TEXT | Country code | 3-letter country code |
countryname | TEXT | Country Name | The Country Name |
ctr | PERCENT | CTR | The Click Through Rate |
date | DATE | Date | The Date |
device | TEXT | Device | The Device Used for the Search |
errors | NUMERIC | Errors | Number of errors in the sitemap |
hostname | TEXT | Hostname | The domain name of the Page |
impressions | NUMERIC | Impressions | The Number of Impressions |
indexed | NUMERIC | Indexed | The number of indexed URLs from the sitemap |
is_sitemaps_index | BOOLEAN | Is sitemaps index | If true, the sitemap is a collection of sitemaps |
last_downloaded | DATE | Last downloaded | Date and time in which this sitemap was last downloaded |
last_submitted | DATE | Last submitted | Date and time in which this sitemap was submitted |
page | TEXT | Page | The Page |
pagepath | TEXT | Page Path | Full path of the Page, excluding the Protocol and Hostname |
path | TEXT | Path | The url of the sitemap |
pathlevel1 | TEXT | pagePathlevel1 | Top-level Directory Path of the Page, e.g. if site is https://abc.foo.bar/a/b/c/dd.html?a=b then pathlevel1 is 'a' |
pathlevel2 | TEXT | pagePathlevel2 | 2nd level Directory Path of the Page, e.g. if site is https://abc.foo.bar/a/b/c/dd.html?a=b then pathlevel2 is 'a/b' |
pathlevel3 | TEXT | pagePathlevel3 | 3rd level Directory Path of the Page, e.g. if site is https://abc.foo.bar/a/b/c/dd.html?a=b then pathlevel3 is 'a/b/c' |
pathlevel4 | TEXT | pagePathlevel4 | 4th level Directory Path of the Page, e.g. if site is https://abc.foo.bar/a/b/c/dd.html?a=b then pathlevel4 is 'a/b/c' |
position | NUMERIC | Position | The Average Position |
position_page | NUMERIC | Average SERP position | The average page number in the Google search results |
protocol | TEXT | Protocol | "http" or "https" |
query | TEXT | Search Query | The Search Query |
queryparams | TEXT | Query params | Query parameters of the Page, e.g. if site is https://abc.foo.bar/a.html?a=b then this is 'a=b' |
search_appearance | TEXT | Search Appearance | How the site appears in the search results |
search_type | TEXT | Search type | news, image, video or web, fetching this field could impact the time needed to get response |
site | TEXT | Site | The Site |
submitted | NUMERIC | Submitted | The number of submitted URLs in the sitemap |
warnings | NUMERIC | Warnings | Number of warnings for the sitemap |
words_in_query | NUMERIC | Words in Query | The number of words in the query |