Overview: HubSpot Marketing Email Query Builder
In this article, we will create a custom metric using the HubSpot Marketing Email Query Builder in order to highlight key functionalities of the tool. For our example, we will create a new Custom Metric that returns the number of Email Opens for non-Newsletter Emails.
IN THIS ARTICLE
1. Basic Options
We chose "Emails Opened (excluding Newsletters)" for our Custom Metric name.
We chose "Opened" as our Metric selection.
2. Advanced Options
When everything mentioned above is set, click Run query to generate the Data Preview.
3. Data Preview
In the Data Preview, you will see the total values returned for the current day.
If you want to sort values by date/ time just click on the arrow next to "Date"
When your Custom Metric is ready, click Save query. This creates a Custom Metric under your HubSpot Marketing Data Source, with the Custom Metric name you specified in section A (i.e., Emails Opened (excluding Newsletters)).
By default, the Custom Metric will be added within the Data Source that the data is pulled from. It is possible to change the Target Data Source by clicking on Target data source hyperlink in the top right of the Query Builder. Unless this is necessary for a specific use case, we do not recommend changing the Target Data Source.
4. Additional Info
- Custom Metrics built using the Email Query Builder will still have an open "start date," meaning a Custom Metric like "Emails Opened (excluding Newsletter)" will show the total number of non-Newsletter Emails that were ever opened up until the end of the specified Date Range.
- If there is no data returned for Today, no data will be displayed in the Data Preview.
- Data is only available for Emails that have gone live.