Semrush Connector Reference

172 metrics28 dimensions

The Semrush connector exposes 200 fields (172 metrics, 28 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.


Available options


database Database

Regional database to query. Mobile and extended databases aren’t available for any requests in the Keyword reports. If All is selected, all databases you have access to will be queried which may result in high API units usage. All isn’t available for the Keyword and history reports. Defaults to United States.

Possible values (147)
United StatesdefaultUnited KingdomCanadaRussiaGermanyFranceSpainItalyBrazilAustraliaArgentinaBelgiumSwitzerlandDenmarkFinlandHong KongIrelandIsraelMexicoNetherlandsNorwayPolandSwedenSingaporeTurkeyJapanIndiaHungaryAfghanistanAlbaniaAlgeriaAngolaArmeniaAustriaAzerbaijanBahrainBangladeshBelarusBelizeBoliviaBosnia and HerzegovinaBotswanaBruneiBulgariaCabo VerdeCambodiaCameroonChileColombiaCosta RicaCroatiaCyprusCzech RepublicCongoDominican RepublicEcuadorEgyptEl SalvadorEstoniaEthiopiaGeorgiaGhanaGreeceGuatemalaGuyanaHaitiHondurasIcelandIndonesiaJamaicaJordanKazakhstanKuwaitLatviaLebanonLithuaniaLuxembourgMadagascarMalaysiaMaltaMauritiusMoldovaMongoliaMontenegroMoroccoMozambiqueNamibiaNepalNew ZealandNicaraguaNigeriaOmanParaguayPeruPhilippinesPortugalRomaniaSaudi ArabiaSenegalSerbiaSlovakiaSloveniaSouth AfricaSouth KoreaSri LankaThailandBahamasTrinidad and TobagoTunisiaUkraineUnited Arab EmiratesUruguayVenezuelaVietnamZambiaZimbabweLibyaPanamaPakistanTaiwanQatarUnited States (Mobile)United Kingdom (Mobile)Canada (Mobile)Germany (Mobile)France (Mobile)Spain (Mobile)Italy (Mobile)Brazil (Mobile)Australia (Mobile)Denmark (Mobile)Mexico (Mobile)Netherlands (Mobile)Sweden (Mobile)Turkey (Mobile)India (Mobile)Indonesia (Mobile)Israel (Mobile)Israel (Extended)Turkey (Extended)Denmark (Extended)Norway (Extended)Sweden (Extended)Finland (Extended)Switzerland (Extended)Israel (Mobile, Extended)All

Semrush Fields

Semrush Domains fields

The Domains report of the Semrush connector includes 5 fields.

ID Type Name Description
organic_positions_declined NUMERIC Organic Positions Declined Results that have decreased in ranking, yet still remain in the top 100.
organic_positions_improved NUMERIC Organic Positions Improved Keywords that the domain is still ranking for within the top 100 positions for, but has moved up in ranking since their previous position.
organic_positions_lost NUMERIC Organic Positions Lost Keywords that the domain was previously ranking for within the top 100 positions, but isn't any longer.
organic_positions_new NUMERIC Organic Positions New New keywords that the domain is ranking for within the top 100 organic results based on the chosen time period.
rank NUMERIC Rank Semrush rating of the website's popularity based on organic traffic coming from Google's top 100 organic search results.

Semrush Keywords fields

The Keywords report of the Semrush connector includes 9 fields.

ID Type Name Description
competition NUMERIC Competition Competitive density of advertisers using the given term for their ads. Possible values: 0-1, where 1 means the highest competition.
cpc NUMERIC CPC Average price in USD advertisers pay for a user's click on an ad containing a particular keyword (Google Ads).
intents TEXT Intents Keyword intents. Possible values: 0-3, where 0 - Commercial, 1 - Informational, 2 - Navigational, 3 - Transactional.
keyword TEXT Keyword Keyword bringing users to the website via Google's top 100 organic search results.
keyword_difficulty_index NUMERIC Keyword Difficulty Index Estimate of how difficult it would be to rank well in organic search results for a particular keyword. The higher the percentage, the harder it is to achieve high rankings for the given keyword. Possible values: 0-100, where higher is harder.
number_of_results NUMERIC Number of Results Total number of organic results returned for a given keyword at the last date of collection.
search_volume NUMERIC Search Volume Average number of times users have searched for a given keyword per month. We calculate this value over the last 12 months.
serp_features TEXT SERP Features Comma-separated list of all SERP features triggered by the keyword, e.g. FEATURED_SNIPPET, PEOPLE_ALSO_ASK, AI_OVERVIEW. Requires a Semrush API v4 key.
TEXT Trends Interest of searchers in a particular keyword during the last 12 months. This metric is based on changes in the number of queries per month.

Semrush Overview fields

The Overview report of the Semrush connector includes 145 fields.

Semrush Overview fields (adwords_cost to keywords_triggering_flights)

ID Type Name Description
adwords_cost NUMERIC Adwords Cost Estimated budget spent buying keywords in Google Ads for ads that appear in paid search results (monthly estimation).
adwords_keywords NUMERIC Adwords Keywords Keywords a website is buying in Google Ads for ads that appear in paid search results.
adwords_traffic NUMERIC Adwords Traffic Traffic brought to the website via paid search results.
database TEXT Database Regional database. Possible values: US, UK, Italy, etc.
domain TEXT Domain Domain name.
intent_commercial_positions NUMERIC Intent Commercial Positions Total number of positions with the Commercial intent.
intent_commercial_traffic NUMERIC Intent Commercial Traffic Total amount of traffic with the Commercial intent.
intent_commercial_traffic_cost NUMERIC Intent Commercial Traffic Cost Total cost of traffic with the Commercial intent.
intent_informational_positions NUMERIC Intent Informational Positions Total number of positions with the Informational intent.
intent_informational_traffic NUMERIC Intent Informational Traffic Total amount of traffic with the Informational intent.
intent_informational_traffic_cost NUMERIC Intent Informational Traffic Cost Total cost of traffic with the Informational intent.
intent_navigational_positions NUMERIC Intent Navigational Positions Total number of positions with the Navigational intent.
intent_navigational_traffic NUMERIC Intent Navigational Traffic Total amount of traffic with the Navigational intent.
intent_navigational_traffic_cost NUMERIC Intent Navigational Traffic Cost Total cost of traffic with the Navigational intent.
intent_transactional_positions NUMERIC Intent Transactional Positions Total number of positions with the Transactional intent.
intent_transactional_traffic NUMERIC Intent Transactional Traffic Total amount of traffic with the Transactional intent.
intent_transactional_traffic_cost NUMERIC Intent Transactional Traffic Cost Total cost of traffic with the Transactional intent.
intent_unknown_positions NUMERIC Intent Unknown Positions Total number of positions with unknown intent.
intent_unknown_traffic NUMERIC Intent Unknown Traffic Total amount of traffic with unknown intent.
intent_unknown_traffic_cost NUMERIC Intent Unknown Traffic Cost Total cost of traffic with unknown intent.
keywords_triggering_address_pack NUMERIC Keywords Triggering Address Pack Number of keywords the domain ranks for that trigger the Address Pack SERP Feature.
keywords_triggering_ads_bottom NUMERIC Keywords Triggering Ads Bottom Number of keywords the domain ranks for that trigger the Ads Bottom SERP Feature.
keywords_triggering_ads_middle NUMERIC Keywords Triggering Ads Middle Number of keywords the domain ranks for that trigger the Ads Middle SERP Feature.
keywords_triggering_ads_top NUMERIC Keywords Triggering Ads Top Number of keywords the domain ranks for that trigger the Ads Top SERP Feature.
keywords_triggering_ai_overview NUMERIC Keywords Triggering AI Overview Number of keywords the domain ranks for that trigger the AI Overview SERP Feature.
keywords_triggering_amp NUMERIC Keywords Triggering AMP Number of keywords the domain ranks for that trigger the AMP SERP Feature.
keywords_triggering_application NUMERIC Keywords Triggering Application Number of keywords the domain ranks for that trigger the Application SERP Feature.
keywords_triggering_application_list NUMERIC Keywords Triggering Application List Number of keywords the domain ranks for that trigger the Application List SERP Feature.
keywords_triggering_buying_guide NUMERIC Keywords Triggering Buying Guide Number of keywords the domain ranks for that trigger the Buying Guide SERP Feature.
NUMERIC Keywords Triggering Carousel Number of keywords the domain ranks for that trigger the Carousel SERP Feature.
keywords_triggering_datasets NUMERIC Keywords Triggering Datasets Number of keywords the domain ranks for that trigger the Datasets SERP Feature.
keywords_triggering_discussions_and_forums NUMERIC Keywords Triggering Discussions and Forums Number of keywords the domain ranks for that trigger the Discussions and Forums SERP Feature.
keywords_triggering_events NUMERIC Keywords Triggering Events Number of keywords the domain ranks for that trigger the Events SERP Feature.
keywords_triggering_explore_brands NUMERIC Keywords Triggering Explore Brands Number of keywords the domain ranks for that trigger the Explore Brands SERP Feature.
keywords_triggering_faq NUMERIC Keywords Triggering FAQ Number of keywords the domain ranks for that trigger the FAQ SERP Feature.
NUMERIC Keywords Triggering Featured Images Number of keywords the domain ranks for that trigger the Featured Images SERP Feature.
NUMERIC Keywords Triggering Featured Snippet Number of keywords the domain ranks for that trigger the Featured Snippet SERP Feature.
NUMERIC Keywords Triggering Featured Video Number of keywords the domain ranks for that trigger the Featured Video SERP Feature.
keywords_triggering_find_results_on NUMERIC Keywords Triggering Find Results On Number of keywords the domain ranks for that trigger the Find Results On SERP Feature.
keywords_triggering_flights NUMERIC Keywords Triggering Flights Number of keywords the domain ranks for that trigger the Flights SERP Feature.

Semrush Overview fields (keywords_triggering_hotels_pack to organic_positions_4_10)

ID Type Name Description
keywords_triggering_hotels_pack NUMERIC Keywords Triggering Hotels Pack Number of keywords the domain ranks for that trigger the Hotels Pack SERP Feature.
keywords_triggering_image NUMERIC Keywords Triggering Image Number of keywords the domain ranks for that trigger the Image SERP Feature.
keywords_triggering_image_pack NUMERIC Keywords Triggering Image Pack Number of keywords the domain ranks for that trigger the Image Pack SERP Feature.
keywords_triggering_indented NUMERIC Keywords Triggering Indented Number of keywords the domain ranks for that trigger the Indented SERP Feature.
keywords_triggering_instant_answer NUMERIC Keywords Triggering Instant Answer Number of keywords the domain ranks for that trigger the Instant Answer SERP Feature.
NUMERIC Keywords Triggering Jobs Search Number of keywords the domain ranks for that trigger the Jobs Search SERP Feature.
keywords_triggering_knowledge_panel NUMERIC Keywords Triggering Knowledge Panel Number of keywords the domain ranks for that trigger the Knowledge Panel SERP Feature.
keywords_triggering_local_pack NUMERIC Keywords Triggering Local Pack Number of keywords the domain ranks for that trigger the Local Pack SERP Feature.
keywords_triggering_news NUMERIC Keywords Triggering News Number of keywords the domain ranks for that trigger the News SERP Feature.
NUMERIC Keywords Triggering Organic Carousel Number of keywords the domain ranks for that trigger the Organic Carousel SERP Feature.
keywords_triggering_people_also_ask NUMERIC Keywords Triggering People Also Ask Number of keywords the domain ranks for that trigger the People Also Ask SERP Feature.
NUMERIC Keywords Triggering People Also Search Number of keywords the domain ranks for that trigger the People Also Search SERP Feature.
NUMERIC Keywords Triggering Popular Products Number of keywords the domain ranks for that trigger the Popular Products SERP Feature.
NUMERIC Keywords Triggering Popular Stores Number of keywords the domain ranks for that trigger the Popular Stores SERP Feature.
keywords_triggering_questions_and_answers NUMERIC Keywords Triggering Questions and Answers Number of keywords the domain ranks for that trigger the Questions and Answers SERP Feature.
keywords_triggering_recipes NUMERIC Keywords Triggering Recipes Number of keywords the domain ranks for that trigger the Recipes SERP Feature.
keywords_triggering_refine NUMERIC Keywords Triggering Refine Number of keywords the domain ranks for that trigger the Refine SERP Feature.
NUMERIC Keywords Triggering Related Products Number of keywords the domain ranks for that trigger the Related Products SERP Feature.
NUMERIC Keywords Triggering Related Searches Number of keywords the domain ranks for that trigger the Related Searches SERP Feature.
NUMERIC Keywords Triggering Related Topics Number of keywords the domain ranks for that trigger the Related Topics SERP Feature.
keywords_triggering_reviews NUMERIC Keywords Triggering Reviews Number of keywords the domain ranks for that trigger the Reviews SERP Feature.
keywords_triggering_see_results_about NUMERIC Keywords Triggering See Results About Number of keywords the domain ranks for that trigger the See Results About SERP Feature.
keywords_triggering_shopping_ads NUMERIC Keywords Triggering Shopping Ads Number of keywords the domain ranks for that trigger the Shopping Ads SERP Feature.
keywords_triggering_short_videos NUMERIC Keywords Triggering Short Videos Number of keywords the domain ranks for that trigger the Short Videos SERP Feature.
NUMERIC Keywords Triggering Sitelinks Number of keywords the domain ranks for that trigger the Sitelinks SERP Feature.
keywords_triggering_things_to_know NUMERIC Keywords Triggering Things to Know Number of keywords the domain ranks for that trigger the Things to Know SERP Feature.
keywords_triggering_top_stories NUMERIC Keywords Triggering Top Stories Number of keywords the domain ranks for that trigger the Top Stories SERP Feature.
keywords_triggering_tweet NUMERIC Keywords Triggering Tweet Number of keywords the domain ranks for that trigger the Tweet SERP Feature.
NUMERIC Keywords Triggering Twitter Carousel Number of keywords the domain ranks for that trigger the Twitter Carousel SERP Feature.
keywords_triggering_video NUMERIC Keywords Triggering Video Number of keywords the domain ranks for that trigger the Video SERP Feature.
NUMERIC Keywords Triggering Video Carousel Number of keywords the domain ranks for that trigger the Video Carousel SERP Feature.
keywords_triggering_web_stories NUMERIC Keywords Triggering Web Stories Number of keywords the domain ranks for that trigger the Web Stories SERP Feature.
organic_cost NUMERIC Organic Cost Estimated price of organic keywords in Google Ads.
organic_keywords NUMERIC Organic Keywords Keywords that bring users to a website via Google's top 100 organic search results.
organic_positions_11_20 NUMERIC Organic Positions 11-20 Organic Position Distribution. Number of keywords bringing users to the website via Google's top 100 organic search results with a ranking between positions 11 and 20.
organic_positions_1_3 NUMERIC Organic Positions 1-3 Organic Position Distribution. Number of keywords bringing users to the website via Google's top 100 organic search results with a ranking between positions 1 and 3.
organic_positions_21_30 NUMERIC Organic Positions 21-30 Organic Position Distribution. Number of keywords bringing users to the website via Google's top 100 organic search results with a ranking between positions 21 and 30.
organic_positions_31_40 NUMERIC Organic Positions 31-40 Organic Position Distribution. Number of keywords bringing users to the website via Google's top 100 organic search results with a ranking between positions 31 and 40.
organic_positions_41_50 NUMERIC Organic Positions 41-50 Organic Position Distribution. Number of keywords bringing users to the website via Google's top 100 organic search results with a ranking between positions 41 and 50.
organic_positions_4_10 NUMERIC Organic Positions 4-10 Organic Position Distribution. Number of keywords bringing users to the website via Google's top 100 organic search results with a ranking between positions 4 and 10.

Semrush Overview fields (organic_positions_51_60 to positions_in_popular_stores)

ID Type Name Description
organic_positions_51_60 NUMERIC Organic Positions 51-60 Organic Position Distribution. Number of keywords bringing users to the website via Google's top 100 organic search results with a ranking between positions 51 and 60.
organic_positions_61_70 NUMERIC Organic Positions 61-70 Organic Position Distribution. Number of keywords bringing users to the website via Google's top 100 organic search results with a ranking between positions 61 and 70.
organic_positions_71_80 NUMERIC Organic Positions 71-80 Organic Position Distribution. Number of keywords bringing users to the website via Google's top 100 organic search results with a ranking between positions 71 and 80.
organic_positions_81_90 NUMERIC Organic Positions 81-90 Organic Position Distribution. Number of keywords bringing users to the website via Google's top 100 organic search results with a ranking between positions 81 and 90.
organic_positions_91_100 NUMERIC Organic Positions 91-100 Organic Position Distribution. Number of keywords bringing users to the website via Google's top 100 organic search results with a ranking between positions 91 and 100.
organic_traffic NUMERIC Organic Traffic Traffic brought to a website via Google's top 100 organic search results.
positions_in_address_pack NUMERIC Positions in Address Pack Number of positions the domain holds in the Address Pack SERP Feature.
positions_in_ads_bottom NUMERIC Positions in Ads Bottom Number of positions the domain holds in the Ads Bottom SERP Feature.
positions_in_ads_middle NUMERIC Positions in Ads Middle Number of positions the domain holds in the Ads Middle SERP Feature.
positions_in_ads_top NUMERIC Positions in Ads Top Number of positions the domain holds in the Ads Top SERP Feature.
positions_in_ai_overview NUMERIC Positions in AI Overview Number of positions the domain holds in the AI Overview SERP Feature.
positions_in_amp NUMERIC Positions in AMP Number of positions the domain holds in the AMP SERP Feature.
positions_in_application NUMERIC Positions in Application Number of positions the domain holds in the Application SERP Feature.
positions_in_application_list NUMERIC Positions in Application List Number of positions the domain holds in the Application List SERP Feature.
positions_in_buying_guide NUMERIC Positions in Buying Guide Number of positions the domain holds in the Buying Guide SERP Feature.
NUMERIC Positions in Carousel Number of positions the domain holds in the Carousel SERP Feature.
positions_in_datasets NUMERIC Positions in Datasets Number of positions the domain holds in the Datasets SERP Feature.
positions_in_discussions_and_forums NUMERIC Positions in Discussions and Forums Number of positions the domain holds in the Discussions and Forums SERP Feature.
positions_in_events NUMERIC Positions in Events Number of positions the domain holds in the Events SERP Feature.
positions_in_explore_brands NUMERIC Positions in Explore Brands Number of positions the domain holds in the Explore Brands SERP Feature.
positions_in_faq NUMERIC Positions in FAQ Number of positions the domain holds in the FAQ SERP Feature.
NUMERIC Positions in Featured Images Number of positions the domain holds in the Featured Images SERP Feature.
NUMERIC Positions in Featured Snippet Number of positions the domain holds in the Featured Snippet SERP Feature.
NUMERIC Positions in Featured Video Number of positions the domain holds in the Featured Video SERP Feature.
positions_in_find_results_on NUMERIC Positions in Find Results On Number of positions the domain holds in the Find Results On SERP Feature.
positions_in_flights NUMERIC Positions in Flights Number of positions the domain holds in the Flights SERP Feature.
positions_in_hotels_pack NUMERIC Positions in Hotels Pack Number of positions the domain holds in the Hotels Pack SERP Feature.
positions_in_image NUMERIC Positions in Image Number of positions the domain holds in the Image SERP Feature.
positions_in_image_pack NUMERIC Positions in Image Pack Number of positions the domain holds in the Image Pack SERP Feature.
positions_in_indented NUMERIC Positions in Indented Number of positions the domain holds in the Indented SERP Feature.
positions_in_instant_answer NUMERIC Positions in Instant Answer Number of positions the domain holds in the Instant Answer SERP Feature.
NUMERIC Positions in Jobs Search Number of positions the domain holds in the Jobs Search SERP Feature.
positions_in_knowledge_panel NUMERIC Positions in Knowledge Panel Number of positions the domain holds in the Knowledge Panel SERP Feature.
positions_in_local_pack NUMERIC Positions in Local Pack Number of positions the domain holds in the Local Pack SERP Feature.
positions_in_news NUMERIC Positions in News Number of positions the domain holds in the News SERP Feature.
NUMERIC Positions in Organic Carousel Number of positions the domain holds in the Organic Carousel SERP Feature.
positions_in_people_also_ask NUMERIC Positions in People Also Ask Number of positions the domain holds in the People Also Ask SERP Feature.
NUMERIC Positions in People Also Search Number of positions the domain holds in the People Also Search SERP Feature.
NUMERIC Positions in Popular Products Number of positions the domain holds in the Popular Products SERP Feature.
NUMERIC Positions in Popular Stores Number of positions the domain holds in the Popular Stores SERP Feature.

Semrush Overview fields (positions_in_questions_and_answers to serp_features_traffic_cost)

ID Type Name Description
positions_in_questions_and_answers NUMERIC Positions in Questions and Answers Number of positions the domain holds in the Questions and Answers SERP Feature.
positions_in_recipes NUMERIC Positions in Recipes Number of positions the domain holds in the Recipes SERP Feature.
positions_in_refine NUMERIC Positions in Refine Number of positions the domain holds in the Refine SERP Feature.
NUMERIC Positions in Related Products Number of positions the domain holds in the Related Products SERP Feature.
NUMERIC Positions in Related Searches Number of positions the domain holds in the Related Searches SERP Feature.
NUMERIC Positions in Related Topics Number of positions the domain holds in the Related Topics SERP Feature.
positions_in_reviews NUMERIC Positions in Reviews Number of positions the domain holds in the Reviews SERP Feature.
positions_in_see_results_about NUMERIC Positions in See Results About Number of positions the domain holds in the See Results About SERP Feature.
positions_in_shopping_ads NUMERIC Positions in Shopping Ads Number of positions the domain holds in the Shopping Ads SERP Feature.
positions_in_short_videos NUMERIC Positions in Short Videos Number of positions the domain holds in the Short Videos SERP Feature.
NUMERIC Positions in Sitelinks Number of positions the domain holds in the Sitelinks SERP Feature.
positions_in_things_to_know NUMERIC Positions in Things to Know Number of positions the domain holds in the Things to Know SERP Feature.
positions_in_top_stories NUMERIC Positions in Top Stories Number of positions the domain holds in the Top Stories SERP Feature.
positions_in_tweet NUMERIC Positions in Tweet Number of positions the domain holds in the Tweet SERP Feature.
NUMERIC Positions in Twitter Carousel Number of positions the domain holds in the Twitter Carousel SERP Feature.
positions_in_video NUMERIC Positions in Video Number of positions the domain holds in the Video SERP Feature.
NUMERIC Positions in Video Carousel Number of positions the domain holds in the Video Carousel SERP Feature.
positions_in_web_stories NUMERIC Positions in Web Stories Number of positions the domain holds in the Web Stories SERP Feature.
serp_features_positions NUMERIC SERP Features Positions Number of keywords where the domain ranks in SERP Features.
serp_features_positions_branded NUMERIC SERP Features Positions Branded Number of branded keywords where the domain ranks in SERP Features.
serp_features_positions_lost NUMERIC SERP Features Positions Lost Keywords that the domain was previously ranking for in SERP Features, but isn't any longer.
serp_features_positions_new NUMERIC SERP Features Positions New New keywords that the domain is ranking for in SERP Features based on the chosen time period.
serp_features_traffic NUMERIC SERP Features Traffic Amount of estimated organic traffic driven to an analyzed domain from a SERP Feature position over a specific period of time.
serp_features_traffic_branded NUMERIC SERP Features Traffic Branded Amount of estimated organic traffic driven to an analyzed domain from a SERP Feature position on a branded keyword over a specific period of time.
serp_features_traffic_cost NUMERIC SERP Features Traffic Cost Estimated price to pay for the PPC ads to rank for the keywords where the domain is ranking in the SERP Features.

Semrush other fields

The Semrush connector has 24 fields that do not belong to a named report, or belong to a report with only one or two fields.

ID Type Name Description Report
account_id TEXT Account ID Account ID in Windsor.ai.
account_name TEXT Account Name Account name in Windsor.ai.
account_type TEXT Account Type Account type. Possible values: domain, subdomain, subfolder, url, keyword.
data_fetched_at TIMESTAMP Data fetched at UTC timestamp (second precision) of when the connector request that pulled the row started. Freshly pulled rows show this request's start time; cache hits keep the start time of the request that filled the cache. Selecting this field disables aggregation, so rows are returned individually (each keeping its own fetch time) instead of being summed.
datasource TEXT Data Source The name of the Windsor connector returning the row
date DATE Date Date of the record. For monthly history reports it's the first day of the month.
day_of_month TEXT Day of month Day of the month
month TEXT Month Number of the month
now TIMESTAMP Now Current timestamp
pla_keywords NUMERIC PLA Keywords Number of keywords the website is using for product listing ads.
pla_uniques NUMERIC PLA Uniques Number of unique product listing ads (PLA Copies).
source TEXT Source The name of the Windsor connector returning the row
today DATE Today Today's date
week TEXT Week Week (Sun-Sat).
week_day TEXT Day of week and day number Weekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday.
week_day_iso TEXT Day of week and day number, ISO Weekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7
week_iso TEXT Week ISO Week, ISO format (Mon-Sun).
year TEXT Year Year
year_month TEXT Yearmonth Year and month, e.g. 2024|3
year_month_name TEXT Year month name Year and month with the month name written out, e.g. "Jan 2025".
year_of_week TEXT Year of week The year that contains first day of the week (Sun-Sat).
year_of_week_iso TEXT Year of week, ISO The year that contains first day of the ISO week (Mon-Sun).
year_week TEXT Year week Year and week for US weeks (Sun-Sat), e.g. 2024|15
year_week_iso TEXT Year week ISO Year and week for ISO weeks (Mon-Sun), e.g. 2024|20