API Connectors

users-love-us medal soc2
Send your GoHighLevel data to
Data StudioGoogle SheetsChatGPTClaudePower BIExcelTableauGoogle BigQueryAmazon S3Azure Blob StorageSnowflakeMySQLPostgreSQLPythonAzure SQLAmazon RedshiftDatabricksWindsor MCPMicrosoft FabricCopilot AgentPerplexityLovableAntigravitySupabaseGemini EnterpriseCursorManusGrok

GoHighLevel Connector Reference

16 metrics232 dimensions
Fields Actions

The GoHighLevel connector supports custom fields

The GoHighLevel connector exposes 248 fields (16 metrics, 232 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.


Available actions


Create Contact Create a contact in the connected GoHighLevel location. Provide at least one of first_name, last_name, name, email or phone; the rest (company, address, website, timezone, source, tags) are optional. GoHighLevel deduplicates on email/phone within the location, so a matching contact may be updated instead of a new one created. Use update_contact to change an existing contact by id.

Create a contact in the connected GoHighLevel location. Provide at least one of first_name, last_name, name, email or phone; the rest (company, address, website, timezone, source, tags) are optional. GoHighLevel deduplicates on email/phone within the location, so a matching contact may be updated instead of a new one created. Use update_contact to change an existing contact by id.

Parameters
first_namestringlast_namestringnamestringemailstringphonestringcompany_namestringaddress1stringcitystringstatestringpostal_codestringcountrystringwebsitestringtimezonestringsourcestringtagsstring
Update Contact Update an existing GoHighLevel contact by id. Only the fields you provide are changed; omit a field to leave it untouched. Tags replace the contact's existing tags rather than adding to them. The contact_id can be obtained from a GoHighLevel contacts query or the create_contact result.

Update an existing GoHighLevel contact by id. Only the fields you provide are changed; omit a field to leave it untouched. Tags replace the contact's existing tags rather than adding to them. The contact_id can be obtained from a GoHighLevel contacts query or the create_contact result.

Parameters
first_namestringlast_namestringnamestringemailstringphonestringcompany_namestringaddress1stringcitystringstatestringpostal_codestringcountrystringwebsitestringtimezonestringsourcestringtagsstringcontact_idstringRequired
Create Invoice Create a draft invoice in the connected GoHighLevel location for an existing contact. Provide the contact_id, a business_name, a currency (ISO code such as USD), issue and due dates (YYYY-MM-DD) and at least one line item (name, amount, optional qty and description). Item amounts are per-unit in the invoice currency. The invoice is created as a draft and is not sent to the contact; send it from the GoHighLevel UI. contact_id comes from a GoHighLevel contacts query or the create_contact result.

Create a draft invoice in the connected GoHighLevel location for an existing contact. Provide the contact_id, a business_name, a currency (ISO code such as USD), issue and due dates (YYYY-MM-DD) and at least one line item (name, amount, optional qty and description). Item amounts are per-unit in the invoice currency. The invoice is created as a draft and is not sent to the contact; send it from the GoHighLevel UI. contact_id comes from a GoHighLevel contacts query or the create_contact result.

Parameters
namestringRequiredcurrencystringRequiredcontact_idstringRequiredbusiness_namestringRequireditemsarrayRequiredissue_datestringRequireddue_datestringRequiredcontact_namestringcontact_emailstringlive_modeboolean

GoHighLevel Fields

GoHighLevel Contacts fields

The Contacts report of the GoHighLevel connector includes 50 fields.

GoHighLevel Contacts fields (contact_additional_emails to contact_last_name_lower_case)

ID Type Name Description
contact_additional_emails OBJECT Contact Additional Emails Contact's additional emails.
contact_additional_phones OBJECT Contact Additional Phones Contact's additional phone numbers.
contact_address TEXT Contact Address Contact's address.
contact_assigned_to TEXT Contact Assigned To User assigned to the contact.
contact_business_id TEXT Contact Business ID Contact's business ID.
contact_business_name TEXT Contact Business Name Contact's business name.
contact_city CITY Contact City Contact's city.
contact_company TEXT Contact Company Name Contact's company name.
contact_country COUNTRY Contact Country Contact's country.
contact_date_added TIMESTAMP Contact Date Added Date when the contact was added.
contact_date_of_birth TEXT Contact Date of Birth Contact's date of birth.
contact_date_updated TIMESTAMP Contact Date Updated Date when the contact was last updated.
contact_dnd BOOLEAN Contact DND Contact's Do Not Disturb status.
contact_email TEXT Contact Email Contact's email address.
contact_first_attribution_ad_id TEXT Contact First Attribution Ad ID Ad platform ad ID of the contact's first touch.
contact_first_attribution_ad_source TEXT Contact First Attribution Ad Source Ad platform that the contact's first touch came from.
contact_first_attribution_campaign TEXT Contact First Attribution Campaign Campaign of the contact's first touch.
contact_first_attribution_campaign_id TEXT Contact First Attribution Campaign ID Ad platform campaign ID of the contact's first touch.
contact_first_attribution_content TEXT Contact First Attribution Content utmContent of the contact's first touch.
contact_first_attribution_medium TEXT Contact First Attribution Medium Medium of the contact's first touch.
contact_first_attribution_medium_id TEXT Contact First Attribution Medium ID Medium ID of the contact's first touch.
contact_first_attribution_session_source TEXT Contact First Attribution Session Source Traffic category of the contact's first touch, e.g. Paid Social.
contact_first_attribution_utm_medium TEXT Contact First Attribution UTM Medium utmMedium of the contact's first touch.
contact_first_attribution_utm_source TEXT Contact First Attribution UTM Source utmSource of the contact's first touch, e.g. facebook.
contact_first_name TEXT Contact First Name Contact's first name.
contact_first_name_lower_case TEXT Contact First Name Lower Case Contact's first name in lower case.
contact_followers OBJECT Contact Followers Followers of the contact.
contact_id TEXT Contact ID Contact's unique identifier.
contact_last_attribution_ad_id TEXT Contact Last Attribution Ad ID Ad platform ad ID of the contact's last touch.
contact_last_attribution_ad_source TEXT Contact Last Attribution Ad Source Ad platform that the contact's last touch came from.
contact_last_attribution_campaign TEXT Contact Last Attribution Campaign Campaign of the contact's last touch.
contact_last_attribution_campaign_id TEXT Contact Last Attribution Campaign ID Ad platform campaign ID of the contact's last touch.
contact_last_attribution_content TEXT Contact Last Attribution Content utmContent of the contact's last touch.
contact_last_attribution_medium TEXT Contact Last Attribution Medium Medium of the contact's last touch.
contact_last_attribution_medium_id TEXT Contact Last Attribution Medium ID Medium ID of the contact's last touch.
contact_last_attribution_session_source TEXT Contact Last Attribution Session Source Traffic category of the contact's last touch, e.g. Paid Social.
contact_last_attribution_utm_medium TEXT Contact Last Attribution UTM Medium utmMedium of the contact's last touch.
contact_last_attribution_utm_source TEXT Contact Last Attribution UTM Source utmSource of the contact's last touch, e.g. facebook.
contact_last_name TEXT Contact Last Name Contact's last name.
contact_last_name_lower_case TEXT Contact Last Name Lower Case Contact's last name in lower case.

GoHighLevel Contacts fields (contact_opportunities to contact_website)

ID Type Name Description
contact_opportunities OBJECT Contact Opportunities Opportunities associated with the contact.
contact_phone TEXT Contact Phone Contact's phone number.
contact_phone_label TEXT Contact Phone Label Contact's phone label.
contact_postal_code TEXT Contact Postal Code Contact's postal code.
contact_source TEXT Contact Source Contact's source.
contact_state REGION Contact State Contact's state.
contact_tags OBJECT Contact Tags Contact's tags.
contact_type TEXT Contact Type Contact's type.
contact_valid_email TEXT Contact Valid Email Contact's valid email.
contact_website TEXT Contact Website Contact's website.

GoHighLevel Conversations fields

The Conversations report of the GoHighLevel connector includes 20 fields.

ID Type Name Description
conversation_company_name TEXT Conversation Company Name Company name of the contact in the conversation.
conversation_contact_id TEXT Conversation Contact ID ID of the contact associated with the conversation.
conversation_contact_name TEXT Conversation Contact Name Name of the contact in the conversation.
conversation_date_added TIMESTAMP Conversation Date Added Date when the conversation was added.
conversation_date_updated TIMESTAMP Conversation Date Updated Date when the conversation was last updated.
conversation_email TEXT Conversation Email Email of the contact in the conversation.
conversation_followers OBJECT Conversation Followers Followers of the conversation.
conversation_full_name TEXT Conversation Full Name Full name of the contact in the conversation.
conversation_id TEXT Conversation ID Conversation's unique identifier.
conversation_is_last_message_internal_comment BOOLEAN Conversation Is Last Message Internal Comment Indicates if the last message is an internal comment.
conversation_last_manual_message_date TIMESTAMP Conversation Last Manual Message Date Date of the last manual message in the conversation.
conversation_last_message_body TEXT Conversation Last Message Body Body of the last message in the conversation.
conversation_last_message_date TIMESTAMP Conversation Last Message Date Date of the last message in the conversation.
conversation_last_message_direction TEXT Conversation Last Message Direction Direction of the last message in the conversation.
conversation_last_message_type TEXT Conversation Last Message Type Type of the last message in the conversation.
conversation_last_outbound_message_action TEXT Conversation Last Outbound Message Action Action of the last outbound message in the conversation.
conversation_phone TEXT Conversation Phone Phone number of the contact in the conversation.
conversation_tags OBJECT Conversation Tags Tags associated with the conversation.
conversation_type TEXT Conversation Type Type of the conversation.
conversation_unread_count NUMERIC Conversation Unread Count Number of unread messages in the conversation.

GoHighLevel Invoices fields

The Invoices report of the GoHighLevel connector includes 23 fields.

ID Type Name Description
invoice_amount_due NUMERIC Invoice Amount Due Amount due for the invoice.
invoice_amount_paid NUMERIC Invoice Amount Paid Amount paid for the invoice.
invoice_automatic_taxes_calculated BOOLEAN Invoice Automatic Taxes Calculated Indicates if automatic taxes have been calculated for the invoice.
invoice_automatic_taxes_enabled BOOLEAN Invoice Automatic Taxes Enabled Indicates if automatic taxes are enabled for the invoice.
invoice_contact_details OBJECT Invoice Contact Details Contact details associated with the invoice.
invoice_created_at DATE Invoice Created At Timestamp when the invoice was created.
invoice_currency TEXT Invoice Currency Currency of the invoice.
invoice_discount OBJECT Invoice Discount Discount applied to the invoice.
invoice_due_date DATE Invoice Due Date Date when the invoice is due.
invoice_id TEXT Invoice ID Invoice's unique identifier.
invoice_issue_date DATE Invoice Issue Date Date when the invoice was issued.
invoice_items OBJECT Invoice Items List of items included in the invoice.
invoice_live_mode BOOLEAN Invoice Live Mode Indicates if the invoice is in live mode.
invoice_name TEXT Invoice Name Name of the invoice.
invoice_number TEXT Invoice Number Number of the invoice.
invoice_payment_schedule TEXT Invoice Payment Schedule Payment schedule for the invoice.
invoice_status TEXT Invoice Status Status of the invoice.
invoice_title TEXT Invoice Title Title of the invoice.
invoice_total NUMERIC Invoice Total Total amount of the invoice.
invoice_total_summary_discount NUMERIC Invoice Total Summary Discount Discount amount for the invoice total summary.
invoice_total_summary_sub_total NUMERIC Invoice Total Summary Sub Total Sub total amount for the invoice total summary.
invoice_total_summary_tax NUMERIC Invoice Total Summary Tax Tax amount for the invoice total summary.
invoice_updated_at DATE Invoice Updated At Timestamp when the invoice was last updated.

GoHighLevel Location fields

The Location report of the GoHighLevel connector includes 38 fields.

ID Type Name Description
account_id TEXT Account ID Location's unique identifier.
account_name TEXT Account Name Name of the location.
location_address TEXT Location Address Address of the location.
location_business_address TEXT Location Business Address Business address associated with the location.
location_business_city CITY Location Business City Business city associated with the location.
location_business_country COUNTRY Location Business Country Business country associated with the location.
location_business_logo_url IMAGE_URL Location Business Logo URL Business logo URL associated with the location.
location_business_name TEXT Location Business Name Business name associated with the location.
location_business_postal_code TEXT Location Business Postal Code Business postal code associated with the location.
location_business_state REGION Location Business State Business state associated with the location.
location_business_timezone TEXT Location Business Timezone Business timezone associated with the location.
location_business_website TEXT Location Business Website Business website associated with the location.
location_city CITY Location City City of the location.
location_company_id TEXT Location Company ID Company ID associated with the location.
location_country COUNTRY Location Country Country of the location.
location_domain TEXT Location Domain Domain of the location.
location_email TEXT Location Email Email associated with the location.
location_first_name TEXT Location First Name First name associated with the location.
location_id TEXT Location ID Location's unique identifier.
location_last_name TEXT Location Last Name Last name associated with the location.
location_logo_url IMAGE_URL Location Logo URL Logo URL of the location.
location_name TEXT Location Name Name of the location.
location_phone TEXT Location Phone Phone number associated with the location.
location_postal_code TEXT Location Postal Code Postal code of the location.
location_social_blog_rss TEXT Location Social Blog RSS Blog RSS URL associated with the location.
location_social_facebook_url TEXT Location Social Facebook URL Facebook URL associated with the location.
location_social_foursquare TEXT Location Social Foursquare Foursquare URL associated with the location.
location_social_google_places_id TEXT Location Social Google Places ID Google Places ID associated with the location.
location_social_google_plus TEXT Location Social Google Plus Google Plus URL associated with the location.
location_social_instagram TEXT Location Social Instagram Instagram URL associated with the location.
location_social_linkedin TEXT Location Social LinkedIn LinkedIn URL associated with the location.
location_social_pinterest TEXT Location Social Pinterest Pinterest URL associated with the location.
location_social_twitter TEXT Location Social Twitter Twitter URL associated with the location.
location_social_yelp TEXT Location Social Yelp Yelp URL associated with the location.
location_social_youtube TEXT Location Social YouTube YouTube URL associated with the location.
location_state REGION Location State State of the location.
location_timezone TEXT Location Timezone Timezone of the location.
location_website TEXT Location Website Website of the location.

GoHighLevel Opportunities fields

The Opportunities report of the GoHighLevel connector includes 36 fields.

ID Type Name Description
opportunity_assigned_to TEXT Opportunity Assigned To User assigned to the opportunity.
opportunity_contact_company_name TEXT Opportunity Contact Company Name Contact's company name associated with the opportunity.
opportunity_contact_email TEXT Opportunity Contact Email Contact's email associated with the opportunity.
opportunity_contact_id TEXT Opportunity Contact ID Contact ID associated with the opportunity.
opportunity_contact_name TEXT Opportunity Contact Name Contact name associated with the opportunity.
opportunity_contact_phone TEXT Opportunity Contact Phone Contact's phone number associated with the opportunity.
opportunity_contact_tags TEXT Opportunity Contact Tags Tags associated with the contact of the opportunity.
opportunity_created_at TIMESTAMP Opportunity Created At Timestamp when the opportunity was created.
opportunity_first_attribution_campaign TEXT Opportunity First Attribution Campaign Campaign of the opportunity's first touch.
opportunity_first_attribution_campaign_id TEXT Opportunity First Attribution Campaign ID Ad platform campaign ID of the opportunity's first touch.
opportunity_first_attribution_content TEXT Opportunity First Attribution Content utmContent of the opportunity's first touch.
opportunity_first_attribution_medium TEXT Opportunity First Attribution Medium Medium of the opportunity's first touch.
opportunity_first_attribution_medium_id TEXT Opportunity First Attribution Medium ID Medium ID of the opportunity's first touch.
opportunity_first_attribution_session_source TEXT Opportunity First Attribution Session Source Traffic category of the opportunity's first touch, e.g. Paid Social.
opportunity_first_attribution_utm_medium TEXT Opportunity First Attribution UTM Medium utmMedium of the opportunity's first touch.
opportunity_first_attribution_utm_source TEXT Opportunity First Attribution UTM Source utmSource of the opportunity's first touch, e.g. facebook.
opportunity_id TEXT Opportunity ID Opportunity's unique identifier.
opportunity_last_attribution_campaign TEXT Opportunity Last Attribution Campaign Campaign of the opportunity's last touch.
opportunity_last_attribution_campaign_id TEXT Opportunity Last Attribution Campaign ID Ad platform campaign ID of the opportunity's last touch.
opportunity_last_attribution_content TEXT Opportunity Last Attribution Content utmContent of the opportunity's last touch.
opportunity_last_attribution_medium TEXT Opportunity Last Attribution Medium Medium of the opportunity's last touch.
opportunity_last_attribution_medium_id TEXT Opportunity Last Attribution Medium ID Medium ID of the opportunity's last touch.
opportunity_last_attribution_session_source TEXT Opportunity Last Attribution Session Source Traffic category of the opportunity's last touch, e.g. Paid Social.
opportunity_last_attribution_utm_medium TEXT Opportunity Last Attribution UTM Medium utmMedium of the opportunity's last touch.
opportunity_last_attribution_utm_source TEXT Opportunity Last Attribution UTM Source utmSource of the opportunity's last touch, e.g. facebook.
opportunity_last_stage_change_at TIMESTAMP Opportunity Last Stage Change At Timestamp of the last stage change of the opportunity.
opportunity_last_status_change_at TIMESTAMP Opportunity Last Status Change At Timestamp of the last status change of the opportunity.
opportunity_lost_reason_id TEXT Opportunity Lost Reason ID Lost reason ID of the opportunity.
opportunity_monetary_value NUMERIC Opportunity Monetary Value Monetary value of the opportunity.
opportunity_name TEXT Opportunity Name Name of the opportunity.
opportunity_pipeline_id TEXT Opportunity Pipeline ID Pipeline ID of the opportunity.
opportunity_pipeline_stage_id TEXT Opportunity Pipeline Stage ID Pipeline stage ID of the opportunity.
opportunity_pipeline_stage_uid TEXT Opportunity Pipeline Stage UID Pipeline stage UID of the opportunity.
opportunity_source TEXT Opportunity Source Source of the opportunity.
opportunity_status TEXT Opportunity Status Status of the opportunity.
opportunity_updated_at TIMESTAMP Opportunity Updated At Timestamp when the opportunity was last updated.

GoHighLevel Orders fields

The Orders report of the GoHighLevel connector includes 23 fields.

ID Type Name Description
order_amount NUMERIC Order Amount Amount of the order.
order_contact_email TEXT Order Contact Email Contact email associated with the order.
order_contact_id TEXT Order Contact ID Contact ID associated with the order.
order_contact_name TEXT Order Contact Name Contact name associated with the order.
order_coupon_code TEXT Order Coupon Code Coupon code applied to the order.
order_created_at TIMESTAMP Order Created At Timestamp when the order was created.
order_created_by TEXT Order Created By User who created the order.
order_currency TEXT Order Currency Currency of the order.
order_discount NUMERIC Order Discount Discount applied to the order.
order_fulfillment_status TEXT Order Fulfillment Status Fulfillment status of the order.
order_id TEXT Order ID Order's unique identifier.
order_live_mode BOOLEAN Order Live Mode Indicates if the order is in live mode.
order_onetime_products NUMERIC Order Onetime Products Onetime products in the order.
order_recurring_products NUMERIC Order Recurring Products Recurring products in the order.
order_source_id TEXT Order Source ID Source ID of the order.
order_source_meta OBJECT Order Source Meta Source metadata of the order.
order_source_name TEXT Order Source Name Source name of the order.
order_source_sub_type TEXT Order Source Sub Type Source sub-type of the order.
order_source_type TEXT Order Source Type Source type of the order.
order_status TEXT Order Status Status of the order.
order_subtotal NUMERIC Order Subtotal Subtotal of the order.
order_total_products NUMERIC Order Total Products Total number of products in the order.
order_updated_at TIMESTAMP Order Updated At Timestamp when the order was last updated.

GoHighLevel Pipelines fields

The Pipelines report of the GoHighLevel connector includes 5 fields.

ID Type Name Description
pipeline_id TEXT Pipeline ID Pipeline's unique identifier.
pipeline_name TEXT Pipeline Name Name of the pipeline.
pipeline_show_in_funnel BOOLEAN Pipeline Show In Funnel Indicates if the pipeline is shown in the funnel view.
pipeline_show_in_pie_chart BOOLEAN Pipeline Show In Pie Chart Indicates if the pipeline is shown in the pie chart view.
pipeline_stages OBJECT Pipeline Stages Stages within the pipeline.

GoHighLevel Transactions fields

The Transactions report of the GoHighLevel connector includes 27 fields.

ID Type Name Description
transaction_amount NUMERIC Transaction Amount Amount of the transaction.
transaction_amount_refunded NUMERIC Transaction Amount Refunded Amount refunded for the transaction.
transaction_charge_id TEXT Transaction Charge ID Charge ID associated with the transaction.
transaction_charge_snapshot OBJECT Transaction Charge Snapshot Charge snapshot associated with the transaction.
transaction_contact_id TEXT Transaction Contact ID Contact ID associated with the transaction.
transaction_contact_name TEXT Transaction Contact Name Name of the contact associated with the transaction.
transaction_created_at TIMESTAMP Transaction Created At Timestamp when the transaction was created.
transaction_created_by TEXT Transaction Created By User who created the transaction.
transaction_currency TEXT Transaction Currency Currency of the transaction.
transaction_entity_id TEXT Transaction Entity ID Entity ID of the transaction.
transaction_entity_source_id TEXT Transaction Entity Source ID Entity source ID of the transaction.
transaction_entity_source_meta OBJECT Transaction Entity Source Meta Entity source metadata of the transaction.
transaction_entity_source_name TEXT Transaction Entity Source Name Entity source name of the transaction.
transaction_entity_source_sub_type TEXT Transaction Entity Source Sub Type Entity source sub-type of the transaction.
transaction_entity_source_type TEXT Transaction Entity Source Type Entity source type of the transaction.
transaction_entity_type TEXT Transaction Entity Type Entity type of the transaction.
transaction_fulfilled_at TIMESTAMP Transaction Fulfilled At Timestamp when the transaction was fulfilled.
transaction_id TEXT Transaction ID Transaction's unique identifier.
transaction_ip_address TEXT Transaction IP Address IP address associated with the transaction.
transaction_live_mode BOOLEAN Transaction Live Mode Indicates if the transaction is in live mode.
transaction_merged_from_contact_id TEXT Transaction Merged From Contact ID Merged from contact ID associated with the transaction.
transaction_payment_method TEXT Transaction Payment Method Payment method used for the transaction.
transaction_payment_provider_connected_account TEXT Transaction Payment Provider Connected Account Payment provider connected account of the transaction.
transaction_payment_provider_type TEXT Transaction Payment Provider Type Payment provider type of the transaction.
transaction_status TEXT Transaction Status Status of the transaction.
transaction_subscription_id TEXT Transaction Subscription ID Subscription ID associated with the transaction.
transaction_updated_at TIMESTAMP Transaction Updated At Timestamp when the transaction was last updated.

GoHighLevel Users fields

The Users report of the GoHighLevel connector includes 7 fields.

ID Type Name Description
user_deleted BOOLEAN User Deleted Indicates if the user is deleted.
user_email TEXT User Email Email of the user.
user_first_name TEXT User First Name First name of the user.
user_id TEXT User ID User's unique identifier.
user_last_name TEXT User Last Name Last name of the user.
user_name TEXT User Name Name of the user.
user_phone TEXT User Phone Phone number of the user.

GoHighLevel other fields

The GoHighLevel connector has 19 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
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 Record's date.
day_of_month TEXT Day of month Day of the month
month TEXT Month Number of the month
now TIMESTAMP Now Current timestamp
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