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.

FieldType
hubspot contact IDText
emailText
first nameText
last nameText
phoneText
companyText
job titleText
lifecycle stageText
lead statusText
owner IDText
sourceText
first URLText
email optoutTrue/false
page viewsInteger
visitsInteger
event completionsInteger
num dealsInteger
recent deal amountNumber
created atTimestamp
updated atTimestamp
archivedTrue/false
archived atTimestamp
custom fieldsText
loaded atTimestamp
account IDText
account nameText
hub IDText
hub domainText

Companies#

CRM companies — domain, industry, deal values.

FieldType
hubspot company IDText
nameText
domainText
industryText
num employeesInteger
annual revenueNumber
cityText
stateText
countryText
lifecycle stageText
owner IDText
num contactsInteger
num dealsInteger
total deal valueNumber
created atTimestamp
updated atTimestamp
archivedTrue/false
archived atTimestamp
custom fieldsText
loaded atTimestamp
account IDText
account nameText
hub IDText
hub domainText

Deals#

CRM deals — pipeline, stage, forecast, owner.

FieldType
hubspot deal IDText
deal nameText
deal stageText
pipelineText
amountNumber
deal currencyText
close dateText
owner IDText
stage probabilityNumber
forecast amountNumber
forecast probabilityNumber
is closed wonTrue/false
is closedTrue/false
sourceText
campaignText
num contactsInteger
days to closeInteger
time in stage msInteger
created atTimestamp
updated atTimestamp
archivedTrue/false
archived atTimestamp
custom fieldsText
loaded atTimestamp
account IDText
account nameText
hub IDText
hub domainText

Deal associations#

Deal-to-company/contact associations with HubSpot labels.

FieldType
hubspot deal IDText
target object typeText
target object IDText
association categoryText
association type IDInteger
association labelText
is primaryTrue/false
loaded atTimestamp
account IDText
account nameText
hub IDText
hub domainText

Owners#

CRM users/owners (sales reps).

FieldType
hubspot owner IDText
emailText
first nameText
last nameText
user IDText
created atTimestamp
updated atTimestamp
loaded atTimestamp
account IDText
account nameText
hub IDText
hub domainText

Pipelines#

Deal pipeline + stage definitions.

FieldType
pipeline stage keyText
pipeline IDText
pipeline labelText
pipeline display orderInteger
object typeText
stage IDText
stage labelText
stage display orderInteger
stage probabilityNumber
is closedTrue/false
is closed wonTrue/false
archivedTrue/false
created atTimestamp
updated atTimestamp
loaded atTimestamp
account IDText
account nameText
hub IDText
hub domainText

Marketing emails#

Marketing email campaigns — dimension only.

FieldType
hubspot email IDText
nameText
subjectText
from nameText
reply toText
email typeText
stateText
primary email campaign IDText
all email campaign IDsText
email campaign group IDText
archivedTrue/false
is publishedTrue/false
is abTrue/false
is transactionalTrue/false
active domainText
business unit IDText
folder IDText
subcategoryText
languageText
publish dateTimestamp
published atTimestamp
created atTimestamp
updated atTimestamp
loaded atTimestamp
account IDText
account nameText
hub IDText
hub domainText

Email events#

Per-recipient email events (send/open/click/bounce).

FieldType
event IDText
event typeText
recipientText
email campaign IDText
portal IDText
app IDText
sent by createdTimestamp
subjectText
URLText
user agentText
browserText
location cityText
location stateText
location countryText
drop reasonText
bounce typeText
portal sub statusText
status causeText
status sourceText
subscriptions jsonText
is filteredTrue/false
filtered reasonText
obfuscatedTrue/false
event atTimestamp
loaded atTimestamp
account IDText
account nameText
hub IDText
hub domainText

Property changes#

Baseline CRM deal-stage, pipeline, and contact-lifecycle property history changes.

FieldType
change keyText
object typeText
object IDText
property nameText
old valueText
new valueText
changed atTimestamp
source typeText
source IDText
account IDText
account nameText
hub IDText
hub domainText