Chapter 9: CRM reporting for decision makers

Part of the Small B2B CRM Setup Handbook.
This chapter explains how to use CRM reporting to make decisions, not to create dashboards that nobody trusts or uses.

← Back to the handbook overview

Reports should answer questions, not display data

For a founder or sales manager, CRM reporting exists to answer two questions:

• Can we hit our number?
• Where are we stuck?

If a report does not clearly answer one of these questions, it is noise.

Complex dashboards with dozens of metrics create the illusion of control while hiding the real problems. Simple, focused reports drive action.

The most common mistake

The most common mistake is reporting on activity instead of outcomes.

Reports such as “number of calls made” or “emails sent” encourage busywork. They reward motion, not progress. Outcome based reports force honest conversations about pipeline health and deal quality.

The three reports every small B2B team needs

1. The forecast report

This report shows all open deals, grouped by pipeline stage, with a weighted amount calculated as:

Deal amount × probability

This answers the question: Can we hit our number?

If your forecast is consistently wrong, the problem is not the report. It is your pipeline design or your deal discipline.

2. The bottleneck report

This report shows the average time deals spend in each pipeline stage.

This answers the question: Where are we stuck?

If deals spend ninety days in “Proposal Under Review,” you do not have a sales performance problem. You have a process problem.

3. The health report

This report shows deals with no logged activity in the last seven days.

This answers the question: Are we dropping the ball?

A deal without recent activity is a deal that is quietly dying.

HubSpot guidance

HubSpot’s reporting tools are powerful, but restraint is essential.

• Dashboards: Create a single sales dashboard containing only the three reports above. Name it something explicit, such as “Weekly Sales Health.”
• Drill-down: Every report must allow managers to click into the underlying list of deals or contacts. The report highlights the problem. The list is where action happens.

What good reporting changes

When reporting is done correctly:

• Sales conversations become factual instead of emotional
• Forecast reviews focus on deals, not excuses
• Process issues surface early, before revenue is lost

Actionable setup

Set up a recurring weekly email using HubSpot’s dashboard sharing feature.

Send the “Weekly Sales Health” dashboard to the founder and sales manager every Monday morning.

No commentary. No slides. Just the data.

If the same problems appear week after week, the CRM is doing its job. It is showing you what needs to be fixed.

Continue reading the handbook:

← Previous: Chapter 8 – Lead sources, attribution, and reporting basics
Next: Chapter 10 – Integrations without breaking the CRM →