HubSpot Report and Dashboard Plan Template

How do you plan HubSpot reporting with the template?

Start with the KPI list: one row per number your team will act on, with its definition in plain words, an owner and the decision it supports. Then write a spec for each report that answers a KPI, group the reports into dashboards by audience, add goals, and only then build anything in HubSpot.

A report nobody acts on is noise on a dashboard. If a KPI has no owner and no decision attached, leave it off until it does. For ideas on which reports suit reps, managers and leadership, see our HubSpot sales dashboard examples.

How do you write a KPI definition your team agrees on?

Write it in words a manager can check against records: which object it counts, which date property decides the period, which records are in or out, and how it is calculated. Then name one owner and the decision it supports. The template's examples are illustrative; your team writes the definitions and sets any targets.

• Name the object and date: "deals created" and "deals closed won" count the same object against different dates, and give different totals for the same month.
• Say what is excluded: renewals, test records or a second pipeline. A definition that leaves this out gets argued about in every meeting.
• One owner per KPI: the person who answers when the number looks wrong, and who approves changes to the definition.

What should a HubSpot report spec record?

The question the report answers, the KPI it serves, the report type, primary and secondary data sources, how they join, the fields and their aggregation, filters, the date range, the breakdown, the chart type and who needs it. Writing this first catches the join or filter that would count the wrong records.

• Primary source first: it decides what the report counts. A custom report can use up to five data sources, and connective sources HubSpot adds to join two objects count toward the five.
• Double counting: filtering on a secondary object's field can count a record once per association. Spec the filter on the primary object where you can, or use Distinct count.
• Filters and breakdowns: you filter by date or dimension, not by an aggregated measure. Keep Break down by well under 100 values, or the report won't load on a dashboard.
• Plan check: when we checked HubSpot's documentation in October 2026, the custom report builder needed a Professional or Enterprise subscription. If one object answers the question, a single object report is simpler and queries the live CRM.

Our HubSpot custom report builder guide covers data sources, fields, chart limits and refresh timing in more depth.

How do you plan a HubSpot dashboard?

Give each dashboard one audience and one purpose, list the reports on it, then record its quick filters, access setting, owner and any scheduled email. When we checked HubSpot's documentation in October 2026, dashboards were on all plans, and access for specific users and teams needed Enterprise. Decide access before you add reports.

• Filters touch some reports: a dashboard filter only changes reports that use the data source its property belongs to. You can pin up to five quick filters, and each viewer's filters apply to their own view.
• Access controls the reports: reports on a dashboard follow the dashboard's access settings, and data permissions still apply, so a user may see partial data or a blank report.
• Scheduled emails: recurring emails go daily, weekly or monthly to HubSpot users only, and show data based on the permissions of the user who set them up. The plan records who sets up each one.

Our HubSpot dashboards guide covers creating, filtering, permissions and sharing step by step.

How do goals fit into the dashboard plan?

Record each goal you track: the HubSpot goal template, the KPI it measures, the period, contributors and assignees, and the dashboard that shows it. When we checked in October 2026, goals needed Marketing Hub, Sales Hub or Service Hub Professional or Enterprise; Sales Hub Starter only had the Revenue measure. Targets stay blank for your team.

• Duration is locked: HubSpot doesn't let you change a goal's duration after you create it, so the template asks for it up front. Clone a goal to change it.
• Contributors: individual users, team goals only, or teams with individual user targets. A user's target applies to one team only.
• Forecast: a revenue goal only appears in the forecast if it is set up for forecasting, with a duration that matches your forecast period.

Our HubSpot goals guide covers templates, custom goals, permissions and goal reports.

How do you run the monthly reporting review?

Once a month, spot-check a few rows of each key report against the records, check the properties your reports depend on for empty values, confirm scheduled emails still go to the right people, retire reports nobody uses, and check goals for the next period. Enter records checked and missing to calculate fill rate, and log every change.

Fields with no value aren't counted in report aggregations, so an empty property quietly lowers a total. The data quality tab lists each property a report depends on, who fills it in and how you keep it filled. More templates and guides are in our HubSpot resources.

Report and dashboard planning checklist