Your HubSpot Is Full of Answers. Nobody's Asking the Questions

Your HubSpot is full of answers. Here's how to build the four dashboards that start asking the right questions. 

TL;DR: Most MSPs who use HubSpot are using about 10% of what it can actually show them. The default dashboards tell you how many contacts you have and how many deals are open. That's not marketing intelligence, that's a headcount. The reports that tell you whether marketing is working, which channels produced clients, what it costs to get them, and whether the pipeline is on track, are all in there. They just haven't been built yet. This post is about building them.  

Most people have the same relationship with their dentist. They know they should go twice a year. They go once, maybe, when something starts to hurt. They get the cleaning, nod at everything the hygienist says, and leave with a bag of floss they'll use exactly twice. Nothing is technically wrong. Nothing is getting better either.

Most MSP owners have that exact relationship with HubSpot reporting. They log in when something feels off. They glance at the contacts count, check the pipeline total, and close the tab feeling like they've done something. They haven't. The default dashboards in HubSpot are the dental cleaning of marketing intelligence: technically a step in the right direction, but completely insufficient for actually knowing what's going on.

Here's what makes that a real problem. The MSP market is more competitive than it's ever been, and the owners pulling ahead aren't doing it on instinct. They're doing it because they can answer a specific set of questions: where did our last ten clients come from, what did it cost to get them, and is our pipeline on track for the quarter. Those answers are sitting in HubSpot right now for almost every MSP reading this. They're just buried under dashboards that were never set up to surface them.

HubSpot isn't just a contact database. When it's configured correctly, it's the closest thing an MSP has to a real-time read on whether marketing is doing its job. Four dashboards is all it takes to get there. This post is about building them.

Table of Contents

1. Why Default HubSpot Dashboards Don't Work for MSPs
2. Dashboard 1: Marketing Performance Overview
3. Dashboard 2: Lead Source and Pipeline Attribution
4. Dashboard 3: Sales Pipeline Health
5. Dashboard 4: Revenue and MRR Tracking
6. The Part That Makes Everything Else Work
7. HubSpot Has the Data. Start Using It
8. Key Takeaways
9. Frequently Asked Questions

Why Default HubSpot Dashboards Don't Work for MSPs

HubSpot's default dashboards were built for a generic B2B sales team, not an MSP. They tell you how many contacts are in the system, how many deals are open, and how much revenue closed this month. That's useful for a Tuesday morning standup. It's useless for answering whether marketing is actually working.

The questions MSP owners actually need answered look different. Which channel produced the clients who stayed and paid? How long does it take from first contact to signed agreement, and does that change depending on where the lead came from? Is the pipeline healthy enough to hit the revenue goal this quarter, or does it just look healthy because nobody's looked closely? Default HubSpot answers none of those questions because it wasn't configured to. The data exists. The reports don't.

The gap is almost always the same across MSPs who haven't customized their setup. Lead sources aren't tagged at the point of contact, so there's no way to trace a client back to the channel that produced them. Deal stages don't reflect the actual MSP sales process, so pipeline reports show a number that means nothing. And there's no view connecting a marketing activity to a closed deal, which means the marketing budget gets defended by gut feel instead of evidence. The four dashboards in this post fix all of that.

Dashboard 1: Marketing Performance Overview

This is the one you open on Monday morning before you do anything else. It shouldn't take more than two minutes to read and it should tell you immediately whether last week was moving in the right direction or not. If you have to dig around to find the answer, the dashboard isn't built right yet.

Four reports belong here. First, new contacts by source, this month versus last month, broken out by channel: organic search, paid search, referral, direct, email, social. Not a combined total. If referrals spiked and organic dropped, that's a signal worth understanding before you make any spending decisions.

Second, form submissions by page. Which pages on your website are actually generating contact requests? If your contact page is producing ten times more submissions than your pricing page, that tells you something important about where prospects are landing and what they're ready to do when they get there.

Third, email performance, but not just open rate. Which emails generated form submissions or deal creation? An email with a 45% open rate that produces zero deals is less useful than one with a 25% open rate that starts three conversations. Open rate is vanity. Pipeline contribution is the point.

Fourth, session-to-contact conversion rate. What percentage of website visitors are turning into named contacts? For most MSPs, this number sits under 2%, and moving it even slightly is one of the highest-leverage improvements available without spending another dollar on traffic.

Dashboard 2: Lead Source and Pipeline Attribution

This is the dashboard most MSPs don't have, and it's the one that matters most. Everything else in your marketing program is a guess until you can answer this question cleanly: which channels are actually producing clients, not just leads?

Four reports do the work here. Deals created by original lead source, meaning the channel where the contact first entered your database, not the last thing they clicked before the deal was created. That distinction matters more than most people realize. The last touch gets the credit. The original source did the work.

Deals closed and won by original lead source. This is where the patterns show up. Organic search might produce more leads than paid, but close at a lower rate. Referrals might produce fewer leads but close faster and at higher contract values. You can't see any of that without this report, which means you can't make a defensible argument for where the budget should go.

Average deal value by source. A lead from a LinkedIn post and a lead from an industry event are not the same lead. If one consistently closes at $2,500 MRR and the other at $4,500, that changes how you think about where to spend your time.

Time to close by source. Referrals that close in 30 days and organic leads that close in 90 days represent fundamentally different pipeline math. Knowing the difference shapes how you forecast and where you focus short-term versus long-term.

As we covered in Most MSPs Are Measuring Marketing Activity. Almost None of Them Are Measuring Results, attribution data is the foundation of every spending decision worth making. Without it, you're allocating budget on gut feel. With it, you're making an argument the numbers can back up.

Dashboard 3: Sales Pipeline Health

Marketing gets the lead into the pipeline. This dashboard tells you what happens after that. Most MSP owners check their pipeline total, see a number that looks okay, and move on. That number is almost always misleading without knowing what's actually moving and what's quietly dying.

Four reports matter here. Pipeline by stage, current quarter: how many deals are sitting in each stage right now and what's the combined value? If everything is stacked in "proposal sent" and nothing is moving to "negotiation," that's not a healthy pipeline. That's a graveyard with optimistic labels.

Deal velocity: how long are deals sitting in each stage before they either advance or disappear? If your average deal spends three weeks in "proposal sent" before going cold, that's a process problem no marketing budget can solve. The dashboard makes it visible. What you do with that information is a different conversation.

Deals at risk: HubSpot can surface deals that haven't had any activity in a set number of days. For most MSPs, 21 days of silence on an open deal means it's going cold. Seeing all of those in one place gives you a chance to intervene before they're gone, rather than discovering it at the end of the quarter when the pipeline number doesn't add up.

Win rate by source: which lead sources are actually closing, not just entering the pipeline? A channel that produces ten leads with a 10% close rate is worth less than one that produces four leads with a 50% close rate. This report makes that math visible and stops you from optimizing for volume when you should be optimizing for quality.

Dashboard 4: Revenue and MRR Tracking

This is the one that ties everything together. The previous three dashboards tell you what's happening in marketing and sales. This one tells you whether any of it is building the business.

New MRR by lead source: not total revenue, just the new monthly recurring revenue from clients who closed this month, broken out by where they came from. This is the number that connects marketing activity to actual growth. If paid search produced two clients this month at $3,000 MRR each, that's a $6,000 contribution you can measure against what you spent.

MRR trend over a rolling 12 months. Is the business growing, flat, or quietly declining? And is the growth rate accelerating or starting to plateau? Everything else in these dashboards feeds into this number. It's the scoreboard.

Client acquisition cost by channel: total spend on a channel divided by clients acquired from it in the same period. This is the calculation that either justifies a channel or ends the argument for keeping it. Simple math, uncomfortable answers, worth running every quarter.

Churn and expansion MRR. New clients are only half the revenue picture. What are you losing to clients who left? What are you gaining from existing clients adding services? HubSpot tracks both if the pipeline is set up correctly, and ignoring either number gives you an incomplete read on whether the business is actually getting healthier.

The Part That Makes Everything Else Work

All four dashboards are only as good as the data going into them. And the most common reason HubSpot reporting doesn't work for MSPs isn't a configuration problem. It's a data problem. Lead sources aren't being tagged at contact creation. Deal stages aren't being updated when things move. Contacts get added to the system without anyone capturing where they came from. Garbage in, garbage out. Doesn't matter how good the dashboard looks.

Three rules that prevent most of the damage. Every new contact gets a lead source captured at the point of entry, not filled in later when someone remembers. Every deal gets updated when it moves stages, not at the end of the month during cleanup. And someone on the team owns CRM hygiene as an ongoing responsibility, not a quarterly panic before the board meeting.

The other half of making this work is the habit. A dashboard nobody checks is decoration. Fifteen minutes, same time, same day, every week. Not an analysis session, just a scan: did lead volume move, is pipeline health trending the right direction, did anything stall that needs attention? The owners who catch problems early are almost always the ones who built a simple review into their weekly schedule and actually kept it.

HubSpot Has the Data. Start Using It

Four dashboards. That's the whole ask. One for marketing performance, one for lead source attribution, one for pipeline health, and one for revenue and MRR. Built once, checked weekly, they answer the questions most MSP owners are currently answering with gut feel and optimism. That's not a criticism. It's just a more expensive way to run a business than it needs to be.

Most MSP owners aren't avoiding this because it's hard. They're avoiding it because nobody ever showed them which reports to build or why those specific ones matter. The data has been sitting in HubSpot the whole time. It just needed someone to ask it the right questions.

Tactics builds HubSpot reporting setups for MSPs that are connected to real pipeline outcomes, not vanity metrics. If your HubSpot is full of data nobody's looking at, or your dashboards are showing you activity instead of intelligence, that's a fixable problem. It usually takes less time than most owners expect.

Get in touch with Tactics Marketing and let's turn your HubSpot into something that actually tells you what's happening. How known do you want to be? Get Findable.

Key Takeaways

• HubSpot's default dashboards show activity. The four dashboards in this post show intelligence: where leads come from, which channels produce clients, whether the pipeline is healthy, and whether marketing is building revenue.
• The lead source and pipeline attribution dashboard is the most important one to build first. Without clean lead source data connected to closed deals, every marketing budget decision is made on gut feel.
• Deal velocity and win rate by source tell you more about your sales process than your total pipeline value does. Stalled deals and low win rates from certain channels are signals, not noise.
• New MRR by lead source is the number that connects marketing activity to actual business growth. It's the answer to "Is marketing working?" that actually means something.
• Data hygiene is not optional. Every dashboard is only as reliable as the data going into it. Someone needs to own CRM hygiene as an ongoing responsibility, not a quarterly cleanup project.
• The weekly 15-minute review is what makes reporting useful. Build the dashboards, then build the habit.

Frequently Asked Questions

1. Do I need HubSpot Professional or Enterprise to build these dashboards?
Most of what's described here is available in HubSpot Professional. The lead source attribution reports and custom deal properties require at minimum a Professional subscription. HubSpot Starter is too limited for meaningful marketing reporting. If you're currently on Starter and finding the reporting frustrating, that's probably why.

2. How long does it take to set up these four dashboards?
If your HubSpot data is reasonably clean and your pipeline stages are already configured correctly, building all four dashboards takes four to six hours of focused setup time. If you need to clean up lead source data or restructure your pipeline stages first, budget a few additional days of cleanup before the dashboards will show you anything accurate.

3. What if my HubSpot data is a mess and I don't know where to start?
Start with the pipeline. Clean up your deal stages so they reflect your actual sales process, then make sure every open deal has an accurate stage and a lead source captured. That foundation makes every other report meaningful. Don't try to clean everything at once: prioritize deals first, contacts second, and historical data last. A clean pipeline view is worth more in the short term than perfect contact records going back three years.