You're Spending $3,200 A Month On Marketing And Have No Idea Which Half Is Working — Here's How To Track Every Dollar From Click To Collected Payment (Free Contractor Marketing ROI Tracker)

By Ryne Bandolik · Jobs Done Labs · July 24, 2026

You just looked at your marketing spend for the month and it hit you: $1,600 to Google Ads, $600 to Facebook, $400 to Yelp, $350 to Angi, $250 to Thumbtack. $3,200 total. And you have absolutely no idea what you got for it. Google says "22 calls." Facebook says "15 messages." Yelp says "8 leads." Angi says "11 leads." Each platform is showing you THEIR version of success — but none of them can tell you which of those 62 "leads" actually turned into a booked job, completed work, collected payment, and profit.

You're making $38,400/year in marketing decisions with ZERO data connecting spend to profit. The platform dashboards are designed to make themselves look good — Google counts a "call" as any phone call lasting over 30 seconds (including the telemarketer who pitched you SEO services for 2 minutes), Facebook counts a "message" as anyone who clicked "Send Message" (including the person who typed "how much?" and never responded), Yelp counts a "lead" as any interaction (including the person who viewed your profile and called 3 other contractors). Angi charges you per lead regardless of whether the lead is real or whether the customer already hired someone else. Every platform's metric is optimized to justify their bill — not to tell you the truth about your ROI.

And the worst part: you're probably profitable on your marketing spend overall — your business is growing. But you're almost certainly wasting 30-50% of your spend on channels or campaigns that don't produce profitable jobs. You just can't prove it because you're not tracking the full journey from ad click → phone call → quote → booked job → completed job → collected payment → gross profit. Every link in that chain is broken. The software industry's answer is CallRail at $45-300/month, WhatConverts at $30-150/month, or ServiceTitan Marketing Pro at $200-500/month — all requiring setup, integration, and ongoing management. But you don't need enterprise call tracking. You need a simple spreadsheet that shows: Channel → Spend → Calls → Quotes → Jobs → Revenue → Profit → ROI. And you need it in 15 minutes a week.

Why every page-1 search result sells you software you don't need

Search "how to track marketing ROI for service business" and every result on page 1 falls into one of four buckets, none of which actually solve your problem: (1) Call tracking SaaS landing pages — CallRail, WhatConverts, Invoca — all positioning their $45-500/month product as "the solution" in blog posts that are really product pages. They show you which channel drove the call but not whether the call turned into a profitable job. (2) Marketing agency blog posts — WordStream, Search Engine Journal, Neil Patel — generic "how to calculate marketing ROI" articles that assume you're an e-commerce business with Google Analytics tracking, not a service business where the "conversion" is a phone call. They tell you to set up conversion tracking that doesn't work for phone-based businesses. (3) Contractor marketing agencies — KickCharge, Contractor Commerce, Blue Corona — pitching their managed services at $1,000-5,000/month. The free "audit" is a sales call. (4) Thin Google Sheets templates shared on contractor forums — basic "spend vs calls" trackers from a well-meaning contractor who built it for their own business. But they don't account for the multi-step conversion path (call → quote → booked → completed → collected) or the gross profit calculation (revenue minus labor and materials). What you won't find: a free, contractor-specific marketing ROI tracker that logs spend per channel, tracks the full lead-to-revenue journey, calculates ROI per channel, and flags channels where spend is growing faster than revenue — the early warning sign of marketing bloat. This is that system.

The 5-sheet free contractor marketing ROI tracker

Each sheet serves one purpose. Together, they answer the only question that matters: "Which marketing channels are making me money, and which are just making noise?" Build this in Google Sheets (or Excel) — one workbook for your entire business, updated in 15 minutes every Monday.

Sheet 1: Monthly Marketing Spend Log

This is your ground truth. Every dollar of marketing spend gets logged here, by channel, by month. The year-over-year comparison column is the canary in the coal mine — when a channel's spend is growing faster than its revenue, you're in marketing bloat territory.

Sheet 2: Lead Source Pipeline

This is the heart of the system. Every lead gets one row. Every row follows the lead through the full pipeline. Nothing falls through the cracks.

Sheet 3: Channel ROI Dashboard

This is the Monday morning view. One row per channel. Auto-calculated from Sheets 1 and 2. This answers the question "should I spend more on Google Ads or Facebook Ads?" with actual data, not gut feeling.

Sheet 4: Monthly Trend View

The 12-month rolling view that catches marketing bloat before it becomes a crisis. This is the strategic dashboard — not the weekly tactical view, but the quarterly trend that tells you whether your marketing investment is getting more or less efficient over time.

Sheet 5: Technician Close Rate by Lead Source

The hidden variable that most contractors never discover: different technicians close different lead sources at wildly different rates. Your best closer should be handling your most expensive leads. This sheet reveals the matchups that maximize ROI.

How to set up basic call tracking without software: the $0 Google Voice method

You don't need CallRail to know which channel drove the call. You need one dedicated phone number per channel and a CSR who asks one question. Here's the $0 setup:

1. Create one Google Voice number per marketing channel. Google Voice is free. Create a Google account for each channel (or use one account — you can have multiple Voice numbers). Set up: Google Ads number, Facebook number, Yelp number, Angi number, Thumbtack number. Each forwards to your main business line. Cost: $0. Time: 30 minutes.
2. Update each platform with its dedicated number. In Google Ads, use the Google Voice number as your call extension. On your Facebook page, list the Facebook Voice number. On Yelp, the Yelp Voice number. Angi and Thumbtack: the Angi and Thumbtack numbers. Now, when a call comes in, you know which channel generated it just by looking at which Voice number rang.
3. Standardize the CSR script. "Thanks for calling [your company name] — and just so I can direct you properly, how did you hear about us today?" This confirms the attribution (the Voice number tells you the channel, but the customer might say "I saw you on Google AND a friend recommended you" — multiple touchpoints). The CSR logs the answer in the "Lead Source" column of Sheet 2.
4. Track the call outcome immediately. Before the CSR hangs up, they log: name, phone, source, and call outcome (booked appointment, quote requested, price shopper, wrong number, etc.). This takes 15 seconds per call. If they don't log it now, it won't get logged.

The 5 marketing metrics that actually matter for contractors (and the 15 that don't)

Marketing platforms will show you dozens of metrics — impressions, clicks, CTR, CPC, quality score, reach, engagement, frequency, CPM, view rate, and on and on. Most of them are noise. Here are the only 5 that matter for a service business:

The 15 metrics that DON'T matter for contractors: impressions, clicks, CTR, CPC, quality score, reach, engagement rate, frequency, CPM, view rate, video completion rate, page likes, post shares, follower count, and "brand awareness." These are platform metrics designed to make the platform look good. They measure the platform's performance, not your business's performance. Ignore them.

The 15-minute weekly marketing review process

This is the discipline that changes everything. Every Monday morning, before you do anything else, the office manager or owner opens the tracker and follows this 5-step process:

1. Pull spend numbers (3 minutes). Log into each platform's billing dashboard. Pull the actual amount charged last week. Log it in Sheet 1. Don't estimate — get the real number from the credit card statement or platform billing page.
2. Log new leads (5 minutes). Go through the CSR log from last week. Enter every lead into Sheet 2: date, source, customer name, call outcome. If the CSR didn't log the outcome, they need to — today. This is the most important 5 minutes of the week.
3. Update pipeline status (3 minutes). For every lead in the pipeline: did the quote go out? Did it book? Was the job completed? Was payment collected? Update the status. This step is where you discover the leads that are stuck — the quote that was sent 3 weeks ago and never followed up on, the job that was completed but the invoice wasn't sent.
4. Review Channel ROI Dashboard (2 minutes). Sheet 3 auto-calculates from Sheets 1 and 2. Scan the ROI column. Any channel with negative ROI? Any channel where spend is up but revenue is flat? These are the decisions: reallocate, restructure, or cut.
5. Adjust next week's budget (2 minutes). Based on the Channel ROI Dashboard, decide where to spend next week's budget. Move money from the worst-performing channel to the best. This is not a big strategic decision — it's a 2-minute reallocation based on data. Over 52 weeks, these small adjustments compound into a marketing budget that's optimized to profit, not to spend.

How to calculate your break-even cost per lead

Before you can evaluate whether a channel is "too expensive," you need to know what you can afford to pay for a lead. The formula:

When to invest in CallRail / ServiceTitan Marketing Pro vs when the spreadsheet is enough

The 5-sheet tracker handles the 80/20 for most contractors. Upgrade to paid call tracking when you hit these triggers:

• $3M+ annual revenue. At this volume, the CSR time savings from automated call attribution (CallRail automatically tags the source) outweigh the $45-300/month cost.
• 5+ technicians running calls. When you have multiple techs running leads from multiple channels, the manual tracking burden multiplies. CallRail's call recording also lets you audit CSR performance — which becomes critical at scale.
• Running ads in multiple metro areas. If you're spending $5,000+/month across 3+ cities, the channel-level attribution isn't enough — you need geo-level attribution too. CallRail's dynamic number insertion handles this automatically.
• You need call recording for CSR training. If you suspect your CSRs are fumbling leads but can't prove it, call recording pays for itself in recovered bookings. One recovered $8,000 HVAC install pays for a year of CallRail.

Before any of these triggers, the spreadsheet is not just sufficient — it's better. It forces the discipline of manual tracking, which builds the habits and processes that make the software useful when you eventually upgrade. Buying CallRail before you have the tracking discipline is like buying a gym membership before you've established the habit of working out — you'll pay for 6 months and never use it.

Red flags: when your marketing is burning cash without you knowing it

• Any channel where spend is growing faster than revenue for 3+ consecutive months. This is the definition of marketing bloat. The channel is becoming less efficient, and you're paying more for each dollar of growth. If Google Ads spend is up 20% this year but Google Ads revenue is up only 8%, you're buying growth at an increasingly expensive rate.
• Any channel with a close rate below 10% after 30+ leads. If 30 people called from a channel and fewer than 3 booked, the problem is either the lead quality (the channel is sending the wrong people) or the CSR/tech handling those leads (the right people are calling but the process is failing them). Either way, fix it or cut the channel.
• Marketing cost above 15% of revenue. For residential service businesses, marketing should be 5-12% of revenue. Above 15% means your marketing is too expensive for your revenue level — you're over-investing relative to your ability to close and deliver.
• CSRs not logging call outcomes. If you can't get your CSRs to spend 15 seconds logging the call outcome, you don't have a marketing tracking problem — you have a management problem. The tracker is useless without the data, and the data starts with the CSR.
• You're making budget decisions based on "how things feel" instead of the Channel ROI Dashboard. Gut feelings about marketing are wrong more often than they're right. The contractor who "feels like Facebook is working" is usually the contractor who's never looked at the data. The data often shows Facebook is great for brand awareness and terrible for booked revenue — the opposite of the gut feeling.

Do this week: your marketing ROI tracker in 2 hours