HubSpot provides a wide array of default reports, but they often fall short of answering the specific questions your business needs to ask. Relying solely on the standard report library means you are likely missing critical insights into your marketing performance, sales pipeline health, and customer service efficiency. The real power of HubSpot's platform is unlocked when you move beyond canned reports and start building custom visualisations tailored to your unique Key Performance Indicators (KPIs). Without this, you are navigating your growth strategy with an incomplete map.
The goal of custom reporting is to transform raw data into actionable intelligence. It is about creating dashboards that provide a clear, at-a-glance view of what is working and what is not. For marketers, this means proving campaign ROI. For sales leaders, it means accurately forecasting revenue and managing pipeline. For service managers, it means identifying bottlenecks and improving customer satisfaction. A well-configured set of dashboards aligns your entire organization around the same data-driven objectives.
This guide provides a practical framework for creating custom reports and dashboards within HubSpot. We will cover the foundational reporting tools, how to define your strategic KPIs, and step-by-step instructions for building dashboards for your marketing, sales, and service teams. We will also explore the power of cross-object reporting for full-funnel analysis. If you find the process complex, remember that expert HubSpot support and maintenance can accelerate your path to data clarity.
Understanding HubSpot's Reporting Tools
Before diving into building, it is crucial to understand the tools at your disposal. HubSpot's reporting capabilities are tiered across different hubs and subscription levels. The primary tool is the Report Builder, which allows you to create custom visualisations of your data. The accessibility and power of this builder depend on your HubSpot subscription. Users on Free and Starter plans have access to basic reports and a limited number of dashboards, while Professional and Enterprise users unlock the full suite of custom reporting tools.
The Custom Report Builder itself has two main variants: single-object and cross-object. A single-object report pulls data from one source, such as contacts, deals, or tickets. For example, you could build a report showing 'Number of Contacts Created by Month'. A cross-object report, available in Professional and Enterprise tiers, is significantly more powerful. It allows you to combine data from multiple object types, such as reporting on 'Deals Won by the Original Source of Associated Contacts', providing a true end-to-end view of your funnel.
Finally, Dashboards are where your reports live. A dashboard is a collection of up to 30 reports, displayed as a single screen. You can create multiple dashboards for different purposes, teams, or individuals. For example, you might have a 'Marketing Team KPI Dashboard', a 'Sales Leaderboard', and a 'Customer Service Daily Snapshot'. Proper dashboard organization is key to making data accessible and preventing information overload for your teams. The number of dashboards you can create is also limited by your subscription tier.
Defining Your Key Performance Indicators (KPIs)
A report is only as valuable as the question it answers. Before you build a single chart, you must define the KPIs that matter to your business. Starting with the technology before the strategy is a common mistake that leads to cluttered dashboards and vanity metrics. Sit down with your marketing, sales, and service leaders to agree on a core set of metrics that directly reflect business goals. What numbers, if they improve, will have a material impact on revenue and growth?
For a marketing team, KPIs should move beyond simple traffic and follower counts. Focus on metrics that demonstrate influence on the pipeline. Examples include: Marketing Qualified Leads (MQLs) generated per channel, lead-to-MQL conversion rate, customer acquisition cost (CAC) by campaign, and the number of contacts generated from key HubSpot landing pages. These metrics connect marketing activity directly to the sales process.
For a sales team, KPIs should focus on pipeline velocity and efficiency. Track metrics like deals created per month, average sales cycle length, deal win rate, and sales activity metrics (calls logged, meetings booked). For customer service, focus on efficiency and satisfaction. Key metrics include average first response time, average ticket resolution time, and ticket volume by category. A robust HubSpot CRM setup and automation plan is essential to ensure you are capturing the data needed to track these KPIs accurately.
Building a Marketing Performance Dashboard
Your Marketing Performance Dashboard should provide a comprehensive overview of your lead generation engine and its impact on the business. Start by adding reports from the standard library that cover high-level metrics, such as 'Sessions by Source' to understand where your traffic is coming from. Then, begin building custom reports to answer more specific questions. A fundamental report to create is 'New MQLs by Original Source', which helps you allocate your marketing budget to the most effective channels.
To build this, you would use the custom report builder, select the 'Contacts' object, and filter for contacts where 'Lifecycle Stage' became 'Marketing Qualified Lead' within a specific date range. You would then visualize this data as a column chart, broken down by the 'Original Source' property. Another vital report is 'Landing Page Performance', showing views, submissions, and conversion rates for your top pages. This helps you identify which content offers are resonating with your audience and which pages need optimization.
Combine these with reports on blog performance (e.g., 'Blog Post Views that Generated New Contacts') and email marketing engagement ('Email Click-Through Rate by Campaign'). When assembled on a single dashboard, these reports provide a 360-degree view of your marketing funnel. You can see how users are finding you, what content converts them into leads, and which campaigns are driving the most qualified prospects for the sales team. This is the first step in proving marketing's direct contribution to revenue.
Creating a Sales Pipeline Dashboard
A Sales Pipeline Dashboard is the command center for any sales leader. Its purpose is to provide a real-time view of pipeline health, team performance, and revenue forecasts. This dashboard should combine deal-focused reports with activity-based reports to give a full picture. Start with a 'Deal Forecast' report, which uses deal stages and amounts to project future revenue. This is a standard HubSpot report but is arguably the most important one for any sales leader.
Next, build custom reports to dissect the pipeline. A 'Deals Created vs. Goal' report helps track new business generation. A 'Win Rate by Rep' report can identify top performers and those who may need coaching. One of the most insightful reports is 'Deal Velocity', which measures the average time deals spend in each stage of your pipeline. This report is critical for identifying bottlenecks. If deals are consistently getting stuck in the 'Proposal Sent' stage, for example, it signals a problem with your proposal or pricing process that needs to be addressed.
At HubStack, we advise clients to include activity metrics alongside outcome metrics. Create reports for 'Meetings Booked by Rep' and 'Calls Logged by Rep'. These leading indicators often predict future success. If a rep's activity drops, their deal creation numbers will likely drop in the following weeks. A well-rounded sales dashboard balances these activity metrics with pipeline metrics, providing a complete story of team performance. To see examples of our strategic approach, view our work with other B2B companies.
| Report Name | Report Type | Objects Used | Key Question it Answers |
|---|---|---|---|
| Deal Forecast by Stage | Single Object | Deals | What is our projected revenue for this quarter? |
| New Deals Created by Source | Single Object | Deals | Which channels are generating the most valuable opportunities? |
| Sales Cycle Length | Single Object | Deals | How long does it take us to close a deal on average? |
| Win Rate by Rep | Single Object | Deals | Who are our top-performing sales representatives? |
| Deal Stage Velocity | Single Object | Deals | Where are deals getting stuck in our sales process? |
| Sales Activity by Rep | Single Object | Engagements (Calls, Meetings) | Is my team putting in the required effort to build pipeline? |
Building a Customer Service Dashboard
For businesses using HubSpot Service Hub, a dedicated dashboard is essential for monitoring support team efficiency and customer satisfaction. The goal is to move from a reactive support model to a proactive one, using data to identify trends and prevent issues before they escalate. The foundation of this dashboard is ticket data. Start by building reports that show 'Ticket Volume Over Time', 'Tickets by Status', and 'Tickets by Priority'. These give you an immediate sense of your team's workload and current backlog.
The next layer of reporting should focus on performance and efficiency. Two critical metrics are 'Average First Response Time' and 'Average Time to Close Ticket'. These KPIs directly impact customer satisfaction. If response times are creeping up, it may be a sign that your team is understaffed or that your ticket routing rules need adjustment. You can visualize this data broken down by individual rep to identify high performers and opportunities for team training.
The most strategic service reports categorize tickets to uncover underlying issues. Create a custom ticket property called 'Ticket Category' (e.g., Billing Issue, Product Bug, User Error). Then, build a report showing 'Ticket Volume by Category'. If you see a spike in tickets related to a specific product feature, you can proactively alert your product team. This transforms the service team from a cost center into a valuable source of business intelligence, helping to improve the overall customer experience.
Cross-Object Reporting: The Key to Full-Funnel Insights
Cross-object reporting is where HubSpot's reporting engine truly shines, and it is the key to achieving full-funnel attribution. This feature, available in Professional and Enterprise tiers, allows you to connect the dots between different data sets, most importantly between marketing activities and sales outcomes. It answers the ultimate question for any marketer: which of our efforts are generating actual revenue? This level of reporting is often where businesses seek expert help from a specialist like HubStack.
A classic example of a powerful cross-object report is 'Closed-Won Deals by Original Source of Associated Contacts'. This report uses data from both the Deals object and the Contacts object. It tells you not just which deals closed, but also how the primary contact on that deal originally found your company months or even years earlier. This allows you to attribute revenue back to specific marketing channels like Organic Search, Paid Social, or a specific blog post you published last year.
To create this, you would use the custom report builder, select 'Deals' as the primary data source, and then add 'Contacts' as a secondary source. You can then filter for deals in the 'Closed Won' stage and display the 'Deal Amount' summarized and broken down by the 'Contact's Original Source' property. You can take this even further by joining data from Campaigns, allowing you to report on 'Revenue Influenced by Marketing Campaign'. Mastering cross-object reporting provides undeniable proof of marketing's ROI and enables smarter budget allocation. If you need assistance setting this up, feel free to contact us.
Best Practices for Dashboard Management
Creating reports is only half the battle; maintaining them is just as important. Over time, dashboards can become cluttered with outdated or irrelevant reports. Schedule a quarterly review of all your primary dashboards. Ask stakeholders from each department: 'Is this report still useful? Does it help you make decisions?' Do not be afraid to delete reports that are no longer serving a purpose. A clean, focused dashboard is far more effective than a cluttered one.
Use HubSpot's permission settings to control who can view and edit your dashboards. Your executive dashboard with high-level revenue and CAC metrics should likely be visible to leaders but not editable. Conversely, a sales rep's personal dashboard should be customizable by them. You can also share dashboards with non-HubSpot users via email. Schedule a recurring email to send a summary of the marketing dashboard to the CEO every Monday morning, or email the sales leaderboard to the team every Friday afternoon.
Finally, treat your dashboards as living documents. As your business goals evolve, so should your KPIs and reports. When you launch a new product line, you will need new reports to track its performance. If you change your sales methodology, you will need to update your pipeline reports to reflect the new stages. Reporting is not a one-time setup. Continuous iteration is the key to ensuring your dashboards remain a relevant and powerful tool for data-driven decision-making across the entire organization.