How to Attribute Leads to the Right Channel Without Fancy Software

Most small businesses spend money on marketing without knowing which part of it works. They post on social, run ads, hand out cards at events, get referrals, and then look at end-of-month revenue and wonder what moved the needle. That is not marketing. That is hoping.

Attribution does not require a six-figure software stack. You can track leads by source with a spreadsheet and a bit of discipline, and it will tell you more than most dashboard tools that nobody updates.

Why Owners Get This Wrong

The first problem is relying on platforms to self-report. Meta will tell you an ad generated 40 leads. Google will say it generated 30. Add those up and you have 70 leads from digital alone, yet you only closed 20 new clients. The platforms are counting different things, claiming the same conversions, and optimizing for their own metrics, not yours.

The second problem is only tracking the last touch. Someone sees your Instagram post, Googles your name a week later, and then books a call. Google gets the credit in most analytics setups. Instagram was the actual catalyst. Without tracking both, you cut the wrong channel.

The third problem is not asking. The simplest attribution tool on earth is asking every new contact "how did you find us?" and writing down the answer. Most businesses never do it consistently.

The CFO Perspective

Marketing spend is an investment. Like any investment, you want to know the return. If you are spending $2,000 a month across three channels and you do not know which one is generating closed revenue, you cannot make a rational decision about where to put next month's dollar.

A consulting firm was spending roughly equal amounts on Google ads, a sponsored newsletter, and attending a monthly industry event. After six months of tracking leads by source, the data showed the event generated 60% of their closed revenue despite being the smallest line item. They doubled the event budget, cut the newsletter, and held Google ads flat. Revenue per marketing dollar went up materially without increasing total spend.

The data was not complex. It was a column in a spreadsheet that someone filled in for every new conversation.

How to Build the Tracking System

1. Create a lead log spreadsheet. Columns: date contacted, name, source (where they came from), stage (lead, proposal sent, closed, lost), and close date. That is it. Five columns.
2. Define your sources clearly and keep the list short. Examples: Google Search, Google Ads, Instagram, referral from client, referral from partner, event, cold outreach, other. Pick the categories that match your actual channels and do not add more than 8 to 10.
3. Ask every single contact how they found you. Add it to your intake form if you have one. Ask verbally in the first conversation if you do not. Log the answer immediately. Do not try to reconstruct it later.
4. Track to close, not just to lead. A channel that generates 20 leads that never close is worse than a channel that generates 5 leads that all close. Update the stage column when deals move. Revenue is the only metric that matters.
5. Review the data monthly. Calculate three numbers for each source: total leads, closed revenue, and cost. That gives you cost per closed lead by channel. The channel with the best ratio deserves more budget. The one with the worst ratio deserves a hard look.
6. Use UTM parameters for digital channels. If you send email campaigns or run ads, add a UTM source tag to every link. Free to set up, works with Google Analytics, and makes it easy to confirm which digital channel sent traffic that converted.

What to Do When a Lead Has Multiple Touches

It happens. Someone found you on Instagram, attended a webinar, then got referred by a client. Pick the rule you will use and apply it consistently. The most practical approach for a small business is to credit the first touch for awareness and the last touch for the close. Record both in your log and note when a referral was the final push. Over time, patterns emerge about which channels warm leads and which ones close them.

You do not need perfect attribution. You need directionally accurate data that lets you stop wasting money on channels that are not converting and put more into ones that are. The difference between gut feel and a simple spreadsheet is often tens of thousands of dollars a year in marketing spend.

If you want help building a marketing budget that ties spend to actual revenue, book a free call at peterxiacpa.com/book.

Next step: run your numbers through the free CFO scorecard.