Work / Attribution

Builder Funnel · 2026

This partner was worth 13x more than what the dashboard said.

Our CRM credited a software referral partner with 3 closed clients. The tracking links were newer than the partnership, so I went looking in the sales call notes.

AttributionMarketing opsHubSpot APIClaude Code
311clients won through the partner. Tracking found 3, the call notes found 8 more.
$132Kwon revenue, out of $1.27M in pipeline across 86 deals since 2023
58%of the partner's pipeline value never showed up in a source report

TL;DR

  • Source fields only know what someone clicked. Prospects were telling our reps about the partner on calls, and the reps typed it into notes the reports never read.
  • I pulled every deal and searched every note, call, meeting and task through the HubSpot API.
  • 8 of the 13 won deals ($122K of $132K) only existed in the notes. Reports built on source fields valued the partner at about $10K.

The problem

The partnership had been sending us prospects since 2023, through partner links, giveaway pages, a bootcamp quiz and the partner's marketplace. My first pass used the CRM's tracking properties, and it found 3 clients.

The catch: the partner tracking links didn't exist for the first part of the partnership. Anyone who came in before them was credited to whatever they clicked last, like Facebook, direct traffic or a meetings link.

What I did

  1. Pulled everything. Every deal, contact and company through the HubSpot CRM API, with their associations, so I could follow a prospect from first touch to closed deal.
  2. Searched the words people actually said. Full-text search across notes, logged calls, meetings and tasks for the partner's name and the ways reps wrote it.
  3. Tagged every deal. Tracked (UTMs, partner links, giveaway URLs) or note-only (the prospect named the partner, but the CRM credited something else).
  4. Rolled it up. By stage, year and source, into a closed-deal tracker and two designed reports.

What I found

More than half of the partnership's pipeline was invisible to every report we had.

Partner pipeline by how we found it

Tracked (42 deals)
$532K
Call notes only (44 deals)
$737K

Won revenue

Tracked (5 deals)
$10K
Call notes only (8 deals)
$122K
Pulled August 17, 2026 from the agency's HubSpot portal. Bars show share of each total.
Closed won deal Recreated example, names removed
StageClosed won
Original sourcePaid social
Partner(blank)
Amount$15,000

↑ The reports read this field

Discovery call · rep notes

(rest of the call notes trimmed)

How did you hear about us? [Partner]

↑ The truth was in here

This is the pattern behind 44 deals: the prospect said the partner's name out loud, and the CRM gave the credit to a click.
Volume isn't the same as value. The giveaway pages produced about 20 deals. Most booked a call and went dark, and one closed. Most of the won revenue came from prospects who named the partner on a call, which only the notes could see.

The partnership was also growing every year: 4 deals in 2023, 14 in 2024, 31 in 2025 and 37 in 2026 through mid-August. The overall win rate was 17.8% (13 of 73 closed deals).

What changed

The partnership was worth far more than our reports said, and that changed how we treated it. We signed up for more shows with the partner, invested more deeply in the relationship and put more resources behind it, with the goal of growing it as much as we could.

What I'd do differently

I'd read the notes first. I started with the tracking properties and almost stopped at 3. Now I treat source fields as the floor and go looking for what they missed.

I'd also push for one plain question on every form: how did you hear about us, in your own words, saved to a field reports can read. Then rep notes stop being the only record.

Built withHubSpot CRM APIClaude CodePython