HubSpot dashboard: what's built in and how to go further

TL;DR: HubSpot's built-in reporting shows you CRM metrics: pipeline, email performance, contact activity, deal stages. It doesn't show you which campaigns generate actual revenue, how customers behave after they close, or what your real LTV looks like by acquisition source. Those answers require connecting HubSpot to your billing and product data. The fastest path: use an AI-native platform like Fabi to query across everything without building a data pipeline first.

If you're running a sales or marketing team on HubSpot, you know the dashboard well. Pipeline snapshots, email open rates, deal stage counts, contact activity logs. For running a weekly standup or checking in on rep performance, it works. HubSpot's reporting has gotten genuinely better over the years, and the custom report builder covers a lot of ground.

But HubSpot is built to manage your CRM and marketing automation. The reporting is a layer on top of that, and it inherits the same limitation: it can only see data that lives inside HubSpot.

"Which marketing campaigns generated the most revenue last quarter, not just the most leads?" "Do customers who went through a longer sales cycle have higher retention rates?" "What's the CAC-to-LTV ratio by lead source, after accounting for actual billing data?"

These questions require crossing out of HubSpot and into your billing system, product database, and finance data. This post covers what HubSpot's built-in reporting gives you, where it runs into walls, and how to build a more complete view.

What HubSpot's built-in reporting covers

HubSpot ships with a broad set of reporting across its hubs:

  • Pipeline reporting: Deal counts and value by stage, close rate, and velocity
  • Sales activity: Calls, emails, meetings logged per rep and team
  • Email marketing: Open rates, click rates, unsubscribe rates, and link-level performance
  • Landing page and form conversions: Submissions by page, form, and campaign
  • Attribution reports (paid tiers): First-touch, last-touch, and multi-touch attribution models
  • Revenue forecasting: Weighted pipeline and projection by close date
  • Contact and company growth: Database growth over time by source
  • Custom report builder: Drag-and-drop reports combining HubSpot objects

You can filter most of this by date range, team, pipeline, and owner. For a team that does all of its marketing and sales tracking inside HubSpot, this is reasonably complete for the CRM layer.

The custom report builder on higher tiers is genuinely flexible, you can combine data from contacts, companies, deals, and activities into a single report with cross-object filtering. For many teams, this covers the standard questions about pipeline health and marketing performance.

Where HubSpot reporting hits its limits

The gaps show up the moment you try to connect what HubSpot knows to the rest of your business.

Attribution stops at the lead. HubSpot can tell you which campaign a contact came from. It can't tell you whether that contact became a paying customer, what they paid, or how long they stayed. That requires a connection to your billing system. Without it, you're optimizing marketing for lead quality as HubSpot defines it, not for revenue.

No product usage data. HubSpot knows what contacts do before and during the sales process. After a deal closes, HubSpot's visibility ends unless you've built custom properties fed by integrations. Whether a customer is actively using your product, expanding, or quietly disengaging, none of that is visible without connecting product data.

Cross-hub reporting is fragmented. If you use Marketing Hub, Sales Hub, and Service Hub, data from each lives in somewhat separate objects. Building a truly unified view that connects a marketing campaign to the deals it influenced to the support tickets those customers filed requires custom report logic that the native report builder doesn't handle cleanly.

Custom metrics are brittle. HubSpot doesn't natively calculate things like net revenue retention, time-to-value, or customer health scores. Teams build these from custom properties and workflows, but they're hard to maintain, easy to misconfigure, and not auditable. When a metric feeds into a board presentation, you want to know exactly how it's calculated.

Visualizations hit a ceiling. HubSpot reports are tables and bar charts. Cohort grids, scatter plots, waterfall charts, and more advanced visualizations don't exist in the native report builder. If you want to show customer retention curves or LTV distributions, you're exporting and building elsewhere.

None of this is a criticism of HubSpot. It's a CRM and marketing automation platform, not a BI tool. But once your go-to-market motion depends on answering revenue questions, you need more than CRM-level reporting.

What a better HubSpot dashboard looks like

The goal isn't to replace HubSpot's pipeline and marketing views. You still need to see deal stage distribution and email performance. The goal is to add layers that connect CRM data to the business outcomes it should be explaining.

Here's what that looks like in practice:

Marketing ROI tied to actual revenue. Connect HubSpot with your billing data and you can see which campaigns generated paying customers, not just leads. This changes how you allocate budget: a campaign that drives 100 leads at 10% conversion to paid is worth more than one that drives 300 leads at 2%, even if HubSpot's lead-level reports rank them the other way.

Full customer lifecycle in one view. Connect HubSpot CRM data to your product usage and billing system, and you can see the complete picture: lead source, sales motion, deal terms, product activation, feature adoption, expansion, and renewal. Each transition tells you something about what actually works.

Reliable custom metrics. Instead of fragile HubSpot workflows for NRR or customer health scores, compute them in a query layer that joins billing, product, and CRM data with full transparency. You can audit the logic, change definitions, and see what every number is made of.

Rep-level revenue attribution. HubSpot shows rep activity and pipeline. Connect billing data and you can see actual revenue closed per rep, average contract value, and expansion revenue on their accounts. Performance conversations get grounded in outcomes, not just activity.

Churn analysis with root causes. Connect HubSpot deal data (lead source, sales motion, contract terms) with product usage data and churn events from billing, and you can start identifying which types of customers churn fastest. That's a closed loop back into marketing and sales strategy, and it's not something HubSpot can build on its own.

Three ways to build a more complete HubSpot dashboard

Here's a quick comparison of how they stack up:

Spreadsheet exports Data warehouse + BI Fabi
Setup time Hours per analysis 4–8 weeks Minutes
Data freshness Stale on export Live (with pipelines) Live
SQL required No Yes Optional
Cross-source analysis Manual Yes Yes
Shareable dashboards No Yes Yes
Estimated cost Low High Low

Option 1: Spreadsheet exports

Export contacts, deals, and company data from HubSpot. Export revenue and subscription data from your billing tool. Match records by email or company, and build pivot tables in Google Sheets. Fine for a one-time analysis, not sustainable: data goes stale, matching is manual and error-prone, and the resulting spreadsheet becomes the personal project of whoever built it.

Option 2: Data warehouse + BI tool

Use a HubSpot connector (Fivetran, Airbyte) to sync CRM data into a warehouse alongside Stripe, product data, and other sources. Query with dbt, visualize in Looker or Metabase. This is the right architecture for a mature data team, full flexibility and a durable single source of truth. The cost is 6-10 weeks of setup, a data engineer to own pipelines, and ongoing maintenance as HubSpot's schema evolves. Most growing teams under 150 people don't have that bandwidth.

Option 3: Connect directly with an AI-native analytics platform

This is the approach we built Fabi around.

Connect HubSpot to Fabi alongside your billing system, product database, or other sources, and start querying across all of them without building any pipelines.

"Show me email campaigns from last quarter ranked by downstream revenue, not open rate."

"Which lead sources are converting to paid customers at the highest rate over the last 6 months?"

"Show me deal velocity by rep, joined with 12-month customer LTV from Stripe."

The SQL is generated and auditable. Setup takes minutes. Shared dashboards stay live against current data, so the analysis doesn't disappear after the quarterly review.

It also solves the ad hoc problem. When your VP of Marketing asks "which content pieces are actually influencing revenue, not just driving traffic?", anyone on the team can open Fabi and get the answer without filing a data request or waiting for an analyst.

What to look for in a HubSpot analytics tool

If you're evaluating options, a few things that separate useful tools from ones that collect dust:

Native HubSpot integration. Look for direct API access to HubSpot objects, contacts, companies, deals, engagements, not just CSV exports. Exports go stale and require manual refresh.

Billing and product data connectors. HubSpot data alone answers CRM questions. To answer revenue and retention questions, the tool needs to join HubSpot data with Stripe (or your billing system) and product usage. If it only connects to HubSpot, it's still a HubSpot tool.

Transparent metric definitions. Any tool that shows you "CAC" or "LTV" should show you how it calculated that number. Black-box metrics are dangerous when they feed into hiring or budget decisions.

Self-service for non-SQL users. Your marketing director or VP of Sales will ask questions in plain English, not SQL. The tool should support both.

Consistent, shareable output. Insights that live in one person's session aren't useful to the team. Look for dashboards that update automatically and can be shared across the org.

Frequently asked questions

Does HubSpot have a built-in reporting dashboard? Yes. HubSpot includes pipeline reports, email performance metrics, deal stage analytics, contact activity, and a custom report builder. Depth varies by plan, Enterprise tiers include multi-touch attribution and more advanced cross-object reporting.

Can HubSpot track revenue from marketing campaigns? Partially. HubSpot can attribute deals to campaigns using its attribution models, but it can only see revenue as defined within HubSpot. It has no visibility into actual billing data from Stripe or other payment processors unless you manually sync that data in.

How do I connect HubSpot to Stripe? HubSpot has a native Stripe integration that syncs payment and invoice data into HubSpot contacts and deals. This helps with operational visibility but isn't designed for cross-source analytics. For flexible reporting that joins HubSpot CRM data with Stripe billing, you need a separate analytics layer.

What are HubSpot's main reporting limitations? HubSpot's reporting can't see data outside HubSpot, no product usage data, no billing data unless synced, and no cross-source cohort analysis. Custom metrics built from workflows and custom properties are brittle. Advanced visualizations like cohort grids or scatter plots aren't available natively. For more on the CRM analytics gap, see CRM analytics beyond your CRM.

Can HubSpot calculate customer LTV? Not natively. HubSpot doesn't have a built-in LTV calculation. Teams typically approximate it with custom properties calculated from deal data, but this doesn't account for expansion revenue, contraction, or churn over time. Real LTV requires joining billing data with CRM data.

What is the best analytics tool for HubSpot data? It depends on team size and technical resources. A data warehouse plus Looker or Metabase is the most flexible option. For teams that want to query HubSpot alongside Stripe and other sources without building pipelines, AI-native platforms like Fabi are a faster path.

HubSpot is a great CRM. It's not a revenue analytics platform.

The data in HubSpot is valuable. But it's one part of your customer picture. The questions that drive GTM strategy, which channels generate your best customers, which sales motions produce the highest retention, what your real marketing ROI is, require connecting CRM data to billing, product, and other systems.

The gap between "which campaign had the best open rate?" and "which campaign generated the most paying customers?" is where most marketing teams are stuck. The data to answer it exists. It's just spread across HubSpot, your billing system, and your product.

You don't need a warehouse project to connect it. Connect your data sources, ask the questions HubSpot's dashboard can't answer, and build the revenue analytics view your team actually needs.

Try Fabi free and connect HubSpot alongside your billing and product data to start querying across everything in minutes.

Try Fabi.ai today

Start building dashboards and workflows in minutes

Start building an internal tool or customer portal in under 10 minutes

Sign up for free
Get a demo
No credit card required
Cancel anytime
RisingWave
ClickHouse
Airtable
Google Slides
MySQL
PostgreSQL
Gmail
BigQuery
Amazon Redshift
Googles Sheets
Slack
GitHub
dbt Labs
MotherDuck
Snowflake
ClickHouse
Databricks
Bitbucket
Microsoft Teams
Related reads
Subscribe to Fabi updates