# HubSpot datasets and fields

> The 9 datasets Maven lands from HubSpot, every field in them, and how the connection syncs.

Source: https://mavendata.ai/docs/integrations/hubspot

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](https://mavendata.ai/integrations/hubspot).

## 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 |
| email | 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 |
| email | 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 |
