
Short answer: HubSpot reports almost never break because of the report. They break because of what’s underneath: source fields left blank or filled in by hand, no agreed definitions, duplicate or wrongly merged records, unclear deal ownership, a deal amount that means something different to sales and finance, and attribution that was never set up. Fix the data and the definitions first, then rebuild a small set of reports everyone agrees to trust. Building more dashboards on bad data just gives you more numbers to argue about.
“Wrong data at the wrong time at the wrong place.” That’s how the HubSpot owner at a compliance firm described their reporting to us. They had around 50 dashboards and nearly 1,000 reports, because for years everyone had been allowed to build their own. Nobody could agree which properties were the real ones, so nobody trusted any of it.
That’s an extreme version, but the pattern is everywhere. Here are the real causes we find, taken from portals we’ve worked in this year, and the order we fix them in.
The nine causes we see most
1. Source fields that are blank or hand-picked
A marketing lead told us that over 50% of their contacts had no source filled in at all. The rest were picked by hand from a drop-down, and people chose broad catch-all options. Her words: she had “no confidence” in where leads came from.
Her previous partner had built dashboards the year before. She didn’t trust those either, because “the source data wasn’t addressed”.
Fix: automate source capture (forms, UTMs, integrations), lock down manual source fields, and backfill what you can.
2. Tracking that measures the wrong thing
An events business saw huge conversion numbers in their ad platform but only “a couple” of form submissions in HubSpot. The cause: the ad conversion was set to a page view of the exhibitor page, not a form submission. It had been copied forward from previous years and nobody had checked.
Fix: audit every conversion event against what it should actually count.
3. AI and “dark” traffic landing in Direct
Buyers who find you through ChatGPT or Perplexity often copy a name into Google or type the URL. That visit shows up as Direct or as an unknown source. One marketing lead’s channel reports were being pushed into “offline” and “direct” while their AI visibility was clearly growing.
Fix: you won’t get perfect first-touch data for this. Add a “how did you hear about us” field to key forms, and track AI referrals where the referrer does come through.
4. No agreed definitions
What’s a lead? An MQL? A qualified opportunity? A won deal? If sales, marketing and finance each answer differently, every report is right by one definition and wrong by another.
A medical recruiting business we’re working with counts a qualified lead only when the person is a US-qualified radiologist. HubSpot’s raw lead counts look healthy. The real number, after the recruiters reject the ones who don’t qualify, is a different story. Until that rule lives in HubSpot, every lead report overstates performance.
Fix: write the definitions down, get sales, marketing and finance to agree them, and then build them into lifecycle stages and properties. More in one version of revenue truth.
5. Duplicates and bad merges
An IoT company’s event report showed around 80 companies. The underlying data had about 300. Duplicate company records (different spellings, extra spaces, country suffixes, separate offices) were splitting the activity, and some reps had tagged the company instead of the contact, or entered the wrong year.
The compliance firm had a worse version: companies wrongly merged together, so contacts and deals sat under the wrong business and flowed downstream into their finance and project systems.
Fix: de-duplicate, fix associations, and set rules for how new companies get created.
6. Unclear deal ownership
If people can’t own records in the system that creates them, reports have to guess. At the compliance firm, account executives couldn’t own opportunities in their old system, so “how many deals does she have?” had two different answers depending on which field you trusted.
Fix: one owner per deal, set automatically where possible, with handoffs that update ownership and keep a record of who sourced it.
7. Revenue means different things to sales and finance
This is the one that makes CFOs stop trusting HubSpot. At the compliance firm, the deal Amount was total contract value. But a $100,000 deal might be two $50,000 projects across two years, and finance allocated revenue by project start date, not by deal close. So HubSpot’s revenue report and finance’s numbers could never match, by design.
Fix: decide which number each report shows (contract value, first-year value, recognised revenue), use separate properties for each, and label reports clearly. Some of this belongs in finance’s system, not HubSpot.
8. Activity that never gets logged
Activity dashboards depend on emails, calls and meetings being logged. At several clients the Outlook connector “breaks all the time” and reps don’t notice it’s disconnected, so whole weeks of activity are missing. One business also had privacy rules that ruled out the usual auto-BCC workaround.
Fix: stabilise the connector, monitor it, and make logging automatic rather than relying on memory. See getting your team to use HubSpot.
9. Attribution that was never set up
A US healthcare business told us plainly: “we don’t have lead attribution set up in HubSpot.” Another had attribution fixed in one division but not the other, and had never configured an attribution model at all, so nobody knew whether to use first touch or multi-touch.
Fix: decide what question attribution needs to answer (usually “where should the next pound or dollar go?”), configure the model to answer that, and make sure deals have the right contacts associated, because attribution follows the contacts. Our guide to HubSpot attribution reporting covers which reports need which tier.
What HubSpot can’t tell you on its own
HubSpot can cover most of the revenue picture. It can’t, on its own, tell you what happened after a deal was marked won: was it invoiced, shipped, paid? That lives in your finance or operations systems. If leadership needs that, connect the systems rather than trying to recreate finance inside the CRM.
For one client we joined accounting, HubSpot and Google Workspace into a single finance dashboard. Monthly reporting went from a full day of spreadsheet work to zero. That’s our self-updating finance system case study.
The order we fix things in
- Definitions. Agree what each stage and number means. Write it down.
- Source capture. Automate it, lock the manual fields, backfill.
- Records. De-duplicate, fix associations and ownership.
- Tracking. Check every conversion event and integration.
- Attribution. Configure a model that answers a real question.
- A few trusted reports. Built around the actual leadership meeting agenda.
- Governance. Limit who can create shared reports, and archive the rest.
Notice reports come sixth. Another client had a “boatload” of reports from a previous partner and the users said “this isn’t helpful to me. I don’t know what to do.” We cut them right back to the essentials for each role: wins this month, pipeline and forecast, activity, and “what should I do next?”.
How long does it take?
Our HubSpot audit takes about two weeks and shows you exactly which of these causes apply to your portal. From there, quick wins usually land in the first 30 days and structural fixes over 60 to 90 days.
Frequently asked questions
Why don’t my HubSpot reports match? Usually because of the data underneath: blank or manual source fields, no agreed definitions, duplicate records, unclear ownership, and a deal amount that means different things to sales and finance.
Why is so much HubSpot traffic showing as Direct? Untagged links, broken tracking and AI assistant referrals often land as Direct or unknown. Visitors who find you in ChatGPT and then type your name into Google are a common cause.
Why don’t HubSpot revenue reports match finance? Deal amounts are often total contract value, while finance recognises revenue over time or by project. Use separate properties for contract value and recognised revenue, and label reports clearly.
How do we fix HubSpot attribution? Decide what question attribution must answer, configure a model for it, automate source capture, and make sure deals have the right contacts associated.
Should we build more dashboards? Not until the data and definitions are fixed. A few trusted reports beat dozens nobody believes.
How long does it take to fix HubSpot reporting? An audit takes about two weeks. Quick wins usually land in 30 days and structural fixes over 60 to 90 days.
Next: one version of revenue truth, HubSpot attribution reporting, or how a HubSpot rescue works.


