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

IDTypeNameDescription
anchorTEXTAnchorAnchor of the Page, e.g. if site is https://abc.foo.bar/a.html#anchor1 then this is 'anchor1'
branded_vs_nonbrandedTEXTBranded vs Non-BrandedThe value is "branded" if the domain name is included in the search query, otherwise it's "nonbranded"
clicksNUMERICClicksThe Number of Clicks
countryTEXTCountry code3-letter country code
countrynameTEXTCountry NameThe Country Name
ctrNUMERICCTRThe Click Through Rate
dateDATEDateThe Date
deviceTEXTDeviceThe Device Used for the Search
errorsNUMERICErrorsNumber of errors in the sitemap
hostnameTEXTHostnameThe domain name of the Page
impressionsNUMERICImpressionsThe Number of Impressions
indexedNUMERICIndexedThe number of indexed URLs from the sitemap
is_sitemaps_indexBOOLEANIs sitemaps indexIf true, the sitemap is a collection of sitemaps
last_downloadedDATELast downloadedDate and time in which this sitemap was last downloaded
last_submittedDATELast submittedDate and time in which this sitemap was submitted
pageTEXTPageThe Page
pagepathTEXTpage PathFull path of the Page, excluding the Protocol and Hostname
pathTEXTPathThe url of the sitemap
pathlevel1TEXTpagePathlevel1Top-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'
pathlevel2TEXTpagePathlevel22nd 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'
pathlevel3TEXTpagePathlevel33rd 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'
pathlevel4TEXTpagePathlevel44th 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'
positionNUMERICPositionThe Average Position
position_pageNUMERICAverage SERP positionThe average page number in the Google search results
protocolTEXTProtocol"http" or "https"
queryTEXTSearch QueryThe Search Query
queryparamsTEXTQuery paramsQuery parameters of the Page, e.g. if site is https://abc.foo.bar/a.html?a=b then this is 'a=b'
search_appearanceTEXTSearch AppearanceHow the site appears in the search results
search_typeTEXTSearch typenews, image, video or web, fetching this field could impact the time needed to get response
siteTEXTSiteThe Site
submittedNUMERICSubmittedThe number of submitted URLs in the sitemap
warningsNUMERICWarningsNumber of warnings for the sitemap
words_in_queryNUMERICWords in QueryThe number of words in the query