Overview: Query Builder for HubSpot Marketing (Emails)

HOW TO

How to access the Query Builder for HubSpot Marketing (Emails)

Navigate to  Data Manager > 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 Email button. 

    Query Builder is available in Plus and Business Accounts. Agency Basic Accounts have access to Query Builder in the Agency Account only.  Request a trial of Query Builder by following these steps  

How to use the Query Builder for HubSpot Marketing (Emails)

A
  Email Name:  Enter a name for your Custom Metric. This Custom Metric name will be available in the Designer after saving.
B
   Metric: Select a Metric from your connected HubSpot Marketing Data Source, such as "Sent," "Clicked or "Unsubscribed." 
C
  Select Emails: From the Select Emails section, you can select specific Emails from your HubSpot Account that you want to collect data for. These Emails will be the only ones that are included in the Custom Metric. 
D
  Email Filters: From the Email Filters section, you can enter text that the Email Name in the HubSpot Account must "contain" or "not contain." For example, if all internal Emails in your HubSpot Account have "Internal" in the Email Name, you can set a Filter to exclude all Emails that contain "Internal" in the Email Name for your company's dashboard. 
E
   Group and Summarize Email Values: By default, the Custom Metric will return a list of Email Names and their associated Metric Values. This is great to display on a Table or Pie Chart. 

There are also cases where it's valuable to have 1 aggregated number to report on high-level data. In order to do this, check the Group and Summarize Email Values checkbox. This will aggregate all of the individual email values that were returned into one high-level Metric. 

F

  Group and Summarize Email ValuesData Preview: After clicking Run query, a Data Preview of the Custom Metric will be displayed. If there is no data returned for the current day, no data will be displayed in the Data Preview.

How to create a Custom Email Metric [Example]

In this example, we'll create a Custom Metric to return a single value representing the number of Emails Sent that contain "Blog" in the Email Name. 

1
 Navigate to Data Manager > Query Builder   
2
 Click the green + New query button
3
 Select the appropriate HubSpot Marketing Data Source and the  Emails button
4
 In order to accurately explain what this Custom Metric is reporting on, we'll name the Custom Metric "Blog" Emails Sent
5
 Rather than selecting individual Emails in the Select Emails section, we will be setting a Filter in the Email Filters section
6
 Select Email Name as the Property, Contains as the Operator. We'll type blog into the Value textbox so all Emails that contain "blog" in the Email Name will be included in this Custom Metric. 
7
 We want 1 Value returned from this Custom Metric that reflects the total number of Emails Sent that promoted our Blog. So, we will check the Group and summarize email values checkbox. 
8
 Click Run query to generate a Data Preview of the Custom Metric
9
 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 Blog 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 Info

  • Due to a limitation of the API, Custom Metrics built using this Query Builder will have an open start date. This means that a Custom Email Metric with the selected Date Range "Last Month" will show All Time Metric Values up until the end of Last Month.
  • If there is no data returned for the current day, no data will be displayed in the Data Preview.
  • Data is only available for Emails that have gone live. 
Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Still need help? Contact Us Contact Us