Contacts

Lists all contacts in HubSpot, supporting both OAuth and private-app token authentication methods.

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, filtering can be applied to columns marked as "Filterable." For these columns, the only supported server-side operator is =.

SELECT * FROM Contacts WHERE ID = '96ec8565-3b73-4ee8-9815-f90566ba9c42';
SELECT * FROM Contacts WHERE Archived = TRUE;

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 for the contact record.
Archived	Bool	True		True	Indicates whether the contact record is archived and no longer actively used.
CreatedAt	Datetime	True		False	Timestamp marking when the contact record was created.
UpdatedAt	Datetime	True		False	Timestamp of the most recent update to the contact record.
ItemURL	String	True		False	Direct URL linking to the contact's record within HubSpot.
Company size	String	False		False	Size classification of the contact's company, required for Facebook Ads Integration and synced automatically from Lead Ads.
Date of birth	String	False		False	Date of birth of the contact, required for Facebook Ads Integration and synced automatically from Lead Ads.
Days To Close	Decimal	True		False	Number of days from contact creation until the contact was closed as a customer, set automatically.
Degree	String	False		False	Academic degree of the contact, required for Facebook Ads Integration and synced automatically from Lead Ads.
Field of study	String	False		False	Academic field of study of the contact, required for Facebook Ads Integration and synced automatically from Lead Ads.
First Conversion Date	Datetime	True		False	Date when the contact first submitted a form or performed a conversion action.
First Conversion	String	True		False	First form or conversion event submitted by the contact.
First Deal Created Date	Datetime	True		False	Date when the first deal was created and associated with the contact.
Gender	String	False		False	Gender of the contact, required for Facebook Ads Integration and synced automatically from Lead Ads.
Graduation date	String	False		False	Graduation date of the contact, required for Facebook Ads Integration and synced automatically from Lead Ads.
Additional email addresses	String	True		False	List of additional email addresses associated with the contact.
Business units	String	False		False	Business units to which this contact record is assigned.
All vids for a contact	String	True		False	Set of all visitor IDs (VIDs), including canonical and merged VIDs, linked to the contact.
First Touch Converting Campaign	String	True		False	Marketing campaign responsible for the first-touch creation of this contact.
Last Touch Converting Campaign	String	True		False	Marketing campaign responsible for the last-touch creation of this contact.
Avatar FileManager key	String	True		False	File path in HubSpot's FileManager CDN for the contact's avatar override image, managed automatically.
Buying Role	String	False		False	Role the contact plays in the sales process. Contacts can have multiple or shared roles.
All form submissions for a contact	String	True		False	List of all form submissions made by the contact.
Merged vids with timestamps of a contact	String	True		False	Merged visitor IDs (VIDs) along with their merge timestamps for the contact.
Calculated Mobile Number in International Format	String	True		False	Mobile phone number of the contact formatted in international dialing format.
Calculated Phone Number in International Format	String	True		False	Primary phone number of the contact formatted in international dialing format.
Calculated Phone Number Area Code	String	True		False	Area code extracted from the contact's primary phone number.
Calculated Phone Number Country Code	String	True		False	Country code extracted from the contact's primary phone number.
Calculated Phone Number Region	String	True		False	ISO2 country code derived from the contact's phone number region.
Clicked on a LinkedIn Ad	String	False		False	Indicates whether the contact has clicked on a LinkedIn ad.
Email Confirmed	Bool	True		False	Indicates whether the contact's email address has been confirmed for content membership.
Registration Follow Up Email Enqueued At	Datetime	False		False	Timestamp of when the first registration follow-up email for content membership was queued.
Membership Notes	String	False		False	Notes related to the contact's content membership.
Registered At	Datetime	True		False	Datetime when the contact was registered for content membership.
Domain to which registration email was sent	String	True		False	Email domain to which the content membership registration invitation was sent.
Time registration email was sent	Datetime	True		False	Datetime when the content membership registration invitation email was sent.
Status	String	False		False	Status of the contact's content membership.
Conversations visitor email	String	True		False	Email address provided by the visitor during a Conversations session.
Count of unengaged contacts	Decimal	True		False	Set to 1 if the contact is assigned but not engaged; set to 0 if assigned and engaged.
Count of engaged contacts	Decimal	True		False	Set to 1 if the contact is assigned and engaged; set to 0 if assigned but unengaged.
Created By Conversations	Bool	True		False	Indicates whether the contact was created via the Conversations API.
Created by user ID	Decimal	True		False	User ID of the individual who created the contact. Automatically assigned by HubSpot.
Object create date_time	Datetime	True		False	Timestamp when the contact record was created. Set automatically and not modifiable.
Date entered Customer (Lifecycle Stage Pipeline)	Datetime	True		False	The date and time when the contact entered the 'Customer' stage of the 'Lifecycle Stage Pipeline'.
Date entered Evangelist (Lifecycle Stage Pipeline)	Datetime	True		False	The date and time when the contact entered the 'Evangelist' stage of the 'Lifecycle Stage Pipeline'.
Date entered Lead (Lifecycle Stage Pipeline)	Datetime	True		False	The date and time when the contact entered the 'Lead' stage of the 'Lifecycle Stage Pipeline'.
Date entered Marketing Qualified Lead (Lifecycle Stage Pipeline)	Datetime	True		False	The date and time when the contact entered the 'Marketing Qualified Lead' stage of the 'Lifecycle Stage Pipeline'.
Date entered Opportunity (Lifecycle Stage Pipeline)	Datetime	True		False	The date and time when the contact entered the 'Opportunity' stage of the 'Lifecycle Stage Pipeline'.
Date entered Other (Lifecycle Stage Pipeline)	Datetime	True		False	The date and time when the contact entered the 'Other' stage of the 'Lifecycle Stage Pipeline'.
Date entered Sales Qualified Lead (Lifecycle Stage Pipeline)	Datetime	True		False	The date and time when the contact entered the 'Sales Qualified Lead' stage of the 'Lifecycle Stage Pipeline'.
Date entered Subscriber (Lifecycle Stage Pipeline)	Datetime	True		False	The date and time when the contact entered the 'Subscriber' stage of the 'Lifecycle Stage Pipeline'.
Date exited Customer (Lifecycle Stage Pipeline)	Datetime	True		False	The date and time when the contact exited the 'Customer' stage of the 'Lifecycle Stage Pipeline'.
Date exited Evangelist (Lifecycle Stage Pipeline)	Datetime	True		False	The date and time when the contact exited the 'Evangelist' stage of the 'Lifecycle Stage Pipeline'.
Date exited Lead (Lifecycle Stage Pipeline)	Datetime	True		False	The date and time when the contact exited the 'Lead' stage of the 'Lifecycle Stage Pipeline'.
Date exited Marketing Qualified Lead (Lifecycle Stage Pipeline)	Datetime	True		False	The date and time when the contact exited the 'Marketing Qualified Lead' stage of the 'Lifecycle Stage Pipeline'.
Date exited Opportunity (Lifecycle Stage Pipeline)	Datetime	True		False	The date and time when the contact exited the 'Opportunity' stage of the 'Lifecycle Stage Pipeline'.
Date exited Other (Lifecycle Stage Pipeline)	Datetime	True		False	The date and time when the contact exited the 'Other' stage of the 'Lifecycle Stage Pipeline'.
Date exited Sales Qualified Lead (Lifecycle Stage Pipeline)	Datetime	True		False	The date and time when the contact exited the 'Sales Qualified Lead' stage of the 'Lifecycle Stage Pipeline'.
Date exited Subscriber (Lifecycle Stage Pipeline)	Datetime	True		False	The date and time when the contact exited the 'Subscriber' stage of the 'Lifecycle Stage Pipeline'.
Recent Document Revisit Date	Datetime	True		False	Timestamp of the last time the contact accessed a shared document or presentation.
Invalid email address	Bool	True		False	Indicates whether the email address associated with the contact is invalid.
Email address quarantine reason	String	False		False	Reason why the contact's email address has been quarantined, typically due to anti-abuse policies.
Email Domain	String	True		False	Domain portion of the contact's primary email address.
Email hard bounce reason	String	True		False	Reason the email address caused a hard bounce during an email send attempt.
Email hard bounce reason2	String	True		False	Additional detail about the hard bounce event for the contact's email address.
Email Address Quarantined	Bool	True		False	Indicates whether the contact's email address has been quarantined for compliance reasons, blocking marketing emails.
Email address automated quarantine reason	String	True		False	System-generated reason explaining why the email address was quarantined automatically.
Email Address Recipient Fatigue Next Available Sending Time	Datetime	True		False	Timestamp when the contact will be eligible to receive emails after reaching recipient fatigue limits.
Sends Since Last Engagement	Decimal	True		False	Number of marketing emails sent to the contact since their last engagement, such as an open or click.
Marketing email confirmation status	String	True		False	Indicates the contact's eligibility to receive marketing emails, managed automatically by HubSpot.
Clicked Facebook ad	Bool	False		False	Indicates whether the contact clicked on a Facebook ad.
Facebook click id	String	False		False	Unique identifier associated with the contact's click on a Facebook ad.
Facebook ID	String	False		False	Unique Facebook ID assigned to the contact.
Last NPS survey comment	String	True		False	Comment provided by the contact during their most recent Net Promoter Score (NPS) survey response.
Last NPS survey rating	String	True		False	Numeric rating submitted by the contact in their most recent NPS survey.
Last NPS survey date	Datetime	True		False	Timestamp when the contact last submitted a Net Promoter Score (NPS) survey response. Set automatically by HubSpot.
Should be shown an NPS web survey	Bool	False		False	Indicates whether the contact is eligible to be shown a Net Promoter Score (NPS) web survey.
ID of first engagement	Decimal	True		False	Object ID of the first engagement (such as call, meeting, or email) between the contact and their current owner. Used in Sales Analytics.
First subscription create date	Datetime	True		False	Timestamp of the first subscription created by the contact.
Google ad click id	String	False		False	Unique identifier associated with a click on a Google ad by the contact.
googleplus ID	String	False		False	Unique Google Plus ID associated with the contact.
Contact has an active subscription	Decimal	True		False	Value is 1 if the contact has an active subscription, 0 otherwise. Set automatically by HubSpot.
IP Timezone	String	True		False	Timezone derived from the contact's IP address. Automatically set by HubSpot for segmentation and reporting.
Is a contact	Bool	True		False	Indicates whether the record is an active contact (not deleted and not a visitor).
Contact unworked	Bool	True		False	Indicates whether the contact has not been assigned or engaged since the last owner assignment or reassignment.
last sales activity date old	Datetime	True		False	Date of the last sales activity with the contact. Set automatically by HubSpot for contacts with owners.
Last Engagement Date	Datetime	True		False	Date when the contact last engaged with your site, forms, documents, meeting links, or tracked emails. Excludes marketing emails.
Last Engagement Type	String	True		False	Type of the last engagement action performed by the contact, excluding bulk marketing emails.
Object last modified date_time	Datetime	True		False	Timestamp of the most recent update to any property on the contact. Includes visible and hidden properties.
Last sequence ended date	Datetime	True		False	Date when the contact exited their most recent sales sequence.
Last sequence enrolled	Decimal	True		False	ID of the last sequence the contact was enrolled in.
Last sequence enrolled date	Datetime	True		False	Date when the contact was last enrolled in a sales sequence.
Last sequence finished date	Datetime	True		False	Date when the contact finished their last enrolled sales sequence.
Last sequence unenrolled date	Datetime	True		False	Date when the contact was unenrolled from a sales sequence.
Latest Source Date	Date	False		False	Date of the latest session associated with the contact.
Latest subscription create date	Datetime	True		False	Timestamp when the contact's most recent subscription was created.
Lead Status	String	False		False	Current sales, prospecting, or outreach status assigned to the contact.
Legal basis for processing contact's data	String	False		False	The legal basis for processing the contact's data. 'Not applicable' exempts the contact from GDPR protections.
Clicked LinkedIn Ad	String	False		False	Indicates whether the contact clicked on a LinkedIn ad.
Linkedin ID	String	False		False	Unique LinkedIn ID assigned to the contact.
Marketing contact status source name	String	True		False	Identifier for the activity or workflow that designated the contact as a marketing contact.
Marketing contact status source type	String	True		False	Type of activity (such as workflow or API call) that set the contact as a marketing contact.
Marketing contact status	String	True		False	The marketing contact status, affecting eligibility for marketing emails.
Marketing contact until next update	String	True		False	Indicates whether the contact will be set to non-marketing at the next update cycle.
Merged object IDs	String	True		False	List of record IDs that have been merged into this contact record. Managed automatically by HubSpot.
Record ID	Decimal	True		False	Unique identifier assigned to this contact record. Set automatically by HubSpot.
Pinned engagement ID	Decimal	True		False	Object ID of the pinned engagement currently highlighted on the contact timeline.
Pipeline	String	False		False	Sales pipeline the contact is currently associated with, if applicable.
Likelihood to close	Decimal	True		False	Probability score predicting the likelihood that the contact will become a customer within the next 90 days.
Contact priority	String	True		False	Priority tier assigned to the contact, with tier one being the highest priority for conversion.
Read Only Object	Bool	True		False	Indicates whether the contact record is read-only and cannot be edited by users.
Date of first engagement	Datetime	True		False	Date of the first recorded engagement between the contact and their current owner. Used in Sales Analytics.
Description of first engagement	String	True		False	Description of the first engagement event between the contact and their current owner. Used in Sales Analytics.
Type of first engagement	String	True		False	Object type (such as call, email, or meeting) of the first engagement between the contact and their current owner. Used in Sales Analytics.
Recent Sales Email Clicked Date	Datetime	True		False	Date when the contact last clicked a link in a tracked sales email.
Recent Sales Email Opened Date	Datetime	True		False	Date when the contact last opened a tracked sales email. Does not update for bulk emails sent to multiple recipients.
Calculated Mobile Number with country code	String	True		False	Contact's mobile number formatted with a country code.
Calculated Phone Number with country code	String	True		False	Contact's primary phone number formatted with a country code.
Calculated Mobile Number without country code	String	True		False	Contact's mobile number formatted without a country code.
Calculated Phone Number without country code	String	True		False	Contact's primary phone number formatted without a country code.
Number of sequences actively enrolled	Decimal	True		False	Number of active sales sequences the contact is currently enrolled in.
Number of sequences enrolled	Decimal	True		False	Total number of sales sequences the contact has ever been enrolled in.
Currently in Sequence	Bool	True		False	Indicates whether the contact is currently enrolled in any active sales sequence.
testpurge	String	True		False	Placeholder field used for testing purge functionality.
testrollback	String	True		False	Placeholder field used for testing rollback functionality.
Time between contact creation and deal close	Decimal	False		False	Elapsed time in milliseconds between the contact's creation and the closing of an associated deal.
Time between contact creation and deal creation	Decimal	False		False	Elapsed time in milliseconds between the contact's creation and the creation of an associated deal.
Time in Customer (Lifecycle Stage Pipeline)	Decimal	True		False	Total time in seconds the contact spent in the 'Customer' stage within the Lifecycle Stage Pipeline.
Time in Evangelist (Lifecycle Stage Pipeline)	Decimal	True		False	Total time in seconds the contact spent in the 'Evangelist' stage within the Lifecycle Stage Pipeline.
Time in Lead (Lifecycle Stage Pipeline)	Decimal	True		False	Total time in seconds the contact spent in the 'Lead' stage within the Lifecycle Stage Pipeline.
Time in Marketing Qualified Lead (Lifecycle Stage Pipeline)	Decimal	True		False	Total time in seconds the contact spent in the 'Marketing Qualified Lead' stage within the Lifecycle Stage Pipeline.
Time in Opportunity (Lifecycle Stage Pipeline)	Decimal	True		False	Total time in seconds the contact spent in the 'Opportunity' stage within the Lifecycle Stage Pipeline.
Time in Other (Lifecycle Stage Pipeline)	Decimal	True		False	Total time in seconds the contact spent in the 'Other' stage within the Lifecycle Stage Pipeline.
Time in Sales Qualified Lead (Lifecycle Stage Pipeline)	Decimal	True		False	Total time in seconds the contact spent in the 'Sales Qualified Lead' stage within the Lifecycle Stage Pipeline.
Time in Subscriber (Lifecycle Stage Pipeline)	Decimal	True		False	Total time in seconds the contact spent in the 'Subscriber' stage within the Lifecycle Stage Pipeline.
Lead response time	Decimal	True		False	Time in milliseconds it took for the current owner to perform the first qualifying engagement with the contact. Used in Sales Analytics.
Time to move from lead to customer	Decimal	False		False	Time it took for the contact to move from 'Lead' stage to 'Customer' stage.
Time to move from marketing qualified lead to customer	Decimal	False		False	Time it took for the contact to move from 'Marketing Qualified Lead' stage to 'Customer' stage.
Time to move from opportunity to customer	Decimal	False		False	Time it took for the contact to move from 'Opportunity' stage to 'Customer' stage.
Time to move from sales qualified lead to customer	Decimal	False		False	Time it took for the contact to move from 'Sales Qualified Lead' stage to 'Customer' stage.
Time to move from subscriber to customer	Decimal	False		False	Time it took for the contact to move from 'Subscriber' stage to 'Customer' stage.
Time Zone	String	False		False	Time zone associated with the contact. Can be automatically derived from other properties or manually assigned.
Twitter ID	String	False		False	Unique identifier for the contact's Twitter account.
Unique creation key	String	True		False	Unique key used to ensure idempotent creation of the contact and prevent duplicates.
Updated by user ID	Decimal	True		False	ID of the user who last updated the contact record. Set automatically by HubSpot.
User IDs of all notification followers	String	True		False	List of user IDs who have opted in to follow update notifications for this contact.
User IDs of all notification unfollowers	String	True		False	List of user IDs who have opted out of receiving update notifications for this contact.
User IDs of all owners	String	True		False	List of user IDs assigned as owners of this contact record.
WhatsApp Phone Number	String	False		False	Phone number associated with the contact's WhatsApp account.
Owner Assigned Date	Datetime	True		False	Date and time when the contact was assigned to its most recent owner. Automatically set by HubSpot.
IP City	String	True		False	City reported by the contact's IP address. Used for segmentation and reporting.
IP Country	String	True		False	Country reported by the contact's IP address. Used for segmentation and reporting.
IP Country Code	String	True		False	Country code reported by the contact's IP address. Used for segmentation and reporting.
IP Latitude _ Longitude	String	True		False	Latitude and longitude coordinates reported by the contact's IP address.
IP State_Region	String	True		False	State or region reported by the contact's IP address. Used for segmentation and reporting.
IP State Code_Region Code	String	True		False	State code or region code reported by the contact's IP address. Used for segmentation and reporting.
IP Zipcode	String	True		False	Postal or ZIP code reported by the contact's IP address. Used for segmentation and reporting.
Job function	String	False		False	Contact's job function. Required for Facebook Ads Integration; synced automatically from Lead Ads.
Last Modified Date	Datetime	True		False	Timestamp when any property of the contact was last modified.
Marital Status	String	False		False	Contact's marital status. Required for Facebook Ads Integration; synced automatically from Lead Ads.
Military status	String	False		False	Contact's military status. Required for Facebook Ads Integration; synced automatically from Lead Ads.
Number of Associated Deals	Decimal	True		False	Total number of deals associated with the contact. Automatically set by HubSpot.
Number of Form Submissions	Decimal	True		False	Total number of forms submitted by the contact. Automatically tracked by HubSpot.
Number of Unique Forms Submitted	Decimal	True		False	Total number of distinct forms submitted by the contact.
Recent Conversion Date	Datetime	True		False	Date when the contact most recently submitted a form.
Recent Conversion	String	True		False	The name of the most recent form submitted by the contact.
Recent Deal Amount	Decimal	True		False	Amount of the most recent closed-won deal associated with the contact. Automatically set.
Recent Deal Close Date	Datetime	True		False	Date when the most recent deal associated with the contact was closed-won. Automatically set.
Relationship Status	String	False		False	Contact's relationship status. Required for Facebook Ads Integration; synced automatically from Lead Ads.
School	String	False		False	Contact's school or educational institution. Required for Facebook Ads Integration; synced automatically from Lead Ads.
Seniority	String	False		False	Contact's seniority level within their organization. Required for Facebook Ads Integration; synced automatically from Lead Ads.
Start date	String	False		False	Contact's job start date. Required for Facebook Ads Integration; synced automatically from Lead Ads.
Total Revenue	Decimal	True		False	Sum of revenue from all closed-won deals associated with the contact. Automatically maintained by HubSpot.
Work email	String	False		False	Work email address of the contact. Required for Facebook Ads Integration; synced automatically from Lead Ads.
First Name	String	False		False	Contact's first name.
First Page Seen	String	True		False	First webpage visited by the contact on your website. Automatically captured by HubSpot.
Marketing emails delivered	Decimal	True		False	Number of marketing emails delivered to the contact. Automatically tracked by HubSpot.
Opted out of emailCustomer Service Communication	String	True		False	Indicates whether the contact has opted out of customer service communications.
Opted out of emailOne to One	String	True		False	Indicates whether the contact has opted out of receiving one-to-one emails.
Twitter Username	String	False		False	Contact's Twitter username or handle.
Currently in workflow	String	True		False	Indicates if the contact is currently enrolled in a HubSpot workflow.
Follower Count	Decimal	False		False	Number of Twitter followers associated with the contact's Twitter account.
Last Page Seen	String	True		False	Last webpage visited by the contact on your website. Automatically captured by HubSpot.
Marketing emails opened	Decimal	True		False	Number of marketing emails opened by the contact. Automatically tracked by HubSpot.
Last Name	String	False		False	Contact's last name.
Number of Pageviews	Decimal	True		False	Total number of pageviews by the contact on your website. Automatically set by HubSpot.
Marketing emails clicked	Decimal	True		False	Number of marketing emails where the contact clicked a link. Automatically tracked by HubSpot.
Salutation	String	False		False	Title used to address the contact, such as Mr., Ms., or Dr.
Twitter Profile Photo	String	False		False	URL of the contact's Twitter profile photo. Set automatically based on the contact's email address.
Email	String	False		False	Primary email address of the contact.
Number of Sessions	Decimal	True		False	Total number of sessions (website visits) by the contact. Automatically set by HubSpot.
Marketing emails bounced	Decimal	True		False	Number of marketing emails that bounced when sent to the contact. Automatically set by HubSpot.
Persona	String	False		False	Persona classification assigned to the contact, useful for segmentation.
Most Recent Social Click	Datetime	True		False	Timestamp of the contact's most recent click on a published social media message.
Number of event completions	Decimal	True		False	Total number of event completions recorded for the contact. Automatically set by HubSpot.
Unsubscribed from all email	Bool	True		False	Indicates if the contact has unsubscribed from all email communications.
Twitter Clicks	Decimal	True		False	Number of times the contact clicked links you shared on Twitter through HubSpot. Automatically tracked.
Mobile Phone Number	String	False		False	Mobile phone number associated with the contact.
Phone Number	String	False		False	Primary phone number associated with the contact.
Fax Number	String	False		False	Fax number associated with the contact, if available.
Time First Seen	Datetime	True		False	Timestamp when the contact was first recorded visiting your website. Automatically set by HubSpot.
Last marketing email name	String	True		False	Name of the last marketing email sent to the contact. Automatically recorded by HubSpot.
Last marketing email send date	Datetime	True		False	Date when the most recent marketing email was sent to the contact.
Facebook Clicks	Decimal	True		False	Number of clicks the contact made on links shared on Facebook.
Street Address	String	False		False	Street address for the contact, including apartment or unit number.
Date of last meeting booked in meetings tool	Datetime	True		False	Date when the last meeting was booked by the contact using HubSpot's meetings tool.
Campaign of last booking in meetings tool	String	True		False	UTM campaign parameter associated with the most recent meeting booking by the contact.
Medium of last booking in meetings tool	String	True		False	UTM medium parameter indicating the channel responsible for the most recent meeting booking.
Source of last booking in meetings tool	String	True		False	UTM source parameter identifying the website that referred the contact's last meeting booking.
Time of First Session	Datetime	True		False	Timestamp when the contact had their first session on your website.
Last marketing email open date	Datetime	True		False	Timestamp when the contact last opened a marketing email.
Latest meeting activity	Datetime	True		False	Date of the most recent meeting (past or upcoming) related to the contact.
Recent Sales Email Replied Date	Datetime	True		False	Date when the contact most recently replied to a tracked sales email.
LinkedIn Clicks	Decimal	True		False	Number of times the contact clicked links shared on LinkedIn.
Contact owner	String	False		False	User assigned as the owner of the contact in HubSpot.
Last Contacted	Datetime	True		False	Timestamp of the most recent call, email, or meeting logged for the contact.
Last Activity Date	Datetime	True		False	Date and time of the most recent activity (such as a call, meeting, or note) logged for the contact.
Next Activity Date	Datetime	True		False	Scheduled date of the next planned activity (such as a call or meeting) for the contact.
Number of times contacted	Decimal	True		False	Total number of calls, emails, and meetings logged for this contact. Automatically tracked by HubSpot.
Number of Sales Activities	Decimal	True		False	Total number of sales activities (calls, meetings, emails) logged for the contact.
HubSpot Owner Email _legacy_	String	False		False	Legacy property recording the email address of the contact's owner. No longer actively used.
HubSpot Owner Name _legacy_	String	False		False	Legacy property recording the name of the contact's owner. No longer actively used.
SurveyMonkey Event Last Updated	Decimal	True		False	Internal field used for triggering list updates when SurveyMonkey information is refreshed.
Webinar Event Last Updated	Decimal	True		False	Internal field used for triggering list updates when webinar information is refreshed.
City	String	False		False	City of residence for the contact. Can be populated through imports, forms, or integrations.
Time Last Seen	Datetime	True		False	Timestamp of the most recent webpage view by the contact.
Last marketing email click date	Datetime	True		False	Date when the contact last clicked a link in a marketing email.
Google Plus Clicks	Decimal	True		False	Number of clicks made by the contact on links shared through Google Plus.
HubSpot Team	String	True		False	Name of the HubSpot team associated with the contact's owner.
LinkedIn Bio	String	False		False	Biography or description from the contact's LinkedIn profile.
Twitter Bio	String	False		False	Biography from the contact's Twitter profile, populated based on their email address.
All owner ids	String	True		False	List of all owner property IDs associated with the contact, including default and custom owners.
Time of Last Session	Datetime	True		False	Timestamp marking the beginning of the contact's most recent session on your website.
First marketing email send date	Datetime	True		False	Date when the first marketing email was delivered to this contact.
Broadcast Clicks	Decimal	True		False	Total number of clicks made by the contact on published social messages.
State_Region	String	False		False	State or region where the contact resides. Can be set through forms, imports, or integrations.
All team ids	String	True		False	IDs of all teams assigned to the contact, either directly or through ownership properties.
Original Source	String	False		False	Original source through which the contact discovered your business. Set automatically by HubSpot.
First marketing email open date	Datetime	True		False	Date when the contact first opened a marketing email.
Latest Source	String	False		False	Source associated with the contact's most recent website session.
Postal Code	String	False		False	Postal or ZIP code associated with the contact's address.
Country_Region	String	False		False	Country or region where the contact resides.
All accessible team ids	String	True		False	IDs of all teams, including inherited teams, associated with the contact's owner properties.
Original Source DrillDown 1	String	True		False	Additional contextual details about how the contact originally found your site.
First marketing email click date	Datetime	True		False	Date when the contact first clicked a link in a marketing email.
Latest Source DrillDown 1	String	True		False	Additional detail about the latest session source for the contact.
LinkedIn Connections	Decimal	False		False	Number of LinkedIn connections linked to the contact's LinkedIn profile.
Original Source DrillDown 2	String	True		False	Further breakdown of the contact's original source of discovery.
Is globally ineligible	Bool	True		False	Indicates if the contact is globally ineligible to receive email communications.
Preferred language	String	False		False	Preferred language for communication with the contact.
Latest Source DrillDown 2	String	True		False	Further detail about the contact's latest session source.
Klout Score	Decimal	False		False	Deprecated social media influence score for the contact, retained for legacy use.
First Referring Site	String	True		False	URL of the website that initially referred the contact to your website.
First marketing email reply date	Datetime	True		False	Date when the contact first replied to a marketing email.
Job Title	String	False		False	Job title of the contact as recorded in their profile.
Photo	String	False		False	Social media profile photo linked to the contact.
Last Referring Site	String	True		False	URL of the last referring website that brought the contact to your site.
Last marketing email reply date	Datetime	True		False	Date when the contact last replied to a marketing email.
Message	String	False		False	Field used to capture custom messages or comments submitted by the contact via forms.
Close Date	Datetime	False		False	Date when the contact officially became a customer. Automatically set when a related deal is closed-won or can be set manually.
Average Pageviews	Decimal	True		False	Average number of page views per session by the contact.
Marketing emails replied	Decimal	True		False	Total number of marketing emails the contact has replied to.
Event Revenue	Decimal	True		False	Revenue value attributed to the contact through Enterprise Events tracking.
Became a Lead Date	Datetime	True		False	Date when the contact's lifecycle stage was updated to Lead.
Became a Marketing Qualified Lead Date	Datetime	True		False	Date when the contact's lifecycle stage was updated to Marketing Qualified Lead (MQL).
Became an Opportunity Date	Datetime	True		False	Date when the contact's lifecycle stage was updated to Opportunity.
Lifecycle Stage	String	False		False	Current sales readiness stage of the contact such as Subscriber, Lead, Opportunity, or Customer.
Became a Sales Qualified Lead Date	Datetime	True		False	Date when the contact's lifecycle stage was updated to Sales Qualified Lead (SQL).
Create Date	Datetime	True		False	Date when the contact record was first created in HubSpot.
Became an Evangelist Date	Datetime	True		False	Date when the contact's lifecycle stage was updated to Evangelist.
Became a Customer Date	Datetime	True		False	Date when the contact's lifecycle stage was updated to Customer.
HubSpot Score	Decimal	True		False	Lead scoring metric showing the contact's sales readiness based on set criteria.
Company Name	String	False		False	Name of the company associated with the contact.
Became a Subscriber Date	Datetime	True		False	Date when the contact's lifecycle stage was updated to Subscriber.
Became an Other Lifecycle Date	Datetime	True		False	Date when the contact's lifecycle stage was updated to 'Other' lifecycle classification.
Website URL	String	False		False	Website URL of the contact's associated company or personal website.
Number of Employees	String	False		False	Total number of employees at the contact's associated company.
Annual Revenue	String	False		False	Annual revenue of the contact's associated company.
Industry	String	False		False	Industry in which the contact's associated company operates.
Primary Associated Company ID	Decimal	False		False	Unique HubSpot ID of the primary associated company linked to the contact.
Associated Company Last Updated	Decimal	True		False	Internal field used to trigger updates when the associated company's information changes.
Lead Rating	String	True		False	Rating given to the contact based on predictive lead scoring models.
Predictive Lead Score	Decimal	True		False	HubSpot-calculated score indicating how likely the contact is to become a customer.