There's a scene that plays out in almost every insight consultancy sooner or later. A senior researcher turns out to be committed to two projects in the same fortnight. Or a study overruns because nobody clocked that the project lead was on leave for a chunk of fieldwork. Or the MD loses an evening to hand-assembling a utilisation report for the next morning's board meeting.
Then comes the line everyone recognises: "We really can't keep running this out of a spreadsheet."
Heads nod. A tool gets trialled, or the master sheet gets a redesign. Six months on, the agency is still running on Excel — just with a few more tabs and a little less trust in the numbers.
What follows is an attempt to explain why that loop repeats, and what boutique qual and quant agencies can actually do to break out of it.
Give the spreadsheet its due
Spreadsheets haven't survived this long by accident. They cost nothing, they bend to any process, and nobody needs training to open one. For an agency of four or five people, a shared sheet genuinely is the right tool.
What kills it isn't headcount — it's operational complexity. An eight-person agency can be in worse trouble than a thirty-person one. The tipping point arrives once you're juggling:
- Several projects running side by side at different stages
- People whose hours vary — part-timers, fractional seniors, freelancers on contracted blocks
- Work in the pipeline that needs resourcing thought before it's even confirmed
- Anyone upstairs asking for utilisation or capacity numbers on a regular basis
Past that point the sheet is no longer where the plan lives — it's where the risk lives. A row doesn't get updated. Someone types into the wrong column. A freelancer's availability shifts and the change never makes it in. What you're looking at is a photograph of last week, presented as though it were live.
"A spreadsheet never lies deliberately. It just has no idea what it's missing — and neither do you, until something collides."
The off-the-shelf detour
The usual next move is a subscription: Monday.com, Asana, ClickUp, Notion. All perfectly good products — for the generic knowledge-work teams they were designed around. Research agencies are not that.
A research project moves through distinct phases — commissioning, design, recruitment, fieldwork, analysis, reporting, debrief — and the people it needs change shape at each one. A quant study might consume a researcher almost entirely during scripting, then barely touch the team during fieldwork. A qual study runs the opposite pattern.
Task-and-deadline tools have no vocabulary for any of this. Crucially, they have no concept of available client hours — the actual currency an agency trades in. They don't know Priya works a 28-hour week, that April's bank holidays quietly delete a day of capacity across the whole team, or that your go-to freelancer offered you 60 hours next month and you've only booked 40.
Can you force a generic tool to model all that? With enough custom fields and discipline, probably. But at that point you've hired yourself as the tool's administrator, and the day job suffers for it.
The four questions a real system has to answer
Ask operations leads and MDs at insight agencies what they actually need, and it distils to four questions:
- What does each project genuinely need this month, in billable hours? Derived from scope — not somebody's hallway estimate.
- What does each person genuinely have to give? Once leave, bank holidays, internal time and part-time patterns are subtracted.
- Where do those two numbers collide? Which months are overheating, who's above capacity, and where real headroom exists to sell.
- What's the freelance position? Who's available, what's already promised to them, what's still in reserve.
Nothing on that list is exotic. The catch is that all four answers have to come from one system, stay current in that system, and surface without anyone doing arithmetic in a side tab.
The gap between winning work and delivering it
Plenty of agencies run their pipeline in Pipedrive or something like it — and it does that job well. But CRMs clock off the moment a deal closes. Delivery is someone else's problem.
That handoff is where trouble breeds. The commercial director can see three probable wins landing inside six weeks; the ops manager hears about them at contract signature. Every resourcing conversation after that is reactive — reshuffling people, ringing freelancers, nudging start dates and calling it strategy.
A planning system worth having accepts pipeline work provisionally. "This tracker is 70% likely. If it lands, it wants Sarah plus one freelancer from July to October — are we covered?" You want to be having that conversation in May, with data. Not in June, with apologies.
Why purpose-built usually wins at this stage
An off-the-shelf tool will get a typical agency 60–70% of the way. If your operation is simple and you're relaxed about bending your process to fit the software, that may be plenty. The agencies that see the biggest payoff, though, are the ones running on software shaped to them — not the reverse.
Shaped-to-you means the system says "studies", "trackers" and "modules" because that's what your team says. It means the workflow mirrors how your projects actually travel from brief to debrief. It means reports organised around the numbers your MD reads, not a dashboard template's guess at them.
Yes, bespoke costs more up front. But the meter never stops running on a tool that almost fits — you pay in workarounds, in maintenance time, in mistakes. And there's a blunter truth underneath: software that mirrors how a team works gets used. Software that doesn't gets abandoned, and you're back in Excel by Christmas.
This is what we build
Insight Planner is our answer to exactly this problem — resource planning software built around how insight consultancies actually operate. If the pattern above feels familiar, we'll happily show you what it looks like for a team your size.
See how it works →Before you buy (or build) anything
If you're knee-deep in tab chaos right now, the first move isn't commissioning software — it's diagnosing precisely what's broken. Four questions worth an honest hour:
- Where does resourcing information actually live today, and whose job is keeping it true?
- What was the most recent thing that went wrong purely because nobody could see the resourcing picture?
- How long does it take to answer "can we take on new work next month?" — and would you stake a client relationship on the answer?
- If you could see live utilisation right now, what would you do differently this week?
The answers point at the right fix surprisingly quickly. Sometimes it's process. Sometimes a lighter tool. Sometimes it's bespoke software. You just can't choose well while you're treating the symptom as the diagnosis.
Ready to see what purpose-built looks like against your own team size, project mix and current setup? We'll walk you through it — no canned demo, no hard sell.