The Agency Dashboard: 8 Metrics Worth Checking Every Week

Most agencies produce some kind of monthly management report. It usually arrives a week or two after the month has ended, after someone has exported data from several systems and pieced it together in a spreadsheet. By the time leadership reads it, the numbers describe a situation that has already changed.

Monthly reports still have a place, particularly for financial reporting and longer-term trends. But for running the agency day to day, a live dashboard reviewed every week is far more useful. It lets you spot capacity problems before they cause missed deadlines, budget overruns while there is still time to correct them, and cash flow issues before they become urgent.

The secret is focus. A dashboard with forty charts gets ignored. A dashboard with a handful of well-chosen metrics, reviewed consistently, changes how the agency is run. Here are eight metrics worth checking every week, and what each one tells you.

1. Utilisation. Utilisation measures how much of your team’s available time is spent on billable client work. It is one of the most important indicators of agency health, because people’s time is what you sell. Track it for the agency as a whole, by team and by individual. Low utilisation may mean you have more capacity than work, or that time is being lost to internal tasks. Very high utilisation, sustained over several weeks, is a warning sign of burnout and a lack of buffer for the unexpected.

Look at both billable utilisation and total time logged. If people are working long hours but billable utilisation is low, something is consuming time that is not being recovered.

2. Capacity forecast. Utilisation looks backwards. A capacity forecast looks forward, comparing the hours your team has available over the next four to eight weeks with the work already booked. It shows which weeks are overloaded, which roles are bottlenecks and where there is room to take on new work. Reviewing it weekly gives you time to rebalance work, bring in freelancers or adjust timelines before the pressure arrives.

Together, utilisation and capacity tell you whether the agency is resourced correctly today and whether it will be next month. They are the two numbers most worth discussing in a weekly leadership meeting.

3. Project budget health. For each active project, compare the budget used with the progress made. A simple traffic-light view works well: green for projects on track, amber for those trending over and red for those already over budget or at serious risk. The aim is not to review every project in detail every week, but to quickly identify the handful that need attention.

Projects that move from green to amber deserve a conversation with the project manager. Often there is a clear reason, such as extra scope from the client, and the right response is a change request rather than absorbing the cost.

4. Project and client margin. Budget health tells you whether a project is on track against its estimate. Margin tells you whether it is actually making money. Track margin by project and by client, taking into account the real cost of the people who worked on it, not just the hours. Over time, this shows which clients and types of work are most profitable, which is invaluable when deciding where to focus new business efforts.

5. Unbilled work in progress. This is the value of work that has been completed but not yet invoiced. A growing balance of unbilled work is a cash flow risk and often a sign that invoicing is falling behind, milestones are not being closed off or time-and-materials work is not being billed regularly. Reviewing it weekly keeps invoicing on schedule and reduces the chance of disputes over work completed months earlier.

6. Overdue invoices. Profit on paper is not much use if clients are not paying. Track the value and age of overdue invoices, and flag any client whose payments are consistently late. Account managers are often best placed to follow up, since they hold the relationship, but they need visibility of which invoices are outstanding. A weekly check means overdue payments are chased promptly rather than discovered at the end of the quarter.

Unbilled work and overdue invoices sit at either end of the same process. One shows how quickly you turn completed work into invoices, the other how quickly those invoices turn into cash. Both directly affect the agency’s ability to pay its people and invest in growth.

7. Retainer usage. Retainers provide valuable recurring revenue, but they are also prone to over-servicing. For each retainer, track hours used against the monthly allowance and how far through the month you are. A retainer that is 75% used in the first week needs a conversation, either to prioritise the remaining work or to discuss additional hours. Over several months, consistent overuse is a strong case for revisiting the retainer’s scope or fee.

8. Pipeline and forecast revenue. Finally, look ahead at the work you expect to win. Track the value of proposals in the pipeline, weighted by the probability of closing, alongside confirmed revenue for the coming months. Combined with your capacity forecast, this tells you whether the agency is heading for a busy period that needs extra resources or a quieter one that needs more new business activity.

A dashboard is only valuable if it leads to decisions. A few principles help:

• Review it at the same time every week, with the same people, so it becomes a habit rather than an occasional exercise.
• Focus on exceptions. Spend time on the metrics and projects that have changed or moved outside acceptable ranges, not on everything that is fine.
• Assign actions. Every issue raised should leave the meeting with an owner and a next step.
• Trust the data. If people doubt the numbers, they will ignore them. Accurate, timely time tracking is the foundation of almost every metric on this list.
• Keep it live. A dashboard built manually each week will eventually be skipped. Automating it from your source systems keeps it current with no extra effort.

Finally, resist the urge to keep adding metrics. If a new number earns its place on the dashboard, consider whether an existing one can be removed. Eight metrics that everyone understands will do more for the agency than thirty that nobody looks at.

Graysync’s business intelligence tools turn live project and financial data into dashboards and reports, so the metrics above are always up to date. Because projects, people, time, budgets and invoices all live in one connected platform, there is no need to export, reconcile or rebuild reports by hand. You simply open the dashboard and see where the agency stands.