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

HubSpot Predefined Reports

  • Dark
    Light
  • PDF

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.

Field Data Type Dimension/Metric
dealid system schema Integer Dimension
associations Record Dimension
isdeleted Boolean Dimension
portalid Integer Metric
property_name String Dimension
property_source String Dimension
property_sourceid String Dimension
property_timestamp Integer Dimension
property_updatedbyuserid Integer Dimension
property_value String Dimension
property_versions Record Dimension

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.

Field Data Type Dimension/Metric
companyid system schema Integer Dimension
additionaldomains Record Dimension
isdeleted Boolean Dimension
portalid Integer Metric
property_name String Dimension
property_source String Dimension
property_sourceid String Dimension
property_timestamp Integer Dimension
property_updatedbyuserid Integer Dimension
property_value String Dimension
property_versions Record Dimension

Pipelines

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

Field Data Type Dimension/Metric
pipelineid system schema String Dimension
active Boolean Dimension
displayorder Integer Dimension
label String Dimension
stages_active Boolean Dimension
stages_closedwon Boolean Dimension
stages_displayorder Integer Dimension
stages_label String Dimension
stages_probability Float Dimension
stages_stageid String Dimension
staticdefault Boolean Dimension

Engagements

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

Field Data Type Dimension/Metric
engagement_id system schema Integer Dimension
associations_companyids Integer Dimension
associations_dealids Integer Dimension
associations_quoteids Integer Dimension
associations_ticketids Integer Dimension
attachments Record Dimension
engagement_active Boolean Dimension
engagement_activitytype String Dimension
engagement_allaccessibleteamids Integer Dimension
engagement_bodypreview String Dimension
engagement_bodypreviewhtml String Dimension
engagement_bodypreviewistruncated Boolean Dimension
engagement_createdat Integer Dimension
engagement_createdby Integer Dimension
engagement_gdprdeleted Boolean Dimension
associations_contactids Integer Dimension
engagement_lastupdated Integer Dimension
engagement_modifiedby Integer Dimension
engagement_ownerid Integer Dimension
engagement_portalid Integer Dimension
engagement_queuemembershipids Integer Dimension
engagement_source String Dimension
engagement_sourceid String Dimension
engagement_teamid Integer Dimension
engagement_timestamp Integer Dimension
engagement_type String Dimension
engagement_uid String Dimension
metadata_attachedvideoopened Boolean Dimension
metadata_attachedvideowatched Boolean Dimension
metadata_body String Dimension
metadata_calleeobjectid Integer Dimension
metadata_calleeobjecttype String Dimension
metadata_cc Record Dimension
metadata_completiondate Integer Dimension
metadata_createdfromlinkid Integer Dimension
metadata_disposition String Dimension
metadata_durationmilliseconds Integer Dimension
metadata_endtime Integer Dimension
metadata_externalaccountid String Dimension
metadata_externalid String Dimension
metadata_externalurl String Dimension
metadata_facsimilesendid String Dimension
metadata_forobjecttype String Dimension
metadata_from_email String Dimension
metadata_from_firstname String Dimension
metadata_from_lastname String Dimension
metadata_from_raw String Dimension
metadata_fromnumber String Dimension
metadata_hastranscript Boolean Dimension
metadata_html String Dimension
metadata_isallday Boolean Dimension
metadata_location String Dimension
metadata_loggedfrom String Dimension
metadata_mediaprocessingstatus String Dimension
metadata_meetingoutcome String Dimension
metadata_messageid String Dimension
metadata_postsendstatus String Dimension
metadata_premeetingprospectreminders Integer Dimension
metadata_priority String Dimension
metadata_recordingurl String Dimension
metadata_reminders Integer Dimension
metadata_senddefaultreminder Boolean Dimension
metadata_sender_email String Dimension
metadata_sentvia String Dimension
metadata_sequencestepenrollmentid String Dimension
metadata_sequencesteporder Integer Dimension
metadata_source String Dimension
metadata_sourceid String Dimension
metadata_starttime Integer Dimension
metadata_status String Dimension
metadata_subject String Dimension
metadata_tasktype String Dimension
metadata_text String Dimension
metadata_title String Dimension
metadata_to Record Dimension
metadata_tonumber String Dimension
metadata_trackerkey String Dimension
metadata_transcriptionid Integer Dimension
scheduledtasks Record Dimension

Forms

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

Field Data Type Dimension/Metric
guid system schema String Dimension
action String Dimension
businessunitid Integer Dimension
campaignguid String Dimension
captchaenabled Boolean Dimension
cloneable Boolean Dimension
createdat Integer Dimension
createmarketablecontact Boolean Dimension
cssclass String Dimension
customuid String Dimension
deletable Boolean Dimension
deletedat Integer Dimension
editable Boolean Dimension
editversion Integer Dimension
followupid String Dimension
formfieldgroups Record Dimension
formtype String Dimension
alwayscreatenewcompany Boolean Dimension
ignorecurrentvalues Boolean Dimension
inlinemessage String Dimension
internalupdatedat Integer Dimension
ispublished Boolean Dimension
kickbackemailsjson String Dimension
kickbackemailworkflowid Integer Dimension
leadnurturingcampaignid String Dimension
metadata Record Dimension
method String Dimension
migratedfrom String Dimension
multivariatetest Record Dimension
name String Dimension
notifyrecipients String Dimension
parentid Integer Dimension
performablehtml String Dimension
portablekey String Dimension
portalid Integer Dimension
publishat Integer Dimension
publishedat Integer Dimension
redirect String Dimension
style String Dimension
submittext String Dimension
thankyoumessagejson String Dimension
themecolor String Dimension
themename String Dimension
tmsid String Dimension
unpublishat Integer Dimension
updatedat Integer Dimension

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.

Field Data Type Dimension/Metric
id system schema Integer Dimension
contactcounts Record Dimension
creationsource Record Dimension
description String Dimension
enabled Boolean Dimension
contactlistids Record Dimension
insertedat Integer Dimension
lastupdatedbyuserid Integer Dimension
migrationstatus Record Dimension
name String Dimension
originalauthoruserid Integer Dimension
portalid Integer Dimension
type String Dimension
updatedat Integer Dimension
updatesource Record Dimension

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.

Field Data Type Dimension/Metric
ownerid system schema Integer Dimension
activesalesforceid String Dimension
createdat Integer Dimension
email String Dimension
firstname String Dimension
hascontactsaccess Boolean Dimension
isactive Boolean Dimension
lastname String Dimension
activeuserid Integer Dimension
portalid Integer Dimension
remotelist Record Dimension
signature String Dimension
type String Dimension
updatedat Integer Dimension
useridincludinginactive Integer Dimension

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.

Field Data Type Dimension/Metric
property_name system schema String Dimension
vid system schema Integer Dimension
canonical_vid Integer Metric
identity_profiles Record Dimension
is_contact Boolean Dimension
portal_id Integer Dimension
addedat Integer Metric
property_value String Dimension
form_submissions Record Dimension

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.

Field Data Type Dimension/Metric
property_name system schema String Dimension
vid system schema Integer Dimension
canonical_vid Integer Metric
identity_profiles Record Dimension
is_contact Boolean Dimension
portal_id Integer Dimension
addedat Integer Metric
property_value String Dimension
form_submissions Record Dimension

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.

Field Data Type Dimension/Metric
id system schema Integer Dimension
ab Boolean Dimension
absamplesizedefault String Dimension
absamplingdefault String Dimension
absoluteurl String Dimension
abstatus String Dimension
absuccessmetric String Dimension
abtestid Integer Metric
abtestpercentage Integer Metric
abvariation Boolean Dimension
allemailcampaignids Integer Metric
analyticspageid String Dimension
analyticspagetype String Dimension
archived Boolean Dimension
author String Dimension
authorname String Dimension
blogrsssettings String Dimension
campaign String Dimension
campaignname String Dimension
campaignutm String Dimension
canspamsettingsid Integer Metric
categoryid Integer Metric
clonedfrom Integer Metric
contenttypecategory Integer Metric
created Integer Metric
createdbyid Integer Metric
createpage Boolean Dimension
currentlypublished Boolean Dimension
currentstate String Dimension
customreplyto String Dimension
customreplytoenabled Boolean Dimension
domain String Dimension
emailbody String Dimension
emailbodyplaintext String Dimension
emailcampaigngroupid Integer Metric
emailnote String Dimension
emailtemplatemode String Dimension
emailtype String Dimension
feedbacksurveyid String Dimension
folderid Integer Metric
freezedate Integer Metric
fromname String Dimension
hascontentaccessrules Boolean Dimension
htmltitle String Dimension
abhourstowait Integer Metric
isgraymailsuppressionenabled Boolean Dimension
ispublished Boolean Dimension
isrecipientfatiguesuppressionenabled Boolean Dimension
language String Dimension
lasteditsessionid Integer Metric
lasteditupdateid Integer Metric
layoutsections Record Dimension
livedomain String Dimension
mailinglistsexcluded Integer Metric
mailinglistsincluded Integer Metric
maxrssentries Integer Metric
metadescription String Dimension
name String Dimension
pageexpiryenabled Boolean Dimension
pageredirected Boolean Dimension
portalid Integer Metric
previewkey String Dimension
primaryemailcampaignid Integer Metric
primaryrichtextmodulehtml String Dimension
processingstatus String Dimension
publishdate Integer Metric
publishedat Integer Metric
publishedbyemail String Dimension
publishedbyid Integer Metric
publishedbyname String Dimension
publishedurl String Dimension
publishimmediately Boolean Dimension
replyto String Dimension
resolveddomain String Dimension
rssemailbytext String Dimension
rssemailclickthroughtext String Dimension
rssemailcommenttext String Dimension
rssemailentrytemplateenabled Boolean Dimension
rssemailimagemaxwidth Integer Metric
rssemailurl String Dimension
scrubssubscriptionlinks Boolean Dimension
sections Record Dimension
securitystate String Dimension
slug String Dimension
state String Dimension
subcategory String Dimension
subject String Dimension
subscription Integer Metric
subscriptionname String Dimension
templatepath String Dimension
transactional Boolean Dimension
unpublishedat Integer Metric
updated Integer Metric
updatedbyid Integer Metric
url String Dimension
userssheadlineassubject Boolean Dimension
vidsincluded Integer Metric
visibletoall Boolean Dimension

Was this article helpful?