Power BI Connector for HubSpot

Build 24.0.9062

Contacts

Retrieve the available Contacts in HubSpot. This table supports both OAuth and PrivateAppToken authentication.

Table Specific Information

In HubSpot, contacts store information about an individual. From marketing automation to smart content, the lead-specific data found in contact records helps users leverage much of HubSpot's functionality.

SELECT

When selecting contacts, they can be filtered by columns marked below as 'Filterable'. For those columns, the supported server-side operators are =, !=, <, <=, >, >=. Further filtering is available using AND and OR combinations. A maximum of 2 OR operators are supported server-side, with each of these operators supporting up to 2 AND operators inside of them. For example: 

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

In the below server-offloading examples, "{Column}" represents any column you'd like to filter and "{Value}" represents any value you want to filter it on: 

SELECT * FROM Contacts WHERE {Column} = {Value} AND {Column} < {Value} AND {Column} > {Value}
SELECT * FROM Contacts WHERE {Column} != {Value} AND {Column} >= {Value} AND {Column} <= {Value}
SELECT * FROM Contacts WHERE ({Column} = {Value} AND {Column} = {Value}) OR ({Column} != {Value} AND {Column} >= {Value})
SELECT * FROM Contacts WHERE ({Column} != {Value} AND {Column} >= {Value} AND {Column} <= {Value}) OR ({Column} != {Value} AND {Column} >= {Value} AND {Column} <= {Value}) OR ({Column} != {Value} AND {Column} >= {Value} AND {Column} <= {Value})

INSERT


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

UPDATE


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

DELETE


DELETE FROM Contacts WHERE ID = '25151'

Columns

Name Type ReadOnly References Filterable Description
Id [KEY] Long False True

Unique identifier of the object.

Archived Bool True False

Whether the object is archived or not.

CreatedAt Datetime True False

When the object was created.

UpdatedAt Datetime True False

When the object was last updated.

ItemURL String True False

Url that points directly to the HubSpot item.

Company size String False True

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

Date of birth String False True

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

Days To Close Decimal True True

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

Degree String False True

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

Field of study String False True

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

First Conversion Date Datetime True True

Date this contact first submitted a form.

First Conversion String True True

First form this contact submitted.

First Deal Created Date Datetime True True

Date first deal was created for contact. Set automatically.

Gender String False True

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

Graduation date String False True

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

Additional email addresses String True True

A set of additional email addresses for a contact.

Business units String False True

The business units this record is assigned to.

All vids for a contact String True True

A set of all vids_ canonical or otherwise_ for a contact.

First Touch Converting Campaign String True True

Campaign responsible for the first touch creation of this contact.

Last Touch Converting Campaign String True True

Campaign responsible for the last touch creation of this contact.

Avatar FileManager key String True True

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

Buying Role String False True

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

All form submissions for a contact String True True

A set of all form submissions for a contact.

Merged vids with timestamps of a contact String True True

Merged vids with timestamps of a contact.

Calculated Mobile Number in International Format String True True

Mobile number in international format.

Calculated Phone Number in International Format String True True

Phone number in international format.

Calculated Phone Number Area Code String True True

Area Code of the calculated phone number.

Calculated Phone Number Country Code String True True

Country code of the calculated phone number.

Calculated Phone Number Region String True True

ISO2 Country code for the derived phone number.

Clicked on a LinkedIn Ad String False True

Whether contact has clicked on a LinkedIn Ad.

Email Confirmed Bool True True

Email Confirmation status of user of Content Membership.

Registration Follow Up Email Enqueued At Datetime False True

The time when the first registration follow up email was enqueued.

Membership Notes String False True

Notes relating to the contact's content membership.

Registered At Datetime True True

Datetime at which this user was set up for Content Membership.

Domain to which registration email was sent String True True

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

Time registration email was sent Datetime True True

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

Status String False True

Status of the contact's content membership.

Conversations visitor email String True True

A Conversations visitor's email address.

Count of unengaged contacts Decimal True True

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

Count of engaged contacts Decimal True True

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

Created By Conversations Bool True True

Flag indicating this contact was created by the Conversations API.

Created by user ID Decimal True True

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

Object create date_time Datetime True True

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

Date entered 'Customer _Lifecycle Stage Pipeline_' Datetime True True

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

Date entered 'Evangelist _Lifecycle Stage Pipeline_' Datetime True True

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

Date entered 'Lead _Lifecycle Stage Pipeline_' Datetime True True

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

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

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

Date entered 'Opportunity _Lifecycle Stage Pipeline_' Datetime True True

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

Date entered 'Other _Lifecycle Stage Pipeline_' Datetime True True

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

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

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

Date entered 'Subscriber _Lifecycle Stage Pipeline_' Datetime True True

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

Date exited 'Customer _Lifecycle Stage Pipeline_' Datetime True True

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

Date exited 'Evangelist _Lifecycle Stage Pipeline_' Datetime True True

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

Date exited 'Lead _Lifecycle Stage Pipeline_' Datetime True True

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

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

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

Date exited 'Opportunity _Lifecycle Stage Pipeline_' Datetime True True

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

Date exited 'Other _Lifecycle Stage Pipeline_' Datetime True True

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

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

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

Date exited 'Subscriber _Lifecycle Stage Pipeline_' Datetime True True

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

Recent Document Revisit Date Datetime True True

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

Invalid email address Bool True True

The email address associated with this contact is invalid.

Email address quarantine reason String False True

The reason why the email address has been quarantined.

Email Domain String True True

A contact's email address domain.

Email hard bounce reason String True True

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

Email hard bounce reason2 String True True

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

Email Address Quarantined Bool True True

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

Email address automated quarantine reason String True True

The automated reason why the email address has been quarantined.

Email Address Recipient Fatigue Next Available Sending Time Datetime True True

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

Sends Since Last Engagement Decimal True True

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

Marketing email confirmation status String True True

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

Clicked Facebook ad Bool False True

Whether contact has clicked a Facebook ad.

Facebook click id String False True

Facebook ID String False True

A contact's Facebook id.

Last NPS survey comment String True True

Last NPS survey comment that this contact gave.

Last NPS survey rating String True True

Last NPS survey rating that this contact gave.

Last NPS survey date Datetime True True

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

Should be shown an NPS web survey Bool False True

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

ID of first engagement Decimal True True

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

First subscription create date Datetime True True

The create date of the first subscription by the contact.

Google ad click id String False True

googleplus ID String False True

A contact's googleplus id.

Contact has an active subscription Decimal True True

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

IP Timezone String True True

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

Is a contact Bool True True

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

Contact unworked Bool True True

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

last sales activity date old Datetime True True

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

Last Engagement Date Datetime True True

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

Last Engagement Type String True True

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

Object last modified date_time Datetime True True

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

Last sequence ended date Datetime True True

The last sequence ended date.

Last sequence enrolled Decimal True True

The last sequence enrolled.

Last sequence enrolled date Datetime True True

The last sequence enrolled date.

Last sequence finished date Datetime True True

The last sequence finished date.

Last sequence unenrolled date Datetime True True

The last sequence unenrolled date.

Latest Source Date Date False True

The time of the latest session for a contact.

Latest subscription create date Datetime True True

The create date of the latest subscription by the contact.

Lead Status String False True

The contact's sales_ prospecting or outreach status.

Legal basis for processing contact's data String False True

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

Clicked LinkedIn Ad String False True

Linkedin ID String False True

A contact's linkedin id.

Marketing contact status source name String True True

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

Marketing contact status source type String True True

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

Marketing contact status String True True

The marketing status of a contact.

Marketing contact until next update String True True

Specifies if this contact will be set as non_marketing on renewal.

Merged object IDs String True True

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

Record ID Decimal True True

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

Pinned engagement ID Decimal True True

Pipeline String False True

The pipeline with which this contact is currently associated.

Likelihood to close Decimal True True

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

Contact priority String True True

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

Read Only Object Bool True True

Is the object read only.

Date of first engagement Datetime True True

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

Description of first engagement String True True

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

Type of first engagement String True True

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

Recent Sales Email Clicked Date Datetime True True

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

Recent Sales Email Opened Date Datetime True True

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

Calculated Mobile Number with country code String True True

Mobile number with country code.

Calculated Phone Number with country code String True True

Phone number with country code.

Calculated Mobile Number without country code String True True

Mobile number without country code.

Calculated Phone Number without country code String True True

Phone number without country code.

Number of sequences actively enrolled Decimal True True

The number of sequences actively enrolled.

Number of sequences enrolled Decimal True True

The number of sequences enrolled.

Currently in Sequence Bool True True

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

testpurge String True True

Testing purge.

testrollback String True True

Testing rollback.

Time between contact creation and deal close Decimal False True

Time between contact creation and deal creation Decimal False True

Time in 'Customer _Lifecycle Stage Pipeline_' Decimal True True

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

Time in 'Evangelist _Lifecycle Stage Pipeline_' Decimal True True

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

Time in 'Lead _Lifecycle Stage Pipeline_' Decimal True True

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

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

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

Time in 'Opportunity _Lifecycle Stage Pipeline_' Decimal True True

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

Time in 'Other _Lifecycle Stage Pipeline_' Decimal True True

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

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

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

Time in 'Subscriber _Lifecycle Stage Pipeline_' Decimal True True

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

Lead response time Decimal True True

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

Time to move from lead to customer Decimal False True

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

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

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

Time to move from opportunity to customer Decimal False True

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

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

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

Time to move from subscriber to customer Decimal False True

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

Time Zone String False True

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

Twitter ID String False True

A contact's Twitter id.

Unique creation key String True True

Unique property used for idempotent creates.

Updated by user ID Decimal True True

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

User IDs of all notification followers String True True

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

User IDs of all notification unfollowers String True True

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

User IDs of all owners String True True

The user IDs of all owners of this object.

WhatsApp Phone Number String False True

The phone number associated with the contact_s WhatsApp account.

Owner Assigned Date Datetime True True

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

IP City String True True

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

IP Country String True True

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

IP Country Code String True True

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

IP Latitude _ Longitude String True True

IP State_Region String True True

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

IP State Code_Region Code String True True

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

IP Zipcode String True True

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

Job function String False True

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

Last Modified Date Datetime True True

The date any property on this contact was modified.

Marital Status String False True

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

Military status String False True

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

Number of Associated Deals Decimal True True

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

Number of Form Submissions Decimal True True

The number of forms this contact has submitted.

Number of Unique Forms Submitted Decimal True True

The number of different forms this contact has submitted.

Recent Conversion Date Datetime True True

The date this contact last submitted a form.

Recent Conversion String True True

The last form this contact submitted.

Recent Deal Amount Decimal True True

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

Recent Deal Close Date Datetime True True

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

Relationship Status String False True

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

School String False True

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

Seniority String False True

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

Start date String False True

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

Total Revenue Decimal True True

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

Work email String False True

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

First Name String False True

A contact's first name.

First Page Seen String True True

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

Marketing emails delivered Decimal True True

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

Opted out of emailCustomer Service Communication String True True

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

Opted out of emailOne to One String True True

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

Twitter Username String False True

The contact's Twitter handle.

Currently in workflow String True True

True when contact is enrolled in a workflow.

Follower Count Decimal False True

The number of Twitter followers a contact has.

Last Page Seen String True True

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

Marketing emails opened Decimal True True

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

Last Name String False True

A contact's last name.

Number of Pageviews Decimal True True

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

Marketing emails clicked Decimal True True

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

Salutation String False True

The title used to address a contact.

Twitter Profile Photo String False True

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

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 24.0.9062