Read the full story
The fixture list was never the hard part. The hard part was everything around it: knowing who could realistically get to each ground, finding out about a change before the analyst did, chasing confirmations, covering a call-off at short notice, and then working out at month end who was owed what. Recruitment had the same problem: knowing where cover was short before a match went unstaffed, and finding people who live near those grounds.
We built the coordinator's whole operation into one system, around the way it was already run. The fixtures come in from the public feeds every hour. The allocation is prepared from each analyst's availability, real driving time, tier, existing games and the coordinator's own rules, and the coordinator approves it. Everything the analysts need to be told is drafted for the coordinator to send; nothing goes out until it is approved.
94 analysts and approximately 240 matches a month, through one operating view.
- The analysts. Who they are, where they live, which tiers they are cleared for, their holidays, and a personal page each where they see their games.
- The allocation. Prepared from the rules, driving times and availability; re-run when the rules change, with an undo; never touching a game the analyst has already been told about.
- Changes and call-offs. A moved kick-off, a postponement or a replay is seen on the feed and the affected analysts are listed. A call-off brings up the cover for one-tap approval, and nobody is sent back to a game they declined.
- The communications. Monthly fixture lists, new-game and change emails, stand-downs, a Monday check-in where each analyst confirms or calls off from a link on their phone, chasers and day-before texts, all in the coordinator's own words.
- Recruitment. A coverage map shows the grounds where cover is short. From any of them, the coordinator writes to the nearby clubs, one email each from their own mailbox, and the replies come back into the campaign. Applicants register online, are sent for training, and are tracked from first contact to their first match.
- The checks. The month compared against the customer's own fixture sheet and payment sheet, difference by difference, and the weekly confirmation list for the customer produced from what was actually confirmed.
- Expenses and payments. Fees by tier, mileage from the coordinator's own rate table, expenses the coordinator can override, and each analyst's monthly statement emailed from the system.
- Invoicing. The month's invoice to the customer is built from the games actually covered, checked line by line, and raised straight into the coordinator's QuickBooks with one click.
- The record. Every change, send and decision in one activity log.
"I came to Bob with a job that was consuming far too much of my time every month. The role involves placing around 200 to 320 matches a month across Scotland with more than 94 freelance analysts, previously all on spreadsheets, emails and phone calls. Bob took the time to learn how we actually work, rules and quirks included, and built a system that does the heavy lifting. It crews the month, messages the analysts, chases confirmations, spots matches that change at the last minute, and works out everyone's pay and mileage. It has cut my admin from around 30 hours a week to about 3, which allows me to focus on managing my team rather than drowning in admin.
What stands out is his urgency. When I ask for a change, it is done the same day, every time. He treats my problems like they are his own."
Warren Hawke, Founder, Strenua