A Source Field on Every Enquiry

Stop letting agencies sell you on “omnichannel attribution modeling” and expensive SaaS subscriptions that require a degree in data science just to read. I’ve spent eleven years in the trenches with firms that have zero marketing budget, and I am sick of seeing small business owners get blamed for “poor ROI” because they couldn’t afford a $500-a-month tracking tool. If you are currently staring at a messy inbox wondering how to track enquiry sources simply without losing your mind or your profit margin, you don’t need a dashboard; you need a system that actually works.

I’m not here to give you a theoretical lecture or show you a single slide with a funnel on it. Instead, I’m going to show you how to build a manual tracking process that you can set up in under two hours using nothing but a basic spreadsheet. My promise is straightforward: I will provide practical, number-driven methods that a single person can manage in an afternoon, ensuring you finally know exactly where your money is working and where it is being wasted.

Set Up Simple Lead Capture Systems Today

Stop looking for a magic software solution. If you are a team of one or two, you don’t need a dashboard that costs more than your monthly rent; you need simple lead capture systems that actually work. Start with your contact forms. If you use a website builder or a basic plugin, ensure there is a mandatory “How did you hear about us?” dropdown menu. Don’t make it an open text box—people are lazy and will just type “Google” or “Internet” every time, which tells you absolutely nothing. Give them four or five specific options like LinkedIn, Referral, or Local Search.

Once that’s live, connect your forms directly to a single, shared spreadsheet. I don’t care if it’s Google Sheets or Excel; just make sure every new enquiry automatically populates a new row with a timestamp and that source dropdown value. This is the most basic form of measuring inquiry origins without needing a degree in data science. If a lead comes in via a phone call, your only job is to make sure whoever picks up the phone asks the question and types the answer into that same sheet. If you can’t do it in under ten minutes, your system is too heavy.

Measuring Inquiry Origins Without the Complexity

Stop looking for a dashboard that tells you everything. Most small firms get trapped in a cycle of buying expensive software to figure out their customer acquisition channels, only to realize they don’t have the time to actually interpret the data. You don’t need a complex suite of lead attribution methods to see what’s working. If a client calls you and says, “I saw your post on LinkedIn,” write that down. If they mention a specific flyer, note it. That is your data.

The most effective way to handle measuring inquiry origins is to add one single column to your existing spreadsheet or CRM: “How did you hear about us?” It sounds insultingly basic, but it works. I’ve seen consultants spend weeks trying to map out digital touchpoints when the reality is that most of their actual business comes from a single, unrecorded referral or a local community group.

Don’t over-engineer this. If you can’t update your tracking log in the thirty seconds it takes to log a new enquiry, your system is broken. Focus on the high-level truth of where the money is coming from, rather than chasing every single click that doesn’t result in a sale.

5 Ways to Stop Guessing Where Your Leads Come From

• Add a “How did you hear about us?” dropdown to your contact form. Don’t leave it as an open text box; people are lazy and will just type “Google” or “Internet.” Give them specific options like “LinkedIn,” “Word of Mouth,” or “Local Event” so you actually get clean data.
• Use a dedicated email address for your different channels. If you’re running a specific local flyer, use [email protected]. If it’s for your website, use hello@. When the emails hit your inbox, you’ll know exactly which campaign triggered the enquiry without opening a single dashboard.
• Create a “Source” column in your existing spreadsheet or CRM immediately. Every time a new name comes in, you must manually type in where they originated. If you don’t record it within ten seconds of the enquiry arriving, you’ve already lost the data forever.
• Stop over-complicating UTM parameters. If you’re posting a link on LinkedIn, just add a simple tag to the end of the URL so you can see it in your basic web analytics. You don’t need a degree in data science to see which link actually got clicked.
• Ask the question out loud. If a lead comes in via a phone call, ask them, “Just so I know how to reach more people like you, how did you find us?” It takes five seconds, it’s polite, and it’s more accurate than any expensive tracking pixel.

The Bare Essentials

Stop looking for “attribution software” and start using a simple spreadsheet to log exactly where every single enquiry came from.

If your enquiry form doesn’t have a “How did you hear about us?” field, add one before lunch; it’s the highest-ROI move you’ll make all week.

If you can’t explain where your last five leads came from in under ten minutes, your tracking system is too complicated and needs to be scrapped.

Stop Guessing and Start Recording

Look, we have covered enough ground to get you moving. You don’t need a $500-a-month attribution platform or a degree in data science to figure out where your money is coming from. All you need is a basic way to capture the lead—whether that’s a dedicated contact form or a simple question on your intake sheet—and a single spreadsheet to log the answer. If you can spend one afternoon setting up a way to ask “How did you hear about us?” and a column to record it, you have already done more than most of your competitors. Stop overthinking the technical architecture and just start logging the data that actually matters to your bank balance.

The goal isn’t to build a perfect marketing engine; it is to stop throwing expensive pebbles into a dark well. Every time you spend time or money on a channel, you deserve to know if it’s actually hitting the mark. You don’t need a complex dashboard to tell you that your local networking event brought in three high-value clients while your expensive LinkedIn ads brought in zero. Trust your gut instinct combined with these simple numbers. Get the system running by the end of the day, and let the reality of your own results guide your next move. Keep it practical, keep it simple, and just keep track.

Frequently Asked Questions

What do I do if a customer says they found me through "Google" but doesn't specify if it was an ad or a search result?

Stop obsessing over the distinction. If they say “Google,” they’re in your ecosystem. For a small firm, the difference between a paid click and an organic search is a rounding error compared to the bigger question: did they actually convert? Just log them as “Google” in your spreadsheet. If you want more precision, check your Google Ads dashboard for spend vs. site traffic, but don’t let a lack of granular data paralyze your afternoon.

Is it worth spending time setting up UTM parameters, or is that overkill for a one-person operation?

If you’re running everything yourself, don’t get lost in a UTM rabbit hole. It’s overkill if you’re just posting a link on LinkedIn once a week. However, if you’re running even a tiny bit of paid spend or sending out a weekly newsletter, spend one hour setting up a simple spreadsheet template. Use basic tags so you aren’t guessing which link actually moved the needle. If it takes more than an afternoon to manage, stop doing it.

How do I stop my spreadsheet from becoming a cluttered mess after just two weeks of data entry?

Stop adding columns every time you think of a new question. That’s how spreadsheets die. Pick five essential data points—Date, Name, Source, Service, and Value—and stick to them. If you need more detail, use a “Notes” column for the messy stuff. Use a simple dropdown menu for your “Source” column so you don’t end up with “Google,” “google,” and “goog” as three different entries. Keep it rigid, or it will break.

If I'm getting leads from word-of-mouth, how do I actually record that without it feeling like guesswork?

Stop guessing. If someone calls you saying “Dave sent me,” that’s a lead. Open your spreadsheet—the one you should already be using—and add a column titled “Referral Source.” Don’t just write “Dave”; write “Dave Smith (Personal Referral).” If it’s a repeat thing, note the company. It takes five seconds during the initial enquiry. If you aren’t recording the name of the person who opened the door, you aren’t tracking; you’re just hoping.