The Revenue Intelligence Blueprint
From first lead to final job profit
How to connect marketing, sales, revenue, collections and job-cost information into a financial picture you can trust, with a worked example and a downloadable mapping worksheet.
A homeowner calls in February about a kitchen and a family room addition. They sign in April. The final payment clears in September, and the last subcontractor invoice arrives in October. By then, the marketing that started it has been reported, paid for and forgotten. This guide shows how to follow that money the whole way, from the first lead to the profit the finished job actually left, and how to tell when the numbers are good enough to act on.
You know what you sold. Do you know what you earned?
Most established remodelers can answer a lot of questions about their business. You know what you spent on advertising last quarter. Your call tracking or CRM shows how many leads came in. Your proposal software shows what was signed. Your bank shows what was deposited.
The harder question is how those numbers connect. Did the marketing that produced the most leads also produce the most profitable work? Of the work you signed in the spring, how much has been collected, and how much of it is finished and costed? The answers exist, but they live in different systems and describe different moments in a project’s life.
Six measures matter here. They’re related, but they aren’t interchangeable.
| Measure | What it tells you | Where it usually lives | What it can’t tell you |
|---|---|---|---|
| Marketing activity | What you spent and how many leads it produced | Ad platforms, call tracking, website forms | Whether any of it turned into work |
| Sales activity | Which leads became consultations, estimates and proposals | CRM, estimating software | What was actually signed |
| Signed work | The value of contracts you’ve won, including approved change orders | Proposal software, CRM, contracts | How much cash you have, or what the work will earn |
| Collections | Payments actually received | Accounting | Whether the job is profitable |
| Expected gross profit | Contract value minus actual costs to date and estimated costs still to come | Job costing plus estimates | The final result, which can still change |
| Actual gross profit | Final revenue minus final job costs, on completed projects | Job costing and accounting | Overhead and net profit |
Two of these are easy to blur. Expected gross profit includes estimates for work that isn’t finished, so it can move. Actual gross profit only exists once a project is complete and costed. And both are gross figures: neither includes your office, your management team, your vehicles or your own pay, so neither is net profit.
Follow the money through the whole business
Every project travels the same path, even when your systems record it in pieces.
- Lead. Someone calls, fills out a form or is introduced by a past client. You learn the source, the date and what they asked about.
- Qualified opportunity. The project fits your work, location, timing and budget range. You learn how much real demand the lead represented.
- Consultation. You meet, visit the site or review plans. You learn where your sales time goes.
- Estimate or proposal. You price the work. You learn what the opportunity is worth and the margin you priced in.
- Signed contract. The homeowner commits. You learn the value of the work won.
- Collections. Deposits, progress payments and the final payment arrive. You learn when the cash actually comes in.
- Job costs. Labor, materials, subcontractors and permits accumulate. You learn what the work is costing against what you bid.
- Completed project. The work is finished and the final invoices are in. You learn the final contract value, including change orders.
- Actual gross profit. Final revenue minus final job costs. You learn what the project truly earned.
Each step answers a different question, and each one happens later than the one before. For a large project, the gap between the first step and the last can be a year or more.
Signed is not collected, and collected is not profit
A signed contract is a promise of revenue on a schedule. A deposit arrives first, progress payments follow the work, and the final payment usually comes after completion. Some of it may be held back until punch-list items are closed. So at any given moment, part of your signed value is still uncollected, mostly because the work isn’t finished, not because anyone is late.
Collections, in turn, aren’t profit. A project can be fully paid and still lose money if costs ran over. And the contract value itself moves: approved change orders add revenue, and they usually add cost too. A project’s final revenue is the original contract plus approved change orders, and its final margin depends on how both sides moved.
Why lead counts mislead
If you judge marketing by leads alone, you reward whatever produces the most calls. But leads differ enormously in how often they sign, how large the projects are and how profitable the work turns out to be. A source that produces a few large, well-margined projects can be worth far more than one that fills the phone with small, price-shopped requests. You can only see that by following leads forward to signed work and, eventually, to gross profit.
That forward view will never be perfectly complete. Referrals and word of mouth often arrive through a Google search or a direct call, and get recorded as one of those. Some homeowners contact you several times through different channels. Some records will never carry a reliable source. A responsible picture accounts for that openly, with an “unknown or unverified” group, instead of forcing every project into a channel.
Connect the systems you already use
The information you need almost always exists already. It’s spread across tools that were each built to do one job well.
| System | What it usually holds | What can link it to the others |
|---|---|---|
| Google Ads, Meta and other ad platforms | Spend, campaigns, clicks | Click identifiers on the visit, campaign tags, dates |
| Website forms and call tracking | Lead time, landing page, source tags, caller number | Form or call record, email, phone, click identifier where captured |
| CRM and sales pipeline | Contacts, opportunities, stages, outcomes | CRM contact and opportunity IDs |
| Estimating and proposal software | Estimates, proposals, contract value, change orders | Proposal or job number, customer name and address |
| Project management and job costing | Budgets, committed and actual costs, completion | Job number |
| Accounting and invoicing | Invoices, payments, cost entries | Customer and job references on transactions |
Connecting these is less about technology than about agreeing how records match.
Deterministic matches use an identifier that’s carried from one system to the next: the CRM opportunity ID copied into the proposal, the job number used in job costing and on every invoice, or an ad platform’s click identifier stored on the lead record. When the identifier is present, the match is certain. Google, for example, adds a click identifier called the GCLID to ad clicks when auto-tagging is on, and that value can travel with the lead if your forms capture it. [1]
Rule-based matches connect records that share details: the same email, phone number or project address. These are reliable when the rules are written down and checked. Which email wins when a couple uses two? What happens when one phone number appears on three leads? Rules make those decisions consistently instead of case by case.
Inferred associations are educated guesses: a homeowner mentioned seeing your truck, or a project signed two weeks after a mailer landed in the neighborhood. These can be worth recording, but they should be labeled as inferred and kept apart from confirmed matches.
A few situations need a deliberate rule rather than a default:
- Duplicate records. The same household entered twice should count once, with both records linked.
- Repeat leads. A homeowner who called in January and filled out a form in March is one opportunity with two touches. Decide which source gets credit for the cohort, and keep the others visible.
- Long buying cycles. Group leads by when they arrived, then follow them forward. Don’t mix this quarter’s leads with last year’s signed work.
- Referrals. Ask at intake and record the answer in its own field. Otherwise referrals tend to disappear into whichever channel the homeowner used to find your number.
Some ad platforms can also receive outcome data back from your systems, such as signed or revenue events, through offline conversion imports in Google Ads or Meta’s Conversions API. [2] [3] Whether to send that data, and what to change because of it, is a separate decision. Connecting records doesn’t change your bidding or campaigns on its own.
The principle behind all of this: build the intelligence around how your business actually operates, not around the limits of any one reporting platform. Your stages, your job types, your definitions of qualified and complete. The systems supply the records; the business supplies the meaning.
Know which numbers you can trust
Two systems can report different numbers for the same quarter without either one being wrong.
- Your ad platform counts form submissions, including duplicates and spam.
- Your CRM counts opportunities after someone has qualified them.
- Your accounting system counts invoices when they’re issued and payments when they clear.
- Your project system counts costs as they’re committed and marks completion when the job closes.
They use different definitions, different dates and different identifiers. The job isn’t to declare one of them right. It’s to know which question each one answers, and to reconcile them where they meet.
Seven checks make that practical.
| Check | The question to ask | What a problem looks like |
|---|---|---|
| Source completeness | What share of leads have a recorded source? | A large “unknown” group, or a source field that’s blank for whole months |
| Matching confidence | How many signed projects are linked to an lead by an identifier or a written rule? | Signed work that can’t be traced to any lead, or matches nobody can explain |
| Freshness | When did each system last update? | A connection that stopped weeks ago without anyone noticing |
| Reconciliation to accounting | Do signed values and collections agree with your books? | Collections in the report that don’t match deposits |
| Missing sources | Are some channels never recorded at all? | Referrals, repeat clients or home shows that never appear |
| Estimated versus actual costs | Which profit figures are estimates? | Unfinished jobs reported as if their margins were final |
| Period and cohort consistency | Is every figure measured over the same group and window? | This quarter’s spend divided by last year’s signed work |
None of these needs a precise score to be useful. They need an honest answer.
Sometimes that answer is: “We don’t have enough reliable information to conclude that yet.” That’s not a failure of the reporting. It’s the reporting doing its job. A source with three signed projects can’t tell you much about the next thirty. A cohort where most jobs are still underway can’t tell you final margins. Saying so out loud protects you from confident decisions built on thin evidence.
One illustrative business, from lead to profit
Here’s how the full picture comes together for one illustrative design-build remodeler.
About this example. These figures come from an internal illustrative model built by Lead Care Team. They aren’t client results and aren’t a measured outcome of our service. The model follows one group of leads: those received from January 1 to March 31, 2026, with their outcomes followed through September 30, 2026. It assigns every lead to a source for simplicity; real records rarely manage that, as the previous section explains.
| Stage | Figure | What it answers |
|---|---|---|
| Marketing spend | $66,000 | What did it cost to produce these leads? |
| Leads | 412 | How much demand did that spending create? |
| Signed projects | 42 | How much of that demand became work? About 1 in 10. |
| Signed contract value | $2,040,000 | What was the work worth when signed? |
| Collected by September 30 | $1,338,000 | How much cash has arrived? About two thirds of signed value. |
| Expected gross profit | $622,000 | What’s the signed work on track to earn? About 30% of signed value. |
| Completed projects | 24 of 42 | How much of that is final? |
| Actual gross profit on completed projects | $318,000 | What has finished work actually earned? |
Each line answers a different question, and none of them answers the others.
The $702,000 not yet collected is the difference between signed value and collections. With 18 projects still underway, most of it reflects work that hasn’t been billed or completed yet. The model doesn’t separate amounts that are overdue from amounts not yet due; a real build would, because those call for different conversations.
The $622,000 in expected gross profit is two different kinds of number added together: $318,000 of actual gross profit on the 24 finished projects, and $304,000 estimated on the 18 still underway. The second part depends on estimates holding, and it can change before those jobs are done.
Neither figure is net profit. Overhead, salaries, vehicles, insurance and the owner’s pay all come out of gross profit before anything is left.
Even counting only finished work, actual gross profit of $318,000 is well above the $66,000 the whole cohort cost to market. That’s a fair conclusion. What the business can’t yet say is what all 42 projects will finally earn.
The same cohort, by source
| Source | Marketing spend | Leads | Signed | Signed value | Expected gross profit | Finished so far |
|---|---|---|---|---|---|---|
| Lead marketplace | $30,000 | 184 | 6 | $168,000 | $38,000 | 5 of 6 |
| Paid search | $18,000 | 96 | 9 | $414,000 | $120,000 | 5 of 9 |
| Organic search | $6,000 | 58 | 10 | $520,000 | $161,000 | 6 of 10 |
| Referrals | $3,000 | 41 | 14 | $812,000 | $268,000 | 6 of 14 |
| Social media | $9,000 | 33 | 3 | $126,000 | $35,000 | 2 of 3 |
The pattern is clear enough to ask about. The lead marketplace produced 45% of the leads and 6 signed projects, with $38,000 in expected gross profit against $30,000 in spend. Referrals produced 10% of the leads and 14 signed projects, with $268,000 in expected gross profit.
It isn’t clear enough to act on blindly, for five reasons:
- Small numbers. Three to fourteen signed projects per source means one large job can swing the result.
- Estimates inside the totals. For referrals, $109,000 of the $268,000 is actual; the rest depends on unfinished work.
- Spend that isn’t comparable. The $3,000 against referrals doesn’t capture the cost of the work that earned those referrals, so dividing profit by it overstates the comparison with paid channels.
- One quarter. Season, crew capacity and pricing changes all sit inside these numbers.
- No straight lines. A source that returned well on $18,000 won’t necessarily return the same rate on $36,000.
The useful output is a short list of questions worth investigating, not a budget decision.
Find what deserves attention
Connected intelligence earns its keep by pointing your attention. Here are the questions it can answer, area by area, with what each one needs.
Marketing. Which sources produce customers who sign profitable work? This needs lead channels matched to signed projects and, over time, to actual gross profit.
Sales. Where are qualified opportunities stalling, and what are they worth? This needs pipeline stages, proposal values and the date of the last real conversation. In a separate illustrative snapshot of open proposals as of September 30, 2026, 24 proposals worth $1,390,000 were open, and 9 of them, worth $604,000, had gone 21 days or more without a two-way conversation. No recovery rate is assumed; the point is knowing which ones deserve a call this week.
Estimating. Which kinds of work finish above or below the margin you bid? This needs the bid margin from the estimate and the actual margin from final job costs. This example uses a different illustrative group, projects completed from October 1, 2025 to September 30, 2026, not the lead cohort above.
| Project type | Completed | Revenue | Margin bid | Margin achieved | Gross profit versus bid |
|---|---|---|---|---|---|
| Additions | 8 | $1,640,000 | 28% | 19% | $147,600 below |
| Kitchens | 16 | $1,380,000 | 33% | 33% | On bid |
| Whole-home | 3 | $1,050,000 | 27% | 23% | $42,000 below |
| Bathrooms | 20 | $760,000 | 37% | 38% | $7,600 above |
| Basements | 6 | $410,000 | 28% | 27% | $4,100 below |
Additions stand out: the largest revenue category, finishing nine points below the margin they were priced at across eight projects. Three whole-home projects are too few to call a pattern.
Collections. How much signed work is uncollected, and how much of that is tied to projects still underway rather than overdue invoices? This needs contract values, billing schedules and payments.
Profitability. Which project types produce the strongest actual gross profit? This needs completed, costed projects grouped the way you sell them.
Data reliability. Which conclusions are weakened by missing job costs, unreliable sources or incomplete records? This needs the seven checks above, run every time.
Keep four things separate
A finding becomes useful when everyone knows how far it has traveled. Using the additions example:
| Stage | Example |
|---|---|
| Observation | Additions finished nine points below their bid margin across eight completed projects. |
| Hypothesis | The estimate template underprices something specific to additions, such as structural work, permitting time or site conditions. |
| Recommendation | Price the next additions from the actual costs of recent ones, and review the estimate template line by line. |
| Confirmed outcome | Only after the next additions are finished and costed. Until then, the recommendation is a reasonable bet, not a result. |
The same discipline applies to marketing. A higher historical return in one channel is an observation. Moving budget is a test, with a defined way to judge it, not a conclusion.
Turn information into decisions
Intelligence becomes valuable when it reaches a regular decision. A monthly business review is the simplest way to make that happen. A useful one answers five questions:
- What changed? Since last month, in leads, signed work, collections and margins.
- What’s working? Where results are strong, and whether the evidence is solid.
- What’s underperforming? Where results are weak, and whether that’s real or a data gap.
- Where are the biggest opportunities? Stalled proposals, margin gaps, sources worth testing.
- What should we investigate or decide next? With an owner and a date for each item.
Quarterly planning steps back further:
- Review three months of evidence together.
- Choose a small number of priorities, usually three or fewer.
- Agree on the actions and who owns each one.
- Define in advance how success will be judged.
- Revisit the results at the next planning session, and keep or change course.
You can run both yourself with the structure above. The Revenue Decision Playbook goes further, with a worked monthly review, a quarterly plan and a decision register you can download. What changes with an independent advisor is judgment: someone who knows your numbers, has no stake in any channel or vendor, questions the assumptions behind a conclusion, and helps you decide what matters most. At Lead Care Team, monthly business reviews and quarterly planning are part of the Revenue Intelligence + Advisor and Revenue Intelligence + Agency Oversight plans. The Revenue Intelligence Stack keeps the intelligence built and maintained for you to use on your own, without advisory meetings. You make the decisions either way.
Keep the intelligence useful
A connected financial picture isn’t a one-time dashboard project. Several things change underneath it.
- Connections change. Software updates, permissions expire and fields get renamed. A connection that quietly stops leaves a gap that looks like a slow month.
- Processes change. You add a pipeline stage, a new lead channel or a new type of work. Each needs to be mapped before it can be counted.
- Definitions evolve. What counts as a qualified opportunity, or how a job-cost category is split, shifts as the business grows.
- Records arrive late. Final costs can land months after the lead. A cohort’s numbers should be updated as jobs finish, and earlier reports restated, so you’re always looking at the best available figures.
That’s why building the intelligence and maintaining it are separate pieces of work. At Lead Care Team, a one-time intelligence build creates the picture around your business; it starts at $3,000, and the final investment depends on the systems we connect and the complexity of your business. The monthly service keeps it working. Routine maintenance of the agreed integrations, data-quality monitoring and keeping your views current are part of every plan. New integrations, moving to a new system, rebuilding years of old records and new custom development are scoped and quoted separately. Plans are month-to-month and can be cancelled anytime. See plans and pricing.
Assess your own revenue visibility
Use these questions to see where your picture is complete and where it isn’t. There’s no score. For each one, either you can answer it reliably today, or the right column shows what you’d need.
| Can you reliably answer this? | What you’d need to answer it |
|---|---|
| For last quarter’s leads, which lead channels produced signed projects? | lead channels matched to signed contracts, with an “unknown” group you can see |
| How much of your signed value has been collected, and how much is tied to work still underway? | Contract values, billing schedules and payments for the same projects |
| What actual gross profit did last year’s completed projects earn? | Final revenue, including change orders, and final job costs per project |
| Which types of work finish above or below the margin you bid? | Bid margins from estimates and actual margins from job costing, by project type |
| What share of signed work has no reliable source? | A source field captured at intake and checked against the CRM |
| Which qualified opportunities have stalled, and what are they worth? | Pipeline stages, proposal values and the date of the last real conversation |
| How current and complete are the numbers you’re looking at? | Last-updated dates for each system and a monthly reconciliation to accounting |
| Do these numbers reach a monthly decision? | A standing review with owners, dates and a record of what was decided |
Where you can’t answer yet, the worksheet below is the place to start.
The Revenue Intelligence Mapping Worksheet
The worksheet turns the questions you care about into a map of where each answer comes from and whether you can trust it today. It works with or without us.
The template opens in any spreadsheet. It starts with the eight business questions from the assessment above; add your own. For each row:
| Column | What to write |
|---|---|
| Business question | The decision-relevant question, in plain words |
| Metric needed | The number that would answer it |
| Source system | Where each part of the number lives |
| Record identifier or matching method | How records connect: an ID, a written rule or an inferred link |
| Reporting period or cohort | The group and window the number covers |
| Metric definition | Exactly how it’s calculated, including what’s in and out |
| Known gaps or limitations | What’s missing, estimated or uncertain |
| Responsible owner | Who keeps this number accurate |
| Trustworthy today? | Yes, Partly or No, with a word on why |
| Next validation action | The single next step to make it more reliable |
Start with three questions, not twenty. Fill in what you know, mark what you don’t, and pick one validation action per row. The illustrative sample shows the same columns completed for the example business in this guide.
If you’d like help building this around your own systems, book a Revenue Clarity Call. We’ll talk through the numbers that matter to you and what it would take to connect them.
Sources and notes
- Google Ads Help, “About auto-tagging.” https://support.google.com/google-ads/answer/3095550
- Google Ads Help, “About offline conversion imports.” https://support.google.com/google-ads/answer/2998031
- Meta for Developers, “Conversions API.” https://developers.facebook.com/docs/marketing-api/conversions-api/
The worked examples use Lead Care Team’s internal illustrative model: an lead cohort received January 1 to March 31, 2026, followed through September 30, 2026; a set of projects completed October 1, 2025 to September 30, 2026; and an open-proposal snapshot as of September 30, 2026. None of it is client data or a measured result of our service. Platform capabilities vary by account, plan and configuration, and connecting any specific system depends on what that system allows.