Pardot Field Reference

Sample

The Salesforce Pardot connector fetches data from the Pardot API


Fields

IDTypeNameDescriptionReport
account_address_oneTEXTAccount Address OneAccount contact address, line 1.
account_address_twoTEXTAccount Address TwoAccount contact address, line 2.
account_admin_idTEXTAccount Admin IDID of the individual who is the admin for this account.
account_api_calls_usedTEXTAccount API Calls UsedTotal daily API requests based on the timezone for this account.
account_cityCITYAccount CityAccount contact city.
account_companyTEXTAccount CompanyAccount company.
account_countryCOUNTRYAccount CountryAccount contact country (full string).
account_created_atTIMESTAMPAccount Created AtThe timestamp of when this object was created.
account_created_by_idTEXTAccount Created By IDID of the individual who created this object.
account_faxTEXTAccount FaxAccount contact fax number.
account_idTEXTAccount IDAccount Engagement ID for this instance.
account_levelTEXTAccount LevelThe level of product for the account.
account_maximum_daily_api_callsTEXTAccount Maximum Daily API CallsMaximum daily API requests based on the timezone for this account.
account_phoneTEXTAccount PhoneAccount contact phone number.
account_plugin_campaign_idTEXTAccount Plugin Campaign IDPlugin ID for account campaign.
account_stateTEXTAccount StateAccount contact state.
account_territoryTEXTAccount TerritoryAccount contact ZIP code.
account_updated_atTIMESTAMPAccount Updated AtThe timestamp of when this object was last updated.
account_updated_by_idTEXTAccount Updated By IDID of the individual who created this object.
account_websiteTEXTAccount WebsiteAccount website.
account_zipTEXTAccount ZipAccount contact territory.
activity_campaign_idTEXTActivity Campaign IDAccount Engagement ID for the associated campaign.
activity_created_atTIMESTAMPActivity Created AtTime that visitor activity occurred; Time is reported in API user's preferred timezone.
activity_custom_redirect_idTEXTActivity Custom Redirect IDAccount Engagement ID of the custom redirect associated with this visitor activity Note: Appears only if this visitor activity has a custom redirect associated with it.
activity_detailsTEXTActivity DetailsDetails about this visitor activity such as the name of the object associated with this activity, the search phrase used in a site search query, etc.
activity_email_idTEXTActivity Email IDAccount Engagement ID of the email associated with this visitor activity. Appears only if this visitor activity has an email associated with it.
activity_email_template_idTEXTActivity Email Template IDAccount Engagement ID of the email template associated with this visitor activity. Appears only if this visitor activity has an email associated with it.
activity_file_idTEXTActivity File IDAccount Engagement ID of the file associated with this visitor activity. Appears only if this visitor activity has a file associated with it.
activity_form_handler_idTEXTActivity Form Handler IDAccount Engagement ID of the form handler associated with this visitor activity. Appears only if this visitor activity has a form handler associated with it.
activity_form_idTEXTActivity Form IDAccount Engagement ID of the form associated with this visitor activity. Appears only if this visitor activity has a form associated with it.
activity_idTEXTActivity Account IDAccount Engagement ID for this visitor activity.
activity_landing_page_idTEXTActivity Landing Page IDAccount Engagement ID of the landing page associated with this visitor activity. Appears only if this visitor activity has a landing page associated with it.
activity_list_email_idTEXTActivity List Email IDAccount Engagement ID of the list email associated with this visitor activity. Appears only if this visitor activity has an email associated with it.
activity_multivariate_test_variation_idTEXTActivity Multivariate Test Variation IDAccount Engagement ID of the multivariate test variation associated with this visitor activity. Appears only if this visitor activity has a multivariate test variation associated with it.
activity_opportunity_idTEXTActivity Opportunity IDAccount Engagement ID for the associated opportunity.
activity_paid_search_ad_idTEXTActivity Paid Search Ad IDAccount Engagement ID of the paid search ad associated with this visitor activity. Appears only if this visitor activity has a paid search ad associated with it.
activity_prospect_idTEXTActivity Prospect IDAccount Engagement ID for the associated prospect.
activity_site_search_query_idTEXTActivity Site Search Query IDAccount Engagement ID of the site search query associated with this visitor activity. Appears only if this visitor activity has a site search query associated with it.
activity_typeTEXTActivity TypeVisitor activity's type number.
activity_type_nameTEXTActivity Type NameVisitor activity's type name.
activity_updated_atTIMESTAMPActivity Updated AtTime that visitor activity update occurred; Time is reported in API user's preferred timezone.
activity_visit_idTEXTActivity Visit IDAccount Engagement ID for the associated visit.
activity_visitor_idTEXTActivity Visitor IDAccount Engagement ID for the associated visitor.
activity_visitor_page_view_idTEXTActivity Visitor Page View IDAccount Engagement ID for the associated visitor page view.
campaignTEXTCampaignThe Campaign Name
campaign_costNUMERICCampaign CostCost of the campaign object.
campaign_created_atTIMESTAMPCampaign Created AtThe timestamp of when this object was created.
campaign_created_by_idTEXTCampaign Created By IDID of the individual who created this object.
campaign_folder_idTEXTCampaign Folder IDID of the folder containing this object.
campaign_idTEXTCampaign IDID of the object.
campaign_is_deletedBOOLEANCampaign Is DeletedTrue if the object is in the recycle bin in Account Engagement.
campaign_nameTEXTCampaign NameName of the object for identification in Account Engagement.
campaign_parent_campaign_idTEXTCampaign Parent Campaign ID (Pardot)The ID of the parent campaign.
campaign_salesforce_idTEXTCampaign Salesforce IDSalesforce Id of the object.
campaign_updated_atTIMESTAMPCampaign Updated AtThe timestamp of when this object was last updated.
campaign_updated_by_idTEXTCampaign Updated By IDID of the individual who last updated this object.
datasourceTEXTData SourceThe name of the Windsor connector returning the row
dateDATEDateThe Date
day_of_monthTEXTDay of monthDay of the month
email_campaign_idTEXTEmail Campaign IDID of the campaign associated with the email.
email_client_typeTEXTEmail Client TypeValue is 'Builder' if the email was sent via the Lightning Email Builder. Value is 'Web' if it was sent via the legacy Pardot email builder.
email_created_by_idTEXTEmail Created By IDID of the user who created this object.
email_html_messageTEXTEmail Html MessageThe HTML content of the email's message. This field isn’t queryable.
email_idTEXTEmail IDID of the email.
email_list_email_idTEXTEmail List Email IDID of the list email associated with this email.
email_list_idTEXTEmail List IDDeprecated, always NULL. Reference the List Email object's reciepientLists and suppressionLists fields for all lists associated with the email.
email_nameTEXTEmail NameName of the email for identification in Pardot.
email_sent_atTIMESTAMPEmail Sent AtTime the email was sent.
email_stats_click_open_ratioPERCENTEmail Stats Click Open RatioThe ratio between email clicks and opens.Email Statistics
email_stats_click_through_ratePERCENTEmail Stats Click Through RateThe click-through rate based on the number of emails delivered.Email Statistics
email_stats_deliveredNUMERICEmail Stats DeliveredThe number of emails delivered.Email Statistics
email_stats_delivery_ratePERCENTEmail Stats Delivery RateThe delivery rate based on the number of emails sent.Email Statistics
email_stats_hard_bouncedNUMERICEmail Stats Hard BouncedThe number of hard bounces for the email.Email Statistics
email_stats_opensNUMERICEmail Stats OpensThe number of opens for the email.Email Statistics
email_stats_opens_ratePERCENTEmail Stats Opens RateThe open rate based on the number of emails delivered.Email Statistics
email_stats_opt_out_ratePERCENTEmail Stats Opt Out RateThe opt-out rate based on the number of emails delivered.Email Statistics
email_stats_opt_outsNUMERICEmail Stats Opt OutsThe number of opt outs for the emailEmail Statistics
email_stats_sentNUMERICEmail Stats SentThe number of emails sent.Email Statistics
email_stats_soft_bouncedNUMERICEmail Stats Soft BouncedThe number of soft bounces for the email.Email Statistics
email_stats_spam_complaint_ratePERCENTEmail Stats Spam Complaint RateThe spam complaint rate based on the number of emails delivered.Email Statistics
email_stats_spam_complaintsNUMERICEmail Stats Spam ComplaintsThe number of spam complaints for the email.Email Statistics
email_stats_total_clicksNUMERICEmail Stats Total ClicksThe total number of clicks for the email.Email Statistics
email_stats_unique_click_through_ratePERCENTEmail Stats Unique Click Through RateThe unique click-through rate based on the number of emails delivered.Email Statistics
email_stats_unique_clicksNUMERICEmail Stats Unique ClicksThe number of unique clicks for the email.Email Statistics
email_stats_unique_opensNUMERICEmail Stats Unique OpensThe number of unique opens for the email.Email Statistics
email_subjectTEXTEmail SubjectThe email subject.
email_text_messageTEXTEmail Text MessageThe text content of the email's message. This field isn’t queryable.
monthTEXTMonthNumber of the month
opportunity_campaign_idTEXTOpportunity Campaign IDAccount Engagement ID of the campaign associated with this opportunity. Information about an opportunity's campaign association can be returned using the Campaign relationship.
opportunity_closed_atTIMESTAMPOpportunity Closed AtThe opportunity's closed date. When left blank, the Closed Date field in Account Engagement isn’t set, even when the opportunity's stage, status, or probability are set to indicate that the opportunity is closed.
opportunity_created_atTIMESTAMPOpportunity Created AtTime opportunity is created in Account Engagement; Time is reported in API user's preferred timezone.
opportunity_created_by_idTEXTOpportunity Created By IDID of the user who created this object.
opportunity_idTEXTOpportunity IDAccount Engagement ID for this opportunity.
opportunity_nameTEXTOpportunity NameThe opportunity's name
opportunity_probabilityNUMERICOpportunity ProbabilityThe opportunity's probability. Must be a positive numeric value from 0 through 100, inclusive.
opportunity_salesforce_idTEXTOpportunity Salesforce IDThe ID of the associated opportunity in Salesforce.
opportunity_stageTEXTOpportunity Stage NameThe opportunity's stage.
opportunity_statusTEXTOpportunity StatusThe opportunity's status. Status must be either won, lost, or open.
opportunity_typeTEXTOpportunity TypeThe opportunity's type.
opportunity_updated_atTIMESTAMPOpportunity Updated AtLast time opportunity was updated in Account Engagement; Time is reported in API user's preferred timezone.
opportunity_updated_by_idTEXTOpportunity Updated By IDID of the user who last updated this object.
opportunity_valueNUMERICOpportunity ValueThe opportunity's value. Must be a positive numeric value.
prospect_account_annual_revenueNUMERICProspect Account Annual RevenueAnnual Revenue of the object.
prospect_account_assigned_toTEXTProspect Account Assigned ToUser object representing the user who the object record is assigned to. See documentation for User for fields.
prospect_account_assigned_to_idTEXTProspect Account Assigned To IDID of the user who the object record is assigned to.
prospect_account_billing_address_oneTEXTProspect Account Billing Address OneBilling Address of the object.
prospect_account_billing_address_twoTEXTProspect Account Billing Address TwoSecond Billing Address of the object.
prospect_account_billing_cityCITYProspect Account Billing CityCity of the object.
prospect_account_billing_countryCOUNTRYProspect Account Billing CountryCounty of the object.
prospect_account_billing_stateTEXTProspect Account Billing StateState of the object.
prospect_account_billing_zipTEXTProspect Account Billing ZipZip of the object.
prospect_account_created_atTIMESTAMPProspect Account Created AtCreation time of the object.
prospect_account_created_byTEXTProspect Account Created ByUser object representing the user who created this object. See documentation for User for fields.
prospect_account_created_by_idTEXTProspect Account Created By IDID of the user who created this object.
prospect_account_descriptionTEXTProspect Account DescriptionDescription of the object.
prospect_account_employeesTEXTProspect Account EmployeesEmployees of the object.
prospect_account_faxTEXTProspect Account FaxFax of the object.
prospect_account_idTEXTProspect Account IDID of the object.
prospect_account_industryTEXTProspect Account IndustryIndustry of the object.
prospect_account_is_deletedBOOLEANProspect Account Is DeletedTrue if the object is in the recycle bin in Account Engagement.
prospect_account_nameTEXTProspect Account NameName of the object for identification in Account Engagement.
prospect_account_numberTEXTProspect Account NumberNumber of the object.
prospect_account_ownershipTEXTProspect Account OwnershipOwnership of the object.
prospect_account_phoneTEXTProspect Account PhonePhone Number of the object.
prospect_account_ratingTEXTProspect Account RatingRating of the object.
prospect_account_shipping_address_oneTEXTProspect Account Shipping Address OneShipping Address of the object.
prospect_account_shipping_address_twoTEXTProspect Account Shipping Address TwoSecond Shipping Address of the object.
prospect_account_shipping_cityCITYProspect Account Shipping CityShipping Address city of the object.
prospect_account_shipping_countryCOUNTRYProspect Account Shipping CountryShipping Address country of the object.
prospect_account_shipping_stateTEXTProspect Account Shipping StateShipping Address state of the object.
prospect_account_shipping_zipTEXTProspect Account Shipping ZipShipping Address zip of the object.
prospect_account_sicTEXTProspect Account SicSIC of the object.
prospect_account_siteTEXTProspect Account SiteSite of the object.
prospect_account_ticker_symbolTEXTProspect Account Ticker SymbolTicker Symbol of the object.
prospect_account_typeTEXTProspect Account TypeType of the object.
prospect_account_updated_atTIMESTAMPProspect Account Updated AtLast update time of the object.
prospect_account_updated_byTEXTProspect Account Updated ByUser object representing the user who last updated this object. See documentation for User for fields.
prospect_account_updated_by_idTEXTProspect Account Updated By IDID of the user who last updated this object.
prospect_account_websiteTEXTProspect Account WebsiteWebsite of the object.
prospect_address_oneTEXTProspect Address OneProspect's address, line 1.
prospect_address_twoTEXTProspect Address TwoProspect's address, line 2.
prospect_annual_revenueTEXTProspect Annual RevenueProspect's annual revenue.
prospect_assigned_toTEXTProspect Assigned ToUser the prospect is assigned to.
prospect_assigned_to_idTEXTProspect Assigned To IDUser the prospect is assigned to.
prospect_campaign_idTEXTProspect Campaign IDAccount Engagement campaign related to this object.
prospect_campaign_parameterTEXTProspect Campaign ParameterProspect's campaign parameter utm_campaign from Google Analytics.
prospect_cityCITYProspect CityProspect's city.
prospect_commentsTEXTProspect CommentsComments about this prospect.
prospect_companyTEXTProspect CompanyProspect's company.
prospect_content_parameterTEXTProspect Content ParameterProspect's content parameter utm_content from Google Analytics.
prospect_converted_atTIMESTAMPProspect Converted AtTime when prospect was converted from visitor.
prospect_converted_from_object_nameTEXTProspect Converted From Object NameName of object associated with visitor activity that resulted in prospect being converted from visitor.
prospect_converted_from_object_typeTEXTProspect Converted From Object TypeType of object associated with visitor activity that resulted in prospect being converted from visitor. Supported values include 'Form', 'FormHandler', 'LandingPage', 'MultivariateTestVariation', and 'Video'.
prospect_countryCOUNTRYProspect CountryProspect's country.
prospect_created_atTIMESTAMPProspect Created AtCreation time of the object.
prospect_created_byTEXTProspect Created ByUser who created this object.
prospect_created_by_idTEXTProspect Created By IDID of the user who created this object.
prospect_departmentTEXTProspect DepartmentProspect's department.
prospect_do_not_sellTEXTProspect Do Not SellIndicates whether the prospect, or a visitor associated with the propect, recorded an activity with the Global Privacy Control Header enabled.
prospect_emailTEXTProspect EmailProspect's email address.
prospect_email_bounced_atTIMESTAMPProspect Email Bounced AtTime when prospect email address hard bounced.
prospect_email_bounced_reasonTEXTProspect Email Bounced ReasonReason why prospect email address hard bounced.
prospect_employeesTEXTProspect EmployeesProspect's number of employees.
prospect_faxTEXTProspect FaxProspect's fax number.
prospect_first_activity_atTIMESTAMPProspect First Activity AtTime when first visitor activity occurred for this prospect.
prospect_first_assigned_atTIMESTAMPProspect First Assigned AtTime prospect was first assigned to a user.
prospect_first_nameTEXTProspect First NameProspect's first name.
prospect_first_referrer_queryTEXTProspect First Referrer QueryFirst referrer's search query.
prospect_first_referrer_typeTEXTProspect First Referrer TypeFirst referrer's vendor and type (such as 'Google Natural Search').
prospect_first_referrer_urlTEXTProspect First Referrer URLFirst referrer's URL.
prospect_gradeTEXTProspect GradeProspect's letter grade.
prospect_idTEXTProspect IDID of the object.
prospect_industryTEXTProspect IndustryProspect's industry.
prospect_is_deletedTEXTProspect Is DeletedTrue if the object is in the recycle bin in Account Engagement.
prospect_is_do_not_callTEXTProspect Is Do Not CallIf true, prospect prefers not to be called.
prospect_is_do_not_emailTEXTProspect Is Do Not EmailIf true, prospect prefers not to be emailed.
prospect_is_email_hard_bouncedTEXTProspect Is Email Hard BouncedIf true, prospect email address has hard bounced.
prospect_is_reviewedTEXTProspect Is ReviewedIf true, prospect has been reviewed.
prospect_is_starredTEXTProspect Is StarredIf true, prospect has been starred.
prospect_job_titleTEXTProspect Job TitleProspect's job title.
prospect_last_activity_atTIMESTAMPProspect Last Activity AtTime stamp of this prospect's latest visitor activity.
prospect_last_nameTEXTProspect Last NameProspect's last name.
prospect_lifecycle_stage_idTEXTProspect Lifecycle Stage IDAccount Engagement lifecycle stage related to this object.
prospect_medium_parameterTEXTProspect Medium ParameterProspect's medium parameter utm_medium from Google Analytics.
prospect_notesTEXTProspect NotesNotes about this prospect.
prospect_opted_outTEXTProspect Opted OutIf true, prospect has opted out of marketing communications.
prospect_passwordTEXTProspect PasswordProspect's password.
prospect_phoneTEXTProspect PhoneProspect's phone number.
prospect_profile_idTEXTProspect Profile IDAccount Engagement profile related to this object.
prospect_prospect_accountTEXTProspect Prospect AccountProspect Account related to this object.
prospect_prospect_account_idTEXTProspect Prospect Account IDProspect's account ID. Can be specified only if there’s no CRM connector.
prospect_recent_interactionTEXTProspect Recent InteractionDescribes the prospect's most recent interaction with Account Engagement.
prospect_salesforce_account_idTEXTProspect Salesforce Account IDAccount ID in a supported Salesforce system.
prospect_salesforce_campaign_idTEXTProspect Salesforce Campaign IDThe alpha-numeric Id of the associated campaign in the Salesforce Org.
prospect_salesforce_contact_idTEXTProspect Salesforce Contact IDProspect's contact ID in a supported Salesforce system.
prospect_salesforce_idTEXTProspect Salesforce IDSalesforce Id of the object. Is unique to a single prospect, so it can't be specified for multiple prospects.
prospect_salesforce_last_syncTEXTProspect Salesforce Last SyncLast time this prospect was synced with a supported Salesforce system.
prospect_salesforce_lead_idTEXTProspect Salesforce Lead IDProspect's lead ID in a supported Salesforce system.
prospect_salesforce_owner_idTEXTProspect Salesforce Owner IDSalesforce user that the prospect record is owned by. You must have the Prospects > Prospects > Assign ability to specify this field. You can specify either userId or salesforceOwnerId in a request.
prospect_salesforce_urlTEXTProspect Salesforce URLURL to view the prospect within the Salesforce system.
prospect_salutationTEXTProspect SalutationProspect's formal prefix.
prospect_scoreNUMERICProspect ScoreProspect's score.
prospect_sourceTEXTProspect SourceProspect's source.
prospect_source_parameterTEXTProspect Source ParameterProspect's source parameter utm_source from Google Analytics.
prospect_stateTEXTProspect StateProspect's US state.
prospect_term_parameterTEXTProspect Term ParameterProspect's term parameter utm_term from Google Analytics.
prospect_territoryTEXTProspect TerritoryProspect's territory.
prospect_updated_atTIMESTAMPProspect Updated AtLast update time of the object.
prospect_updated_byTEXTProspect Updated ByUser who last updated this object.
prospect_updated_by_idTEXTProspect Updated By IDID of the user who last updated this object.
prospect_user_idTEXTProspect User IDUser the prospect is assigned to. You must have the Prospects > Prospects > Assign ability to specify this field. You can specify either userId or salesforceOwnerId in a request.
prospect_websiteTEXTProspect WebsiteProspect's website URL.
prospect_years_in_businessTEXTProspect Years In BusinessProspect's number of years in business.
prospect_zipTEXTProspect ZIPProspect's postal code.
sourceTEXTSourceThe name of the Windsor connector returning the row
todayDATETodayToday's date
visit_campaign_parameterTEXTVisit Campaign ParameterVisit's campaign parameter utm_campaign from Google Analytics.
visit_content_parameterTEXTVisit Content ParameterVisit's content parameter utm_content from Google Analytics.
visit_created_atTIMESTAMPVisit Created AtCreation time of this object.
visit_duration_in_secondsNUMERICVisit Duration In SecondsLength of this visit.
visit_first_visitor_page_view_atTIMESTAMPVisit First Visitor Page View AtTime of first page view for this visit; Time is reported in API user's preferred timezone.
visit_idTEXTVisit IDID of the object.
visit_last_visitor_page_view_atTIMESTAMPVisit Last Visitor Page View AtTime of last page view for this visit; Time is reported in API user's preferred timezone.
visit_medium_parameterTEXTVisit Medium ParameterVisit's medium parameter utm_medium from Google Analytics.
visit_prospect_idTEXTVisit Prospect IDAccount Engagement ID for the associated prospect.
visit_source_parameterTEXTVisit Source ParameterVisit's source parameter utm_source from Google Analytics.
visit_term_parameterTEXTVisit Term ParameterVisit's term parameter utm_term from Google Analytics.
visit_updated_atTIMESTAMPVisit Updated AtLast updated time for the object.
visit_visitor_idTEXTVisit Visitor IDAccount Engagement ID for the associated visitor.
visit_visitor_page_view_countNUMERICVisit Visitor Page View CountNumber of page views for this visit.
visitor_campaign_idTEXTVisitor Campaign IDCampaign ID for the associated visitor.
visitor_campaign_parameterTEXTVisitor Campaign ParameterVisitor's campaign parameter utm_campaign from Google Analytics.
visitor_content_parameterTEXTVisitor Content ParameterVisitor's content parameter utm_content from Google Analytics.
visitor_created_atTIMESTAMPVisitor Created AtCreation time of this object.
visitor_do_not_sellBOOLEANVisitor Do Not SellIndicates whether the prospect, or a visitor associated with the propect, recorded an activity with the Global Privacy Control Header enabled.
visitor_hostnameTEXTVisitor HostnameEquivalent to visitor.hostname
visitor_idTEXTVisitor IDID of the object.
visitor_ip_addressTEXTVisitor IP AddressEquivalent to visitor.ip_address
visitor_is_identifiedBOOLEANVisitor Is IdentifiedIf True, the visitor's company is identified.
visitor_page_view_campaign_idTEXTVisitor Page View Campaign IDAccount Engagement ID for the associated campaign.
visitor_page_view_countNUMERICVisitor Page View CountEquivalent to visitor.visitor_page_view_count
visitor_page_view_created_atTIMESTAMPVisitor Page View Created AtCreation time of this object.
visitor_page_view_duration_in_secondsNUMERICVisitor Page View Duration In SecondsLength of this page view.
visitor_page_view_idTEXTVisitor Page View IDID of the object.
visitor_page_view_salesforce_idTEXTVisitor Page View Salesforce IDSalesforce Id of the object.
visitor_page_view_titleTEXTVisitor Page View TitlePage title.
visitor_page_view_urlTEXTVisitor Page View URLPage view URL.
visitor_page_view_visit_idTEXTVisitor Page View Visit IDAccount Engagement ID for the associated visit.
visitor_page_view_visitor_idTEXTVisitor Page View Visitor IDAccount Engagement ID for the associated visitor.
visitor_prospect_idTEXTVisitor Prospect IDAccount Engagement ID for the associated prospect.
visitor_source_parameterTEXTVisitor Source ParameterVisitor's source parameter utm_source from Google Analytics.
visitor_term_parameterTEXTVisitor Term ParameterVisitor's term parameter utm_term from Google Analytics.
visitor_updated_atTIMESTAMPVisitor Updated AtLast updated time for the object.
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).
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