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)
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.
Group and Summarize Email Values: Data 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.
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 Data Preview.
- Data is only available for Emails that have gone live.