“Contractor Foreman already reports revenue by project.”
It does, and it has no record of what produced the client, because that happened before the project existed.
For Contractor Foreman
Export invoices from Contractor Foreman, upload the leads behind them, and rank marketing on the project rather than on the deposit.
CloseRev reads a Contractor Foreman export of invoices — the client's phone or email, the amount and the date — and matches it against the leads that produced the project. Construction bills in stages, so one decision by one client produces many invoices across many months; every one carries the same contact and credits the same earliest lead, but each row counts as a sale until the file is summed to one row per project. Invoices with no traceable lead are reported as Direct / Unknown.
Page updated September 24, 2026.
The gap
Progress billing turns one won project into a dozen rows, and every report that counts rows as wins is wrong.
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 client record rather than the invoice, so every progress bill joins to the same person.
Each billing, including change orders. The project's value is their sum, not the first one.
When each stage was billed. The spread across dates is what the report has to collapse.
Not read by CloseRev; it is what you sum the export by before uploading. Without it, summing by client does the same job slightly less precisely.
Step by step
Written for somebody with Contractor Foreman open in the next tab. Report names vary by edition, so each step says what to look for.
One row per billing with a contact detail, the amount, the date, and the project reference where available.
Each row counts as a sale. Every billing lands on the same channel, but unsummed, one large job is counted as a dozen wins.
Referrals, architects and designers, search ads, the website form, tracked numbers and any directory you pay for.
A project signed this quarter finishes billing next year, and the lead that produced it arrived the quarter before.
The join runs on the phone and the email, normalized, with every billing on a project credited to the lead that produced it.
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 Commercial Construction page — not from a Contractor Foreman account.
| Channel | Share | Sales | Revenue |
|---|---|---|---|
| Google Ads | 4 | $480,000 | |
| Events | 6 | $720,000 | |
| Email marketing | 3 | $320,000 | |
| Direct / Unknown | 17 | $2,480,000 |
Unmatched sales stay in Direct / Unknown. They are never spread across the paid channels to make the total look better.
The argument
A project billed in stages produces invoices in months when no marketing produced anything, and none in the month the client actually decided.
Attributed by invoice date, a single kitchen build credits whatever was running in each of nine months, which is nine wrong answers rather than one.
Crediting every billing to the earliest lead the client came through gives one answer, which is the only version a budget decision can use; summing by project first keeps the count of wins honest as well.
Change orders belong in that sum too: they are revenue from the same decision, and excluding them understates every channel that produces clients who expand scope.
That last effect is not evenly spread, which is precisely why it matters.
A residential remodel is considered for months before a contractor is called, and the project bills for months after it starts.
Between the two, revenue arriving this quarter can trace to a lead from a year earlier, and a lead file that does not reach back that far leaves it in Direct / Unknown.
The report dates revenue by the invoice; the matched-records export carries the lead date beside it, which allows grouping by when the client arrived — the grouping that answers what to buy next.
Those two dates also give the lag per channel, worked out from the export, which tells you how far ahead of a busy season you have to be spending.
For a contractor booking work six months out, that number is operationally more useful than the ranking itself.
For an established general contractor, much of the work may come from people who already know them: a designer who specifies them, a past client, a neighbor of a past client.
None of those produce an invoice from an advertising platform, so they are absent from every paid-media report and the paid channels are judged as if they were the whole picture.
Recording the referral source at first contact — one field — puts them into the same comparison on the same project value.
The result can be that the paid budget is carrying a much smaller share of the business than anyone assumed, which changes where the next effort goes.
It also identifies which relationships are actually producing work, as opposed to which ones are pleasant.
A bathroom, a whole-house remodel and a commercial fit-out have different values, different durations and different buyers.
A source that mostly produces one will be ranked as though it produced the mix, which flatters some channels and buries others.
Mapped as Product / service, a project type lets the report cut revenue by it, and the matched-records export pairs each project with its channel — this source for kitchens, that one for additions.
Without the split, a contractor running several project types is reading an average that corresponds to no decision they can make.
Fair questions
It does, and it has no record of what produced the client, because that happened before the project existed.
Then recording the referrer is the highest-value change available, and the report will show its true share.
Which is why the files should cover eighteen months, and why every billing credits the earliest lead however long ago it arrived.
No. It reads an exported file, so your schedules, documents and project records stay where they are.
Invoices with a client contact detail, the amount, the date and a project reference where available.
Every billing credits the same earliest lead, so the revenue lands on one channel. Each row counts as a sale, though, so sum to one row per project first if one decision should be one win.
Yes. They are revenue from the same decision, and leaving them out understates the channels that bring clients who expand scope.
Eighteen months; there is no window to set. The lead, the signature and the final billing can span more than a year.
Not in the report, which dates revenue by the invoice. The matched-records export carries the lead date for that grouping, and it is the one a marketing decision needs.
Yes, recorded at first contact. They may be the largest source, and they are the least measured.
Yes, mapped as Product / service where the export carries one. A blended average across project types is rarely actionable.
Keep them in the lead file, out of the sales file. Estimating a large project is expensive, and a channel that produces many losses shows it as leads with no sale.
Any revenue with no traceable lead. Its size is reported rather than distributed across the measurable channels.
A contact detail, an amount and a date, plus a project reference or type if you include them. No plans, no documents, no site photographs. Encrypted in transit and at rest and deleted with the import.
Project value per source, every billing credited to the lead that started it, revenue cut by project type where you map one, 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.
Contractor Foreman 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
Multi-crew home and field services businesses run on phone calls and job management software, not on web forms. Which means the standard marketing dashboard is measuring the smallest part of the business and missing where the money actually is.
Read the articleCall tracking answers one question well: which campaign produced the ring. It has no view of what happened after the call ended, which is where the money is decided. This is what the gap costs, and how to close it without replacing the call tracker you already have.
Read the articleThe 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 articleStart today
Nothing to install in Contractor Foreman, no API key, and no need to have been tracking anything until now. Last year works as well as this month.