Lead Source Tracking: Why Your Channel Report Doesn't Match What Sales Sees

It's the last leadership meeting of the quarter. You put up the channel slide: the spring trade show and the partner programme look thin, and a large slice of open pipeline sits under no source at all. The head of sales disagrees: those deals came from the booth and from partner introductions, and the sales team can name them. Next quarter's event and partner budget is on the table, and so, quite possibly, are both teams' bonuses. Whichever version leadership believes will decide where the money goes.

Nobody in that room is being careless. Marketing reports what Salesforce holds; sales reports what sellers remember. The gap usually lives in one field on a handful of records, and you can trace it before the quarter closes.

What lead source tracking is

Lead source tracking means recording where each lead and each deal came from, so spending can follow results. In Salesforce, Lead Source is a standard picklist on leads, contacts and opportunities, and most channel reports group pipeline by it. Many teams also separate the original source (how the buyer first arrived) from the latest source (what brought them back); this article deals with the single value most leadership reports read.

Why your channel report and sales disagree

Any CRM lead source field is only as reliable as the way it gets filled in. In Salesforce, the disagreement usually comes from a few ordinary causes:

What the report looks like when the source is missing

Here is next quarter's open pipeline for Fernhill Labware, a company selling lab inventory and sample-tracking software to research labs and biotech companies, grouped by Lead Source.

Salesforce opportunity report grouped by Lead Source showing $58,000 of next quarter's $140,000 open pipeline with no source and $20,000 under Other

Before: next quarter's open pipeline grouped by Lead Source. Three deals worth $58,000 have no source, and two more sit under Other.

Three opportunities worth $58,000 have no source: over 40% of the $140,000 in open pipeline. Add the $20,000 under Other and more than half the pipeline has no channel leadership can act on. The trade show shows one deal at $25,000; partners show one at $15,000. That is the view leadership is being asked to fund events and partners against.

Only one of these deals came through a converted lead: Northbrook Biosciences, whose trade show source carried over at conversion. Sellers opened the other seven directly, and that is where the blanks are.

Check the evidence before changing anything

The obvious fix is to ask sales where each deal came from and update the field. That conversation is useful, but it shouldn't be the evidence. Correct a source only where the record shows where the deal came from. A guessed source is worse than a blank one, because it looks trustworthy.

Salesforce report listing the five opportunities with a blank or Other Lead Source, with the seller's note on where each deal came from

The review list: only opportunities with no source or Other, with the seller's note beside each. Three notes name a channel; one record has no note.

In this example, each opportunity's Description holds the seller's note. Three records carry clear evidence:

Tolland Agritech called in after a former customer mentioned the company, so Other is an honest answer. Westmere Cell Sciences has no note at all, so it stays blank and visible. Someone may know where it came from; until they write it down, the report should say "unknown."

In your org, the evidence may sit in activity history, campaign membership or the original lead instead. If deals lose their history at conversion, see what Salesforce lead conversion can leave behind.

Same pipeline, a different budget conversation

The same Salesforce report after three sources were corrected, showing Trade Show at $55,000, Partner Referral at $33,000 and $10,000 still with no source

After: the same report, filters and columns. Total pipeline is still $140,000; trade show and partner pipeline grew because three records now show where they came from.

No deal changed. The same eight opportunities still total $140,000. But the trade show now carries $55,000 instead of $25,000, partner referrals $33,000 instead of $15,000, and the webinar appears with $12,000. Pipeline with no source fell from $58,000 to $10,000.

That's a different budget conversation. It doesn't prove the trade show was a good investment: open pipeline isn't closed revenue, and one source per deal still simplifies the buyer's path. It does mean leadership can argue about channels rather than about the data.

Settle the dispute before the next review

The corrections fix this quarter's slide; the dispute returns unless marketing and sales agree on the rules. These are suggested practices, not tested results.

If the handoff itself is unclear, the marketing-to-sales handoff questions a CEO is likely to ask are a useful companion, and lead assignment rules decide who owns a lead in the first place.

Keep it from drifting

Small, proportionate controls usually beat a large attribution project:

Bring one disputed deal

Bring the channel report leadership questioned and one deal sales says was miscredited. Contact Logic Conduit to trace where that deal's source was set, changed or lost in Salesforce, and what it would take to make the report trustworthy before the next budget decision. If the value is being overwritten or dropped as records move between a marketing platform such as HubSpot, Marketo or Account Engagement and Salesforce, the Salesforce Integration Sprint covers one bounded integration, including data mappings and reconciliation checks.