CData Python Connector for HubSpot

Build 23.0.8839

Contacts

Retrieve the available Contacts in HubSpot. his table supports both OAuth and PrivateAppToken authentications.

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.

Company size String False True

Contact's company size. Required for the Facebook Ads Integration. Automatically synced from the Lead Ads tool.

Date of birth String False True

Contact's date of birth. Required for the Facebook Ads Integration. Automatically synced from the Lead Ads tool.

Days To Close Decimal True True

Count of days elapsed between creation and being closed as a customer. Set automatically.

Degree String False True

Contact's degree. Required for the Facebook Ads Integration. Automatically synced from the Lead Ads tool.

Field of study String False True

Contact's field of study. Required for the Facebook Ads Integration. Automatically synced from the Lead Ads tool.

First Conversion Date Datetime True True

Date this contact first submitted a form.

First Conversion String True True

First form this contact submitted.

First Deal Created Date Datetime True True

Date first deal was created for contact. Set automatically.

Gender String False True

Contact's gender. Required for the Facebook Ads Integration. Automatically synced from the Lead Ads tool.

Graduation date String False True

Contact's graduation date. Required for the Facebook Ads Integration. Automatically synced from the Lead Ads tool.

Additional email addresses String True True

A set of additional email addresses for a contact

Business units String False True

The business units this record is assigned to.

All vids for a contact String True True

A set of all vids_ canonical or otherwise_ for a contact

First Touch Converting Campaign String True True

Campaign responsible for the first touch creation of this contact.

Last Touch Converting Campaign String True True

Campaign responsible for the last touch creation of this contact.

Avatar FileManager key String True True

The path in the FileManager CDN for this contact's avatar override image. Automatically set by HubSpot.

Buying Role String False True

Role the contact plays during the sales process. Contacts can have multiple roles_ and can share roles with others.

All form submissions for a contact String True True

A set of all form submissions for a contact

Merged vids with timestamps of a contact String True True

Merged vids with timestamps of a contact

Calculated Mobile Number in International Format String True True

Mobile number in international format

Calculated Phone Number in International Format String True True

Phone number in international format

Calculated Phone Number Area Code String True True

Area Code of the calculated phone number

Calculated Phone Number Country Code String True True

Country code of the calculated phone number

Calculated Phone Number Region String True True

ISO2 Country code for the derived phone number

Clicked on a LinkedIn Ad String False True

Whether contact has clicked on a LinkedIn Ad

Email Confirmed Bool True True

Email Confirmation status of user of Content Membership

Registration Follow Up Email Enqueued At Datetime False True

The time when the first registration follow up email was enqueued

Membership Notes String False True

Notes relating to the contact's content membership.

Registered At Datetime True True

Datetime at which this user was set up for Content Membership

Domain to which registration email was sent String True True

Domain to which the registration invitation email for Content Membership was sent to

Time registration email was sent Datetime True True

Datetime at which this user was sent a registration invitation email for Content Membership

Status String False True

Status of the contact's content membership.

Conversations visitor email String True True

A Conversations visitor's email address

Count of unengaged contacts Decimal True True

if contact is assigned and unworked_ set to 1. if contact is assigned and worked_ set to 0.

Count of engaged contacts Decimal True True

if contact is assigned and worked_ set to 1. if contact is assigned and unworked_ set to 0.

Created By Conversations Bool True True

Flag indicating this contact was created by the Conversations API

Created by user ID Decimal True True

The user that created this object. This value is automatically set by HubSpot and may not be modified.

Object create date_time Datetime True True

The date and time at which this object was created. This value is automatically set by HubSpot and may not be modified.

Date entered 'Customer _Lifecycle Stage Pipeline_' Datetime True True

The date and time when the contact entered the 'Customer' stage_ 'Lifecycle Stage Pipeline' pipeline

Date entered 'Evangelist _Lifecycle Stage Pipeline_' Datetime True True

The date and time when the contact entered the 'Evangelist' stage_ 'Lifecycle Stage Pipeline' pipeline

Date entered 'Lead _Lifecycle Stage Pipeline_' Datetime True True

The date and time when the contact entered the 'Lead' stage_ 'Lifecycle Stage Pipeline' pipeline

Date entered 'Marketing Qualified Lead _Lifecycle Stage Pipeline_' Datetime True True

The date and time when the contact entered the 'Marketing Qualified Lead' stage_ 'Lifecycle Stage Pipeline' pipeline

Date entered 'Opportunity _Lifecycle Stage Pipeline_' Datetime True True

The date and time when the contact entered the 'Opportunity' stage_ 'Lifecycle Stage Pipeline' pipeline

Date entered 'Other _Lifecycle Stage Pipeline_' Datetime True True

The date and time when the contact entered the 'Other' stage_ 'Lifecycle Stage Pipeline' pipeline

Date entered 'Sales Qualified Lead _Lifecycle Stage Pipeline_' Datetime True True

The date and time when the contact entered the 'Sales Qualified Lead' stage_ 'Lifecycle Stage Pipeline' pipeline

Date entered 'Subscriber _Lifecycle Stage Pipeline_' Datetime True True

The date and time when the contact entered the 'Subscriber' stage_ 'Lifecycle Stage Pipeline' pipeline

Date exited 'Customer _Lifecycle Stage Pipeline_' Datetime True True

The date and time when the contact exited the 'Customer' stage_ 'Lifecycle Stage Pipeline' pipeline

Date exited 'Evangelist _Lifecycle Stage Pipeline_' Datetime True True

The date and time when the contact exited the 'Evangelist' stage_ 'Lifecycle Stage Pipeline' pipeline

Date exited 'Lead _Lifecycle Stage Pipeline_' Datetime True True

The date and time when the contact exited the 'Lead' stage_ 'Lifecycle Stage Pipeline' pipeline

Date exited 'Marketing Qualified Lead _Lifecycle Stage Pipeline_' Datetime True True

The date and time when the contact exited the 'Marketing Qualified Lead' stage_ 'Lifecycle Stage Pipeline' pipeline

Date exited 'Opportunity _Lifecycle Stage Pipeline_' Datetime True True

The date and time when the contact exited the 'Opportunity' stage_ 'Lifecycle Stage Pipeline' pipeline

Date exited 'Other _Lifecycle Stage Pipeline_' Datetime True True

The date and time when the contact exited the 'Other' stage_ 'Lifecycle Stage Pipeline' pipeline

Date exited 'Sales Qualified Lead _Lifecycle Stage Pipeline_' Datetime True True

The date and time when the contact exited the 'Sales Qualified Lead' stage_ 'Lifecycle Stage Pipeline' pipeline

Date exited 'Subscriber _Lifecycle Stage Pipeline_' Datetime True True

The date and time when the contact exited the 'Subscriber' stage_ 'Lifecycle Stage Pipeline' pipeline

Recent Document Revisit Date Datetime True True

The last time a shared document _presentation_ was accessed by this contact

Invalid email address Bool True True

The email address associated with this contact is invalid.

Email address quarantine reason String False True

The reason why the email address has been quarantined.

Email Domain String True True

A contact's email address domain

Email hard bounce reason String True True

The issue that caused a contact to hard bounce from your emails. If this is an error or a temporary issue_ you can unbounce this contact from the contact record.

Email hard bounce reason2 String True True

The issue that caused a contact to hard bounce from your emails. If this is an error or a temporary issue_ you can unbounce this contact from the contact record.

Email Address Quarantined Bool True True

Indicates that the current email address has been quarantined for anti_abuse reasons and any marketing email sends to it will be blocked. This is automatically set by HubSpot.

Email address automated quarantine reason String True True

The automated reason why the email address has been quarantined.

Email Address Recipient Fatigue Next Available Sending Time Datetime True True

When this recipient has reached the limit of email sends per time period_ this property indicates the next available time to send. This is automatically set by HubSpot.

Sends Since Last Engagement Decimal True True

The number of marketing emails that have been sent to the current email address since the last engagement _open or link click_. This is automatically set by HubSpot.

Marketing email confirmation status String True True

The status of a contact's eligibility to receive marketing email. This is automatically set by HubSpot.

Clicked Facebook ad Bool False True

Whether contact has clicked a Facebook ad

Facebook click id String False True

Facebook ID String False True

A contact's facebook id

Last NPS survey comment String True True

Last NPS survey comment that this contact gave

Last NPS survey rating String True True

Last NPS survey rating that this contact gave

Last NPS survey date Datetime True True

The time that this contact last submitted a NPS survey response. This is automatically set by HubSpot.

Should be shown an NPS web survey Bool False True

Whether or not a contact should be shown an NPS web survey. This is automatically set by HubSpot.

ID of first engagement Decimal True True

The object id of the current contact owner's first engagement with the contact. Used in Sales Analytics app.

First subscription create date Datetime True True

The create date of the first subscription by the contact.

Google ad click id String False True

googleplus ID String False True

A contact's googleplus id

Contact has an active subscription Decimal True True

The rollup property value is 1 when the contact has an active Subscription or 0 otherwise.

IP Timezone String True True

The timezone reported by a contact's IP address. This is automatically set by HubSpot and can be used for segmentation and reporting.

Is a contact Bool True True

Is a contact_ has not been deleted and is not a visitor

Contact unworked Bool True True

Contact has not been assigned or has not been engaged after last owner assignment_re_assignment

last sales activity date old Datetime True True

The date of the last sales activity with the contact. This property is set automatically by HubSpot. Note_ This field is only updated for contacts with an owner.

Last Engagement Date Datetime True True

The last time a contact engaged with your site or a form_ document_ meetings link_ or tracked email. This doesn't include marketing emails or emails to multiple contacts.

Last Engagement Type String True True

The type of the last engagement a contact performed. This doesn't include marketing emails or emails to multiple contacts.

Object last modified date_time Datetime True True

Most recent timestamp of any property update for this contact. This includes HubSpot internal properties_ which can be visible or hidden. This property is updated automatically.

Last sequence ended date Datetime True True

The last sequence ended date.

Last sequence enrolled Decimal True True

The last sequence enrolled.

Last sequence enrolled date Datetime True True

The last sequence enrolled date.

Last sequence finished date Datetime True True

The last sequence finished date.

Last sequence unenrolled date Datetime True True

The last sequence unenrolled date.

Latest Source Date Date False True

The time of the latest session for a contact

Latest subscription create date Datetime True True

The create date of the latest subscription by the contact.

Lead Status String False True

The contact's sales_ prospecting or outreach status

Legal basis for processing contact's data String False True

Legal basis for processing contact's data_ 'Not applicable' will exempt the contact from GDPR protections

Clicked LinkedIn Ad String False True

Linkedin ID String False True

A contact's linkedin id

Marketing contact status source name String True True

The ID of the activity that set the contact as a marketing contact

Marketing contact status source type String True True

The type of the activity that set the contact as a marketing contact

Marketing contact status String True True

The marketing status of a contact

Marketing contact until next update String True True

Specifies if this contact will be set as non_marketing on renewal

Merged object IDs String True True

The list of object IDs that have been merged into this object. This value is automatically set by HubSpot and may not be modified.

Record ID Decimal True True

The unique ID for this record. This value is automatically set by HubSpot and may not be modified.

Pinned engagement ID Decimal True True

Pipeline String False True

The pipeline with which this contact is currently associated

Likelihood to close Decimal True True

The probability that a contact will become a customer within the next 90 days. This score is based on standard contact properties and behavior.

Contact priority String True True

A ranking system of contacts evenly assigned into four tiers. Contacts in tier one are more likely to become customers than contacts in tier four.

Read Only Object Bool True True

Is the object read only

Date of first engagement Datetime True True

The date the current contact owner first engaged with the contact. Used in Sales Analytics app.

Description of first engagement String True True

A description of the current contact owner's first engagement with the contact. Used in the Sales Analytics app.

Type of first engagement String True True

The object type of the current contact owner's first engagement with the contact. Used in the Sales Analytics app.

Recent Sales Email Clicked Date Datetime True True

The last time a tracked sales email was clicked by this user

Recent Sales Email Opened Date Datetime True True

The last time a tracked sales email was opened by this contact. This property does not update for emails that were sent to more than one contact.

Calculated Mobile Number with country code String True True

Mobile number with country code

Calculated Phone Number with country code String True True

Phone number with country code

Calculated Mobile Number without country code String True True

Mobile number without country code

Calculated Phone Number without country code String True True

Phone number without country code

Number of sequences actively enrolled Decimal True True

The number of sequences actively enrolled.

Number of sequences enrolled Decimal True True

The number of sequences enrolled.

Currently in Sequence Bool True True

A yes_no field that indicates whether the contact is currently in a Sequence.

testpurge String True True

testing purge

testrollback String True True

testing rollback

Time between contact creation and deal close Decimal False True

Time between contact creation and deal creation Decimal False True

Time in 'Customer _Lifecycle Stage Pipeline_' Decimal True True

The total time in seconds spent by the contact in the 'Customer' stage_ 'Lifecycle Stage Pipeline' pipeline

Time in 'Evangelist _Lifecycle Stage Pipeline_' Decimal True True

The total time in seconds spent by the contact in the 'Evangelist' stage_ 'Lifecycle Stage Pipeline' pipeline

Time in 'Lead _Lifecycle Stage Pipeline_' Decimal True True

The total time in seconds spent by the contact in the 'Lead' stage_ 'Lifecycle Stage Pipeline' pipeline

Time in 'Marketing Qualified Lead _Lifecycle Stage Pipeline_' Decimal True True

The total time in seconds spent by the contact in the 'Marketing Qualified Lead' stage_ 'Lifecycle Stage Pipeline' pipeline

Time in 'Opportunity _Lifecycle Stage Pipeline_' Decimal True True

The total time in seconds spent by the contact in the 'Opportunity' stage_ 'Lifecycle Stage Pipeline' pipeline

Time in 'Other _Lifecycle Stage Pipeline_' Decimal True True

The total time in seconds spent by the contact in the 'Other' stage_ 'Lifecycle Stage Pipeline' pipeline

Time in 'Sales Qualified Lead _Lifecycle Stage Pipeline_' Decimal True True

The total time in seconds spent by the contact in the 'Sales Qualified Lead' stage_ 'Lifecycle Stage Pipeline' pipeline

Time in 'Subscriber _Lifecycle Stage Pipeline_' Decimal True True

The total time in seconds spent by the contact in the 'Subscriber' stage_ 'Lifecycle Stage Pipeline' pipeline

Lead response time Decimal True True

Time it took current owner to do first qualifying engagement _ms_. Used in Sales Analytics app.

Time to move from lead to customer Decimal False True

How long it takes for a contact to move from the HubSpot lead stage to the HubSpot customer stage.

Time to move from marketing qualified lead to customer Decimal False True

How long it takes for a contact to move from the HubSpot marketing qualified lead stage to the HubSpot customer stage.

Time to move from opportunity to customer Decimal False True

How long it takes for a contact to move from the HubSpot opportunity stage to the HubSpot customer stage.

Time to move from sales qualified lead to customer Decimal False True

How long it takes for a contact to move from the HubSpot sales qualified lead stage to the HubSpot customer stage.

Time to move from subscriber to customer Decimal False True

How long it takes for a contact to move from the HubSpot subscriber stage to the HubSpot customer stage.

Time Zone String False True

The contact_s time zone. This can be set automatically by HubSpot based on other contact properties. It can also be set manually for each contact.

Twitter ID String False True

A contact's twitter id

Unique creation key String True True

Unique property used for idempotent creates

Updated by user ID Decimal True True

The user that last updated this object. This value is automatically set by HubSpot and may not be modified.

User IDs of all notification followers String True True

The user IDs of all users that have clicked follow within the object to opt_in to getting follow notifications

User IDs of all notification unfollowers String True True

The user IDs of all object owners that have clicked unfollow within the object to opt_out of getting follow notifications

User IDs of all owners String True True

The user IDs of all owners of this object

WhatsApp Phone Number String False True

The phone number associated with the contact_s WhatsApp account.

Owner Assigned Date Datetime True True

The most recent date a HubSpot Owner was assigned to a contact. This is set automatically by HubSpot and can be used for segmentation and reporting.

IP City String True True

The city reported by a contact's IP address. This is automatically set by HubSpot and can be used for segmentation and reporting.

IP Country String True True

The country reported by a contact's IP address. This is automatically set by HubSpot and can be used for segmentation and reporting.

IP Country Code String True True

The country code reported by a contact's IP address. This is automatically set by HubSpot and can be used for segmentation and reporting.

IP Latitude _ Longitude String True True

IP State_Region String True True

The state or region reported by a contact's IP address. This is automatically set by HubSpot and can be used for segmentation and reporting.

IP State Code_Region Code String True True

The state code or region code reported by a contact's IP address. This is automatically set by HubSpot and can be used for segmentation and reporting.

IP Zipcode String True True

The zipcode reported by a contact's IP address. This is automatically set by HubSpot and can be used for segmentation and reporting.

Job function String False True

Contact's job function. Required for the Facebook Ads Integration. Automatically synced from the Lead Ads tool.

Last Modified Date Datetime True True

The date any property on this contact was modified

Marital Status String False True

Contact's marital status. Required for the Facebook Ads Integration. Automatically synced from the Lead Ads tool.

Military status String False True

Contact's military status. Required for the Facebook Ads Integration. Automatically synced from the Lead Ads tool.

Number of Associated Deals Decimal True True

Count of deals associated with this contact. Set automatically by HubSpot.

Number of Form Submissions Decimal True True

The number of forms this contact has submitted

Number of Unique Forms Submitted Decimal True True

The number of different forms this contact has submitted

Recent Conversion Date Datetime True True

The date this contact last submitted a form

Recent Conversion String True True

The last form this contact submitted

Recent Deal Amount Decimal True True

Amount of last closed won deal associated with a contact. Set automatically.

Recent Deal Close Date Datetime True True

Date last deal associated with contact was closed_won. Set automatically.

Relationship Status String False True

Contact's relationship status. Required for the Facebook Ads Integration. Automatically synced from the Lead Ads tool.

School String False True

Contact's school. Required for the Facebook Ads Integration. Automatically synced from the Lead Ads tool.

Seniority String False True

Contact's seniority. Required for the Facebook Ads Integration. Automatically synced from the Lead Ads tool.

Start date String False True

Contact's start date. Required for the Facebook Ads Integration. Automatically synced from the Lead Ads tool.

Total Revenue Decimal True True

Sum of all closed_won deal revenue associated with the contact. Set automatically.

Work email String False True

Contact's work email. Required for the Facebook Ads Integration. Automatically synced from the Lead Ads tool.

First Name String False True

A contact's first name

First Page Seen String True True

First page the contact visited on your website. Set automatically.

Marketing emails delivered Decimal True True

The number of marketing emails delivered for the current email address. This is automatically set by HubSpot.

Opted out of emailCustomer Service Communication String True True

Indicates that the current email address has opted out of this email type.

Opted out of emailOne to One String True True

This column is a custom field. Indicates that the current email address has opted out of this email type.

Twitter Username String False True

The contact's Twitter handle.

Currently in workflow String True True

True when contact is enrolled in a workflow.

Follower Count Decimal False True

The number of Twitter followers a contact has

Last Page Seen String True True

Last page the contact visited on your website. Set automatically.

Marketing emails opened Decimal True True

The number of marketing emails opened for the current email address. This is automatically set by HubSpot.

Last Name String False True

A contact's last name

Number of Pageviews Decimal True True

Total number of page views this contact has had on your website. Set automatically.

Marketing emails clicked Decimal True True

The number of marketing emails which have had link clicks for the current email address. This is automatically set by HubSpot.

Salutation String False True

The title used to address a contact

Twitter Profile Photo String False True

The contact's Twitter profile photo. This is set by HubSpot using the contact's email address.

Email String False True

A contact's email address

Number of Sessions Decimal True True

Number of times a contact has come to your website. Set automatically.

Marketing emails bounced Decimal True True

The number of marketing emails that bounced for the current email address. This is automatically set by HubSpot.

Persona String False True

A contact's persona

Most Recent Social Click Datetime True True

The date of the most recent click on a published social message. This is set automatically by HubSpot for each contact.

Number of event completions Decimal True True

Total number of events for this contact. Set automatically.

Unsubscribed from all email Bool True True

Indicates that the current email address has opted out of all email.

Twitter Clicks Decimal True True

The number of times a contact clicked on links you shared on Twitter through HubSpot. This is set automatically by HubSpot and can be used for segmentation.

Mobile Phone Number String False True

A contact's mobile phone number

Phone Number String False True

A contact's primary phone number

Fax Number String False True

A contact's primary fax number

Time First Seen Datetime True True

First time the contact has been seen. Set automatically.

Last marketing email name String True True

The name of the last marketing email sent to the current email address. This is automatically set by HubSpot.

Last marketing email send date Datetime True True

The date of the most recent delivery for any marketing email to the current email address. This is automatically set by HubSpot.

Facebook Clicks Decimal True True

The number clicks on links shared on Facebook

Street Address String False True

Contact's street address_ including apartment or unit number.

Date of last meeting booked in meetings tool Datetime True True

The date of the last meeting that has been scheduled by a contact through the meetings tool. If multiple meetings have been scheduled_ the date of the last chronological meeting in the timeline is shown.

Campaign of last booking in meetings tool String True True

UTM parameter for marketing campaign _e.g. a specific email_ responsible for recent meeting booking. Only populated when tracking parameters are included in meeting link.

Medium of last booking in meetings tool String True True

UTM parameter for the channel _e.g. email_ responsible for most recent meeting booking. Only populated when tracking parameters are included in meeting link.

Source of last booking in meetings tool String True True

UTM parameter for the site _e.g. Twitter_ responsible for most recent meeting booking. Only populated when tracking parameters are included in meeting link.

Time of First Session Datetime True True

First time the contact visited your website. Set automatically.

Last marketing email open date Datetime True True

The date of the most recent open for any marketing email to the current email address. This is automatically set by HubSpot.

Latest meeting activity Datetime True True

The date of the most recent meeting _past or upcoming_ logged for_ scheduled with_ or booked by this contact.

Recent Sales Email Replied Date Datetime True True

The last time a tracked sales email was replied to by this user. This is set automatically by HubSpot based on user actions in the contact record.

LinkedIn Clicks Decimal True True

The number clicks on links shared on LinkedIn

Contact owner String False True

The owner of a contact. This can be any HubSpot user or Salesforce integration user_ and can be set manually or via Workflows.

Last Contacted Datetime True True

The last time a call_ email_ or meeting was logged for a contact. This is set automatically by HubSpot based on user actions in the contact record.

Last Activity Date Datetime True True

The last time a note_ call_ email_ meeting_ or task was logged for a contact. This is set automatically by HubSpot based on user actions in the contact record.

Next Activity Date Datetime True True

The date of the next upcoming activity for a contact. This is set automatically by HubSpot based on user actions in the contact record.

Number of times contacted Decimal True True

The number of times a call_ email_ or meeting was logged for a contact. This is set automatically by HubSpot based on user actions in the contact record.

Number of Sales Activities Decimal True True

The number of sales activities for a contact. This is set automatically by HubSpot based on user actions in the contact record.

HubSpot Owner Email _legacy_ String False True

A legacy property used to identify the email address of the owner of the contact. This property is no longer in use.

HubSpot Owner Name _legacy_ String False True

A legacy property used to identify the name of the owner of the contact. This property is no longer in use.

SurveyMonkey Event Last Updated Decimal True True

This field is meaningless on its own_ and is solely used for triggering dynamic list updates when SurveyMonkey information is updated

Webinar Event Last Updated Decimal True True

This field is meaningless on its own_ and is solely used for triggering dynamic list updates when webinar information is updated

City String False True

A contact's city of residence

Time Last Seen Datetime True True

Timestamp for most recent webpage view on your website.

Last marketing email click date Datetime True True

The date of the most recent link click for any marketing email to the current email address. This is automatically set by HubSpot.

Google Plus Clicks Decimal True True

The number clicks on links shared on Google Plus

HubSpot Team String True True

The team of the owner of a contact.

LinkedIn Bio String False True

A contact's LinkedIn bio

Twitter Bio String False True

The contact's Twitter bio. This is set by HubSpot using the contact's email address.

All owner ids String True True

The value of all owner referencing properties for this object_ both default and custom

Time of Last Session Datetime True True

Timestamp for start of the most recent session for this contact to your website.

First marketing email send date Datetime True True

The date of the earliest delivery for any marketing email to the current email address. This is automatically set by HubSpot.

Broadcast Clicks Decimal True True

The number of clicks on published social messages. This is set automatically by HubSpot for each contact.

State_Region String False True

The contact's state of residence. This might be set via import_ form_ or integration.

All team ids String True True

The team ids corresponding to all owner referencing properties for this object_ both default and custom

Original Source String False True

First known source the contact used to find your website. Set automatically_ but may be updated manually.

First marketing email open date Datetime True True

The date of the earliest open for any marketing email to the current email address. This is automatically set by HubSpot.

Latest Source String False True

The source of the latest session for a contact

Postal Code String False True

The contact's zip code. This might be set via import_ form_ or integration.

Country_Region String False True

The contact's country_region of residence. This might be set via import_ form_ or integration.

All accessible team ids String True True

The team ids_ including up the team hierarchy_ corresponding to all owner referencing properties for this object_ both default and custom

Original Source DrillDown 1 String True True

Additional information about the source the contact used to find your website. Set automatically.

First marketing email click date Datetime True True

The date of the earliest link click for any marketing email to the current email address. This is automatically set by HubSpot.

Latest Source DrillDown 1 String True True

Additional information about the latest source for the last session the contact used to find your website. Set automatically.

LinkedIn Connections Decimal False True

How many LinkedIn connections they have

Original Source DrillDown 2 String True True

Additional information about the source the contact used to find your website. Set automatically.

Is globally ineligible Bool True True

Indicates the contact is globally ineligible for email.

Preferred language String False True

Set your contact's preferred language for communications. This property can be changed from an import_ form_ or integration.

Latest Source DrillDown 2 String True True

Additional information about the source for the last session the contact used to find your website. Set automatically.

Klout Score Decimal False True

A contact's Klout score_ a measure of Internet influence

First Referring Site String True True

URL that referred the contact to your website. Set automatically.

First marketing email reply date Datetime True True

The date of the earliest reply for any marketing email to the current email address. This is automatically set by HubSpot.

Job Title String False True

A contact's job title

Photo String False True

Social Media photo

Last Referring Site String True True

Last URL that referred contact to your website. Set automatically.

Last marketing email reply date Datetime True True

The date of the latest reply for any marketing email to the current email address. This is automatically set by HubSpot.

Message String False True

A default property to be used for any message or comments a contact may want to leave on a form.

Close Date Datetime False True

Date the contact became a customer. Set automatically when a deal or opportunity is marked as closed_won. It can also be set manually or programmatically.

Average Pageviews Decimal True True

Average number of pageviews per session for this contact. Set automatically.

Marketing emails replied Decimal True True

The number of marketing emails replied to by the current email address. This is automatically set by HubSpot.

Event Revenue Decimal True True

Set event revenue on a contact though the Enterprise Events feature. http___help.hubspot.com_articles_KCS_Article_Reports_How_do_I_create_Events_in_HubSpot

Became a Lead Date Datetime True True

The date when a contact's lifecycle stage changed to Lead. This is automatically set by HubSpot for each contact.

Became a Marketing Qualified Lead Date Datetime True True

The date when a contact's lifecycle stage changed to MQL. This is automatically set by HubSpot for each contact.

Became an Opportunity Date Datetime True True

The date when a contact's lifecycle stage changed to Opportunity. This is automatically set by HubSpot for each contact.

Lifecycle Stage String False True

The qualification of contacts to sales readiness. It can be set through imports_ forms_ workflows_ and manually on a per contact basis.

Became a Sales Qualified Lead Date Datetime True True

The date when a contact's lifecycle stage changed to SQL. This is automatically set by HubSpot for each contact.

Create Date Datetime True True

The date that a contact entered the system

Became an Evangelist Date Datetime True True

The date when a contact's lifecycle stage changed to Evangelist. This is automatically set by HubSpot for each contact.

Became a Customer Date Datetime True True

The date when a contact's lifecycle stage changed to Customer. This is automatically set by HubSpot for each contact.

HubSpot Score Decimal True True

The number that shows qualification of contacts to sales readiness. It can be set in HubSpot's Lead Scoring app.

Company Name String False True

Name of the contact's company. This can be set independently from the name property on the contact's associated company.

Became a Subscriber Date Datetime True True

The date when a contact's lifecycle stage changed to Subscriber. This is automatically set by HubSpot for each contact.

Became an Other Lifecycle Date Datetime True True

The date when a contact's lifecycle stage changed to Other. This is automatically set by HubSpot for each contact.

Website URL String False True

Associated company website.

Number of Employees String False True

The number of company employees

Annual Revenue String False True

Annual company revenue

Industry String False True

The Industry a contact is in

Primary Associated Company ID Decimal False True

HubSpot defined ID of a contact's primary associated company in HubSpot.

Associated Company Last Updated Decimal True True

This field is meaningless on its own_ and is solely used for triggering dynamic list updates when a company is updated

Lead Rating String True True

The rating of this contact based on their predictive lead score

Predictive Lead Score Decimal True True

A score calculated by HubSpot that represents a contact's likelihood to become a customer

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839