Reports &
Dashboards

Every HubSpot portal needs these 8 reports before any other custom reporting work. Together they cover the full revenue operation across Marketing, Sales, and Customer Success.

Building Report 01 — the Lifecycle Stage Funnel — step by step.

1. Choose report type — Select "Funnel" from the report type picker. Then "Contact funnel" for lifecycle stage analysis.
2. Add funnel stages — HubSpot populates with lifecycle stage options. Select: Subscriber, Lead, MQL, SQL, Opportunity, Customer. Arrange in funnel order.
3. Set date filter — Click "Add filter" → Contact Create Date → "is in the rolling 90 days." This keeps the report automatically current.
4. Optional: segment filter — Add "Original Source = Organic Search" to see the funnel specifically for organic contacts. Or leave unfiltered for the full picture.
5. Choose visualisation — Select "Funnel chart." The funnel view shows both count at each stage and conversion percentage between adjacent stages.
6. Preview the report — Click "Apply" to see a live preview with your real data. Check: do the numbers make sense? Is MQL count significantly lower than Lead count (expected)? If MQL count is 0, your MQL promotion workflow may not be running.
7. Name and save — "Lifecycle Stage Funnel — All Contacts — Rolling 90 Days." Click "Save" and add to your RevOps Operations dashboard.
8. Repeat the pattern — Every other essential report follows the same five-panel structure: source → filters → measure → dimension → visualisation. Once you've built one, the rest follow naturally.

A dashboard is not a collection of reports — it's a curated decision-making tool for a specific audience.

Dashboard design principles

• 👥
  One audience per dashboard. The Marketing dashboard should not include rep activity metrics. The Sales dashboard should not include email campaign click rates. Design for the person reading it every morning.
• 📊
  8–12 reports maximum. A 25-chart dashboard nobody reads is worse than a 6-chart dashboard everyone uses. Edit ruthlessly.
• 📅
  Consistent time periods across all reports. If reports on the same dashboard use different time periods, the numbers won't be comparable. Pick one default per dashboard (this quarter, rolling 90 days) and stick to it.
• 👑
  Lead with the headline number. The most important metric for that audience goes top-left. For Sales: weighted pipeline. For Marketing: MQL count. For CEO: revenue vs target.
• 🔄
  Use rolling date ranges, not fixed. "Last 30 days" stays current automatically. A fixed date range requires manual updating and goes stale.

Reports are only as accurate as the data that feeds them. Every report traces back to a configuration decision earlier in this curriculum.

How HubSpot credits marketing interactions for driving a conversion — three models, each telling a different story.

Day-by-day build plan

• Day 1
  Data quality audit. Pulled every essential property and checked coverage: 94% of contacts have Lifecycle Stage set (good), 61% of deals have Amount populated (not good), 0% of Closed Lost deals have a Closed Lost Reason (nothing). Fixed: enabled Amount required at Qualified stage, enabled Closed Lost Reason required at Closed Lost. Can't retroactively fix old data, but future data will be clean.
• Day 2
  Built date-stamp properties — MQL Date, SQL Date, Customer Date. Retroactively stamped Customer Date from deal close dates via import (had 2 years of deal history). This unlocked trend reporting.
• Day 3
  Built the 8 essential reports. Lifecycle funnel, pipeline forecast (discovered 43% of deals had $0 amount — found and fixed), closed lost reason (blank — noted for future quarters), lead source breakdown, rep activity, deal velocity.
• Day 4
  Built 3 dashboards — Executive (for QBR), Sales (for VP of Sales review), Marketing (for CMO). Each with 8 reports, rolling time periods, consistent formatting.
• Day 5
  Prepared QBR narrative. Lead source data showed 68% of customers came from Organic Search — the company had been investing heavily in paid social with near-zero revenue attribution. This single data point redirected $15k/month in ad spend before the QBR presentation even ended.

• 01 — Building reports before fixing data quality
  A lifecycle funnel report that shows 94% of contacts at Lead with 3 at MQL is not a broken report — it's a broken workflow. Fix the MQL promotion workflow first. Then the report becomes accurate. Never spend time formatting a report built on bad data.
• 02 — Reporting on current state instead of over time
  "How many MQLs do we have right now?" tells you nothing useful. "How many MQLs did we generate each month for the last 12 months?" reveals trends, seasonality, and growth trajectory. Always add a time dimension to operational metrics.
• 03 — Using fixed date ranges instead of rolling dates
  A report with a fixed date range (Jan 1 – Dec 31 2024) becomes stale the moment the period ends. Use rolling dates (Last 30 days, This quarter, Rolling 90 days) — they stay current automatically and never require updating.
• 04 — Too many reports on one dashboard
  A 25-chart dashboard that nobody reads is worse than a 6-chart dashboard everyone opens every morning. Limit dashboards to 8–12 reports. Every report on a dashboard must answer a question someone is genuinely asking.
• 05 — Pie charts for data with more than 4 categories
  A pie chart with 10 slices representing 10 Closed Lost Reasons is unreadable. Use a bar chart. Pie charts are appropriate for 2–4 proportional categories with meaningful size differences. Nothing else.
• 06 — Dashboards without named owners
  If nobody is responsible for a dashboard, nobody reads it. Every dashboard should have a named owner who reviews it on a defined cadence and is accountable for the business outcome it represents. Without ownership, dashboards become digital wallpaper.

• ❓
  Start with the question, not the report. Never open the report builder without knowing the exact business question. "I want a report on contacts" is not a question. "Which lead source generates the most revenue per customer?" is a question. Every configuration decision flows from the question.
• 🏷️
  Name reports like newspaper headlines. "Closed Lost Reason — Last 90 Days — By Rep" is better than "Deal Report 3." The name should tell you what question it answers, what time period it covers, and what breakdown it shows.
• 🔍
  Always audit the upstream data before trusting a report. Trace backward from the report to the properties it depends on. Verify each property is being set consistently — by a workflow, by a required field, or by a reliable process. A wrong number in a report is almost never a report problem.
• 👥
  Design dashboards for the reader, not for yourself. The best dashboard is the one the VP of Sales opens every morning without anyone explaining it to them. Test it: show it to them and see if they understand it in 30 seconds without narration.
• 📋
  Document every dashboard. Maintain a simple record: Dashboard name · Primary audience · Review cadence · Owner · Key questions it answers. This prevents dashboard sprawl and keeps the system purposeful over time.
• 🔄
  Build reporting into your workflow configurations. Every time you build a workflow that sets a property, ask: "Do I need to report on this later?" If yes, make sure the property it sets is the exact property the report will filter on. Plan reporting requirements before building automations.

Do this in your free HubSpot sandbox — approximately 60 minutes. This exercise builds the full reporting layer on top of everything you've configured in previous modules.

Part A — Build 3 essential reports (40 min)

1. Lifecycle Stage Funnel — Reports → Create report → Funnel → Contact funnel. Stages: Lead → MQL → SQL → Opportunity → Customer. Date filter: Create Date, rolling last 90 days. Save as "Lifecycle Stage Funnel — Rolling 90 Days."
2. Pipeline Forecast — Create report → Single object → Deals. Filters: Stage not Closed Won or Lost · Close Date this quarter. Measure: Sum of Amount. Breakdown: by Deal Stage. Visualisation: bar chart. Save as "Pipeline Forecast — This Quarter — By Stage."
3. Rep Activity — Create report → Single object → Calls. Filters: Call Date this week. Measure: Count of calls. Breakdown: by Activity Owner. Visualisation: bar chart. Save as "Call Activity — This Week — By Owner." Repeat for Emails and Meetings.

Part B — Build a Sales Dashboard (20 min)

1. Go to Reports → Dashboards → Create dashboard. Name it: "Sales Team Dashboard."
2. Add your 3 reports from Part A. Arrange: Pipeline Forecast top-left (most important for sales), Lifecycle Funnel top-right, Rep Activity bottom.
3. Set the dashboard to be shared with: "Anyone in my HubSpot account." This makes it visible to all users.
4. Pin it to your HubSpot home (click the pin icon in the dashboard header). Now it appears on your HubSpot home page every time you log in.
5. Look at the pipeline forecast report. Is the data what you expected? If Amount is showing as $0 for most deals — that's a data quality issue, not a report issue. Make a note: "Require Amount at Qualified stage."