“Copper already shows where our deals came from.”
It shows the recent activity on the record. The first touch can be eighteen months behind that, and it was never written down.
For Copper
Export won opportunities and leads from Copper, join them on the contact detail, and recover how the relationship actually started.
CloseRev reads a Copper export of won opportunities — the contact's phone or email, the value and the close date — and matches it against the leads that produced them. Copper's design assumption is that business is won through relationships conducted in email, which is often true and which makes the first touch unusually hard to see by the time the deal closes. Revenue with no traceable lead is reported as Direct / Unknown.
Page updated September 24, 2026.
The gap
Every deal traces back to an email thread, and every email thread traces back to something nobody wrote down.
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 person record. In a relationship-led firm the email address is the durable key and the phone is often secondary.
Won opportunities with their amount. Open pipeline is a forecast.
When it was marked won. The contact created date belongs in the lead file; the interval can be a year or more here, and the matched-records export carries both dates.
Whatever the record carries about origin, exported as the lead file's source column — a claim to be tested rather than a fact.
Step by step
Written for somebody with Copper open in the next tab. Report names vary by edition, so each step says what to look for.
One row per win with a contact detail, the value and the close date.
The created date decides which lead came first, and in the matched-records export it sits beside the close date — the interval this page exists to make visible.
Referrals, events, content downloads, search, and any list or introduction you paid for.
Relationship-led sales cycles can exceed a year, and a shorter file leaves this year's revenue without the lead that started it.
The join runs on the email and the phone, normalized, with each win credited to the earliest lead the contact came through.
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 Business Consulting page — not from a Copper account.
| Channel | Share | Sales | Revenue |
|---|---|---|---|
| LinkedIn Ads | 9 | $171,000 | |
| Content & SEO | 11 | $198,000 | |
| Events & speaking | 8 | $144,000 | |
| Direct / Unknown | 21 | $387,000 |
Unmatched sales stay in Direct / Unknown. They are never spread across the paid channels to make the total look better.
The argument
When a deal closes after eighteen months of conversation, everybody involved remembers the conversation and nobody remembers the webinar, the introduction or the search that started it.
The CRM reflects that: the record is rich in recent activity and thin on how it began, because the beginning was the least interesting part at the time.
Joining the won deal back to the original lead file recovers the origin from data rather than from memory, and memory is reliably wrong about this.
One possible correction is that a channel everybody had written off as ineffective turns out to have started many of the relationships that later paid.
That is not a small finding when the channel in question is about to be cut for producing no attributable revenue.
Professional firms win work through people who vouch for them, and the effort behind that — events, memberships, hospitality, content, time — is a genuine budget line.
Because it produces no click and no invoice from a platform, it is absent from the marketing report while consuming a meaningful share of the marketing effort.
Recording the referrer at first contact makes it a source like any other, ranked on the same closed revenue.
The ranking may support what the partners already believed, with a surprise or two that change where the year's effort goes.
The surprises are the return on the exercise; the confirmations are what make the report trusted.
Copper's whole premise is that the relationship lives in email, which means the email address on a record is likely to be current and correct.
That makes it an unusually reliable join key — better than a phone number, which is the reverse of most of this catalog.
Where a person has changed employer, the same individual can appear twice with different addresses. Nothing merges them, so a sale matches only the record whose email or phone it carries.
Deciding whether those are one relationship or two is a judgment about your business; if they are one, give both rows the same phone number in the file before uploading.
Merging them automatically would be the kind of quiet assumption that makes an attribution number impossible to defend.
For consultancies, agencies and professional services, the interval between a first conversation and a signed engagement can be measured in seasons.
A twelve-month file therefore reports on marketing that ran before the file starts, and the ranking it produces is about a period nobody can act on.
Grouping revenue by when the contact first appeared, rather than when the deal closed, puts each win against the effort that actually produced it; the report dates by the close, and the matched-records export carries the first-contact date for that.
The same export gives that interval per source, which tells you which channels can be turned on for this year and which are next year's work.
Fair questions
It shows the recent activity on the record. The first touch can be eighteen months behind that, and it was never written down.
Then the report will show it as a number, which is what justifies the events and memberships that produce referrals.
They are too long for a twelve-month file. That is an argument for a two-year one, not against measuring.
No. It reads exported files, so your email, records and pipeline stay where they are.
Won opportunities with a contact detail, a value and a close date, plus people with their created dates and your lead sources.
Two years; there is no window to set. Relationship-led cycles can exceed one, and a shorter file measures the wrong period.
The email address here, which is unusual — most of this catalog runs on the phone number.
They appear twice and nothing merges them; a sale matches whichever record carries its email or phone. Whether that is one relationship is your judgment.
Yes, recorded at first contact, and in professional services they may dominate.
From the matched-records export, which carries the first-contact date; the report itself dates by the close. That grouping puts a win against the effort that produced it.
Not as a figure. The matched-records export carries both dates on every win, so it can be worked out per source — which tells you which channels are this year's work and which are next year's.
Not always. Where you invoice elsewhere, export from there for the collected figure.
Any revenue with no traceable first touch. Its size is stated rather than distributed.
A contact detail, an amount and a date, plus a source label. No email content, no notes, no files. Encrypted in transit and at rest and deleted with the import.
Revenue per source, each win credited to the earliest lead the contact came through, both dates on every match in the matched-records export, 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.
Copper 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 articleEvery attribution tool is built for businesses where the inquiry and the purchase happen in the same quarter. If yours does not, almost every default is wrong: the date ranges, the reporting cadence, the optimization signal and the patience of everyone involved.
Read the articleStart today
Nothing to install in Copper, no API key, and no need to have been tracking anything until now. Last year works as well as this month.