Operating partners do not need more dashboards. They need the right dashboards that answer specific questions at predictable intervals. After building reporting infrastructure for 50+ PE-backed portfolio companies, we have distilled the reporting stack to the minimum viable set that gives an operating partner what they actually need.
This is not a guide to every HubSpot report you could build. It is a guide to the reports you should build — the ones that survive contact with reality and get used in actual board meetings and pipeline reviews.
The Three Reporting Layers
Effective PE portfolio reporting operates at three layers, each with a different audience, cadence, and level of detail.
Layer 1: The Investment Committee View
Audience: Operating partners, managing directors, investment committee members
Cadence: Monthly, with quarterly deep-dives
Core question this layer answers: Is this portfolio company on track to hit the value creation plan?
The four reports:
Report 1: Revenue vs. Plan
- Month-over-month revenue, plotted against the value creation plan forecast
- Variance analysis: where specifically the company is ahead or behind
- Trailing 12-month revenue trend
- Revenue by source (new business, expansion, renewal)
HubSpot implementation: Custom report using Deal closed-won amount with a close date filter, compared against a custom property storing the plan target. Display as a combo chart — bar for actual, line for plan.
Report 2: Pipeline Health
- Total pipeline value weighted by stage probability
- Pipeline coverage ratio (pipeline value / next quarter target)
- Net pipeline change (new deals created minus deals lost and closed-won)
- Stage-by-stage conversion rates vs. prior quarter
HubSpot implementation: Deal pipeline report filtered by create date and close date. Pipeline coverage requires a custom calculated property dividing total weighted pipeline by the quota custom property. The coverage ratio should be above 3x for the current quarter and above 2x for next quarter.
Report 3: Sales Efficiency
- Win rate (closed-won / total closed deals)
- Average deal cycle length (days from deal creation to close)
- Average deal size
- Revenue per sales rep
HubSpot implementation: Custom report using deal properties with filters for date range. Trend these quarterly to show improvement (or decline) over time. These metrics are what sophisticated acquirers evaluate during exit due diligence.
Report 4: Operational Maturity Score
- CRM adoption rate (monthly active users / total licensed users)
- Data quality score (critical field completion rate)
- Forecast accuracy (predicted close amount vs. actual, 90-day lookback)
- Process compliance (percentage of deals following defined stage progression)
HubSpot implementation: This requires a combination of usage analytics (available in HubSpot's Activity Feed and User Management) and custom reports on data completeness. We build a composite dashboard that pulls these metrics into a single view with color-coded status indicators.
Layer 2: The Portco Leadership View
Audience: Portfolio company CEO, CRO/VP Sales, VP Marketing
Cadence: Weekly
Core question this layer answers: What is happening this week that needs attention?
The five reports:
Report 1: Weekly Pipeline Snapshot
- Deals expected to close this month, sorted by probability
- Deals that moved forward or backward this week
- New deals created this week
- Deals past their expected close date (the "stale" list)
Report 2: Activity Volume
- Total calls, emails, and meetings by rep (this week vs. trailing 4-week average)
- Reps below activity threshold (the early warning indicator)
- Lead response time (median time from lead assignment to first outreach)
Report 3: Marketing Performance
- New leads generated this week by source
- MQL to SQL conversion (trailing 30 days)
- Content engagement metrics (form submissions, email opens/clicks)
- Paid campaign spend vs. lead generation
Report 4: Customer Health
- Open support tickets by priority
- NPS or CSAT trend (if tracked)
- Renewal pipeline (deals expiring in next 90 days)
- Expansion revenue opportunities
Report 5: Forecast Update
- Current month forecast (commit vs. best case vs. upside)
- Next month forecast
- Quarter-to-date attainment vs. target
- Changes from last week's forecast with explanations
Layer 3: The Rep Productivity View
Audience: Individual sales reps and their managers
Cadence: Daily (self-service)
Core question this layer answers: Am I on track to hit my number this month?
The three reports:
Report 1: My Deals
- Active deals sorted by close date
- Next activity scheduled for each deal
- Days since last activity on each deal (highlight any above 7 days)
- Deals at risk (past expected close date, no activity in 14+ days)
Report 2: My Activity Dashboard
- Calls, emails, meetings logged today/this week
- Activity vs. personal target
- Meetings booked this week
- Upcoming tasks and reminders
Report 3: My Leads
- Assigned leads awaiting first contact
- Lead age (time since assignment)
- Lead source and score (if applicable)
- Follow-up tasks due today
Building the Cross-Portfolio Roll-Up
For PE firms with multiple portfolio companies on standardized HubSpot implementations, the cross-portfolio roll-up is where reporting produces its highest-value output.
The portfolio dashboard includes:
- Revenue attainment by portco (bar chart, color-coded by variance from plan)
- Pipeline coverage by portco
- Win rate comparison across portcos
- Sales efficiency metrics side by side
- Operational maturity scores across the portfolio
- Quarter-over-quarter trend for each metric
Implementation approach:
HubSpot does not natively support cross-instance reporting. There are three approaches:
Approach 1: API aggregation. Pull data from each HubSpot instance via API into a centralized dashboard tool (Databox, Klipfolio, or a custom build). This is the most common approach and works well for 3-10 portcos. Cost: $5,000-15,000 for initial setup plus $200-500/month for the dashboard tool.
Approach 2: HubSpot Business Units. If all portcos operate within a single HubSpot Enterprise account using Business Units, cross-portfolio reporting is native. This works well when portcos share similar business models. Cost: included in Enterprise licensing, but requires careful configuration to maintain data separation.
Approach 3: Manual compilation. Export standard reports from each portco monthly and compile in a spreadsheet or slide deck. This works for 2-3 portcos but does not scale. The primary risk is inconsistency — if the person compiling the report changes the methodology, historical comparisons break.
We recommend Approach 1 for most PE portfolios. It balances automation with flexibility and scales to 10+ portcos without significant additional cost.
The Reporting Cadence
Reporting is only useful if it is consumed at the right cadence by the right audience. Too frequent and it becomes noise. Too infrequent and it loses relevance.
Recommended cadence:
| Report | Audience | Cadence | Delivery |
|---|---|---|---|
| Investment Committee Dashboard | Operating partners | Monthly | Automated email with dashboard link |
| Portfolio Roll-Up | Operating partners | Quarterly | Slide deck for IC meeting |
| Portco Weekly Snapshot | CEO, CRO, VP Marketing | Weekly (Monday AM) | Automated email |
| Pipeline Review | Sales managers, reps | Weekly (Monday) | Live meeting from HubSpot |
| Rep Productivity | Individual reps | Daily (self-serve) | HubSpot dashboard |
| Data Quality Monitor | RevOps/Admin | Weekly | Automated alert for threshold breaches |
The critical rule: Every report must have a defined owner who is responsible for ensuring it is accurate, delivered on time, and acted upon. Reports without owners decay within 90 days.
What to Stop Reporting
Most portfolio companies have too many reports, not too few. When we audit HubSpot reporting, we typically find 30-50 custom reports, of which 5-8 are actively used. The rest are zombie reports — created for a one-time request and never archived.
Reports to eliminate:
- Anything not viewed in the past 60 days
- Duplicate reports measuring the same metric with different filters
- Reports that require manual data manipulation after export
- "Vanity metrics" that do not inform decisions (raw website traffic, total email sends, social media followers)
- Reports that measure activity without connecting it to outcomes
Clean the reporting environment quarterly. Fewer, better reports produce more signal than a cluttered dashboard that nobody scrolls past the first chart.
Getting Started
If your portfolio company's HubSpot instance cannot currently produce the Layer 1 reports described above, the reporting infrastructure needs work. Start with our Portfolio Health Score to assess the current state, then review our evaluation framework to understand the specific gaps.
For a portfolio-wide reporting standardization engagement, see our Cross-Portfolio Standardization offering.
Related reading: