Contacts

Retrieves contact records from HubSpot, supporting both OAuth and private-app token 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')

UPSERT

UPSERT operations can be used to create a new contact record if it doesn't exist, or update it if it already exists. You must specify an ExternalIdColumn to identify the record.

UPSERT INTO Contacts (`First name`, `Email`, `Upsert Property`, `ExternalIdColumn`) VALUES ('John', '[email protected]', '31d06273-de69-4150-9ece-764d267222f6', 'Upsert Property')

Note

Only AtomicBatch upserts are supported for Contacts when ExternalIdColumn is set to 'Email'.
AtomicBatch: If one batch item fails, the entire batch fails. No records are written to HubSpot.

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	True		True	Unique numeric identifier for the contact record.
Archived	Bool	True		False	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		True	Size classification of the contact's company. Required for Facebook Ads Integration; synced automatically from Lead Ads.
Date of birth	String	False		True	Contact's date of birth. Required for Facebook Ads Integration; synced automatically from Lead Ads.
Days To Close	Decimal	True		True	Number of days from contact creation until they are marked as a customer. Set automatically.
Degree	String	False		True	Contact's academic degree. Required for Facebook Ads Integration; synced automatically from Lead Ads.
Field of study	String	False		True	Contact's academic field of study. Required for Facebook Ads Integration; synced automatically from Lead Ads.
First Conversion Date	Datetime	True		True	Date when the contact first submitted a form or performed a conversion action.
First Conversion	String	True		True	The first form submitted by the contact.
First Deal Created Date	Datetime	True		True	Date when the first deal was created and associated with the contact. Set automatically.
Gender	String	False		True	Contact's gender. Required for Facebook Ads Integration; synced automatically from Lead Ads.
Graduation date	String	False		True	Contact's graduation date. Required for Facebook Ads Integration; synced automatically from Lead Ads.
Additional email addresses	String	True		True	List of additional email addresses associated with the contact.
Business units	String	False		True	The business units to which this contact record is assigned.
All vids for a contact	String	True		True	List of all visitor IDs (VIDs) linked to the contact, including canonical and merged VIDs.
First Touch Converting Campaign	String	True		True	Marketing campaign responsible for the first-touch creation of this contact.
Last Touch Converting Campaign	String	True		True	Marketing campaign responsible for the last-touch creation of this contact.
Avatar FileManager key	String	True		True	File path in HubSpot's FileManager CDN for the contact's avatar override image. Managed automatically.
Buying Role	String	False		True	Sales role assigned to the contact during the sales process. Contacts can have multiple roles or share roles.
All form submissions for a contact	String	True		True	List of all form submissions made by the contact.
Merged vids with timestamps of a contact	String	True		True	List of merged visitor IDs (VIDs) along with timestamps for the contact.
Calculated Mobile Number in International Format	String	True		True	Contact's mobile number formatted in international dialing format.
Calculated Phone Number in International Format	String	True		True	Contact's primary phone number formatted in international dialing format.
Calculated Phone Number Area Code	String	True		True	Area code extracted from the contact's primary phone number.
Calculated Phone Number Country Code	String	True		True	Country code extracted from the contact's primary phone number.
Calculated Phone Number Region	String	True		True	ISO2 country code derived from the contact's phone number.
Clicked on a LinkedIn Ad	String	False		True	Indicates whether the contact has clicked on a LinkedIn ad.
Email Confirmed	Bool	True		True	Indicates whether the contact's email address has been confirmed for content membership.
Registration Follow Up Email Enqueued At	Datetime	False		True	Timestamp of when the first content membership registration follow-up email was queued for sending.
Membership Notes	String	False		True	Notes or comments related to the contact's content membership status.
Registered At	Datetime	True		True	Datetime when the contact was registered for content membership.
Domain to which registration email was sent	String	True		True	Domain of the email address where the content membership registration invitation was sent.
Time registration email was sent	Datetime	True		True	Datetime when the content membership registration invitation email was sent.
Status	String	False		True	Current status of the contact's content membership.
Conversations visitor email	String	True		True	Email address provided by the visitor during a Conversations session.
Count of unengaged contacts	Decimal	True		True	Set to 1 if the contact is assigned but not yet engaged; set to 0 if assigned and engaged.
Count of engaged contacts	Decimal	True		True	Set to 1 if the contact is assigned and engaged; set to 0 if assigned but unengaged.
Created By Conversations	Bool	True		True	Indicates whether this contact was created via the Conversations API.
Created by user ID	Decimal	True		True	User ID of the individual who created this contact. Set automatically by HubSpot.
Object create date_time	Datetime	True		True	Timestamp marking when this contact record was created. Set automatically and not editable.
Date entered Customer (Lifecycle Stage Pipeline)	Datetime	True		True	Date and time when the contact entered the 'Customer' stage within the Lifecycle Stage Pipeline.
Date entered Evangelist (Lifecycle Stage Pipeline)	Datetime	True		True	Date and time when the contact entered the 'Evangelist' stage within the Lifecycle Stage Pipeline.
Date entered Lead (Lifecycle Stage Pipeline)	Datetime	True		True	Date and time when the contact entered the 'Lead' stage within the Lifecycle Stage Pipeline.
Date entered Marketing Qualified Lead (Lifecycle Stage Pipeline)	Datetime	True		True	Date and time when the contact entered the 'Marketing Qualified Lead' stage within the Lifecycle Stage Pipeline.
Date entered Opportunity (Lifecycle Stage Pipeline)	Datetime	True		True	Date and time when the contact entered the 'Opportunity' stage within the Lifecycle Stage Pipeline.
Date entered Other (Lifecycle Stage Pipeline)	Datetime	True		True	Date and time when the contact entered the 'Other' stage within the Lifecycle Stage Pipeline.
Date entered Sales Qualified Lead (Lifecycle Stage Pipeline)	Datetime	True		True	Date and time when the contact entered the 'Sales Qualified Lead' stage within the Lifecycle Stage Pipeline.
Date entered Subscriber (Lifecycle Stage Pipeline)	Datetime	True		True	Date and time when the contact entered the 'Subscriber' stage within the Lifecycle Stage Pipeline.
Date exited Customer (Lifecycle Stage Pipeline)	Datetime	True		True	Date and time when the contact exited the 'Customer' stage within the Lifecycle Stage Pipeline.
Date exited Evangelist (Lifecycle Stage Pipeline)	Datetime	True		True	Date and time when the contact exited the 'Evangelist' stage within the Lifecycle Stage Pipeline.
Date exited Lead (Lifecycle Stage Pipeline)	Datetime	True		True	Date and time when the contact exited the 'Lead' stage within the Lifecycle Stage Pipeline.
Date exited Marketing Qualified Lead (Lifecycle Stage Pipeline)	Datetime	True		True	Date and time when the contact exited the 'Marketing Qualified Lead' stage within the Lifecycle Stage Pipeline.
Date exited Opportunity (Lifecycle Stage Pipeline)	Datetime	True		True	Date and time when the contact exited the 'Opportunity' stage within the Lifecycle Stage Pipeline.
Date exited Other (Lifecycle Stage Pipeline)	Datetime	True		True	Date and time when the contact exited the 'Other' stage within the Lifecycle Stage Pipeline.
Date exited Sales Qualified Lead (Lifecycle Stage Pipeline)	Datetime	True		True	Date and time when the contact exited the 'Sales Qualified Lead' stage within the Lifecycle Stage Pipeline.
Date exited Subscriber (Lifecycle Stage Pipeline)	Datetime	True		True	Date and time when the contact exited the 'Subscriber' stage within the Lifecycle Stage Pipeline.
Recent Document Revisit Date	Datetime	True		True	Last time the contact accessed a shared document or presentation.
Invalid email address	Bool	True		True	Indicates whether the email address associated with the contact is invalid.
Email address quarantine reason	String	False		True	Reason the email address has been quarantined, typically for security or compliance reasons.
Email Domain	String	True		True	Domain portion of the contact's primary email address.
Email hard bounce reason	String	True		True	Reason the contact's email address caused a hard bounce during email sending.
Email hard bounce reason2	String	True		True	Additional reason details for a hard bounce event on the contact's email address.
Email Address Quarantined	Bool	True		True	Indicates whether the contact's email address has been quarantined due to anti-abuse policies.
Email address automated quarantine reason	String	True		True	System-generated reason explaining why the email address was quarantined automatically.
Email Address Recipient Fatigue Next Available Sending Time	Datetime	True		True	Timestamp when the contact will next be eligible to receive marketing emails after reaching recipient fatigue limits.
Sends Since Last Engagement	Decimal	True		True	Total number of marketing emails sent to this contact since their last engagement, such as an open or click. Tracked automatically.
Marketing email confirmation status	String	True		True	Status indicating whether the contact is eligible to receive marketing emails. Managed automatically by HubSpot.
Clicked Facebook ad	Bool	False		True	Indicates whether the contact has clicked on a Facebook ad.
Facebook click id	String	False		True	Unique identifier associated with the contact's click on a Facebook ad for tracking purposes.
Facebook ID	String	False		True	Contact's unique Facebook ID, used for integration and tracking.
Last NPS survey comment	String	True		True	Comment provided by the contact during their most recent Net Promoter Score (NPS) survey.
Last NPS survey rating	String	True		True	Numeric rating submitted by the contact in their most recent NPS survey response.
Last NPS survey date	Datetime	True		True	Timestamp when the contact last submitted an NPS survey response. Set automatically by HubSpot.
Should be shown an NPS web survey	Bool	False		True	Indicates whether the contact is eligible to be shown a Net Promoter Score (NPS) web survey. Managed automatically by HubSpot.
ID of first engagement	Decimal	True		True	Object ID of the first engagement, such as a call or email, between the contact and their owner. Used in Sales Analytics.
First subscription create date	Datetime	True		True	Date when the contact's first subscription was created.
Google ad click id	String	False		True	Unique identifier linked to the contact's click on a Google ad for tracking purposes.
googleplus ID	String	False		True	Contact's Google+ ID, used for legacy social integrations.
Contact has an active subscription	Decimal	True		True	Indicates if the contact currently has an active subscription (1 = active, 0 = inactive).
IP Timezone	String	True		True	Time zone detected from the contact's IP address. Set automatically for segmentation and reporting.
Is a contact	Bool	True		True	Indicates whether the record represents an active contact, not deleted or classified as a visitor.
Contact unworked	Bool	True		True	Flag showing whether the contact has not been assigned or engaged since the last owner assignment or reassignment.
last sales activity date old	Datetime	True		True	Date of the last recorded sales activity involving this contact. Updated automatically for owned contacts.
Last Engagement Date	Datetime	True		True	Date of the last engagement by the contact, such as visiting a site, submitting a form, or replying to an email. Excludes bulk marketing emails.
Last Engagement Type	String	True		True	Type of the most recent engagement performed by the contact, excluding bulk marketing emails.
Object last modified date_time	Datetime	True		True	Timestamp of the most recent update to any property on the contact. Managed automatically by HubSpot.
Last sequence ended date	Datetime	True		True	Date when the contact last exited a sales sequence.
Last sequence enrolled	Decimal	True		True	ID of the last sales sequence in which the contact was enrolled.
Last sequence enrolled date	Datetime	True		True	Date when the contact was last enrolled in a sales sequence.
Last sequence finished date	Datetime	True		True	Date when the contact completed their last sales sequence.
Last sequence unenrolled date	Datetime	True		True	Date when the contact was unenrolled from their last sales sequence.
Latest Source Date	Date	False		True	Date of the most recent website session or tracked interaction for the contact.
Latest subscription create date	Datetime	True		True	Date when the contact's latest subscription was created.
Lead Status	String	False		True	Current sales, prospecting, or outreach status assigned to the contact.
Legal basis for processing contact's data	String	False		True	The legal justification for processing the contact's data. 'Not applicable' exempts the contact from GDPR protections.
Clicked LinkedIn Ad	String	False		True	Indicates whether the contact has clicked on a LinkedIn ad.
Linkedin ID	String	False		True	Contact's LinkedIn ID, used for integrations and profile enrichment.
Marketing contact status source name	String	True		True	ID of the process or activity that set this contact as a marketing contact.
Marketing contact status source type	String	True		True	Type of source, such as workflow or API, that assigned the marketing contact status.
Marketing contact status	String	True		True	The contact's current marketing status, determining eligibility for marketing emails and billing.
Marketing contact until next update	String	True		True	Specifies whether the contact will be converted to non-marketing status during the next update cycle.
Merged object IDs	String	True		True	List of contact record IDs merged into this contact. Managed automatically by HubSpot.
Record ID	Decimal	True		True	Unique identifier for this contact record, assigned by HubSpot.
Pinned engagement ID	Decimal	True		True	ID of the engagement pinned to the contact's timeline for quick reference.
Pipeline	String	False		True	The pipeline to which this contact is currently assigned, typically reflecting sales or marketing workflows.
Likelihood to close	Decimal	True		True	Predictive score indicating the probability of this contact becoming a customer within 90 days.
Contact priority	String	True		True	Tiered ranking indicating the contact's likelihood to convert, with tier one being the highest priority.
Read Only Object	Bool	True		True	Indicates whether the contact record is read-only and cannot be modified.
Date of first engagement	Datetime	True		True	Date when the contact owner first engaged with this contact, such as through a call, email, or meeting. Used in Sales Analytics.
Description of first engagement	String	True		True	Description of the initial engagement between the contact and their owner. Used in Sales Analytics.
Type of first engagement	String	True		True	The type of the first engagement object, such as call, email, or meeting. Used in Sales Analytics.
Recent Sales Email Clicked Date	Datetime	True		True	Date when the contact last clicked a link in a tracked sales email.
Recent Sales Email Opened Date	Datetime	True		True	Date when the contact last opened a tracked sales email. Excludes bulk marketing emails.
Calculated Mobile Number with country code	String	True		True	Contact's mobile phone number formatted to include the country code.
Calculated Phone Number with country code	String	True		True	Contact's primary phone number formatted to include the country code.
Calculated Mobile Number without country code	String	True		True	Contact's mobile phone number formatted without the country code.
Calculated Phone Number without country code	String	True		True	Contact's primary phone number formatted without the country code.
Number of sequences actively enrolled	Decimal	True		True	Number of active sales sequences in which the contact is currently enrolled.
Number of sequences enrolled	Decimal	True		True	Total number of sales sequences in which the contact has been enrolled.
Currently in Sequence	Bool	True		True	Indicates whether the contact is currently active in a sales sequence.
testpurge	String	True		True	Placeholder field used for testing purge operations.
testrollback	String	True		True	Placeholder field used for testing rollback operations.
Time between contact creation and deal close	Decimal	False		True	Total time elapsed between the contact's creation and the closing of an associated deal.
Time between contact creation and deal creation	Decimal	False		True	Total time elapsed between the contact's creation and the creation of an associated deal.
Time in Customer (Lifecycle Stage Pipeline)	Decimal	True		True	Total time in seconds the contact spent in the 'Customer' stage within the Lifecycle Stage Pipeline.
Time in Evangelist (Lifecycle Stage Pipeline)	Decimal	True		True	Total time in seconds the contact spent in the 'Evangelist' stage within the Lifecycle Stage Pipeline.
Time in Lead (Lifecycle Stage Pipeline)	Decimal	True		True	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		True	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		True	Total time in seconds the contact spent in the 'Opportunity' stage within the Lifecycle Stage Pipeline.
Time in Other (Lifecycle Stage Pipeline)	Decimal	True		True	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		True	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		True	Total time in seconds the contact spent in the 'Subscriber' stage within the Lifecycle Stage Pipeline.
Lead response time	Decimal	True		True	Time in milliseconds it took for the contact owner to make the first qualifying engagement. Used in Sales Analytics.
Time to move from lead to customer	Decimal	False		True	Time it took for the contact to progress from the Lead stage to the Customer stage.
Time to move from marketing qualified lead to customer	Decimal	False		True	Time it took for the contact to progress from the Marketing Qualified Lead stage to the Customer stage.
Time to move from opportunity to customer	Decimal	False		True	Time it took for the contact to progress from the Opportunity stage to the Customer stage.
Time to move from sales qualified lead to customer	Decimal	False		True	Time it took for the contact to progress from the Sales Qualified Lead stage to the Customer stage.
Time to move from subscriber to customer	Decimal	False		True	Time it took for the contact to progress from the Subscriber stage to the Customer stage.
Time Zone	String	False		True	Time zone associated with the contact, either set automatically by HubSpot or manually assigned.
Twitter ID	String	False		True	Unique identifier for the contact's Twitter account.
Unique creation key	String	True		True	Unique key used to ensure idempotent creation of the contact record.
Updated by user ID	Decimal	True		True	User ID of the person who last updated the contact record. Managed automatically by HubSpot.
User IDs of all notification followers	String	True		True	List of user IDs who have opted to receive notifications for updates related to this contact.
User IDs of all notification unfollowers	String	True		True	List of user IDs who opted out of receiving notifications about this contact.
User IDs of all owners	String	True		True	List of user IDs assigned as owners of this contact.
WhatsApp Phone Number	String	False		True	Phone number linked to the contact's WhatsApp account.
Owner Assigned Date	Datetime	True		True	Date and time when the contact was last assigned to a HubSpot owner. Set automatically.
IP City	String	True		True	City detected from the contact's IP address. Set automatically for segmentation and reporting.
IP Country	String	True		True	Country detected from the contact's IP address. Set automatically by HubSpot.
IP Country Code	String	True		True	Country code detected from the contact's IP address. Set automatically by HubSpot.
IP Latitude _ Longitude	String	True		True	Latitude and longitude coordinates detected from the contact's IP address.
IP State_Region	String	True		True	State or region detected from the contact's IP address. Set automatically by HubSpot.
IP State Code_Region Code	String	True		True	State or region code detected from the contact's IP address. Set automatically by HubSpot.
IP Zipcode	String	True		True	ZIP or postal code detected from the contact's IP address. Set automatically.
Job function	String	False		True	The contact's job function. Required for Facebook Ads Integration; synced automatically from Lead Ads.
Last Modified Date	Datetime	True		True	Date when any property on the contact was last updated.
Marital Status	String	False		True	The contact's marital status. Required for Facebook Ads Integration; synced automatically from Lead Ads.
Military status	String	False		True	The contact's military status. Required for Facebook Ads Integration; synced automatically from Lead Ads.
Number of Associated Deals	Decimal	True		True	Total number of deals linked to this contact. Set automatically by HubSpot.
Number of Form Submissions	Decimal	True		True	Total number of forms submitted by this contact.
Number of Unique Forms Submitted	Decimal	True		True	Number of distinct forms submitted by this contact.
Recent Conversion Date	Datetime	True		True	Date when the contact last submitted a form.
Recent Conversion	String	True		True	Name of the most recent form submitted by the contact.
Recent Deal Amount	Decimal	True		True	Value of the most recent closed-won deal associated with this contact.
Recent Deal Close Date	Datetime	True		True	Date when the most recent associated deal was marked as closed-won.
Relationship Status	String	False		True	The contact's relationship status. Required for Facebook Ads Integration; synced automatically from Lead Ads.
School	String	False		True	The contact's school name. Required for Facebook Ads Integration; synced automatically from Lead Ads.
Seniority	String	False		True	The contact's seniority level. Required for Facebook Ads Integration; synced automatically from Lead Ads.
Start date	String	False		True	The contact's job start date. Required for Facebook Ads Integration; synced automatically from Lead Ads.
Total Revenue	Decimal	True		True	Sum of revenue from all closed-won deals associated with this contact. Set automatically.
Work email	String	False		True	The contact's work email address. Required for Facebook Ads Integration; synced automatically from Lead Ads.
First Name	String	False		True	The contact's first name.
First Page Seen	String	True		True	The first page visited by the contact on your website. Set automatically.
Marketing emails delivered	Decimal	True		True	Total number of marketing emails delivered to this contact. Set automatically by HubSpot.
Opted out of emailCustomer Service Communication	String	True		True	Indicates if the contact has opted out of customer service-related emails.
Opted out of emailOne to One	String	True		True	Custom field indicating if the contact has opted out of one-to-one emails.
Twitter Username	String	False		True	The contact's Twitter handle.
Currently in workflow	String	True		True	Indicates if the contact is actively enrolled in a HubSpot workflow.
Follower Count	Decimal	False		True	The number of Twitter followers associated with the contact.
Last Page Seen	String	True		True	The last page visited by the contact on your website. Set automatically.
Marketing emails opened	Decimal	True		True	Total number of marketing emails opened by this contact. Set automatically.
Last Name	String	False		True	The contact's last name.
Number of Pageviews	Decimal	True		True	Total number of website page views recorded for this contact. Set automatically.
Marketing emails clicked	Decimal	True		True	Total number of marketing emails clicked by the contact. Set automatically.
Salutation	String	False		True	The title or greeting used to address the contact, such as Mr., Ms., or Dr.
Twitter Profile Photo	String	False		True	URL of the contact's Twitter profile photo, set automatically by HubSpot.
Email	String	False		True	The primary email address associated with the contact.
Number of Sessions	Decimal	True		True	Total number of sessions, or visits, the contact has initiated on your website. Set automatically.
Marketing emails bounced	Decimal	True		True	Total number of marketing emails that bounced for this contact. Set automatically.
Persona	String	False		True	Persona assigned to the contact, used for marketing segmentation and targeting.
Most Recent Social Click	Datetime	True		True	Date of the most recent click by the contact on a published social media post. Set automatically.
Number of event completions	Decimal	True		True	Total number of event completions by the contact, such as webinars or surveys. Set automatically.
Unsubscribed from all email	Bool	True		True	Indicates whether the contact has opted out of receiving all email communications.
Twitter Clicks	Decimal	True		True	Number of clicks made by the contact on links shared through Twitter posts managed by HubSpot. Set automatically.
Mobile Phone Number	String	False		True	The contact's mobile phone number.
Phone Number	String	False		True	The primary phone number for the contact.
Fax Number	String	False		True	The contact's fax number, if available.
Time First Seen	Datetime	True		True	Timestamp of the first time the contact visited your website. Set automatically.
Last marketing email name	String	True		True	Name of the last marketing email sent to the contact. Set automatically.
Last marketing email send date	Datetime	True		True	Date when the most recent marketing email was sent to the contact. Set automatically.
Facebook Clicks	Decimal	True		True	Number of times the contact clicked on links shared via Facebook posts. Set automatically.
Street Address	String	False		True	Street address for the contact, including apartment or unit number if applicable.
Date of last meeting booked in meetings tool	Datetime	True		True	Date when the last meeting was scheduled by the contact using the meetings tool.
Campaign of last booking in meetings tool	String	True		True	UTM campaign parameter identifying the campaign responsible for the last meeting booked.
Medium of last booking in meetings tool	String	True		True	UTM medium parameter identifying the channel (such as email) responsible for the last meeting booking.
Source of last booking in meetings tool	String	True		True	UTM source parameter identifying the site (such as LinkedIn or Twitter) responsible for the last meeting booking.
Time of First Session	Datetime	True		True	Timestamp of the first session initiated by the contact on your website. Set automatically.
Last marketing email open date	Datetime	True		True	Date when the contact last opened a marketing email. Set automatically.
Latest meeting activity	Datetime	True		True	Date of the most recent meeting, whether past or upcoming, involving the contact.
Recent Sales Email Replied Date	Datetime	True		True	Date when the contact last replied to a tracked sales email. Set automatically by HubSpot.
LinkedIn Clicks	Decimal	True		True	Total number of times the contact clicked on links shared via LinkedIn posts. Set automatically.
Contact owner	String	False		True	The HubSpot or Salesforce user assigned as the primary owner of the contact.
Last Contacted	Datetime	True		True	The date and time when the contact was last contacted via a call, email, or meeting. Set automatically based on user actions.
Last Activity Date	Datetime	True		True	The date and time of the last logged activity, such as a note, call, email, or task, involving the contact. Set automatically.
Next Activity Date	Datetime	True		True	The date of the next scheduled activity, such as a call, task, or meeting, involving the contact.
Number of times contacted	Decimal	True		True	Total number of logged calls, emails, or meetings made with the contact. Set automatically by HubSpot.
Number of Sales Activities	Decimal	True		True	Total number of sales-related activities logged for the contact, including calls, emails, and meetings.
HubSpot Owner Email _legacy_	String	False		True	Legacy field capturing the email address of the contact's owner. No longer actively updated.
HubSpot Owner Name _legacy_	String	False		True	Legacy field capturing the name of the contact's owner. No longer actively updated.
SurveyMonkey Event Last Updated	Decimal	True		True	Internal field used to trigger updates when SurveyMonkey event data is refreshed.
Webinar Event Last Updated	Decimal	True		True	Internal field used to trigger updates when webinar event data is refreshed.
City	String	False		True	The city of residence for the contact. Can be set manually, by import, or via forms.
Time Last Seen	Datetime	True		True	Timestamp when the contact was most recently seen on your website. Set automatically.
Last marketing email click date	Datetime	True		True	Date when the contact last clicked a link inside a marketing email. Set automatically.
Google Plus Clicks	Decimal	True		True	Total number of times the contact clicked on links shared via Google Plus posts. Set automatically.
HubSpot Team	String	True		True	Team assignment of the contact's owner within HubSpot.
LinkedIn Bio	String	False		True	Biography or professional summary of the contact pulled from LinkedIn, if available.
Twitter Bio	String	False		True	Contact's biography from their Twitter profile, populated automatically if linked.
All owner ids	String	True		True	List of all owner IDs, including default and custom owners, associated with the contact.
Time of Last Session	Datetime	True		True	Timestamp marking the beginning of the contact's most recent website session.
First marketing email send date	Datetime	True		True	Date when the first marketing email was sent to the contact. Set automatically.
Broadcast Clicks	Decimal	True		True	Number of clicks by the contact on published social media messages. Set automatically.
State_Region	String	False		True	State or region of residence for the contact. Can be populated via import, form, or integration.
All team ids	String	True		True	List of team IDs related to the contact's ownership, including default and custom fields.
Original Source	String	False		True	The first recorded source through which the contact discovered your business, such as organic search or paid social. Set automatically.
First marketing email open date	Datetime	True		True	Date when the contact first opened a marketing email. Set automatically.
Latest Source	String	False		True	Source of the contact's most recent session or interaction, such as direct traffic or referral.
Postal Code	String	False		True	Postal or ZIP code for the contact's address. Can be set manually or via forms.
Country_Region	String	False		True	Country or region associated with the contact's address. Can be set via import, form, or integration.
All accessible team ids	String	True		True	List of all accessible team IDs associated with the contact, including inherited ownership.
Original Source DrillDown 1	String	True		True	Additional detail about the original source that brought the contact to your business. Set automatically.
First marketing email click date	Datetime	True		True	Date when the contact first clicked a link in a marketing email. Set automatically.
Latest Source DrillDown 1	String	True		True	Additional detail about the source of the latest session recorded for the contact. Set automatically.
LinkedIn Connections	Decimal	False		True	The number of LinkedIn connections associated with the contact, if available.
Original Source DrillDown 2	String	True		True	Further breakdown of how the contact first discovered your business. Set automatically.
Is globally ineligible	Bool	True		True	Indicates whether the contact is globally ineligible to receive any marketing emails.
Preferred language	String	False		True	The preferred language of communication for the contact. Set manually or via forms, imports, or integrations.
Latest Source DrillDown 2	String	True		True	Further detail about the source of the contact's latest session. Set automatically.
Klout Score	Decimal	False		True	The contact's Klout Score, a measure of social media influence (retained for legacy use).
First Referring Site	String	True		True	URL of the site that first referred the contact to your website. Set automatically by HubSpot.
First marketing email reply date	Datetime	True		True	Date when the contact first replied to a marketing email. Set automatically.
Job Title	String	False		True	The contact's job title, collected through forms, imports, or integrations.
Photo	String	False		True	URL of the contact's social media profile photo, populated automatically if available.
Last Referring Site	String	True		True	URL of the last site that referred the contact to your website. Set automatically.
Last marketing email reply date	Datetime	True		True	Date when the contact most recently replied to a marketing email. Set automatically.
Message	String	False		True	General-purpose field for capturing a contact's message or comment submitted through a form.
Close Date	Datetime	False		True	Date when the contact was marked as a customer, usually tied to a closed-won deal.
Average Pageviews	Decimal	True		True	Average number of pageviews per session by the contact on your website. Set automatically.
Marketing emails replied	Decimal	True		True	Total number of marketing emails to which the contact has replied. Set automatically.
Event Revenue	Decimal	True		True	Revenue value attributed to the contact through tracked events. Used with Enterprise Events features.
Became a Lead Date	Datetime	True		True	Date when the contact's lifecycle stage changed to Lead. Set automatically.
Became a Marketing Qualified Lead Date	Datetime	True		True	Date when the contact's lifecycle stage changed to Marketing Qualified Lead (MQL). Set automatically.
Became an Opportunity Date	Datetime	True		True	Date when the contact's lifecycle stage changed to Opportunity. Set automatically.
Lifecycle Stage	String	False		True	The contact's current lifecycle stage, such as Subscriber, Lead, Customer, or Evangelist.
Became a Sales Qualified Lead Date	Datetime	True		True	Date when the contact's lifecycle stage changed to Sales Qualified Lead (SQL). Set automatically.
Create Date	Datetime	True		True	Date when the contact record was originally created in HubSpot.
Became an Evangelist Date	Datetime	True		True	Date when the contact's lifecycle stage changed to Evangelist. Set automatically.
Became a Customer Date	Datetime	True		True	Date when the contact's lifecycle stage changed to Customer. Set automatically.
HubSpot Score	Decimal	True		True	A numerical lead score reflecting the contact's qualification based on behavior and profile properties.
Company Name	String	False		True	The name of the company associated with the contact. Can differ from the associated company's name in HubSpot.
Became a Subscriber Date	Datetime	True		True	Date when the contact's lifecycle stage changed to Subscriber. Set automatically.
Became an Other Lifecycle Date	Datetime	True		True	Date when the contact's lifecycle stage changed to 'Other'. Set automatically.
Website URL	String	False		True	Website URL of the contact's associated company.
Number of Employees	String	False		True	The number of employees at the contact's associated company.
Annual Revenue	String	False		True	Annual revenue of the contact's associated company.
Industry	String	False		True	Industry classification of the contact's associated company.
Primary Associated Company ID	Decimal	False		True	Unique HubSpot ID of the primary company associated with the contact.
Associated Company Last Updated	Decimal	True		True	Internal field used to trigger updates when company information changes.
Lead Rating	String	True		True	Categorical lead rating assigned based on predictive scoring models, such as Hot, Warm, or Cold.
Predictive Lead Score	Decimal	True		True	A predictive score indicating the likelihood of the contact becoming a customer based on HubSpot's machine learning models.

ODBC Driver for HubSpot