Integrations
HubSpot datasets and fields
The 9 datasets Maven lands from HubSpot, every field in them, and how the connection syncs.
Maven lands 9 datasets from HubSpot in each client workspace. This page lists every one with all of its fields. For the metrics, reports and setup steps, see the HubSpot integration page.
Connection and sync#
You connect HubSpot by signing in to it and approving access, so nobody shares a password.
Each HubSpot sync takes a fresh copy of the current records, so the workspace always reflects what is in HubSpot now.
Datasets#
Contacts#
CRM contacts — email, lifecycle, analytics, deal associations.
| Field | Type |
|---|---|
| hubspot contact ID | Text |
| Text | |
| first name | Text |
| last name | Text |
| phone | Text |
| company | Text |
| job title | Text |
| lifecycle stage | Text |
| lead status | Text |
| owner ID | Text |
| source | Text |
| first URL | Text |
| email optout | True/false |
| page views | Integer |
| visits | Integer |
| event completions | Integer |
| num deals | Integer |
| recent deal amount | Number |
| created at | Timestamp |
| updated at | Timestamp |
| archived | True/false |
| archived at | Timestamp |
| custom fields | Text |
| loaded at | Timestamp |
| account ID | Text |
| account name | Text |
| hub ID | Text |
| hub domain | Text |
Companies#
CRM companies — domain, industry, deal values.
| Field | Type |
|---|---|
| hubspot company ID | Text |
| name | Text |
| domain | Text |
| industry | Text |
| num employees | Integer |
| annual revenue | Number |
| city | Text |
| state | Text |
| country | Text |
| lifecycle stage | Text |
| owner ID | Text |
| num contacts | Integer |
| num deals | Integer |
| total deal value | Number |
| created at | Timestamp |
| updated at | Timestamp |
| archived | True/false |
| archived at | Timestamp |
| custom fields | Text |
| loaded at | Timestamp |
| account ID | Text |
| account name | Text |
| hub ID | Text |
| hub domain | Text |
Deals#
CRM deals — pipeline, stage, forecast, owner.
| Field | Type |
|---|---|
| hubspot deal ID | Text |
| deal name | Text |
| deal stage | Text |
| pipeline | Text |
| amount | Number |
| deal currency | Text |
| close date | Text |
| owner ID | Text |
| stage probability | Number |
| forecast amount | Number |
| forecast probability | Number |
| is closed won | True/false |
| is closed | True/false |
| source | Text |
| campaign | Text |
| num contacts | Integer |
| days to close | Integer |
| time in stage ms | Integer |
| created at | Timestamp |
| updated at | Timestamp |
| archived | True/false |
| archived at | Timestamp |
| custom fields | Text |
| loaded at | Timestamp |
| account ID | Text |
| account name | Text |
| hub ID | Text |
| hub domain | Text |
Deal associations#
Deal-to-company/contact associations with HubSpot labels.
| Field | Type |
|---|---|
| hubspot deal ID | Text |
| target object type | Text |
| target object ID | Text |
| association category | Text |
| association type ID | Integer |
| association label | Text |
| is primary | True/false |
| loaded at | Timestamp |
| account ID | Text |
| account name | Text |
| hub ID | Text |
| hub domain | Text |
Owners#
CRM users/owners (sales reps).
| Field | Type |
|---|---|
| hubspot owner ID | Text |
| Text | |
| first name | Text |
| last name | Text |
| user ID | Text |
| created at | Timestamp |
| updated at | Timestamp |
| loaded at | Timestamp |
| account ID | Text |
| account name | Text |
| hub ID | Text |
| hub domain | Text |
Pipelines#
Deal pipeline + stage definitions.
| Field | Type |
|---|---|
| pipeline stage key | Text |
| pipeline ID | Text |
| pipeline label | Text |
| pipeline display order | Integer |
| object type | Text |
| stage ID | Text |
| stage label | Text |
| stage display order | Integer |
| stage probability | Number |
| is closed | True/false |
| is closed won | True/false |
| archived | True/false |
| created at | Timestamp |
| updated at | Timestamp |
| loaded at | Timestamp |
| account ID | Text |
| account name | Text |
| hub ID | Text |
| hub domain | Text |
Marketing emails#
Marketing email campaigns — dimension only.
| Field | Type |
|---|---|
| hubspot email ID | Text |
| name | Text |
| subject | Text |
| from name | Text |
| reply to | Text |
| email type | Text |
| state | Text |
| primary email campaign ID | Text |
| all email campaign IDs | Text |
| email campaign group ID | Text |
| archived | True/false |
| is published | True/false |
| is ab | True/false |
| is transactional | True/false |
| active domain | Text |
| business unit ID | Text |
| folder ID | Text |
| subcategory | Text |
| language | Text |
| publish date | Timestamp |
| published at | Timestamp |
| created at | Timestamp |
| updated at | Timestamp |
| loaded at | Timestamp |
| account ID | Text |
| account name | Text |
| hub ID | Text |
| hub domain | Text |
Email events#
Per-recipient email events (send/open/click/bounce).
| Field | Type |
|---|---|
| event ID | Text |
| event type | Text |
| recipient | Text |
| email campaign ID | Text |
| portal ID | Text |
| app ID | Text |
| sent by created | Timestamp |
| subject | Text |
| URL | Text |
| user agent | Text |
| browser | Text |
| location city | Text |
| location state | Text |
| location country | Text |
| drop reason | Text |
| bounce type | Text |
| portal sub status | Text |
| status cause | Text |
| status source | Text |
| subscriptions json | Text |
| is filtered | True/false |
| filtered reason | Text |
| obfuscated | True/false |
| event at | Timestamp |
| loaded at | Timestamp |
| account ID | Text |
| account name | Text |
| hub ID | Text |
| hub domain | Text |
Property changes#
Baseline CRM deal-stage, pipeline, and contact-lifecycle property history changes.
| Field | Type |
|---|---|
| change key | Text |
| object type | Text |
| object ID | Text |
| property name | Text |
| old value | Text |
| new value | Text |
| changed at | Timestamp |
| source type | Text |
| source ID | Text |
| account ID | Text |
| account name | Text |
| hub ID | Text |
| hub domain | Text |