“Close already reports won deals by lead source.”
If somebody set the source correctly on every lead, for the whole period. This reads the click and the won deal rather than a field somebody maintained.
For Close
Export won opportunities, upload the sources that produced the leads, and rank channels on closed value rather than on lead volume.
CloseRev reads a Close export of won opportunities — the lead's email or phone, the value and the close date — and matches it against the marketing that produced the lead before any rep touched it. Close reports on activity and outcome exceptionally well and has no view of what happened before the lead arrived. Deals with no traceable origin are reported as Direct / Unknown rather than credited to a campaign.
Page updated September 24, 2026.
The gap
Your dashboard shows calls made, emails sent and deals won by rep. Nothing on it says which marketing put those leads in the queue.
What was sold, to whom, and for how much.
The click, the keyword, the call, and what each one cost.
The file
Three things carry the match: who, how much, and when. Anything else is optional and only changes how the report can be sliced.
On the lead the opportunity belongs to. A phone-led team should take both — outbound dials and inbound forms capture different halves of the same person.
The won value. Where you sell annually, be consistent about whether it is first-year or total contract value across the whole file.
When the opportunity was marked won. For anything with a ramp, that is closer to the marketing than the first invoice is.
One can take the Product / service slot and the other Location. Rep separates channel quality from execution; pipeline separates product lines that convert at different rates.
Step by step
Written for somebody with Close open in the next tab. Report names vary by edition, so each step says what to look for.
One row per won deal with a lead contact detail, the value and the won date. Lost opportunities do not belong here — every row counts as a sale; conversion by source comes from the lead file, which holds every lead whether it was won or not.
A lead your team sourced cold did not come from marketing, and including it silently will make Direct / Unknown look like a failure of attribution rather than a description of your prospecting.
Paid search, paid social, content sign-ups, call tracking, marketplace and list vendors — combined into one lead file with a contact detail and the source on every row.
Whatever your median time from lead to won is, the deal file should reach back at least twice that far.
The join is the email and the phone, normalized. An exact match counts on its own; the same number under a different country code waits for a person; anything weaker stays unmatched.
What comes back
Revenue by channel, the count of sales behind each figure, and an honest bucket for the ones nobody could trace. Sample figures, from the worked example on the B2B SaaS page — not from a Close account.
| Channel | Share | Sales | Revenue |
|---|---|---|---|
| Google Ads | 18 | $720,000 | |
| LinkedIn Ads | 21 | $930,000 | |
| Email marketing | 12 | $420,000 | |
| Direct / Unknown | 24 | $930,000 |
Unmatched sales stay in Direct / Unknown. They are never spread across the paid channels to make the total look better.
The argument
Close is built around what a rep does: dials, connects, emails, sequences, meetings. Those are the right metrics for managing a floor and they are the wrong ones for judging a channel.
A source producing engaged, well-qualified leads makes every activity metric look better without the team doing anything differently, and a source producing poor leads makes a good team look lazy.
Ranking channels on won value rather than on the activity they generated separates the two. It is the difference between knowing your reps are working and knowing your marketing is.
Inside sales teams live on response time, and response time is not evenly distributed across sources. Leads arriving during business hours from a form get called in minutes; leads arriving overnight or through a vendor feed sit.
So a source can look poor when what is actually poor is the routing of that source. The channel gets cut, the routing never gets examined, and the same thing happens to the next channel.
Reading won value by source beside the rep — the rep in the Product / service slot, and the matched-records export for the two together — exposes it. Where one source underperforms only for the reps who work the late queue, that is an operations finding wearing a marketing costume.
Plenty of sales teams run outbound alongside inbound. Both produce opportunities in the same pipeline and both are worked by the same people.
If the export mixes them, every marketing channel is diluted by deals marketing never touched, and the honest Direct / Unknown bucket fills up with prospecting the team did deliberately.
Where the export carries a source or a lead origin, filter outbound out before drawing conclusions; left in, it makes these reports read worse than they are.
With every lead in the lead file, won or lost, the report puts each source's leads beside its won deals: conversion from lead to won by source, and value per lead by source.
Those two numbers can disagree with the volume ranking a team already has. A source producing half the leads at three times the conversion is the one to spend on, and it is invisible in any report that counts leads.
Value per lead is the one to act on, because it survives both halves of the problem at once: a source can win a high share of small deals or a low share of large ones, and only the combined figure says which is worth more to the business. The cheapest source per lead can turn out to be the most expensive per dollar of revenue, which is a sentence worth reading twice before the next budget.
Fair questions
If somebody set the source correctly on every lead, for the whole period. This reads the click and the won deal rather than a field somebody maintained.
Then split outbound out before reading it, or marketing will be judged against deals it never produced.
Then the file is small and the answer arrives quickly. The method does not change.
No. It reads a file you exported, so your pipeline, your sequences and your reps' inboxes stay entirely out of reach.
Won opportunities with a lead contact detail, the value and the won date. Lost ones stay out: every row in the sales file counts as a sale, and conversion comes from the lead file.
Either, consistently across the file. Mixing them favors whichever channel happens to sell longer terms.
Filter them out of the deal file, or tag them as their own source in the lead file. Including them silently dilutes every marketing channel and inflates Direct / Unknown.
Yes, with a rep column in the Product / service slot; rep and source together come from the matched-records export.
Yes: the lead file holds every lead, won or lost, so each source's leads sit beside its won deals.
At least twice your median lead-to-won time.
Yes, on won value rather than on the count of records they sold you.
Direct / Unknown, reported as unmatched rather than distributed across the paid channels.
No. It adds the half before the lead existed, which Close never saw.
A contact detail, a value and a date, plus a rep or pipeline if you include them. No call recordings, no email threads, no notes, no sequences. Encrypted in transit and at rest and deleted with the import.
Won value by source, each source's leads beside its won deals, and everything unmatched kept visible.
By trade
What the report looks like once the export is in, written for each one.
Other systems
Running more than one system, or comparing? The method is the same and the columns are not.
Close and the other product names and logos on this page belong to their owners and are shown to identify the software a file comes from. CloseRev is not affiliated with or endorsed by them, and connects to none of them: it reads a file you export.
From the blog
The export is the part of an attribution project that everyone treats as trivial and that determines whether the whole thing works. Here is the field list, the date-range trap, the deduplication rule, and the six columns to leave out on purpose.
Read the articleEvery attribution vendor quotes a match rate and none of them define it the same way. Here is what the number actually measures, what range is honest for a mid-market business, and the three ways the figure gets inflated before it reaches your slide.
Read the articleThe channel with the cheapest leads is often the one whose leads almost never buy. Lead conversion rate by source divides the new customers each channel produced by the real, deduplicated leads it sent, counted by the month the lead arrived. Here is the formula, what to take out of the denominator, why small counts lie, how revenue per lead and cost per customer follow from it, and a five-channel worked example.
Read the articleStart today
Nothing to install in Close, no API key, and no need to have been tracking anything until now. Last year works as well as this month.