Introduction

Datasources and destinations

Fields listing for Hubspot

Company About Us
Short about-company
Field IDcompanies.about_us
TypeTEXT
Data Typedimension
Company Facebook Fans
Number of facebook fans
Field IDcompanies.facebookfans
TypeNUMBER
Data Typedimension
Company First Conversion Date
The first conversion date across all contacts associated this company or organization
Field IDcompanies.first_conversion_date
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Company First Conversion
The first form submitted across all contacts associated this company or organization
Field IDcompanies.first_conversion_event_name
TypeTEXT
Data Typedimension
Company First Deal Created Date
Date the first deal was associated with this company record.
Field IDcompanies.first_deal_created_date
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Company Year Founded
The year the company was created. Powered by HubSpot Insights.
Field IDcompanies.founded_year
TypeTEXT
Data Typedimension
Company Additional Domains
Additional domains belonging to this company
Field IDcompanies.hs_additional_domains
TypeTEXT
Data Typedimension
Company Business units
The business units this record is assigned to.
Field IDcompanies.hs_all_assigned_business_unit_ids
TypeTEXT
Data Typedimension
Company Time First Seen
The first activity for any contact associated with this company or organization
Field IDcompanies.hs_analytics_first_timestamp
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Company First Touch Converting Campaign
The campaign responsible for the first touch creation of the first contact associated with this company
Field IDcompanies.hs_analytics_first_touch_converting_campaign
TypeTEXT
Data Typedimension
Company Time of First Session
Time of first session across all contacts associated with this company or organization
Field IDcompanies.hs_analytics_first_visit_timestamp
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Company Time Last Seen
Time last seen across all contacts associated with this company or organization
Field IDcompanies.hs_analytics_last_timestamp
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Company Last Touch Converting Campaign
The campaign responsible for the last touch creation of the first contact associated with this company
Field IDcompanies.hs_analytics_last_touch_converting_campaign
TypeTEXT
Data Typedimension
Company Time of Last Session
Time of the last session attributed to any contacts that are associated with this company record.
Field IDcompanies.hs_analytics_last_visit_timestamp
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Company Latest Source
Source of the last session attributed to any contacts that are associated with this company
Field IDcompanies.hs_analytics_latest_source
TypeTEXT
Data Typedimension
Company Latest Source Data 1
Additional source details of the last session attributed to any contacts that are associated with this company
Field IDcompanies.hs_analytics_latest_source_data_1
TypeTEXT
Data Typedimension
Company Latest Source Data 2
Additional source details of the last session attributed to any contacts that are associated with this company
Field IDcompanies.hs_analytics_latest_source_data_2
TypeTEXT
Data Typedimension
Company Latest Source Timestamp
Timestamp of when latest source occurred
Field IDcompanies.hs_analytics_latest_source_timestamp
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Company Number of Pageviews
Total number of page views across all contacts associated with this company or organization
Field IDcompanies.hs_analytics_num_page_views
TypeNUMBER
Data Typedimension
Company Number of Sessions
Total number of sessions across all contacts associated with this company or organization
Field IDcompanies.hs_analytics_num_visits
TypeNUMBER
Data Typedimension
Company Original Source Type
Original source for the contact with the earliest activity for this company or organization
Field IDcompanies.hs_analytics_source
TypeTEXT
Data Typedimension
Company Original Source Data 1
Additional information about the original source for the contact with the earliest activity for this company or organization
Field IDcompanies.hs_analytics_source_data_1
TypeTEXT
Data Typedimension
Company Original Source Data 2
Additional information about the original source for the contact with the earliest activity for this company or organization
Field IDcompanies.hs_analytics_source_data_2
TypeTEXT
Data Typedimension
Company Annual Revenue Currency Code
The currency code associated with the annual revenue amount
Field IDcompanies.hs_annual_revenue_currency_code
TypeTEXT
Data Typemetric
Company Avatar FileManager key
The path in the FileManager CDN for this company's avatar override image. Automatically set by HubSpot.
Field IDcompanies.hs_avatar_filemanager_key
TypeTEXT
Data Typedimension
Company Created by user ID
The user that created this object. This value is automatically set by HubSpot and may not be modified.
Field IDcompanies.hs_created_by_user_id
TypeNUMBER
Data Typedimension
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.
Field IDcompanies.hs_createdate
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Company Date entered 'Customer (Lifecycle Stage Pipeline)'
The date and time when the company entered the 'Customer' stage, 'Lifecycle Stage Pipeline' pipeline
Field IDcompanies.hs_date_entered_customer
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Company Date entered 'Evangelist (Lifecycle Stage Pipeline)'
The date and time when the company entered the 'Evangelist' stage, 'Lifecycle Stage Pipeline' pipeline
Field IDcompanies.hs_date_entered_evangelist
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Company Date entered 'Lead (Lifecycle Stage Pipeline)'
The date and time when the company entered the 'Lead' stage, 'Lifecycle Stage Pipeline' pipeline
Field IDcompanies.hs_date_entered_lead
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Company Date entered 'Marketing Qualified Lead (Lifecycle Stage Pipeline)'
The date and time when the company entered the 'Marketing Qualified Lead' stage, 'Lifecycle Stage Pipeline' pipeline
Field IDcompanies.hs_date_entered_marketingqualifiedlead
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Company Date entered 'Opportunity (Lifecycle Stage Pipeline)'
The date and time when the company entered the 'Opportunity' stage, 'Lifecycle Stage Pipeline' pipeline
Field IDcompanies.hs_date_entered_opportunity
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Company Date entered 'Other (Lifecycle Stage Pipeline)'
The date and time when the company entered the 'Other' stage, 'Lifecycle Stage Pipeline' pipeline
Field IDcompanies.hs_date_entered_other
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Company Date entered 'Sales Qualified Lead (Lifecycle Stage Pipeline)'
The date and time when the company entered the 'Sales Qualified Lead' stage, 'Lifecycle Stage Pipeline' pipeline
Field IDcompanies.hs_date_entered_salesqualifiedlead
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Company Date entered 'Subscriber (Lifecycle Stage Pipeline)'
The date and time when the company entered the 'Subscriber' stage, 'Lifecycle Stage Pipeline' pipeline
Field IDcompanies.hs_date_entered_subscriber
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Company Date exited 'Customer (Lifecycle Stage Pipeline)'
The date and time when the company exited the 'Customer' stage, 'Lifecycle Stage Pipeline' pipeline
Field IDcompanies.hs_date_exited_customer
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Company Date exited 'Evangelist (Lifecycle Stage Pipeline)'
The date and time when the company exited the 'Evangelist' stage, 'Lifecycle Stage Pipeline' pipeline
Field IDcompanies.hs_date_exited_evangelist
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Company Date exited 'Lead (Lifecycle Stage Pipeline)'
The date and time when the company exited the 'Lead' stage, 'Lifecycle Stage Pipeline' pipeline
Field IDcompanies.hs_date_exited_lead
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Company Date exited 'Marketing Qualified Lead (Lifecycle Stage Pipeline)'
The date and time when the company exited the 'Marketing Qualified Lead' stage, 'Lifecycle Stage Pipeline' pipeline
Field IDcompanies.hs_date_exited_marketingqualifiedlead
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Company Date exited 'Opportunity (Lifecycle Stage Pipeline)'
The date and time when the company exited the 'Opportunity' stage, 'Lifecycle Stage Pipeline' pipeline
Field IDcompanies.hs_date_exited_opportunity
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Company Date exited 'Other (Lifecycle Stage Pipeline)'
The date and time when the company exited the 'Other' stage, 'Lifecycle Stage Pipeline' pipeline
Field IDcompanies.hs_date_exited_other
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Company Date exited 'Sales Qualified Lead (Lifecycle Stage Pipeline)'
The date and time when the company exited the 'Sales Qualified Lead' stage, 'Lifecycle Stage Pipeline' pipeline
Field IDcompanies.hs_date_exited_salesqualifiedlead
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Company Date exited 'Subscriber (Lifecycle Stage Pipeline)'
The date and time when the company exited the 'Subscriber' stage, 'Lifecycle Stage Pipeline' pipeline
Field IDcompanies.hs_date_exited_subscriber
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Company Ideal Customer Profile Tier
How well this company matches your Ideal Customer Profile. Tier 1 means a great fit for your products/services, Tier 3 might be acceptable, but low priority.
Field IDcompanies.hs_ideal_customer_profile
TypeTEXT
Data Typedimension
Is Company Target Account
Identifies whether this company is being marketed and sold to as part of your account-based strategy.
Field IDcompanies.hs_is_target_account
TypeBOOLEAN
Data Typedimension
Company Last Booked Meeting Date
The last date of booked meetings associated with the company
Field IDcompanies.hs_last_booked_meeting_date
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Company Last Logged Call Date
The last date of logged calls associated with the company
Field IDcompanies.hs_last_logged_call_date
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Company Last Open Task Date
The last due date of open tasks associated with the company
Field IDcompanies.hs_last_open_task_date
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Company last sales activity date old
The date of the last sales activity with the company in seconds.
Field IDcompanies.hs_last_sales_activity_date
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
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.
Field IDcompanies.hs_last_sales_activity_timestamp
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Company Last Engagement Type
The type of the last engagement a company performed. This doesn't include marketing emails or emails to multiple contacts.
Field IDcompanies.hs_last_sales_activity_type
TypeTEXT
Data Typedimension
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.
Field IDcompanies.hs_lastmodifieddate
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Company Latest create date of active subscriptions
Latest created date of all associated active Subscriptions
Field IDcompanies.hs_latest_createdate_of_active_subscriptions
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Merged Company IDs
The list of Company record IDs that have been merged into this Company. This value is automatically set by HubSpot and may not be modified.
Field IDcompanies.hs_merged_object_ids
TypeTEXT
Data Typedimension
Company Number of blockers
The number of contacts associated with this company with the role of blocker.
Field IDcompanies.hs_num_blockers
TypeNUMBER
Data Typedimension
Company Number of contacts with a buying role
The number of contacts associated with this company with a buying role.
Field IDcompanies.hs_num_contacts_with_buying_roles
TypeNUMBER
Data Typedimension
Company Number of decision makers
The number of contacts associated with this company with the role of decision maker.
Field IDcompanies.hs_num_decision_makers
TypeNUMBER
Data Typedimension
Company Number of open deals
The number of open deals associated with this company.
Field IDcompanies.hs_num_open_deals
TypeNUMBER
Data Typedimension
Company Record ID
The unique ID for this record. This value is automatically set by HubSpot and may not be modified.
Field IDcompanies.hs_object_id
TypeNUMBER
Data Typedimension
Company Record Creation Source
Source (PropertySource) that created this object record
Field IDcompanies.hs_object_source
TypeTEXT
Data Typedimension
Company Record Creation Source ID
The sourceId -- further detail -- of the source that created this object record
Field IDcompanies.hs_object_source_id
TypeTEXT
Data Typedimension
Company Record Source
How this record was created
Field IDcompanies.hs_object_source_label
TypeTEXT
Data Typedimension
Company Record Creation Source User ID
User ID of the user who initiated creation of this object record
Field IDcompanies.hs_object_source_user_id
TypeNUMBER
Data Typedimension
Company Pinned Engagement ID
The object ID of the current pinned engagement. This value is automatically set by HubSpot and may not be modified.
Field IDcompanies.hs_pinned_engagement_id
TypeNUMBER
Data Typedimension
Company Pipeline
The pipeline with which this company is currently associated
Field IDcompanies.hs_pipeline
TypeTEXT
Data Typedimension
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.
Field IDcompanies.hs_predictivecontactscore_v2
TypeNUMBER
Data Typedimension
Company Read Only Object
Is the object read only
Field IDcompanies.hs_read_only
TypeBOOLEAN
Data Typedimension
Company Source Object ID
The ID of the object from which the data was migrated. This is set automatically during portal data migration.
Field IDcompanies.hs_source_object_id
TypeNUMBER
Data Typedimension
Company Target Account
The Target Account property is a means to flag high priority companies if you are following an account based strategy
Field IDcompanies.hs_target_account
TypeTEXT
Data Typedimension
Company Target Account Probability
The probability a company is marked as a target account
Field IDcompanies.hs_target_account_probability
TypeNUMBER
Data Typedimension
Company Target Account Recommendation Snooze Time
The date when the target account recommendation is snoozed.
Field IDcompanies.hs_target_account_recommendation_snooze_time
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Company Target Account Recommendation State
The state of the target account recommendation
Field IDcompanies.hs_target_account_recommendation_state
TypeTEXT
Data Typedimension
Company Time in 'Customer (Lifecycle Stage Pipeline)'
The total time in seconds spent by the company in the 'Customer' stage, 'Lifecycle Stage Pipeline' pipeline
Field IDcompanies.hs_time_in_customer
TypeNUMBER
Data Typedimension
Company Time in 'Evangelist (Lifecycle Stage Pipeline)'
The total time in seconds spent by the company in the 'Evangelist' stage, 'Lifecycle Stage Pipeline' pipeline
Field IDcompanies.hs_time_in_evangelist
TypeNUMBER
Data Typedimension
Company Time in 'Lead (Lifecycle Stage Pipeline)'
The total time in seconds spent by the company in the 'Lead' stage, 'Lifecycle Stage Pipeline' pipeline
Field IDcompanies.hs_time_in_lead
TypeNUMBER
Data Typedimension
Company Time in 'Marketing Qualified Lead (Lifecycle Stage Pipeline)'
The total time in seconds spent by the company in the 'Marketing Qualified Lead' stage, 'Lifecycle Stage Pipeline' pipeline
Field IDcompanies.hs_time_in_marketingqualifiedlead
TypeNUMBER
Data Typedimension
Company Time in 'Opportunity (Lifecycle Stage Pipeline)'
The total time in seconds spent by the company in the 'Opportunity' stage, 'Lifecycle Stage Pipeline' pipeline
Field IDcompanies.hs_time_in_opportunity
TypeNUMBER
Data Typedimension
Company Time in 'Other (Lifecycle Stage Pipeline)'
The total time in seconds spent by the company in the 'Other' stage, 'Lifecycle Stage Pipeline' pipeline
Field IDcompanies.hs_time_in_other
TypeNUMBER
Data Typedimension
Company Time in 'Sales Qualified Lead (Lifecycle Stage Pipeline)'
The total time in seconds spent by the company in the 'Sales Qualified Lead' stage, 'Lifecycle Stage Pipeline' pipeline
Field IDcompanies.hs_time_in_salesqualifiedlead
TypeNUMBER
Data Typedimension
Company Time in 'Subscriber (Lifecycle Stage Pipeline)'
The total time in seconds spent by the company in the 'Subscriber' stage, 'Lifecycle Stage Pipeline' pipeline
Field IDcompanies.hs_time_in_subscriber
TypeNUMBER
Data Typedimension
Company Total open deal value
The total value, in your company's currency, of all open deals associated with this company
Field IDcompanies.hs_total_deal_value
TypeNUMBER
Data Typedimension
Company Unique creation key
Unique property used for idempotent creates
Field IDcompanies.hs_unique_creation_key
TypeTEXT
Data Typedimension
Company Updated by user ID
The user that last updated this object. This value is automatically set by HubSpot and may not be modified.
Field IDcompanies.hs_updated_by_user_id
TypeNUMBER
Data Typedimension
Company 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
Field IDcompanies.hs_user_ids_of_all_notification_followers
TypeTEXT
Data Typedimension
Company 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
Field IDcompanies.hs_user_ids_of_all_notification_unfollowers
TypeTEXT
Data Typedimension
Company User IDs of all owners
The user IDs of all owners of this object
Field IDcompanies.hs_user_ids_of_all_owners
TypeTEXT
Data Typedimension
Company Performed in an import
Object is part of an import
Field IDcompanies.hs_was_imported
TypeBOOLEAN
Data Typedimension
Company Owner Assigned Date
The timestamp when an owner was assigned to this company
Field IDcompanies.hubspot_owner_assigneddate
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Company Is Public
Indicates if the company is publicly traded. Powered by HubSpot Insights.
Field IDcompanies.is_public
TypeBOOLEAN
Data Typedimension
Company Number of Associated Contacts
The number of contacts associated with this company
Field IDcompanies.num_associated_contacts
TypeNUMBER
Data Typedimension
Company Number of Associated Deals
The number of deals associated with this company
Field IDcompanies.num_associated_deals
TypeNUMBER
Data Typedimension
Company Number of Form Submissions
The number of forms submission for all contacts associated with this company or organization
Field IDcompanies.num_conversion_events
TypeNUMBER
Data Typedimension
Company Recent Conversion Date
The most recent conversion date across all contacts associated this company or organization
Field IDcompanies.recent_conversion_date
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Company Recent Conversion
The last form submitted across all contacts associated this company or organization
Field IDcompanies.recent_conversion_event_name
TypeTEXT
Data Typedimension
Company Recent Deal Amount
Amount of last closed won deal associated with this company. Set automatically.
Field IDcompanies.recent_deal_amount
TypeNUMBER
Data Typedimension
Company Recent Deal Close Date
Date of the last "closed won" deal associated with this company record.
Field IDcompanies.recent_deal_close_date
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Company Time Zone
Time zone where the company or organization is located. Powered by HubSpot Insights.
Field IDcompanies.timezone
TypeTEXT
Data Typedimension
Company Total Money Raised
The total amount of money raised by the company. Powered by HubSpot Insights.
Field IDcompanies.total_money_raised
TypeTEXT
Data Typedimension
Company Total Revenue
The total amount of closed won deals
Field IDcompanies.total_revenue
TypeNUMBER
Data Typedimension
Company name
The name of the company or organization. Powered by HubSpot Insights.
Field IDcompanies.name
TypeTEXT
Data Typedimension
Company HubSpot Owner Email
HubSpot owner email for this company or organization
Field IDcompanies.owneremail
TypeTEXT
Data Typedimension
Company Twitter Handle
The main twitter account of the company or organization
Field IDcompanies.twitterhandle
TypeTEXT
Data Typedimension
Company HubSpot Owner Name
HubSpot owner name for this company or organization
Field IDcompanies.ownername
TypeTEXT
Data Typedimension
Company Phone Number
Company primary phone number. Powered by HubSpot Insights.
Field IDcompanies.phone
TypeTEXT
Data Typedimension
Company Twitter Bio
The Twitter bio of the company or organization
Field IDcompanies.twitterbio
TypeTEXT
Data Typedimension
Company Twitter Followers
The number of Twitter followers of the company or organization
Field IDcompanies.twitterfollowers
TypeNUMBER
Data Typedimension
Company Street Address
Street address of the company or organization, including unit number. Powered by HubSpot Insights.
Field IDcompanies.address
TypeTEXT
Data Typedimension
Company Street Address 2
Additional address of the company or organization. Powered by HubSpot Insights.
Field IDcompanies.address2
TypeTEXT
Data Typedimension
Facebook Company Page
The URL of the Facebook company page for the company or organization
Field IDcompanies.facebook_company_page
TypeTEXT
Data Typedimension
Company City
City where the company is located. Powered by HubSpot Insights.
Field IDcompanies.city
TypeTEXT
Data Typedimension
LinkedIn Company Page
The URL of the LinkedIn company page for the company or organization
Field IDcompanies.linkedin_company_page
TypeTEXT
Data Typedimension
Company LinkedIn Bio
The LinkedIn bio for the company or organization
Field IDcompanies.linkedinbio
TypeTEXT
Data Typedimension
Company State/Region
State or region in which the company or organization is located. Powered by HubSpot Insights.
Field IDcompanies.state
TypeTEXT
Data Typedimension
Company Google Plus Page
The URL of the Google Plus page for the company or organization
Field IDcompanies.googleplus_page
TypeTEXT
Data Typedimension
Company Date of last meeting booked in meetings tool
Last Meeting Booked for any contact associated with this Company/Organization.
Field IDcompanies.engagements_last_meeting_booked
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
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.
Field IDcompanies.engagements_last_meeting_booked_campaign
TypeTEXT
Data Typedimension
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.
Field IDcompanies.engagements_last_meeting_booked_medium
TypeTEXT
Data Typedimension
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.
Field IDcompanies.engagements_last_meeting_booked_source
TypeTEXT
Data Typedimension
Company Latest meeting activity
The date of the most recent meeting (past or upcoming) logged for, scheduled with, or booked by a contact associated with this company.
Field IDcompanies.hs_latest_meeting_activity
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Company Recent Sales Email Replied Date
The last time a tracked sales email was replied to by this company
Field IDcompanies.hs_sales_email_last_replied
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Company owner
The owner of the company
Field IDcompanies.hubspot_owner_id
TypeTEXT
Data Typedimension
Company Last Contacted
The last time a call, chat conversation, LinkedIn message, postal mail, meeting, sales email, SMS, or WhatsApp message was logged for a company. This is set automatically by HubSpot based on user actions in the company record.
Field IDcompanies.notes_last_contacted
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Company Last Activity Date
The last time a call, chat conversation, LinkedIn message, postal mail, meeting, note, sales email, SMS, or WhatsApp message was logged for a company. This is set automatically by HubSpot based on user actions in the company record.
Field IDcompanies.notes_last_updated
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Company Next Activity Date
Date of the next upcoming scheduled sales activity for this company record.
Field IDcompanies.notes_next_activity_date
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Company Number of times contacted
The number of times a call, chat conversation, LinkedIn message, postal mail, meeting, sales email, SMS, or WhatsApp message was logged for a company record. This is set automatically by HubSpot based on user actions in the company record.
Field IDcompanies.num_contacted_notes
TypeNUMBER
Data Typedimension
Company Number of Sales Activities
The number of times a call, chat conversation, LinkedIn message, postal mail, meeting, note, sales email, SMS, task, or WhatsApp message was logged for a company record. This is set automatically by HubSpot based on user actions in the company record.
Field IDcompanies.num_notes
TypeNUMBER
Data Typedimension
Company Postal Code
Postal or zip code of the company or organization. Powered by HubSpot Insights.
Field IDcompanies.zip
TypeTEXT
Data Typedimension
Company Country/Region
Country in which the company or organization is located. Powered by HubSpot Insights.
Field IDcompanies.country
TypeTEXT
Data Typedimension
Company HubSpot Team
The team of the owner of the company.
Field IDcompanies.hubspot_team_id
TypeTEXT
Data Typedimension
Company All owner ids
The value of all owner referencing properties for this object, both default and custom
Field IDcompanies.hs_all_owner_ids
TypeTEXT
Data Typedimension
Company Website URL
The main website of the company or organization. This property is used to identify unique companies. Powered by HubSpot Insights.
Field IDcompanies.website
TypeTEXT
Data Typedimension
Company Domain Name
The domain name of the company or organization
Field IDcompanies.domain
TypeTEXT
Data Typedimension
Company All team ids
The team ids corresponding to all owner referencing properties for this object, both default and custom
Field IDcompanies.hs_all_team_ids
TypeTEXT
Data Typedimension
Company All teams
The team ids, including up the team hierarchy, corresponding to all owner referencing properties for this object, both default and custom
Field IDcompanies.hs_all_accessible_team_ids
TypeTEXT
Data Typedimension
Company Number of Employees
The total number of employees who work for the company or organization. Powered by HubSpot Insights.
Field IDcompanies.numberofemployees
TypeNUMBER
Data Typedimension
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.
Field IDcompanies.industry
TypeTEXT
Data Typedimension
Company Annual Revenue
The actual or estimated annual revenue of the company. Powered by HubSpot Insights.
Field IDcompanies.annualrevenue
TypeNUMBER
Data Typedimension
Company Lifecycle Stage
The qualification of companies to sales readiness throughout the buying journey
Field IDcompanies.lifecyclestage
TypeTEXT
Data Typedimension
Company Lead Status
The company's sales, prospecting or outreach status
Field IDcompanies.hs_lead_status
TypeTEXT
Data Typedimension
Parent Company
The parent company of this company
Field IDcompanies.hs_parent_company_id
TypeNUMBER
Data Typedimension
Company Type
The optional classification of this company record - prospect, partner, etc.
Field IDcompanies.type
TypeTEXT
Data Typedimension
Company Description
A short statement about the company's mission and goals. Powered by HubSpot Insights.
Field IDcompanies.description
TypeTEXT
Data Typedimension
Company Number of child companies
The number of child companies of this company
Field IDcompanies.hs_num_child_companies
TypeNUMBER
Data Typedimension
Company HubSpot Score
The sales and marketing score for the company or organization
Field IDcompanies.hubspotscore
TypeNUMBER
Data Typedimension
Company Create Date
The date the company or organization was added to the database
Field IDcompanies.createdate
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Company Close Date
The date the company or organization was closed as a customer
Field IDcompanies.closedate
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
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
Field IDcompanies.first_contact_createdate
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Company Days to Close
The number of days between when the company record was created and when they closed as a customer.
Field IDcompanies.days_to_close
TypeNUMBER
Data Typemetric
Company Web Technologies
The web technologies used by the company or organization. Powered by HubSpot Insights.
Field IDcompanies.web_technologies
TypeTEXT
Data Typedimension
Contact Company size
Contact's company size. Required for the Facebook Ads Integration. Automatically synced from the Lead Ads tool.
Field IDcontacts.company_size
TypeTEXT
Data Typedimension
Contact Date of birth
Contact's date of birth. Required for the Facebook Ads Integration. Automatically synced from the Lead Ads tool.
Field IDcontacts.date_of_birth
TypeTEXT
Data Typedimension
Contact Days To Close
Count of days elapsed between creation and being closed as a customer. Set automatically.
Field IDcontacts.days_to_close
TypeNUMBER
Data Typemetric
Contact Degree
Contact's degree. Required for the Facebook Ads Integration. Automatically synced from the Lead Ads tool.
Field IDcontacts.degree
TypeTEXT
Data Typedimension
Contact Field of study
Contact's field of study. Required for the Facebook Ads Integration. Automatically synced from the Lead Ads tool.
Field IDcontacts.field_of_study
TypeTEXT
Data Typedimension
Contact First Conversion Date
Date this contact first submitted a form.
Field IDcontacts.first_conversion_date
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Contact First Conversion
First form this contact submitted.
Field IDcontacts.first_conversion_event_name
TypeTEXT
Data Typedimension
Contact First Deal Created Date
Date first deal was created for contact. Set automatically.
Field IDcontacts.first_deal_created_date
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Contact Gender
Contact's gender. Required for the Facebook Ads Integration. Automatically synced from the Lead Ads tool.
Field IDcontacts.gender
TypeTEXT
Data Typedimension
Contact Graduation date
Contact's graduation date. Required for the Facebook Ads Integration. Automatically synced from the Lead Ads tool.
Field IDcontacts.graduation_date
TypeTEXT
Data Typedimension
Contact Additional email addresses
A set of additional email addresses for a contact
Field IDcontacts.hs_additional_emails
TypeTEXT
Data Typedimension
Contact Business units
The business units this record is assigned to.
Field IDcontacts.hs_all_assigned_business_unit_ids
TypeTEXT
Data Typedimension
All vids for a contact
A set of all vids, canonical or otherwise, for a contact
Field IDcontacts.hs_all_contact_vids
TypeTEXT
Data Typedimension
Contact First Touch Converting Campaign
Campaign responsible for the first touch creation of this contact.
Field IDcontacts.hs_analytics_first_touch_converting_campaign
TypeTEXT
Data Typedimension
Contact Last Touch Converting Campaign
Campaign responsible for the last touch creation of this contact.
Field IDcontacts.hs_analytics_last_touch_converting_campaign
TypeTEXT
Data Typedimension
Contact Avatar FileManager key
The path in the FileManager CDN for this contact's avatar override image. Automatically set by HubSpot.
Field IDcontacts.hs_avatar_filemanager_key
TypeTEXT
Data Typedimension
Contact Buying Role
Role the contact plays during the sales process. Contacts can have multiple roles, and can share roles with others.
Field IDcontacts.hs_buying_role
TypeTEXT
Data Typedimension
All form submissions for a contact
A set of all form submissions for a contact
Field IDcontacts.hs_calculated_form_submissions
TypeTEXT
Data Typedimension
Merged vids with timestamps of a contact
Merged vids with timestamps of a contact
Field IDcontacts.hs_calculated_merged_vids
TypeTEXT
Data Typedimension
Contact Calculated Mobile Number in International Format
Mobile number in international format
Field IDcontacts.hs_calculated_mobile_number
TypeTEXT
Data Typedimension
Contact Calculated Phone Number in International Format
Phone number in international format
Field IDcontacts.hs_calculated_phone_number
TypeTEXT
Data Typedimension
Contact Calculated Phone Number Area Code
Area Code of the calculated phone number
Field IDcontacts.hs_calculated_phone_number_area_code
TypeTEXT
Data Typedimension
Contact Calculated Phone Number Country Code
Country code of the calculated phone number
Field IDcontacts.hs_calculated_phone_number_country_code
TypeTEXT
Data Typedimension
Contact Calculated Phone Number Region
ISO2 Country code for the derived phone number
Field IDcontacts.hs_calculated_phone_number_region_code
TypeTEXT
Data Typedimension
Contact Clicked on a LinkedIn Ad
Whether contact has clicked on a LinkedIn Ad
Field IDcontacts.hs_clicked_linkedin_ad
TypeTEXT
Data Typedimension
Contact Member email
Email used to send private content information to members
Field IDcontacts.hs_content_membership_email
TypeTEXT
Data Typedimension
Contact Email Confirmed
Email Confirmation status of user of Content Membership
Field IDcontacts.hs_content_membership_email_confirmed
TypeBOOLEAN
Data Typedimension
Contact Time enrolled in registration follow up emails
The time when the contact was first enrolled in the registration follow up email flow
Field IDcontacts.hs_content_membership_follow_up_enqueued_at
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Contact Membership Notes
Notes relating to the contact's content membership.
Field IDcontacts.hs_content_membership_notes
TypeTEXT
Data Typedimension
Contact Registered At
Datetime at which this user was set up for Content Membership
Field IDcontacts.hs_content_membership_registered_at
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Contact Domain to which registration email was sent
Domain to which the registration invitation email for Content Membership was sent to
Field IDcontacts.hs_content_membership_registration_domain_sent_to
TypeTEXT
Data Typedimension
Contact Time registration email was sent
Datetime at which this user was sent a registration invitation email for Content Membership
Field IDcontacts.hs_content_membership_registration_email_sent_at
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Contact Status
Status of the contact's content membership.
Field IDcontacts.hs_content_membership_status
TypeTEXT
Data Typedimension
Contact Conversations visitor email
A Conversations visitor's email address
Field IDcontacts.hs_conversations_visitor_email
TypeTEXT
Data Typedimension
Count of unengaged contacts
if contact is assigned and unworked, set to 1. if contact is assigned and worked, set to 0.
Field IDcontacts.hs_count_is_unworked
TypeNUMBER
Data Typemetric
Count of engaged contacts
if contact is assigned and worked, set to 1. if contact is assigned and unworked, set to 0.
Field IDcontacts.hs_count_is_worked
TypeNUMBER
Data Typemetric
Contact Created By Conversations
Flag indicating this contact was created by the Conversations API
Field IDcontacts.hs_created_by_conversations
TypeBOOLEAN
Data Typedimension
Contact Created by user ID
The user that created this object. This value is automatically set by HubSpot and may not be modified.
Field IDcontacts.hs_created_by_user_id
TypeNUMBER
Data Typedimension
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.
Field IDcontacts.hs_createdate
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Contact Ads Consent from Forms
This property captures ads consents from forms and is used by consentmanager to create / update associated data privacy consent objects
Field IDcontacts.hs_data_privacy_ads_consent
TypeBOOLEAN
Data Typedimension
Contact Date entered 'Customer (Lifecycle Stage Pipeline)'
The date and time when the contact entered the 'Customer' stage, 'Lifecycle Stage Pipeline' pipeline
Field IDcontacts.hs_date_entered_customer
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Contact Date entered 'Evangelist (Lifecycle Stage Pipeline)'
The date and time when the contact entered the 'Evangelist' stage, 'Lifecycle Stage Pipeline' pipeline
Field IDcontacts.hs_date_entered_evangelist
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Contact Date entered 'Lead (Lifecycle Stage Pipeline)'
The date and time when the contact entered the 'Lead' stage, 'Lifecycle Stage Pipeline' pipeline
Field IDcontacts.hs_date_entered_lead
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Contact Date entered 'Marketing Qualified Lead (Lifecycle Stage Pipeline)'
The date and time when the contact entered the 'Marketing Qualified Lead' stage, 'Lifecycle Stage Pipeline' pipeline
Field IDcontacts.hs_date_entered_marketingqualifiedlead
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Contact Date entered 'Opportunity (Lifecycle Stage Pipeline)'
The date and time when the contact entered the 'Opportunity' stage, 'Lifecycle Stage Pipeline' pipeline
Field IDcontacts.hs_date_entered_opportunity
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Contact Date entered 'Other (Lifecycle Stage Pipeline)'
The date and time when the contact entered the 'Other' stage, 'Lifecycle Stage Pipeline' pipeline
Field IDcontacts.hs_date_entered_other
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Contact Date entered 'Sales Qualified Lead (Lifecycle Stage Pipeline)'
The date and time when the contact entered the 'Sales Qualified Lead' stage, 'Lifecycle Stage Pipeline' pipeline
Field IDcontacts.hs_date_entered_salesqualifiedlead
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Contact Date entered 'Subscriber (Lifecycle Stage Pipeline)'
The date and time when the contact entered the 'Subscriber' stage, 'Lifecycle Stage Pipeline' pipeline
Field IDcontacts.hs_date_entered_subscriber
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Contact Date exited 'Customer (Lifecycle Stage Pipeline)'
The date and time when the contact exited the 'Customer' stage, 'Lifecycle Stage Pipeline' pipeline
Field IDcontacts.hs_date_exited_customer
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Contact Date exited 'Evangelist (Lifecycle Stage Pipeline)'
The date and time when the contact exited the 'Evangelist' stage, 'Lifecycle Stage Pipeline' pipeline
Field IDcontacts.hs_date_exited_evangelist
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Contact Date exited 'Lead (Lifecycle Stage Pipeline)'
The date and time when the contact exited the 'Lead' stage, 'Lifecycle Stage Pipeline' pipeline
Field IDcontacts.hs_date_exited_lead
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Contact Date exited 'Marketing Qualified Lead (Lifecycle Stage Pipeline)'
The date and time when the contact exited the 'Marketing Qualified Lead' stage, 'Lifecycle Stage Pipeline' pipeline
Field IDcontacts.hs_date_exited_marketingqualifiedlead
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Contact Date exited 'Opportunity (Lifecycle Stage Pipeline)'
The date and time when the contact exited the 'Opportunity' stage, 'Lifecycle Stage Pipeline' pipeline
Field IDcontacts.hs_date_exited_opportunity
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Contact Date exited 'Other (Lifecycle Stage Pipeline)'
The date and time when the contact exited the 'Other' stage, 'Lifecycle Stage Pipeline' pipeline
Field IDcontacts.hs_date_exited_other
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Contact Date exited 'Sales Qualified Lead (Lifecycle Stage Pipeline)'
The date and time when the contact exited the 'Sales Qualified Lead' stage, 'Lifecycle Stage Pipeline' pipeline
Field IDcontacts.hs_date_exited_salesqualifiedlead
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Contact Date exited 'Subscriber (Lifecycle Stage Pipeline)'
The date and time when the contact exited the 'Subscriber' stage, 'Lifecycle Stage Pipeline' pipeline
Field IDcontacts.hs_date_exited_subscriber
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Contact Recent Document Revisit Date
The last time a shared document (presentation) was accessed by this contact
Field IDcontacts.hs_document_last_revisited
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Contact Invalid email address
The email address associated with this contact is invalid.
Field IDcontacts.hs_email_bad_address
TypeBOOLEAN
Data Typedimension
Contact Email address quarantine reason
The reason why the email address has been quarantined.
Field IDcontacts.hs_email_customer_quarantined_reason
TypeTEXT
Data Typedimension
Contact Email Domain
A contact's email address domain
Field IDcontacts.hs_email_domain
TypeTEXT
Data Typedimension
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.
Field IDcontacts.hs_email_hard_bounce_reason
TypeTEXT
Data Typedimension
Contact Email hard bounce reason enum
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.
Field IDcontacts.hs_email_hard_bounce_reason_enum
TypeTEXT
Data Typedimension
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.
Field IDcontacts.hs_email_quarantined
TypeBOOLEAN
Data Typedimension
Contact Email address automated quarantine reason
The automated reason why the email address has been quarantined.
Field IDcontacts.hs_email_quarantined_reason
TypeTEXT
Data Typedimension
Contact Email Address Recipient Fatigue Next Available Sending Time
When this recipient has reached the limit of email sends per time period, this property indicates the next available time to send. This is automatically set by HubSpot.
Field IDcontacts.hs_email_recipient_fatigue_recovery_time
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
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.
Field IDcontacts.hs_email_sends_since_last_engagement
TypeNUMBER
Data Typedimension
Contact Marketing email confirmation status
The status of a contact's eligibility to receive marketing email. This is automatically set by HubSpot.
Field IDcontacts.hs_emailconfirmationstatus
TypeTEXT
Data Typedimension
Contact Clicked Facebook ad
Whether contact has clicked a Facebook ad
Field IDcontacts.hs_facebook_ad_clicked
TypeBOOLEAN
Data Typedimension
Contact Facebook click id
Field IDcontacts.hs_facebook_click_id
TypeTEXT
Data Typedimension
Contact Facebook ID
A contact's facebook id
Field IDcontacts.hs_facebookid
TypeTEXT
Data Typedimension
Contact Last NPS survey comment
Last NPS survey comment that this contact gave
Field IDcontacts.hs_feedback_last_nps_follow_up
TypeTEXT
Data Typedimension
Contact Last NPS survey rating
Last NPS survey rating that this contact gave
Field IDcontacts.hs_feedback_last_nps_rating
TypeTEXT
Data Typedimension
Contact Last NPS survey date
The time that this contact last submitted a NPS survey response. This is automatically set by HubSpot.
Field IDcontacts.hs_feedback_last_survey_date
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Contact Should be shown an NPS web survey
Whether or not a contact should be shown an NPS web survey. This is automatically set by HubSpot.
Field IDcontacts.hs_feedback_show_nps_web_survey
TypeBOOLEAN
Data Typedimension
Contact ID of first engagement
The object id of the current contact owner's first engagement with the contact. Used in Sales Analytics app.
Field IDcontacts.hs_first_engagement_object_id
TypeNUMBER
Data Typedimension
Contact First outreach date
The date of the first outreach (call, email, meeting or other communication) from a sales rep to the contact.
Field IDcontacts.hs_first_outreach_date
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Contact First subscription create date
The create date of the first subscription by the contact.
Field IDcontacts.hs_first_subscription_create_date
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Contact Google ad click id
Field IDcontacts.hs_google_click_id
TypeTEXT
Data Typedimension
Contact googleplus ID
A contact's googleplus id
Field IDcontacts.hs_googleplusid
TypeTEXT
Data Typedimension
Contact has an active subscription
The rollup property value is 1 when the contact has an active Subscription or 0 otherwise.
Field IDcontacts.hs_has_active_subscription
TypeNUMBER
Data Typedimension
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.
Field IDcontacts.hs_ip_timezone
TypeTEXT
Data Typedimension
Is a contact
Is a contact, has not been deleted and is not a visitor
Field IDcontacts.hs_is_contact
TypeBOOLEAN
Data Typedimension
Contact unworked
Contact has not been assigned or has not been engaged after last owner assignment/re-assignment
Field IDcontacts.hs_is_unworked
TypeBOOLEAN
Data Typemetric
Contact last sales activity date old
The date of the last sales activity with the contact. This property is set automatically by HubSpot. Note: This field is only updated for contacts with an owner.
Field IDcontacts.hs_last_sales_activity_date
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
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.
Field IDcontacts.hs_last_sales_activity_timestamp
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Contact Last Engagement Type
The type of the last engagement a contact performed. This doesn't include marketing emails or emails to multiple contacts.
Field IDcontacts.hs_last_sales_activity_type
TypeTEXT
Data Typedimension
Contact Object last modified date/time
Most recent timestamp of any property update for this contact. This includes HubSpot internal properties, which can be visible or hidden. This property is updated automatically.
Field IDcontacts.hs_lastmodifieddate
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Contact Last sequence ended date
The last sequence ended date.
Field IDcontacts.hs_latest_sequence_ended_date
TypeYEAR_MONTH_DAY_SECOND
Data Typemetric
Contact Last sequence enrolled
The last sequence enrolled.
Field IDcontacts.hs_latest_sequence_enrolled
TypeNUMBER
Data Typedimension
Contact Last sequence enrolled date
The last sequence enrolled date.
Field IDcontacts.hs_latest_sequence_enrolled_date
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Contact Last sequence finished date
The last sequence finished date.
Field IDcontacts.hs_latest_sequence_finished_date
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Contact Last sequence unenrolled date
The last sequence unenrolled date.
Field IDcontacts.hs_latest_sequence_unenrolled_date
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Contact Latest Source Date
The time of the latest session for a contact
Field IDcontacts.hs_latest_source_timestamp
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Contact Latest subscription create date
The create date of the latest subscription by the contact.
Field IDcontacts.hs_latest_subscription_create_date
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Contact Lead Status
The contact's sales, prospecting or outreach status
Field IDcontacts.hs_lead_status
TypeTEXT
Data Typedimension
Legal basis for processing contact's data
Legal basis for processing contact's data; 'Not applicable' will exempt the contact from GDPR protections
Field IDcontacts.hs_legal_basis
TypeTEXT
Data Typedimension
Contact Clicked LinkedIn Ad
Field IDcontacts.hs_linkedin_ad_clicked
TypeTEXT
Data Typedimension
Contact Linkedin ID
A contact's linkedin id
Field IDcontacts.hs_linkedinid
TypeTEXT
Data Typedimension
Marketing contact status source name
The ID of the activity that set the contact as a marketing contact
Field IDcontacts.hs_marketable_reason_id
TypeTEXT
Data Typedimension
Marketing contact status source type
The type of the activity that set the contact as a marketing contact
Field IDcontacts.hs_marketable_reason_type
TypeTEXT
Data Typedimension
Marketing contact status
The marketing status of a contact
Field IDcontacts.hs_marketable_status
TypeTEXT
Data Typedimension
Marketing contact until next update
Specifies if this contact will be set as non-marketing on renewal
Field IDcontacts.hs_marketable_until_renewal
TypeTEXT
Data Typedimension
Merged Contact IDs
The list of Contact record IDs that have been merged into this Contact. This value is automatically set by HubSpot and may not be modified.
Field IDcontacts.hs_merged_object_ids
TypeTEXT
Data Typedimension
Contact Record ID
The unique ID for this record. This value is automatically set by HubSpot and may not be modified.
Field IDcontacts.hs_object_id
TypeNUMBER
Data Typedimension
Contact Record Creation Source
Source (PropertySource) that created this object record
Field IDcontacts.hs_object_source
TypeTEXT
Data Typedimension
Contact Record Creation Source ID
The sourceId -- further detail -- of the source that created this object record
Field IDcontacts.hs_object_source_id
TypeTEXT
Data Typedimension
Contact Record Source
How this record was created
Field IDcontacts.hs_object_source_label
TypeTEXT
Data Typedimension
Contact Record Creation Source User ID
User ID of the user who initiated creation of this object record
Field IDcontacts.hs_object_source_user_id
TypeNUMBER
Data Typedimension
Contact Pinned engagement ID
Field IDcontacts.hs_pinned_engagement_id
TypeNUMBER
Data Typedimension
Contact Pipeline
The pipeline with which this contact is currently associated
Field IDcontacts.hs_pipeline
TypeTEXT
Data Typedimension
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.
Field IDcontacts.hs_predictivecontactscore_v2
TypeNUMBER
Data Typedimension
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.
Field IDcontacts.hs_predictivescoringtier
TypeTEXT
Data Typedimension
Contact Read Only Object
Is the object read only
Field IDcontacts.hs_read_only
TypeBOOLEAN
Data Typedimension
Contact Date of first engagement
The date the current contact owner first engaged with the contact. Used in Sales Analytics app.
Field IDcontacts.hs_sa_first_engagement_date
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Contact Description of first engagement
A description of the current contact owner's first engagement with the contact. Used in the Sales Analytics app.
Field IDcontacts.hs_sa_first_engagement_descr
TypeTEXT
Data Typedimension
Contact Type of first engagement
The object type of the current contact owner's first engagement with the contact. Used in the Sales Analytics app.
Field IDcontacts.hs_sa_first_engagement_object_type
TypeTEXT
Data Typedimension
Contact Recent Sales Email Clicked Date
The last time a tracked sales email was clicked by this user
Field IDcontacts.hs_sales_email_last_clicked
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
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.
Field IDcontacts.hs_sales_email_last_opened
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Contact Calculated Mobile Number with country code
Mobile number with country code
Field IDcontacts.hs_searchable_calculated_international_mobile_number
TypeTEXT
Data Typedimension
Contact Calculated Phone Number with country code
Phone number with country code
Field IDcontacts.hs_searchable_calculated_international_phone_number
TypeTEXT
Data Typedimension
Contact Calculated Mobile Number without country code
Mobile number without country code
Field IDcontacts.hs_searchable_calculated_mobile_number
TypeTEXT
Data Typedimension
Contact Calculated Phone Number without country code
Phone number without country code
Field IDcontacts.hs_searchable_calculated_phone_number
TypeTEXT
Data Typedimension
Contact Number of sequences actively enrolled
The number of sequences actively enrolled.
Field IDcontacts.hs_sequences_actively_enrolled_count
TypeNUMBER
Data Typedimension
Contact Number of sequences enrolled
The number of sequences enrolled.
Field IDcontacts.hs_sequences_enrolled_count
TypeNUMBER
Data Typedimension
Contact Currently in Sequence
A yes/no field that indicates whether the contact is currently in a Sequence.
Field IDcontacts.hs_sequences_is_enrolled
TypeBOOLEAN
Data Typemetric
Contact Source Object ID
The ID of the object from which the data was migrated. This is set automatically during portal data migration.
Field IDcontacts.hs_source_object_id
TypeNUMBER
Data Typedimension
Contact Source Portal ID
The ID of the portal from which the data was migrated. This is set automatically during portal data migration.
Field IDcontacts.hs_source_portal_id
TypeNUMBER
Data Typedimension
Contact testpurge
testing purge
Field IDcontacts.hs_testpurge
TypeTEXT
Data Typedimension
Contact testrollback
testing rollback
Field IDcontacts.hs_testrollback
TypeTEXT
Data Typedimension
Time between contact creation and deal close
Field IDcontacts.hs_time_between_contact_creation_and_deal_close
TypeNUMBER
Data Typemetric
Time between contact creation and deal creation
Field IDcontacts.hs_time_between_contact_creation_and_deal_creation
TypeNUMBER
Data Typemetric
Contact Time in 'Customer (Lifecycle Stage Pipeline)'
The total time in seconds spent by the contact in the 'Customer' stage, 'Lifecycle Stage Pipeline' pipeline
Field IDcontacts.hs_time_in_customer
TypeNUMBER
Data Typedimension
Contact Time in 'Evangelist (Lifecycle Stage Pipeline)'
The total time in seconds spent by the contact in the 'Evangelist' stage, 'Lifecycle Stage Pipeline' pipeline
Field IDcontacts.hs_time_in_evangelist
TypeNUMBER
Data Typedimension
Contact Time in 'Lead (Lifecycle Stage Pipeline)'
The total time in seconds spent by the contact in the 'Lead' stage, 'Lifecycle Stage Pipeline' pipeline
Field IDcontacts.hs_time_in_lead
TypeNUMBER
Data Typedimension
Contact Time in 'Marketing Qualified Lead (Lifecycle Stage Pipeline)'
The total time in seconds spent by the contact in the 'Marketing Qualified Lead' stage, 'Lifecycle Stage Pipeline' pipeline
Field IDcontacts.hs_time_in_marketingqualifiedlead
TypeNUMBER
Data Typedimension
Contact Time in 'Opportunity (Lifecycle Stage Pipeline)'
The total time in seconds spent by the contact in the 'Opportunity' stage, 'Lifecycle Stage Pipeline' pipeline
Field IDcontacts.hs_time_in_opportunity
TypeNUMBER
Data Typedimension
Contact Time in 'Other (Lifecycle Stage Pipeline)'
The total time in seconds spent by the contact in the 'Other' stage, 'Lifecycle Stage Pipeline' pipeline
Field IDcontacts.hs_time_in_other
TypeNUMBER
Data Typedimension
Contact Time in 'Sales Qualified Lead (Lifecycle Stage Pipeline)'
The total time in seconds spent by the contact in the 'Sales Qualified Lead' stage, 'Lifecycle Stage Pipeline' pipeline
Field IDcontacts.hs_time_in_salesqualifiedlead
TypeNUMBER
Data Typedimension
Contact Time in 'Subscriber (Lifecycle Stage Pipeline)'
The total time in seconds spent by the contact in the 'Subscriber' stage, 'Lifecycle Stage Pipeline' pipeline
Field IDcontacts.hs_time_in_subscriber
TypeNUMBER
Data Typedimension
Contact Lead response time
Time it took current owner to do first qualifying engagement (ms). Used in Sales Analytics app.
Field IDcontacts.hs_time_to_first_engagement
TypeNUMBER
Data Typedimension
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.
Field IDcontacts.hs_time_to_move_from_lead_to_customer
TypeNUMBER
Data Typemetric
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.
Field IDcontacts.hs_time_to_move_from_marketingqualifiedlead_to_customer
TypeNUMBER
Data Typemetric
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.
Field IDcontacts.hs_time_to_move_from_opportunity_to_customer
TypeNUMBER
Data Typemetric
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.
Field IDcontacts.hs_time_to_move_from_salesqualifiedlead_to_customer
TypeNUMBER
Data Typemetric
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.
Field IDcontacts.hs_time_to_move_from_subscriber_to_customer
TypeNUMBER
Data Typemetric
Contact Time Zone
The contact’s time zone. This can be set automatically by HubSpot based on other contact properties. It can also be set manually for each contact.
Field IDcontacts.hs_timezone
TypeTEXT
Data Typedimension
Contact Twitter ID
A contact's twitter id
Field IDcontacts.hs_twitterid
TypeTEXT
Data Typedimension
Contact Unique creation key
Unique property used for idempotent creates
Field IDcontacts.hs_unique_creation_key
TypeTEXT
Data Typedimension
Contact Updated by user ID
The user that last updated this object. This value is automatically set by HubSpot and may not be modified.
Field IDcontacts.hs_updated_by_user_id
TypeNUMBER
Data Typedimension
Contact 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
Field IDcontacts.hs_user_ids_of_all_notification_followers
TypeTEXT
Data Typedimension
Contact 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
Field IDcontacts.hs_user_ids_of_all_notification_unfollowers
TypeTEXT
Data Typedimension
Contact User IDs of all owners
The user IDs of all owners of this object
Field IDcontacts.hs_user_ids_of_all_owners
TypeTEXT
Data Typedimension
Contact Cumulative time in "Customer (Lifecycle Stage Pipeline)"
The cumulative time in seconds spent by the contact in the 'Customer' stage, 'Lifecycle Stage Pipeline' pipeline
Field IDcontacts.hs_v2_cumulative_time_in_customer
TypeNUMBER
Data Typedimension
Contact Cumulative time in "Evangelist (Lifecycle Stage Pipeline)"
The cumulative time in seconds spent by the contact in the 'Evangelist' stage, 'Lifecycle Stage Pipeline' pipeline
Field IDcontacts.hs_v2_cumulative_time_in_evangelist
TypeNUMBER
Data Typedimension
Contact Cumulative time in "Lead (Lifecycle Stage Pipeline)"
The cumulative time in seconds spent by the contact in the 'Lead' stage, 'Lifecycle Stage Pipeline' pipeline
Field IDcontacts.hs_v2_cumulative_time_in_lead
TypeNUMBER
Data Typedimension
Contact Cumulative time in "Marketing Qualified Lead (Lifecycle Stage Pipeline)"
The cumulative time in seconds spent by the contact in the 'Marketing Qualified Lead' stage, 'Lifecycle Stage Pipeline' pipeline
Field IDcontacts.hs_v2_cumulative_time_in_marketingqualifiedlead
TypeNUMBER
Data Typedimension
Contact Cumulative time in "Opportunity (Lifecycle Stage Pipeline)"
The cumulative time in seconds spent by the contact in the 'Opportunity' stage, 'Lifecycle Stage Pipeline' pipeline
Field IDcontacts.hs_v2_cumulative_time_in_opportunity
TypeNUMBER
Data Typedimension
Contact Cumulative time in "Other (Lifecycle Stage Pipeline)"
The cumulative time in seconds spent by the contact in the 'Other' stage, 'Lifecycle Stage Pipeline' pipeline
Field IDcontacts.hs_v2_cumulative_time_in_other
TypeNUMBER
Data Typedimension
Contact Cumulative time in "Sales Qualified Lead (Lifecycle Stage Pipeline)"
The cumulative time in seconds spent by the contact in the 'Sales Qualified Lead' stage, 'Lifecycle Stage Pipeline' pipeline
Field IDcontacts.hs_v2_cumulative_time_in_salesqualifiedlead
TypeNUMBER
Data Typedimension
Contact Cumulative time in "Subscriber (Lifecycle Stage Pipeline)"
The cumulative time in seconds spent by the contact in the 'Subscriber' stage, 'Lifecycle Stage Pipeline' pipeline
Field IDcontacts.hs_v2_cumulative_time_in_subscriber
TypeNUMBER
Data Typedimension
Contact Date entered "Customer (Lifecycle Stage Pipeline)"
The date and time when the contact entered the 'Customer' stage, 'Lifecycle Stage Pipeline' pipeline
Field IDcontacts.hs_v2_date_entered_customer
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Contact Date entered "Evangelist (Lifecycle Stage Pipeline)"
The date and time when the contact entered the 'Evangelist' stage, 'Lifecycle Stage Pipeline' pipeline
Field IDcontacts.hs_v2_date_entered_evangelist
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Contact Date entered "Lead (Lifecycle Stage Pipeline)"
The date and time when the contact entered the 'Lead' stage, 'Lifecycle Stage Pipeline' pipeline
Field IDcontacts.hs_v2_date_entered_lead
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Contact Date entered "Marketing Qualified Lead (Lifecycle Stage Pipeline)"
The date and time when the contact entered the 'Marketing Qualified Lead' stage, 'Lifecycle Stage Pipeline' pipeline
Field IDcontacts.hs_v2_date_entered_marketingqualifiedlead
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Contact Date entered "Opportunity (Lifecycle Stage Pipeline)"
The date and time when the contact entered the 'Opportunity' stage, 'Lifecycle Stage Pipeline' pipeline
Field IDcontacts.hs_v2_date_entered_opportunity
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Contact Date entered "Other (Lifecycle Stage Pipeline)"
The date and time when the contact entered the 'Other' stage, 'Lifecycle Stage Pipeline' pipeline
Field IDcontacts.hs_v2_date_entered_other
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Contact Date entered "Sales Qualified Lead (Lifecycle Stage Pipeline)"
The date and time when the contact entered the 'Sales Qualified Lead' stage, 'Lifecycle Stage Pipeline' pipeline
Field IDcontacts.hs_v2_date_entered_salesqualifiedlead
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Contact Date entered "Subscriber (Lifecycle Stage Pipeline)"
The date and time when the contact entered the 'Subscriber' stage, 'Lifecycle Stage Pipeline' pipeline
Field IDcontacts.hs_v2_date_entered_subscriber
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Contact Date exited "Customer (Lifecycle Stage Pipeline)"
The date and time when the contact exited the 'Customer' stage, 'Lifecycle Stage Pipeline' pipeline
Field IDcontacts.hs_v2_date_exited_customer
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Contact Date exited "Evangelist (Lifecycle Stage Pipeline)"
The date and time when the contact exited the 'Evangelist' stage, 'Lifecycle Stage Pipeline' pipeline
Field IDcontacts.hs_v2_date_exited_evangelist
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Contact Date exited "Lead (Lifecycle Stage Pipeline)"
The date and time when the contact exited the 'Lead' stage, 'Lifecycle Stage Pipeline' pipeline
Field IDcontacts.hs_v2_date_exited_lead
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Contact Date exited "Marketing Qualified Lead (Lifecycle Stage Pipeline)"
The date and time when the contact exited the 'Marketing Qualified Lead' stage, 'Lifecycle Stage Pipeline' pipeline
Field IDcontacts.hs_v2_date_exited_marketingqualifiedlead
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Contact Date exited "Opportunity (Lifecycle Stage Pipeline)"
The date and time when the contact exited the 'Opportunity' stage, 'Lifecycle Stage Pipeline' pipeline
Field IDcontacts.hs_v2_date_exited_opportunity
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Contact Date exited "Other (Lifecycle Stage Pipeline)"
The date and time when the contact exited the 'Other' stage, 'Lifecycle Stage Pipeline' pipeline
Field IDcontacts.hs_v2_date_exited_other
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Contact Date exited "Sales Qualified Lead (Lifecycle Stage Pipeline)"
The date and time when the contact exited the 'Sales Qualified Lead' stage, 'Lifecycle Stage Pipeline' pipeline
Field IDcontacts.hs_v2_date_exited_salesqualifiedlead
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Contact Date exited "Subscriber (Lifecycle Stage Pipeline)"
The date and time when the contact exited the 'Subscriber' stage, 'Lifecycle Stage Pipeline' pipeline
Field IDcontacts.hs_v2_date_exited_subscriber
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Contact Latest time in "Customer (Lifecycle Stage Pipeline)"
The total time in seconds spent by the contact in the 'Customer' stage, 'Lifecycle Stage Pipeline' pipeline since it last entered this stage
Field IDcontacts.hs_v2_latest_time_in_customer
TypeNUMBER
Data Typedimension
Contact Latest time in "Evangelist (Lifecycle Stage Pipeline)"
The total time in seconds spent by the contact in the 'Evangelist' stage, 'Lifecycle Stage Pipeline' pipeline since it last entered this stage
Field IDcontacts.hs_v2_latest_time_in_evangelist
TypeNUMBER
Data Typedimension
Contact Latest time in "Lead (Lifecycle Stage Pipeline)"
The total time in seconds spent by the contact in the 'Lead' stage, 'Lifecycle Stage Pipeline' pipeline since it last entered this stage
Field IDcontacts.hs_v2_latest_time_in_lead
TypeNUMBER
Data Typedimension
Contact Latest time in "Marketing Qualified Lead (Lifecycle Stage Pipeline)"
The total time in seconds spent by the contact in the 'Marketing Qualified Lead' stage, 'Lifecycle Stage Pipeline' pipeline since it last entered this stage
Field IDcontacts.hs_v2_latest_time_in_marketingqualifiedlead
TypeNUMBER
Data Typedimension
Contact Latest time in "Opportunity (Lifecycle Stage Pipeline)"
The total time in seconds spent by the contact in the 'Opportunity' stage, 'Lifecycle Stage Pipeline' pipeline since it last entered this stage
Field IDcontacts.hs_v2_latest_time_in_opportunity
TypeNUMBER
Data Typedimension
Contact Latest time in "Other (Lifecycle Stage Pipeline)"
The total time in seconds spent by the contact in the 'Other' stage, 'Lifecycle Stage Pipeline' pipeline since it last entered this stage
Field IDcontacts.hs_v2_latest_time_in_other
TypeNUMBER
Data Typedimension
Contact Latest time in "Sales Qualified Lead (Lifecycle Stage Pipeline)"
The total time in seconds spent by the contact in the 'Sales Qualified Lead' stage, 'Lifecycle Stage Pipeline' pipeline since it last entered this stage
Field IDcontacts.hs_v2_latest_time_in_salesqualifiedlead
TypeNUMBER
Data Typedimension
Contact Latest time in "Subscriber (Lifecycle Stage Pipeline)"
The total time in seconds spent by the contact in the 'Subscriber' stage, 'Lifecycle Stage Pipeline' pipeline since it last entered this stage
Field IDcontacts.hs_v2_latest_time_in_subscriber
TypeNUMBER
Data Typedimension
Contact Performed in an import
Object is part of an import
Field IDcontacts.hs_was_imported
TypeBOOLEAN
Data Typedimension
Contact WhatsApp Phone Number
The phone number associated with the contact’s WhatsApp account.
Field IDcontacts.hs_whatsapp_phone_number
TypeTEXT
Data Typedimension
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.
Field IDcontacts.hubspot_owner_assigneddate
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
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.
Field IDcontacts.ip_city
TypeTEXT
Data Typedimension
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.
Field IDcontacts.ip_country
TypeTEXT
Data Typedimension
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.
Field IDcontacts.ip_country_code
TypeTEXT
Data Typedimension
Contact IP Latitude & Longitude
Field IDcontacts.ip_latlon
TypeTEXT
Data Typedimension
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.
Field IDcontacts.ip_state
TypeTEXT
Data Typedimension
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.
Field IDcontacts.ip_state_code
TypeTEXT
Data Typedimension
Contact IP Zipcode
The zipcode reported by a contact's IP address. This is automatically set by HubSpot and can be used for segmentation and reporting.
Field IDcontacts.ip_zipcode
TypeTEXT
Data Typedimension
Contact Job function
Contact's job function. Required for the Facebook Ads Integration. Automatically synced from the Lead Ads tool.
Field IDcontacts.job_function
TypeTEXT
Data Typedimension
Contact Last Modified Date
The date any property on this contact was modified
Field IDcontacts.lastmodifieddate
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Contact Marital Status
Contact's marital status. Required for the Facebook Ads Integration. Automatically synced from the Lead Ads tool.
Field IDcontacts.marital_status
TypeTEXT
Data Typedimension
Contact Military status
Contact's military status. Required for the Facebook Ads Integration. Automatically synced from the Lead Ads tool.
Field IDcontacts.military_status
TypeTEXT
Data Typedimension
Contact Number of Associated Deals
Count of deals associated with this contact. Set automatically by HubSpot.
Field IDcontacts.num_associated_deals
TypeNUMBER
Data Typedimension
Contact Number of Form Submissions
The number of forms this contact has submitted
Field IDcontacts.num_conversion_events
TypeNUMBER
Data Typedimension
Contact Number of Unique Forms Submitted
The number of different forms this contact has submitted
Field IDcontacts.num_unique_conversion_events
TypeNUMBER
Data Typedimension
Contact Recent Conversion Date
The date this contact last submitted a form
Field IDcontacts.recent_conversion_date
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Contact Recent Conversion
The last form this contact submitted
Field IDcontacts.recent_conversion_event_name
TypeTEXT
Data Typedimension
Contact Recent Deal Amount
Amount of last closed won deal associated with a contact. Set automatically.
Field IDcontacts.recent_deal_amount
TypeNUMBER
Data Typedimension
Contact Recent Deal Close Date
Date last deal associated with contact was closed-won. Set automatically.
Field IDcontacts.recent_deal_close_date
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Contact Relationship Status
Contact's relationship status. Required for the Facebook Ads Integration. Automatically synced from the Lead Ads tool.
Field IDcontacts.relationship_status
TypeTEXT
Data Typedimension
Contact School
Contact's school. Required for the Facebook Ads Integration. Automatically synced from the Lead Ads tool.
Field IDcontacts.school
TypeTEXT
Data Typedimension
Contact Seniority
Contact's seniority. Required for the Facebook Ads Integration. Automatically synced from the Lead Ads tool.
Field IDcontacts.seniority
TypeTEXT
Data Typedimension
Contact Start date
Contact's start date. Required for the Facebook Ads Integration. Automatically synced from the Lead Ads tool.
Field IDcontacts.start_date
TypeTEXT
Data Typedimension
Contact Total Revenue
Sum of all closed-won deal revenue associated with the contact. Set automatically.
Field IDcontacts.total_revenue
TypeNUMBER
Data Typedimension
Contact Work email
Contact's work email. Required for the Facebook Ads Integration. Automatically synced from the Lead Ads tool.
Field IDcontacts.work_email
TypeTEXT
Data Typedimension
Contact First Name
A contact's first name
Field IDcontacts.firstname
TypeTEXT
Data Typedimension
Contact First Page Seen
First page the contact visited on your website. Set automatically.
Field IDcontacts.hs_analytics_first_url
TypeTEXT
Data Typedimension
Contact Marketing emails delivered
The number of marketing emails delivered for the current email address. This is automatically set by HubSpot.
Field IDcontacts.hs_email_delivered
TypeNUMBER
Data Typedimension
Contact Opted out of email: Marketing Information
Indicates that the current email address has opted out of this email type.
Field IDcontacts.hs_email_optout_265900982
TypeTEXT
Data Typedimension
Contact Opted out of email: One to One
Indicates that the current email address has opted out of this email type.
Field IDcontacts.hs_email_optout_265900983
TypeTEXT
Data Typedimension
Contact Opted out of email: Customer Service Communication
Indicates that the current email address has opted out of this email type.
Field IDcontacts.hs_email_optout_265900989
TypeTEXT
Data Typedimension
Contact Twitter Username
The contact's Twitter handle.
Field IDcontacts.twitterhandle
TypeTEXT
Data Typedimension
Contact Currently in workflow
True when contact is enrolled in a workflow.
Field IDcontacts.currentlyinworkflow
TypeTEXT
Data Typedimension
Contact Follower Count
The number of Twitter followers a contact has
Field IDcontacts.followercount
TypeNUMBER
Data Typedimension
Contact Last Page Seen
Last page the contact visited on your website. Set automatically.
Field IDcontacts.hs_analytics_last_url
TypeTEXT
Data Typedimension
Contact Marketing emails opened
The number of marketing emails opened for the current email address. This is automatically set by HubSpot.
Field IDcontacts.hs_email_open
TypeNUMBER
Data Typedimension
Contact Last Name
A contact's last name
Field IDcontacts.lastname
TypeTEXT
Data Typedimension
Contact Number of Pageviews
Total number of page views this contact has had on your website. Set automatically.
Field IDcontacts.hs_analytics_num_page_views
TypeNUMBER
Data Typedimension
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.
Field IDcontacts.hs_email_click
TypeNUMBER
Data Typedimension
Contact Salutation
The title used to address a contact
Field IDcontacts.salutation
TypeTEXT
Data Typedimension
Contact Twitter Profile Photo
The contact's Twitter profile photo. This is set by HubSpot using the contact's email address.
Field IDcontacts.twitterprofilephoto
TypeTEXT
Data Typedimension
Contact Email
A contact's email address
Field IDcontacts.email
TypeTEXT
Data Typedimension
Contact Number of Sessions
Number of times a contact has come to your website. Set automatically.
Field IDcontacts.hs_analytics_num_visits
TypeNUMBER
Data Typedimension
Contact Marketing emails bounced
The number of marketing emails that bounced for the current email address. This is automatically set by HubSpot.
Field IDcontacts.hs_email_bounce
TypeNUMBER
Data Typedimension
Contact Persona
A contact's persona
Field IDcontacts.hs_persona
TypeTEXT
Data Typedimension
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.
Field IDcontacts.hs_social_last_engagement
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Contact Number of event completions
Total number of events for this contact. Set automatically.
Field IDcontacts.hs_analytics_num_event_completions
TypeNUMBER
Data Typedimension
Contact Unsubscribed from all email
Indicates that the current email address has opted out of all email.
Field IDcontacts.hs_email_optout
TypeBOOLEAN
Data Typedimension
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.
Field IDcontacts.hs_social_twitter_clicks
TypeNUMBER
Data Typedimension
Contact Mobile Phone Number
A contact's mobile phone number
Field IDcontacts.mobilephone
TypeTEXT
Data Typedimension
Contact Phone Number
A contact's primary phone number
Field IDcontacts.phone
TypeTEXT
Data Typedimension
Contact Fax Number
A contact's primary fax number
Field IDcontacts.fax
TypeTEXT
Data Typedimension
Contact Time First Seen
First time the contact has been seen. Set automatically.
Field IDcontacts.hs_analytics_first_timestamp
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Contact Last marketing email name
The name of the last marketing email sent to the current email address. This is automatically set by HubSpot.
Field IDcontacts.hs_email_last_email_name
TypeTEXT
Data Typedimension
Contact 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.
Field IDcontacts.hs_email_last_send_date
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Contact Facebook Clicks
The number clicks on links shared on Facebook
Field IDcontacts.hs_social_facebook_clicks
TypeNUMBER
Data Typedimension
Contact Street Address
Contact's street address, including apartment or unit number.
Field IDcontacts.address
TypeTEXT
Data Typedimension
Contact Date of last meeting booked in meetings tool
The date of the last meeting that has been scheduled by a contact through the meetings tool. If multiple meetings have been scheduled, the date of the last chronological meeting in the timeline is shown.
Field IDcontacts.engagements_last_meeting_booked
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Contact Campaign of last booking in meetings tool
UTM parameter for marketing campaign (e.g. a specific email) responsible for recent meeting booking. Only populated when tracking parameters are included in meeting link.
Field IDcontacts.engagements_last_meeting_booked_campaign
TypeTEXT
Data Typedimension
Contact Medium of last booking in meetings tool
UTM parameter for the channel (e.g. email) responsible for most recent meeting booking. Only populated when tracking parameters are included in meeting link.
Field IDcontacts.engagements_last_meeting_booked_medium
TypeTEXT
Data Typedimension
Contact Source of last booking in meetings tool
UTM parameter for the site (e.g. Twitter) responsible for most recent meeting booking. Only populated when tracking parameters are included in meeting link.
Field IDcontacts.engagements_last_meeting_booked_source
TypeTEXT
Data Typedimension
Contact Time of First Session
First time the contact visited your website. Set automatically.
Field IDcontacts.hs_analytics_first_visit_timestamp
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
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.
Field IDcontacts.hs_email_last_open_date
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Contact Latest meeting activity
The date of the most recent meeting (past or upcoming) logged for, scheduled with, or booked by this contact.
Field IDcontacts.hs_latest_meeting_activity
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
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.
Field IDcontacts.hs_sales_email_last_replied
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Contact LinkedIn Clicks
The number clicks on links shared on LinkedIn
Field IDcontacts.hs_social_linkedin_clicks
TypeNUMBER
Data Typedimension
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.
Field IDcontacts.hubspot_owner_id
TypeTEXT
Data Typedimension
Last Contacted
The last time a call, chat conversation, LinkedIn message, postal mail, meeting, sales email, SMS, or WhatsApp message was logged for a contact. This is set automatically by HubSpot based on user actions in the contact record.
Field IDcontacts.notes_last_contacted
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Contact Last Activity Date
The last time a call, chat conversation, LinkedIn message, postal mail, meeting, note, sales email, SMS, or WhatsApp message was logged for a contact. This is set automatically by HubSpot based on user actions in the contact record.
Field IDcontacts.notes_last_updated
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
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.
Field IDcontacts.notes_next_activity_date
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Number of times contacted
The number of times a call, chat conversation, LinkedIn message, postal mail, meeting, sales email, SMS, or WhatsApp message was logged for a contact record. This is set automatically by HubSpot based on user actions in the contact record.
Field IDcontacts.num_contacted_notes
TypeNUMBER
Data Typedimension
Contact Number of Sales Activities
The number of times a call, chat conversation, LinkedIn message, postal mail, meeting, note, sales email, SMS, task, or WhatsApp message was logged for a contact record. This is set automatically by HubSpot based on user actions in the contact record.
Field IDcontacts.num_notes
TypeNUMBER
Data Typedimension
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.
Field IDcontacts.owneremail
TypeTEXT
Data Typedimension
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.
Field IDcontacts.ownername
TypeTEXT
Data Typedimension
Contact SurveyMonkey Event Last Updated
This field is meaningless on its own, and is solely used for triggering dynamic list updates when SurveyMonkey information is updated
Field IDcontacts.surveymonkeyeventlastupdated
TypeNUMBER
Data Typedimension
Contact Webinar Event Last Updated
This field is meaningless on its own, and is solely used for triggering dynamic list updates when webinar information is updated
Field IDcontacts.webinareventlastupdated
TypeNUMBER
Data Typedimension
Contact City
A contact's city of residence
Field IDcontacts.city
TypeTEXT
Data Typedimension
Contact Time Last Seen
Timestamp for most recent webpage view on your website.
Field IDcontacts.hs_analytics_last_timestamp
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
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.
Field IDcontacts.hs_email_last_click_date
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Contact Google Plus Clicks
The number clicks on links shared on Google Plus
Field IDcontacts.hs_social_google_plus_clicks
TypeNUMBER
Data Typedimension
Contact HubSpot Team
The team of the owner of a contact.
Field IDcontacts.hubspot_team_id
TypeTEXT
Data Typedimension
Contact LinkedIn Bio
A contact's LinkedIn bio
Field IDcontacts.linkedinbio
TypeTEXT
Data Typedimension
Contact Twitter Bio
The contact's Twitter bio. This is set by HubSpot using the contact's email address.
Field IDcontacts.twitterbio
TypeTEXT
Data Typedimension
Contact All owner ids
The value of all owner referencing properties for this object, both default and custom
Field IDcontacts.hs_all_owner_ids
TypeTEXT
Data Typedimension
Contact Time of Last Session
Timestamp for start of the most recent session for this contact to your website.
Field IDcontacts.hs_analytics_last_visit_timestamp
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
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.
Field IDcontacts.hs_email_first_send_date
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Contact Broadcast Clicks
The number of clicks on published social messages. This is set automatically by HubSpot for each contact.
Field IDcontacts.hs_social_num_broadcast_clicks
TypeNUMBER
Data Typedimension
Contact State/Region
The contact's state of residence. This might be set via import, form, or integration.
Field IDcontacts.state
TypeTEXT
Data Typedimension
Contact All team ids
The team ids corresponding to all owner referencing properties for this object, both default and custom
Field IDcontacts.hs_all_team_ids
TypeTEXT
Data Typedimension
Contact Original Source
First known source the contact used to find your website. Set automatically, but may be updated manually.
Field IDcontacts.hs_analytics_source
TypeTEXT
Data Typedimension
Contact 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.
Field IDcontacts.hs_email_first_open_date
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Contact Latest Source
The source of the latest session for a contact
Field IDcontacts.hs_latest_source
TypeTEXT
Data Typedimension
Contact Postal Code
The contact's zip code. This might be set via import, form, or integration.
Field IDcontacts.zip
TypeTEXT
Data Typedimension
Contact Country/Region
The contact's country/region of residence. This might be set via import, form, or integration.
Field IDcontacts.country
TypeTEXT
Data Typedimension
Contact All teams
The team ids, including up the team hierarchy, corresponding to all owner referencing properties for this object, both default and custom
Field IDcontacts.hs_all_accessible_team_ids
TypeTEXT
Data Typedimension
Contact Original Source Drill-Down 1
Additional information about the source the contact used to find your website. Set automatically.
Field IDcontacts.hs_analytics_source_data_1
TypeTEXT
Data Typedimension
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.
Field IDcontacts.hs_email_first_click_date
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Contact Latest Source Drill-Down 1
Additional information about the latest source for the last session the contact used to find your website. Set automatically.
Field IDcontacts.hs_latest_source_data_1
TypeTEXT
Data Typedimension
Contact LinkedIn Connections
How many LinkedIn connections they have
Field IDcontacts.linkedinconnections
TypeNUMBER
Data Typedimension
Contact Original Source Drill-Down 2
Additional information about the source the contact used to find your website. Set automatically.
Field IDcontacts.hs_analytics_source_data_2
TypeTEXT
Data Typedimension
Contact Is globally ineligible
Indicates the contact is globally ineligible for email.
Field IDcontacts.hs_email_is_ineligible
TypeBOOLEAN
Data Typedimension
Contact Preferred language
Set your contact's preferred language for communications. This property can be changed from an import, form, or integration.
Field IDcontacts.hs_language
TypeTEXT
Data Typedimension
Contact Latest Source Drill-Down 2
Additional information about the source for the last session the contact used to find your website. Set automatically.
Field IDcontacts.hs_latest_source_data_2
TypeTEXT
Data Typedimension
Contact Klout Score
A contact's Klout score, a measure of Internet influence
Field IDcontacts.kloutscoregeneral
TypeNUMBER
Data Typedimension
Contact First Referring Site
URL that referred the contact to your website. Set automatically.
Field IDcontacts.hs_analytics_first_referrer
TypeTEXT
Data Typedimension
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.
Field IDcontacts.hs_email_first_reply_date
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Contact Job Title
A contact's job title
Field IDcontacts.jobtitle
TypeTEXT
Data Typedimension
Contact Photo
Social Media photo
Field IDcontacts.photo
TypeTEXT
Data Typedimension
Contact Last Referring Site
Last URL that referred contact to your website. Set automatically.
Field IDcontacts.hs_analytics_last_referrer
TypeTEXT
Data Typedimension
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.
Field IDcontacts.hs_email_last_reply_date
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Contact Message
A default property to be used for any message or comments a contact may want to leave on a form.
Field IDcontacts.message
TypeTEXT
Data Typedimension
Contact Close Date
Date the contact became a customer. Set automatically when a deal or opportunity is marked as closed-won. It can also be set manually or programmatically.
Field IDcontacts.closedate
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Contact Average Pageviews
Average number of pageviews per session for this contact. Set automatically.
Field IDcontacts.hs_analytics_average_page_views
TypeNUMBER
Data Typedimension
Contact Marketing emails replied
The number of marketing emails replied to by the current email address. This is automatically set by HubSpot.
Field IDcontacts.hs_email_replied
TypeNUMBER
Data Typedimension
Contact Event Revenue
Set event revenue on a contact though the Enterprise Events feature. http://help.hubspot.com/articles/KCS_Article/Reports/How-do-I-create-Events-in-HubSpot
Field IDcontacts.hs_analytics_revenue
TypeNUMBER
Data Typedimension
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.
Field IDcontacts.hs_lifecyclestage_lead_date
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
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.
Field IDcontacts.hs_lifecyclestage_marketingqualifiedlead_date
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
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.
Field IDcontacts.hs_lifecyclestage_opportunity_date
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
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.
Field IDcontacts.lifecyclestage
TypeTEXT
Data Typedimension
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.
Field IDcontacts.hs_lifecyclestage_salesqualifiedlead_date
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Contact Create Date
The date that a contact entered the system
Field IDcontacts.createdate
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
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.
Field IDcontacts.hs_lifecyclestage_evangelist_date
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
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.
Field IDcontacts.hs_lifecyclestage_customer_date
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Contact HubSpot Score
The number that shows qualification of contacts to sales readiness. It can be set in HubSpot's Lead Scoring app.
Field IDcontacts.hubspotscore
TypeNUMBER
Data Typedimension
Contact Company Name
Name of the contact's company. This can be set independently from the name property on the contact's associated company.
Field IDcontacts.company
TypeTEXT
Data Typedimension
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.
Field IDcontacts.hs_lifecyclestage_subscriber_date
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
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.
Field IDcontacts.hs_lifecyclestage_other_date
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Contact Website URL
Associated company website.
Field IDcontacts.website
TypeTEXT
Data Typedimension
Contact Number of Employees
The number of company employees
Field IDcontacts.numemployees
TypeTEXT
Data Typedimension
Contact Annual Revenue
Annual company revenue
Field IDcontacts.annualrevenue
TypeTEXT
Data Typedimension
Contact Industry
The Industry a contact is in
Field IDcontacts.industry
TypeTEXT
Data Typedimension
Contact Primary Associated Company ID
HubSpot defined ID of a contact's primary associated company in HubSpot.
Field IDcontacts.associatedcompanyid
TypeNUMBER
Data Typedimension
Contact Associated Company Last Updated
This field is meaningless on its own, and is solely used for triggering dynamic list updates when a company is updated
Field IDcontacts.associatedcompanylastupdated
TypeNUMBER
Data Typedimension
Contact Lead Rating
The rating of this contact based on their predictive lead score
Field IDcontacts.hs_predictivecontactscorebucket
TypeTEXT
Data Typedimension
Contact Predictive Lead Score
A score calculated by HubSpot that represents a contact's likelihood to become a customer
Field IDcontacts.hs_predictivecontactscore
TypeNUMBER
Data Typedimension
Deal Amount in company currency
The amount of the deal, using the exchange rate, in your company's currency
Field IDdeals.amount_in_home_currency
TypeNUMBER
Data Typemetric
Deal Days to close
The number of days the deal took to close
Field IDdeals.days_to_close
TypeNUMBER
Data Typemetric
Deal Currency
Currency code for the deal.
Field IDdeals.deal_currency_code
TypeTEXT
Data Typedimension
Deal Annual contract value
The annual contract value (ACV) of this deal.
Field IDdeals.hs_acv
TypeNUMBER
Data Typedimension
Deal Business units
The business units this record is assigned to.
Field IDdeals.hs_all_assigned_business_unit_ids
TypeTEXT
Data Typedimension
Deal Collaborator
Owner ids of the users involved in closing the deal
Field IDdeals.hs_all_collaborator_owner_ids
TypeTEXT
Data Typedimension
Deal Split Users
The owner ids of all associated Deal Splits. This property is set automatically by HubSpot.
Field IDdeals.hs_all_deal_split_owner_ids
TypeTEXT
Data Typedimension
Deal Latest Source
Source for the contact either directly or indirectly associated with the last session activity for this deal
Field IDdeals.hs_analytics_latest_source
TypeTEXT
Data Typemetric
Deal Latest Source Company
Source for the company with an associated contact with the last session activity for this deal
Field IDdeals.hs_analytics_latest_source_company
TypeTEXT
Data Typedimension
Deal Latest Source Contact
Source for the directly associated contact with the last session activity for this deal
Field IDdeals.hs_analytics_latest_source_contact
TypeTEXT
Data Typedimension
Deal Latest Source Data 1
Additional source details of the last session attributed to any contacts that are directly or indirectly associated with this deal
Field IDdeals.hs_analytics_latest_source_data_1
TypeTEXT
Data Typemetric
Deal Latest Source Data 1 Company
Additional source details of the last session attributed to any contacts that are indirectly associated with this deal (via a company association)
Field IDdeals.hs_analytics_latest_source_data_1_company
TypeTEXT
Data Typedimension
Deal Latest Source Data 1 Contact
Additional source details of the last session attributed to any contacts that are directly associated with this deal
Field IDdeals.hs_analytics_latest_source_data_1_contact
TypeTEXT
Data Typedimension
Deal Latest Source Data 2
Additional source details of the last session attributed to any contacts that are directly or indirectly associated with this deal
Field IDdeals.hs_analytics_latest_source_data_2
TypeTEXT
Data Typemetric
Deal Latest Source Data 2 Company
Additional source details of the last session attributed to any contacts that are indirectly associated with this deal
Field IDdeals.hs_analytics_latest_source_data_2_company
TypeTEXT
Data Typedimension
Deal Latest Source Data 2 Contact
Additional source details of the last session attributed to any contacts that are directly associated with this deal
Field IDdeals.hs_analytics_latest_source_data_2_contact
TypeTEXT
Data Typedimension
Deal Latest Source Timestamp
Timestamp of when latest source occurred for either a directly or indirectly associated contact
Field IDdeals.hs_analytics_latest_source_timestamp
TypeYEAR_MONTH_DAY_SECOND
Data Typemetric
Deal Latest Source Timestamp Company
Timestamp of when latest source occurred for an indirectly associated contact
Field IDdeals.hs_analytics_latest_source_timestamp_company
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Deal Latest Source Timestamp Contact
Timestamp of when latest source occurred for a directly associated contact
Field IDdeals.hs_analytics_latest_source_timestamp_contact
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Deal Original Source Type
Original source for the contact with the earliest activity for this deal.
Field IDdeals.hs_analytics_source
TypeTEXT
Data Typedimension
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.
Field IDdeals.hs_analytics_source_data_1
TypeTEXT
Data Typedimension
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.
Field IDdeals.hs_analytics_source_data_2
TypeTEXT
Data Typedimension
Deal Annual recurring revenue
The annual recurring revenue (ARR) of this deal.
Field IDdeals.hs_arr
TypeNUMBER
Data Typedimension
Deal HubSpot Campaign
The marketing campaign the deal is associated with
Field IDdeals.hs_campaign
TypeTEXT
Data Typedimension
Closed Deal Amount
Returns the amount if the deal is closed. Else, returns 0.
Field IDdeals.hs_closed_amount
TypeNUMBER
Data Typemetric
Closed Deal Amount In Home Currency
Returns the amount in home currency if the deal is closed. Else, returns 0.
Field IDdeals.hs_closed_amount_in_home_currency
TypeNUMBER
Data Typemetric
Deal Closed won count
Returns 1 if this deal is closed won
Field IDdeals.hs_closed_won_count
TypeNUMBER
Data Typemetric
Deal Closed Won Date (Internal)
Returns closedate if this deal is closed won
Field IDdeals.hs_closed_won_date
TypeYEAR_MONTH_DAY_SECOND
Data Typemetric
Deal Created by user ID
The user that created this object. This value is automatically set by HubSpot and may not be modified.
Field IDdeals.hs_created_by_user_id
TypeNUMBER
Data Typedimension
Deal Date entered 'Appointment Scheduled (Sales Pipeline)'
The date and time when the deal entered the 'Appointment Scheduled' stage, 'Sales Pipeline' pipeline
Field IDdeals.hs_date_entered_appointmentscheduled
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Deal Date entered 'Closed Lost (Sales Pipeline)'
The date and time when the deal entered the 'Closed Lost' stage, 'Sales Pipeline' pipeline
Field IDdeals.hs_date_entered_closedlost
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Deal Date entered 'Closed Won (Sales Pipeline)'
The date and time when the deal entered the 'Closed Won' stage, 'Sales Pipeline' pipeline
Field IDdeals.hs_date_entered_closedwon
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Deal Date entered 'Contract Sent (Sales Pipeline)'
The date and time when the deal entered the 'Contract Sent' stage, 'Sales Pipeline' pipeline
Field IDdeals.hs_date_entered_contractsent
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Deal Date entered 'Decision Maker Bought-In (Sales Pipeline)'
The date and time when the deal entered the 'Decision Maker Bought-In' stage, 'Sales Pipeline' pipeline
Field IDdeals.hs_date_entered_decisionmakerboughtin
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Deal Date entered 'Presentation Scheduled (Sales Pipeline)'
The date and time when the deal entered the 'Presentation Scheduled' stage, 'Sales Pipeline' pipeline
Field IDdeals.hs_date_entered_presentationscheduled
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Deal Date entered 'Qualified To Buy (Sales Pipeline)'
The date and time when the deal entered the 'Qualified To Buy' stage, 'Sales Pipeline' pipeline
Field IDdeals.hs_date_entered_qualifiedtobuy
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Deal Date exited 'Appointment Scheduled (Sales Pipeline)'
The date and time when the deal exited the 'Appointment Scheduled' stage, 'Sales Pipeline' pipeline
Field IDdeals.hs_date_exited_appointmentscheduled
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Deal Date exited 'Closed Lost (Sales Pipeline)'
The date and time when the deal exited the 'Closed Lost' stage, 'Sales Pipeline' pipeline
Field IDdeals.hs_date_exited_closedlost
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Deal Date exited 'Closed Won (Sales Pipeline)'
The date and time when the deal exited the 'Closed Won' stage, 'Sales Pipeline' pipeline
Field IDdeals.hs_date_exited_closedwon
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Deal Date exited 'Contract Sent (Sales Pipeline)'
The date and time when the deal exited the 'Contract Sent' stage, 'Sales Pipeline' pipeline
Field IDdeals.hs_date_exited_contractsent
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Deal Date exited 'Decision Maker Bought-In (Sales Pipeline)'
The date and time when the deal exited the 'Decision Maker Bought-In' stage, 'Sales Pipeline' pipeline
Field IDdeals.hs_date_exited_decisionmakerboughtin
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Deal Date exited 'Presentation Scheduled (Sales Pipeline)'
The date and time when the deal exited the 'Presentation Scheduled' stage, 'Sales Pipeline' pipeline
Field IDdeals.hs_date_exited_presentationscheduled
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Deal Date exited 'Qualified To Buy (Sales Pipeline)'
The date and time when the deal exited the 'Qualified To Buy' stage, 'Sales Pipeline' pipeline
Field IDdeals.hs_date_exited_qualifiedtobuy
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Deal Days to close (without rounding)
The number of days the deal took to close, without rounding
Field IDdeals.hs_days_to_close_raw
TypeNUMBER
Data Typemetric
Deal amount calculation preference
Specifies how deal amount should be calculated from line items
Field IDdeals.hs_deal_amount_calculation_preference
TypeTEXT
Data Typedimension
Deal Score
The predictive deal score calculated by Hubspot AI to score the deal health
Field IDdeals.hs_deal_score
TypeNUMBER
Data Typedimension
Deal probability
The probability a deal will close. This defaults to the deal stage probability setting.
Field IDdeals.hs_deal_stage_probability
TypeNUMBER
Data Typedimension
Deal stage probability shadow
Fall back property for calculating the deal stage when no customer override exist. Probability between 0 and 1 of deal stage. Defaults to 0 for unknown deal stages.
Field IDdeals.hs_deal_stage_probability_shadow
TypeNUMBER
Data Typemetric
Deal Exchange rate
This is the exchange rate used to convert the deal amount into your company currency.
Field IDdeals.hs_exchange_rate
TypeNUMBER
Data Typemetric
Deal Forecast amount
The custom forecasted deal value calculated by multiplying the forecast probability and deal amount in your company’s currency.
Field IDdeals.hs_forecast_amount
TypeNUMBER
Data Typemetric
Deal Forecast probability
The custom percent probability a deal will close.
Field IDdeals.hs_forecast_probability
TypeNUMBER
Data Typedimension
Is Deal Closed?
True if the deal was won or lost.
Field IDdeals.hs_is_closed
TypeBOOLEAN
Data Typemetric
Deal Is Closed Won
True if the deal is in the closed won state, false otherwise
Field IDdeals.hs_is_closed_won
TypeBOOLEAN
Data Typemetric
Deal Split Added
Indicates if the deal is split between multiple users.
Field IDdeals.hs_is_deal_split
TypeBOOLEAN
Data Typemetric
Deal Is open count
1 if the deal is not closed won/lost, else 0
Field IDdeals.hs_is_open_count
TypeNUMBER
Data Typemetric
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.
Field IDdeals.hs_lastmodifieddate
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Deal Likelihood to close by the close date
Hubspot predicted likelihood between 0 and 1 of the deal to close by the close date.
Field IDdeals.hs_likelihood_to_close
TypeNUMBER
Data Typedimension
Deal Global Term Line Item Discount Percentage
For internal HubSpot Application use only. Global term for the discount percentage applied.
Field IDdeals.hs_line_item_global_term_hs_discount_percentage
TypeTEXT
Data Typedimension
Deal Global Term Line Item Discount Percentage Enabled
For internal HubSpot Application use only. Indicates if the Global term for the discount percentage is enabled.
Field IDdeals.hs_line_item_global_term_hs_discount_percentage_enabled
TypeBOOLEAN
Data Typedimension
Deal Global Term Line Item Recurring Billing Period
For internal HubSpot Application use only. Global term for product recurring billing duration.
Field IDdeals.hs_line_item_global_term_hs_recurring_billing_period
TypeTEXT
Data Typedimension
Deal Global Term Line Item Recurring Billing Period Enabled
For internal HubSpot Application use only. Indicates if the Global term for product recurring billing duration is enabled.
Field IDdeals.hs_line_item_global_term_hs_recurring_billing_period_enabled
TypeBOOLEAN
Data Typedimension
Deal Global Term Line Item Recurring Billing Start Date
For internal HubSpot Application use only. Global term for recurring billing start date for a line item.
Field IDdeals.hs_line_item_global_term_hs_recurring_billing_start_date
TypeTEXT
Data Typedimension
Deal Global Term Line Item Recurring Billing Start Date Enabled
For internal HubSpot Application use only. Indicates if the Global term for recurring billing start date for a line item is enabled.
Field IDdeals.hs_line_item_global_term_hs_recurring_billing_start_date_enabled
TypeBOOLEAN
Data Typedimension
Deal Global Term Line Item Recurring Billing Frequency
For internal HubSpot Application use only. Global term for how frequently the product is billed.
Field IDdeals.hs_line_item_global_term_recurringbillingfrequency
TypeTEXT
Data Typedimension
Deal Global Term Line Item Recurring Billing Frequency Enabled
For internal HubSpot Application use only. Indicates if the Global term for how frequently the product is billed is enabled
Field IDdeals.hs_line_item_global_term_recurringbillingfrequency_enabled
TypeBOOLEAN
Data Typedimension
Deal Forecast category
The likelihood a deal will close. This property is used for manual forecasting your deals.
Field IDdeals.hs_manual_forecast_category
TypeTEXT
Data Typedimension
Merged Deal IDs
The list of Deal record IDs that have been merged into this Deal. This value is automatically set by HubSpot and may not be modified.
Field IDdeals.hs_merged_object_ids
TypeTEXT
Data Typedimension
Deal Monthly recurring revenue
The monthly recurring revenue (MRR) of this deal.
Field IDdeals.hs_mrr
TypeNUMBER
Data Typedimension
Deal Next step
A short description of the next step for the deal
Field IDdeals.hs_next_step
TypeTEXT
Data Typedimension
Number of Active Deal Registrations
The number of active deal registrations associated with this deal. This property is set automatically by HubSpot.
Field IDdeals.hs_num_associated_active_deal_registrations
TypeNUMBER
Data Typedimension
Number of Deal Registrations
The number of deal registrations associated with this deal. This property is set automatically by HubSpot.
Field IDdeals.hs_num_associated_deal_registrations
TypeNUMBER
Data Typedimension
Number of Deal Splits
The number of deal splits associated with this deal. This property is set automatically by HubSpot.
Field IDdeals.hs_num_associated_deal_splits
TypeNUMBER
Data Typedimension
Deal Number of Associated Line Items
The number of line items associated with this deal
Field IDdeals.hs_num_of_associated_line_items
TypeNUMBER
Data Typedimension
Deal Number of target accounts
The number of target account companies associated with this deal. This property is set automatically by HubSpot.
Field IDdeals.hs_num_target_accounts
TypeNUMBER
Data Typedimension
Deal Record ID
The unique ID for this record. This value is automatically set by HubSpot and may not be modified.
Field IDdeals.hs_object_id
TypeNUMBER
Data Typedimension
Deal Record Creation Source
Source (PropertySource) that created this object record
Field IDdeals.hs_object_source
TypeTEXT
Data Typedimension
Deal Record Creation Source ID
The sourceId -- further detail -- of the source that created this object record
Field IDdeals.hs_object_source_id
TypeTEXT
Data Typedimension
Deal Record Source
How this record was created
Field IDdeals.hs_object_source_label
TypeTEXT
Data Typedimension
Deal Record Creation Source User ID
User ID of the user who initiated creation of this object record
Field IDdeals.hs_object_source_user_id
TypeNUMBER
Data Typedimension
Deal Pinned Engagement ID
The object ID of the current pinned engagement. This value is automatically set by HubSpot and may not be modified.
Field IDdeals.hs_pinned_engagement_id
TypeNUMBER
Data Typedimension
The predicted deal amount
Returns the multiplication of the deal amount times the predicted likelihood of the deal to close by the close date.
Field IDdeals.hs_predicted_amount
TypeNUMBER
Data Typemetric
The predicted deal amount in your company's currency
Returns the multiplication of the deal amount in your company's currency times the predicted likelihood of the deal to close by the close date.
Field IDdeals.hs_predicted_amount_in_home_currency
TypeNUMBER
Data Typemetric
Deal Priority
Field IDdeals.hs_priority
TypeTEXT
Data Typedimension
Deal Weighted amount
Returns the multiplication of the amount times the probability of the deal closing.
Field IDdeals.hs_projected_amount
TypeNUMBER
Data Typemetric
Deal Weighted amount in company currency
Returns the multiplication of the amount in home currency times the probability of the deal closing.
Field IDdeals.hs_projected_amount_in_home_currency
TypeNUMBER
Data Typemetric
Deal Read Only Object
Is the object read only
Field IDdeals.hs_read_only
TypeBOOLEAN
Data Typedimension
Deal Source Object ID
The ID of the object from which the data was migrated. This is set automatically during portal data migration.
Field IDdeals.hs_source_object_id
TypeNUMBER
Data Typedimension
Deal Tags
List of tag ids applicable to a deal. This property is set automatically by HubSpot.
Field IDdeals.hs_tag_ids
TypeTEXT
Data Typedimension
Deal Total contract value
The total contract value (TCV) of this deal.
Field IDdeals.hs_tcv
TypeNUMBER
Data Typedimension
Deal Time in 'Appointment Scheduled (Sales Pipeline)'
The total time in seconds spent by the deal in the 'Appointment Scheduled' stage, 'Sales Pipeline' pipeline
Field IDdeals.hs_time_in_appointmentscheduled
TypeNUMBER
Data Typedimension
Deal Time in 'Closed Lost (Sales Pipeline)'
The total time in seconds spent by the deal in the 'Closed Lost' stage, 'Sales Pipeline' pipeline
Field IDdeals.hs_time_in_closedlost
TypeNUMBER
Data Typedimension
Deal Time in 'Closed Won (Sales Pipeline)'
The total time in seconds spent by the deal in the 'Closed Won' stage, 'Sales Pipeline' pipeline
Field IDdeals.hs_time_in_closedwon
TypeNUMBER
Data Typedimension
Deal Time in 'Contract Sent (Sales Pipeline)'
The total time in seconds spent by the deal in the 'Contract Sent' stage, 'Sales Pipeline' pipeline
Field IDdeals.hs_time_in_contractsent
TypeNUMBER
Data Typedimension
Deal Time in 'Decision Maker Bought-In (Sales Pipeline)'
The total time in seconds spent by the deal in the 'Decision Maker Bought-In' stage, 'Sales Pipeline' pipeline
Field IDdeals.hs_time_in_decisionmakerboughtin
TypeNUMBER
Data Typedimension
Deal Time in 'Presentation Scheduled (Sales Pipeline)'
The total time in seconds spent by the deal in the 'Presentation Scheduled' stage, 'Sales Pipeline' pipeline
Field IDdeals.hs_time_in_presentationscheduled
TypeNUMBER
Data Typedimension
Deal Time in 'Qualified To Buy (Sales Pipeline)'
The total time in seconds spent by the deal in the 'Qualified To Buy' stage, 'Sales Pipeline' pipeline
Field IDdeals.hs_time_in_qualifiedtobuy
TypeNUMBER
Data Typedimension
Deal Unique creation key
Unique property used for idempotent creates
Field IDdeals.hs_unique_creation_key
TypeTEXT
Data Typedimension
Deal Updated by user ID
The user that last updated this object. This value is automatically set by HubSpot and may not be modified.
Field IDdeals.hs_updated_by_user_id
TypeNUMBER
Data Typedimension
Deal 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
Field IDdeals.hs_user_ids_of_all_notification_followers
TypeTEXT
Data Typedimension
Deal 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
Field IDdeals.hs_user_ids_of_all_notification_unfollowers
TypeTEXT
Data Typedimension
Deal User IDs of all owners
The user IDs of all owners of this object
Field IDdeals.hs_user_ids_of_all_owners
TypeTEXT
Data Typedimension
Deal Performed in an import
Object is part of an import
Field IDdeals.hs_was_imported
TypeBOOLEAN
Data Typedimension
Deal Owner Assigned Date
The date the most recent deal owner was assigned to a deal. This is updated automatically by HubSpot.
Field IDdeals.hubspot_owner_assigneddate
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Deal Name
The name given to this deal.
Field IDdeals.dealname
TypeTEXT
Data Typedimension
Deal Amount
The total amount of the deal
Field IDdeals.amount
TypeNUMBER
Data Typedimension
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.
Field IDdeals.dealstage
TypeTEXT
Data Typedimension
Deal Pipeline
The pipeline the deal is in. This determines which stages are options for the deal.
Field IDdeals.pipeline
TypeTEXT
Data Typedimension
Deal Close Date
Date the deal was closed. This property is set automatically by HubSpot.
Field IDdeals.closedate
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Deal Create Date
Date the deal was created. This property is set automatically by HubSpot.
Field IDdeals.createdate
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
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.
Field IDdeals.engagements_last_meeting_booked
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
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.
Field IDdeals.engagements_last_meeting_booked_campaign
TypeTEXT
Data Typedimension
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.
Field IDdeals.engagements_last_meeting_booked_medium
TypeTEXT
Data Typedimension
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.
Field IDdeals.engagements_last_meeting_booked_source
TypeTEXT
Data Typedimension
Deal Latest meeting activity
The date of the most recent meeting (past or upcoming) logged for, scheduled with, or booked by a contact associated with this deal.
Field IDdeals.hs_latest_meeting_activity
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Deal Recent Sales Email Replied Date
The last time a tracked sales email was replied to for this deal
Field IDdeals.hs_sales_email_last_replied
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Deal owner
User the deal is assigned to. Assign additional users to a deal record by creating a custom user property.
Field IDdeals.hubspot_owner_id
TypeTEXT
Data Typedimension
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.
Field IDdeals.notes_last_contacted
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Deal Last Activity Date
The last time a note, call, email, meeting, or task was logged for a deal. This is updated automatically by HubSpot.
Field IDdeals.notes_last_updated
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
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.
Field IDdeals.notes_next_activity_date
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Deal Number of times contacted
The total number of sales activities (notes, calls, emails, meetings, or tasks) logged for a deal. This is updated automatically by HubSpot.
Field IDdeals.num_contacted_notes
TypeNUMBER
Data Typedimension
Deal Number of Sales Activities
The total number of times a sales email or call has been logged for a deal. This is updated automatically by HubSpot.
Field IDdeals.num_notes
TypeNUMBER
Data Typedimension
Deal HubSpot Create Date
The date the deal was created. This property is set automatically by HubSpot.
Field IDdeals.hs_createdate
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Deal HubSpot Team
Primary team of the deal owner. This property is set automatically by HubSpot.
Field IDdeals.hubspot_team_id
TypeTEXT
Data Typedimension
Deal Type
The type of deal. By default, categorize your deal as either a New Business or Existing Business.
Field IDdeals.dealtype
TypeTEXT
Data Typedimension
Deal All owner ids
The value of all owner referencing properties for this object, both default and custom
Field IDdeals.hs_all_owner_ids
TypeTEXT
Data Typedimension
Deal Description
Description of the deal
Field IDdeals.description
TypeTEXT
Data Typedimension
Deal All team ids
The team ids corresponding to all owner referencing properties for this object, both default and custom
Field IDdeals.hs_all_team_ids
TypeTEXT
Data Typedimension
Deal All teams
The team ids, including up the team hierarchy, corresponding to all owner referencing properties for this object, both default and custom
Field IDdeals.hs_all_accessible_team_ids
TypeTEXT
Data Typedimension
Deal Number of Associated Contacts
The number of contacts associated with this deal. This property is set automatically by HubSpot.
Field IDdeals.num_associated_contacts
TypeNUMBER
Data Typedimension
Deal Closed Lost Reason
Reason why this deal was lost
Field IDdeals.closed_lost_reason
TypeTEXT
Data Typedimension
Deal Closed Won Reason
Reason why this deal was won
Field IDdeals.closed_won_reason
TypeTEXT
Data Typedimension
Ticket Close date
The date the ticket was closed
Field IDtickets.closed_date
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Ticket Created by
VID of contact that created the ticket
Field IDtickets.created_by
TypeNUMBER
Data Typedimension
Ticket Create date
The date the ticket was created
Field IDtickets.createdate
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Ticket First agent email response date
The date of the first email response from an agent after a ticket was created
Field IDtickets.first_agent_reply_date
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Ticket Business units
The business units this record is assigned to.
Field IDtickets.hs_all_assigned_business_unit_ids
TypeTEXT
Data Typedimension
Ticket All associated contact companies
All associated contact companies
Field IDtickets.hs_all_associated_contact_companies
TypeTEXT
Data Typedimension
Ticket All associated contact emails
All associated contact emails
Field IDtickets.hs_all_associated_contact_emails
TypeTEXT
Data Typedimension
Ticket All associated contact first names
All associated contact first names
Field IDtickets.hs_all_associated_contact_firstnames
TypeTEXT
Data Typedimension
Ticket All associated contact last names
All associated contact last names
Field IDtickets.hs_all_associated_contact_lastnames
TypeTEXT
Data Typedimension
Ticket All associated contact mobile phones
All associated contact mobile phones
Field IDtickets.hs_all_associated_contact_mobilephones
TypeTEXT
Data Typedimension
Ticket All associated contact phones
All associated contact phones
Field IDtickets.hs_all_associated_contact_phones
TypeTEXT
Data Typedimension
Ticket All conversation mentions
All mentioned users on the associated conversations
Field IDtickets.hs_all_conversation_mentions
TypeTEXT
Data Typedimension
Ticket Applied SLA Rule Config ID
Reference to the SLA rule that was applied to this ticket
Field IDtickets.hs_applied_sla_rule_config_id
TypeNUMBER
Data Typedimension
Ticket Assigned Teams
teamIds of the ticket owner(s)’ main team(s), or if ticket owner is blank, then teamId(s) of the team(s) we attempted to assign to
Field IDtickets.hs_assigned_team_ids
TypeTEXT
Data Typedimension
Ticket Assignment Method
defines how the Object Assignment is done
Field IDtickets.hs_assignment_method
TypeTEXT
Data Typedimension
Ticket Auto-generated from thread id
Thread that this ticket was automatically created for using ticket rules
Field IDtickets.hs_auto_generated_from_thread_id
TypeNUMBER
Data Typedimension
Ticket Originating Conversations Message Id
Conversations Message Id of the message that originated this ticket
Field IDtickets.hs_conversations_originating_message_id
TypeTEXT
Data Typedimension
Ticket Conversations originating thread id
Thread that this ticket was originally created for
Field IDtickets.hs_conversations_originating_thread_id
TypeNUMBER
Data Typedimension
Ticket Created by user ID
The user that created this object. This value is automatically set by HubSpot and may not be modified.
Field IDtickets.hs_created_by_user_id
TypeNUMBER
Data Typedimension
Ticket HubSpot create date
Internal read-only property representing the date the ticket was created in HubSpot
Field IDtickets.hs_createdate
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Ticket Custom inbox ID
ID of the custom inbox the ticket is associated with
Field IDtickets.hs_custom_inbox
TypeNUMBER
Data Typedimension
Ticket Date entered 'New (Support Pipeline)'
The date and time when the ticket entered the 'New' stage, 'Support Pipeline' pipeline
Field IDtickets.hs_date_entered_1
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Ticket Date entered 'Waiting on contact (Support Pipeline)'
The date and time when the ticket entered the 'Waiting on contact' stage, 'Support Pipeline' pipeline
Field IDtickets.hs_date_entered_2
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Ticket Date entered 'Waiting on us (Support Pipeline)'
The date and time when the ticket entered the 'Waiting on us' stage, 'Support Pipeline' pipeline
Field IDtickets.hs_date_entered_3
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Ticket Date entered 'Closed (Support Pipeline)'
The date and time when the ticket entered the 'Closed' stage, 'Support Pipeline' pipeline
Field IDtickets.hs_date_entered_4
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Ticket Date exited 'New (Support Pipeline)'
The date and time when the ticket exited the 'New' stage, 'Support Pipeline' pipeline
Field IDtickets.hs_date_exited_1
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Ticket Date exited 'Waiting on contact (Support Pipeline)'
The date and time when the ticket exited the 'Waiting on contact' stage, 'Support Pipeline' pipeline
Field IDtickets.hs_date_exited_2
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Ticket Date exited 'Waiting on us (Support Pipeline)'
The date and time when the ticket exited the 'Waiting on us' stage, 'Support Pipeline' pipeline
Field IDtickets.hs_date_exited_3
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Ticket Date exited 'Closed (Support Pipeline)'
The date and time when the ticket exited the 'Closed' stage, 'Support Pipeline' pipeline
Field IDtickets.hs_date_exited_4
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Ticket External object ids
Unique ids corresponding to tickets in a system outside of HubSpot
Field IDtickets.hs_external_object_ids
TypeTEXT
Data Typedimension
Ticket Last CES survey comment
Last CES survey comment that this contact gave for this ticket
Field IDtickets.hs_feedback_last_ces_follow_up
TypeTEXT
Data Typedimension
Ticket Last CES survey rating
Last CES survey rating that this contact gave for this ticket
Field IDtickets.hs_feedback_last_ces_rating
TypeTEXT
Data Typedimension
Ticket Last CES survey date
The time that this contact last submitted a CES survey response. This is automatically set by HubSpot.
Field IDtickets.hs_feedback_last_survey_date
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Ticket File upload
Files attached to a support form by a contact.
Field IDtickets.hs_file_upload
TypeTEXT
Data Typedimension
Ticket First agent response date
The date of the first response from an agent out of all associated conversations
Field IDtickets.hs_first_agent_message_sent_at
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Ticket Helpdesk Sort Timestamp
A calculated property to help with sorting in the Helpdesk
Field IDtickets.hs_helpdesk_sort_timestamp
TypeYEAR_MONTH_DAY_SECOND
Data Typemetric
Ticket In Help Desk
Is this Ticket rendered in the Help Desk
Field IDtickets.hs_in_helpdesk
TypeBOOLEAN
Data Typedimension
Ticket Inbox ID
Inbox the ticket is in
Field IDtickets.hs_inbox_id
TypeNUMBER
Data Typedimension
Ticket Is Visible in Help desk
Whether the ticket is visible in help desk
Field IDtickets.hs_is_visible_in_help_desk
TypeBOOLEAN
Data Typemetric
Ticket Last email activity
The type of the last email activity with the contact associated with the ticket.
Field IDtickets.hs_last_email_activity
TypeTEXT
Data Typedimension
Ticket Last email date
The date of the last email activity with the contact associated with the ticket.
Field IDtickets.hs_last_email_date
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Ticket Last message from visitor
Whether the last message came from visitor
Field IDtickets.hs_last_message_from_visitor
TypeBOOLEAN
Data Typemetric
Ticket Last message received date
The date of the last response from the visitor
Field IDtickets.hs_last_message_received_at
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Ticket Last response date
The date of the last response from an agent or bot
Field IDtickets.hs_last_message_sent_at
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Ticket Last activity date
The last time a note, call, email, meeting, or task was logged for a ticket. This is updated automatically by HubSpot.
Field IDtickets.hs_lastactivitydate
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Ticket 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.
Field IDtickets.hs_lastcontacted
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Ticket 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.
Field IDtickets.hs_lastmodifieddate
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Ticket Latest message seen by agent ids
Agents who have seen the newest message across all conversations associated to the ticket
Field IDtickets.hs_latest_message_seen_by_agent_ids
TypeTEXT
Data Typedimension
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.
Field IDtickets.hs_merged_object_ids
TypeTEXT
Data Typedimension
Ticket Most relevant SLA status
Most relevant sla status
Field IDtickets.hs_most_relevant_sla_status
TypeTEXT
Data Typedimension
Ticket Most Relevant SLA Type
Most relevant SLA type between Close By, First Response, Next Response
Field IDtickets.hs_most_relevant_sla_type
TypeTEXT
Data Typedimension
Microsoft Teams message ID for this ticket.
Microsoft Teams message ID for this ticket.
Field IDtickets.hs_msteams_message_id
TypeTEXT
Data Typedimension
Ticket 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.
Field IDtickets.hs_nextactivitydate
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Ticket Number of Associated Companies
Number of companies associated with this ticket
Field IDtickets.hs_num_associated_companies
TypeNUMBER
Data Typedimension
Ticket Number of Associated Conversations
Number of conversations associated to the ticket
Field IDtickets.hs_num_associated_conversations
TypeNUMBER
Data Typedimension
Ticket Number of times contacted
The number of times a call, email, or meeting was logged on the ticket
Field IDtickets.hs_num_times_contacted
TypeNUMBER
Data Typedimension
Ticket Record ID
The unique ID for this record. This value is automatically set by HubSpot and may not be modified.
Field IDtickets.hs_object_id
TypeNUMBER
Data Typedimension
Ticket Record Creation Source
Source (PropertySource) that created this object record
Field IDtickets.hs_object_source
TypeTEXT
Data Typedimension
Ticket Record Creation Source ID
The sourceId -- further detail -- of the source that created this object record
Field IDtickets.hs_object_source_id
TypeTEXT
Data Typedimension
Ticket Record Source
How this record was created
Field IDtickets.hs_object_source_label
TypeTEXT
Data Typedimension
Ticket Record Creation Source User ID
User ID of the user who initiated creation of this object record
Field IDtickets.hs_object_source_user_id
TypeNUMBER
Data Typedimension
Ticket Originating channel account
First channel account used when conversation was started
Field IDtickets.hs_originating_channel_instance_id
TypeTEXT
Data Typedimension
Ticket Originating email engagement id
Engagement id of the email originating this ticket
Field IDtickets.hs_originating_email_engagement_id
TypeNUMBER
Data Typedimension
Ticket Originating channel type
The channel the conversation is in
Field IDtickets.hs_originating_generic_channel_id
TypeTEXT
Data Typedimension
Ticket Pinned Engagement ID
The object ID of the current pinned engagement. This value is automatically set by HubSpot and may not be modified.
Field IDtickets.hs_pinned_engagement_id
TypeNUMBER
Data Typedimension
Ticket Pipeline
The pipeline that contains this ticket
Field IDtickets.hs_pipeline
TypeTEXT
Data Typedimension
Ticket status
The pipeline stage that contains this ticket
Field IDtickets.hs_pipeline_stage
TypeTEXT
Data Typedimension
Ticket Primary Company
Primary company of a ticket
Field IDtickets.hs_primary_company
TypeTEXT
Data Typedimension
Ticket Primary Company ID
Primary company ID of a ticket
Field IDtickets.hs_primary_company_id
TypeNUMBER
Data Typedimension
Ticket Primary Company Name
Primary company name of a ticket
Field IDtickets.hs_primary_company_name
TypeTEXT
Data Typedimension
Ticket Read Only Object
Is the object read only
Field IDtickets.hs_read_only
TypeBOOLEAN
Data Typedimension
Ticket Resolution
The action taken to resolve the ticket
Field IDtickets.hs_resolution
TypeTEXT
Data Typedimension
Ticket Users interaction
Stores a list of users who have viewed the most recent interaction on a ticket
Field IDtickets.hs_seen_by_agent_ids
TypeTEXT
Data Typedimension
Ticket Source Object ID
The ID of the object from which the data was migrated. This is set automatically during portal data migration.
Field IDtickets.hs_source_object_id
TypeNUMBER
Data Typedimension
Ticket Tags IDs
List of tag ids applicable to a ticket. This property is set automatically by HubSpot.
Field IDtickets.hs_tag_ids
TypeTEXT
Data Typedimension
Ticket Thread IDs To Restore
Thread IDs (from cv-threads) used to implement custom cascading delete/restore
Field IDtickets.hs_thread_ids_to_restore
TypeTEXT
Data Typedimension
Ticket Category
Main reason customer reached out for help
Field IDtickets.hs_ticket_category
TypeTEXT
Data Typedimension
Ticket ID
The unique id for this ticket. This unique id is automatically populated by HubSpot.
Field IDtickets.hs_ticket_id
TypeNUMBER
Data Typemetric
Ticket Priority
The level of attention needed on the ticket
Field IDtickets.hs_ticket_priority
TypeTEXT
Data Typedimension
Ticket Time in 'New (Support Pipeline)'
The total time in seconds spent by the ticket in the 'New' stage, 'Support Pipeline' pipeline
Field IDtickets.hs_time_in_1
TypeNUMBER
Data Typedimension
Ticket 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
Field IDtickets.hs_time_in_2
TypeNUMBER
Data Typedimension
Ticket 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
Field IDtickets.hs_time_in_3
TypeNUMBER
Data Typedimension
Ticket Time in 'Closed (Support Pipeline)'
The total time in seconds spent by the ticket in the 'Closed' stage, 'Support Pipeline' pipeline
Field IDtickets.hs_time_in_4
TypeNUMBER
Data Typedimension
Ticket Time to Close SLA Due Date
When the ticket falls out of Time to Close SLA.
Field IDtickets.hs_time_to_close_sla_at
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Time to Close SLA Ticket Status
Current Time to Close SLA status of ticket
Field IDtickets.hs_time_to_close_sla_status
TypeTEXT
Data Typedimension
Ticket Time to First Response SLA Due Date
When the ticket falls out of the Time to First Response SLA
Field IDtickets.hs_time_to_first_response_sla_at
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Ticket Time to First Response SLA Status
Current Time to First Response SLA status.
Field IDtickets.hs_time_to_first_response_sla_status
TypeTEXT
Data Typedimension
Ticket Time to Next Response SLA Due Date
When the ticket falls out of Time to Next Response SLA
Field IDtickets.hs_time_to_next_response_sla_at
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Ticket Time to Next Response SLA Status
Current Time to Next Response SLA status
Field IDtickets.hs_time_to_next_response_sla_status
TypeTEXT
Data Typedimension
Ticket Unique creation key
Unique property used for idempotent creates
Field IDtickets.hs_unique_creation_key
TypeTEXT
Data Typedimension
Ticket Updated by user ID
The user that last updated this object. This value is automatically set by HubSpot and may not be modified.
Field IDtickets.hs_updated_by_user_id
TypeNUMBER
Data Typedimension
Ticket 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
Field IDtickets.hs_user_ids_of_all_notification_followers
TypeTEXT
Data Typedimension
Ticket 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
Field IDtickets.hs_user_ids_of_all_notification_unfollowers
TypeTEXT
Data Typedimension
Ticket User IDs of all owners
The user IDs of all owners of this object
Field IDtickets.hs_user_ids_of_all_owners
TypeTEXT
Data Typedimension
Ticket Performed in an import
Object is part of an import
Field IDtickets.hs_was_imported
TypeBOOLEAN
Data Typedimension
Ticket Owner assigned date
The date an owner was assigned to the ticket
Field IDtickets.hubspot_owner_assigneddate
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Ticket Date of last engagement
The date of the last reply or note
Field IDtickets.last_engagement_date
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Ticket Last customer reply date
The date of the last customer response
Field IDtickets.last_reply_date
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Ticket NPS follow up
Answer to NPS follow up question
Field IDtickets.nps_follow_up_answer
TypeTEXT
Data Typedimension
Ticket NPS follow up question
Specific version of NPS follow up question that was asked
Field IDtickets.nps_follow_up_question_version
TypeNUMBER
Data Typedimension
Ticket Conversation NPS score
NPS score received after ticket resolution
Field IDtickets.nps_score
TypeTEXT
Data Typedimension
Ticket Reference to email thread
The id of an email thread with ticket conversation
Field IDtickets.source_thread_id
TypeTEXT
Data Typedimension
Ticket Time to close
The time between when the ticket was created and closed
Field IDtickets.time_to_close
TypeNUMBER
Data Typemetric
Ticket Time to first agent email reply
The time from the ticket create date to the first agent email reply
Field IDtickets.time_to_first_agent_reply
TypeNUMBER
Data Typedimension
Ticket name
Short summary of ticket
Field IDtickets.subject
TypeTEXT
Data Typedimension
Ticket description
Description of the ticket
Field IDtickets.content
TypeTEXT
Data Typedimension
Ticket Source
Channel where ticket was originally submitted
Field IDtickets.source_type
TypeTEXT
Data Typedimension
Ticket Reference to source-specific object
The id of a connected source object
Field IDtickets.source_ref
TypeTEXT
Data Typedimension
Ticket Tags
Tags associated with your tickets
Field IDtickets.tags
TypeTEXT
Data Typedimension
Ticket Recent Sales Email Replied Date
The last time a tracked sales email was replied to for this ticket
Field IDtickets.hs_sales_email_last_replied
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Ticket owner
User the ticket is assigned to. Assign additional users to a ticket record by creating a custom user property.
Field IDtickets.hubspot_owner_id
TypeTEXT
Data Typedimension
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.
Field IDtickets.notes_last_contacted
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
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.
Field IDtickets.notes_last_updated
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Next Activity Date (Ticket Note)
The date of the next upcoming activity for this ticket
Field IDtickets.notes_next_activity_date
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Number of times contacted (Ticket Note)
The number of times a call, email or meeting was logged for this ticket
Field IDtickets.num_contacted_notes
TypeNUMBER
Data Typedimension
Ticket Number of Sales Activities
The number of times a call, chat conversation, LinkedIn message, postal mail, meeting, note, sales email, SMS, task, or WhatsApp message was logged for a ticket record. This is set automatically by HubSpot based on user actions in the ticket record.
Field IDtickets.num_notes
TypeNUMBER
Data Typedimension
Ticket HubSpot team
Primary team of the ticket owner. This property is set automatically by HubSpot.
Field IDtickets.hubspot_team_id
TypeTEXT
Data Typedimension
Ticket All owner ids
The value of all owner referencing properties for this object, both default and custom
Field IDtickets.hs_all_owner_ids
TypeTEXT
Data Typedimension
Ticket All team ids
The team IDs, including up the team hierarchy, corresponding to all owner referencing properties for this object, both default and custom
Field IDtickets.hs_all_team_ids
TypeTEXT
Data Typedimension
Ticket All teams
The team IDs, including up the team hierarchy, corresponding to all owner referencing properties for this object, both default and custom
Field IDtickets.hs_all_accessible_team_ids
TypeTEXT
Data Typedimension
Extracted Date
The date where the extraction take times.
Field ID_catchr_date_extract
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Platform Name
Return the platform name
Field ID_catchr_platform_name
TypeTEXT
Data Typedimension