Contacts

Retrieve available contacts in HubSpot. This table supports both OAuth and PrivateAppToken authentication methods.

Table Specific Information

In HubSpot, contacts store information about individuals. The lead-specific data contained in contact records supports various functionalities, from marketing automation to smart content, helping users make the most of the platform.

SELECT

When selecting contacts, filtering is supported primarily by specific fields like Email or a custom unique identifier property. While some columns are marked as 'Filterable', server-side filtering is only truly effective for fields that HubSpot's API natively supports, such as email or properties specifically created as unique identifiers. For all other fields, the driver performs client-side filtering, retrieving a broader dataset from HubSpot and applying filters locally.

For example, for fields like Email, you can perform server-side filtering directly using the API:

SELECT * FROM Contacts WHERE Email = '[email protected]'
SELECT * FROM Contacts WHERE Email != '[email protected]'

For fields not natively supported by the API for server-side filtering, the query retrieves all contacts from HubSpot and applies filters locally:

SELECT * FROM Contacts WHERE [Company Name] = 'CData' OR [Last Name] = 'Robinson'
SELECT * FROM Contacts WHERE [Associated Deals] = 3 AND [First Deal Created Date] > '2019-01-01'

HubSpot also supports querying using custom unique identifier properties if these have been defined. For example:

SELECT * FROM Contacts WHERE CustomUniqueId = '12345'

INSERT

INSERT INTO Contacts ([Field of study]) VALUES ('uni')

UPDATE

UPDATE Contacts SET [Field of study] = 'new uni' WHERE ID = '25151'

DELETE

DELETE FROM Contacts WHERE ID = '25151'

Columns


Name	Type	ReadOnly	References	Filterable	Description
Id [KEY]	Long	False		True	Unique identifier of the object.
Archived	Bool	True		False	Whether the object is archived or not.
CreatedAt	Datetime	True		False	When the object was created.
UpdatedAt	Datetime	True		False	When the object was last updated.
ItemURL	String	True		False	Url that points directly to the HubSpot item.
Company size	String	False		True	Contact's company size. Required for the Facebook Ads Integration. Automatically synced from the Lead Ads tool.
Date of birth	String	False		True	Contact's date of birth. Required for the Facebook Ads Integration. Automatically synced from the Lead Ads tool.
Days To Close	Decimal	True		True	Count of days elapsed between creation and being closed as a customer. Set automatically.
Degree	String	False		True	Contact's degree. Required for the Facebook Ads Integration. Automatically synced from the Lead Ads tool.
Field of study	String	False		True	Contact's field of study. Required for the Facebook Ads Integration. Automatically synced from the Lead Ads tool.
First Conversion Date	Datetime	True		True	Date this contact first submitted a form.
First Conversion	String	True		True	First form this contact submitted.
First Deal Created Date	Datetime	True		True	Date first deal was created for contact. Set automatically.
Gender	String	False		True	Contact's gender. Required for the Facebook Ads Integration. Automatically synced from the Lead Ads tool.
Graduation date	String	False		True	Contact's graduation date. Required for the Facebook Ads Integration. Automatically synced from the Lead Ads tool.
Additional email addresses	String	True		True	A set of additional email addresses for a contact
Business units	String	False		True	The business units this record is assigned to.
All vids for a contact	String	True		True	A set of all vids_ canonical or otherwise_ for a contact
First Touch Converting Campaign	String	True		True	Campaign responsible for the first touch creation of this contact.
Last Touch Converting Campaign	String	True		True	Campaign responsible for the last touch creation of this contact.
Avatar FileManager key	String	True		True	The path in the FileManager CDN for this contact's avatar override image. Automatically set by HubSpot.
Buying Role	String	False		True	Role the contact plays during the sales process. Contacts can have multiple roles_ and can share roles with others.
All form submissions for a contact	String	True		True	A set of all form submissions for a contact
Merged vids with timestamps of a contact	String	True		True	Merged vids with timestamps of a contact
Calculated Mobile Number in International Format	String	True		True	Mobile number in international format
Calculated Phone Number in International Format	String	True		True	Phone number in international format
Calculated Phone Number Area Code	String	True		True	Area Code of the calculated phone number
Calculated Phone Number Country Code	String	True		True	Country code of the calculated phone number
Calculated Phone Number Region	String	True		True	ISO2 Country code for the derived phone number
Clicked on a LinkedIn Ad	String	False		True	Whether contact has clicked on a LinkedIn Ad
Email Confirmed	Bool	True		True	Email Confirmation status of user of Content Membership
Registration Follow Up Email Enqueued At	Datetime	False		True	The time when the first registration follow up email was enqueued
Membership Notes	String	False		True	Notes relating to the contact's content membership.
Registered At	Datetime	True		True	Datetime at which this user was set up for Content Membership
Domain to which registration email was sent	String	True		True	Domain to which the registration invitation email for Content Membership was sent to
Time registration email was sent	Datetime	True		True	Datetime at which this user was sent a registration invitation email for Content Membership
Status	String	False		True	Status of the contact's content membership.
Conversations visitor email	String	True		True	A Conversations visitor's email address
Count of unengaged contacts	Decimal	True		True	if contact is assigned and unworked_ set to 1. if contact is assigned and worked_ set to 0.
Count of engaged contacts	Decimal	True		True	if contact is assigned and worked_ set to 1. if contact is assigned and unworked_ set to 0.
Created By Conversations	Bool	True		True	Flag indicating this contact was created by the Conversations API
Created by user ID	Decimal	True		True	The user that created this object. This value is automatically set by HubSpot and may not be modified.
Object create date_time	Datetime	True		True	The date and time at which this object was created. This value is automatically set by HubSpot and may not be modified.
Date entered 'Customer _Lifecycle Stage Pipeline_'	Datetime	True		True	The date and time when the contact entered the 'Customer' stage_ 'Lifecycle Stage Pipeline' pipeline
Date entered 'Evangelist _Lifecycle Stage Pipeline_'	Datetime	True		True	The date and time when the contact entered the 'Evangelist' stage_ 'Lifecycle Stage Pipeline' pipeline
Date entered 'Lead _Lifecycle Stage Pipeline_'	Datetime	True		True	The date and time when the contact entered the 'Lead' stage_ 'Lifecycle Stage Pipeline' pipeline
Date entered 'Marketing Qualified Lead _Lifecycle Stage Pipeline_'	Datetime	True		True	The date and time when the contact entered the 'Marketing Qualified Lead' stage_ 'Lifecycle Stage Pipeline' pipeline
Date entered 'Opportunity _Lifecycle Stage Pipeline_'	Datetime	True		True	The date and time when the contact entered the 'Opportunity' stage_ 'Lifecycle Stage Pipeline' pipeline
Date entered 'Other _Lifecycle Stage Pipeline_'	Datetime	True		True	The date and time when the contact entered the 'Other' stage_ 'Lifecycle Stage Pipeline' pipeline
Date entered 'Sales Qualified Lead _Lifecycle Stage Pipeline_'	Datetime	True		True	The date and time when the contact entered the 'Sales Qualified Lead' stage_ 'Lifecycle Stage Pipeline' pipeline
Date entered 'Subscriber _Lifecycle Stage Pipeline_'	Datetime	True		True	The date and time when the contact entered the 'Subscriber' stage_ 'Lifecycle Stage Pipeline' pipeline
Date exited 'Customer _Lifecycle Stage Pipeline_'	Datetime	True		True	The date and time when the contact exited the 'Customer' stage_ 'Lifecycle Stage Pipeline' pipeline
Date exited 'Evangelist _Lifecycle Stage Pipeline_'	Datetime	True		True	The date and time when the contact exited the 'Evangelist' stage_ 'Lifecycle Stage Pipeline' pipeline
Date exited 'Lead _Lifecycle Stage Pipeline_'	Datetime	True		True	The date and time when the contact exited the 'Lead' stage_ 'Lifecycle Stage Pipeline' pipeline
Date exited 'Marketing Qualified Lead _Lifecycle Stage Pipeline_'	Datetime	True		True	The date and time when the contact exited the 'Marketing Qualified Lead' stage_ 'Lifecycle Stage Pipeline' pipeline
Date exited 'Opportunity _Lifecycle Stage Pipeline_'	Datetime	True		True	The date and time when the contact exited the 'Opportunity' stage_ 'Lifecycle Stage Pipeline' pipeline
Date exited 'Other _Lifecycle Stage Pipeline_'	Datetime	True		True	The date and time when the contact exited the 'Other' stage_ 'Lifecycle Stage Pipeline' pipeline
Date exited 'Sales Qualified Lead _Lifecycle Stage Pipeline_'	Datetime	True		True	The date and time when the contact exited the 'Sales Qualified Lead' stage_ 'Lifecycle Stage Pipeline' pipeline
Date exited 'Subscriber _Lifecycle Stage Pipeline_'	Datetime	True		True	The date and time when the contact exited the 'Subscriber' stage_ 'Lifecycle Stage Pipeline' pipeline
Recent Document Revisit Date	Datetime	True		True	The last time a shared document _presentation_ was accessed by this contact
Invalid email address	Bool	True		True	The email address associated with this contact is invalid.
Email address quarantine reason	String	False		True	The reason why the email address has been quarantined.
Email Domain	String	True		True	A contact's email address domain
Email hard bounce reason	String	True		True	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.
Email hard bounce reason2	String	True		True	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.
Email Address Quarantined	Bool	True		True	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.
Email address automated quarantine reason	String	True		True	The automated reason why the email address has been quarantined.
Email Address Recipient Fatigue Next Available Sending Time	Datetime	True		True	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.
Sends Since Last Engagement	Decimal	True		True	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.
Marketing email confirmation status	String	True		True	The status of a contact's eligibility to receive marketing email. This is automatically set by HubSpot.
Clicked Facebook ad	Bool	False		True	Whether contact has clicked a Facebook ad
Facebook click id	String	False		True
Facebook ID	String	False		True	A contact's facebook id
Last NPS survey comment	String	True		True	Last NPS survey comment that this contact gave
Last NPS survey rating	String	True		True	Last NPS survey rating that this contact gave
Last NPS survey date	Datetime	True		True	The time that this contact last submitted a NPS survey response. This is automatically set by HubSpot.
Should be shown an NPS web survey	Bool	False		True	Whether or not a contact should be shown an NPS web survey. This is automatically set by HubSpot.
ID of first engagement	Decimal	True		True	The object id of the current contact owner's first engagement with the contact. Used in Sales Analytics app.
First subscription create date	Datetime	True		True	The create date of the first subscription by the contact.
Google ad click id	String	False		True
googleplus ID	String	False		True	A contact's googleplus id
Contact has an active subscription	Decimal	True		True	The rollup property value is 1 when the contact has an active Subscription or 0 otherwise.
IP Timezone	String	True		True	The timezone reported by a contact's IP address. This is automatically set by HubSpot and can be used for segmentation and reporting.
Is a contact	Bool	True		True	Is a contact_ has not been deleted and is not a visitor
Contact unworked	Bool	True		True	Contact has not been assigned or has not been engaged after last owner assignment_re_assignment
last sales activity date old	Datetime	True		True	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.
Last Engagement Date	Datetime	True		True	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.
Last Engagement Type	String	True		True	The type of the last engagement a contact performed. This doesn't include marketing emails or emails to multiple contacts.
Object last modified date_time	Datetime	True		True	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.
Last sequence ended date	Datetime	True		True	The last sequence ended date.
Last sequence enrolled	Decimal	True		True	The last sequence enrolled.
Last sequence enrolled date	Datetime	True		True	The last sequence enrolled date.
Last sequence finished date	Datetime	True		True	The last sequence finished date.
Last sequence unenrolled date	Datetime	True		True	The last sequence unenrolled date.
Latest Source Date	Date	False		True	The time of the latest session for a contact
Latest subscription create date	Datetime	True		True	The create date of the latest subscription by the contact.
Lead Status	String	False		True	The contact's sales_ prospecting or outreach status
Legal basis for processing contact's data	String	False		True	Legal basis for processing contact's data_ 'Not applicable' will exempt the contact from GDPR protections
Clicked LinkedIn Ad	String	False		True
Linkedin ID	String	False		True	A contact's linkedin id
Marketing contact status source name	String	True		True	The ID of the activity that set the contact as a marketing contact
Marketing contact status source type	String	True		True	The type of the activity that set the contact as a marketing contact
Marketing contact status	String	True		True	The marketing status of a contact
Marketing contact until next update	String	True		True	Specifies if this contact will be set as non_marketing on renewal
Merged object IDs	String	True		True	The list of object IDs that have been merged into this object. This value is automatically set by HubSpot and may not be modified.
Record ID	Decimal	True		True	The unique ID for this record. This value is automatically set by HubSpot and may not be modified.
Pinned engagement ID	Decimal	True		True
Pipeline	String	False		True	The pipeline with which this contact is currently associated
Likelihood to close	Decimal	True		True	The probability that a contact will become a customer within the next 90 days. This score is based on standard contact properties and behavior.
Contact priority	String	True		True	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.
Read Only Object	Bool	True		True	Is the object read only
Date of first engagement	Datetime	True		True	The date the current contact owner first engaged with the contact. Used in Sales Analytics app.
Description of first engagement	String	True		True	A description of the current contact owner's first engagement with the contact. Used in the Sales Analytics app.
Type of first engagement	String	True		True	The object type of the current contact owner's first engagement with the contact. Used in the Sales Analytics app.
Recent Sales Email Clicked Date	Datetime	True		True	The last time a tracked sales email was clicked by this user
Recent Sales Email Opened Date	Datetime	True		True	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.
Calculated Mobile Number with country code	String	True		True	Mobile number with country code
Calculated Phone Number with country code	String	True		True	Phone number with country code
Calculated Mobile Number without country code	String	True		True	Mobile number without country code
Calculated Phone Number without country code	String	True		True	Phone number without country code
Number of sequences actively enrolled	Decimal	True		True	The number of sequences actively enrolled.
Number of sequences enrolled	Decimal	True		True	The number of sequences enrolled.
Currently in Sequence	Bool	True		True	A yes_no field that indicates whether the contact is currently in a Sequence.
testpurge	String	True		True	testing purge
testrollback	String	True		True	testing rollback
Time between contact creation and deal close	Decimal	False		True
Time between contact creation and deal creation	Decimal	False		True
Time in 'Customer _Lifecycle Stage Pipeline_'	Decimal	True		True	The total time in seconds spent by the contact in the 'Customer' stage_ 'Lifecycle Stage Pipeline' pipeline
Time in 'Evangelist _Lifecycle Stage Pipeline_'	Decimal	True		True	The total time in seconds spent by the contact in the 'Evangelist' stage_ 'Lifecycle Stage Pipeline' pipeline
Time in 'Lead _Lifecycle Stage Pipeline_'	Decimal	True		True	The total time in seconds spent by the contact in the 'Lead' stage_ 'Lifecycle Stage Pipeline' pipeline
Time in 'Marketing Qualified Lead _Lifecycle Stage Pipeline_'	Decimal	True		True	The total time in seconds spent by the contact in the 'Marketing Qualified Lead' stage_ 'Lifecycle Stage Pipeline' pipeline
Time in 'Opportunity _Lifecycle Stage Pipeline_'	Decimal	True		True	The total time in seconds spent by the contact in the 'Opportunity' stage_ 'Lifecycle Stage Pipeline' pipeline
Time in 'Other _Lifecycle Stage Pipeline_'	Decimal	True		True	The total time in seconds spent by the contact in the 'Other' stage_ 'Lifecycle Stage Pipeline' pipeline
Time in 'Sales Qualified Lead _Lifecycle Stage Pipeline_'	Decimal	True		True	The total time in seconds spent by the contact in the 'Sales Qualified Lead' stage_ 'Lifecycle Stage Pipeline' pipeline
Time in 'Subscriber _Lifecycle Stage Pipeline_'	Decimal	True		True	The total time in seconds spent by the contact in the 'Subscriber' stage_ 'Lifecycle Stage Pipeline' pipeline
Lead response time	Decimal	True		True	Time it took current owner to do first qualifying engagement _ms_. Used in Sales Analytics app.
Time to move from lead to customer	Decimal	False		True	How long it takes for a contact to move from the HubSpot lead stage to the HubSpot customer stage.
Time to move from marketing qualified lead to customer	Decimal	False		True	How long it takes for a contact to move from the HubSpot marketing qualified lead stage to the HubSpot customer stage.
Time to move from opportunity to customer	Decimal	False		True	How long it takes for a contact to move from the HubSpot opportunity stage to the HubSpot customer stage.
Time to move from sales qualified lead to customer	Decimal	False		True	How long it takes for a contact to move from the HubSpot sales qualified lead stage to the HubSpot customer stage.
Time to move from subscriber to customer	Decimal	False		True	How long it takes for a contact to move from the HubSpot subscriber stage to the HubSpot customer stage.
Time Zone	String	False		True	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.
Twitter ID	String	False		True	A contact's twitter id
Unique creation key	String	True		True	Unique property used for idempotent creates
Updated by user ID	Decimal	True		True	The user that last updated this object. This value is automatically set by HubSpot and may not be modified.
User IDs of all notification followers	String	True		True	The user IDs of all users that have clicked follow within the object to opt_in to getting follow notifications
User IDs of all notification unfollowers	String	True		True	The user IDs of all object owners that have clicked unfollow within the object to opt_out of getting follow notifications
User IDs of all owners	String	True		True	The user IDs of all owners of this object
WhatsApp Phone Number	String	False		True	The phone number associated with the contact_s WhatsApp account.
Owner Assigned Date	Datetime	True		True	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.
IP City	String	True		True	The city reported by a contact's IP address. This is automatically set by HubSpot and can be used for segmentation and reporting.
IP Country	String	True		True	The country reported by a contact's IP address. This is automatically set by HubSpot and can be used for segmentation and reporting.
IP Country Code	String	True		True	The country code reported by a contact's IP address. This is automatically set by HubSpot and can be used for segmentation and reporting.
IP Latitude _ Longitude	String	True		True
IP State_Region	String	True		True	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.
IP State Code_Region Code	String	True		True	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.
IP Zipcode	String	True		True	The zipcode reported by a contact's IP address. This is automatically set by HubSpot and can be used for segmentation and reporting.
Job function	String	False		True	Contact's job function. Required for the Facebook Ads Integration. Automatically synced from the Lead Ads tool.
Last Modified Date	Datetime	True		True	The date any property on this contact was modified
Marital Status	String	False		True	Contact's marital status. Required for the Facebook Ads Integration. Automatically synced from the Lead Ads tool.
Military status	String	False		True	Contact's military status. Required for the Facebook Ads Integration. Automatically synced from the Lead Ads tool.
Number of Associated Deals	Decimal	True		True	Count of deals associated with this contact. Set automatically by HubSpot.
Number of Form Submissions	Decimal	True		True	The number of forms this contact has submitted
Number of Unique Forms Submitted	Decimal	True		True	The number of different forms this contact has submitted
Recent Conversion Date	Datetime	True		True	The date this contact last submitted a form
Recent Conversion	String	True		True	The last form this contact submitted
Recent Deal Amount	Decimal	True		True	Amount of last closed won deal associated with a contact. Set automatically.
Recent Deal Close Date	Datetime	True		True	Date last deal associated with contact was closed_won. Set automatically.
Relationship Status	String	False		True	Contact's relationship status. Required for the Facebook Ads Integration. Automatically synced from the Lead Ads tool.
School	String	False		True	Contact's school. Required for the Facebook Ads Integration. Automatically synced from the Lead Ads tool.
Seniority	String	False		True	Contact's seniority. Required for the Facebook Ads Integration. Automatically synced from the Lead Ads tool.
Start date	String	False		True	Contact's start date. Required for the Facebook Ads Integration. Automatically synced from the Lead Ads tool.
Total Revenue	Decimal	True		True	Sum of all closed_won deal revenue associated with the contact. Set automatically.
Work email	String	False		True	Contact's work email. Required for the Facebook Ads Integration. Automatically synced from the Lead Ads tool.
First Name	String	False		True	A contact's first name
First Page Seen	String	True		True	First page the contact visited on your website. Set automatically.
Marketing emails delivered	Decimal	True		True	The number of marketing emails delivered for the current email address. This is automatically set by HubSpot.
Opted out of emailCustomer Service Communication	String	True		True	Indicates that the current email address has opted out of this email type.
Opted out of emailOne to One	String	True		True	This column is a custom field. Indicates that the current email address has opted out of this email type.
Twitter Username	String	False		True	The contact's Twitter handle.
Currently in workflow	String	True		True	True when contact is enrolled in a workflow.
Follower Count	Decimal	False		True	The number of Twitter followers a contact has
Last Page Seen	String	True		True	Last page the contact visited on your website. Set automatically.
Marketing emails opened	Decimal	True		True	The number of marketing emails opened for the current email address. This is automatically set by HubSpot.
Last Name	String	False		True	A contact's last name
Number of Pageviews	Decimal	True		True	Total number of page views this contact has had on your website. Set automatically.
Marketing emails clicked	Decimal	True		True	The number of marketing emails which have had link clicks for the current email address. This is automatically set by HubSpot.
Salutation	String	False		True	The title used to address a contact
Twitter Profile Photo	String	False		True	The contact's Twitter profile photo. This is set by HubSpot using the contact's email address.
Email	String	False		True	A contact's email address
Number of Sessions	Decimal	True		True	Number of times a contact has come to your website. Set automatically.
Marketing emails bounced	Decimal	True		True	The number of marketing emails that bounced for the current email address. This is automatically set by HubSpot.
Persona	String	False		True	A contact's persona
Most Recent Social Click	Datetime	True		True	The date of the most recent click on a published social message. This is set automatically by HubSpot for each contact.
Number of event completions	Decimal	True		True	Total number of events for this contact. Set automatically.
Unsubscribed from all email	Bool	True		True	Indicates that the current email address has opted out of all email.
Twitter Clicks	Decimal	True		True	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.
Mobile Phone Number	String	False		True	A contact's mobile phone number
Phone Number	String	False		True	A contact's primary phone number
Fax Number	String	False		True	A contact's primary fax number
Time First Seen	Datetime	True		True	First time the contact has been seen. Set automatically.
Last marketing email name	String	True		True	The name of the last marketing email sent to the current email address. This is automatically set by HubSpot.
Last marketing email send date	Datetime	True		True	The date of the most recent delivery for any marketing email to the current email address. This is automatically set by HubSpot.
Facebook Clicks	Decimal	True		True	The number clicks on links shared on Facebook
Street Address	String	False		True	Contact's street address_ including apartment or unit number.
Date of last meeting booked in meetings tool	Datetime	True		True	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.
Campaign of last booking in meetings tool	String	True		True	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.
Medium of last booking in meetings tool	String	True		True	UTM parameter for the channel _e.g. email_ responsible for most recent meeting booking. Only populated when tracking parameters are included in meeting link.
Source of last booking in meetings tool	String	True		True	UTM parameter for the site _e.g. Twitter_ responsible for most recent meeting booking. Only populated when tracking parameters are included in meeting link.
Time of First Session	Datetime	True		True	First time the contact visited your website. Set automatically.
Last marketing email open date	Datetime	True		True	The date of the most recent open for any marketing email to the current email address. This is automatically set by HubSpot.
Latest meeting activity	Datetime	True		True	The date of the most recent meeting _past or upcoming_ logged for_ scheduled with_ or booked by this contact.
Recent Sales Email Replied Date	Datetime	True		True	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.
LinkedIn Clicks	Decimal	True		True	The number clicks on links shared on LinkedIn
Contact owner	String	False		True	The owner of a contact. This can be any HubSpot user or Salesforce integration user_ and can be set manually or via Workflows.
Last Contacted	Datetime	True		True	The last time a call_ email_ or meeting was logged for a contact. This is set automatically by HubSpot based on user actions in the contact record.
Last Activity Date	Datetime	True		True	The last time a note_ call_ email_ meeting_ or task was logged for a contact. This is set automatically by HubSpot based on user actions in the contact record.
Next Activity Date	Datetime	True		True	The date of the next upcoming activity for a contact. This is set automatically by HubSpot based on user actions in the contact record.
Number of times contacted	Decimal	True		True	The number of times a call_ email_ or meeting was logged for a contact. This is set automatically by HubSpot based on user actions in the contact record.
Number of Sales Activities	Decimal	True		True	The number of sales activities for a contact. This is set automatically by HubSpot based on user actions in the contact record.
HubSpot Owner Email _legacy_	String	False		True	A legacy property used to identify the email address of the owner of the contact. This property is no longer in use.
HubSpot Owner Name _legacy_	String	False		True	A legacy property used to identify the name of the owner of the contact. This property is no longer in use.
SurveyMonkey Event Last Updated	Decimal	True		True	This field is meaningless on its own_ and is solely used for triggering dynamic list updates when SurveyMonkey information is updated
Webinar Event Last Updated	Decimal	True		True	This field is meaningless on its own_ and is solely used for triggering dynamic list updates when webinar information is updated
City	String	False		True	A contact's city of residence
Time Last Seen	Datetime	True		True	Timestamp for most recent webpage view on your website.
Last marketing email click date	Datetime	True		True	The date of the most recent link click for any marketing email to the current email address. This is automatically set by HubSpot.
Google Plus Clicks	Decimal	True		True	The number clicks on links shared on Google Plus
HubSpot Team	String	True		True	The team of the owner of a contact.
LinkedIn Bio	String	False		True	A contact's LinkedIn bio
Twitter Bio	String	False		True	The contact's Twitter bio. This is set by HubSpot using the contact's email address.
All owner ids	String	True		True	The value of all owner referencing properties for this object_ both default and custom
Time of Last Session	Datetime	True		True	Timestamp for start of the most recent session for this contact to your website.
First marketing email send date	Datetime	True		True	The date of the earliest delivery for any marketing email to the current email address. This is automatically set by HubSpot.
Broadcast Clicks	Decimal	True		True	The number of clicks on published social messages. This is set automatically by HubSpot for each contact.
State_Region	String	False		True	The contact's state of residence. This might be set via import_ form_ or integration.
All team ids	String	True		True	The team ids corresponding to all owner referencing properties for this object_ both default and custom
Original Source	String	False		True	First known source the contact used to find your website. Set automatically_ but may be updated manually.
First marketing email open date	Datetime	True		True	The date of the earliest open for any marketing email to the current email address. This is automatically set by HubSpot.
Latest Source	String	False		True	The source of the latest session for a contact
Postal Code	String	False		True	The contact's zip code. This might be set via import_ form_ or integration.
Country_Region	String	False		True	The contact's country_region of residence. This might be set via import_ form_ or integration.
All accessible team ids	String	True		True	The team ids_ including up the team hierarchy_ corresponding to all owner referencing properties for this object_ both default and custom
Original Source DrillDown 1	String	True		True	Additional information about the source the contact used to find your website. Set automatically.
First marketing email click date	Datetime	True		True	The date of the earliest link click for any marketing email to the current email address. This is automatically set by HubSpot.
Latest Source DrillDown 1	String	True		True	Additional information about the latest source for the last session the contact used to find your website. Set automatically.
LinkedIn Connections	Decimal	False		True	How many LinkedIn connections they have
Original Source DrillDown 2	String	True		True	Additional information about the source the contact used to find your website. Set automatically.
Is globally ineligible	Bool	True		True	Indicates the contact is globally ineligible for email.
Preferred language	String	False		True	Set your contact's preferred language for communications. This property can be changed from an import_ form_ or integration.
Latest Source DrillDown 2	String	True		True	Additional information about the source for the last session the contact used to find your website. Set automatically.
Klout Score	Decimal	False		True	A contact's Klout score_ a measure of Internet influence
First Referring Site	String	True		True	URL that referred the contact to your website. Set automatically.
First marketing email reply date	Datetime	True		True	The date of the earliest reply for any marketing email to the current email address. This is automatically set by HubSpot.
Job Title	String	False		True	A contact's job title
Photo	String	False		True	Social Media photo
Last Referring Site	String	True		True	Last URL that referred contact to your website. Set automatically.
Last marketing email reply date	Datetime	True		True	The date of the latest reply for any marketing email to the current email address. This is automatically set by HubSpot.
Message	String	False		True	A default property to be used for any message or comments a contact may want to leave on a form.
Close Date	Datetime	False		True	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.
Average Pageviews	Decimal	True		True	Average number of pageviews per session for this contact. Set automatically.
Marketing emails replied	Decimal	True		True	The number of marketing emails replied to by the current email address. This is automatically set by HubSpot.
Event Revenue	Decimal	True		True	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
Became a Lead Date	Datetime	True		True	The date when a contact's lifecycle stage changed to Lead. This is automatically set by HubSpot for each contact.
Became a Marketing Qualified Lead Date	Datetime	True		True	The date when a contact's lifecycle stage changed to MQL. This is automatically set by HubSpot for each contact.
Became an Opportunity Date	Datetime	True		True	The date when a contact's lifecycle stage changed to Opportunity. This is automatically set by HubSpot for each contact.
Lifecycle Stage	String	False		True	The qualification of contacts to sales readiness. It can be set through imports_ forms_ workflows_ and manually on a per contact basis.
Became a Sales Qualified Lead Date	Datetime	True		True	The date when a contact's lifecycle stage changed to SQL. This is automatically set by HubSpot for each contact.
Create Date	Datetime	True		True	The date that a contact entered the system
Became an Evangelist Date	Datetime	True		True	The date when a contact's lifecycle stage changed to Evangelist. This is automatically set by HubSpot for each contact.
Became a Customer Date	Datetime	True		True	The date when a contact's lifecycle stage changed to Customer. This is automatically set by HubSpot for each contact.
HubSpot Score	Decimal	True		True	The number that shows qualification of contacts to sales readiness. It can be set in HubSpot's Lead Scoring app.
Company Name	String	False		True	Name of the contact's company. This can be set independently from the name property on the contact's associated company.
Became a Subscriber Date	Datetime	True		True	The date when a contact's lifecycle stage changed to Subscriber. This is automatically set by HubSpot for each contact.
Became an Other Lifecycle Date	Datetime	True		True	The date when a contact's lifecycle stage changed to Other. This is automatically set by HubSpot for each contact.
Website URL	String	False		True	Associated company website.
Number of Employees	String	False		True	The number of company employees
Annual Revenue	String	False		True	Annual company revenue
Industry	String	False		True	The Industry a contact is in
Primary Associated Company ID	Decimal	False		True	HubSpot defined ID of a contact's primary associated company in HubSpot.
Associated Company Last Updated	Decimal	True		True	This field is meaningless on its own_ and is solely used for triggering dynamic list updates when a company is updated
Lead Rating	String	True		True	The rating of this contact based on their predictive lead score
Predictive Lead Score	Decimal	True		True	A score calculated by HubSpot that represents a contact's likelihood to become a customer