Follow your marketing leads through to the work and revenue
If your marketing report ends at the lead, bring the office and job records into the same review. You should be able to follow a request into a quote, accepted work, completed service and revenue. I'll use a fictional cleaning business to show the worksheet and calculations. The method works for bus
Editorial Team
Heaviside Digital

If your marketing report ends at the lead, bring the office and job records into the same review. You should be able to follow a request into a quote, accepted work, completed service and revenue. I'll use a fictional cleaning business to show the worksheet and calculations. The method works for businesses in Cincinnati and nationwide when the service and records are defined correctly.
1. Choose a period and define the customer you can serve
Choose a complete first-contact period with enough records to inspect the pattern, then record its acquisition dates and a separate outcome review date so later progress stays attached to the same group.
Write a fit definition using the business's real services and territory. For the fictional cleaning company:
A business requesting recurring office cleaning within our confirmed area, with a contact who can coordinate a walkthrough. Residential cleaning requests are outside this campaign's intended service.
That makes the campaign's purpose clear. It doesn't make every other service request worthless. If the company offers another service, route the lead appropriately and preserve what the person originally asked for.
2. Match contact attempts to opportunities
Join calls and forms about the same request under one opportunity while retaining the individual contact attempts, and keep separate jobs distinct even when the same customer requested them.
Use these columns:
| Field | Example entry |
|---|---|
| Opportunity ID | CL-101 |
| First received | October 2 |
| Source | Search Ads, organic, referral or unknown |
| Requested work | Recurring office cleaning |
| Fit | Confirmed fit, mismatch or unknown |
| Contact outcome | Reached, pending callback or no usable details |
| Sales stage | Walkthrough, estimate, accepted, declined or unresolved |
| Work outcome | Scheduled, started, completed or cancelled |
| Evidence | Link to the customer record |
Keep contract value distinct from work actually delivered. For a recurring service, an accepted agreement doesn't mean every future month of revenue has been earned.
3. Calculate a worked example
Suppose this fictional business spent $1,800 on one campaign during the selected month. It received 30 unique leads. Eighteen fit the intended service, eight were confirmed mismatches and four remained unknown.
Of the eighteen fit leads, ten booked walkthroughs. Six accepted proposals, and four had begun service by the review date. Two accepted customers were waiting for their agreed start dates.
| Measure | Calculation | Result |
|---|---|---|
| Cost per unique lead | $1,800 ÷ 30 | $60 |
| Cost per confirmed fit lead | $1,800 ÷ 18 | $100 |
| Cost per booked walkthrough | $1,800 ÷ 10 | $180 |
| Cost per accepted customer | $1,800 ÷ 6 | $300 |
| Cost per customer started so far | $1,800 ÷ 4 | $450 |
The denominator changes the question. Label it every time. The four unknown leads also belong in the report so nobody mistakes incomplete follow-up for a fully measured funnel.
4. Find the decision in the records
Read the mismatch reasons. If several people requested residential cleaning, inspect the ad and destination page. Does the copy make the commercial scope clear? If the service was clear but the search intent wasn't, review the campaign evidence.
For fit leads that didn't book, inspect handling and availability. A pending callback needs an owner. A customer who couldn't arrange a walkthrough needs a recorded scheduling reason. Those observations lead to different work.
For sent proposals, ask what is still open. A buyer awaiting approval belongs in a pending state, with an agreed next action where possible. Silence doesn't establish that price was the problem.
Use this action record:
Evidence: [Opportunity IDs and observed issue]. Change: [Specific action]. Owner: [Person]. Date: [When changed]. Expected effect: [The stage that should improve]. Review: [Comparable next group and date].
5. Check the report before changing the budget
Trace several rows back to the source and job records. Reconcile the number of unique leads. Check that cancellations update the original opportunity and that repeat calls didn't inflate the total.
Compare groups with similar time to reach an outcome. If the newest group has had only three days to decide, it won't compare fairly with last month's group after six weeks of follow-up.
When tracking is incomplete, show the unknowns and fix the collection process. A precise-looking cost per customer is less useful than an honest report showing where evidence is missing.
Heaviside Digital can review this with businesses in Cincinnati and across the country. If you want help, bring the current lead and job records to a marketing consultation. The worksheet works with a basic spreadsheet as well as a customer management system.
Download the working files
Share this article
Help others discover this content
About Heaviside Digital
We help local businesses get found in search and make it easier for a website visitor to contact them. Our work also covers advertising and the follow-up that turns a new lead into a conversation.
Learn more about usContinue Reading

What a Local Rank Grid Actually Tells You About Google Maps
One map ranking can look fine while most of your service area cannot find you. Learn how to read a local rank grid and choose the next action.

How to Use AI Tools to Save Time on Marketing Without Losing Your Voice
Discover how digital marketing agencies can harness AI to draft campaign copy and repurpose client wins faster without producing bland, cookie-cutter content that alienates prospective clients.

Answer Engine Optimization — The SEO Strategy Nobody Is Talking About Yet
For agencies helping local brands scale, traditional SEO tactics are missing half the equation. Dive into Answer Engine Optimization (AEO) tailored for digital marketing firms, and learn how to optimize your agency's online presence to be cited directly by ChatGPT and Google Overviews.
