Contacts
Retrieve the available Contacts in HubSpot. This table supports both OAuth and PrivateAppToken authentication.
Table Specific Information
In HubSpot, contacts store information about an individual. From marketing automation to smart content, the lead-specific data found in contact records helps users leverage much of HubSpot's functionality.
SELECT
When selecting contacts, they can be filtered by columns marked below as 'Filterable'. For those columns, the supported server-side operators are =, !=, <, <=, >, >=. Further filtering is available using AND and OR combinations. A maximum of 2 OR operators are supported server-side, with each of these operators supporting up to 2 AND operators inside of them. For example:
SELECT * FROM Contacts WHERE [Associated Deals] = 3 AND [First Deal Created Date] > '2019-01-01' SELECT * FROM Contacts WHERE [Company Name] = 'CData' OR [Last Name] = 'Robinson'
In the below server-offloading examples, "{Column}" represents any column you'd like to filter and "{Value}" represents any value you want to filter it on:
SELECT * FROM Contacts WHERE {Column} = {Value} AND {Column} < {Value} AND {Column} > {Value} SELECT * FROM Contacts WHERE {Column} != {Value} AND {Column} >= {Value} AND {Column} <= {Value} SELECT * FROM Contacts WHERE ({Column} = {Value} AND {Column} = {Value}) OR ({Column} != {Value} AND {Column} >= {Value}) SELECT * FROM Contacts WHERE ({Column} != {Value} AND {Column} >= {Value} AND {Column} <= {Value}) OR ({Column} != {Value} AND {Column} >= {Value} AND {Column} <= {Value}) OR ({Column} != {Value} AND {Column} >= {Value} AND {Column} <= {Value})
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. | |
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. |