All articles
How-To7 min read

How to Audit Deal Attribution in HubSpot (Step-by-Step)

A practical step-by-step guide to auditing deal attribution in HubSpot. Find misattributed deals, check Original Source accuracy, and fix your pipeline data.

The average RevOps team spends 4+ hours per quarter manually auditing attribution in spreadsheets. The same audit takes 2 minutes with the right tool.

TL;DR

Export your last quarter's closed deals from HubSpot. For each deal, compare the Original Source field against the actual contact timeline (first marketing touch vs first sales touch). If more than 2-3 out of 20 deals are wrong, you have an attribution problem worth fixing.

An attribution audit answers one question: is my CRM telling the truth about where deals come from?If you are using HubSpot's Original Source field to report on pipeline, plan budgets, or evaluate channels, you need to verify that data is accurate. Here is a step-by-step process to audit your deal attribution.

Before you start: what you need

  • Admin or Sales access to your HubSpot portal
  • A list of recently closed deals (last 60-90 days is ideal)
  • 30-60 minutes for a manual audit of 20 deals, or 2 minutes to connect Attrfix and automate it

Not sure why this matters? Read why HubSpot attribution is wrong for context on how 10-20% of deals end up misattributed.

Step 1: Export your deals

Go to CRM > Deals in HubSpot. Filter to Closed Won deals from the last quarter. Export with these fields:

  • Deal Name
  • Amount
  • Close Date
  • Deal Owner
  • Associated Contact (primary)
  • Original Source
  • Original Source Drill-Down 1

If you are not sure what the Drill-Down fields mean, our Original Source Drill-Down explainer breaks down every value.

Step 2: Review contact timelines (the critical part)

For each deal, click through to the primary contact and review their timeline. You are looking for the chronological sequence of interactions:

  • Marketing touches: Email opens/clicks, ad clicks, form submissions, page views, content downloads
  • Sales touches: Logged calls, sent emails (from sales sequences or manual), meetings, LinkedIn messages

Write down the date of the first marketing touch and the first sales touch. This is the data point that determines whether the deal is truly inbound or outbound.

Step 3: Compare against Original Source

Now compare what you found in the timeline against what HubSpot says:

  • Match: Original Source says “Organic Search” and the contact's first interaction was indeed a website visit from Google, before any sales outreach. Attribution is correct.
  • Conflict: Original Source says “Offline Sources” but the contact clicked a LinkedIn ad two weeks before the first sales call. This deal is misattributed. Marketing should get credit.
  • Conflict: Original Source says “Paid Search” but the contact was actually added by a sales rep who then ran a sequence. The ad click came after the sales outreach. Sales should get credit.

Step 4: Flag and quantify mismatches

For each misattributed deal, note:

  1. What HubSpot says (Original Source)
  2. What actually happened (based on timeline)
  3. The deal amount

Sum the pipeline value of misattributed deals. This is the dollar amount of pipeline that your team is making decisions about based on wrong data. In a typical B2B SaaS pipeline, this is 10-20% of total closed-won revenue.

Step 5: Fix the process going forward

A one-time audit is useful. An ongoing process is better. You have two options:

  • Manual: Schedule a quarterly audit. Assign someone on the RevOps team to review the last quarter's deals. This works for teams with fewer than 50 deals per quarter.
  • Automated: Use a tool like Attrfix to continuously monitor attribution accuracy. Attrfix connects to HubSpot, computes independent verdicts for every deal, and flags conflicts automatically. Setup takes 2 minutes. See how it compares in our attribution tools comparison.

What to do with the results

An attribution audit is only valuable if it changes decisions. Share the findings with:

  • Marketing leadership: If inbound deals are being miscredited as outbound, marketing may be underinvesting in channels that are working.
  • Sales leadership: If outbound deals are being miscredited as inbound, the sales team is not getting proper credit for their prospecting efforts.
  • Finance: Budget and headcount decisions based on misattributed pipeline are directionally wrong. The audit gives them accurate data.

The marketing vs sales attribution conflict is the most common outcome of this audit. Having data to settle it transforms pipeline reviews from opinion battles into productive conversations.

Frequently asked questions

How often should I audit HubSpot deal attribution?

At minimum, once per quarter before pipeline reviews or budget planning. Ideally, use an automated tool that flags attribution conflicts in real-time so you catch issues as deals progress, not after they close.

What percentage of deals typically have wrong attribution?

In B2B SaaS pipelines, 10-20% of deals have attribution that disagrees with the actual contact timeline. The most common issue is inbound deals being labeled as Offline Sources because the sales rep created the contact before HubSpot tracked the marketing interaction.

Can I audit attribution without a third-party tool?

Yes, but it is time-consuming. You need to manually review each deal's contact timeline, check Original Source against actual engagement data, and document discrepancies. For pipelines with more than 50 deals, an automated tool like Attrfix saves significant time.

See your attribution data in 2 minutes

Connect HubSpot, get verdicts on your first 10 deals for free. No credit card required.

Try Attrfix free