From 30 hours a week to 3: rebuilding a coordinator's whole operation
One coordinator was running a workforce of 94 freelance analysts from spreadsheets, an inbox and a phone. It took around 30 hours a week. It now takes about 3. This is how, and what other businesses can take from it.
The job
Warren Hawke, founder of Strenua, places a freelance analyst at every professional football match in Scotland: between 200 and 320 matches a month, with more than 94 analysts spread from the Borders to the far north. Who covers what, holidays, call-offs, postponements, television changes, cup replays, confirmations, expenses, pay and recruitment all ran through one person.
It lived in spreadsheets, an inbox and a phone. Every fixture change meant an evening of calls. Month end meant working out, by hand, who was owed what for which games and how many miles.
What we learned by watching the work
The fixture list was never the hard part. The hard part was everything around it:
- Knowing who could realistically get to each ground, given where they live, what tier they are cleared for and what else they are covering that weekend.
- Finding out about a change before the analyst did, not after they had driven to an empty stadium.
- Covering a call-off at short notice without sending someone back to a game they had already declined.
- Knowing where cover was thin before a match went unstaffed, and finding people who live near those grounds.
None of that was written down. It was in one person's head, which is the most common, and most fragile, process in any small business.
What we built
- The allocation. Prepared from each analyst's availability, real driving time, tier, existing games and Warren's own rules. Warren approves it, and it never moves a game an analyst has already been told about.
- Changes and call-offs. Fixtures are read from the public feeds every hour. A moved kick-off or a postponement lists the affected analysts. A call-off brings up the nearest free cover for one-tap approval.
- The messages. Monthly fixture lists, change emails, a Monday check-in where each analyst confirms from their phone, chasers and day-before texts, all in Warren's own words, all approved before they go.
- Recruitment. A map of the grounds where cover is short, campaigns to nearby clubs from Warren's own mailbox, and every applicant tracked from first contact to first match.
- The checks. Each month compared, difference by difference, against the customer's own fixture and payment sheets.
- Pay and invoicing. Fees by tier, mileage from Warren's own rate table, a monthly statement emailed to each analyst, and the customer's invoice raised straight into QuickBooks with one click.
The result
Around 27 hours a week back. Over a year that is about 1,400 hours, roughly 35 working weeks of one person's time, now spent managing the team and growing the business instead of administering it.
In Warren's words: "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. When I ask for a change, it is done the same day, every time."
What other businesses can take from it
- Write down the rules in the person's head. Most of the value came from capturing Warren's judgement, not replacing it.
- Prepare, do not decide. The system prepares every allocation, message and invoice. Warren decides. That is why he trusts it.
- Catch changes early. Checking the feeds every hour turned last-minute emergencies into routine updates.
- Keep changing it. The rules changed several times in the first season. Because changes are part of the service, they were made the same day instead of waiting for a new project.
Have a job like this? Tell us in a few lines what gets copied, checked or chased by hand. We will come back with questions, not slides.
Book a callNext: Why salespeople do not update the CRM, and what to do instead