“NetSuite already reports revenue by customer.”
It does, exactly. It has no record of the campaign that produced the customer, because that predates the customer record.
For NetSuite
Export invoices from NetSuite, upload the leads behind them, and rank marketing on invoiced revenue.
CloseRev reads a NetSuite export of invoices — the customer's phone or email, the amount and the date — and matches it against the campaigns, calls and forms that produced the inquiry. NetSuite is the system of record for money in a mid-market company and has no view of what happened before the customer record existed, which is why the two halves may never have met. Revenue with no traceable lead is reported as Direct / Unknown.
Page updated September 25, 2026.
The gap
Finance can tell you what every customer paid. Marketing can tell you what every campaign cost. Nobody has joined them.
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 customer record rather than the invoice. In a mid-market file the email on the billing contact is often the durable key.
Invoiced, converted to one reporting currency if you run more than one — one amount is read per row.
When it was raised. The lead date belongs in the lead file; the matched-records export carries both, and the gap is the sales cycle.
The subsidiary as Location, the item class as Product / service. Both split a single number into decisions.
Step by step
Written for somebody with NetSuite open in the next tab. Report names vary by edition, so each step says what to look for.
Customer contact detail, amount, date. A saved search exports to CSV without a developer, which is the whole requirement.
They differ by your payment terms and by customer. Whichever you pick, use it on every row and record it.
A multi-currency file ranked on mixed currencies ranks exchange rates. Convert once, at a stated rate, before anything is compared.
Campaign leads, call tracking, web forms, events and any partner or reseller registration.
The join runs on the phone and the email, normalized, with unmatched invoices and unmatched leads both kept visible.
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 NetSuite 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
Revenue in a mid-market company is whatever the ERP says it is. Every other system holds an estimate: the CRM holds what somebody expected to close, the advertising platform holds what it can observe.
That makes NetSuite the right source for the money side and an awkward one for a marketer, because the export is a saved search rather than a download button.
It is still a marketer's task and not an IT project — a saved search with three columns, run once a month, is the whole mechanism.
What it is not is a CRM report. A closed-won opportunity is a forecast that somebody believed; an invoice is a claim on a customer, and they differ often enough to change a channel ranking.
Where both exist, exporting them together and measuring the gap per source is worth doing once. If discount-led channels show the widest gap, that is worth knowing.
A company on NetSuite often has more than one entity, and sometimes more than one currency, which is much of why it is on NetSuite.
A blended figure across subsidiaries answers a question nobody asks: marketing is bought per market, and a channel that works in one territory often does nothing in another.
Converting to one reporting currency at a stated rate is the minimum. Splitting by subsidiary is what makes the answer actionable.
Currency is set per dataset, so convert in the file and record the rate; the subsidiary, mapped as Location, lets the report cut revenue by it. A ranking that moves when the euro moves is not a ranking of marketing.
Skipping it is a common reason an ERP-based attribution report gets argued with rather than acted on.
Where revenue is recognized over a term — a subscription, a multi-year license, a service contract — the recognized amount and the invoiced amount describe different months.
Attributing on recognition spreads one decision across a schedule and credits whatever marketing was running each period, which is the same error progress billing causes elsewhere.
Every invoice on a contract carries the same customer and credits the lead that produced it, so the decision stays with one channel; export invoices, not recognition entries.
A renewal invoice credits the original campaign too; to see renewals apart, map a new/renewal column as Product / service.
Where you want the recognition view as well, run it as a second report and label it — do not mix the two bases in one ranking.
Deals that arrive through a channel partner have a different cost, a different margin and a different acquisition story from anything a campaign produced.
Pooled, they inflate whichever source happens to be running and understate the real cost of the direct channels.
Where the export flags partner deals, filter them out or map the flag as Product / service, and the direct ranking becomes honest.
It also gives the partner program a revenue number of its own, which may be the first time anybody has put one beside the cost of running it.
Fair questions
It does, exactly. It has no record of the campaign that produced the customer, because that predates the customer record.
Filled in by whoever created the record. Joining invoices to leads on the contact detail is a second, independent view of the same question.
A saved search with three columns does not. Anything that does need IT is a sign the wrong export was chosen.
No. It reads a CSV you exported, so your ledger, your customers and your permissions stay exactly where they are.
Invoices with a customer contact detail, the amount and the date, from a saved search.
Either, chosen once and recorded. They differ by payment terms and by customer, and mixing them across sources compares accounting rather than marketing.
Convert to one reporting currency at a stated rate before anything is compared. A ranking that moves with the exchange rate is not a ranking of marketing.
Yes, mapped as Location where the export carries one, and for a multi-entity company that is often the point.
Attribute the contract on the decision rather than across the schedule. Run a recognition view as a second, labeled report if you want it.
They count, and credit the campaign that produced the customer; map a new/renewal column as Product / service to see them apart.
Yes, where the export flags them — filter them out or map the flag as Product / service — and they should be: their cost and margin are nothing like a campaign's.
Long enough for your sales cycle, often a year or more in mid-market. There is no window to set.
Any revenue with no traceable lead. Its size is stated rather than distributed across the measurable channels.
A contact detail, an amount and a date, plus a subsidiary or class if you include them. No ledger, no bank details, no purchase orders, no contracts. Encrypted in transit and at rest and deleted with the import.
Invoiced revenue per source, cut by subsidiary where you map one, renewals apart where marked, 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.
NetSuite 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 articleOrganic search is often the largest source of customers a business has and the one it measures worst. There is no spend to divide by, no click identifier to follow, and Google withholds close to half the queries. Here is what can honestly be known about what it earns, and how to find out.
Read the articleStart today
Nothing to install in NetSuite, no API key, and no need to have been tracking anything until now. Last year works as well as this month.