Most agencies have a data problem. Not a shortage of data, a surplus of it, scattered across project management tools, time trackers, spreadsheets, CRMs, and someone's personal Notion doc that they swear they will share "soon."
The result is that agency leaders make gut-feel decisions about the most consequential questions in their business: Are we profitable? Are we overutilized? Is this client relationship healthy? Is our pipeline strong enough to cover next quarter's payroll?
A well-built agency operations dashboard does not require a BI analyst, a six-month implementation, or a $2,000/month enterprise tool. It requires four metrics, a clear definition and formula for each, and 30 minutes of focused setup. This article gives you all three.
Why most agency dashboards fail
Before building anything, it is worth understanding why previous attempts probably did not stick.
Vanity metrics dominate. The most common agency dashboards track things like total revenue, number of active clients, and social media impressions. These numbers feel good to look at, especially during growth phases, but they do not tell you whether the business is healthy or heading for a cliff. Revenue of $500K means nothing without knowing whether it cost you $480K or $320K to generate it.
Too many tools, no integration. Your time is tracked in Harvest. Your projects live in Asana. Your proposals are in PandaDoc. Your CRM is HubSpot. Nobody has the 10 hours a week required to manually reconcile these systems into a coherent picture, so nobody does. The dashboard becomes a weekend project that never happens.
No single source of truth. Different people define "utilization" differently. Your ops lead counts internal meetings as billable time. Your senior strategist does not. Your PM only counts hours logged against active projects. When the same metric means different things to different people, the dashboard creates arguments rather than alignment.
No action triggers. A dashboard that shows you a number without telling you what to do with it is just decoration. The best dashboards do not just report state, they surface when something is off and needs intervention. If your utilization drops below 65% for two consecutive weeks and nobody is automatically flagged to investigate why, the dashboard is not doing its job.
The fix for all of these: fewer metrics, explicit definitions, and thresholds that trigger action.
How healthy is your agency? Take the free 10-question Agency Health Score quiz and get a personalized diagnostic across scoping, pricing, delivery, and client management. Take the quiz →
Metric definitions: agree on these before you build
Most dashboards fail at the definition layer, not the spreadsheet layer. Before you write a single formula, write down exactly what each term means so two people updating the same sheet produce the same number. Here are the working definitions this dashboard uses.
- Available hours: headcount multiplied by working days multiplied by 8, minus holidays, PTO, and any planned internal time. This is the denominator for utilization.
- Billable hours: time logged directly against a client project that you can invoice for. Internal meetings, business development, and "learning time" are not billable.
- Direct costs: billable hours multiplied by your blended internal team rate, plus external costs like subcontractors, tools, and stock assets.
- Blended team rate: your average fully-loaded internal cost per hour across the people on a project, used as a cost figure, not a client rate.
- Qualified opportunity: a deal in your pipeline that has a real budget, a decision-maker, and a defined need. Tire-kickers do not count.
- Win rate: the percentage of qualified opportunities that become signed contracts, measured over a trailing period.
Paste these definitions at the top of your dashboard. They are the difference between a tool that aligns your team and one that starts arguments.
The 4 metrics every agency must track
After stripping out everything that is interesting but not actionable, four numbers tell you almost everything you need to know about whether your agency is running well.
1. Utilization rate
Utilization is the percentage of your team's available hours that are spent on billable client work. It is the single most important operational metric for a services business because it directly ties labor cost, your largest expense, to revenue generation.
Utilization Rate = (Billable Hours / Available Hours) × 100
Available Hours = Headcount × Working Days × 8 hours/day
(subtract holidays, PTO, and planned internal time)
A team of 8 full-time employees has roughly 1,360 available hours per month (8 people × 170 hours). If they log 952 billable hours, utilization is 70%.
Target range: 65 to 80% billable utilization. Below 65% and you are carrying too much bench time. You are overstaffed relative to current client load, or scoping is too loose. Above 80% and your team is burning out, quality is slipping, and you have no capacity to handle scope creep or pitch new work.
The most common mistake agencies make with utilization: counting internal meetings, business development, and "learning time" as billable. They are not billable. Define this clearly before you build the dashboard, or you will game yourself into thinking you are healthy when you are not. For why pushing this number too high backfires, see the agency utilization trap.
2. Margin per project
Revenue is what you invoice. Margin is what you keep. Most agency leaders know their overall gross margin reasonably well. Far fewer know the margin on individual projects, which means they cannot tell which clients are profitable, which service lines are dragging down the business, or whether their pricing is calibrated to actual delivery costs.
Project Margin = ((Project Revenue − Direct Costs) / Project Revenue) × 100
Direct Costs = Billable Hours × Blended Team Rate + External Costs
(subcontractors, tools, stock assets, etc.)
Example: You invoice a client $18,000 for a website project. Your team logs 120 hours at a blended rate of $85/hour (internal cost), plus $400 in stock photography. Direct cost = $10,600. Margin = ($18,000 − $10,600) / $18,000 = 41%.
Target range: 45 to 65% gross margin per project for a healthy agency. Below 40% consistently means your pricing is too low, your scope discipline is weak, or your team rate is too high relative to what clients will pay. Above 65% on most projects is a signal to invest more in team capacity or raise pricing systematically. If your rates are the issue, our agency rate calculator helps you set a defensible number.
Track this by project, not just by month. A month with good aggregate margins can hide two unprofitable projects that are burning through your best people. You want to catch those early, not when you are reconciling the quarterly P&L.
3. Pipeline velocity
Pipeline velocity tells you how quickly deals are moving from initial conversation to signed contract, and how much revenue those deals represent. It is the metric that bridges your current revenue and your future revenue, and it is almost entirely absent from most agency dashboards.
Pipeline Velocity = (# of Qualified Opportunities × Avg Deal Value × Win Rate) / Avg Sales Cycle (days)
Result = Estimated revenue generated per day from active pipeline
Example: 6 qualified deals in pipeline, average value $22,000, win rate 40%, average sales cycle 30 days. Velocity = (6 × $22,000 × 0.40) / 30 = $1,760 per day.
This number matters because it tells you how hard you need to work to hit next month's revenue target. If your monthly target is $80,000 and your current velocity is $1,760/day, you are generating roughly $53,000/month from pipeline, so you have a gap. Now you can act on it before it becomes a cash flow problem.
Track velocity weekly, not monthly. By the time monthly velocity drops, you are already 30 to 60 days behind on filling the gap.
4. Client health score
A client health score is a composite number that tells you at a glance which client relationships are strong and which are at risk. It is your early warning system for churn, and for expansion opportunities, since the healthiest clients are also the most likely to buy more.
You do not need a sophisticated algorithm. A simple weighted score across four signals works well:
Client Health Score = weighted average of:
• Responsiveness (0–10): How quickly do they reply to briefs, feedback requests, approvals?
• Satisfaction (0–10): Pulse survey or NPS, collected monthly
• Scope Adherence (0–10): Are they frequently adding out-of-scope work? Requesting revisions beyond contracted rounds?
• Payment Timeliness (0–10): Do they pay on time? Any overdue invoices?
Suggested weights: Satisfaction 40%, Responsiveness 25%, Scope Adherence 20%, Payment 15%
A score of 7.5+ is healthy. 5.0 to 7.4 is a relationship that needs attention. Below 5.0 is a red flag. Assign an account lead to investigate and intervene before the client churns or becomes a liability.
Update health scores monthly. It takes about 10 minutes per client once the rubric is defined.
A sample metrics table
Here is what the core of the dashboard looks like once it is populated. Each metric gets a current value, a target, a status, and the action that fires when it crosses a threshold. This is the whole tool in one view.
| Metric | How it is calculated | Healthy target | Current | Status |
|---|---|---|---|---|
| Utilization rate | Billable hours / available hours | 65–80% | 70% | On target |
| Margin per project | (Revenue − direct costs) / revenue | 45–65% | 41% | Watch |
| Pipeline velocity | (Qual. opps × deal value × win rate) / cycle days | Above monthly need | $1,760/day | Act now |
| Client health score | Weighted average of 4 signals | 7.5+ | 6.8 avg | Watch |
Use color the same way: green for on target, yellow for watch, red for act now. The point is to look at this one block and know in 60 seconds whether the business is healthy.
30-minute setup: Google Sheets or Notion
You do not need a purpose-built BI tool to get started. A well-structured Google Sheet or a Notion database will get you 90% of the value in a fraction of the time. Here is the exact setup flow.
Step 1: Create your master data tab (5 minutes)
In Google Sheets, create a tab called Raw Data. Set up these columns:
- Project Name
- Client Name
- Project Revenue (invoiced)
- Billable Hours Logged
- Blended Team Rate ($/hr, internal cost)
- External Costs ($)
- Project Status (Active / Complete / On Hold)
- Month
Pull this data from your time tracker (Harvest, Toggl, Clockify) and your invoicing tool (QuickBooks, FreshBooks, or even your own spreadsheet). If you are logging time manually, this takes 15 minutes once a week. If your time tracker has CSV export, it takes 2 minutes.
Step 2: Build your metrics tab (10 minutes)
Create a tab called Dashboard. Use SUMIF and AVERAGEIF formulas to pull from Raw Data. Calculate:
- Utilization rate this month vs. last month
- Margin per project for all active projects (highlight anything below 40% in red)
- Pipeline summary, total weighted deal value in your CRM, manually updated weekly
- Client health scores, one row per client, auto-calculated from your four input scores
Use conditional formatting aggressively. Green = on target. Yellow = watch. Red = act now. The goal is to be able to look at this tab in 60 seconds and know whether the business is healthy.
Step 3: Add your action triggers (5 minutes)
Next to each metric, add a column called Trigger. Define the thresholds:
- Utilization below 65% for 2+ weeks → Review staffing and pipeline
- Project margin below 40% → Review scope, flag for pricing conversation
- Pipeline velocity below $1,500/day → Activate new biz outreach
- Client health score below 5.0 → Schedule relationship call within 5 business days
These triggers are what transform the dashboard from a reporting tool into a management tool. Write them down. Share them with your team. Make sure everyone knows what happens when a threshold is crossed.
Step 4: Set your update cadence (5 minutes)
Decide now who updates what, and when. A sustainable cadence:
- Weekly (Monday morning, 15 min): Update billable hours, pipeline deals, any new invoices
- Monthly (first Friday, 30 min): Update client health scores, calculate margin on completed projects, review triggers
- Quarterly (1 hour): Review trends, adjust thresholds, assess whether the dashboard is actually driving decisions
Assign a single owner for the weekly update. Shared ownership means nobody does it.
Step 5: Share and review (5 minutes)
Share the dashboard with your leadership team with view access. Add a standing 15-minute "dashboard review" to your weekly all-hands or leadership sync. The goal is not to dig into every number, it is to identify anything red and assign an action before the meeting ends.
Common dashboard anti-patterns
You have built the dashboard. Now the main risk is letting bad habits undermine it. Here are the patterns that kill ops dashboards within 60 days of launch:
Tracking too much. Every week someone suggests adding a new metric. "Can we add average project duration? What about revision rounds per project? What about hours per deliverable type?" These are interesting questions, but adding them to the dashboard before you have established a baseline habit of reviewing the core four metrics dilutes focus. Resist for the first 90 days. Master the four, then expand.
Inconsistent definitions. Two people updating the spreadsheet with different ideas of what counts as "billable" will produce garbage data. Write a one-page definitions document. It does not need to be elegant, just clear. Paste it at the top of the spreadsheet as a comment or a dedicated tab.
Not updating it. This is obvious, but it bears saying: a dashboard that is 3 weeks stale is worse than no dashboard. It creates false confidence. Build the update process into an existing workflow, tack it onto the end of a meeting that already happens, or set a recurring calendar reminder with a time-boxed commitment. If it takes more than 20 minutes to update, simplify it.
No action taken on red metrics. The fastest way to kill a dashboard culture is to have the team stare at a red utilization number for three weeks without anyone doing anything about it. The first time a trigger fires, respond visibly. Call the meeting. Make the decision. Close the loop. People will take the dashboard seriously when they see it actually drives action.
Confusing dashboards with strategy. A dashboard tells you what is happening. It does not tell you why or what to do about it. Do not make the mistake of replacing strategic thinking with dashboard review. The dashboard is an input to the conversation, not a substitute for it.
When to graduate to more advanced tools
A Google Sheet handles most agencies well up to about 15 to 20 people or $3 to 4M in revenue. Beyond that, the manual update burden and the limitations of spreadsheet visualization start creating friction. Here is when to consider graduating:
Looker Studio (formerly Data Studio) is the right move when you want automated data pulls from multiple sources (Google Sheets, your project management tool, your CRM) without manually copying numbers each week. It is free, relatively easy to set up with Google connectors, and produces shareable visual dashboards that non-spreadsheet people will actually use. Expect 4 to 8 hours to set up properly the first time.
Databox makes sense when you need live data from 10+ integrations (HubSpot, Harvest, QuickBooks, Asana, etc.) and you want pre-built agency metric templates rather than building from scratch. It starts at around $47/month for the features that matter. Worth it when manual updates are eating more than 2 hours per week of someone's time.
Mosaic or Vantagepoint are purpose-built agency financial intelligence platforms. They go well beyond dashboards into forecasting, resource planning, and profitability modeling. Consider these when you are north of $5M in revenue, have a dedicated ops or finance person, and are making complex resourcing decisions across 20+ concurrent projects. Pricing starts at $500+/month.
Rule of thumb: upgrade tools when the cost of the tool is less than the labor cost of maintaining the manual version. A $100/month tool that saves your ops lead 5 hours/month pays for itself at a $25/hour blended rate. At a $75/hour rate, it pays for itself in 80 minutes.
Most agencies over-invest in tooling before they have validated that they will actually maintain the discipline to review the data. Start simple. Build the habit. Then upgrade the infrastructure.
The margin tracking problem nobody talks about
Here is the honest bottleneck in all of this: accurate margin tracking requires accurate scope-to-actuals data. That means you need to know what you planned to spend on a project and compare it against what you actually spent.
Most agencies do not have this because their scopes are built in proposals that live in one tool, their time is tracked in another tool, and nobody reconciles the two until the project is over, at which point the damage is done.
A $30,000 branding project scoped for 180 hours that ends up consuming 260 hours did not fail at delivery. It failed at scoping. But if you do not have a structured scope document tied to your time tracking, you will never see that pattern clearly enough to fix it systematically.
This is exactly the problem ScopeStack was built to solve. When your scopes are structured and standardized from the start, with hours, rates, and deliverables defined clearly, margin tracking becomes a byproduct of your normal workflow instead of a quarterly forensic exercise.
Frequently asked questions
What metrics belong on an agency operations dashboard?
Four metrics cover most of agency health: utilization rate (are people working on the right things), margin per project (is the work profitable), pipeline velocity (is future revenue funded), and a client health score (are the relationships stable). Master those four before adding anything else.
What tool should I use to build an agency operations dashboard?
Start with a Google Sheet or Notion database. They get you 90% of the value with a 30-minute setup and work well up to roughly 15 to 20 people or $3 to 4M in revenue. Graduate to Looker Studio, Databox, or a purpose-built platform only when manual updates cost more in labor than the tool would.
How often should an agency update its dashboard?
Update billable hours, pipeline, and invoices weekly (about 15 minutes). Update client health scores and completed-project margins monthly (about 30 minutes). Review trends and adjust thresholds quarterly. A single named owner for the weekly update is what keeps it from going stale.