Overview: Query Builder for HubSpot Marketing (Workflow Contact Performance)

HOW TO

How to access the Query Builder for HubSpot Marketing (Workflow Contact Performance)

Navigate to  Metrics > Query Builder to access the Query Builder for HubSpot Marketing. Click the green + Create Custom Metric button and select your connected HubSpot Marketing Account from the Data Source drop-down list. Select the Workflow Contact Performance button. 

    Query Builder is available on the Professional and Performer plans. Request a trial of Query Builder by following these steps.  

How to use the Query Builder for HubSpot Marketing (Workflow Contact Performance)

A
  Data Source: This is the Data Source that the Custom Metric is syncing data from. 
B
  Workflow: Select a Workflow from your connected HubSpot Marketing Data Source.   
C
  Metric: Select a Metric from your connected HubSpot Marketing Data Source, such as "Completed Workflow," "Contacts Enrolled" or "Contact Lost." 
D
  Favourable Trend: By default,  Trending up is positive is pre-selected, which will display the percentage change value on Datablocks as green when the Metric value has increased. If the Custom Metric you created has opposite trends, select  Trending down is positive radio button. Learn more here.   
E
  Preview data: After clicking Preview data, a Data Preview of the Custom Metric will be displayed. Daily Metric values are displayed in this section, along with the total Metric values for the Date Range in bold at the bottom. You can view the Data Preview for different Date Ranges by clicking on the drop-down list at the top of the Data Preview.  
F
   Custom Metric Name: Enter a name for your Custom Metric. This Custom Metric name will be available in the Designer after saving.
G
   Save: Save your Custom Metric.

How to create a Custom Workflow Contact Performance Metric [Example]

In this example, we'll create a Custom Metric to return the number of Contacts who completed our Onboarding Workflow. 

1
 Navigate to Metrics > Query Builder   
2
 Click the green + New query button
3
 Select the appropriate HubSpot Marketing Data Source and the Workflows button
4
 We will select Onboarding Completed from the Workflow dropdown list
5
 Since we want to track Contacts who completed the Workflow, we'll select  Completed Workflow as the Metric
6
 In order to accurately explain what this Custom Metric is reporting on, we'll name the Custom Metric  # Contacts Completed Onboarding Workflow
7
 Click Preview data to generate a Data Preview of the Custom Metric
8
 Once we confirm that these are the results we're looking for, we'll click Save to save the Custom Metric

How to add a Custom Workflow Contact Performance Metric to a Databoard

1
 Open the selected Databoard in the Databox Designer, or create a new Databoard.
2
 Drag and drop a blank Datablock onto the Databoard from the Visualization Library. 
3
 Select the appropriate HubSpot Marketing Data Source from the righthand Datablock Settings panel. This must be the same HubSpot Marketing Account that was selected when creating the Custom Metric. 
4
 Select the  Custom tab at the top of the  Metric drop-down list. 
5
 Select the Custom Metric name to populate the Datablock.

Additional Information

Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.