You've worked hard to get your website live, your Google Business Profile optimised, and your calls-to-action clear. Visitors are finding you. Some are even reaching out.
But here's the uncomfortable question: Do you actually know how many enquiries you received last week? Or where they came from?
If you can't answer that confidently, you're flying blind. You don't know which marketing efforts are working, which channels to invest more in, or whether your website is converting visitors at all. Without tracking, you're guessing—and guessing costs money.
The good news? You don't need expensive software or complex dashboards. You need a simple, reliable system that captures every enquiry, categorises the source, and gives you the data to make smart decisions.
This guide will show you exactly how to set up a basic lead tracking system in under 30 minutes—using tools you already have.
Jump to:
Quick Start: Set Up Your Tracking Spreadsheet (5 Minutes)
This is the fastest path to functional lead tracking. You'll create a simple spreadsheet that captures the essential information you need to understand where your enquiries come from.
#
Five Steps to Basic Tracking
Step 1: Create Your Lead Log
Open Google Sheets or Excel and create a new file titled "[Your Business Name] Lead Log." Save it somewhere you can access quickly—ideally bookmarked in your browser or pinned to your desktop.
Step 2: Add the Five Essential Columns
Create these column headers:
- •Date (when the enquiry came in)
- •Lead Name (or company name)
- •Source (how they found you: Google, Facebook, referral, direct call, etc.)
- •Service Requested (what they're interested in)
- •Status (New, Contacted, Quoted, Won, Lost)
That's it. Don't add more columns yet. These five capture everything you need to start making decisions.
Step 3: Connect Your Website Forms
Check that your website contact form sends you an email notification when someone submits it. If it doesn't, fix that now. Every form submission should trigger an immediate email to a dedicated address you check daily.
This builds on ensuring your CTAs are clear and functional, which we covered in Write CTAs That Actually Get Clicks.
Step 4: Log Your Last Three Leads
Think back to your last three enquiries—whether they came via email, phone, or form. Add them to your spreadsheet now. This establishes your baseline and helps you practice the logging habit.
Step 5: Make It Accessible
Put the link to this spreadsheet in your browser bookmarks bar, or create a desktop shortcut. The easier it is to access, the more likely you are to use it consistently.
#
✅ Completed the quick version? Move on to Simple Follow-Up System for Enquiries or continue below for the detailed walkthrough.
Complete Step-by-Step Guide: Building a Reliable Tracking Funnel
Now let's build a more robust system that captures every enquiry automatically, tracks sources accurately, and gives you the data you need to scale what's working.
Step 1: Define the Sources You Must Track
Before you can track effectively, you need to know where enquiries can come from. For most micro-businesses, there are typically 4-6 main sources:
Digital sources:
- •Website contact form
- •Direct email to your business address
- •Social media messages (Facebook, Instagram, LinkedIn)
- •Google Business Profile messages or calls
Offline sources:
- •Direct phone calls
- •Walk-ins or in-person enquiries
- •Referrals from existing customers
- •Networking events or word-of-mouth
Write down your specific sources. Be realistic—if you're not actively using Instagram, don't add it to your list yet. Focus on the channels you're actually using.
For a deeper understanding of how to categorise and analyse these sources, see Track Where Your Leads Come From.
Step 2: Automate Form Tracking (The Email/CRM Connection)
Your website contact form is likely your highest-volume source. You need to ensure every submission is captured automatically.
Set up email notifications:
Most form builders (Contact Form 7, Gravity Forms, Typeform, Google Forms) can send an email notification when someone submits. Configure this to send to a dedicated email address—ideally something like `leads@yourbusiness.com` or a Gmail address you check daily.
Create an email filter:
In Gmail or Outlook, create a filter that:
- •Identifies emails from your form (usually they have a consistent subject line like "New Contact Form Submission")
- •Applies a label like "🔥 NEW LEADS"
- •Marks them as important or stars them
This ensures you never miss a form submission in your inbox.
Optional: Connect to a spreadsheet automatically
If you're using Google Forms, submissions automatically populate a Google Sheet. For other form builders, tools like Zapier (free tier available) can automatically add form submissions to your spreadsheet.
Step 3: Integrate Call Tracking (Unique Numbers)
Phone calls are harder to track than digital enquiries, but they're often your highest-value leads. Here's how to track them without expensive software.
Use Google Business Profile insights:
If you display your phone number on your Google Business Profile, Google tracks how many people click to call. Check your insights monthly to see call volume trends.
Assign unique numbers to different channels:
If you're running multiple marketing campaigns (Google Ads, Facebook, print advertising), consider using different phone numbers for each. Services like Google Voice (free) or low-cost virtual number providers let you set up multiple numbers that forward to your main line.
When someone calls, you'll know which number they dialled—and therefore which campaign drove the call.
Ask every caller: "How did you hear about us?"
The simplest method is often the best. Train yourself (and any staff) to ask this question on every call. Log the answer immediately in your spreadsheet.
The worst thing is thinking you're tracking leads only to find your forms broke last month. This is one of the essential technical checks NetNav runs automatically across your whole site to ensure lead flow remains uninterrupted. Run a check now to validate your form connections.
Step 4: Choose Your Low-Tech Tool
You have two realistic options for micro-businesses: a spreadsheet or a simple free CRM.
Option 1: Spreadsheet (Best for <10 leads/month)
Pros:
- •Free
- •Flexible
- •No learning curve
- •Works offline
Cons:
- •Manual data entry
- •No automation
- •Limited reporting
Best for: Solo operators, service businesses with low enquiry volume, anyone just starting to track.
Option 2: Simple Free CRM (Best for 10-30 leads/month)
Tools like HubSpot (free tier), Streak (Gmail plugin), or Trello (Kanban board) offer basic CRM functionality at no cost.
Pros:
- •Visual pipeline management
- •Some automation possible
- •Better for team collaboration
- •Email integration
Cons:
- •Learning curve
- •Requires internet connection
- •May have feature limitations on free tier
Best for: Growing businesses, teams of 2+, anyone who wants visual pipeline management.
For a detailed comparison and setup guide, see Simple CRM for Tiny Businesses.
My recommendation: Start with a spreadsheet. Upgrade to a CRM only when you're consistently logging 10+ leads per month and the spreadsheet feels limiting.
Step 5: Log Essential Metrics
Now that you're capturing enquiries, you need to track the right data points. Don't overcomplicate this—focus on what actually helps you make decisions.
Essential data points:
- Date received (helps you spot seasonal trends)
- Lead name/company (for follow-up)
- Source (where they found you—this is the most important field)
- Service requested (helps you understand what people want)
- Status (New, Contacted, Quoted, Won, Lost)
Optional but valuable:
- Estimated value (if you quote projects, track the quote amount)
- Notes (any relevant context)
Calculate your Cost Per Lead:
Once you have a month of data, you can start calculating how much each lead costs you. If you spent £200 on Google Ads and received 10 enquiries, your cost per lead is £20.
This metric tells you which channels are cost-effective and which are too expensive. For the full calculation method, see Calculate Your Cost Per Lead and Cost Per Customer.
Step 6: Set Response Standards
Tracking enquiries is pointless if you don't respond to them promptly. Now that you're logging every lead, you need a standard for how quickly you'll respond.
Research shows:
- •Responding within 5 minutes increases conversion by 900% compared to 30 minutes
- •78% of customers buy from the first responder
- •After 24 hours, your chances of conversion drop dramatically
Set your standard:
- •Ideal: Respond within 1 hour during business hours
- •Minimum: Respond within 24 hours, every time
- •Automated: Send an immediate auto-reply acknowledging receipt
For detailed guidance on building response time into your workflow, see Set Your Response Time Standard.
#
🎉 Completed? You now know exactly where your leads come from, which is vital data for investment decisions. You're ready for Simple Follow-Up System for Enquiries.
Troubleshooting
What's Next: Close the Loop
You're now tracking where your enquiries come from. The next critical step is ensuring you respond to them consistently and effectively.
Next Blueprint Step:
Simple Follow-Up System for Enquiries
Once you're tracking leads, you need a standardised process to nurture and respond to them. This guide shows you how to build a simple follow-up system that ensures no enquiry falls through the cracks.
Go Deeper
Map Your Lead Flow from Visitor to Customer
For the full guide on visualising the entire process a prospect takes from first click to final sale, see this deep dive.
Learn how to use the data you just collected to calculate how effective your website actually is at turning visitors into tracked leads.
Other Get Customers Guides
- •Creating a "Service Menu" PDF to Send Leads
- •How Do I Get More Enquiries?
- •Build a Simple Webinar to Generate Leads
- •What Is a Sales Funnel (Without the BS)?
- •Email Marketing Basics for Micro Businesses
- •Create Simple Landing Pages Without a Developer
You've completed setting up your essential lead tracking system. Now you have the data you need to make decisions. NetNav can audit your entire site across 9 pillars in 60 seconds—see what else needs attention before you scale your marketing spend.