Overview: Query Builder for HubSpot Marketing (Emails)
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
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 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.