The One Spreadsheet Tab That Tells You If Marketing Is Actually Working

07 September 2026·3 min read

Quick answer: You don't need a dashboard or analytics platform to know if marketing is working — you need one spreadsheet tab with five columns: date, lead source, enquiry, outcome, and value. Update it as enquiries come in, and after a month you'll see exactly which channel is actually producing paying clients, not just likes and impressions. 📈

Most small businesses either track nothing (and guess) or track everything (and drown in metrics that don't answer the one question that matters: is this making money?). One simple tab, kept honestly, beats both extremes. 💖

What most businesses get wrong

Tracking vanity metrics instead of outcomes — likes, followers and impressions feel like progress but don't tell you whether any of it converted to revenue.
Not asking every lead where they came from — without a source logged at the point of enquiry, you're reconstructing guesses later, which is unreliable.
Overcomplicating the tracking system — a 20-column tracker that's too tedious to maintain gets abandoned within a month; simple and consistent beats thorough and abandoned.
Never actually reviewing it — a tracker that's filled in but never analysed is just admin, not insight.

The five-column tracker

Columns:
1. Date — when the enquiry came in
2. Source — how they found you (ask directly: "how did you hear about us?")
3. Enquiry type — what they wanted
4. Outcome — booked / didn't proceed / still deciding
5. Value — what the booking was actually worth, if it converted

After 4–8 weeks, pivot or filter by source to see: total enquiries per channel, conversion rate per channel, and total revenue per channel. The channel with the best revenue-per-enquiry, not just the most enquiries, is usually where more investment should go.

Here's how the same simple tool reveals different things for different businesses. 📈

A booking-based business with lots of no-shows: The tracker reveals that Instagram brings the most enquiries, but Google Business Profile bookings actually show up and pay — a distinction that follower counts alone would never have surfaced.

A B2B firm with a long sales cycle: The tracker shows referrals convert at a much higher rate than cold outreach, even though outreach generates more raw enquiries — a case for investing more in referral partnerships over cold prospecting.

A local service business with a seasonal dip: The tracker shows which channel performs best specifically during the quiet season versus the busy one, allowing the marketing focus to shift with the calendar rather than staying static year-round.

Making it easy to actually keep updated

The tracker only works if it's genuinely quick to fill in — link it to your booking or enquiry process so logging the source becomes part of the existing workflow, rather than a separate task that gets forgotten during a busy week.

💡 Heads up: If you run paid ads, cross-check the platform's own reported conversions against this tracker occasionally — ad platforms tend to over-report their own contribution, and your own honest source-tracking is often more accurate than the dashboard.

Mistakes to avoid

Guessing the source instead of asking — assumptions about where leads come from are frequently wrong; always ask directly.
Only tracking wins, not losses — logging enquiries that didn't convert is just as important for understanding what's actually happening.
Changing the tracking method halfway through — keep the columns consistent for at least a full quarter so you can compare like with like.

Frequently asked questions

Do I need proper analytics software instead of a spreadsheet?

Eventually it can help as you scale, but a spreadsheet is genuinely sufficient for most small businesses — the discipline of tracking consistently matters far more than the sophistication of the tool.

What if customers don't remember or won't say how they found me?

Offer a few quick options rather than an open question ("Google, Instagram, a friend, or somewhere else?") — multiple choice gets a far higher response rate than an open-ended ask.

How often should I review the tracker?

Monthly is usually enough to spot meaningful patterns without overreacting to short-term noise — a single unusual week can skew a weekly review in misleading ways.