HUBSPOT CUSTOM
REPORTING DASHBOARDS.

Most HubSpot portals have dashboards. Few have dashboards that anyone actually uses to make decisions. The gap between "we have reporting" and "our reporting drives strategy" is almost always a design problem, not a data problem.

HubSpot's reporting tools are more powerful than most teams realize. Custom report builder, calculated properties, multi-object datasets, and attribution reporting give you the raw materials to build dashboards that genuinely change how your team operates. Nexoro's reporting and analytics services help teams design these dashboards from the ground up. This guide shows you how.

Start With Dashboard Strategy, Not Reports

The most common mistake in dashboard design is starting with individual reports and assembling them into a dashboard after the fact. The result is a collection of charts that each answer a different question but don't tell a coherent story.

Define the Decision Each Dashboard Supports

Every dashboard should serve a specific audience making specific decisions. Before building anything, answer:

• Who looks at this dashboard? A VP of Sales and an SDR manager need different views.
• What decisions does it inform? Pipeline review, campaign optimization, resource allocation, and forecasting each require different metrics.
• How often is it reviewed? A daily activity dashboard needs different granularity than a monthly executive summary.

Limit Dashboards to 8-12 Reports

A dashboard with 25 reports is a data dump, not a decision tool. Constrain yourself to the metrics that directly inform the dashboard's purpose. If a report doesn't influence a decision, it doesn't belong on this dashboard — it might belong on a different one, or it might not need to exist at all.

Key Metrics by Department

Sales Dashboards

Sales dashboards should answer three questions every week: Where is the pipeline? How fast is it moving? Where are deals getting stuck?

Essential reports:

• Pipeline by stage — A funnel or bar chart showing deal count and value at each pipeline stage. This is the single most important sales report.
• Deal velocity — Average time deals spend in each stage. Long dwell times in specific stages reveal process bottlenecks that workflow automation can address.
• Close rate by source — Win rate segmented by lead source or original campaign. This connects marketing efforts to revenue outcomes.
• Activity volume by rep — Calls, emails, meetings, and tasks per rep per week. Not for micromanagement — for identifying reps who need support.
• Revenue forecast — Weighted pipeline value based on deal stage probability.
• Deals closing this month — A table of deals with expected close dates in the current month, sorted by amount.

Marketing Dashboards

Marketing dashboards should connect top-of-funnel activity to pipeline contribution. Vanity metrics — page views, social impressions — belong in a separate operational dashboard, not the one leadership reviews.

Essential reports:

• MQL to SQL conversion rate — The percentage of marketing-qualified leads that sales accepts. This is the most important alignment metric between marketing and sales.
• Lead source performance — New contacts and leads generated by channel. Track both volume and conversion rate.
• Campaign attribution — Revenue influenced by campaign, using HubSpot's multi-touch attribution models.
• Email performance trends — Open rate, click rate, and unsubscribe rate trended over time. Trends reveal signal.
• Landing page conversion rates — Conversion rate by landing page, sorted by traffic volume.
• Blog performance — Traffic, CTA clicks, and form submissions attributed to blog content.

Service Dashboards

Service dashboards should surface response times, resolution rates, and customer satisfaction — the metrics that predict retention.

Essential reports:

• Ticket volume by category — Where are support requests concentrating? Rising volume in a specific category signals a product or process issue.
• Average time to first response — The single strongest predictor of customer satisfaction in service interactions.
• Average time to close — Total resolution time, segmented by ticket category and priority.
• Customer satisfaction score — CSAT or NPS survey results trended over time.
• Tickets by owner — Workload distribution across the service team.

Building Custom Reports and Datasets

HubSpot's standard reports cover most common use cases, but custom reports are where dashboards become genuinely powerful.

Single-Object vs Cross-Object Reports

Single-object reports (contacts, deals, tickets) are straightforward. Cross-object reports — deals associated with contacts who came from a specific campaign, for example — require HubSpot's custom report builder available on Professional and Enterprise tiers.

Cross-object reports unlock the questions that actually matter: Which marketing campaigns generated the most closed-won revenue? What's the average deal size for contacts who engaged with a specific piece of content? How does ticket volume correlate with contract renewal rates?

Custom Datasets

For complex reporting that spans multiple objects with specific filtering and calculations, HubSpot's datasets feature (available on Enterprise) lets you build reusable data tables that custom reports pull from. Think of datasets as saved queries that standardize how your team defines metrics.

For example, a "Qualified Pipeline" dataset might include only deals in specific stages, owned by specific teams, with amounts above a minimum threshold. Any report built on that dataset inherits those filters, ensuring consistency across dashboards.

Calculated Properties

HubSpot's calculated properties let you create derived metrics without custom code. Common examples:

• Days since last activity — Identifies stale deals and disengaged contacts.
• Deal-to-close time — Calculate the number of days between deal creation and close date.
• Weighted deal value — Multiply deal amount by stage probability for more accurate forecasting.

Report Distribution and Access

Building a great dashboard means nothing if the right people don't see it at the right time.

Schedule Email Delivery

HubSpot lets you schedule dashboard email summaries — daily, weekly, or monthly — delivered to specific users or teams. Set up Monday morning delivery for the weekly sales dashboard and first-of-month delivery for the monthly marketing review.

Set Permission-Based Access

Not every dashboard should be visible to every user. Use HubSpot's dashboard permissions to control who can view, edit, and share each dashboard. Sales leadership sees pipeline dashboards. Marketing sees campaign dashboards. Executives see a consolidated view.

Create a Board-Level Executive Dashboard

If you report to a board or senior leadership team, build a dedicated executive dashboard with 6 to 8 high-level metrics: total pipeline value, revenue closed this month, new leads generated, customer churn rate, NPS score, and sales forecast. No detail — just outcomes.

Attribution Reporting

Attribution is the most underutilized reporting feature in HubSpot. Most teams track last-touch attribution by default, which credits the final interaction before a conversion. This systematically undervalues top-of-funnel activities like blog content and brand awareness campaigns.

Multi-Touch Attribution Models

HubSpot offers several attribution models on Marketing Hub Enterprise:

• First touch credits the first interaction.
• Last touch credits the final interaction before conversion.
• Linear distributes credit equally across all touchpoints.
• U-shaped weights first and last touch more heavily with remaining credit distributed across middle interactions.
• W-shaped emphasizes first touch, lead creation, and deal creation touchpoints.

No single model is "correct." The best practice is to review attribution through multiple models and look for consistent patterns. If a channel shows up as high-value across multiple models, you can be confident it's genuinely contributing. Pair attribution data with the automation techniques in our workflow best practices guide to act on what reporting reveals.

Case Study: Strata Digital's Dashboard Transformation

When Nexoro began working with Strata Digital, their HubSpot portal had three default dashboards that no one reviewed. Marketing reported on campaign metrics in spreadsheets. Sales tracked pipeline in a separate tool. Leadership had no unified view of performance.

We built 12 custom dashboards segmented by role and function: two for sales leadership, two for individual reps, three for marketing, two for service, and three executive-level views. Each dashboard was designed around specific weekly or monthly review meetings.

The result was real-time pipeline visibility for the first time in the company's history. Sales reviews that previously required 2 hours of spreadsheet preparation now started with a live dashboard that everyone could see. Marketing could trace campaign spend to closed revenue using multi-touch attribution. Leadership got a single-page executive view that replaced a 15-slide monthly report.