Master Overview: Query Builders for HubSpot CRM
The Query Builders for HubSpot CRM allow you to create Custom Metrics based on Deals and Custom Company data. A summary of each Query Builder for HubSpot CRM is outlined below, along with links to full documents outlining the functionality of each Query Builder.
Query Builder is available on the Professional and Performer plans. Request a trial of Query Builder by following
How the Query Builder for Deals works
To track Deals data like Open Deals, Closed Won Deals, Closed Lost Deals, and Sales Activities during a specified Date Range, you'll want to use the Query Builder for Deals.
Sample Custom Metrics: ''Count of Deals by Deal Stage,'' ''Amount by Pipeline,'' ''Number of Sales Activities by Deal Name,'' ''Closed Won Deals by Deal Owner''
Learn more about the Query Builder for Deals here.
How the Query Builder for Company Properties works
To report on Custom Company Properties during a specified Date Range, you'll want to use the Query Builder for Company Properties.
This Query Builder is also a great way to access Custom Company Properties that are not accessible from Basic HubSpot Metrics. For example, if you wanted to report on the number of Companies for a specific Property, you'd want to set a Custom Company Property in HubSpot. You can then create a Custom Metric in Databox to report on the number of Companies for that Custom Property.
Sample Custom Metrics: "Count of Companies by Tier," "Count of Companies by Plan Name," "Total Revenue by State/Region," ''Number of Form Submissions by Lead Status''
Learn more about the Query Builder for Company Properties here.