HubSpot Predefined Reports
  • 6 Minutes to read
  • Dark
    Light
  • PDF

HubSpot Predefined Reports

  • Dark
    Light
  • PDF

Article Summary

Predefined Reports

The HubSpot datasource in Rivery comes with the below predefined reports. Each report will have a short description of the data, a list of customizable fields (if any), and the schema mapping. Due to the standardized nature of these reports, there are a number of locked fields that will only be accessible through the custom reporting functionality.

Source-Level Selections

HubSpot does not have any source-level selections available to filter each report in the river.

Deals

The Deals report represents a list of an ongoing transactions that a sales team is pursuing with a contact or company. The only customization for this report is the "Modified Deals" selection. If the checkbox is selected, the endpoint will only return records modified in the last 30 days, or the 10,000 most recently modified records. Otherwise, if unchecked (current setup), the endpoint will return all deals.

FieldData TypeDimension/Metric
dealid system schemaIntegerDimension
associationsRecordDimension
isdeletedBooleanDimension
portalidIntegerMetric
property_nameStringDimension
property_sourceStringDimension
property_sourceidStringDimension
property_timestampIntegerDimension
property_updatedbyuseridIntegerDimension
property_valueStringDimension
property_versionsRecordDimension

Companies

The Companies report pulls a list of information about the businesses or organizations within the HubSpot account. The only customization for this report is the "Modified Companies" selection. If the checkbox is selected, the endpoint will only return records modified in the last 30 days, or the 10,000 most recently modified records. Otherwise, if unchecked (current setup), the endpoint will return all companies.

FieldData TypeDimension/Metric
companyid system schemaIntegerDimension
additionaldomainsRecordDimension
isdeletedBooleanDimension
portalidIntegerMetric
property_nameStringDimension
property_sourceStringDimension
property_sourceidStringDimension
property_timestampIntegerDimension
property_updatedbyuseridIntegerDimension
property_valueStringDimension
property_versionsRecordDimension

Pipelines

The Pipelines report represents distinct stages in a workflow for deals and/or support tickets.

FieldData TypeDimension/Metric
pipelineid system schemaStringDimension
activeBooleanDimension
displayorderIntegerDimension
labelStringDimension
stages_activeBooleanDimension
stages_closedwonBooleanDimension
stages_displayorderIntegerDimension
stages_labelStringDimension
stages_probabilityFloatDimension
stages_stageidStringDimension
staticdefaultBooleanDimension

Engagements

The Engagements report lists data from CRM actions, including notes, tasks, emails, meetings, and calls.

FieldData TypeDimension/Metric
engagement_id system schemaIntegerDimension
associations_companyidsIntegerDimension
associations_dealidsIntegerDimension
associations_quoteidsIntegerDimension
associations_ticketidsIntegerDimension
attachmentsRecordDimension
engagement_activeBooleanDimension
engagement_activitytypeStringDimension
engagement_allaccessibleteamidsIntegerDimension
engagement_bodypreviewStringDimension
engagement_bodypreviewhtmlStringDimension
engagement_bodypreviewistruncatedBooleanDimension
engagement_createdatIntegerDimension
engagement_createdbyIntegerDimension
engagement_gdprdeletedBooleanDimension
associations_contactidsIntegerDimension
engagement_lastupdatedIntegerDimension
engagement_modifiedbyIntegerDimension
engagement_owneridIntegerDimension
engagement_portalidIntegerDimension
engagement_queuemembershipidsIntegerDimension
engagement_sourceStringDimension
engagement_sourceidStringDimension
engagement_teamidIntegerDimension
engagement_timestampIntegerDimension
engagement_typeStringDimension
engagement_uidStringDimension
metadata_attachedvideoopenedBooleanDimension
metadata_attachedvideowatchedBooleanDimension
metadata_bodyStringDimension
metadata_calleeobjectidIntegerDimension
metadata_calleeobjecttypeStringDimension
metadata_ccRecordDimension
metadata_completiondateIntegerDimension
metadata_createdfromlinkidIntegerDimension
metadata_dispositionStringDimension
metadata_durationmillisecondsIntegerDimension
metadata_endtimeIntegerDimension
metadata_externalaccountidStringDimension
metadata_externalidStringDimension
metadata_externalurlStringDimension
metadata_facsimilesendidStringDimension
metadata_forobjecttypeStringDimension
metadata_from_emailStringDimension
metadata_from_firstnameStringDimension
metadata_from_lastnameStringDimension
metadata_from_rawStringDimension
metadata_fromnumberStringDimension
metadata_hastranscriptBooleanDimension
metadata_htmlStringDimension
metadata_isalldayBooleanDimension
metadata_locationStringDimension
metadata_loggedfromStringDimension
metadata_mediaprocessingstatusStringDimension
metadata_meetingoutcomeStringDimension
metadata_messageidStringDimension
metadata_postsendstatusStringDimension
metadata_premeetingprospectremindersIntegerDimension
metadata_priorityStringDimension
metadata_recordingurlStringDimension
metadata_remindersIntegerDimension
metadata_senddefaultreminderBooleanDimension
metadata_sender_emailStringDimension
metadata_sentviaStringDimension
metadata_sequencestepenrollmentidStringDimension
metadata_sequencesteporderIntegerDimension
metadata_sourceStringDimension
metadata_sourceidStringDimension
metadata_starttimeIntegerDimension
metadata_statusStringDimension
metadata_subjectStringDimension
metadata_tasktypeStringDimension
metadata_textStringDimension
metadata_titleStringDimension
metadata_toRecordDimension
metadata_tonumberStringDimension
metadata_trackerkeyStringDimension
metadata_transcriptionidIntegerDimension
scheduledtasksRecordDimension

Forms

The Forms report is used to retrieve the details of the forms previously set up in the HubSpot account.

FieldData TypeDimension/Metric
guid system schemaStringDimension
actionStringDimension
businessunitidIntegerDimension
campaignguidStringDimension
captchaenabledBooleanDimension
cloneableBooleanDimension
createdatIntegerDimension
createmarketablecontactBooleanDimension
cssclassStringDimension
customuidStringDimension
deletableBooleanDimension
deletedatIntegerDimension
editableBooleanDimension
editversionIntegerDimension
followupidStringDimension
formfieldgroupsRecordDimension
formtypeStringDimension
alwayscreatenewcompanyBooleanDimension
ignorecurrentvaluesBooleanDimension
inlinemessageStringDimension
internalupdatedatIntegerDimension
ispublishedBooleanDimension
kickbackemailsjsonStringDimension
kickbackemailworkflowidIntegerDimension
leadnurturingcampaignidStringDimension
metadataRecordDimension
methodStringDimension
migratedfromStringDimension
multivariatetestRecordDimension
nameStringDimension
notifyrecipientsStringDimension
parentidIntegerDimension
performablehtmlStringDimension
portablekeyStringDimension
portalidIntegerDimension
publishatIntegerDimension
publishedatIntegerDimension
redirectStringDimension
styleStringDimension
submittextStringDimension
thankyoumessagejsonStringDimension
themecolorStringDimension
themenameStringDimension
tmsidStringDimension
unpublishatIntegerDimension
updatedatIntegerDimension

Workflows

The Workflows report returns all the information on previosuly created marketing automation campaigns that rely on triggering relevant and timely actions (like emails) for contacts.

FieldData TypeDimension/Metric
id system schemaIntegerDimension
contactcountsRecordDimension
creationsourceRecordDimension
descriptionStringDimension
enabledBooleanDimension
contactlistidsRecordDimension
insertedatIntegerDimension
lastupdatedbyuseridIntegerDimension
migrationstatusRecordDimension
nameStringDimension
originalauthoruseridIntegerDimension
portalidIntegerDimension
typeStringDimension
updatedatIntegerDimension
updatesourceRecordDimension

Owners

The Owners report lists users in the organization that are assigned to CRM object records (contacts, companies, deals, tickets, and engagements). The only customization for this report is to include or remove inactive owners in the report.

FieldData TypeDimension/Metric
ownerid system schemaIntegerDimension
activesalesforceidStringDimension
createdatIntegerDimension
emailStringDimension
firstnameStringDimension
hascontactsaccessBooleanDimension
isactiveBooleanDimension
lastnameStringDimension
activeuseridIntegerDimension
portalidIntegerDimension
remotelistRecordDimension
signatureStringDimension
typeStringDimension
updatedatIntegerDimension
useridincludinginactiveIntegerDimension

Contacts Created

Return all contacts that have been created in the account for a given account.
You will receive a paginated list of contacts, with a maximum of 100 contacts per page.

FieldData TypeDimension/Metric
property_name system schemaStringDimension
vid system schemaIntegerDimension
canonical_vidIntegerMetric
identity_profilesRecordDimension
is_contactBooleanDimension
portal_idIntegerDimension
addedatIntegerMetric
property_valueStringDimension
form_submissionsRecordDimension

Contacts Updated

Return all contacts that have been updated in the account for a given account.
You will receive a paginated list of contacts, with a maximum of 100 contacts per page.

FieldData TypeDimension/Metric
property_name system schemaStringDimension
vid system schemaIntegerDimension
canonical_vidIntegerMetric
identity_profilesRecordDimension
is_contactBooleanDimension
portal_idIntegerDimension
addedatIntegerMetric
property_valueStringDimension
form_submissionsRecordDimension

Marketing Emails

Get all marketing emails for a HubSpot account.
The results can be filtered, allowing you to find a specific set of emails you're searching for. See the table below for a full list of filtering options.

FieldData TypeDimension/Metric
id system schemaIntegerDimension
abBooleanDimension
absamplesizedefaultStringDimension
absamplingdefaultStringDimension
absoluteurlStringDimension
abstatusStringDimension
absuccessmetricStringDimension
abtestidIntegerMetric
abtestpercentageIntegerMetric
abvariationBooleanDimension
allemailcampaignidsIntegerMetric
analyticspageidStringDimension
analyticspagetypeStringDimension
archivedBooleanDimension
authorStringDimension
authornameStringDimension
blogrsssettingsStringDimension
campaignStringDimension
campaignnameStringDimension
campaignutmStringDimension
canspamsettingsidIntegerMetric
categoryidIntegerMetric
clonedfromIntegerMetric
contenttypecategoryIntegerMetric
createdIntegerMetric
createdbyidIntegerMetric
createpageBooleanDimension
currentlypublishedBooleanDimension
currentstateStringDimension
customreplytoStringDimension
customreplytoenabledBooleanDimension
domainStringDimension
emailbodyStringDimension
emailbodyplaintextStringDimension
emailcampaigngroupidIntegerMetric
emailnoteStringDimension
emailtemplatemodeStringDimension
emailtypeStringDimension
feedbacksurveyidStringDimension
folderidIntegerMetric
freezedateIntegerMetric
fromnameStringDimension
hascontentaccessrulesBooleanDimension
htmltitleStringDimension
abhourstowaitIntegerMetric
isgraymailsuppressionenabledBooleanDimension
ispublishedBooleanDimension
isrecipientfatiguesuppressionenabledBooleanDimension
languageStringDimension
lasteditsessionidIntegerMetric
lasteditupdateidIntegerMetric
layoutsectionsRecordDimension
livedomainStringDimension
mailinglistsexcludedIntegerMetric
mailinglistsincludedIntegerMetric
maxrssentriesIntegerMetric
metadescriptionStringDimension
nameStringDimension
pageexpiryenabledBooleanDimension
pageredirectedBooleanDimension
portalidIntegerMetric
previewkeyStringDimension
primaryemailcampaignidIntegerMetric
primaryrichtextmodulehtmlStringDimension
processingstatusStringDimension
publishdateIntegerMetric
publishedatIntegerMetric
publishedbyemailStringDimension
publishedbyidIntegerMetric
publishedbynameStringDimension
publishedurlStringDimension
publishimmediatelyBooleanDimension
replytoStringDimension
resolveddomainStringDimension
rssemailbytextStringDimension
rssemailclickthroughtextStringDimension
rssemailcommenttextStringDimension
rssemailentrytemplateenabledBooleanDimension
rssemailimagemaxwidthIntegerMetric
rssemailurlStringDimension
scrubssubscriptionlinksBooleanDimension
sectionsRecordDimension
securitystateStringDimension
slugStringDimension
stateStringDimension
subcategoryStringDimension
subjectStringDimension
subscriptionIntegerMetric
subscriptionnameStringDimension
templatepathStringDimension
transactionalBooleanDimension
unpublishedatIntegerMetric
updatedIntegerMetric
updatedbyidIntegerMetric
urlStringDimension
userssheadlineassubjectBooleanDimension
vidsincludedIntegerMetric
visibletoallBooleanDimension

Was this article helpful?