Guide: Using HubSpot CRM with Databox

HOW TO

How to connect HubSpot CRM to Databox

IN THIS SECTION

How to connect HubSpot CRM to Databox

To connect a HubSpot CRM Account in Databox, go to  Data Manager > + New connection. Type HubSpot CRM in the search bar and click on the green Connect button. 

This will open the  Authorization window where you will be prompted to enter your HubSpot login credentials and authorize the Databox app. 

What HubSpot CRM permissions do you need to connect a HubSpot Data Source in Databox?

To connect a HubSpot CRM account in Databox, you will need Sales Access enabled. Learn more here

To report on Contacts Metrics (e.g. ''Contacts (Marketing)''), you will need HubSpot Marketing Professional or HubSpot Marketing Enterprise Account. Learn more here.

What's the maximum amount of historical data initially available when you use a new HubSpot CRM Data Source Metric in Databox?

Data is synced for the Metrics that are being used in your Account, so when you first use a new HubSpot CRM Metric, the maximum amount of historical data available is 36 months. 

Certain Metrics may have more or less historical data available based on the API restrictions. 

For more information about the amount of historical data available for a specific Metric learn more here.

Pro Tip: In order to start syncing data for a Metric, you can add it to your Metrics screen, use it in a Scorecard, set a Goal around it, create an Alert for it, or add it to a Databoard. Learn more here.    
    The amount of historical data you're able to access in Databox is dependent on your Databox plan. Learn more here

What time zone does HubSpot CRM data sync in? 

HubSpot CRM data is synced in the time zone set in the HubSpot Account. For example, if your HubSpot Account time zone is set as EST, your HubSpot data will sync with Databox in EST. 

Which HubSpot Marketing plans have API access?

HubSpot Marketing Professional and HubSpot Marketing Enterprise Accounts can connect with Databox. Learn more here

How to access pre-built HubSpot CRM Templates

1
 Navigate to Databoards > Public Templates
2
 In the Data Source drop-down list, select HubSpot CRM
3
 To view a preview of the Template populated with dummy data, click Preview
4
 To pull the Template into your Account and re-populate it with your own HubSpot CRM data, click Use Template
5
 Select the appropriate HubSpot CRM Data Source from the drop-down list to complete the process. The Databoard will be re-populated with data from the selected HubSpot CRM Account and can be found on the  Databoards page
Pro Tip: Once the Databoard is available on the Databoards page, it is completely disconnected from the public Template. Therefore, you can further customize this Databoard to meet your specific needs using the Designer.

Popular HubSpot CRM Templates

HubSpot CRM Weekly Sales Performance (Sales Rep View)
This dashboard provides you with insights about deals and sales pipelines to help you to track and grow your pipelines.
This template helps sales reps manage and track their weekly sales activity metrics like emails, calls, and deals created.

How to build a Databoard using HubSpot CRM data

IN THIS SECTION

Popular Use Cases

Learn more about popular HubSpot CRM use cases here.

Popular HubSpot CRM Metrics

Deals Closed Won Sales Closed Deals Leaderboard




Deals Overview New Deals Created Amount Sales Pipeline

View a full list of HubSpot CRM Metrics available in Databox here.

How to build a Databoard

1
 Navigate to  Databoards > + New Databoard > Start Blank
2
 Click on the Metric Library icon on the lefthand side of the Designer
3
 Select the appropriate HubSpot CRM Account from the Data Source drop-down list in the Metric Library
4
 View the list of pre-built HubSpot CRM Datablocks in the Metric Library. Drag and drop your selected Datablock onto your Databoard    
5

 If a pre-built Datablock isn't available for your use case, click on the  Visualization Types icon under the Metric Library icon

6
 View the list of Visualizations available in Databox. Drag and drop your selected Visualization onto your Databoard
7
 Click on the Datablock on the Databoard to open the corresponding Datablock Settings on the righthand side of the Designer
8
 Select the appropriate HubSpot CRM Data Source and Metric in the righthand Property Manager. This will update the Datablock and it will populate the Datablock with the corresponding data
 
9
 Complete steps 4-8 until your Databoard is complete

How to use the Query Builder for HubSpot CRM

With the Query Builder for HubSpot CRM, you can create Custom HubSpot CRM Metrics using a combination of Metrics, Dimensions, and Filters. Some popular use cases for the Query Builder for HubSpot CRM include tracking individual Sales Rep performance and filtering by custom Deal Properties. 

Learn more about the Query Builder for HubSpot CRM here

Additional Information

IN THIS SECTION

Metric Considerations

  • Due to technical limitations, the Date Range ''All Time'' will return a maximum 36 months of historical data.
  • However, Metrics that represents total values (i.e. ''Total Contacts (Marketing)'', ''Total Revenue by Company'') will always show current total value when ''All Time'' Date Range is selected.
  • Due to API limitation, a maximum of 30 days (or at most 10,000 recent engagements) of historical data is available in Databox for the Engagement Metrics. 
  • Engagement Metrics include all metrics that report on Calls, Meetings, Tasks, Notes, and Emails from HubSpot CRM.

  • All currency Metrics (e.g., "Deals Closed Won Amount," "New Deals Created Amount," etc.) are synced without the corresponding unit (currency). The unit must be set in Databox. Learn more here.

Granularity Restrictions

  • Due to API limitations, hourly granularity is not supported. This may affect visualization options for Charts in Databox.

    For example, if a HubSpot CRM Metric is used on a Line or Bar Chart with ''Yesterday'' Date Range selected, hourly data won't be displayed on the Chart. However, the big number above the Chart will accurately reflect the Metric value for the selected Date Range.

    Learn more about Granularity here

API Limitations

  • Metrics in HubSpot accounts are reporting on data from Sunday to Saturday. There is no option to change the first day of the week within their UI. Read more here.

    In Databox, the first day of the week is set to Sunday by default. However, you are able to change it to Monday or Saturday. Learn more here.

    When validating weekly data in HubSpot vs Databox (e.g. looking at ''Week to Date'', ''This Week'' or "Last Week'' Date Ranges), it's important to compare data for the same time period (e.g. from Sunday to Saturday).
Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Still need help? Contact Us Contact Us