Skip to content

Use data join in datasets

Last updated: October 24, 2024

Available with any of the following subscriptions, except where noted:

Operations Hub   Professional , Enterprise

Use datasets to combine different data sources, create new information, and customize reports using powerful data views. 

A dataset is a tool that helps you prepare your data to use it in a more meaningful way. It combines your most important sources of data to create custom reports.

When choosing your data sources, use data join to see how they are being joined. This will create a graph of sources with information about the join type. 

Create a dataset

To create a dataset:

  • In your HubSpot account, navigate to Data ManagementDatasets.
  • In the upper right, click Create dataset. Or to create a dataset using a template, browse the available templates, then click Use template

Select data sources

First, select the data sources to include in your dataset. Data sources are the objects, assets, and events that you want to report on. This includes all CRM objects such as contacts or custom objects, and assets such as website pages and emails, conversations, sales activities, and more. You can select up to 5 data sources per dataset.

  • To select the primary data source, click + Add primary data source.

primary-data-source-blank

  • Select a data source. The primary data source defines the first or only source of data that can be used to create a reportable table of data.

Primary-data-source

  • Click Continue. Once a data source is chosen, the preview table at the bottom of the screen shows which properties are available for that data source. 

data-preview

  • To combine multiple data sources, click Join another data source

join-another-data-source

Select a data source, and click Continue. HubSpot will attempt to automatically join the tables of data using a known association. 

preview-your-join
    • If there’s no known association between the sources you've selected and the new source selection, or you want to use a custom join, click to toggle the Customize your join switch on.
    • Select Use association labels or Use join key.
      • Use association labels: combine labels such as primary or secondary. Click the Associations dropdown menu to select an association. Depending on your datasources, you may not be able to select an association label.
      • Use join key: combine columns of data (typically properties). Click the Left table key dropdown menu to select the left table data, and click the Right table key dropdown menu to select the right table data.
  • Review the join, then click Add suggested join or Add custom join.

multiple-data-sources

 

Was this article helpful?
This form is used for documentation feedback only. Learn how to get help with HubSpot.