Deals Closed-Won by Pipeline [HubSpot]

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

  1. Navigate to Metric Builder and create a new Custom Metric by selecting the merged dataset you previously created.

  2. Fill out the fields as shown in the table below.

  3. 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