Windsor brings all your HubSpot data into Power BI, Looker Studio, Google Sheets, Excel, BigQuery, Snowflake, Tableau, PostgreSQL, MySQL, Python, Amazon S3, Azure, Azure MS SQL
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
| ID | Type | Name | Description | Object |
|---|---|---|---|---|
| account_id | TEXT | Account ID | Your Hubspot account ID | Account |
| account_name | TEXT | Account Name | Your Hubspot account name | Account |
| company | TEXT | Contact Company Name (Alias) | Alias for contact_company | contact |
| company_about_us | TEXT | Company About Us | Short about-company | company |
| company_address | TEXT | Company Street Address | The street address of the company or organization, including unit number. Powered by HubSpot Insights. | company |
| company_address2 | TEXT | Company Street Address 2 | The additional address of the company or organization. Powered by HubSpot Insights. | company |
| company_annualrevenue | NUMERIC | Company Annual Revenue | The actual or estimated annual revenue of the company. Powered by HubSpot Insights. | company |
| company_city | CITY | Company City | The city where the company is located. Powered by HubSpot Insights. | company |
| company_closedate | TIMESTAMP | Company Close Date | The date the company or organization was closed as a customer | company |
| company_country | COUNTRY | Company Country/Region | The country/region in which the company or organization is located. Powered by HubSpot Insights. | company |
| company_createdate | TIMESTAMP | Company Create Date | The date the company or organization was added to the database | company |
| company_days_to_close | NUMERIC | Company Days to Close | The number of days between when the company record was created and when they closed as a customer. | company |
| company_description | TEXT | Company Description | A short statement about the company's mission and goals. Powered by HubSpot Insights. | company |
| company_domain | TEXT | Company Domain Name | The domain name of the company or organization | company |
| company_engagements_last_meeting_booked | TIMESTAMP | Company Date of last meeting booked in meetings tool | The date of the most recent meeting an associated contact has booked through the meetings tool. | company |
| company_engagements_last_meeting_booked_campaign | TEXT | Company Campaign of last booking in meetings tool | This 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_medium | TEXT | Company Medium of last booking in meetings tool | This 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_source | TEXT | Company Source of last booking in meetings tool | This 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_page | TEXT | Company Facebook Company Page | The URL of the Facebook company page for the company or organization | company |
| company_facebookfans | NUMERIC | Company Facebook Fans | Number of facebook fans | company |
| company_first_contact_createdate | TIMESTAMP | Company First Contact Create Date | The date that the first contact from this company entered the system, which could pre-date the company's create date | company |
| company_first_conversion_date | TIMESTAMP | Company First Conversion Date | The first conversion date across all contacts associated this company or organization | company |
| company_first_conversion_event_name | TEXT | Company First Conversion | The first form submitted across all contacts associated this company or organization | company |
| company_first_deal_created_date | TIMESTAMP | Company First Deal Created Date | The create date of the first deal associated with this company record. | company |
| company_founded_year | TEXT | Company Year Founded | The year the company was created. Powered by HubSpot Insights. | company |
| company_googleplus_page | TEXT | Company Google Plus Page | The URL of the Google Plus page for the company or organization | company |
| company_hs_analytics_first_timestamp | TIMESTAMP | Company Time First Seen | The first activity for any contact associated with this company or organization | company |
| company_hs_analytics_first_touch_converting_campaign | TEXT | Company First Touch Converting Campaign | The campaign responsible for the first touch creation of the first contact associated with this company | company |
| company_hs_analytics_first_visit_timestamp | TIMESTAMP | Company Time of First Session | Time of first session across all contacts associated with this company or organization | company |
| company_hs_analytics_last_timestamp | TIMESTAMP | Company Time Last Seen | Time last seen across all contacts associated with this company or organization | company |
| company_hs_analytics_last_touch_converting_campaign | TEXT | Company Last Touch Converting Campaign | The campaign responsible for the last touch creation of the first contact associated with this company | company |
| company_hs_analytics_last_visit_timestamp | TIMESTAMP | Company Time of Last Session | Time of the last session attributed to any contacts that are associated with this company record. | company |
| company_hs_analytics_num_page_views | NUMERIC | Company Number of Pageviews | Total number of page views across all contacts associated with this company or organization | company |
| company_hs_analytics_num_visits | NUMERIC | Company Number of Sessions | Total number of sessions across all contacts associated with this company or organization | company |
| company_hs_analytics_source | TEXT | Company Original Source Type | Original source for the contact with the earliest activity for this company or organization | company |
| company_hs_analytics_source_data_1 | TEXT | Company Original Source Data 1 | Additional information about the original source for the contact with the earliest activity for this company or organization | company |
| company_hs_analytics_source_data_2 | TEXT | Company Original Source Data 2 | Additional information about the original source for the contact with the earliest activity for this company or organization | company |
| company_hs_createdate | TIMESTAMP | Company object create date/time | The 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_profile | TEXT | Company Ideal Customer Profile Tier | This 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 priority | company |
| company_hs_is_target_account | BOOLEAN | Company Target Account | The 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_date | TIMESTAMP | Company Last Booked Meeting Date | The last date of booked meetings associated with the company | company |
| company_hs_last_logged_call_date | TIMESTAMP | Company Last Logged Call Date | The last date of logged calls associated with the company | company |
| company_hs_last_open_task_date | TIMESTAMP | Company Last Open Task Date | The last due date of open tasks associated with the company | company |
| company_hs_last_sales_activity_timestamp | TIMESTAMP | Company Last Engagement Date | The 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_lastmodifieddate | TIMESTAMP | Company Last Modified Date | Most 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_status | TEXT | Company Lead Status | The company's sales, prospecting or outreach status | company |
| company_hs_num_blockers | NUMERIC | Company Number of blockers | The number of contacts associated with this company with the role of blocker. | company |
| company_hs_num_child_companies | NUMERIC | Company Number of child companies | The number of child companies of this company | company |
| company_hs_num_contacts_with_buying_roles | NUMERIC | Company Number of contacts with a buying role | The number of contacts associated with this company with a buying role. | company |
| company_hs_num_decision_makers | NUMERIC | Company Number of decision makers | The number of contacts associated with this company with the role of decision maker. | company |
| company_hs_num_open_deals | NUMERIC | Company Number of open deals | The number of open deals associated with this company. | company |
| company_hs_object_id | NUMERIC | Company ID | The unique ID for this company. This unique ID is automatically populated by HubSpot and cannot be changed. | company |
| company_hs_parent_company_id | NUMERIC | Parent Company | The parent company of this company | company |
| company_hs_predictivecontactscore_v2 | NUMERIC | Company Likelihood to close | The 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_value | NUMERIC | Company Total open deal value | The total value, in your company's currency, of all open deals associated with this company | company |
| company_hubspot_owner_assigneddate | TIMESTAMP | Company Owner Assigned Date | The timestamp when an owner was assigned to this company | company |
| company_hubspot_owner_id | TEXT | Company owner | The owner of the company | company |
| company_hubspot_team_id | TEXT | Company HubSpot Team | The team of the owner of the company. | company |
| company_industry | TEXT | Company Industry | The 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_public | BOOLEAN | Company Is Public | Indicates that the company is publicly traded. Powered by HubSpot Insights. | company |
| company_lifecyclestage | TEXT | Company Lifecycle Stage | The most advanced lifecycle stage across all contacts associated with this company or organization | company |
| company_linkedin_company_page | TEXT | LinkedIn Company Page | The URL of the LinkedIn company page for the company or organization | company |
| company_linkedinbio | TEXT | Company LinkedIn Bio | The LinkedIn bio for the company or organization | company |
| company_name | TEXT | Company Name (Duplicate) | The name of the company or organization. Powered by HubSpot Insights. | company |
| company_notes_last_contacted | TIMESTAMP | Company Last Contacted | The last timestamp when a call, email or meeting was logged for a contact at this company. | company |
| company_notes_last_updated | TIMESTAMP | Company Last Activity Date | The 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_date | TIMESTAMP | Company Next Activity Date | The date of the next upcoming scheduled sales activity for this company record. | company |
| company_num_associated_contacts | NUMERIC | Company Associated Contacts | The number of contacts associated with this company | company |
| company_num_associated_deals | NUMERIC | Company Associated Deals | The number of deals associated with this company | company |
| company_num_contacted_notes | NUMERIC | Company Number of times contacted | The number of times a call, email or meeting was logged for this company | company |
| company_num_conversion_events | NUMERIC | Company Number of Form Submissions | The number of forms submission for all contacts associated with this company or organization | company |
| company_numberofemployees | NUMERIC | Company Number of Employees | The total number of employees who work for the company or organization | company |
| company_owneremail | TEXT | Company HubSpot Owner Email | HubSpot owner email for this company or organization | company |
| company_ownername | TEXT | Company HubSpot Owner Name | HubSpot owner name for this company or organization | company |
| company_phone | TEXT | Company Phone Number | A company's primary phone number. Powered by HubSpot Insights. | company |
| company_recent_conversion_date | TIMESTAMP | Company Recent Conversion Date | The most recent conversion date across all contacts associated this company or organization | company |
| company_recent_conversion_event_name | TEXT | Company Recent Conversion | The last form submitted across all contacts associated this company or organization | company |
| company_recent_deal_amount | NUMERIC | Company Recent Deal Amount | The amount of the last deal closed | company |
| company_recent_deal_close_date | TIMESTAMP | Company Recent Deal Close Date | The date of the last `closed won` deal associated with this company record. | company |
| company_state | REGION | Company State/Region | The state or region in which the company or organization is located. Powered by HubSpot Insights. | company |
| company_timezone | TEXT | Company Time Zone | The time zone where the company or organization is located. Powered by HubSpot Insights. | company |
| company_total_money_raised | TEXT | Company Total Money Raised | The total amount of money raised by the company. Powered by HubSpot Insights. | company |
| company_total_revenue | NUMERIC | Company Total Revenue | The total amount of closed won deals | company |
| company_twitterbio | TEXT | Company Twitter Bio | The Twitter bio of the company or organization | company |
| company_twitterfollowers | NUMERIC | Company Twitter Followers | The number of Twitter followers of the company or organization | company |
| company_twitterhandle | TEXT | Company Twitter Handle | The main twitter account of the company or organization | company |
| company_type | TEXT | Company Type | The optional classification of this company record - prospect, partner, etc. | company |
| company_web_technologies | TEXT | Company Web Technologies | The web technologies used by the company or organization. Powered by HubSpot Insights. | company |
| company_website | TEXT | Company Website URL | The main website of the company or organization. This property is used to identify unique companies. Powered by HubSpot Insights. | company |
| company_zip | TEXT | Company Postal Code | The postal or zip code of the company or organization. Powered by HubSpot Insights. | company |
| contact_address | TEXT | Contact Street Address | A contact's street address, including apartment or unit # | contact |
| contact_annualrevenue | TEXT | Contact Annual Revenue | Annual company revenue | contact |
| contact_city | CITY | Contact City | A contact's city of residence | contact |
| contact_closedate | TIMESTAMP | Contact Close Date | The 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_company | TEXT | Contact Company Name | The 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_size | TEXT | Contact Company size | A contact's company size. This property is required for the Facebook Ads Integration. This property will be automatically synced via the Lead Ads tool | contact |
| contact_country | COUNTRY | Contact Country/Region | The contact's country/region of residence. This might be set via import, form, or integration. | contact |
| contact_createdate | TIMESTAMP | Contact Create Date | The date that a contact entered the system | contact |
| contact_currentlyinworkflow | TEXT | Contact Currently in workflow | If the contact is currently enrolled in any workflow | contact |
| contact_date_of_birth | TEXT | Contact Date of birth | A contact's date of birth. This property is required for the Facebook Ads Integration. This property will be automatically synced via the Lead Ads tool | contact |
| contact_days_to_close | NUMERIC | Contact Days To Close | The 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_degree | TEXT | Contact Degree | A contact's degree. This property is required for the Facebook Ads Integration. This property will be automatically synced to via Lead Ads tool | contact |
| contact_email | TEXT | Contact Email | A contact's email address | contact |
| contact_engagements_last_meeting_booked | TIMESTAMP | Contact date of last meeting booked in meetings tool | The date of the most recent meeting a contact has booked through the meetings tool. | contact |
| contact_engagements_last_meeting_booked_campaign | TEXT | Contact Campaign of last booking in meetings tool | This 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_medium | TEXT | Contact Medium of last booking in meetings tool | This 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_source | TEXT | Contact Source of last booking in meetings tool | This 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_fax | TEXT | Contact Fax Number | A contact's primary fax number | contact |
| contact_field_of_study | TEXT | Contact Field of study | A contact's field of study. This property is required for the Facebook Ads Integration. This property will be automatically synced via the Lead Ads tool | contact |
| contact_first_conversion_date | TIMESTAMP | Contact First Conversion Date | The date this contact first submitted a form | contact |
| contact_first_conversion_event_name | TEXT | Contact First Conversion | The first form this contact submitted | contact |
| contact_first_deal_created_date | TIMESTAMP | Contact First Deal Created Date | The 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_firstname | TEXT | Contact First Name | A contact's first name | contact |
| contact_followercount | NUMERIC | Contact Follower Count | The number of Twitter followers a contact has | contact |
| contact_gender | TEXT | Contact Gender | contact | |
| contact_graduation_date | TEXT | Contact Graduation date | A contact's graduation date. This property is required for the Facebook Ads Integration. This property will be automatically synced via the Lead Ads tool | contact |
| contact_hs_analytics_average_page_views | NUMERIC | Contact Average Pageviews | The average number of pages a contact sees. This is automatically set by HubSpot for each contact. | contact |
| contact_hs_analytics_first_referrer | TEXT | Contact First Referring Site | The first website that referred a contact to your website. This is automatically set by HubSpot for each contact. | contact |
| contact_hs_analytics_first_timestamp | TIMESTAMP | Contact Time First Seen | The first time a contact has been seen. This is automatically set by HubSpot for each contact. | contact |
| contact_hs_analytics_first_touch_converting_campaign | TEXT | Contact First Touch Converting Campaign | The campaign responsible for the first touch creation of this contact | contact |
| contact_hs_analytics_first_url | TEXT | Contact First Page Seen | The first page a contact saw on your website. This is automatically set by HubSpot for each contact. | contact |
| contact_hs_analytics_first_visit_timestamp | TIMESTAMP | Contact time of First Session | The first time a contact visited your website. This is automatically set by HubSpot for each contact. | contact |
| contact_hs_analytics_last_referrer | TEXT | Contact Last Referring Site | The last website that referred a contact to your website. This is automatically set by HubSpot for each contact. | contact |
| contact_hs_analytics_last_timestamp | TIMESTAMP | Contact Time Last Seen | The last time and date a contact has viewed a page on your website. | contact |
| contact_hs_analytics_last_touch_converting_campaign | TEXT | Contact Last Touch Converting Campaign | The campaign responsible for the last touch creation of this contact | contact |
| contact_hs_analytics_last_url | TEXT | Contact Last Page Seen | The last page a contact saw on your website. This is automatically set by HubSpot for each contact. | contact |
| contact_hs_analytics_last_visit_timestamp | TIMESTAMP | Contact time of Last Session | The last time and date a contact visited your website. | contact |
| contact_hs_analytics_num_event_completions | NUMERIC | Contact Number of event completions | The sum of all events a contact has experienced. This is automatically set by HubSpot for each contact. | contact |
| contact_hs_analytics_num_page_views | NUMERIC | Contact Number of Pageviews | The 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_visits | NUMERIC | Contact Number of Sessions | The sum of all sessions a contact has made to your website. This is automatically set by HubSpot for each contact. | contact |
| contact_hs_analytics_revenue | NUMERIC | Contact Event Revenue | Event 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-HubSpot | contact |
| contact_hs_analytics_source | TEXT | Contact Original Source | First known source the contact used to find your website. Set automatically, but may be updated manually. | contact |
| contact_hs_analytics_source_data_1 | TEXT | Contact Original Source Drill-Down 1 | Additional 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_2 | TEXT | Contact Original Source Drill-Down 2 | Additional information about the source through which a contact first found your website. This property is automatically set by HubSpot. | contact |
| contact_hs_buying_role | TEXT | Contact Buying Role | The 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_confirmed | BOOLEAN | Contact Email Confirmed | Email Confirmation status of user of Content Membership | contact |
| contact_hs_content_membership_notes | TEXT | Contact Membership Notes | The notes relating to the contact's content membership. | contact |
| contact_hs_content_membership_registered_at | TIMESTAMP | Contact Registered At | Datetime at which this user was set up for Content Membership | contact |
| contact_hs_content_membership_registration_domain_sent_to | TEXT | Contact Domain to which registration email was sent | Domain to which the registration invitation email for Content Membership was sent to | contact |
| contact_hs_content_membership_registration_email_sent_at | TIMESTAMP | Contact Time registration email was sent | Datetime at which this user was sent a registration invitation email for Content Membership | contact |
| contact_hs_content_membership_status | TEXT | Contact Status | The status of the contact's content membership. | contact |
| contact_hs_createdate | TIMESTAMP | Contact Object create date/time | The 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_address | BOOLEAN | Contact Invalid email address | The email address associated with this contact is invalid. | contact |
| contact_hs_email_bounce | NUMERIC | Contact Marketing emails bounced | The number of marketing emails that bounced for the current email address. This is automatically set by HubSpot. | contact |
| contact_hs_email_click | NUMERIC | Contact Marketing emails clicked | The 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_reason | TEXT | Contact Email address quarantine reason | The reason why the email address has been quarantined. | contact |
| contact_hs_email_delivered | NUMERIC | Contact Marketing emails delivered | The number of marketing emails delivered for the current email address. This is automatically set by HubSpot. | contact |
| contact_hs_email_domain | TEXT | Contact Email Domain | A contact's email address domain | contact |
| contact_hs_email_first_click_date | TIMESTAMP | Contact First marketing email click date | The 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_date | TIMESTAMP | Contact Concat first marketing email open date | The 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_date | TIMESTAMP | Contact First marketing email reply date | The 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_date | TIMESTAMP | Contact first marketing email send date | The 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_enum | TEXT | Contact Email hard bounce reason | The 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_date | TIMESTAMP | Contact last marketing email click date | The 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_name | TEXT | Contact Last marketing email name | The name of the last marketing email sent to the current email address. This is automatically set by HubSpot. | contact |
| contact_hs_email_last_open_date | TIMESTAMP | Contact Last marketing email open date | The 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_date | TIMESTAMP | Contact Last marketing email reply date | The 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_date | TIMESTAMP | Contact Contac last marketing email send date | The 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_open | NUMERIC | Contact Marketing emails opened | The number of marketing emails opened for the current email address. This is automatically set by HubSpot. | contact |
| contact_hs_email_optout | BOOLEAN | Contact Unsubscribed from all email | Indicates that the current email address has opted out of all email. | contact |
| contact_hs_email_quarantined | BOOLEAN | Contact Email Address Quarantined | Indicates 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_reason | TEXT | Contact Email address automated quarantine reason | The automated reason why the email address has been quarantined. | contact |
| contact_hs_email_replied | NUMERIC | Contact Marketing emails replied | The number of marketing emails replied to by the current email address. This is automatically set by HubSpot. | contact |
| contact_hs_email_sends_since_last_engagement | NUMERIC | Contact Sends Since Last Engagement | The 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_emailconfirmationstatus | TEXT | Contact Marketing email confirmation status | The status of a contact's eligibility to receive marketing email. This is automatically set by HubSpot. | contact |
| contact_hs_facebook_click_id | TEXT | Contact Facebook click id | contact | |
| contact_hs_feedback_last_nps_follow_up | TEXT | Contact Last NPS survey comment | Last NPS survey comment that this contact gave | contact |
| contact_hs_feedback_last_nps_rating | TEXT | Contact Last NPS survey rating | Last NPS survey rating that this contact gave | contact |
| contact_hs_feedback_last_survey_date | TIMESTAMP | Contact Last NPS survey date | The time that this contact last submitted a NPS survey response. This is automatically set by HubSpot. | contact |
| contact_hs_google_click_id | TEXT | Contact Google ad click id | contact | |
| contact_hs_ip_timezone | TEXT | Contact IP Timezone | The 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_unworked | BOOLEAN | Contact unworked | Contact has not been assigned or has not been engaged after last owner assignment/re-assignment | contact |
| contact_hs_language | TEXT | Contact Preferred language | Set your contact's preferred language for communications. This property can be changed from an import, form, or integration. | contact |
| contact_hs_last_sales_activity_timestamp | TIMESTAMP | Contact Last Engagement Date | The 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_date | TIMESTAMP | Contact Last sequence ended date | The last sequence ended date. | contact |
| contact_hs_latest_sequence_enrolled | NUMERIC | Contact Last sequence enrolled | The last sequence enrolled. | contact |
| contact_hs_latest_sequence_enrolled_date | TIMESTAMP | Contact Last sequence enrolled date | The last sequence enrolled date. | contact |
| contact_hs_lead_status | TEXT | Contact Lead Status | The contact's sales, prospecting or outreach status | contact |
| contact_hs_legal_basis | TEXT | Contact Legal basis for processing contact's data | Legal basis for processing contact's data; 'Not applicable' will exempt the contact from GDPR protections | contact |
| contact_hs_lifecyclestage_customer_date | TIMESTAMP | Contact Became a Customer Date | The date when a contact's lifecycle stage changed to Customer. This is automatically set by HubSpot for each contact. | contact |
| contact_hs_lifecyclestage_evangelist_date | TIMESTAMP | Contact Became an Evangelist Date | The date when a contact's lifecycle stage changed to Evangelist. This is automatically set by HubSpot for each contact. | contact |
| contact_hs_lifecyclestage_lead_date | TIMESTAMP | Contact Became a Lead Date | The date when a contact's lifecycle stage changed to Lead. This is automatically set by HubSpot for each contact. | contact |
| contact_hs_lifecyclestage_marketingqualifiedlead_date | TIMESTAMP | Contact Became a Marketing Qualified Lead Date | The date when a contact's lifecycle stage changed to MQL. This is automatically set by HubSpot for each contact. | contact |
| contact_hs_lifecyclestage_opportunity_date | TIMESTAMP | Contact Became an Opportunity Date | The date when a contact's lifecycle stage changed to Opportunity. This is automatically set by HubSpot for each contact. | contact |
| contact_hs_lifecyclestage_other_date | TIMESTAMP | Contact Became an Other Lifecycle Date | The date when a contact's lifecycle stage changed to Other. This is automatically set by HubSpot for each contact. | contact |
| contact_hs_lifecyclestage_salesqualifiedlead_date | TIMESTAMP | Contact Became a Sales Qualified Lead Date | The date when a contact's lifecycle stage changed to SQL. This is automatically set by HubSpot for each contact. | contact |
| contact_hs_lifecyclestage_subscriber_date | TIMESTAMP | Contact Became a Subscriber Date | The date when a contact's lifecycle stage changed to Subscriber. This is automatically set by HubSpot for each contact. | contact |
| contact_hs_marketable_reason_id | TEXT | Contact Marketing contact status source name | The ID of the activity that set the contact as a marketing contact | contact |
| contact_hs_marketable_reason_type | TEXT | Contact Marketing contact status source type | The type of the activity that set the contact as a marketing contact | contact |
| contact_hs_marketable_status | TEXT | Contact Marketing contact status | The marketing status of a contact | contact |
| contact_hs_marketable_until_renewal | TEXT | Contact Marketing contact until next update | Specifies if this contact will be set as non-marketing on renewal | contact |
| contact_hs_object_id | TEXT | Contact ID (HubSpot) | The unique ID for this contact. This unique ID is automatically populated by HubSpot and cannot be changed. | contact |
| contact_hs_persona | TEXT | Contact Persona | A contact's persona | contact |
| contact_hs_predictivecontactscore | NUMERIC | Contact Predictive Lead Score | A score calculated by HubSpot that represents a contact's likelihood to become a customer | contact |
| contact_hs_predictivecontactscore_v2 | NUMERIC | Contact Likelihood to close | The 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_predictivecontactscorebucket | TEXT | Contact Lead Rating | The rating of this contact based on their predictive lead score | contact |
| contact_hs_predictivescoringtier | TEXT | Contact priority | A 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_clicked | TIMESTAMP | Contact Recent Sales Email Clicked Date | The last time a tracked sales email was clicked by this user | contact |
| contact_hs_sales_email_last_opened | TIMESTAMP | Contact Recent Sales Email Opened Date | The 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_replied | TIMESTAMP | Contact Recent Sales Email Replied Date | The 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_count | NUMERIC | Contact Number of sequences enrolled | The number of sequences enrolled. | contact |
| contact_hs_sequences_is_enrolled | BOOLEAN | Contact Currently in Sequence | A yes/no field that indicates whether the contact is currently in a Sequence. | contact |
| contact_hs_social_facebook_clicks | NUMERIC | Contact Facebook Clicks | The number clicks on links shared on Facebook | contact |
| contact_hs_social_google_plus_clicks | NUMERIC | Contact Google Plus Clicks | The number clicks on links shared on Google Plus | contact |
| contact_hs_social_last_engagement | TIMESTAMP | Contact Most Recent Social Click | The 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_clicks | NUMERIC | Contact LinkedIn Clicks | The number clicks on links shared on LinkedIn | contact |
| contact_hs_social_num_broadcast_clicks | NUMERIC | Contact Broadcast Clicks | The number of clicks on published social messages. This is set automatically by HubSpot for each contact. | contact |
| contact_hs_social_twitter_clicks | NUMERIC | Contact Twitter Clicks | The 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_close | NUMERIC | Contact Time between contact creation and deal close | contact | |
| contact_hs_time_between_contact_creation_and_deal_creation | NUMERIC | Contact Time between contact creation and deal creation | contact | |
| contact_hs_time_to_move_from_lead_to_customer | NUMERIC | Contact 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_customer | NUMERIC | Contact 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_customer | NUMERIC | Contact 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_customer | NUMERIC | Contact 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_customer | NUMERIC | Contact 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_assigneddate | TIMESTAMP | Contact Owner Assigned Date | The 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_id | TEXT | Contact owner | The 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_id | TEXT | Contact HubSpot Team | The team of the owner of a contact. | contact |
| contact_hubspotscore | NUMERIC | Contact HubSpot Score | The number that shows qualification of contacts to sales readiness. It can be set in HubSpot's Lead Scoring app. | contact |
| contact_industry | TEXT | Contact Industry | The industry a contact is in | contact |
| contact_ip_city | CITY | Contact IP City | The 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_country | COUNTRY | Contact IP Country | The 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_code | COUNTRY | Contact IP Country Code | The 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_state | REGION | Contact IP State/Region | The 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_code | TEXT | Contact IP State Code/Region Code | The 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_function | TEXT | Contact Job function | A contact's job function. This property is required for the Facebook Ads Integration. This property will be automatically synced via the Lead Ads tool | contact |
| contact_jobtitle | TEXT | Contact Job Title | A contact's job title | contact |
| contact_kloutscoregeneral | NUMERIC | Contact Klout Score | A contact's Klout score, a measure of Internet influence | contact |
| contact_lastmodifieddate | TIMESTAMP | Contact Last Modified Date | The date any property on this contact was modified | contact |
| contact_lastname | TEXT | Contact Last Name | A contact's last name | contact |
| contact_lifecyclestage | TEXT | Contact Lifecycle Stage | The qualification of contacts to sales readiness. It can be set through imports, forms, workflows, and manually on a per contact basis. | contact |
| contact_linkedinbio | TEXT | Contact LinkedIn Bio | A contact's LinkedIn bio | contact |
| contact_linkedinconnections | NUMERIC | Contact LinkedIn Connections | How many LinkedIn connections they have | contact |
| contact_marital_status | TEXT | Contact Marital Status | A contact's marital status. This property is required for the Facebook Ads Integration. This property will be automatically synced via the Lead Ads tool | contact |
| contact_message | TEXT | Contact Message | A default property to be used for any message or comments a contact may want to leave on a form. | contact |
| contact_military_status | TEXT | Contact Military status | A contact's military status. This property is required for the Facebook Ads Integration. This property will be automatically synced via the Lead Ads tool | contact |
| contact_mobilephone | TEXT | Contact Mobile Phone Number | A contact's mobile phone number | contact |
| contact_notes_last_contacted | TIMESTAMP | Contact Last Contacted | The 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_updated | TIMESTAMP | Contact Notes Last Activity Date | The 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_date | TIMESTAMP | Contact Next Activity Date | The 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_deals | NUMERIC | Contact Associated Deals | The number of deals associated with this contact. This is set automatically by HubSpot. | contact |
| contact_num_contacted_notes | NUMERIC | Contact number of times contacted | The 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_events | NUMERIC | Contact Number of Form Submissions | The number of forms this contact has submitted | contact |
| contact_num_notes | NUMERIC | Contact Number of Sales Activities | The 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_events | NUMERIC | Contact Number of Unique Forms Submitted | The number of different forms this contact has submitted | contact |
| contact_numemployees | TEXT | Contact Number of Employees | The number of company employees | contact |
| contact_owneremail | TEXT | Contact 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_ownername | TEXT | Contact 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_phone | TEXT | Contact Phone Number | A contact's primary phone number | contact |
| contact_recent_conversion_date | TIMESTAMP | Contact Recent Conversion Date | The date this contact last submitted a form | contact |
| contact_recent_conversion_event_name | TEXT | Contact Recent Conversion | The last form this contact submitted | contact |
| contact_recent_deal_amount | NUMERIC | Contact Recent Deal Amount | The 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_date | TIMESTAMP | Contact Recent Deal Close Date | The 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_status | TEXT | Contact Relationship Status | A contact's relationship status. This property is required for the Facebook Ads Integration. This property will be automatically synced via the Lead Ads tool | contact |
| contact_sales_status | TEXT | Sales Status | Sales status | contact |
| contact_salutation | TEXT | Contact Salutation | The title used to address a contact | contact |
| contact_school | TEXT | Contact School | A contact's school. This property is required for the Facebook Ads Integration. This property will be automatically synced via the Lead Ads tool | contact |
| contact_seniority | TEXT | Contact Seniority | A contact's seniority. This property is required for the Facebook Ads Integration. This property will be automatically synced via the Lead Ads tool | contact |
| contact_source | TEXT | Contact Source | The contact source | contact |
| contact_start_date | TEXT | Contact Start date | A contact's start date. This property is required for the Facebook Ads Integration. This property will be automatically synced via the Lead Ads tool | contact |
| contact_state | REGION | Contact State/Region | The contact's state of residence. This might be set via import, form, or integration. | contact |
| contact_total_revenue | NUMERIC | Contact Total Revenue | The 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_twitterbio | TEXT | Contact Twitter Bio | The contact's Twitter bio. This is set by HubSpot using the contact's email address. | contact |
| contact_twitterhandle | TEXT | Contact Twitter Username | The contact's Twitter handle. This is set by HubSpot using the contact's email address. | contact |
| contact_twitterprofilephoto | TEXT | Contact Twitter Profile Photo | The contact's Twitter profile photo. This is set by HubSpot using the contact's email address. | contact |
| contact_type | TEXT | Contact Type | The contact type | contact |
| contact_website | TEXT | Contact Website URL | The contact's company website | contact |
| contact_work_email | TEXT | Contact Work email | A contact's work email. This property is required for the Facebook Ads Integration. This property will be automatically synced via the Lead Ads tool | contact |
| contact_zip | TEXT | Contact Postal Code | The contact's zip code. This might be set via import, form, or integration. | contact |
| createddate | TIMESTAMP | Created Date | Alias for contact_createdate | contact |
| customfield_hs_createdate | TIMESTAMP | Custom Field Modified Date | Most recent timestamp of any property update for this custom object. | customfield |
| customfield_hs_lastmodifieddate | TIMESTAMP | Custom Field Last Modified Date | Most recent timestamp of any property update for this custom object. | customfield |
| customobject_createdat | TIMESTAMP | Custom Object Created at | The date the custom object was created. | custom_object |
| customobject_description | TEXT | Custom Object Description | The custom object description. | custom_object |
| customobject_display_order | TEXT | Custom Object Display Order | The custom object display order. | custom_object |
| customobject_field_type | TEXT | Custom Object Field Type | The custom object field type | custom_object |
| customobject_group_name | TEXT | Custom Object Group Name | The custom object group name. | custom_object |
| BOOLEAN | Custom Object Hidden | The custom object is hiddnen or not. | custom_object | |
| customobject_id | TEXT | Custom Object ID | The custom object type ID. | custom_object |
| customobject_label | TEXT | Custom Object Label | The custom object label. | custom_object |
| customobject_name | TEXT | Custom object name | Most 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_name | TEXT | Custom object property name | Name of the custom object properties (fields). | custom_object |
| customobject_type | TEXT | Custom Object Type | The custom object type. | custom_object |
| customobject_updatedat | TIMESTAMP | Custom Object Updated At | Most 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 |
| datasource | TEXT | Data Source | The name of the Windsor connector returning the row | |
| date | DATE | Date | The Date | |
| day_of_month | TEXT | Day of month | Day of the month | |
| deal_amount | NUMERIC | Deal Amount | The total amount of the deal | deal |
| deal_amount_in_home_currency | NUMERIC | Deal Amount in company currency | The amount of the deal, using the exchange rate, in your company's currency | deal |
| deal_closed_lost_reason | TEXT | Deal Closed Lost Reason | Reason why this deal was lost | deal |
| deal_closed_won_reason | TEXT | Deal Closed Won Reason | Reason why this deal was won | deal |
| deal_closedate | TIMESTAMP | Deal Close Date | The expected close date of the deal | deal |
| deal_createdate | TIMESTAMP | Deal Create Date | The date the deal was created. This property is set automatically by HubSpot. | deal |
| deal_currency_code | TEXT | Deal Currency | Currency code for the deal. | deal |
| deal_dealname | TEXT | Deal Name | The name given to this deal. | deal |
| deal_dealstage | TEXT | Deal Stage | The stage of the deal. Deal stages allow you to categorize and track the progress of the deals that you are working on. | deal |
| deal_dealtype | TEXT | Deal Type | The type of deal. By default, categorize your deal as either a New Business or Existing Business. | deal |
| deal_description | TEXT | Deal Description | Description of the deal | deal |
| deal_engagements_last_meeting_booked | TIMESTAMP | Deal Date of last meeting booked in meetings tool | The date of the most recent meeting an associated contact has booked through the meetings tool. | deal |
| deal_engagements_last_meeting_booked_campaign | TEXT | Deal Campaign of last booking in meetings tool | This 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_medium | TEXT | Deal Medium of last booking in meetings tool | This 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_source | TEXT | Deal Source of last booking in meetings tool | This 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_acv | NUMERIC | Deal Annual contract value | The annual contract value (ACV) of this deal. | deal |
| deal_hs_analytics_source | TEXT | Deal Original Source Type | Original source for the contact with the earliest activity for this deal. | deal |
| deal_hs_analytics_source_data_1 | TEXT | Deal Original Source Data 1 | Additional 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_2 | TEXT | Deal Original Source Data 2 | Additional 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_arr | NUMERIC | Deal Annual recurring revenue | The annual recurring revenue (ARR) of this deal. | deal |
| deal_hs_forecast_amount | NUMERIC | Deal Forecast Amount | The forecasted deal value calculated by multiplying the forecast probability and deal amount | deal |
| deal_hs_forecast_probability | NUMERIC | Deal Forecast Probability | The percent probability the deal will close, expressed as a decimal. | deal |
| deal_hs_lastmodifieddate | TIMESTAMP | Deal Last Modified Date | Most 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_category | TEXT | Deal Forecast category | The likelihood a deal will close. This property is used for manual forecasting your deals. | deal |
| deal_hs_mrr | NUMERIC | Deal Monthly recurring revenue | The monthly recurring revenue (MRR) of this deal. | deal |
| deal_hs_next_step | TEXT | Deal Next step | A short description of the next step for the deal | deal |
| deal_hs_object_id | NUMERIC | Deal ID (HubSpot) | The unique ID for this deal. This unique ID is automatically populated by HubSpot and cannot be changed. | deal |
| deal_hs_priority | TEXT | Deal Priority | deal | |
| deal_hs_tcv | NUMERIC | Deal Total contract value | The total contract value (TCV) of this deal. | deal |
| deal_hubspot_owner_assigneddate | TIMESTAMP | Deal Owner Assigned Date | The date the most recent deal owner was assigned to a deal. This is updated automatically by HubSpot. | deal |
| deal_hubspot_owner_id | TEXT | Deal Owner ID | The owner of the deal | deal |
| deal_hubspot_team_id | TEXT | Deal HubSpot Team | The team of the owner of the deal. | deal |
| deal_notes_last_contacted | TIMESTAMP | Deal Last Contacted | The 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_updated | TIMESTAMP | Deal Last Activity Date | The 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_date | TIMESTAMP | Deal Next Activity Date | The 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_contacts | NUMERIC | Deal Number of Contacts | The number of contacts associated with this deal. This property is set automatically by HubSpot. | deal |
| deal_num_contacted_notes | NUMERIC | Deal Number of times contacted | The number of times a call, email or meeting was logged for this deal | deal |
| deal_num_notes | NUMERIC | Deal Number of Sales Activities | The total number of sales activities (notes, calls, emails, meetings, or tasks) logged for a deal. This is updated automatically by HubSpot. | deal |
| deal_pipeline | TEXT | Deal Pipeline | The pipeline the deal is in. This determines which stages are options for the deal. | deal |
| TEXT | Alias for contact_email | contact | ||
| email_bounced | NUMERIC | Email engagement bounced | The recipient's email server couldn't or wouldn't accept the message, and no further attempts will be made to deliver the message. | |
| email_clicked | NUMERIC | Email engagement clicks | The recipient clicked on a link within the message. | |
| email_clicked_on_link | NUMERIC | Email engagement click on identified link | The recipient click on identified link in the email. | |
| email_deferred | NUMERIC | Email engagement deferred | The recipient’s email server has temporarily rejected message, and subsequent attempts will be made to deliver the message. | |
| email_delivered | NUMERIC | Email engagement delivered | The recipient's email server has accepted the message and the message has been successfully delivered to the recipient. | |
| email_dropped | NUMERIC | Email engagement dropped | The message was rejected, either by HubSpot or by our delivery provider, and no attempt will be made to deliver the message. | |
| email_errored | NUMERIC | Email engagement error | ||
| email_event_created | TIMESTAMP | Email engagement timestamp | Email engagement timestamp | |
| email_forwarded | NUMERIC | Email engagement forwarded | The recipient forwarded the email. | |
| email_mta_dropped | NUMERIC | Email engagement mta dropped | ||
| email_opened | NUMERIC | Email engagement opened | The recipient opened the message. | |
| email_optinchange | NUMERIC | Email engagement spam opt in change | ||
| email_processed | NUMERIC | Email engagement processed | The message has been received by our delivery provider, which has indicated it will attempt to deliver the message to the recipient's email server. | |
| email_recipient | TEXT | Email recipient | Email recipient | |
| email_replied | NUMERIC | Email engagement replied | The recipient replied to the email. | |
| email_selected | NUMERIC | Email engagement selected | ||
| email_sent | NUMERIC | Email engagement sent | The message was sent to and received by our delivery provider. | |
| email_spamreported | NUMERIC | Email engagement spam reported | The recipient flagged the message as spam. | |
| email_statuschange | NUMERIC | Email engagement status changed | The recipient changed their email subscriptions in some way. | |
| email_suppressed | NUMERIC | Email engagement suppressed | The message was not sent, the recipient has been unengaged with previous marketing emails. | |
| email_unbounced | NUMERIC | Email engagement unbounced | This events occur when a particular email address is either automatically or manually unbounced by HubSpot. This resets the bounce status of the recipient, potentially allowing them to receive emails from your portal. | |
| email_unsubscribed | NUMERIC | Email engagement unsubscribed | The recipient unsubscribed from subscription. | |
| emailstats_aggregations_counters_bounce | NUMERIC | Emailstats Aggregations Counters Bounce | The number of times contacts were sent your email, but they didn’t receive it because either their address is invalid, your email hit their spam filter, or your email was marked as spam by other people. | emailstats |
| emailstats_aggregations_counters_click | NUMERIC | Emailstats Aggregations Counters Click | The number of unique recipients who clicked on any link in your email, excluding the Unsubscribe and Subscription Preferences links. | emailstats |
| emailstats_aggregations_counters_contactslost | NUMERIC | Emailstats Aggregations Counters Contactslost | The sum of contacts that have unsubscribed, marked the email as spam, or have hardbounced. | emailstats |
| emailstats_aggregations_counters_delivered | NUMERIC | Emailstats Aggregations Counters Delivered | The number of emails succesfully delivered to an inbox | emailstats |
| emailstats_aggregations_counters_dropped | NUMERIC | Emailstats Aggregations Counters Dropped | The number of contacts that were not sent your email. This may be because they previously hard bounced, unsubscribed, marked you as spam, or because they have not engaged with any of your recent emails. | emailstats |
| emailstats_aggregations_counters_hardbounced | NUMERIC | Emailstats Aggregations Counters Hardbounced | These contacts were sent your email, but they didn’t receive it because either their address is invalid, your email hit their spam filter, or your email was marked as spam by other people. | emailstats |
| emailstats_aggregations_counters_notsent | NUMERIC | Emailstats Aggregations Counters Notsent | These contacts were not sent your email. This may be because they previously hard bounced, unsubscribed, marked you as spam, or because they have not engaged with any of your recent emails. | emailstats |
| emailstats_aggregations_counters_open | NUMERIC | Emailstats Aggregations Counters Open | The total number of unique opens | emailstats |
| emailstats_aggregations_counters_pending | NUMERIC | Emailstats Aggregations Counters Pending | The number of emails still trying to reach a contact's inbox. | emailstats |
| emailstats_aggregations_counters_reply | NUMERIC | Emailstats Aggregations Counters Reply | Emails Stats Counters Reply | emailstats |
| emailstats_aggregations_counters_selected | NUMERIC | Emailstats Aggregations Counters Selected | The number of contacts selected to receive this email. | emailstats |
| emailstats_aggregations_counters_sent | NUMERIC | Emailstats Aggregations Counters Sent | The total number of sent emails | emailstats |
| emailstats_aggregations_counters_softbounced | NUMERIC | Emailstats Aggregations Counters Softbounced | Soft bounces occur when a contact’s inbox has a temporary problem. You can still send to these people in the future. Contacts who hard bounce will be ineligible for later sends. | emailstats |
| emailstats_aggregations_counters_spamreport | NUMERIC | Emailstats Aggregations Counters Spamreport | The number of contacts received your email and marked it as spam. They won’t be sent to in the future. | emailstats |
| emailstats_aggregations_counters_suppressed | NUMERIC | Emailstats Aggregations Counters Suppressed | The number of contacts that did not receive your email due to graymail suppression. | emailstats |
| emailstats_aggregations_counters_unsubscribed | NUMERIC | Emailstats Aggregations Counters Unsubscribed | The number of contacts who received your email and unsubscribed. They won’t be sent to in the future. | emailstats |
| emailstats_aggregations_devicebreakdown_click_device_type_computer | NUMERIC | Emailstats Aggregations Devicebreakdown Click Device Type Computer | Click broken down by device type computer. | emailstats |
| emailstats_aggregations_devicebreakdown_click_device_type_mobile | NUMERIC | Emailstats Aggregations Devicebreakdown Click Device Type Mobile | Click broken down by device type mobile. | emailstats |
| emailstats_aggregations_devicebreakdown_click_device_type_unknown | NUMERIC | Emailstats Aggregations Devicebreakdown Click Device Type Unknown | Click broken down by device type unknown. | emailstats |
| emailstats_aggregations_devicebreakdown_open_device_type_computer | NUMERIC | Emailstats Aggregations Devicebreakdown Open Device Type Computer | Open broken down by device type computer. | emailstats |
| emailstats_aggregations_devicebreakdown_open_device_type_mobile | NUMERIC | Emailstats Aggregations Devicebreakdown Open Device Type Mobile | Open broken down by device type mobile. | emailstats |
| emailstats_aggregations_devicebreakdown_open_device_type_unknown | NUMERIC | Emailstats Aggregations Devicebreakdown Open Device Type Unknown | Open broken down by device type unknown. | emailstats |
| emailstats_aggregations_qualifierstats | NUMERIC | Emailstats Aggregations Qualifierstats | Emailstats Aggregations Qualifiers | emailstats |
| emailstats_aggregations_ratios_bounceratio | PERCENT | Emailstats Aggregations Ratios Bounceratio | The number of contacts that bounced from the email over the total number of selected contacts. | emailstats |
| emailstats_aggregations_ratios_clickratio | PERCENT | Emailstats Aggregations Ratios Clickratio | Click rate is the percentage of people who clicked a link in your email out of the people who were delivered your email. | emailstats |
| emailstats_aggregations_ratios_clickthroughratio | PERCENT | Emailstats Aggregations Ratios Clickthroughratio | This is the percentage of people who clicked a link in your email out of the people who opened your email. | emailstats |
| emailstats_aggregations_ratios_contactslostratio | PERCENT | Emailstats Aggregations Ratios Contactslostratio | The number of contacts that can no longer recive emails from the portal over the total number of selected contacts. | emailstats |
| emailstats_aggregations_ratios_deliveredratio | PERCENT | Emailstats Aggregations Ratios Deliveredratio | The number of succesfull deliveries over the number of selected contacts. | emailstats |
| emailstats_aggregations_ratios_hardbounceratio | PERCENT | Emailstats Aggregations Ratios Hardbounceratio | The number of contacts that hard bounced from the email over the total number of selected contacts. | emailstats |
| emailstats_aggregations_ratios_notsentratio | NUMERIC | Emailstats Aggregations Ratios Notsentratio | The number of contacts that were not sent emails over the total number of selected contacts. | emailstats |
| emailstats_aggregations_ratios_openratio | PERCENT | Emailstats Aggregations Ratios Openratio | Open rate is the percentage of people who opened your email out of the people who were delivered your email. | emailstats |
| emailstats_aggregations_ratios_pendingratio | PERCENT | Emailstats Aggregations Ratios Pendingratio | The number of contacts that soft bounced from the email over the total number of selected contacts. | emailstats |
| emailstats_aggregations_ratios_replyratio | PERCENT | Emailstats Aggregations Ratios Replyratio | Open rate is the percentage of people who replied to your email out of the people who were delivered your email. | emailstats |
| emailstats_aggregations_ratios_softbounceratio | PERCENT | Emailstats Aggregations Ratios Softbounceratio | The number of contacts that soft bounced from the email over the total number of selected contacts. | emailstats |
| emailstats_aggregations_ratios_spamreportratio | PERCENT | Emailstats Aggregations Ratios Spamreportratio | The number of contacts that mark the email as spam over the total number of selected contacts. | emailstats |
| emailstats_aggregations_ratios_unsubscribedratio | PERCENT | Emailstats Aggregations Ratios Unsubscribedratio | the number of contacts that have unsubscribed over the total number of selected contacts | emailstats |
| emailstats_interval_end | TIMESTAMP | Emailstats Interval End | End of the daily interval. | emailstats |
| emailstats_interval_start | TIMESTAMP | Emailstats Interval Start | Start of the daily interval. | emailstats |
| firstname | TEXT | First Name | Alias for contact_firstname | contact |
| lastname | TEXT | Last Name | Alias for contact_lastname | contact |
| lifecyclestage | TEXT | Lifecycle Stage | Alias for contact_lifecyclestage | contact |
| marketingemail_ab | TEXT | ab | ab | marketingemail |
| marketingemail_abhourstowait | TEXT | abHoursToWait | abHoursToWait | marketingemail |
| marketingemail_absamplesizedefault | TEXT | abSampleSizeDefault | abSampleSizeDefault | marketingemail |
| marketingemail_absamplingdefault | TEXT | abSamplingDefault | abSamplingDefault | marketingemail |
| marketingemail_absoluteurl | TEXT | absoluteUrl | absoluteUrl | marketingemail |
| marketingemail_absuccessmetric | TEXT | abSuccessMetric | abSuccessMetric | marketingemail |
| marketingemail_abtestpercentage | TEXT | abTestPercentage | abTestPercentage | marketingemail |
| marketingemail_abvariation | TEXT | abVariation | abVariation | marketingemail |
| marketingemail_allemailcampaignids | TEXT | allEmailCampaignIds | allEmailCampaignIds | marketingemail |
| marketingemail_analyticspageid | TEXT | analyticsPageId | analyticsPageId | marketingemail |
| marketingemail_analyticspagetype | TEXT | analyticsPageType | analyticsPageType | marketingemail |
| marketingemail_archivedat | TEXT | archivedAt | archivedAt | marketingemail |
| marketingemail_archivedindashboard | TEXT | archivedInDashboard | archivedInDashboard | marketingemail |
| marketingemail_audienceaccess | TEXT | audienceAccess | audienceAccess | marketingemail |
| marketingemail_author | TEXT | author | author | marketingemail |
| marketingemail_authorname | TEXT | authorName | authorName | marketingemail |
| marketingemail_blogrsssettings | TEXT | blogRssSettings | blogRssSettings | marketingemail |
| marketingemail_canspamsettingsid | TEXT | canSpamSettingsId | canSpamSettingsId | marketingemail |
| marketingemail_categoryid | TEXT | categoryId | categoryId | marketingemail |
| marketingemail_contentaccessruleids | TEXT | contentAccessRuleIds | contentAccessRuleIds | marketingemail |
| marketingemail_contentaccessruletypes | TEXT | contentAccessRuleTypes | contentAccessRuleTypes | marketingemail |
| marketingemail_contenttypecategory | TEXT | contentTypeCategory | contentTypeCategory | marketingemail |
| marketingemail_created | TIMESTAMP | created | created | marketingemail |
| marketingemail_createdbyid | TEXT | createdById | createdById | marketingemail |
| marketingemail_createpage | TEXT | createPage | createPage | marketingemail |
| marketingemail_currentlypublished | TEXT | currentlyPublished | currentlyPublished | marketingemail |
| marketingemail_currentstate | TEXT | currentState | currentState | marketingemail |
| marketingemail_customreplyto | TEXT | customReplyTo | customReplyTo | marketingemail |
| marketingemail_customreplytoenabled | TEXT | customReplyToEnabled | customReplyToEnabled | marketingemail |
| marketingemail_domain | TEXT | domain | domain | marketingemail |
| marketingemail_emailbody | TEXT | emailBody | emailBody | marketingemail |
| marketingemail_emailcampaigngroupid | TEXT | emailCampaignGroupId | emailCampaignGroupId | marketingemail |
| marketingemail_emailnote | TEXT | emailNote | emailNote | marketingemail |
| marketingemail_emailtemplatemode | TEXT | emailTemplateMode | emailTemplateMode | marketingemail |
| marketingemail_emailtype | TEXT | emailType | emailType | marketingemail |
| marketingemail_feedbacksurveyid | TEXT | feedbackSurveyId | feedbackSurveyId | marketingemail |
| marketingemail_flexareas | TEXT | flexAreas | flexAreas | marketingemail |
| marketingemail_freezedate | TIMESTAMP | freezeDate | freezeDate | marketingemail |
| marketingemail_fromname | TEXT | fromName | fromName | marketingemail |
| marketingemail_hascontentaccessrules | TEXT | hasContentAccessRules | hasContentAccessRules | marketingemail |
| marketingemail_htmltitle | TEXT | htmlTitle | htmlTitle | marketingemail |
| marketingemail_id | TEXT | id | id | marketingemail |
| marketingemail_iscreatedfomsandboxsync | TEXT | isCreatedFomSandboxSync | isCreatedFomSandboxSync | marketingemail |
| marketingemail_isgraymailsuppressionenabled | TEXT | isGraymailSuppressionEnabled | isGraymailSuppressionEnabled | marketingemail |
| marketingemail_isinstancelayoutpage | TEXT | isInstanceLayoutPage | isInstanceLayoutPage | marketingemail |
| marketingemail_ispublished | TEXT | isPublished | isPublished | marketingemail |
| marketingemail_isrecipientfatiguesuppressionenabled | TEXT | isRecipientFatigueSuppressionEnabled | isRecipientFatigueSuppressionEnabled | marketingemail |
| marketingemail_language | TEXT | language | language | marketingemail |
| marketingemail_layoutsections | TEXT | layoutSections | layoutSections | marketingemail |
| marketingemail_livedomain | TEXT | liveDomain | liveDomain | marketingemail |
| marketingemail_mailinglistsexcluded | TEXT | mailingListsExcluded | mailingListsExcluded | marketingemail |
| marketingemail_mailinglistsincluded | TEXT | mailingListsIncluded | mailingListsIncluded | marketingemail |
| marketingemail_maxrssentries | TEXT | maxRssEntries | maxRssEntries | marketingemail |
| marketingemail_metadescription | TEXT | metaDescription | metaDescription | marketingemail |
| marketingemail_name | TEXT | name | name | marketingemail |
| marketingemail_pageexpiryenabled | TEXT | pageExpiryEnabled | pageExpiryEnabled | marketingemail |
| marketingemail_pageredirected | TEXT | pageRedirected | pageRedirected | marketingemail |
| marketingemail_pastmabexperimentids | TEXT | pastMabExperimentIds | pastMabExperimentIds | marketingemail |
| marketingemail_portalid | TEXT | portalId | portalId | marketingemail |
| marketingemail_previewkey | TEXT | previewKey | previewKey | marketingemail |
| marketingemail_primaryemailcampaignid | TEXT | primaryEmailCampaignId | primaryEmailCampaignId | marketingemail |
| marketingemail_primaryrichtextmodulehtml | TEXT | primaryRichTextModuleHtml | primaryRichTextModuleHtml | marketingemail |
| marketingemail_processingstatus | TEXT | processingStatus | processingStatus | marketingemail |
| marketingemail_publishdate | TIMESTAMP | publishDate | publishDate | marketingemail |
| marketingemail_publishedat | TEXT | publishedAt | publishedAt | marketingemail |
| marketingemail_publishedbyemail | TEXT | publishedByEmail | publishedByEmail | marketingemail |
| marketingemail_publishedbyid | TEXT | publishedById | publishedById | marketingemail |
| marketingemail_publishedbyname | TEXT | publishedByName | publishedByName | marketingemail |
| marketingemail_publishedurl | TEXT | publishedUrl | publishedUrl | marketingemail |
| marketingemail_replyto | TEXT | replyTo | replyTo | marketingemail |
| marketingemail_resolveddomain | TEXT | resolvedDomain | resolvedDomain | marketingemail |
| marketingemail_rssemailbytext | TEXT | rssEmailByText | rssEmailByText | marketingemail |
| marketingemail_rssemailclickthroughtext | TEXT | rssEmailClickThroughText | rssEmailClickThroughText | marketingemail |
| marketingemail_rssemailcommenttext | TEXT | rssEmailCommentText | rssEmailCommentText | marketingemail |
| marketingemail_rssemailentrytemplateenabled | TEXT | rssEmailEntryTemplateEnabled | rssEmailEntryTemplateEnabled | marketingemail |
| marketingemail_rssemailimagemaxwidth | TEXT | rssEmailImageMaxWidth | rssEmailImageMaxWidth | marketingemail |
| marketingemail_rssemailurl | TEXT | rssEmailUrl | rssEmailUrl | marketingemail |
| marketingemail_scrubssubscriptionlinks | TEXT | scrubsSubscriptionLinks | scrubsSubscriptionLinks | marketingemail |
| marketingemail_sections | TEXT | sections | sections | marketingemail |
| marketingemail_securitystate | TEXT | securityState | securityState | marketingemail |
| marketingemail_slug | TEXT | slug | slug | marketingemail |
| marketingemail_smartemailfields | TEXT | smartEmailFields | smartEmailFields | marketingemail |
| marketingemail_state | TEXT | state | state | marketingemail |
| marketingemail_stylesettings | TEXT | styleSettings | styleSettings | marketingemail |
| marketingemail_subcategory | TEXT | subcategory | subcategory | marketingemail |
| marketingemail_subject | TEXT | subject | subject | marketingemail |
| marketingemail_subscription | TEXT | subscription | subscription | marketingemail |
| marketingemail_subscriptionname | TEXT | subscriptionName | subscriptionName | marketingemail |
| marketingemail_teamperms | TEXT | teamPerms | teamPerms | marketingemail |
| marketingemail_templatepath | TEXT | templatePath | templatePath | marketingemail |
| marketingemail_transactional | TEXT | transactional | transactional | marketingemail |
| marketingemail_translations | TEXT | translations | translations | marketingemail |
| marketingemail_unpublishedat | TEXT | unpublishedAt | unpublishedAt | marketingemail |
| marketingemail_updated | TIMESTAMP | updated | updated | marketingemail |
| marketingemail_updatedbyid | TEXT | updatedById | updatedById | marketingemail |
| marketingemail_url | TEXT | url | url | marketingemail |
| marketingemail_userperms | TEXT | userPerms | userPerms | marketingemail |
| marketingemail_userssheadlineassubject | TEXT | useRssHeadlineAsSubject | useRssHeadlineAsSubject | marketingemail |
| marketingemail_vidsexcluded | TEXT | vidsExcluded | vidsExcluded | marketingemail |
| marketingemail_vidsincluded | TEXT | vidsIncluded | vidsIncluded | marketingemail |
| marketingemail_visibletoall | TEXT | visibleToAll | visibleToAll | marketingemail |
| meetings_hs_activity_type | TEXT | Meetings Hubspot Activity Type | The type of meeting. The options are based on the meeting types set in your HubSpot account. | meetings |
| meetings_hs_attachment_ids | TEXT | Meetings Hubspot Attachment Ids | The IDs of the meeting's attachments. Multiple attachment IDs are separated by a semi-colon. | meetings |
| meetings_hs_createdate | TIMESTAMP | Meetings Create Date | Created date for the meeting. | meetings |
| meetings_hs_internal_meeting_notes | TEXT | Meetings Hubspot Internal Meeting Notes | The internal notes you take for your team during a meeting that are not included in the attendee meeting description. | meetings |
| meetings_hs_meeting_body | TEXT | Meetings Hubspot Meeting Body | The meeting description. | meetings |
| meetings_hs_meeting_end_time | TIMESTAMP | Meetings Hubspot Meeting End Time | The date and time when the meeting ends. | meetings |
| meetings_hs_meeting_external_url | TEXT | Meetings Hubspot Meeting External URL | The external URL for the calendar event. For example, this could be a Google calendar link or a Microsoft Outlook calendar link. | meetings |
| meetings_hs_meeting_location | TEXT | Meetings Hubspot Meeting Location | The internal notes you take for your team during a meeting that are not included in the attendee meeting description. | meetings |
| meetings_hs_meeting_start_time | TIMESTAMP | Meetings Hubspot Meeting Start Time | The date and time when the meeting starts. The value for this property should match the value for hs_timestamp. | meetings |
| meetings_hs_meeting_title | TEXT | Meetings Hs Meeting Title | The title of the meeting. | meetings |
| meetings_hs_timestamp | TIMESTAMP | Meetings Hs Timestamp | This field marks the date and time that the meeting occurred. You can use either a Unix timestamp in milliseconds or UTC format. | meetings |
| meetings_hubspot_owner_id | TEXT | Meetings Hubspot Owner Id | The ID of the owner associated with the meeting. This field determines the user listed as the meeting creator on the record timeline. | meetings |
| month | TEXT | Month | Number of the month | |
| owner_archived | TEXT | Owner Archived | Owner Archived | owner |
| owner_created_at | TIMESTAMP | Owner Created At | Owner Created At | owner |
| owner_email | TEXT | Owner Email | Owner Email | owner |
| owner_first_name | TEXT | Owner First Name | Owner First Name | owner |
| owner_last_name | TEXT | Owner Last Name | Owner Last Name | owner |
| owner_owner_id | TEXT | Owner Id | Owner Id | owner |
| owner_updated_at | TIMESTAMP | Owner Updated At | Owner Updated At | owner |
| owner_user_id | TEXT | Owner User Id | Owner User Id | owner |
| phone | TEXT | Phone Number | Alias for contact_phone | contact |
| pipeline_id | TEXT | Pipeline ID | Pipeline ID | pipeline |
| pipeline_name | TEXT | Pipeline Name | Pipeline name | pipeline |
| pipeline_stage_created_at | TIMESTAMP | Pipeline Stage Created Date | The timestamp that specifies when the stage was created | pipeline |
| pipeline_stage_display_order | NUMERIC | Pipeline Stage Display Order Number | Stage display order number | pipeline |
| pipeline_stage_id | TEXT | Pipeline Stage ID | Stage ID | pipeline |
| pipeline_stage_is_archived | BOOLEAN | Pipeline Is Stage Archived | Is stage archived | pipeline |
| pipeline_stage_is_closed | BOOLEAN | Pipeline Is Closed | Is deal closed | pipeline |
| pipeline_stage_name | TEXT | Pipeline Stage Name | Stage name | pipeline |
| pipeline_stage_probability | TEXT | Pipeline Probablity | Deal probability | pipeline |
| pipeline_stage_updated_at | TIMESTAMP | Pipeline Stage Last Modified Date | The timestamp that specifies when the stage was modified | pipeline |
| source | TEXT | Source | The name of the Windsor connector returning the row | |
| tickets_closed_date | TIMESTAMP | Close date | The date the ticket was closed | tickets |
| tickets_content | TEXT | Ticket description | Description of the ticket | tickets |
| tickets_created_by | TEXT | Created by | VID of contact that created the ticket | tickets |
| tickets_createdate | TIMESTAMP | Create date | The date the ticket was created | tickets |
| tickets_first_agent_reply_date | TIMESTAMP | First agent email response date | The date of the first email response from an agent after a ticket was created | tickets |
| tickets_hs_all_accessible_team_ids | TEXT | All teams | The team IDs, including up the team hierarchy, corresponding to all owner referencing properties for this object, both default and custom | tickets |
| tickets_hs_all_assigned_business_unit_ids | TEXT | Business units | The business units this record is assigned to. | tickets |
| tickets_hs_all_associated_contact_companies | TEXT | All associated contact companies | All associated contact companies | tickets |
| tickets_hs_all_associated_contact_emails | TEXT | All associated contact emails | All associated contact emails | tickets |
| tickets_hs_all_associated_contact_firstnames | TEXT | All associated contact first names | All associated contact first names | tickets |
| tickets_hs_all_associated_contact_lastnames | TEXT | All associated contact last names | All associated contact last names | tickets |
| tickets_hs_all_associated_contact_mobilephones | TEXT | All associated contact mobile phones | All associated contact mobile phones | tickets |
| tickets_hs_all_associated_contact_phones | TEXT | All associated contact phones | All associated contact phones | tickets |
| tickets_hs_all_conversation_mentions | TEXT | All conversation mentions | All mentioned users on the associated conversations | tickets |
| tickets_hs_all_owner_ids | TEXT | All owner ids | The value of all owner referencing properties for this object, both default and custom | tickets |
| tickets_hs_all_team_ids | TEXT | All team ids | The team IDs, including up the team hierarchy, corresponding to all owner referencing properties for this object, both default and custom | tickets |
| tickets_hs_applied_sla_rule_config_at | TEXT | Applied SLA Rule Config Date | Timestamp the current SLA Rule Config was applied to the ticket | tickets |
| tickets_hs_applied_sla_rule_config_id | TEXT | Applied SLA Rule Config ID | Reference to the SLA rule that was applied to this ticket | tickets |
| tickets_hs_assigned_team_ids | TEXT | Assigned Teams | The target main teams or the user's main team assigned to the ticket by automatic assignment. | tickets |
| tickets_hs_assignment_method | TEXT | Assignment Method | defines how the Object Assignment is done | tickets |
| tickets_hs_auto_generated_from_thread_id | TEXT | Auto-generated from thread id | Thread that this ticket was automatically created for using ticket rules | tickets |
| tickets_hs_conversations_originating_message_id | TEXT | Originating Conversations Message Id | Conversations Message Id of the message that originated this ticket | tickets |
| tickets_hs_conversations_originating_thread_id | TEXT | Conversations originating thread id | Thread that this ticket was originally created for | tickets |
| tickets_hs_created_by_user_id | TEXT | Created by user ID | The user that created this object. This value is automatically set by HubSpot and may not be modified. | tickets |
| tickets_hs_createdate | TIMESTAMP | HubSpot create date | Internal read-only property representing the date the ticket was created in HubSpot | tickets |
| tickets_hs_custom_inbox | TEXT | Custom inbox ID | ID of the custom inbox the ticket is associated with | tickets |
| tickets_hs_date_entered_1 | TIMESTAMP | Date entered 'New (Support Pipeline)' | The date and time when the ticket entered the 'New' stage, 'Support Pipeline' pipeline | tickets |
| tickets_hs_date_entered_2 | TIMESTAMP | Date entered 'Waiting on contact (Support Pipeline)' | The date and time when the ticket entered the 'Waiting on contact' stage, 'Support Pipeline' pipeline | tickets |
| tickets_hs_date_entered_3 | TIMESTAMP | Date entered 'Waiting on us (Support Pipeline)' | The date and time when the ticket entered the 'Waiting on us' stage, 'Support Pipeline' pipeline | tickets |
| tickets_hs_date_entered_4 | TIMESTAMP | Date entered 'Closed (Support Pipeline)' | The date and time when the ticket entered the 'Closed' stage, 'Support Pipeline' pipeline | tickets |
| tickets_hs_date_exited_1 | TIMESTAMP | Date exited 'New (Support Pipeline)' | The date and time when the ticket exited the 'New' stage, 'Support Pipeline' pipeline | tickets |
| tickets_hs_date_exited_2 | TIMESTAMP | Date exited 'Waiting on contact (Support Pipeline)' | The date and time when the ticket exited the 'Waiting on contact' stage, 'Support Pipeline' pipeline | tickets |
| tickets_hs_date_exited_3 | TIMESTAMP | Date exited 'Waiting on us (Support Pipeline)' | The date and time when the ticket exited the 'Waiting on us' stage, 'Support Pipeline' pipeline | tickets |
| tickets_hs_date_exited_4 | TIMESTAMP | Date exited 'Closed (Support Pipeline)' | The date and time when the ticket exited the 'Closed' stage, 'Support Pipeline' pipeline | tickets |
| tickets_hs_email_subject | TEXT | Email subject | Email subject | tickets |
| tickets_hs_external_object_ids | TEXT | External object ids | Unique ids corresponding to tickets in a system outside of HubSpot | tickets |
| tickets_hs_feedback_last_ces_follow_up | TEXT | Last CES survey comment | Last CES survey comment that this contact gave for this ticket | tickets |
| tickets_hs_feedback_last_ces_rating | TEXT | Last CES survey rating | Last CES survey rating that this contact gave for this ticket | tickets |
| tickets_hs_feedback_last_survey_date | TIMESTAMP | Last CES survey date | The time that this contact last submitted a CES survey response. This is automatically set by HubSpot. | tickets |
| tickets_hs_file_upload | TEXT | File upload | Files attached to a support form by a contact. | tickets |
| tickets_hs_first_agent_message_sent_at | TIMESTAMP | First agent response date | The date of the first response from an agent out of all associated conversations | tickets |
| tickets_hs_helpdesk_sort_timestamp | TIMESTAMP | Helpdesk Sort Timestamp | A calculated property to help with sorting in the Helpdesk | tickets |
| tickets_hs_in_helpdesk | TEXT | In Help Desk | Is this Ticket rendered in the Help Desk | tickets |
| tickets_hs_inbox_id | TEXT | Inbox ID | Inbox the ticket is in | tickets |
| tickets_hs_is_latest_message_failed | TEXT | Is latest message failed | Is latest message failed | tickets |
| tickets_hs_is_visible_in_help_desk | TEXT | Is Visible in Help desk | Whether the ticket is visible in help desk | tickets |
| tickets_hs_last_email_activity | TEXT | Last email activity | The type of the last email activity with the contact associated with the ticket. | tickets |
| tickets_hs_last_email_date | TIMESTAMP | Last email date | The date of the last email activity with the contact associated with the ticket. | tickets |
| tickets_hs_last_message_from_visitor | TIMESTAMP | Last message from visitor | Whether the last message came from visitor | tickets |
| tickets_hs_last_message_received_at | TIMESTAMP | Last message received date | The date of the last response from the visitor | tickets |
| tickets_hs_last_message_sent_at | TIMESTAMP | Last response date | The date of the last response from an agent or bot | tickets |
| tickets_hs_lastactivitydate | TIMESTAMP | Last activity date | The last time a note, call, email, meeting, or task was logged for a ticket. This is updated automatically by HubSpot. | tickets |
| tickets_hs_lastcontacted | TIMESTAMP | Last contacted date | The last time a call, chat conversation, LinkedIn message, postal mail, meeting, sales email, SMS, or WhatsApp message was logged for a ticket. This is set automatically by HubSpot based on user actions in the ticket record. | tickets |
| tickets_hs_lastmodifieddate | TIMESTAMP | Last modified date | Most recent timestamp of any property update for this ticket. This includes HubSpot internal properties, which can be visible or hidden. This property is updated automatically. | tickets |
| tickets_hs_latest_message_attachment_types | TEXT | Latest message attachment types | List of attachment types from the latest message | tickets |
| tickets_hs_latest_message_is_forwarded_email | TEXT | Latest message is forwarded email | Is latest message a forwarded email | tickets |
| tickets_hs_latest_message_is_thread_comment | TEXT | Latest message is thread comment | Is latest message a thread comment | tickets |
| tickets_hs_latest_message_seen_by_agent_ids | TEXT | Latest message seen by agent ids | Agents who have seen the newest message across all conversations associated to the ticket | tickets |
| tickets_hs_latest_message_text | TEXT | Latest Message Text | Latest message text (truncated) | tickets |
| tickets_hs_merged_object_ids | TEXT | Merged Ticket IDs | The list of Ticket record IDs that have been merged into this Ticket. This value is automatically set by HubSpot and may not be modified. | tickets |
| tickets_hs_most_relevant_sla_status | TEXT | Most relevant SLA status | Most relevant sla status | tickets |
| tickets_hs_most_relevant_sla_type | TEXT | Most Relevant SLA Type | Most relevant SLA type between Close By, First Response, Next Response | tickets |
| tickets_hs_msteams_message_id | TEXT | Microsoft Teams message ID for this ticket. | Microsoft Teams message ID for this ticket. | tickets |
| tickets_hs_nextactivitydate | TIMESTAMP | Next activity date | The date of the next upcoming activity for a ticket. This property is set automatically by HubSpot based on user action. This includes logging a future call, 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. | tickets |
| tickets_hs_notes_next_activity | TEXT | Next Activity | The coordinates of the next upcoming activity for a ticket. This is set automatically by HubSpot based on user actions in the ticket record. | tickets |
| tickets_hs_notes_next_activity_type | TEXT | Next Activity Type | The type of the next upcoming activity for a ticket. This property is set automatically by HubSpot based on user action. This includes logging a future call, 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. | tickets |
| tickets_hs_num_associated_companies | TEXT | Number of Associated Companies | Number of companies associated with this ticket | tickets |
| tickets_hs_num_associated_conversations | TEXT | Number of Associated Conversations | Number of conversations associated to the ticket | tickets |
| tickets_hs_num_times_contacted | TEXT | Number of times contacted | The number of times a call, email, or meeting was logged on the ticket | tickets |
| tickets_hs_object_id | TEXT | Record ID | The unique ID for this record. This value is automatically set by HubSpot and may not be modified. | tickets |
| tickets_hs_object_source | TEXT | Record Creation Source | Source (PropertySource) that created this object record | tickets |
| tickets_hs_object_source_detail_1 | TEXT | Record Source Detail 1 | First level of detail on how this record was created | tickets |
| tickets_hs_object_source_detail_2 | TEXT | Record Source Detail 2 | Second level of detail on how this record was created | tickets |
| tickets_hs_object_source_detail_3 | TEXT | Record Source Detail 3 | Third level of detail on how this record was created | tickets |
| tickets_hs_object_source_id | TEXT | Record Creation Source ID | The sourceId -- further detail -- of the source that created this object record | tickets |
| tickets_hs_object_source_label | TEXT | Record Source | How this record was created | tickets |
| tickets_hs_object_source_user_id | TEXT | Record Creation Source User ID | User ID of the user who initiated creation of this object record | tickets |
| tickets_hs_originating_channel_instance_id | TEXT | Originating channel account | First channel account used when conversation was started | tickets |
| tickets_hs_originating_email_engagement_id | TEXT | Originating email engagement id | Engagement id of the email originating this ticket | tickets |
| tickets_hs_originating_generic_channel_id | TEXT | Originating channel type | The channel the conversation is in | tickets |
| tickets_hs_pinned_engagement_id | TEXT | Pinned Engagement ID | The object ID of the current pinned engagement. This will only be shown if there is already an association to the engagement. | tickets |
| tickets_hs_pipeline | TEXT | Pipeline | The pipeline that contains this ticket | tickets |
| tickets_hs_pipeline_stage | TEXT | Ticket status | The pipeline stage that contains this ticket | tickets |
| tickets_hs_primary_company | TEXT | Primary Company | Primary company of a ticket | tickets |
| tickets_hs_primary_company_id | TEXT | Primary Company ID | Primary company ID of a ticket | tickets |
| tickets_hs_primary_company_name | TEXT | Primary Company Name | Primary company name of a ticket | tickets |
| tickets_hs_read_only | TEXT | Read Only Object | Is the object read only | tickets |
| tickets_hs_resolution | TEXT | Resolution | The action taken to resolve the ticket | tickets |
| tickets_hs_sales_email_last_replied | TEXT | Recent Sales Email Replied Date | The last time a tracked sales email was replied to for this ticket | tickets |
| tickets_hs_seen_by_agent_ids | TEXT | Users interaction | Stores a list of users who have viewed the most recent interaction on a ticket | tickets |
| tickets_hs_source_object_id | TEXT | Source Object ID | The ID of the object from which the data was migrated. This is set automatically during portal data migration. | tickets |
| tickets_hs_tag_ids | TEXT | Ticket Tags | List of tag ids applicable to a ticket. This property is set automatically by HubSpot. | tickets |
| tickets_hs_thread_ids_to_restore | TEXT | Thread IDs To Restore | Thread IDs (from cv-threads) used to implement custom cascading delete/restore | tickets |
| tickets_hs_ticket_category | TEXT | Tickets Hubspot Category | Main reason customer reached out for help | tickets |
| tickets_hs_ticket_id | TEXT | Ticket ID | The unique ID for this ticket. This unique ID is automatically populated by HubSpot and cannot be changed. | tickets |
| tickets_hs_ticket_priority | TEXT | Tickets Hubspot Priority | The level of attention needed on the ticket | tickets |
| tickets_hs_time_in_1 | TEXT | Time in 'New (Support Pipeline)' | The total time in seconds spent by the ticket in the 'New' stage, 'Support Pipeline' pipeline | tickets |
| tickets_hs_time_in_2 | TEXT | Time in 'Waiting on contact (Support Pipeline)' | The total time in seconds spent by the ticket in the 'Waiting on contact' stage, 'Support Pipeline' pipeline | tickets |
| tickets_hs_time_in_3 | TEXT | Time in 'Waiting on us (Support Pipeline)' | The total time in seconds spent by the ticket in the 'Waiting on us' stage, 'Support Pipeline' pipeline | tickets |
| tickets_hs_time_in_4 | TEXT | Time in 'Closed (Support Pipeline)' | The total time in seconds spent by the ticket in the 'Closed' stage, 'Support Pipeline' pipeline | tickets |
| tickets_hs_time_to_close_sla_at | TEXT | Time to Close SLA Due Date | When the ticket falls out of Time to Close SLA. | tickets |
| tickets_hs_time_to_close_sla_status | TEXT | Time to Close SLA Ticket Status | Current Time to Close SLA status of ticket | tickets |
| tickets_hs_time_to_first_response_sla_at | TIMESTAMP | Time to First Response SLA Due Date | When the ticket falls out of the Time to First Response SLA | tickets |
| tickets_hs_time_to_first_response_sla_status | TEXT | Time to First Response SLA Status | Current Time to First Response SLA status. | tickets |
| tickets_hs_time_to_next_response_sla_at | TIMESTAMP | Time to Next Response SLA Due Date | When the ticket falls out of Time to Next Response SLA | tickets |
| tickets_hs_time_to_next_response_sla_status | TEXT | Time to Next Response SLA Status | Current Time to Next Response SLA status | tickets |
| tickets_hs_unique_creation_key | TEXT | Unique creation key | Unique property used for idempotent creates | tickets |
| tickets_hs_updated_by_user_id | TEXT | Updated by user ID | The user that last updated this object. This value is automatically set by HubSpot and may not be modified. | tickets |
| tickets_hs_user_ids_of_all_notification_followers | TEXT | User IDs of all notification followers | The user IDs of all users that have clicked follow within the object to opt-in to getting follow notifications | tickets |
| tickets_hs_user_ids_of_all_notification_unfollowers | TEXT | User IDs of all notification unfollowers | The user IDs of all object owners that have clicked unfollow within the object to opt-out of getting follow notifications | tickets |
| tickets_hs_user_ids_of_all_owners | TEXT | User IDs of all owners | The user IDs of all owners of this object | tickets |
| tickets_hs_was_imported | TEXT | Performed in an import | Object is part of an import | tickets |
| tickets_hubspot_owner_assigneddate | TIMESTAMP | Owner assigned date | The date an owner was assigned to the ticket | tickets |
| tickets_hubspot_owner_id | TEXT | Ticket owner | The user from your team that the ticket is assigned to. You can assign additional users to a ticket record by creating a custom HubSpot user property. | tickets |
| tickets_hubspot_team_id | TEXT | HubSpot team | The Primary team of the ticket owner for the ticket. This property is set automatically by HubSpot. | tickets |
| tickets_last_engagement_date | TIMESTAMP | Date of last engagement | The date of the last reply or note | tickets |
| tickets_last_reply_date | TIMESTAMP | Last customer reply date | The date of the last customer response | tickets |
| tickets_notes_last_contacted | TEXT | Last Contacted (Ticket Note) | The last time a call, chat conversation, LinkedIn message, postal mail, meeting, note, sales email, SMS, or WhatsApp message was logged for a ticket. This is set automatically by HubSpot based on user actions in the ticket record. | tickets |
| tickets_notes_last_updated | TIMESTAMP | Last Activity Date (Ticket Note) | The last time a note, call, email, meeting, or task was logged for a ticket. This is set automatically by HubSpot based on user actions in the ticket record. | tickets |
| tickets_notes_next_activity_date | TIMESTAMP | Next Activity Date (Ticket Note) | The date of the next upcoming activity for this ticket | tickets |
| tickets_nps_follow_up_answer | TEXT | NPS follow up | Answer to NPS follow up question | tickets |
| tickets_nps_follow_up_question_version | TEXT | NPS follow up question | Specific version of NPS follow up question that was asked | tickets |
| tickets_nps_score | TEXT | Conversation NPS score | NPS score received after ticket resolution | tickets |
| tickets_num_contacted_notes | TEXT | Number of times contacted (Ticket Note) | The number of times a call, email or meeting was logged for this ticket | tickets |
| tickets_num_notes | TEXT | Number of Sales Activities | Number of sales activities for this ticket | tickets |
| tickets_source_ref | TEXT | Reference to source-specific object | The id of a connected source object | tickets |
| tickets_source_thread_id | TEXT | Reference to email thread | The id of an email thread with ticket conversation | tickets |
| tickets_source_type | TEXT | Tickets Source Type | Channel where ticket was originally submitted | tickets |
| tickets_subject | TEXT | Ticket name | Short summary of ticket | tickets |
| tickets_tags | TEXT | Tags | Tags associated with your tickets | tickets |
| tickets_time_to_close | TEXT | Time to close | The time between when the ticket was created and closed | tickets |
| tickets_time_to_first_agent_reply | TEXT | Time to first agent email reply | The time from the ticket create date to the first agent email reply | tickets |
| 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_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 |