Overview: Query Builder for HubSpot Marketing (Emails)
How to access the Query Builder for HubSpot Marketing (Emails)
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 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
How to use the Query Builder for HubSpot Marketing (Emails)
Pro Tip: Add the word "by" in between the Metric and Dimension in order to determine an appropriate Custom Metric Name. From the Metric and Dimension examples outlined above, we could create the Custom Metrics "Sent Emails by Email Title," "Opened Emails by Email Title," or "Clicked Emails by Email Title."
Preview data: After clicking Preview data, 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.
Custom Metric Name: Enter a name for your Custom Metric. This Custom Metric Name will be available in the Designer after saving.
Save: Save your Custom Metric.
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.
How to add a Custom Blog Metric to a Databoard
- Due to an API limitation, Custom Metrics built using this Query Builder will only show the All Time (total) data. This means that when a Custom Metric is created, no data will be returned for Date Ranges that don't include "Today." Data will continue to accumulate for this Custom Metric over time.
Date Ranges such as "Week to Date" and "This Month" include "Today." Date Ranges such as "Last 7 Days" and "Last 90 Days" do not. Learn more about the parameters for each Date Range here.
- If there is no data returned for the current day, no data will be displayed in the Preview data.
- Data is only available for Emails that have gone live.