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.

By Lead Care Team. Updated October 13, 2026. 18 min read.

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.

MeasureWhat it tells youWhere it usually livesWhat it can’t tell you
Marketing activityWhat you spent and how many leads it producedAd platforms, call tracking, website formsWhether any of it turned into work
Sales activityWhich leads became consultations, estimates and proposalsCRM, estimating softwareWhat was actually signed
Signed workThe value of contracts you’ve won, including approved change ordersProposal software, CRM, contractsHow much cash you have, or what the work will earn
CollectionsPayments actually receivedAccountingWhether the job is profitable
Expected gross profitContract value minus actual costs to date and estimated costs still to comeJob costing plus estimatesThe final result, which can still change
Actual gross profitFinal revenue minus final job costs, on completed projectsJob costing and accountingOverhead 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.

  1. 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.
  2. Qualified opportunity. The project fits your work, location, timing and budget range. You learn how much real demand the lead represented.
  3. Consultation. You meet, visit the site or review plans. You learn where your sales time goes.
  4. Estimate or proposal. You price the work. You learn what the opportunity is worth and the margin you priced in.
  5. Signed contract. The homeowner commits. You learn the value of the work won.
  6. Collections. Deposits, progress payments and the final payment arrive. You learn when the cash actually comes in.
  7. Job costs. Labor, materials, subcontractors and permits accumulate. You learn what the work is costing against what you bid.
  8. Completed project. The work is finished and the final invoices are in. You learn the final contract value, including change orders.
  9. 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.

SystemWhat it usually holdsWhat can link it to the others
Google Ads, Meta and other ad platformsSpend, campaigns, clicksClick identifiers on the visit, campaign tags, dates
Website forms and call trackingLead time, landing page, source tags, caller numberForm or call record, email, phone, click identifier where captured
CRM and sales pipelineContacts, opportunities, stages, outcomesCRM contact and opportunity IDs
Estimating and proposal softwareEstimates, proposals, contract value, change ordersProposal or job number, customer name and address
Project management and job costingBudgets, committed and actual costs, completionJob number
Accounting and invoicingInvoices, payments, cost entriesCustomer 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.

CheckThe question to askWhat a problem looks like
Source completenessWhat share of leads have a recorded source?A large “unknown” group, or a source field that’s blank for whole months
Matching confidenceHow 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
FreshnessWhen did each system last update?A connection that stopped weeks ago without anyone noticing
Reconciliation to accountingDo signed values and collections agree with your books?Collections in the report that don’t match deposits
Missing sourcesAre some channels never recorded at all?Referrals, repeat clients or home shows that never appear
Estimated versus actual costsWhich profit figures are estimates?Unfinished jobs reported as if their margins were final
Period and cohort consistencyIs 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.

StageFigureWhat it answers
Marketing spend$66,000What did it cost to produce these leads?
Leads412How much demand did that spending create?
Signed projects42How much of that demand became work? About 1 in 10.
Signed contract value$2,040,000What was the work worth when signed?
Collected by September 30$1,338,000How much cash has arrived? About two thirds of signed value.
Expected gross profit$622,000What’s the signed work on track to earn? About 30% of signed value.
Completed projects24 of 42How much of that is final?
Actual gross profit on completed projects$318,000What 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

SourceMarketing spendLeadsSignedSigned valueExpected gross profitFinished so far
Lead marketplace$30,0001846$168,000$38,0005 of 6
Paid search$18,000969$414,000$120,0005 of 9
Organic search$6,0005810$520,000$161,0006 of 10
Referrals$3,0004114$812,000$268,0006 of 14
Social media$9,000333$126,000$35,0002 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 typeCompletedRevenueMargin bidMargin achievedGross profit versus bid
Additions8$1,640,00028%19%$147,600 below
Kitchens16$1,380,00033%33%On bid
Whole-home3$1,050,00027%23%$42,000 below
Bathrooms20$760,00037%38%$7,600 above
Basements6$410,00028%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:

StageExample
ObservationAdditions finished nine points below their bid margin across eight completed projects.
HypothesisThe estimate template underprices something specific to additions, such as structural work, permitting time or site conditions.
RecommendationPrice the next additions from the actual costs of recent ones, and review the estimate template line by line.
Confirmed outcomeOnly 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:

  1. What changed? Since last month, in leads, signed work, collections and margins.
  2. What’s working? Where results are strong, and whether the evidence is solid.
  3. What’s underperforming? Where results are weak, and whether that’s real or a data gap.
  4. Where are the biggest opportunities? Stalled proposals, margin gaps, sources worth testing.
  5. What should we investigate or decide next? With an owner and a date for each item.

Quarterly planning steps back further:

  1. Review three months of evidence together.
  2. Choose a small number of priorities, usually three or fewer.
  3. Agree on the actions and who owns each one.
  4. Define in advance how success will be judged.
  5. 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:

ColumnWhat to write
Business questionThe decision-relevant question, in plain words
Metric neededThe number that would answer it
Source systemWhere each part of the number lives
Record identifier or matching methodHow records connect: an ID, a written rule or an inferred link
Reporting period or cohortThe group and window the number covers
Metric definitionExactly how it’s calculated, including what’s in and out
Known gaps or limitationsWhat’s missing, estimated or uncertain
Responsible ownerWho keeps this number accurate
Trustworthy today?Yes, Partly or No, with a word on why
Next validation actionThe 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

  1. Google Ads Help, “About auto-tagging.” https://support.google.com/google-ads/answer/3095550
  2. Google Ads Help, “About offline conversion imports.” https://support.google.com/google-ads/answer/2998031
  3. 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.

From visibility to confidence

  1. Know your numbers.

    Connect the lead channels, customer journeys, sales outcomes, and project results behind your business.

  2. Know what they mean.

    Recognize meaningful changes and learn which leads and projects are associated with your best work.

  3. Know what to do next.

    Put that knowledge into your next decision, then measure what happens and keep the result.

Your next move deserves the full picture.