[object Object]

A leadership review opens with three dashboards from three teams showing three different revenue numbers, all sourced from HubSpot. The math is right; the filters are not the same. Reports and dashboards in HubSpot are powerful enough to mislead when ungoverned and useful enough to drive the business when they are not. Tier choice and naming discipline carry most of the weight.

Custom report builder

The report builder is HubSpot’s primary analytics surface. Pick objects, drag in properties, set filters, pick a visualization. Professional tier unlocks custom reports; Enterprise unlocks more cross-object joins and additional metrics. A typical multi-object report:

Object 1: Deal
Join: Deal > Primary contact > Lifecycle stage
Filter: Pipeline = New Business
Group by: Lifecycle stage at deal create
Metric: Sum of amount, weighted by stage probability
Visualization: stacked bar by month

Save reports to a “source of truth” dashboard so derived versions are recognizable from the canonical one.

Calculated properties

Derived values that update on demand: days since last activity, deal age, total account revenue. Enterprise tier. Useful when reports need a value that does not exist as a stored property:

Property: account_lifetime_value
Type: Number
Formula: SUM(Deal.amount WHERE Deal.stage = "Closed Won")
Object: Company

Use them sparingly — every calculated property is recomputed when read, and complex formulas slow report renders.

Dashboards by audience, not by department

A rep dashboard shows their pipeline, their tasks, their conversion funnel. A manager dashboard shows team rollups and forecast accuracy. An exec dashboard shows board-level metrics. Mixing audiences on one dashboard makes it useful to no one:

Rep dashboard:
  - My open deals (sorted by close date)
  - My tasks today
  - My sequences in progress

Manager dashboard:
  - Team forecast vs commit
  - Stuck deals by rep
  - Rep activity counts week over week

Exec dashboard:
  - Pipeline coverage
  - Win rate by segment
  - Booking trend YTD

Funnel reports for conversion analysis

Funnel reports measure stage-to-stage conversion. Build one per pipeline. The diagnostic power is in drop-off rates — a 70 percent stage-1-to-2 conversion with a 12 percent stage-2-to-3 says the second exit criterion is too steep or the wrong audience is reaching it.

Funnel: New business pipeline
  Lead         100%
  Qualified     54%
  Discovery     38%
  Proposal      18%
  Closed Won     6%

Tier reality and where reporting hits a wall

Starter reports are limited to standard reports. Professional unlocks the custom report builder and most dimensions ops teams need. Enterprise adds calculated properties, cross-object joins for less common pairs, and the data model to power forecasting. If your top three monthly questions cannot be answered without a tier upgrade, the upgrade math is usually clear.

Naming and ownership

Every report needs an owner field populated and a name prefix that signals scope:

SOT_  - source of truth, do not edit
EXP_  - exploratory, may change
TEAM_ - owned by named team
PERS_ - personal, not for sharing

Without naming discipline, dashboards accumulate dozens of similar-looking reports that disagree.

What to do this week

Pick three reports your leadership team uses weekly, mark them SOT, document filters in the description, and clone any conflicting versions into EXP before the next review.

[object Object]
Share