Master Overview: HubSpot Marketing Query Builders

HubSpot Marketing Query Builders allow you to create Custom Metrics based on Lifecycle Stage, Smart List, Landing Page, Email and Blog data. A summary of each HubSpot Marketing Query Builder is outlined below, along with links to full articles on the functionality of each Query Builder. 

IN THIS ARTICLE

Contacts Query Builder

To report on all Contacts who entered a Lifecycle Stage during the specified Date Range, you'll want to use the Contacts Query Builder. 

Sample Custom Metrics: Became a Lead, Became an Opportunity by Original Source, Became a MQL by Owner, Became a SQL by HubSpot Team, etc.

Learn more about the Contact Query Builder here.

Smart List Query Builder 

To report on the total number of Contacts in a Smart List or the number of Contacts that entered/ exited a Smart List during a specified Date Range, you'll want to use the Smart List Query Builder. 

This Query Builder is also a great way to access Contact-specific data that may not be accessible via HubSpot's API. For example, if you wanted to report on the number of Leads for a specific Persona, you'd want to create a Smart List in HubSpot with the parameters being that the Contact is a Lead and the Contact Persona = x. You can then pull the Smart List into Databox to report on the number of Leads for that Persona. 

Sample Custom Metrics : Form 1 Submissions, Campaign 2 MQLs, Survey Completions, etc. 

Learn more about the Smart List Query Builder here.
Learn how to verify Smart List Contact values in HubSpot and Databox 
here.

Blog Query Builder 

To report on Blog Metrics like Pageviews, Subscribers, Submissions, CTA Views, etc. for a specific group of Blog Posts, you'll want to use the Blog Query Builder. 

Each Custom Metric built using the Blog Query Builder will return a list of Blog Posts and their associated Metric Values. The only Blog Posts that will be returned are those that satisfy the parameters outlined in the Filter(s). Filters can be added to differentiate between individual Blog Posts, Campaigns, Authors, and Metric Values.

Sample Custom Metrics : Bounce Rate by Blog Post, Average Time on Page by Blog Post for Campaign A, CTA Clicks by Blog Post for Author B, etc.

Learn more about the Blog Query Builder here.

Landing Page Query Builder 

To report on Landing Page Metrics like Pageviews, Subscribers, Submissions, CTA Views, etc. for a specific group of Landing Pages, you'll want to use the Landing Page Query Builder. 

Each Custom Metric built using the Landing Page Query Builder will return a list of Landing Pages and their associated Metric Values. The only Landing Pages that will be returned are those that satisfy the parameters outlined in the Filter(s). Filters can be added to differentiate between individual Landing Pages or Metric Values. 

Sample Custom Metrics :  Entrances by Landing Page, New Contacts by Landing Page, Bounce Rate by Landing Page for Landing Pages 1-4, etc.

Learn more about the Landing Page Query Builder here.

Email Query Builder 

To report on Email Metrics like Sends, Opens, Clicks, Bounces, etc. for a specific group of Emails, you'll want to use the Email Query Builder. 

You have the ability to choose whether Custom Metrics built using the Email Query Builder return a list of Emails and their associated Metric Values, or if you would like the individual Metric Values summarized and returned as 1 Value. For the Filters, you can manually select individual Emails to include, or you can add parameters to pull data from a group of Emails based on a shared naming convention. 

Due to limitations of the API, the Email Query Builder will have an open "start date." This means that a Custom Metric created for "Emails Opened (Emails 1-5)" will show the total number of times Emails  1-5 were ever opened up until the end of the specified Date Range. 

Sample Custom Metrics: Newsletter Email Open Rate, Contacts Lost by Email, Emails Delivered (Emails A-F), etc.

Learn more about the Email Query Builder here.

Still need help? Contact Us Contact Us