How to Build an Agency
Operations Dashboard
in 30 Minutes

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'll 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 ops dashboard doesn't require a BI analyst, a six-month implementation, or a $2,000/month enterprise tool. It requires four metrics, a clear formula for each, and 30 minutes of focused setup. This article gives you all three.

Why Most Agency Dashboards Fail

Before building anything, it's worth understanding why previous attempts probably didn't 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 don't 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 doesn't. 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 don't just report state — they surface when something is off and needs intervention. If your utilization drops below 65% for two consecutive weeks and nobody's automatically flagged to investigate why, the dashboard isn't doing its job.

The fix for all of these: fewer metrics, explicit definitions, and thresholds that trigger action.

The 4 Metrics Every Agency Must Track

After stripping out everything that's 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's the single most important operational metric for a services business because it directly ties labor cost — your largest expense — to revenue generation.

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–80% billable utilization. Below 65% and you're carrying too much bench time — you're 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're not billable. Define this clearly before you build the dashboard, or you'll game yourself into thinking you're healthy when you're not.

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 can't tell which clients are profitable, which service lines are dragging down the business, or whether their pricing is calibrated to actual delivery costs.

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–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.

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're 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's the metric that bridges your current revenue and your future revenue, and it's almost entirely absent from most agency dashboards.

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're generating roughly $53,000/month from pipeline — 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're already 30–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's your early warning system for churn — and for expansion opportunities, since the healthiest clients are also the most likely to buy more.

You don't need a sophisticated algorithm. A simple weighted score across four signals works well:

A score of 7.5+ is healthy. 5.0–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.

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's 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're 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 isn't to dig into every number — it's to identify anything red and assign an action before the meeting ends.

Common Dashboard Anti-Patterns

You've 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've 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 doesn't 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's 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's happening. It doesn't tell you why or what to do about it. Don't 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–20 people or $3–4M in revenue. Beyond that, the manual update burden and the limitations of spreadsheet visualization start creating friction. Here's 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's free, relatively easy to set up with Google connectors, and produces shareable visual dashboards that non-spreadsheet people will actually use. Expect 4–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're 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.

Most agencies over-invest in tooling before they've validated that they'll 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's 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 don't 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 didn't fail at delivery. It failed at scoping. But if you don't have a structured scope document tied to your time tracking, you'll 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.

The Bottom Line

A good agency ops dashboard isn't about having the fanciest tool or the most comprehensive data set. It's about knowing four numbers, knowing what they mean, knowing what to do when they go wrong, and actually doing it.

Utilization tells you if your team is working on the right things. Margin tells you if the work is profitable. Pipeline velocity tells you if the future is funded. Client health tells you if the relationships that drive it all are stable.

Those four numbers, reviewed weekly, will surface 80% of the problems that kill agency businesses before they become fatal. The setup takes 30 minutes. The discipline to keep it current is the harder part — but that's a management problem, not a tools problem.

Build it this week. Review it Monday. Act on what's red. Repeat.