Sie sagen
„NetSuite already reports revenue by customer.“
Wir sagen
It does, exactly. It has no record of the campaign that produced the customer, because that predates the customer record.
Für NetSuite
The ledger is immaculate and it has never heard of your campaigns.
Export invoices from NetSuite, upload the leads behind them, and rank marketing on invoiced revenue.
Kein API-Schlüssel Nichts in NetSuite zu installierenNichts zu installieren Keine Karte nötigOhne Karte
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 enquiry. 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 have usually never met. Revenue with no traceable lead is reported as Direct / Unknown.
Zuletzt am 25. September 2026 anhand der eigenen Dokumentation von NetSuite geprüft.
Die Lücke
Finance can tell you what every customer paid. Marketing can tell you what every campaign cost. Nobody has joined them.
NetSuite sieht
Was verkauft wurde, an wen und für wie viel.
keine gemeinsame Zeile
Ihr Anzeigenkonto sieht
Der Klick, das Keyword, der Anruf und was jedes davon gekostet hat.
Die Datei
Was im Export stehen muss.
Drei Dinge tragen die Zuordnung: wer, wie viel und wann. Alles andere ist optional und ändert nur, wie sich der Bericht aufschlüsseln lässt.
- Erforderlich
Customer phone or email
On the customer record rather than the invoice. In a mid-market file the email on the billing contact is usually the durable key.
- Erforderlich
Invoice amount
Invoiced, in the transaction currency and a reporting currency if you run more than one.
- Erforderlich
Invoice date
When it was raised. Keep the customer's created date too — the gap is the sales cycle.
- Optional
Subsidiary and item class
Which entity billed it and what was sold. Both split a single number into decisions.
Schritt für Schritt
So holen Sie die Datei aus NetSuite.
Geschrieben für alle, die NetSuite im Nachbar-Tab geöffnet haben. Berichtsnamen unterscheiden sich je nach Edition, deshalb sagt jeder Schritt, wonach Sie suchen.
-
Build a saved search of invoices
Customer contact detail, amount, date. A saved search exports to CSV without a developer, which is the whole requirement.
-
Choose invoiced or collected and say which
They differ by your payment terms and by customer. Whichever you pick, use it on every row and record it.
-
Pick one reporting currency
A multi-currency file ranked on mixed currencies ranks exchange rates. Convert once, at a stated rate, before anything is compared.
-
Export your lead sources
Campaign leads, call tracking, web forms, events and any partner or reseller registration.
-
Upload both
The join runs on the phone and the email, normalised, with unmatched invoices and unmatched leads both kept visible.
Was zurückkommt
Die Seite, die NetSuite Ihnen nicht zeigen kann.
Umsatz nach Kanal, die Zahl der Verkäufe hinter jedem Wert und eine ehrliche Kategorie für alles, was niemand zuordnen konnte. Beispielzahlen aus dem durchgerechneten Beispiel der Seite B2B SaaS – nicht aus einem NetSuite-Konto.
Einem Kanal zugeordnet$2,070,00069% von $3,000,000
Zugeordnete Verkäufe51 von 75nur hohe Konfidenz
Durchschn. Verkauf$40,000pro bezahltem Verkauf
| Kanal | Anteil | Verkäufe | Umsatz |
|---|---|---|---|
| Google Ads | 18 | $720,000 | |
| LinkedIn Ads | 21 | $930,000 | |
| E‑Mail-Marketing | 12 | $420,000 | |
| Direkt / Unbekannt | 24 | $930,000 |
Nicht zugeordnete Verkäufe bleiben unter Direkt / Unbekannt. Sie werden nie auf die bezahlten Kanäle verteilt, damit die Summe besser aussieht.
Das Argument
Was sich ändert, wenn invoice und Anzeige in einer Zeile stehen.
The ERP is the only place the real number lives, and the hardest place to get it out of
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. Discount-led channels show the widest gap, reliably.
Subsidiaries and currencies turn one ranking into several
A company on NetSuite usually has more than one entity, and frequently more than one currency, which is most 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.
The report does both where the export carries them, and states the rate used, because a ranking that moves when the euro moves is not a ranking of marketing.
This is the most common reason an ERP-based attribution report gets argued with rather than acted on.
Revenue recognition and the invoice date are not the same event
Where revenue is recognised over a term — a subscription, a multi-year licence, a service contract — the recognised 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.
Summing by customer and attributing the whole contract to the lead that produced it keeps one decision as one number.
The report sums by customer across the window and keeps the first invoice apart from later ones, so a renewal is not silently credited to the original campaign.
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.
Partner and reseller revenue is not marketing and should not be averaged in
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 the partner, the report splits on it and the direct ranking becomes honest.
It also gives the partner programme a revenue number of its own, which is usually the first time anybody has put one beside the cost of running it.
Berechtigte Fragen
„NetSuite kann das doch schon.“ Nicht ganz.
Sie sagen
„Our CRM has a source field.“
Wir sagen
Filled in by whoever created the record. Joining invoices to leads on the contact detail is a second, independent view of the same question.
Sie sagen
„Exporting from the ERP needs IT.“
Wir sagen
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, where the export carries one, and for a multi-entity company it is usually the point.
Attribute the contract on the decision rather than across the schedule. Run a recognition view as a second, labelled report if you want it.
Reported separately from the first invoice, so the decision stays yours.
Yes, where the export flags them, and they should be — their cost and margin are nothing like a campaign's.
Long enough for your sales cycle, which in mid-market is usually a year or more.
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, split by subsidiary where available, first and repeat business apart, and everything unmatched kept visible.
Nach Branche
Branchen, die NetSuite nutzen.
Wie der Bericht aussieht, sobald der Export drin ist – für jede Branche eigens geschrieben.
- B2B SaaSWelche Kanäle haben Closed-Won gebracht – nicht MQLs?
- IndustrieherstellerWelche Kanäle haben Aufträge gebracht, nicht nur Anfragen?
- Enterprise-SoftwareWelche Kanäle haben gewonnene Verträge gebracht?
- Logistik & FrachtWelche Kanäle haben Verlader gebracht, die tatsächlich verladen?
- MedizinprodukteWelche Kanäle haben gebuchte Aufträge und Verbrauchsmaterial gebracht?
Andere Systeme
Ebenfalls lesenswert.
Mehrere Systeme im Einsatz oder im Vergleich? Die Methode ist dieselbe, die Spalten sind es nicht.
Datei mit Abschlüssen QuickBooks Online Businesses whose sales are invoices, not deals Datei mit Abschlüssen Was exportieren Datei mit Abschlüssen Xero Businesses that invoice through Xero Datei mit Abschlüssen Was exportieren Eine der beiden Dateien Odoo Small and mid-sized companies Eine der beiden Dateien Was exportieren
Alle 119 Systeme 
NetSuite und die anderen Produktnamen und Logos auf dieser Seite gehören ihren Inhabern und dienen nur dazu, die Software zu kennzeichnen, aus der eine Datei stammt. CloseRev ist mit ihnen nicht verbunden oder von ihnen empfohlen und verbindet sich mit keinem davon: CloseRev liest eine Datei, die Sie exportieren.
Heute starten
Zwei Exporte, und Sie wissen es.
Nichts in NetSuite zu installieren, kein API-Schlüssel, und Sie müssen bisher nichts getrackt haben. Das Vorjahr funktioniert so gut wie dieser Monat.