Follow the Metric Recipe below to create the metric Deals Closed-Won by Pipeline from HubSpot CRM.
1. Set up the dataset
Ensure that you have the following views and columns included in your dataset.
a) Include these columns in the Deals Dataset
Data Source
Views
Columns
HubspotCrm
Deals
Id
Pipeline
Close date
Deal stage
b) Include these columns in the Deal Pipeline Stages Dataset
Data Source
Views
Columns
Hubspot CRM
Deal Pipeline Stages
Id
Label
c) Merge Datasets together
Dataset
Column to join
Operator
HubSpot CRM - Deals
Deal Stage
Left Join
HubSpot CRM - Deal Pipeline Stages
Id
2. Create the Custom Metric
Navigate to Metric Builder and create a new Custom Metric by selecting the merged dataset you previously created.
Fill out the fields as shown in the table below.
Name your metric and save it.
Field
Value
Measure
Id
Date
Close date
Dimension
Pipeline
Aggregation
Count
Filters
Label = Closed Won
Check out the Schema Explorer to learn more about all supported views and columns/properties: https://schema-explorer.databox.com/?integrationkey=HubspotCrm