Overview: Query Builder for HubSpot Marketing (Website Pages)
How to access the Query Builder for HubSpot Marketing (Website Pages)
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 Website Pages button.
Website Pages is a HubSpot Marketing add-on. If this add-on is not used in the HubSpot Account, Website Page data will not be returned from HubSpot's API.
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 (Website Pages)
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 "Pageviews by Page Title," "Avg Time on Page by Page Title," or "CTA Clicks by Page Title."
Date Range: Select up to 8 Date Ranges that will be available for the Custom Metric. The Date Ranges selected are the only periods of time that data is synced for this Custom Metric.
If there is no data returned for the specified Date Range(s), no data will be displayed in the Data Preview. Only Website Pages with tracked data will be accessible through this Query Builder.
Pro Tip : If you don't know which Filters to put in place for your use case, use the Dimension + Data Preview to troubleshoot and get more insight into the data that is returned from your HubSpot Marketing Account for each field. Learn more here.
How to create a Custom Website Page Metric [Example]
In this example, we'll create a Custom Metric to return a list of the Average Bounce Rate split up by Page for our Website Pages that contain "Red" in the Page Title.
How to add a Custom Website Page Metric to a Databoard
- Up to 36 months of historical data is accessible through this Query Builder.
- Daily data is not available for Custom Metrics created through this Query Builder. Because of this, you will want to view your Custom Website Page Metrics on a Visualization Type that does not necessitate granularity options. Line Charts and Bar Charts will not be good Visualization Types for this data, but Tables, Pie Charts, and Number Blocks will be.
- If a Website Page has 0 Pageviews during the selected Date Range, the Website Page will not be visible in the Data Preview.
- "Page Title" refers to the Title of the Page on your Website, not the title of the Internal Website Page in your HubSpot Marketing Account.