A Greenwolf Tech Labs site · Our Data Studio agency team, India and USAgreenwolftechlabs.com ↗

Agency operations

Marketing agency KPIs: what to track, how to calculate it, and how to see it weekly

The marketing agency KPIs that matter most are billable utilization, gross margin per client, monthly recurring revenue, client retention and realization rate, because together they show whether the agency makes money on the work it already has. This guide is for agency owners, managing directors and operations leads who track client campaigns closely but see their own numbers once a quarter in a spreadsheet. You get each KPI's formula, the system it comes from, a worked month for a 12-person agency and a one-page dashboard layout you can build in Data Studio.

Agency leadership reviewing marketing agency KPIs such as utilization and margin per client on a Data Studio dashboard
Agency operations6 min readUpdated November 18, 2026 · by Harsh Khubchandani

Quick answer

What KPIs should a marketing agency track?

A marketing agency should track billable utilization, gross margin per client, effective hourly rate, monthly recurring revenue and its movement, client retention, realization rate, revenue concentration, pipeline win rate and days sales outstanding. These measure the agency's own health, which is different from the campaign metrics you report to clients.

  • Separate agency business KPIs from the client campaign metrics you report to clients.
  • Margin per client needs hours logged against each client, not just invoices.
  • Harvest publishes a 70 to 80% utilization target range for marketing agencies.
  • One weekly page beats a quarterly spreadsheet, as long as definitions are written down.
01

Which marketing agency KPIs actually matter?

Nine KPIs cover the business side of most marketing agencies: four on profitability, three on revenue and clients, and two on growth and cash. Track fewer than this and you miss a whole category; track many more and nobody reads the page.

Most articles on this topic mix two different things. Click-through rate, cost per lead and keyword rankings are client campaign metrics. They belong on the reports you send clients, and they tell you whether your work performs. Agency KPIs tell you whether the agency itself is healthy: whether people are busy on paid work, whether each retainer covers its cost, and whether revenue is growing or leaking. An agency can deliver excellent campaign results and still lose money on half its clients.

The table below lists each KPI with its formula and the system that usually holds the data. Formulas are the part most top-ranking guides leave out, and they are where internal arguments start, so agree them in writing before building anything.

KPIFormulaWhere the data lives
Billable utilizationBillable hours / available hours x 100Time tracking tool
Effective hourly rateClient revenue / hours logged on that clientAccounting plus time tracking
Gross margin per client(Client revenue - delivery labour cost - pass-through costs) / client revenueAccounting, time tracking, payroll cost rates
Realization rateValue billed / (hours worked x standard rate)Time tracking plus invoices
Monthly recurring revenue (MRR)Sum of active monthly retainer valuesContracts sheet or CRM
Net MRR changeNew + expansion - contraction - churned MRRContracts sheet or CRM
Client retention rate(Clients at end - new clients) / clients at start x 100CRM or contracts sheet
Revenue concentrationLargest client's revenue / total revenueAccounting
Pipeline win rateProposals won / proposals decidedCRM
Days sales outstandingAccounts receivable / revenue for the period x days in periodAccounting
02

How do you calculate agency utilization rate, and what is a good one?

Billable utilization is billable hours divided by total available hours, multiplied by 100. Harvest, the time tracking company, publishes this formula on its utilization calculator and gives 70 to 80% as the typical target for marketing agencies and 60 to 70% for creative agencies.

Two definitions decide whether the number is useful. Available hours should be contracted hours minus holidays and leave, not a flat 40 per week. Billable hours should include only time that is charged or covered by a retainer, so internal meetings, pitches and training sit outside it. Track utilization per person and per team, because an agency average of 70% can hide one overloaded specialist at 95% and a team at 45%.

Utilization above the target range is not automatically good. It often means there is no time for training, process work or new business, and it is an early warning for burnout and mistakes in client delivery.

03

How do you measure profitability per client?

Gross margin per client is the client's revenue minus the cost of the people who delivered the work and any pass-through costs, divided by the client's revenue. It is the single most useful number an agency owner can see each month, and it needs only three inputs: what the client paid, the hours logged against them, and a loaded cost rate per person.

The loaded cost rate is salary plus employer taxes and benefits, divided by available hours. Your accountant can set one rate per role so individual salaries stay private. Pass-through costs include media you buy on the client's behalf and any tools billed back to them. If you leave media inside revenue, a large ad budget will make a thin retainer look highly profitable.

Effective hourly rate is the companion metric: client revenue divided by hours logged. It shows which retainers have drifted. A client signed at a fair rate two years ago may now take twice the hours because of new channels, extra meetings or a demanding stakeholder.

04

Worked example: one month at a 12-person agency

The figures below are illustrative, not client data. They show how the KPIs connect, using an agency with 12 people, 10 of whom do billable work.

Utilization: each of the 10 billable staff has 140 available hours after leave, so 1,400 hours in total. They log 966 billable hours, a utilization of 69%, just under Harvest's 70 to 80% range for marketing agencies.

Two retainers side by side: Client A pays $6,000 a month and logs 60 hours. Client B pays $4,000 and logs 70 hours. With a loaded cost of $45 per hour, Client A costs $2,700 to deliver, an effective rate of $100 per hour and a gross margin of 55%. Client B costs $3,150, an effective rate of about $57 per hour and a margin of about 21%. On the invoice ledger both look like healthy retainers. Only the hours reveal that Client B needs a scope conversation.

Revenue and retention: the agency starts the month with 24 clients and $96,000 of MRR. It wins 3 clients worth $9,000, expands one retainer by $2,000, reduces another by $1,000 and loses 2 clients worth $5,000. MRR ends at $101,000, a net change of $5,000. Client retention is (25 - 3) / 24, or 91.7%. The headline growth hides $6,000 of lost and reduced revenue, which is why net MRR change belongs on the page next to MRR.

MetricClient AClient B
Monthly retainer$6,000$4,000
Hours logged6070
Delivery cost at $45 per hour$2,700$3,150
Effective hourly rate$100About $57
Gross margin55%About 21%
05

Which client and revenue KPIs predict churn?

Client retention rate, revenue concentration and on-time reporting are the three that warn you earliest. Retention tells you what happened; the other two tell you what is likely to happen next.

Revenue concentration is the share of total revenue from your largest client. When one client is a large share of revenue, losing them can force layoffs, so owners watch this before signing more work from the same account. On-time reporting matters because clients judge agencies on what they see. In the AgencyAnalytics 2025 Marketing Agency Benchmarks report, based on a survey of more than 220 agency leaders, 70% rated client reporting as extremely important for retention and 81% named strong relationships as the top retention driver.

Add a simple client health flag to the dashboard: margin below target, effective rate falling for two months, reports delivered late, or a key contact leaving. Any two flags together justify a call from the account lead.

  • Retention rate: count logos, and track retained revenue separately.
  • Revenue concentration: show the top 5 clients' share of revenue as a bar chart.
  • Realization rate: falling realization usually means unbilled scope creep.
  • Days sales outstanding: slow payers tie up cash even when margins look fine.
06

What should an agency KPI dashboard look like?

An agency KPI dashboard works best as one summary page for the leadership meeting, with drill-down pages behind it. The summary answers whether the agency is on track this month; the drill-downs answer why.

In Data Studio, the summary page uses scorecards with comparison to the previous month and to target, a combo chart of MRR with new and churned MRR as bars, and a table of clients sorted by gross margin with conditional formatting on anything below target. Drill-down pages cover utilization by person and team, margin and effective rate by client over time, and pipeline by stage. A date range control and a team filter cover most questions in the meeting itself.

  • Page 1, Summary: utilization, gross margin, MRR, net MRR change, retention, DSO versus target.
  • Page 2, People: utilization by person and team, billable versus non-billable hours.
  • Page 3, Clients: margin, effective rate and realization per client with health flags.
  • Page 4, Growth: pipeline by stage, win rate, new MRR by source.
  • Scheduled delivery of page 1 as a PDF before each leadership meeting.
07

How do you build an agency KPI dashboard in Data Studio?

The build is mostly data work. Agency KPIs combine at least three systems, time tracking, accounting and CRM or contracts, and they rarely share a clean client ID. The first job is a mapping table that links each client name as it appears in every system to one ID.

For a small agency, a Google Sheet that receives monthly exports from each system and holds the mapping table is enough. Data Studio connects to Sheets natively. For larger agencies or anyone joining more than a few sources, move the data into BigQuery, because Data Studio blends are limited to 5 sources with equality joins only, and margin per client per month needs hours, revenue, costs and contracts joined at the same grain. Calculated fields then hold the formulas from the table above, with CASE statements for categories such as retainer versus project work.

Access needs care. Margin and cost rates are sensitive, so the leadership view and any team view should use separate data sources or Data Studio Pro team workspaces with clear roles. Data Studio Pro costs $9 per user per project per month, and viewers need no licence.

  • Agree KPI definitions and targets in writing first.
  • Build a client ID mapping table across time tracking, accounting and CRM.
  • Land exports in Sheets, or in BigQuery once joins exceed what a blend can hold.
  • Create calculated fields for each formula and reconcile one month by hand.
  • Schedule the summary page to arrive before the weekly or monthly leadership meeting.
08

What mistakes make agency KPIs misleading?

The most common mistake is counting media spend as revenue, which inflates margin on clients with large ad budgets. The second is calculating utilization against a flat 40-hour week, which hides leave and makes every month look worse in holiday periods.

Other frequent errors: hours logged to an internal code instead of the client, so the client looks more profitable than it is; retention calculated on logos only, so losing your largest client counts the same as losing your smallest; and targets that change every quarter, so trends cannot be read. A dashboard that nobody trusts is worse than none, because meetings turn into arguments about the numbers.

09

How Greenwolf Tech Labs builds agency KPI dashboards

We build executive KPI dashboards in Data Studio for agencies and service businesses, starting with a written KPI dictionary, then the client mapping table, the Sheets or BigQuery model and the summary and drill-down pages. Our team includes people with experience from top consulting firms, and we have delivered 100+ projects across 50+ locations.

Work starts with a free review of your time tracking, accounting and CRM exports. We then quote a fixed price, hand over reports and data sources in your own accounts, and can keep the dashboard maintained through managed reporting if your systems change.

FAQ

Frequently asked questions

What are the most important KPIs for a marketing agency?

Billable utilization, gross margin per client, monthly recurring revenue with its net change, client retention and realization rate. Together they show whether staff time is paid for, whether each client covers its cost, and whether revenue is growing or leaking.

What is a good utilization rate for a marketing agency?

Harvest gives 70 to 80% as the typical target range for marketing agencies and 60 to 70% for creative agencies. Measure it against available hours after leave, and track it per person, because an average can hide overloaded specialists.

How do I calculate profit per client at my agency?

Subtract delivery labour cost and pass-through costs from the client's revenue, then divide by revenue. Delivery labour cost is hours logged on the client multiplied by a loaded cost rate per role. Keep media spend out of revenue, or margin will look far higher than it is.

What is the difference between agency KPIs and client KPIs?

Client KPIs, such as cost per lead or return on ad spend, measure the campaigns you run. Agency KPIs, such as utilization and margin per client, measure the agency's own business. Both matter, but they belong on separate dashboards with separate audiences.

Can Data Studio track agency profitability?

Yes, if the data is prepared first. Exports from time tracking, accounting and CRM go into Google Sheets or BigQuery with a client ID mapping table, and calculated fields hold each formula. Data Studio then shows scorecards against target and drill-downs by client and team.

How often should an agency review its KPIs?

Utilization and pipeline are worth a weekly look, because they change quickly and can be acted on. Margin per client, MRR movement and retention suit a monthly review once invoices and timesheets are closed. Schedule the summary page to arrive before each meeting.

Reviewed by Team Greenwolf Tech Labs · 18 Nov 2026

Get started

Tell us what your reporting has to do

Describe the dashboards you need, who reads them and where the data sits. We reply within one business day with an approach, the connectors involved and a fixed-price plan.

  • Free 30-minute reporting review
  • Fixed quote before any work starts
  • Everything built and owned in your Google account

Prefer email? info@greenwolftechlabs.com

Get a free proposal

Two lines is enough to start.

A Data Studio lead replies from info@greenwolftechlabs.com, usually within one business day. No mailing lists.

Ask us anything

A Data Studio lead replies from info@greenwolftechlabs.com, usually within one business day.

A Data Studio lead replies from info@greenwolftechlabs.com, usually within one business day. No mailing lists.