The Scenario
You run a thirty-person digital agency. You have a CRM, a time tracker, a project management tool, and an accounting system. None of them speak to each other in a way that gives you an operational picture of the agency at any given moment. You know utilisation matters. You know project margin matters. You know which clients are profitable, roughly, by feel rather than by figure.
Every Tuesday your operations lead pulls together a “weekly numbers” document by exporting CSVs from four tools and pasting them into a spreadsheet. By the end of it she has a snapshot — utilisation by team, WIP by project, write-offs by client, and the rough margin position for the month. You read it on Wednesday morning. Decisions made on Thursday and Friday are made against figures that are a week out of date.
The Problem
The recognisable frustration is the way you find out about problems. You find out a project has slipped over budget when a designer mentions she is “still on that thing” at the standup. You find out a client is unprofitable when the year-end accounts land. You find out a team member is at 110% utilisation when they start missing deadlines. Every operational issue at the agency is discovered after the fact, because the data that would have shown it earlier was buried inside an export that nobody had run.
The cost is the agency’s own margin. Overruns that could have been caught in week one of a project run for three weeks. Scope creep that could have been pushed back on goes unbilled. Clients who should have had their retainer increased two quarters ago are still on the rate from when they signed. None of these are dramatic individually. Collectively they are the difference between a healthy agency and an exhausted one.
The Approach
An agency operations dashboard pulls live data from each of the four tools through their APIs and presents the operational picture you actually run the business on. Utilisation is calculated nightly from time tracker entries against contracted hours. WIP is calculated from logged time at billable rates against agreed budgets per project. Margin is calculated from billable hours against the cost base loaded from payroll. Pipeline health comes from the CRM, weighted by stage.
The dashboard is built on a reporting and dashboard system and uses API integrations to the four core tools. The point is not to replace any of them. The point is to make the picture they collectively hold visible without anyone rebuilding it manually each week. Alerts fire when a project crosses 80% of its budget, when utilisation crosses thresholds in either direction, or when a retainer client’s hours exceed their agreed scope two months in a row.
The Outcome
Your operations lead stops being a report assembler and goes back to being an operations lead. The weekly numbers document still exists, but it is generated from the dashboard rather than rebuilt from scratch, and it takes her twenty minutes instead of half a day. You catch project overruns in week one because the budget alert fires the moment time logged crosses the threshold, not three weeks later when the invoice is being prepared.
The Tuesday-Wednesday lag disappears. When you sit down with a department lead on a Thursday, you both look at the same live picture of their team’s utilisation, WIP, and margin. Conversations stop being about what the numbers were last week and become about what to do about the numbers right now. Over a year, the agency’s effective margin improves not because anyone is working harder but because problems are being caught at the point they can still be fixed.
Who This Applies To
Managing directors, operations directors, and finance leads at agencies between fifteen and a hundred and fifty people — particularly digital, marketing, design, PR, and consultancy firms running multiple concurrent projects across a billable team. If you have a CRM, a time tracker, a project tool, and an accounting system, and none of them speak to each other, this is the situation.
Sound Familiar?
If your weekly numbers document is a spreadsheet rebuilt by hand every Tuesday, the data is fine — it is the pipeline that is missing. We build agency operations dashboards on top of the time, project, CRM, and accounting tools agencies already run. Let us walk through what yours would look like.