Tracking from spend to meeting takes three things: consistent UTM tagging on every link, a results tracker where every enquiry is logged with its source and status, and a weekly report per channel (new leads, response time, meetings, proposals and won value). You don’t need an expensive CRM; a well-built spreadsheet and a few automations are enough.
One lowercase UTM naming convention fixes most tracking errors
Most tracking errors come from the same channel being written three different ways. A simple, all-lowercase standard:
| Parameter | What it identifies | Example |
|---|---|---|
| utm_source | platform | google, meta, linkedin, newsletter |
| utm_medium | type | cpc, paid_social, email, outreach |
| utm_campaign | campaign: country_goal_month | mt_assessment_2026-10 |
| utm_content | creative or variant | video_a, copy_b |
Columns of the results tracker: from first contact to closed deal
Date received, name, company, email, phone, source (UTM), goal, budget, recommended package, status, appointment, showed up, proposal date and value, won date, next step, deadline, owner. Make status a drop-down list: new → contacted → assessment → proposal → won / lost.
What can be automated? New rows, appointments, daily digest and weekly report
- Every enquiry from your web form automatically gets a new row in the sheet, together with its source.
- Calendar bookings update the appointment column.
- A morning digest email shows yesterday’s new enquiries and overdue deadlines.
- Every Monday: a weekly report by channel.
The four numbers your weekly report needs
- New leads per channel
- Median response time
- Assessment / meeting rate
- Proposal and won value
Once these four numbers are visible week after week, moving budget between channels becomes a decision based on data rather than opinion.