Windsor brings all your Google Search Console data into Power BI, Looker Studio, Google Sheets, Excel, BigQuery, Snowflake, TableauPostgreSQL, MySQL, Python, Amazon S3, Azure, Azure MS SQL

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

IDTypeNameDescriptionReport
account_idTEXTAccount IDThe Site
account_nameTEXTAccount NameThe Site
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
countryCOUNTRYCountry NameCountry Name
countrynameCOUNTRYCountry NameThe Country Name
ctrPERCENTCTRThe Click Through Rate
datasourceTEXTData SourceThe name of the Windsor connector returning the row
dateDATEDateThe date (for Sitemaps this is the date of the last submission)
day_of_monthTEXTDay of monthDay of the month
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
monthTEXTMonthNumber of the month
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
sourceTEXTSourceThe name of the Windsor connector returning the row
submittedNUMERICSubmittedThe number of submitted URLs in the sitemap
todayDATETodayToday's date
warningsNUMERICWarningsNumber of warnings for the sitemap
weekTEXTWeekWeek (Sun-Sat).
week_dayTEXTDay of week and day numberWeekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday.
week_day_isoTEXTDay of week and day number, ISOWeekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7
week_isoTEXTWeek ISOWeek, ISO format (Mon-Sun).
words_in_queryNUMERICWords in QueryThe number of words in the query
yearTEXTYearYear
year_monthTEXTYearmonthYear and month, e.g. 2024|3
year_of_weekTEXTYear of weekThe year that contains first day of the week (Sun-Sat).
year_of_week_isoTEXTYear of week, ISOThe year that contains first day of the ISO week (Mon-Sun).
year_weekTEXTYear weekYear and week for US weeks (Sun-Sat), e.g. 2024|15
year_week_isoTEXTYear week ISOYear and week for ISO weeks (Mon-Sun), e.g. 2024|20