HubSpot predefined reports
The HubSpot data source in Data Integration comes with the predefined reports. Each report includes a short description of the data, a list of customizable fields (if any), and the schema mapping.
Since these reports follow a standardized format, a few fields are locked, and you can only access them through the Custom Reports feature.
note
HubSpot has no source-level selections to filter each report in the river.
Deals
The Deals report represents a list of ongoing transactions a sales team is pursuing with a contact or company. The only customization for this report is the "Modified Deals" selection.
- If you select the Modified Deals checkbox, the endpoint returns records modified in the last 30 days, or the 10,000 most recently modified records.
- The endpoint returns all deals if you turn off the checkbox (current setup).
| Field | Data Type | Dimension/Metric |
|---|---|---|
dealid  | 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 information about the businesses or organizations within the HubSpot account. The only customization for this report is the "Modified Companies" selection.
- If you select the "Modified Companies" checkbox, the endpoint returns records modified in the last 30 days, or the 10,000 most recently modified records.
- The endpoint returns all companies if you turn off the checkbox (current setup).
| Field | Data Type | Dimension/Metric |
|---|---|---|
| companyid | 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 | 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 | 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 retrieves the details of the forms previously set up in the HubSpot account.
| Field | Data Type | Dimension/Metric |
|---|---|---|
| guid | 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 previously created marketing automation campaigns that rely on triggering relevant and timely actions (like emails) for contacts.
| Field | Data Type | Dimension/Metric |
|---|---|---|
| id | 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 assigned to CRM object records (contacts, companies, deals, tickets, and engagements). The only customization for this report is to include or remove inactive owners.
| Field | Data Type | Dimension/Metric |
|---|---|---|
| ownerid | Integer | Dimension |
| activesalesforceid | String | Dimension |
| createdat | Integer | Dimension |
| 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. You will receive a paginated list of contacts, with a maximum of 100 contacts per page.
| Field | Data Type | Dimension/Metric |
|---|---|---|
| property_name | String | Dimension |
| vid | 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 updated contacts in the account. You will receive a paginated list of contacts, with a maximum of 100 contacts per page.
| Field | Data Type | Dimension/Metric |
|---|---|---|
| property_name | String | Dimension |
| vid | 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 to find specific emails you are searching for.
| Field(filtering options) | Data Type | Dimension/Metric |
|---|---|---|
| id | 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 |
