Hubspot

The table below gives information about all the data fields that you can import from Hubspot.

 

Field API name

Data Type

Description

Use in Adriel

address

string

A contact's street address, including apartment or unit #

dimension

amount

currency

The total value of the deal

metric

amount_in_home_currency

currency

The amount of the deal, using the exchange rate, in your company's currency

metric

annualrevenue

currency

Annual company revenue

metric

associatedcompanyid

string

A company's ID

dimension

associatedcompanylastupdated

string

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

dimension

call.body

string

The details or notes of the call

dimension

call.durationMilliseconds

long

The length of the call in milliseconds

metric

call.recordingUrl

string

The URL of the recording file

dimension

call.status

string

Will be COMPLETED once the call is finished

dimension

call.toNumber

string

The phone number that was called

dimension

city

string

A contact's city of residence

dimension

closed_lost_reason

string

Reason why the deal was lost.

dimension

closed_won_reason

string

Reason why the deal was won.

dimension

closedate

date

The date that a contact became a customer. This property is set automatically by HubSpot when a deal or opportunity is marked as closed-won. It can also be set manually or programmatically.

dimension

closedate

string

The expected close date of the deal

dimension

company

string

A company's name

dimension

company_size

long

Company size

metric

country

string

The contact's country of residence. This might be set via import, form, or integration.

dimension

createdate

date

The date that a contact entered the system

dimension

createdate

string

The date the deal was created

dimension

currentlyinworkflow

string

If the contact is currently enrolled in any workflow

dimension

date_of_birth

date

Date of Birth

dimension

days_to_close

long

The days that elapsed from when a contact was created until they closed as a customer. This is set automatically by HubSpot and can be used for segmentation and reporting.

metric

dealname

string

Name of the deal

dimension

dealstage

string

The stage of the deal

dimension

dealtype

string

Type of the deal

dimension

degree

string

Degree

dimension

description

string

Description of the deal

dimension

email

string

A contact's email address

dimension

email.from.email

string

The email address of the sender

dimension

email.to.email

string

The email address of the recipient

dimension

engagements_last_meeting_booked

string

The date of the most recent meeting booked from the Meetings app.

dimension

engagements_last_meeting_booked_campaign

string

The campaign of the last meeting booked through the Meetings App (ex: the specific email that was sent)

dimension

engagements_last_meeting_booked_medium

string

The medium of the last meeting booked through the Meetings App (ex: email or website or in-app)

dimension

engagements_last_meeting_booked_source

string

The source of the last meeting booked through the Meetings App (ex: pql-email, landing-page)

dimension

fax

string

A contact's primary fax number

dimension

field_of_study

string

Field of study

dimension

first_conversion_date

string

The date this contact first submitted a form

dimension

first_conversion_event_name

string

The first form this contact submitted

dimension

first_deal_created_date

string

The date the first deal for a contact was created. This is automatically set by HubSpot and can be used for segmentation and reporting.

dimension

firstname

string

A contact's first name

dimension

followercount

long

The number of Twitter followers a contact has

metric

gender

string

Gender

dimension

graduation_date

date

Graduation date

dimension

hs_additional_emails

string

A set of additional email addresses for a contact

dimension

hs_all_accessible_team_ids

string

The team ids, including up the team hierarchy, corresponding to all owner referencing properties for this object, both default and custom

dimension

hs_all_accessible_team_ids

string

The team ids, including up the team hierarchy, corresponding to all owner referencing properties for this object, both default and custom

dimension

hs_all_contact_vids

string

A set of all vids, canonical or otherwise, for a contact

dimension

hs_all_owner_ids

string

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

dimension

hs_all_owner_ids

string

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

dimension

hs_all_team_ids

string

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

dimension

hs_all_team_ids

string

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

dimension

hs_analytics_average_page_views

float

The average number of pages a contact sees. This is automatically set by HubSpot for each contact.

metric

hs_analytics_first_referrer

string

The first website that referred a contact to your website. This is automatically set by HubSpot for each contact.

dimension

hs_analytics_first_timestamp

string

The first time a contact has been seen. This is automatically set by HubSpot for each contact.

dimension

hs_analytics_first_touch_converting_campaign

string

The campaign responsible for the first touch creation of this contact

dimension

hs_analytics_first_url

string

The first page a contact saw on your website. This is automatically set by HubSpot for each contact.

dimension

hs_analytics_first_visit_timestamp

string

The first time a contact visited your website. This is automatically set by HubSpot for each contact.

dimension

hs_analytics_last_referrer

string

The last website that referred a contact to your website. This is automatically set by HubSpot for each contact.

dimension

hs_analytics_last_timestamp

string

The last time and date a contact has viewed a page on your website.

dimension

hs_analytics_last_touch_converting_campaign

string

The campaign responsible for the last touch creation of this contact

dimension

hs_analytics_last_url

string

The last page a contact saw on your website. This is automatically set by HubSpot for each contact.

dimension

hs_analytics_last_visit_timestamp

string

The last time and date a contact visited your website.

dimension

hs_analytics_num_event_completions

long

The sum of all events a contact has experienced. This is automatically set by HubSpot for each contact.

metric

hs_analytics_num_page_views

long

The sum of all pages a contact has seen on your website. This is automatically set by HubSpot for each contact.

metric

hs_analytics_num_visits

long

The sum of all visits a contact has made to your website. This is automatically set by HubSpot for each contact.

metric

hs_analytics_revenue

currency

Event revenue can be set on a contact though HubSpot's enterprise Events. http://help.hubspot.com/articles/KCS_Article/Reports/How-do-I-create-Events-in-HubSpot

metric

hs_analytics_source

string

The first known source through which a contact found your website. Source is automatically set by HubSpot, but may be updated manually.

dimension

hs_analytics_source

string

Original source for the contact with the earliest activity for this deal.

dimension

hs_analytics_source_data_1

string

Additional information about the source through which a contact first found your website. This property is automatically set by HubSpot.

dimension

hs_analytics_source_data_1

string

Additional information about the original source for the contact with the earliest activity for this deal.

dimension

hs_analytics_source_data_2

string

Additional information about the source through which a contact first found your website. This property is automatically set by HubSpot.

dimension

hs_analytics_source_data_2

string

Additional information about the original source for the contact with the earliest activity for this deal.

dimension

hs_avatar_filemanager_key

string

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

dimension

hs_calculated_form_submissions

string

A set of all form submissions for a contact

dimension

hs_calculated_mobile_number

string

Mobile number in international format

dimension

hs_calculated_phone_number

string

Phone number in international format

dimension

hs_calculated_phone_number_area_code

string

Area Code of the calculated phone number

dimension

hs_calculated_phone_number_country_code

string

Country code of the calculated phone number

dimension

hs_calculated_phone_number_region_code

string

ISO2 Country code for the derived phone number

dimension

hs_campaign

string

The marketing campaign the deal is associated with

dimension

hs_content_membership_email_confirmed

string

Email Confirmation status of user of Content Membership

dimension

hs_content_membership_notes

string

Membership Notes

dimension

hs_content_membership_registered_at

string

Datetime at which this user was set up for Content Membership

dimension

hs_content_membership_registration_domain_sent_to

string

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

dimension

hs_content_membership_registration_email_sent_at

string

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

dimension

hs_content_membership_status

string

Membership Status

dimension

hs_created_by_conversations

string

Flag indicating this contact was created by the Conversations API

dimension

hs_createdate

string

The date the deal was created in HubSpot

dimension

hs_deal_amount_calculation_preference

string

Calculation preference of deal amount

dimension

hs_document_last_revisited

string

The last time a shared document (presentation) was accessed by this contact

dimension

hs_email_bounce

long

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

metric

hs_email_click

long

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

metric

hs_email_delivered

long

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

metric

hs_email_domain

string

A contact's email address domain

dimension

hs_email_first_click_date

string

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

dimension

hs_email_first_open_date

string

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

dimension

hs_email_first_send_date

string

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

dimension

hs_email_is_ineligible

string

Indicates the contact is globally ineligible for email.

dimension

hs_email_last_click_date

string

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

dimension

hs_email_last_email_name

string

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

dimension

hs_email_last_open_date

string

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

dimension

hs_email_last_send_date

string

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

dimension

hs_email_open

long

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

metric

hs_email_optout

string

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

dimension

hs_email_quarantined

string

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.

dimension

hs_email_sends_since_last_engagement

long

This property tracks how many marketing emails have been sent to a contact since they last engaged with one.

metric

hs_emailconfirmationstatus

string

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

dimension

hs_facebook_ad_clicked

string

Whether contact has clicked a Facebook ad

dimension

hs_facebookid

string

A contact's facebook id

dimension

hs_google_click_id

string

Google Click ID

dimension

hs_googleplusid

string

A contact's googleplus id

dimension

hs_ip_timezone

string

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

dimension

hs_language

string

Set your contact's preferred language for communications. This property can be changed from an import, form, or integration.

dimension

hs_lastmodifieddate

string

The date any property on this deal was modified

dimension

hs_lead_status

string

The contact's sales, prospecting or outreach status

dimension

hs_legal_basis

string

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

dimension

hs_lifecyclestage_customer_date

string

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

dimension

hs_lifecyclestage_evangelist_date

string

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

dimension

hs_lifecyclestage_lead_date

string

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

dimension

hs_lifecyclestage_marketingqualifiedlead_date

string

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

dimension

hs_lifecyclestage_opportunity_date

string

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

dimension

hs_lifecyclestage_other_date

string

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

dimension

hs_lifecyclestage_salesqualifiedlead_date

string

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

dimension

hs_lifecyclestage_subscriber_date

string

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

dimension

hs_linkedinid

string

A contact's linkedin id

dimension

hs_object_id

string

The unique id for this deal

dimension

hs_persona

string

A contact's persona

dimension

hs_sales_email_last_clicked

string

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

dimension

hs_sales_email_last_opened

string

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

dimension

hs_sales_email_last_replied

string

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.

dimension

hs_sales_email_last_replied

string

The last time a tracked sales email was replied to for this deal

dimension

hs_searchable_calculated_international_mobile_number

string

Mobile number with country code

dimension

hs_searchable_calculated_international_phone_number

string

Phone number with country code

dimension

hs_searchable_calculated_mobile_number

string

Mobile number without country code

dimension

hs_searchable_calculated_phone_number

string

Phone number without country code

dimension

hs_sequences_is_enrolled

string

A yes/no field that indicates whether the contact is currently in a Sequence.

dimension

hs_social_facebook_clicks

long

The number clicks on links shared on Facebook

metric

hs_social_google_plus_clicks

long

The number clicks on links shared on Google Plus

metric

hs_social_last_engagement

string

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

dimension

hs_social_linkedin_clicks

long

The number clicks on links shared on LinkedIn

metric

hs_social_num_broadcast_clicks

long

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

metric

hs_social_twitter_clicks

long

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.

metric

hs_twitterid

string

A contact's twitter id

dimension

hubspot_owner_assigneddate

string

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.

dimension

hubspot_owner_assigneddate

string

The timestamp when an owner was assigned to this deal

dimension

hubspot_owner_id

string

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

dimension

hubspot_owner_id

string

The owner of the deal

dimension

hubspot_team_id

string

The team of the owner of a contact.

dimension

hubspot_team_id

string

The team assigned to the deal owner for the deal.

dimension

hubspotscore

long

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

metric

industry

string

A company's industry

dimension

ip_city

string

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

dimension

ip_country

string

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

dimension

ip_country_code

string

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

dimension

ip_latlon

string

IP latitude and longitude

dimension

ip_state

string

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.

dimension

ip_state_code

string

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.

dimension

ip_zipcode

string

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

dimension

ipaddress

string

A contact's IP Address

dimension

job_function

string

Job function

dimension

jobtitle

string

A contact's job title

dimension

kloutscoregeneral

float

A contact's Klout score, a measure of Internet influence

metric

last_lead_source

string

Last Lead source

dimension

lastmodifieddate

string

The date any property on this contact was modified

dimension

lastname

string

A contact's last name

dimension

lead_source

string

Lead source

dimension

lifecyclestage

string

The qualification of contacts to sales readiness. It can be set through imports, forms, workflows, and manually on a per contact basis.

dimension

linkedinbio

string

A contact's LinkedIn bio

dimension

linkedinconnections

long

How many LinkedIn connections they have

metric

marital_status

string

Marital status

dimension

meeting.endTime

string

A Unix timestamp in milliseconds representing the end time of the meeting

dimension

meeting.startTime

string

A Unix timestamp in milliseconds representing the start time of the meeting

dimension

meeting.title

string

The title or subject of the meeting

dimension

message

string

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

dimension

military_status

string

Military status

dimension

mobilephone

string

A contact's mobile phone number

dimension

note.body

string

The body of the note

dimension

notes_last_contacted

string

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.

dimension

notes_last_contacted

string

The last timestamp when a call, email or meeting was logged for this deal, an associated company or contact

dimension

notes_last_updated

string

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.

dimension

notes_last_updated

string

The last timestamp when a note was updated for this deal, or an associated contact or company

dimension

notes_next_activity_date

string

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

dimension

notes_next_activity_date

string

The date of the next upcoming activity for a deal.

dimension

num_associated_contacts

long

Number of contacts associated with this deal

metric

num_associated_deals

long

The number of deals associated with this contact. This is set automatically by HubSpot.

metric

num_contacted_notes

long

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.

metric

num_contacted_notes

long

The number of times a call, email or meeting was logged for this deal

metric

num_conversion_events

long

The number of forms this contact has submitted

metric

num_notes

long

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

metric

num_notes

long

Number of sales activities for this deal

metric

num_unique_conversion_events

long

The number of different forms this contact has submitted

metric

numemployees

long

The number of company employees

metric

phone

string

A contact's primary phone number

dimension

photo

string

Social Media photo

dimension

pipeline

string

The pipeline a deal is in, which determines the deal stages the deal will move through.

dimension

recent_conversion_date

string

The date this contact last submitted a form

dimension

recent_conversion_event_name

string

The last form this contact submitted

dimension

recent_deal_amount

currency

The amount of the last closed won deal associated with a contact. This is set automatically by HubSpot based on information from the Deals object.

metric

recent_deal_close_date

string

Recent deal close date

dimension

relationship_status

string

Relationship status

dimension

salutation

string

The title used to address a contact

dimension

school

string

School

dimension

seniority

string

Seniority

dimension

start_date

string

Start date

dimension

state

string

State

dimension

surveymonkeyeventlastupdated

string

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

dimension

task.status

string

The status of the task

dimension

task.subject

string

The subject or title of the task

dimension

total_revenue

currency

The sum from all closed won deal revenue associated with a contact. This is automatically set by HubSpot and can be used for segmentation and reporting.

metric

twitterbio

string

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

dimension

twitterhandle

string

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

dimension

twitterprofilephoto

string

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

dimension

webinareventlastupdated

string

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

dimension

website

string

A company's website

dimension

work_email

string

Work email

dimension

zip

string

The contact's zip code. This might be set via import, form, or integration.

dimension

If you require help with this topic, please contact Adriel Support using the chat box.