HubSpot | Contact Standard Dataset

Below are the measures and dimensions Alight Analytics considers standard for HubSpot - Contact dataset. There is a one day lag on HubSpot and lifetime contact data is pulled daily.

Field Name Type Description
Added At DateTime The time the contact became a contact in the HubSpot database.
Form Submission Page URL Dimension How HubSpot acquired the contact's email address.
Form Submission Page Title Dimension The Name or Title of the page the form is submitted on.
Portal ID Whole Number The HubSpot Portal the form belongs to.
Profile URL Dimension URL for the contact in HubSpot.
VID Whole Number Contact's unique visitor ID.
Company Dimension Company of contact, if provided.
Last Modified Date DateTime Last date the contact information was modified
Lead GUID Whole Number Globally Universal ID.
Became A Subscriber Date

DateTime

The date when a contact's lifecycle stage changed to Subscriber. This is automatically set by HubSpot for each contact.
Became A Lead Date DateTime The date when a contact's lifecycle stage changed to Lead. This is automatically set by HubSpot for each contact.
Became An MQL Date DateTime The date when a contact's lifecycle stage changed to Marketing Qualified Lead (MQL). This is automatically set by HubSpot for each contact.
Became An SQL Date DateTime The date when a contact's lifecycle stage changed to Sales Qualified Lead (SQL). This is automatically set by HubSpot for each contact.
Became An Opportunity Date DateTime The date when a contact's lifecycle stage changed to Opportunity. This is automatically set by HubSpot for each contact.
Became A Customer Date DateTime The date when a contact's lifecycle stage changed to Customer. This is automatically set by HubSpot for each contact.
Became Other Lifecycle Stage Date DateTime The date when a contact's lifecycle stage changed to Other. This is automatically set by HubSpot for each contact.
Lifecycle Stage Dimension The qualification of contacts to sales readiness. It can be set through imports, forms, workflows, and manually on a per contact basis via Hubspot.
State Dimension The state/region that the contact record is associated with.
Country Dimension The country that the contact record is associated with.
Lead Status Dimension The status that is associated with the contact record.
Insert Date DateTime Internal use: when the row was inserted in the table
ChannelMix Profile Dimension When needed, distinguishes between HubSpot accounts - Contents defined by Alight

 

If contact properties that are not included in this standard dataset are required, then check out our HubSpot | How to Connect article. 

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.