HubSpot Field Reference

Sample

The HubSpot connector allows to retrieve HubSpot data from standard and custom objects.

Important: Custom fields and custom objects are not available on the list below. To make them available go to https://onboard.windsor.ai/app/hubspot and connect your HubSpot account.

http://connectors.windsor.ai/hubspot?fields=contact_firstname,contact_lastname,contact_email,contact_company,contact_phone,contact_lifecyclestage&api_key=[your API key]


Fields

IDTypeNameDescriptionObject
account_idTEXTAccount IDYour Hubspot account IDAccount
account_nameTEXTAccount NameYour Hubspot account nameAccount
companyTEXTContact Company Name (Alias)Alias for contact_companycontact
company_about_usTEXTCompany About UsShort about-companycompany
company_addressTEXTCompany Street AddressThe street address of the company or organization, including unit number. Powered by HubSpot Insights.company
company_address2TEXTCompany Street Address 2The additional address of the company or organization. Powered by HubSpot Insights.company
company_annualrevenueNUMERICCompany Annual RevenueThe actual or estimated annual revenue of the company. Powered by HubSpot Insights.company
company_cityCITYCompany CityThe city where the company is located. Powered by HubSpot Insights.company
company_closedateTIMESTAMPCompany Close DateThe date the company or organization was closed as a customercompany
company_countryCOUNTRYCompany Country/RegionThe country/region in which the company or organization is located. Powered by HubSpot Insights.company
company_createdateTIMESTAMPCompany Create DateThe date the company or organization was added to the databasecompany
company_days_to_closeNUMERICCompany Days to CloseThe number of days between when the company record was created and when they closed as a customer.company
company_descriptionTEXTCompany DescriptionA short statement about the company's mission and goals. Powered by HubSpot Insights.company
company_domainTEXTCompany Domain NameThe domain name of the company or organizationcompany
company_engagements_last_meeting_bookedTIMESTAMPCompany Date of last meeting booked in meetings toolThe date of the most recent meeting an associated contact has booked through the meetings tool.company
company_engagements_last_meeting_booked_campaignTEXTCompany Campaign of last booking in meetings toolThis UTM parameter shows which marketing campaign (e.g. a specific email) referred an associated contact to the meetings tool for their most recent booking. This property is only populated when you add tracking parameters to your meeting link.company
company_engagements_last_meeting_booked_mediumTEXTCompany Medium of last booking in meetings toolThis UTM parameter shows which channel (e.g. email) referred an associated contact to the meetings tool for their most recent booking. This property is only populated when you add tracking parameters to your meeting link.company
company_engagements_last_meeting_booked_sourceTEXTCompany Source of last booking in meetings toolThis UTM parameter shows which site (e.g. Twitter) referred an associated contact to the meetings tool for their most recent booking. This property is only populated when you add tracking parameters to your meeting link.company
company_facebook_company_pageTEXTCompany Facebook Company PageThe URL of the Facebook company page for the company or organizationcompany
company_facebookfansNUMERICCompany Facebook FansNumber of facebook fanscompany
company_first_contact_createdateTIMESTAMPCompany First Contact Create DateThe date that the first contact from this company entered the system, which could pre-date the company's create datecompany
company_first_conversion_dateTIMESTAMPCompany First Conversion DateThe first conversion date across all contacts associated this company or organizationcompany
company_first_conversion_event_nameTEXTCompany First ConversionThe first form submitted across all contacts associated this company or organizationcompany
company_first_deal_created_dateTIMESTAMPCompany First Deal Created DateThe create date of the first deal associated with this company record.company
company_founded_yearTEXTCompany Year FoundedThe year the company was created. Powered by HubSpot Insights.company
company_googleplus_pageTEXTCompany Google Plus PageThe URL of the Google Plus page for the company or organizationcompany
company_hs_analytics_first_timestampTIMESTAMPCompany Time First SeenThe first activity for any contact associated with this company or organizationcompany
company_hs_analytics_first_touch_converting_campaignTEXTCompany First Touch Converting CampaignThe campaign responsible for the first touch creation of the first contact associated with this companycompany
company_hs_analytics_first_visit_timestampTIMESTAMPCompany Time of First SessionTime of first session across all contacts associated with this company or organizationcompany
company_hs_analytics_last_timestampTIMESTAMPCompany Time Last SeenTime last seen across all contacts associated with this company or organizationcompany
company_hs_analytics_last_touch_converting_campaignTEXTCompany Last Touch Converting CampaignThe campaign responsible for the last touch creation of the first contact associated with this companycompany
company_hs_analytics_last_visit_timestampTIMESTAMPCompany Time of Last SessionTime of the last session attributed to any contacts that are associated with this company record.company
company_hs_analytics_num_page_viewsNUMERICCompany Number of PageviewsTotal number of page views across all contacts associated with this company or organizationcompany
company_hs_analytics_num_visitsNUMERICCompany Number of SessionsTotal number of sessions across all contacts associated with this company or organizationcompany
company_hs_analytics_sourceTEXTCompany Original Source TypeOriginal source for the contact with the earliest activity for this company or organizationcompany
company_hs_analytics_source_data_1TEXTCompany Original Source Data 1Additional information about the original source for the contact with the earliest activity for this company or organizationcompany
company_hs_analytics_source_data_2TEXTCompany Original Source Data 2Additional information about the original source for the contact with the earliest activity for this company or organizationcompany
company_hs_createdateTIMESTAMPCompany object create date/timeThe date and time at which this object was created. This value is automatically set by HubSpot and may not be modified.company
company_hs_ideal_customer_profileTEXTCompany Ideal Customer Profile TierThis property shows how well a Company matches your Ideal Customer Profile. Companies that are Tier 1 should be a great fit for your products/services where Tier 3 might be acceptable, but low prioritycompany
company_hs_is_target_accountBOOLEANCompany Target AccountThe Target Account property identifies the companies that you are marketing and selling to as part of your account-based strategy.company
company_hs_last_booked_meeting_dateTIMESTAMPCompany Last Booked Meeting DateThe last date of booked meetings associated with the companycompany
company_hs_last_logged_call_dateTIMESTAMPCompany Last Logged Call DateThe last date of logged calls associated with the companycompany
company_hs_last_open_task_dateTIMESTAMPCompany Last Open Task DateThe last due date of open tasks associated with the companycompany
company_hs_last_sales_activity_timestampTIMESTAMPCompany Last Engagement DateThe last time a contact engaged with your site or a form, document, meetings link, or tracked email. This doesn't include marketing emails or emails to multiple contacts.company
company_hs_lastmodifieddateTIMESTAMPCompany Last Modified DateMost recent timestamp of any property update for this company. This includes HubSpot internal properties, which can be visible or hidden. This property is updated automatically.company
company_hs_lead_statusTEXTCompany Lead StatusThe company's sales, prospecting or outreach statuscompany
company_hs_num_blockersNUMERICCompany Number of blockersThe number of contacts associated with this company with the role of blocker.company
company_hs_num_child_companiesNUMERICCompany Number of child companiesThe number of child companies of this companycompany
company_hs_num_contacts_with_buying_rolesNUMERICCompany Number of contacts with a buying roleThe number of contacts associated with this company with a buying role.company
company_hs_num_decision_makersNUMERICCompany Number of decision makersThe number of contacts associated with this company with the role of decision maker.company
company_hs_num_open_dealsNUMERICCompany Number of open dealsThe number of open deals associated with this company.company
company_hs_object_idNUMERICCompany IDThe unique ID for this company. This unique ID is automatically populated by HubSpot and cannot be changed.company
company_hs_parent_company_idNUMERICParent CompanyThe parent company of this companycompany
company_hs_predictivecontactscore_v2NUMERICCompany Likelihood to closeThe highest probability that a contact associated with this company will become a customer within the next 90 days. This score is based on standard contact properties and behavior.company
company_hs_total_deal_valueNUMERICCompany Total open deal valueThe total value, in your company's currency, of all open deals associated with this companycompany
company_hubspot_owner_assigneddateTIMESTAMPCompany Owner Assigned DateThe timestamp when an owner was assigned to this companycompany
company_hubspot_owner_idTEXTCompany ownerThe owner of the companycompany
company_hubspot_team_idTEXTCompany HubSpot TeamThe team of the owner of the company.company
company_industryTEXTCompany IndustryThe type of business the company performs. By default, this property has approximately 150 pre-defined options to select from. While these options cannot be deleted as they used by HubSpot Insights, you can add new custom options to meet your needs.company
company_is_publicBOOLEANCompany Is PublicIndicates that the company is publicly traded. Powered by HubSpot Insights.company
company_lifecyclestageTEXTCompany Lifecycle StageThe most advanced lifecycle stage across all contacts associated with this company or organizationcompany
company_linkedin_company_pageTEXTLinkedIn Company PageThe URL of the LinkedIn company page for the company or organizationcompany
company_linkedinbioTEXTCompany LinkedIn BioThe LinkedIn bio for the company or organizationcompany
company_nameTEXTCompany Name (Duplicate)The name of the company or organization. Powered by HubSpot Insights.company
company_notes_last_contactedTIMESTAMPCompany Last ContactedThe last timestamp when a call, email or meeting was logged for a contact at this company.company
company_notes_last_updatedTIMESTAMPCompany Last Activity DateThe last time a note, call, meeting, or task was logged for a company. This is set automatically by HubSpot based on user actions in the company record.company
company_notes_next_activity_dateTIMESTAMPCompany Next Activity DateThe date of the next upcoming scheduled sales activity for this company record.company
company_num_associated_contactsNUMERICCompany Associated ContactsThe number of contacts associated with this companycompany
company_num_associated_dealsNUMERICCompany Associated DealsThe number of deals associated with this companycompany
company_num_contacted_notesNUMERICCompany Number of times contactedThe number of times a call, email or meeting was logged for this companycompany
company_num_conversion_eventsNUMERICCompany Number of Form SubmissionsThe number of forms submission for all contacts associated with this company or organizationcompany
company_numberofemployeesNUMERICCompany Number of EmployeesThe total number of employees who work for the company or organizationcompany
company_owneremailTEXTCompany HubSpot Owner EmailHubSpot owner email for this company or organizationcompany
company_ownernameTEXTCompany HubSpot Owner NameHubSpot owner name for this company or organizationcompany
company_phoneTEXTCompany Phone NumberA company's primary phone number. Powered by HubSpot Insights.company
company_recent_conversion_dateTIMESTAMPCompany Recent Conversion DateThe most recent conversion date across all contacts associated this company or organizationcompany
company_recent_conversion_event_nameTEXTCompany Recent ConversionThe last form submitted across all contacts associated this company or organizationcompany
company_recent_deal_amountNUMERICCompany Recent Deal AmountThe amount of the last deal closedcompany
company_recent_deal_close_dateTIMESTAMPCompany Recent Deal Close DateThe date of the last `closed won` deal associated with this company record.company
company_stateREGIONCompany State/RegionThe state or region in which the company or organization is located. Powered by HubSpot Insights.company
company_timezoneTEXTCompany Time ZoneThe time zone where the company or organization is located. Powered by HubSpot Insights.company
company_total_money_raisedTEXTCompany Total Money RaisedThe total amount of money raised by the company. Powered by HubSpot Insights.company
company_total_revenueNUMERICCompany Total RevenueThe total amount of closed won dealscompany
company_twitterbioTEXTCompany Twitter BioThe Twitter bio of the company or organizationcompany
company_twitterfollowersNUMERICCompany Twitter FollowersThe number of Twitter followers of the company or organizationcompany
company_twitterhandleTEXTCompany Twitter HandleThe main twitter account of the company or organizationcompany
company_typeTEXTCompany TypeThe optional classification of this company record - prospect, partner, etc.company
company_web_technologiesTEXTCompany Web TechnologiesThe web technologies used by the company or organization. Powered by HubSpot Insights.company
company_websiteTEXTCompany Website URLThe main website of the company or organization. This property is used to identify unique companies. Powered by HubSpot Insights.company
company_zipTEXTCompany Postal CodeThe postal or zip code of the company or organization. Powered by HubSpot Insights.company
contact_addressTEXTContact Street AddressA contact's street address, including apartment or unit #contact
contact_annualrevenueTEXTContact Annual RevenueAnnual company revenuecontact
contact_cityCITYContact CityA contact's city of residencecontact
contact_closedateTIMESTAMPContact Close DateThe date that a contact became a customer. This property is set automatically by HubSpot when a deal or opportunity is marked as closed-won. It can also be set manually or programmatically.contact
contact_companyTEXTContact Company NameThe name of the contact's company. This is separate from the Name property of the contact's associated company and can be set independently.contact
contact_company_sizeTEXTContact Company sizeA contact's company size. This property is required for the Facebook Ads Integration. This property will be automatically synced via the Lead Ads toolcontact
contact_countryCOUNTRYContact Country/RegionThe contact's country/region of residence. This might be set via import, form, or integration.contact
contact_createdateTIMESTAMPContact Create DateThe date that a contact entered the systemcontact
contact_currentlyinworkflowTEXTContact Currently in workflowIf the contact is currently enrolled in any workflowcontact
contact_date_of_birthTEXTContact Date of birthA contact's date of birth. This property is required for the Facebook Ads Integration. This property will be automatically synced via the Lead Ads toolcontact
contact_days_to_closeNUMERICContact Days To CloseThe days that elapsed from when a contact was created until they closed as a customer. This is set automatically by HubSpot and can be used for segmentation and reporting.contact
contact_degreeTEXTContact DegreeA contact's degree. This property is required for the Facebook Ads Integration. This property will be automatically synced to via Lead Ads toolcontact
contact_emailTEXTContact EmailA contact's email addresscontact
contact_engagements_last_meeting_bookedTIMESTAMPContact date of last meeting booked in meetings toolThe date of the most recent meeting a contact has booked through the meetings tool.contact
contact_engagements_last_meeting_booked_campaignTEXTContact Campaign of last booking in meetings toolThis UTM parameter shows which marketing campaign (e.g. a specific email) referred the contact to the meetings tool for their most recent booking. This property is only populated when you add tracking parameters to your meeting link.contact
contact_engagements_last_meeting_booked_mediumTEXTContact Medium of last booking in meetings toolThis UTM parameter shows which channel (e.g. email) referred the contact to the meetings tool for their most recent booking. This property is only populated when you add tracking parameters to your meeting link.contact
contact_engagements_last_meeting_booked_sourceTEXTContact Source of last booking in meetings toolThis UTM parameter shows which site (e.g. Twitter) referred the contact to the meetings tool for their most recent booking. This property is only populated when you add tracking parameters to your meeting link.contact
contact_faxTEXTContact Fax NumberA contact's primary fax numbercontact
contact_field_of_studyTEXTContact Field of studyA contact's field of study. This property is required for the Facebook Ads Integration. This property will be automatically synced via the Lead Ads toolcontact
contact_first_conversion_dateTIMESTAMPContact First Conversion DateThe date this contact first submitted a formcontact
contact_first_conversion_event_nameTEXTContact First ConversionThe first form this contact submittedcontact
contact_first_deal_created_dateTIMESTAMPContact First Deal Created DateThe date the first deal for a contact was created. This is automatically set by HubSpot and can be used for segmentation and reporting.contact
contact_firstnameTEXTContact First NameA contact's first namecontact
contact_followercountNUMERICContact Follower CountThe number of Twitter followers a contact hascontact
contact_genderTEXTContact Gendercontact
contact_graduation_dateTEXTContact Graduation dateA contact's graduation date. This property is required for the Facebook Ads Integration. This property will be automatically synced via the Lead Ads toolcontact
contact_hs_analytics_average_page_viewsNUMERICContact Average PageviewsThe average number of pages a contact sees. This is automatically set by HubSpot for each contact.contact
contact_hs_analytics_first_referrerTEXTContact First Referring SiteThe first website that referred a contact to your website. This is automatically set by HubSpot for each contact.contact
contact_hs_analytics_first_timestampTIMESTAMPContact Time First SeenThe first time a contact has been seen. This is automatically set by HubSpot for each contact.contact
contact_hs_analytics_first_touch_converting_campaignTEXTContact First Touch Converting CampaignThe campaign responsible for the first touch creation of this contactcontact
contact_hs_analytics_first_urlTEXTContact First Page SeenThe first page a contact saw on your website. This is automatically set by HubSpot for each contact.contact
contact_hs_analytics_first_visit_timestampTIMESTAMPContact time of First SessionThe first time a contact visited your website. This is automatically set by HubSpot for each contact.contact
contact_hs_analytics_last_referrerTEXTContact Last Referring SiteThe last website that referred a contact to your website. This is automatically set by HubSpot for each contact.contact
contact_hs_analytics_last_timestampTIMESTAMPContact Time Last SeenThe last time and date a contact has viewed a page on your website.contact
contact_hs_analytics_last_touch_converting_campaignTEXTContact Last Touch Converting CampaignThe campaign responsible for the last touch creation of this contactcontact
contact_hs_analytics_last_urlTEXTContact Last Page SeenThe last page a contact saw on your website. This is automatically set by HubSpot for each contact.contact
contact_hs_analytics_last_visit_timestampTIMESTAMPContact time of Last SessionThe last time and date a contact visited your website.contact
contact_hs_analytics_num_event_completionsNUMERICContact Number of event completionsThe sum of all events a contact has experienced. This is automatically set by HubSpot for each contact.contact
contact_hs_analytics_num_page_viewsNUMERICContact Number of PageviewsThe sum of all pages a contact has seen on your website. This is automatically set by HubSpot for each contact.contact
contact_hs_analytics_num_visitsNUMERICContact Number of SessionsThe sum of all sessions a contact has made to your website. This is automatically set by HubSpot for each contact.contact
contact_hs_analytics_revenueNUMERICContact Event RevenueEvent revenue can be set on a contact though HubSpot's enterprise Events. http://help.hubspot.com/articles/KCS_Article/Reports/How-do-I-create-Events-in-HubSpotcontact
contact_hs_analytics_sourceTEXTContact Original SourceFirst known source the contact used to find your website. Set automatically, but may be updated manually.contact
contact_hs_analytics_source_data_1TEXTContact Original Source Drill-Down 1Additional information about the source through which a contact first found your website. This property is automatically set by HubSpot.contact
contact_hs_analytics_source_data_2TEXTContact Original Source Drill-Down 2Additional information about the source through which a contact first found your website. This property is automatically set by HubSpot.contact
contact_hs_buying_roleTEXTContact Buying RoleThe role that a contact plays during the sales process. Contacts can have more than one role, and they can share the same role with another contact.contact
contact_hs_content_membership_email_confirmedBOOLEANContact Email ConfirmedEmail Confirmation status of user of Content Membershipcontact
contact_hs_content_membership_notesTEXTContact Membership NotesThe notes relating to the contact's content membership.contact
contact_hs_content_membership_registered_atTIMESTAMPContact Registered AtDatetime at which this user was set up for Content Membershipcontact
contact_hs_content_membership_registration_domain_sent_toTEXTContact Domain to which registration email was sentDomain to which the registration invitation email for Content Membership was sent tocontact
contact_hs_content_membership_registration_email_sent_atTIMESTAMPContact Time registration email was sentDatetime at which this user was sent a registration invitation email for Content Membershipcontact
contact_hs_content_membership_statusTEXTContact StatusThe status of the contact's content membership.contact
contact_hs_createdateTIMESTAMPContact Object create date/timeThe date and time at which this object was created. This value is automatically set by HubSpot and may not be modified.contact
contact_hs_email_bad_addressBOOLEANContact Invalid email addressThe email address associated with this contact is invalid.contact
contact_hs_email_bounceNUMERICContact Marketing emails bouncedThe number of marketing emails that bounced for the current email address. This is automatically set by HubSpot.contact
contact_hs_email_clickNUMERICContact Marketing emails clickedThe number of marketing emails which have had link clicks for the current email address. This is automatically set by HubSpot.contact
contact_hs_email_customer_quarantined_reasonTEXTContact Email address quarantine reasonThe reason why the email address has been quarantined.contact
contact_hs_email_deliveredNUMERICContact Marketing emails deliveredThe number of marketing emails delivered for the current email address. This is automatically set by HubSpot.contact
contact_hs_email_domainTEXTContact Email DomainA contact's email address domaincontact
contact_hs_email_first_click_dateTIMESTAMPContact First marketing email click dateThe date of the earliest link click for any marketing email to the current email address. This is automatically set by HubSpot.contact
contact_hs_email_first_open_dateTIMESTAMPContact Concat first marketing email open dateThe date of the earliest open for any marketing email to the current email address. This is automatically set by HubSpot.contact
contact_hs_email_first_reply_dateTIMESTAMPContact First marketing email reply dateThe date of the earliest reply for any marketing email to the current email address. This is automatically set by HubSpot.contact
contact_hs_email_first_send_dateTIMESTAMPContact first marketing email send dateThe date of the earliest delivery for any marketing email to the current email address. This is automatically set by HubSpot.contact
contact_hs_email_hard_bounce_reason_enumTEXTContact Email hard bounce reasonThe issue that caused a contact to hard bounce from your emails. If this is an error or a temporary issue, you can unbounce this contact from the contact record.contact
contact_hs_email_last_click_dateTIMESTAMPContact last marketing email click dateThe date of the most recent link click for any marketing email to the current email address. This is automatically set by HubSpot.contact
contact_hs_email_last_email_nameTEXTContact Last marketing email nameThe name of the last marketing email sent to the current email address. This is automatically set by HubSpot.contact
contact_hs_email_last_open_dateTIMESTAMPContact Last marketing email open dateThe date of the most recent open for any marketing email to the current email address. This is automatically set by HubSpot.contact
contact_hs_email_last_reply_dateTIMESTAMPContact Last marketing email reply dateThe date of the latest reply for any marketing email to the current email address. This is automatically set by HubSpot.contact
contact_hs_email_last_send_dateTIMESTAMPContact Contac last marketing email send dateThe date of the most recent delivery for any marketing email to the current email address. This is automatically set by HubSpot.contact
contact_hs_email_openNUMERICContact Marketing emails openedThe number of marketing emails opened for the current email address. This is automatically set by HubSpot.contact
contact_hs_email_optoutBOOLEANContact Unsubscribed from all emailIndicates that the current email address has opted out of all email.contact
contact_hs_email_quarantinedBOOLEANContact Email Address QuarantinedIndicates that the current email address has been quarantined for anti-abuse reasons and any marketing email sends to it will be blocked. This is automatically set by HubSpot.contact
contact_hs_email_quarantined_reasonTEXTContact Email address automated quarantine reasonThe automated reason why the email address has been quarantined.contact
contact_hs_email_repliedNUMERICContact Marketing emails repliedThe number of marketing emails replied to by the current email address. This is automatically set by HubSpot.contact
contact_hs_email_sends_since_last_engagementNUMERICContact Sends Since Last EngagementThe number of marketing emails that have been sent to the current email address since the last engagement (open or link click). This is automatically set by HubSpot.contact
contact_hs_emailconfirmationstatusTEXTContact Marketing email confirmation statusThe status of a contact's eligibility to receive marketing email. This is automatically set by HubSpot.contact
contact_hs_facebook_click_idTEXTContact Facebook click idcontact
contact_hs_feedback_last_nps_follow_upTEXTContact Last NPS survey commentLast NPS survey comment that this contact gavecontact
contact_hs_feedback_last_nps_ratingTEXTContact Last NPS survey ratingLast NPS survey rating that this contact gavecontact
contact_hs_feedback_last_survey_dateTIMESTAMPContact Last NPS survey dateThe time that this contact last submitted a NPS survey response. This is automatically set by HubSpot.contact
contact_hs_google_click_idTEXTContact Google ad click idcontact
contact_hs_ip_timezoneTEXTContact IP TimezoneThe timezone reported by a contact's IP address. This is automatically set by HubSpot and can be used for segmentation and reporting.contact
contact_hs_is_unworkedBOOLEANContact unworkedContact has not been assigned or has not been engaged after last owner assignment/re-assignmentcontact
contact_hs_languageTEXTContact Preferred languageSet your contact's preferred language for communications. This property can be changed from an import, form, or integration.contact
contact_hs_last_sales_activity_timestampTIMESTAMPContact Last Engagement DateThe last time a contact engaged with your site or a form, document, meetings link, or tracked email. This doesn't include marketing emails or emails to multiple contacts.contact
contact_hs_latest_sequence_ended_dateTIMESTAMPContact Last sequence ended dateThe last sequence ended date.contact
contact_hs_latest_sequence_enrolledNUMERICContact Last sequence enrolledThe last sequence enrolled.contact
contact_hs_latest_sequence_enrolled_dateTIMESTAMPContact Last sequence enrolled dateThe last sequence enrolled date.contact
contact_hs_lead_statusTEXTContact Lead StatusThe contact's sales, prospecting or outreach statuscontact
TEXTContact Legal basis for processing contact's dataLegal basis for processing contact's data; 'Not applicable' will exempt the contact from GDPR protectionscontact
contact_hs_lifecyclestage_customer_dateTIMESTAMPContact Became a Customer DateThe date when a contact's lifecycle stage changed to Customer. This is automatically set by HubSpot for each contact.contact
contact_hs_lifecyclestage_evangelist_dateTIMESTAMPContact Became an Evangelist DateThe date when a contact's lifecycle stage changed to Evangelist. This is automatically set by HubSpot for each contact.contact
contact_hs_lifecyclestage_lead_dateTIMESTAMPContact Became a Lead DateThe date when a contact's lifecycle stage changed to Lead. This is automatically set by HubSpot for each contact.contact
contact_hs_lifecyclestage_marketingqualifiedlead_dateTIMESTAMPContact Became a Marketing Qualified Lead DateThe date when a contact's lifecycle stage changed to MQL. This is automatically set by HubSpot for each contact.contact
contact_hs_lifecyclestage_opportunity_dateTIMESTAMPContact Became an Opportunity DateThe date when a contact's lifecycle stage changed to Opportunity. This is automatically set by HubSpot for each contact.contact
contact_hs_lifecyclestage_other_dateTIMESTAMPContact Became an Other Lifecycle DateThe date when a contact's lifecycle stage changed to Other. This is automatically set by HubSpot for each contact.contact
contact_hs_lifecyclestage_salesqualifiedlead_dateTIMESTAMPContact Became a Sales Qualified Lead DateThe date when a contact's lifecycle stage changed to SQL. This is automatically set by HubSpot for each contact.contact
contact_hs_lifecyclestage_subscriber_dateTIMESTAMPContact Became a Subscriber DateThe date when a contact's lifecycle stage changed to Subscriber. This is automatically set by HubSpot for each contact.contact
contact_hs_marketable_reason_idTEXTContact Marketing contact status source nameThe ID of the activity that set the contact as a marketing contactcontact
contact_hs_marketable_reason_typeTEXTContact Marketing contact status source typeThe type of the activity that set the contact as a marketing contactcontact
contact_hs_marketable_statusTEXTContact Marketing contact statusThe marketing status of a contactcontact
contact_hs_marketable_until_renewalTEXTContact Marketing contact until next updateSpecifies if this contact will be set as non-marketing on renewalcontact
contact_hs_object_idTEXTContact ID (HubSpot)The unique ID for this contact. This unique ID is automatically populated by HubSpot and cannot be changed.contact
contact_hs_personaTEXTContact PersonaA contact's personacontact
contact_hs_predictivecontactscoreNUMERICContact Predictive Lead ScoreA score calculated by HubSpot that represents a contact's likelihood to become a customercontact
contact_hs_predictivecontactscore_v2NUMERICContact Likelihood to closeThe probability that a contact will become a customer within the next 90 days. This score is based on standard contact properties and behavior.contact
contact_hs_predictivecontactscorebucketTEXTContact Lead RatingThe rating of this contact based on their predictive lead scorecontact
contact_hs_predictivescoringtierTEXTContact priorityA ranking system of contacts evenly assigned into four tiers. Contacts in tier one are more likely to become customers than contacts in tier four.contact
contact_hs_sales_email_last_clickedTIMESTAMPContact Recent Sales Email Clicked DateThe last time a tracked sales email was clicked by this usercontact
contact_hs_sales_email_last_openedTIMESTAMPContact Recent Sales Email Opened DateThe last time a tracked sales email was opened by this contact. This property does not update for emails that were sent to more than one contact.contact
contact_hs_sales_email_last_repliedTIMESTAMPContact Recent Sales Email Replied DateThe last time a tracked sales email was replied to by this user. This is set automatically by HubSpot based on user actions in the contact record.contact
contact_hs_sequences_enrolled_countNUMERICContact Number of sequences enrolledThe number of sequences enrolled.contact
contact_hs_sequences_is_enrolledBOOLEANContact Currently in SequenceA yes/no field that indicates whether the contact is currently in a Sequence.contact
contact_hs_social_facebook_clicksNUMERICContact Facebook ClicksThe number clicks on links shared on Facebookcontact
contact_hs_social_google_plus_clicksNUMERICContact Google Plus ClicksThe number clicks on links shared on Google Pluscontact
contact_hs_social_last_engagementTIMESTAMPContact Most Recent Social ClickThe date of the most recent click on a published social message. This is set automatically by HubSpot for each contact.contact
contact_hs_social_linkedin_clicksNUMERICContact LinkedIn ClicksThe number clicks on links shared on LinkedIncontact
contact_hs_social_num_broadcast_clicksNUMERICContact Broadcast ClicksThe number of clicks on published social messages. This is set automatically by HubSpot for each contact.contact
contact_hs_social_twitter_clicksNUMERICContact Twitter ClicksThe number of times a contact clicked on links you shared on Twitter through HubSpot. This is set automatically by HubSpot and can be used for segmentation.contact
contact_hs_time_between_contact_creation_and_deal_closeNUMERICContact Time between contact creation and deal closecontact
contact_hs_time_between_contact_creation_and_deal_creationNUMERICContact Time between contact creation and deal creationcontact
contact_hs_time_to_move_from_lead_to_customerNUMERICContact Time to move from lead to customer How long it takes for a contact to move from the HubSpot lead stage to the HubSpot customer stage.contact
contact_hs_time_to_move_from_marketingqualifiedlead_to_customerNUMERICContact Time to move from marketing qualified lead to customer How long it takes for a contact to move from the HubSpot marketing qualified lead stage to the HubSpot customer stage.contact
contact_hs_time_to_move_from_opportunity_to_customerNUMERICContact Time to move from opportunity to customer How long it takes for a contact to move from the HubSpot opportunity stage to the HubSpot customer stage.contact
contact_hs_time_to_move_from_salesqualifiedlead_to_customerNUMERICContact Time to move from sales qualified lead to customer How long it takes for a contact to move from the HubSpot sales qualified lead stage to the HubSpot customer stage.contact
contact_hs_time_to_move_from_subscriber_to_customerNUMERICContact Time to move from subscriber to customer How long it takes for a contact to move from the HubSpot subscriber stage to the HubSpot customer stage.contact
contact_hubspot_owner_assigneddateTIMESTAMPContact Owner Assigned DateThe most recent date a HubSpot Owner was assigned to a contact. This is set automatically by HubSpot and can be used for segmentation and reporting.contact
contact_hubspot_owner_idTEXTContact ownerThe owner of a contact. This can be any HubSpot user or Salesforce integration user, and can be set manually or via Workflows.contact
contact_hubspot_team_idTEXTContact HubSpot TeamThe team of the owner of a contact.contact
contact_hubspotscoreNUMERICContact HubSpot ScoreThe number that shows qualification of contacts to sales readiness. It can be set in HubSpot's Lead Scoring app.contact
contact_industryTEXTContact IndustryThe industry a contact is incontact
contact_ip_cityCITYContact IP CityThe city reported by a contact's IP address. This is automatically set by HubSpot and can be used for segmentation and reporting.contact
contact_ip_countryCOUNTRYContact IP CountryThe country reported by a contact's IP address. This is automatically set by HubSpot and can be used for segmentation and reporting.contact
contact_ip_country_codeCOUNTRYContact IP Country CodeThe country code reported by a contact's IP address. This is automatically set by HubSpot and can be used for segmentation and reporting.contact
contact_ip_stateREGIONContact IP State/RegionThe state or region reported by a contact's IP address. This is automatically set by HubSpot and can be used for segmentation and reporting.contact
contact_ip_state_codeTEXTContact IP State Code/Region CodeThe state code or region code reported by a contact's IP address. This is automatically set by HubSpot and can be used for segmentation and reporting.contact
contact_job_functionTEXTContact Job functionA contact's job function. This property is required for the Facebook Ads Integration. This property will be automatically synced via the Lead Ads toolcontact
contact_jobtitleTEXTContact Job TitleA contact's job titlecontact
contact_kloutscoregeneralNUMERICContact Klout ScoreA contact's Klout score, a measure of Internet influencecontact
contact_lastmodifieddateTIMESTAMPContact Last Modified DateThe date any property on this contact was modifiedcontact
contact_lastnameTEXTContact Last NameA contact's last namecontact
contact_lifecyclestageTEXTContact Lifecycle StageThe qualification of contacts to sales readiness. It can be set through imports, forms, workflows, and manually on a per contact basis.contact
contact_linkedinbioTEXTContact LinkedIn BioA contact's LinkedIn biocontact
contact_linkedinconnectionsNUMERICContact LinkedIn ConnectionsHow many LinkedIn connections they havecontact
contact_marital_statusTEXTContact Marital StatusA contact's marital status. This property is required for the Facebook Ads Integration. This property will be automatically synced via the Lead Ads toolcontact
contact_messageTEXTContact MessageA default property to be used for any message or comments a contact may want to leave on a form.contact
contact_military_statusTEXTContact Military statusA contact's military status. This property is required for the Facebook Ads Integration. This property will be automatically synced via the Lead Ads toolcontact
contact_mobilephoneTEXTContact Mobile Phone NumberA contact's mobile phone numbercontact
contact_notes_last_contactedTIMESTAMPContact Last ContactedThe last time a call, email, or meeting was logged for a contact. This is set automatically by HubSpot based on user actions in the contact record.contact
contact_notes_last_updatedTIMESTAMPContact Notes Last Activity DateThe last time a note, call, email, meeting, or task was logged for a contact. This is set automatically by HubSpot based on user actions in the contact record.contact
contact_notes_next_activity_dateTIMESTAMPContact Next Activity DateThe date of the next upcoming activity for a contact. This is set automatically by HubSpot based on user actions in the contact record.contact
contact_num_associated_dealsNUMERICContact Associated DealsThe number of deals associated with this contact. This is set automatically by HubSpot.contact
contact_num_contacted_notesNUMERICContact number of times contactedThe number of times a call, email, or meeting was logged for a contact. This is set automatically by HubSpot based on user actions in the contact record.contact
contact_num_conversion_eventsNUMERICContact Number of Form SubmissionsThe number of forms this contact has submittedcontact
contact_num_notesNUMERICContact Number of Sales ActivitiesThe number of sales activities for a contact. This is set automatically by HubSpot based on user actions in the contact record.contact
contact_num_unique_conversion_eventsNUMERICContact Number of Unique Forms SubmittedThe number of different forms this contact has submittedcontact
contact_numemployeesTEXTContact Number of EmployeesThe number of company employeescontact
contact_owneremailTEXTContact HubSpot Owner Email (legacy)A legacy property used to identify the email address of the owner of the contact. This property is no longer in use.contact
contact_ownernameTEXTContact HubSpot Owner Name (legacy)A legacy property used to identify the name of the owner of the contact. This property is no longer in use.contact
contact_phoneTEXTContact Phone NumberA contact's primary phone numbercontact
contact_recent_conversion_dateTIMESTAMPContact Recent Conversion DateThe date this contact last submitted a formcontact
contact_recent_conversion_event_nameTEXTContact Recent ConversionThe last form this contact submittedcontact
contact_recent_deal_amountNUMERICContact Recent Deal AmountThe amount of the last closed won deal associated with a contact. This is set automatically by HubSpot based on information from the Deals object.contact
contact_recent_deal_close_dateTIMESTAMPContact Recent Deal Close DateThe date that the last deal associated with a contact was won. This is automatically set by HubSpot based on information from the Deals object.contact
contact_relationship_statusTEXTContact Relationship StatusA contact's relationship status. This property is required for the Facebook Ads Integration. This property will be automatically synced via the Lead Ads toolcontact
contact_sales_statusTEXTSales StatusSales statuscontact
contact_salutationTEXTContact SalutationThe title used to address a contactcontact
contact_schoolTEXTContact SchoolA contact's school. This property is required for the Facebook Ads Integration. This property will be automatically synced via the Lead Ads toolcontact
contact_seniorityTEXTContact SeniorityA contact's seniority. This property is required for the Facebook Ads Integration. This property will be automatically synced via the Lead Ads toolcontact
contact_sourceTEXTContact SourceThe contact sourcecontact
contact_start_dateTEXTContact Start dateA contact's start date. This property is required for the Facebook Ads Integration. This property will be automatically synced via the Lead Ads toolcontact
contact_stateREGIONContact State/RegionThe contact's state of residence. This might be set via import, form, or integration.contact
contact_total_revenueNUMERICContact Total RevenueThe sum from all closed won deal revenue associated with a contact. This is automatically set by HubSpot and can be used for segmentation and reporting.contact
contact_twitterbioTEXTContact Twitter BioThe contact's Twitter bio. This is set by HubSpot using the contact's email address.contact
contact_twitterhandleTEXTContact Twitter UsernameThe contact's Twitter handle. This is set by HubSpot using the contact's email address.contact
contact_twitterprofilephotoTEXTContact Twitter Profile PhotoThe contact's Twitter profile photo. This is set by HubSpot using the contact's email address.contact
contact_typeTEXTContact TypeThe contact typecontact
contact_websiteTEXTContact Website URLThe contact's company websitecontact
contact_work_emailTEXTContact Work emailA contact's work email. This property is required for the Facebook Ads Integration. This property will be automatically synced via the Lead Ads toolcontact
contact_zipTEXTContact Postal CodeThe contact's zip code. This might be set via import, form, or integration.contact
createddateTIMESTAMPCreated DateAlias for contact_createdatecontact
customfield_hs_createdateTIMESTAMPCustom Field Modified DateMost recent timestamp of any property update for this custom object.customfield
customfield_hs_lastmodifieddateTIMESTAMPCustom Field Last Modified DateMost recent timestamp of any property update for this custom object.customfield
customobject_createdatTIMESTAMPCustom Object Created atThe date the custom object was created.custom_object
customobject_descriptionTEXTCustom Object DescriptionThe custom object description.custom_object
customobject_display_orderTEXTCustom Object Display OrderThe custom object display order.custom_object
customobject_field_typeTEXTCustom Object Field TypeThe custom object field typecustom_object
customobject_group_nameTEXTCustom Object Group NameThe custom object group name.custom_object
customobject_hiddenBOOLEANCustom Object HiddenThe custom object is hiddnen or not.custom_object
customobject_idTEXTCustom Object IDThe custom object type ID.custom_object
customobject_labelTEXTCustom Object LabelThe custom object label.custom_object
customobject_nameTEXTCustom object nameMost recent timestamp of any property update for this custom object. This includes HubSpot internal properties, which can be visible or hidden. This property is updated automatically.custom_object
customobject_property_nameTEXTCustom object property nameName of the custom object properties (fields).custom_object
customobject_typeTEXTCustom Object TypeThe custom object type.custom_object
customobject_updatedatTIMESTAMPCustom Object Updated AtMost recent timestamp of any property update for this custom object. This includes HubSpot internal properties, which can be visible or hidden. This property is updated automatically.custom_object
datasourceTEXTData SourceThe name of the Windsor connector returning the row
dateDATELast Modified DateThe timestamp that specifies when the stage was modified
deal_amountNUMERICDeal AmountThe total amount of the dealdeal
deal_amount_in_home_currencyNUMERICDeal Amount in company currencyThe amount of the deal, using the exchange rate, in your company's currencydeal
deal_closed_lost_reasonTEXTDeal Closed Lost ReasonReason why this deal was lostdeal
deal_closed_won_reasonTEXTDeal Closed Won ReasonReason why this deal was wondeal
deal_closedateTIMESTAMPDeal Close DateThe expected close date of the dealdeal
deal_createdateTIMESTAMPDeal Create DateThe date the deal was created. This property is set automatically by HubSpot.deal
deal_currency_codeTEXTDeal CurrencyCurrency code for the deal.deal
deal_dealnameTEXTDeal NameThe name given to this deal.deal
deal_dealstageTEXTDeal StageThe stage of the deal. Deal stages allow you to categorize and track the progress of the deals that you are working on.deal
deal_dealtypeTEXTDeal TypeThe type of deal. By default, categorize your deal as either a New Business or Existing Business.deal
deal_descriptionTEXTDeal DescriptionDescription of the dealdeal
deal_engagements_last_meeting_bookedTIMESTAMPDeal Date of last meeting booked in meetings toolThe date of the most recent meeting an associated contact has booked through the meetings tool.deal
deal_engagements_last_meeting_booked_campaignTEXTDeal Campaign of last booking in meetings toolThis UTM parameter shows which marketing campaign (e.g. a specific email) referred an associated contact to the meetings tool for their most recent booking. This property is only populated when you add tracking parameters to your meeting link.deal
deal_engagements_last_meeting_booked_mediumTEXTDeal Medium of last booking in meetings toolThis UTM parameter shows which channel (e.g. email) referred an associated contact to the meetings tool for their most recent booking. This property is only populated when you add tracking parameters to your meeting link.deal
deal_engagements_last_meeting_booked_sourceTEXTDeal Source of last booking in meetings toolThis UTM parameter shows which site (e.g. Twitter) referred an associated contact to the meetings tool for their most recent booking. This property is only populated when you add tracking parameters to your meeting link. deal
deal_hs_acvNUMERICDeal Annual contract valueThe annual contract value (ACV) of this deal.deal
deal_hs_analytics_sourceTEXTDeal Original Source TypeOriginal source for the contact with the earliest activity for this deal.deal
deal_hs_analytics_source_data_1TEXTDeal Original Source Data 1Additional information about the original source for the associated contact, or associated company if there is no contact, with the oldest value for the Time first seen property.deal
deal_hs_analytics_source_data_2TEXTDeal Original Source Data 2Additional information about the original source for the associated contact, or associated company if there is no contact, with the oldest value for the Time first seen property.deal
deal_hs_arrNUMERICDeal Annual recurring revenueThe annual recurring revenue (ARR) of this deal.deal
deal_hs_forecast_amountNUMERICDeal Forecast AmountThe forecasted deal value calculated by multiplying the forecast probability and deal amountdeal
deal_hs_forecast_probabilityNUMERICDeal Forecast ProbabilityThe percent probability the deal will close, expressed as a decimal.deal
deal_hs_lastmodifieddateTIMESTAMPDeal Last Modified DateMost recent timestamp of any property update for this deal. This includes HubSpot internal properties, which can be visible or hidden. This property is updated automatically.deal
deal_hs_manual_forecast_categoryTEXTDeal Forecast categoryThe likelihood a deal will close. This property is used for manual forecasting your deals.deal
deal_hs_mrrNUMERICDeal Monthly recurring revenueThe monthly recurring revenue (MRR) of this deal.deal
deal_hs_next_stepTEXTDeal Next stepA short description of the next step for the dealdeal
deal_hs_object_idNUMERICDeal ID (HubSpot)The unique ID for this deal. This unique ID is automatically populated by HubSpot and cannot be changed.deal
deal_hs_priorityTEXTDeal Prioritydeal
deal_hs_tcvNUMERICDeal Total contract valueThe total contract value (TCV) of this deal.deal
deal_hubspot_owner_assigneddateTIMESTAMPDeal Owner Assigned DateThe date the most recent deal owner was assigned to a deal. This is updated automatically by HubSpot.deal
deal_hubspot_owner_idTEXTDeal Owner IDThe owner of the dealdeal
deal_hubspot_team_idTEXTDeal HubSpot TeamThe team of the owner of the deal.deal
deal_notes_last_contactedTIMESTAMPDeal Last ContactedThe last time a call, sales email, or meeting was logged for this deal. This is set automatically by HubSpot based on user actions.deal
deal_notes_last_updatedTIMESTAMPDeal Last Activity DateThe last time a note, call, email, meeting, or task was logged for a deal. This is set automatically by HubSpot based on user actions in the deal record.deal
deal_notes_next_activity_dateTIMESTAMPDeal Next Activity DateThe date of the next upcoming activity for a deal. This property is set automatically by HubSpot based on user action. This includes logging a future call, sales email, or meeting using the Log feature, as well as creating a future task or scheduling a future meeting. This is updated automatically by HubSpot.deal
deal_num_associated_contactsNUMERICDeal Number of ContactsThe number of contacts associated with this deal. This property is set automatically by HubSpot.deal
deal_num_contacted_notesNUMERICDeal Number of times contactedThe number of times a call, email or meeting was logged for this dealdeal
deal_num_notesNUMERICDeal Number of Sales ActivitiesThe total number of sales activities (notes, calls, emails, meetings, or tasks) logged for a deal. This is updated automatically by HubSpot.deal
deal_pipelineTEXTDeal PipelineThe pipeline the deal is in. This determines which stages are options for the deal.deal
emailTEXTEmailAlias for contact_emailcontact
email_bouncedNUMERICEmail engagement bouncedThe recipient's email server couldn't or wouldn't accept the message, and no further attempts will be made to deliver the message.email
email_clickedNUMERICEmail engagement clicksThe recipient clicked on a link within the message.email
email_deferredNUMERICEmail engagement deferredThe recipient’s email server has temporarily rejected message, and subsequent attempts will be made to deliver the message.and no further attempts will be made to deliver the message.email
email_deliveredNUMERICEmail engagement deliveredThe recipient's email server has accepted the message and the message has been successfully delivered to the recipient.and no further attempts will be made to deliver the message.email
email_droppedNUMERICEmail engagement droppedThe message was rejected, either by HubSpot or by our delivery provider, and no attempt will be made to deliver the message.and no further attempts will be made to deliver the message.email
email_event_createdTIMESTAMPEmail engagement timestampEmail engagement timestampemail
email_openedNUMERICEmail engagement openedThe recipient opened the message.email
email_processedNUMERICEmail engagement processedThe message has been received by our delivery provider, which has indicated it will attempt to deliver the message to the recipient's email server.and no further attempts will be made to deliver the message.email
email_recipientTEXTEmail recipientEmail recipientemail
email_sentNUMERICEmail engagement sentThe message was sent to and received by our delivery provider.email
firstnameTEXTFirst NameAlias for contact_firstnamecontact
lastnameTEXTLast NameAlias for contact_lastnamecontact
lifecyclestageTEXTLifecycle StageAlias for contact_lifecyclestagecontact
marketingemail_abTEXTababmarketingemail
marketingemail_abhourstowaitTEXTabHoursToWaitabHoursToWaitmarketingemail
marketingemail_absamplesizedefaultTEXTabSampleSizeDefaultabSampleSizeDefaultmarketingemail
marketingemail_absamplingdefaultTEXTabSamplingDefaultabSamplingDefaultmarketingemail
marketingemail_absoluteurlTEXTabsoluteUrlabsoluteUrlmarketingemail
marketingemail_absuccessmetricTEXTabSuccessMetricabSuccessMetricmarketingemail
marketingemail_abtestpercentageTEXTabTestPercentageabTestPercentagemarketingemail
marketingemail_abvariationTEXTabVariationabVariationmarketingemail
marketingemail_allemailcampaignidsTEXTallEmailCampaignIdsallEmailCampaignIdsmarketingemail
marketingemail_analyticspageidTEXTanalyticsPageIdanalyticsPageIdmarketingemail
marketingemail_analyticspagetypeTEXTanalyticsPageTypeanalyticsPageTypemarketingemail
marketingemail_archivedatTEXTarchivedAtarchivedAtmarketingemail
marketingemail_archivedindashboardTEXTarchivedInDashboardarchivedInDashboardmarketingemail
marketingemail_audienceaccessTEXTaudienceAccessaudienceAccessmarketingemail
marketingemail_authorTEXTauthorauthormarketingemail
marketingemail_authornameTEXTauthorNameauthorNamemarketingemail
marketingemail_blogrsssettingsTEXTblogRssSettingsblogRssSettingsmarketingemail
marketingemail_canspamsettingsidTEXTcanSpamSettingsIdcanSpamSettingsIdmarketingemail
marketingemail_categoryidTEXTcategoryIdcategoryIdmarketingemail
marketingemail_contentaccessruleidsTEXTcontentAccessRuleIdscontentAccessRuleIdsmarketingemail
marketingemail_contentaccessruletypesTEXTcontentAccessRuleTypescontentAccessRuleTypesmarketingemail
marketingemail_contenttypecategoryTEXTcontentTypeCategorycontentTypeCategorymarketingemail
marketingemail_createdTIMESTAMPcreatedcreatedmarketingemail
marketingemail_createdbyidTEXTcreatedByIdcreatedByIdmarketingemail
marketingemail_createpageTEXTcreatePagecreatePagemarketingemail
marketingemail_currentlypublishedTEXTcurrentlyPublishedcurrentlyPublishedmarketingemail
marketingemail_currentstateTEXTcurrentStatecurrentStatemarketingemail
marketingemail_customreplytoTEXTcustomReplyTocustomReplyTomarketingemail
marketingemail_customreplytoenabledTEXTcustomReplyToEnabledcustomReplyToEnabledmarketingemail
marketingemail_domainTEXTdomaindomainmarketingemail
marketingemail_emailbodyTEXTemailBodyemailBodymarketingemail
marketingemail_emailcampaigngroupidTEXTemailCampaignGroupIdemailCampaignGroupIdmarketingemail
marketingemail_emailnoteTEXTemailNoteemailNotemarketingemail
marketingemail_emailtemplatemodeTEXTemailTemplateModeemailTemplateModemarketingemail
marketingemail_emailtypeTEXTemailTypeemailTypemarketingemail
marketingemail_feedbacksurveyidTEXTfeedbackSurveyIdfeedbackSurveyIdmarketingemail
marketingemail_flexareasTEXTflexAreasflexAreasmarketingemail
marketingemail_freezedateTIMESTAMPfreezeDatefreezeDatemarketingemail
marketingemail_fromnameTEXTfromNamefromNamemarketingemail
marketingemail_hascontentaccessrulesTEXThasContentAccessRuleshasContentAccessRulesmarketingemail
marketingemail_htmltitleTEXThtmlTitlehtmlTitlemarketingemail
marketingemail_idTEXTididmarketingemail
marketingemail_iscreatedfomsandboxsyncTEXTisCreatedFomSandboxSyncisCreatedFomSandboxSyncmarketingemail
marketingemail_isgraymailsuppressionenabledTEXTisGraymailSuppressionEnabledisGraymailSuppressionEnabledmarketingemail
marketingemail_isinstancelayoutpageTEXTisInstanceLayoutPageisInstanceLayoutPagemarketingemail
marketingemail_ispublishedTEXTisPublishedisPublishedmarketingemail
marketingemail_isrecipientfatiguesuppressionenabledTEXTisRecipientFatigueSuppressionEnabledisRecipientFatigueSuppressionEnabledmarketingemail
marketingemail_languageTEXTlanguagelanguagemarketingemail
marketingemail_layoutsectionsTEXTlayoutSectionslayoutSectionsmarketingemail
marketingemail_livedomainTEXTliveDomainliveDomainmarketingemail
marketingemail_mailinglistsexcludedTEXTmailingListsExcludedmailingListsExcludedmarketingemail
marketingemail_mailinglistsincludedTEXTmailingListsIncludedmailingListsIncludedmarketingemail
marketingemail_maxrssentriesTEXTmaxRssEntriesmaxRssEntriesmarketingemail
marketingemail_metadescriptionTEXTmetaDescriptionmetaDescriptionmarketingemail
marketingemail_nameTEXTnamenamemarketingemail
marketingemail_pageexpiryenabledTEXTpageExpiryEnabledpageExpiryEnabledmarketingemail
marketingemail_pageredirectedTEXTpageRedirectedpageRedirectedmarketingemail
marketingemail_pastmabexperimentidsTEXTpastMabExperimentIdspastMabExperimentIdsmarketingemail
marketingemail_portalidTEXTportalIdportalIdmarketingemail
marketingemail_previewkeyTEXTpreviewKeypreviewKeymarketingemail
marketingemail_primaryemailcampaignidTEXTprimaryEmailCampaignIdprimaryEmailCampaignIdmarketingemail
marketingemail_primaryrichtextmodulehtmlTEXTprimaryRichTextModuleHtmlprimaryRichTextModuleHtmlmarketingemail
marketingemail_processingstatusTEXTprocessingStatusprocessingStatusmarketingemail
marketingemail_publishdateTIMESTAMPpublishDatepublishDatemarketingemail
marketingemail_publishedatTEXTpublishedAtpublishedAtmarketingemail
marketingemail_publishedbyemailTEXTpublishedByEmailpublishedByEmailmarketingemail
marketingemail_publishedbyidTEXTpublishedByIdpublishedByIdmarketingemail
marketingemail_publishedbynameTEXTpublishedByNamepublishedByNamemarketingemail
marketingemail_publishedurlTEXTpublishedUrlpublishedUrlmarketingemail
marketingemail_replytoTEXTreplyToreplyTomarketingemail
marketingemail_resolveddomainTEXTresolvedDomainresolvedDomainmarketingemail
marketingemail_rssemailbytextTEXTrssEmailByTextrssEmailByTextmarketingemail
marketingemail_rssemailclickthroughtextTEXTrssEmailClickThroughTextrssEmailClickThroughTextmarketingemail
marketingemail_rssemailcommenttextTEXTrssEmailCommentTextrssEmailCommentTextmarketingemail
marketingemail_rssemailentrytemplateenabledTEXTrssEmailEntryTemplateEnabledrssEmailEntryTemplateEnabledmarketingemail
marketingemail_rssemailimagemaxwidthTEXTrssEmailImageMaxWidthrssEmailImageMaxWidthmarketingemail
marketingemail_rssemailurlTEXTrssEmailUrlrssEmailUrlmarketingemail
TEXTscrubsSubscriptionLinksscrubsSubscriptionLinksmarketingemail
marketingemail_sectionsTEXTsectionssectionsmarketingemail
marketingemail_securitystateTEXTsecurityStatesecurityStatemarketingemail
marketingemail_slugTEXTslugslugmarketingemail
marketingemail_smartemailfieldsTEXTsmartEmailFieldssmartEmailFieldsmarketingemail
marketingemail_stateTEXTstatestatemarketingemail
marketingemail_stylesettingsTEXTstyleSettingsstyleSettingsmarketingemail
marketingemail_subcategoryTEXTsubcategorysubcategorymarketingemail
marketingemail_subjectTEXTsubjectsubjectmarketingemail
marketingemail_subscriptionTEXTsubscriptionsubscriptionmarketingemail
marketingemail_subscriptionnameTEXTsubscriptionNamesubscriptionNamemarketingemail
marketingemail_teampermsTEXTteamPermsteamPermsmarketingemail
marketingemail_templatepathTEXTtemplatePathtemplatePathmarketingemail
marketingemail_transactionalTEXTtransactionaltransactionalmarketingemail
marketingemail_translationsTEXTtranslationstranslationsmarketingemail
marketingemail_unpublishedatTEXTunpublishedAtunpublishedAtmarketingemail
marketingemail_updatedTIMESTAMPupdatedupdatedmarketingemail
marketingemail_updatedbyidTEXTupdatedByIdupdatedByIdmarketingemail
marketingemail_urlTEXTurlurlmarketingemail
marketingemail_userpermsTEXTuserPermsuserPermsmarketingemail
marketingemail_userssheadlineassubjectTEXTuseRssHeadlineAsSubjectuseRssHeadlineAsSubjectmarketingemail
marketingemail_vidsexcludedTEXTvidsExcludedvidsExcludedmarketingemail
marketingemail_vidsincludedTEXTvidsIncludedvidsIncludedmarketingemail
marketingemail_visibletoallTEXTvisibleToAllvisibleToAllmarketingemail
owner_archivedTEXTOwner ArchivedOwner Archivedowner
owner_created_atTIMESTAMPOwner Created AtOwner Created Atowner
owner_emailTEXTOwner EmailOwner Emailowner
owner_first_nameTEXTOwner First NameOwner First Nameowner
owner_last_nameTEXTOwner Last NameOwner Last Nameowner
owner_owner_idTEXTOwner IdOwner Idowner
owner_updated_atTIMESTAMPOwner Updated AtOwner Updated Atowner
owner_user_idTEXTOwner User IdOwner User Idowner
phoneTEXTPhone NumberAlias for contact_phonecontact
pipeline_idTEXTPipeline IDPipeline IDpipeline
pipeline_nameTEXTPipeline NamePipeline namepipeline
pipeline_stage_created_atTIMESTAMPPipeline Stage Created DateThe timestamp that specifies when the stage was createdpipeline
pipeline_stage_display_orderNUMERICPipeline Stage Display Order NumberStage display order numberpipeline
pipeline_stage_idTEXTPipeline Stage IDStage IDpipeline
pipeline_stage_is_archivedBOOLEANPipeline Is Stage ArchivedIs stage archivedpipeline
pipeline_stage_is_closedBOOLEANPipeline Is ClosedIs deal closedpipeline
pipeline_stage_nameTEXTPipeline Stage NameStage namepipeline
pipeline_stage_probabilityTEXTPipeline ProbablityDeal probabilitypipeline
pipeline_stage_updated_atTIMESTAMPPipeline Stage Last Modified DateThe timestamp that specifies when the stage was modifiedpipeline
sourceTEXTSourceThe name of the Windsor connector returning the row
todayDATETodayToday's date