Follow the Metric Recipe below to create the metric.
1. Configure the dataset
If you already have an existing dataset, ensure that you have the following views and columns included. Read more about how to create a dataset: https://help.databox.com/create-a-dataset
a) Include these columns in the HubSpot Marketing Dataset
Data Source
Views
Columns
HubSpot Marketing
Contacts
Id
Original Traffic Source
Became a Subscriber Date
b) Include these columns in the HubSpot CRM - Associations Dataset
Data Source
Views
Columns
HubSpot CRM
Company to Contact Associations
Contact ID
Company ID
c) Include these columns in the HubSpot CRM - Companies Dataset
Data Source
Views
Columns
HubSpot CRM
Companies
Id
Company Owner
d) Include these columns in the HubSpot CRM - Owners Dataset
Data Source
Views
Columns
HubSpot CRM
Owners
Id
FirstName
LastName
e) Create a new Calculated Column to combine FirstName and LastName
Edit the Owners Dataset and create a new calculated column by clicking on the + icon on the right side.
Insert the following function: CONCAT($FirstName, ' ', $LastName)
Rename the column to Full owner name.
Save the Dataset.
f) Merge Datasets together
Dataset
Column to join
Operator
HubSpot Marketing Dataset
Id
Left Join
HubSpot CRM - Associations Dataset
Contact ID
Dataset
Column to join
Operator
HubSpot CRM - Associations Dataset
Company Id
Left Join
HubSpot CRM - Companies Dataset
Id
Dataset
Column to join
Operator
HubSpot CRM - Companies Dataset
Company owner
Left Join
Owners
Id
2. Create the Custom Metric
Navigate to Metric Builder and create a new Custom Metric by selecting the dataset created in the previous step. Read more about how to create a custom metric: https://help.databox.com/create-a-custom-metric
Field
Value
Measure
Id
Date
Became a Subscriber Date
Dimension
Full owner name
Aggregation
COUNT
Filters
(optional) Original Traffic Source - not equal - OFFLINE
Check out the Schema Explorer to learn more about all supported views and columns/properties: