Cookie preferences

Choose what we may use. Strictly necessary cookies keep you signed in and can't be turned off; everything else is your call and changes nothing about how the site works. You can change your mind any time from the footer.

For Odoo

The lead and the invoice live in the same database. The link between them often does not.

Export leads and invoices from Odoo, join them on the customer, and rank sources on invoiced revenue.

  • No API key
  • Nothing to install in OdooNothing to install
  • No card requiredNo card

Odoo can hold both halves of the match — leads in its CRM, and the invoices that followed in its accounting — which makes it one of the few systems here that could answer attribution from a single database. In practice the chain from lead to opportunity to quotation to invoice is only intact where the sales team completed every step, so CloseRev joins the lead export to the invoice export on the contact detail instead, which works whether or not the chain was kept. Revenue with no traceable lead is reported as Direct / Unknown.

Page updated September 25, 2026.

The gap

Opportunities get converted, quotations get sent, invoices get raised, and nobody can say which marketing produced any of it.

Odoo sees

What was sold, to whom, and for how much.

no shared row
Your ad account sees

The click, the keyword, the call, and what each one cost.

The file

What the export needs in it.

Three things carry the match: who, how much, and when. Anything else is optional and only changes how the report can be sliced.

  1. Needed

    Contact phone or email

    On the lead and on the invoiced customer. Joining on the contact detail works even where nobody linked the records inside Odoo.

  2. Needed

    Lead source and campaign

    As recorded when the lead was created.

  3. Needed

    Invoice amount and date

    Posted customer invoices. A confirmed quotation is not yet revenue.

  4. Optional

    Company or sales team

    The invoicing company, mapped as Location; the sales team is not read as a field, but can go in the lead file's campaign value.

Step by step

Getting the file out of Odoo.

Written for somebody with Odoo open in the next tab. Report names vary by edition, so each step says what to look for.

  1. Export leads with their source

    One row per lead with the contact detail, source, campaign and created date — including leads that were lost.

  2. Export posted customer invoices

    Contact detail, amount, date. Draft and canceled invoices are not revenue.

  3. Do not rely on the internal chain

    Where a lead was converted to an opportunity and on to a sale, the link helps; where it was not, the contact detail still joins them.

  4. Let the files fit your sale

    Weeks for a product business, months for a project or a contract. There is no window to set.

  5. Upload both

    The join runs on the phone and the email, normalized, with unmatched leads and invoices both kept visible.

What comes back

The page Odoo cannot show you.

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 Odoo account.

Traced to a channel$1,062,00059% of $1,800,000
Sales matched57 of 100high confidence only
Average sale$18,000per paid sale
ChannelShareSalesRevenue
Google Ads24$396,000
Trade shows19$468,000
Email marketing14$198,000
Direct / Unknown43$738,000

Unmatched sales stay in Direct / Unknown. They are never spread across the paid channels to make the total look better.

The argument

What changes when the invoice and the ad share a row.

One database does not mean one record

An integrated system makes it possible to follow a lead through to an invoice, and that possibility is only realized when every step was completed in order.

In practice a salesperson creates a new customer rather than converting the lead, a quotation is raised against a different contact, or the invoice goes to a company when the lead was a person.

Each break leaves the invoice without a source, and a report that follows internal links attributes it to nothing.

Joining on the contact detail reconnects them, whether or not the internal link exists.

Comparing the report with what Odoo's own linked records attribute shows how much had to be rebuilt, which is itself worth knowing: it measures how the sales process is actually used, as against how it was designed.

Modules get adopted one at a time

Many companies start with one part of an integrated system — often the CRM or the invoicing — and run the rest elsewhere for years.

A company using its CRM without its accounting has leads and no invoices in the same place; one using its accounting without the CRM has invoices and no sources.

The method works either way, because it needs two exports rather than one integrated setup: leads from wherever they are kept, invoices from wherever they are raised.

That also makes it robust to the next change of system, which in growing companies tends to come sooner than planned.

A confirmed quotation is not revenue

The step from quotation to invoice is where scope changes, discounts get applied and some confirmed orders are never invoiced at all.

Ranking sources on confirmed quotations measures the sales team's optimism; ranking on posted invoices measures the money.

Where both are exported, the gap between them per source is worth a look once. Sources that produce price-sensitive buyers may show the widest one.

The report ranks on posted invoices; state the basis with it, so the number can be defended when somebody asks.

Recurring revenue needs marking

Where customers are billed monthly or annually on a subscription, one sale produces a long series of invoices.

Credited invoice by invoice, the source that produced the customer gets paid again every month and looks far better than a source whose customers buy once.

Every invoice credits the same source, so a recurring customer's revenue grows under one channel; mapping a first/recurring column as Product / service keeps the acquisition figure and the retention figure apart.

That split also shows which sources produce customers who stay, which can be the more valuable finding. A source whose customers cancel after two months was a source of trials, however good its first-month figure looked.

Fair questions

“Odoo already does that.” Not quite.

They say

“Odoo can already report on this.”

We say

Where the lead-to-invoice chain is intact, partly. Joining on the contact detail works where it is not, which is many real databases.

They say

“We only use Odoo for invoicing.”

We say

Then the invoices come from Odoo and the leads from wherever you keep them. The method needs two files, not one system.

They say

“Our salespeople always convert leads properly.”

We say

Then the join will agree with the internal chain, and you will have evidence for it.

Questions

Odoo, specifically.

Something else? Ask us and a person answers.

No. It reads exported files, so your database, users and records stay where they are.

Odoo 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.

Start today

Two exports, and you will know.

Nothing to install in Odoo, no API key, and no need to have been tracking anything until now. Last year works as well as this month.