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 and project margin matter, and 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. A client turns out to be unprofitable when the year-end accounts arrive, and a team member at 110% utilisation only shows up once 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 is dramatic on its own, but they add up across every account.
The Approach
An agency operations dashboard pulls live data from each of the four tools through their APIs and presents the operational picture you 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. None of them is replaced. The dashboard makes 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.
For teams that want visibility into individual contributor output alongside project margin, team productivity dashboards extend the same logic. For the portfolio view across all projects rather than the operational picture, project portfolio visibility handles that layer.
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 become about what to do about the numbers right now, not what the numbers were last week. Over a year, the agency’s effective margin improves because problems are 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 and what is missing is the pipeline. We build agency operations dashboards on top of the time, project, CRM, and accounting tools agencies already run. Get in touch to walk through what yours would look like, or browse our dashboards and visibility use cases to see related work.