“Epicor already reports sales by customer.”
It does. It has no record of the trade show, inquiry or campaign that opened the account.
For Epicor
Export invoices from Epicor, upload the leads and quote requests behind them, and rank sources on the accounts they opened.
CloseRev reads an Epicor export of invoices — the account's contact phone or email, the amount and the date — and matches it against the trade shows, inquiries, quote requests and campaigns that opened the account. For manufacturers and distributors a customer is an account that orders repeatedly and often grows, so the value of a source is what its accounts bought over a year or two, not the first order. Revenue with no traceable lead is reported as Direct / Unknown.
Page updated September 25, 2026.
The gap
Sales reports show orders and reps. Nothing shows which marketing opened the accounts that now carry the business.
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.
The buyer or purchasing contact on the account. Accounts often have several; list each in the lead file under the same source so any of them joins.
Invoiced sales per account.
When it was invoiced. The account opened date is not read; every invoice credits the lead that opened the account, so the first order and the growth after it land on the same source.
The territory as Location; the rep in the lead file's campaign value. Needed to separate what the marketing did from what the rep did.
Step by step
Written for somebody with Epicor open in the next tab. Report names vary by edition, so each step says what to look for.
One row per invoice with an account contact detail, the amount and the date.
The person who inquired is often not the person who orders. List every known contact in the lead file under the same source, so any of them joins the account.
Trade show scans, website inquiries, requests for quotation and distributor referrals, including the quotes that were lost.
New accounts often start small and grow, and a short file measures only the trial order.
The join runs on the phone and the email, normalized, with every later invoice credited to the source that opened the account.
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 Industrial Manufacturers page — not from a Epicor account.
| Channel | Share | Sales | Revenue |
|---|---|---|---|
| Google Ads | 24 | $396,000 | |
| Trade shows | 19 | $468,000 | |
| Email marketing | 14 | $198,000 | |
| Direct / Unknown | 43 | $738,000 |
Unmatched sales stay in Direct / Unknown. They are never spread across the paid channels to make the total look better.
The argument
Industrial buyers often test a new supplier with a small order before moving more of their spend to it.
Ranked on the first order, every source looks modest and the differences between them are noise.
Two years of invoices, all credited to the source that opened each account, show which sources opened accounts that grew into meaningful customers.
That is the ranking that should set next year's trade show and campaign budget, and it can differ from a first-order ranking.
The report shows the count and the average beside the total, and the matched-records export lists every invoice, because one very large account can otherwise decide a source's result on its own.
Trade shows are often the largest marketing line for a manufacturer or distributor, and among the least measured.
Badge scans and meeting notes carry the visitor's company, phone and email. Kept as a lead file, they match against the accounts that later ordered.
Over two years, the report shows what each show produced in account revenue, to set against what it cost to attend.
Shows that produce a lot of conversations and few accounts become visible, as do smaller shows that quietly produce the best customers.
The scans are the part most often lost. They sit in a rep's inbox or a spreadsheet after the event and never reach a system, so the show's results can only be argued about. Keeping them as a file, with the show named on every row, is what turns a line in the events budget into something that can be ranked.
Much industrial business is quoted: a request for quotation arrives, engineering or estimating prices it, and the customer accepts or goes elsewhere.
Every quote costs time whether or not it is won, and sources differ in how many quotes they generate per order.
Including quote requests, lost ones as well, sets each source's quotes beside the accounts it opened.
A source producing many requests from buyers gathering prices is expensive in estimating time, which no revenue-only report shows.
The matched-records export also carries the quote date beside each invoice, so the lag from quote to first order can be worked out per source. In industries where a qualified supplier list is reviewed once a year, a quote that loses today can become an account at the next review, and a short file would count it as a loss for good.
In a business with field sales, the rep who manages an account shapes how much it grows, and reps are not assigned to accounts at random.
Without the rep in the file, a source whose accounts happened to go to the strongest reps looks better than it is.
With the rep in the campaign value and the territory mapped as Location, sources can be compared within the same rep's accounts, which removes most of the distortion.
It also shows the reverse: a strong source whose accounts are struggling under a particular territory, which is a sales-management finding rather than a marketing one.
Fair questions
It does. It has no record of the trade show, inquiry or campaign that opened the account.
Then the report will show it, and with the rep in the campaign value the two are not confused.
Industrial accounts take that long to show what they are worth. The first order is a trial.
No. It reads a file you exported, so your ERP, orders and customer records stay where they are.
Invoices by account with a contact detail, the amount and the date.
Because the person who inquired is often not the person who orders; list each contact under the same source.
Two years, because new accounts often start with a trial order and grow. There is no window to set.
Yes, where badge scans or meeting notes are kept as a lead file.
Yes. They cost estimating time, and quotes beside accounts opened, per source, is one of the most useful outputs.
Yes, with the rep in the campaign value and the territory mapped as Location.
Yes, recorded as a source when the lead arrives, and named in the campaign column so each can be ranked.
The count and the average sit beside the total, and the matched-records export lists every invoice, so one account cannot decide a source's ranking unnoticed.
Any account revenue with no traceable lead. Its size is stated rather than distributed.
A contact detail, an amount and a date, plus a rep or territory if you include them. No parts, no pricing, no drawings, no contracts. Encrypted in transit and at rest and deleted with the import.
Account revenue per source over two years, quotes beside accounts opened, 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.
Epicor 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 articleTrade shows and webinars produce the best-qualified leads most companies get and the worst measurement. The badge scan is not the problem: the gap between the scan and the invoice is. Here is how to price an event by the revenue it closed, months after everybody stopped talking about it.
Read the articleStart today
Nothing to install in Epicor, no API key, and no need to have been tracking anything until now. Last year works as well as this month.