Agency automation 25 of 25

Marketing agency profit margin: how to see profit per client

Marketing agency profit margin is the share of your revenue left after the time and tools it took to serve clients. To see it per client, use one formula: revenue minus time cost minus tool costs. Most agency owners know revenue per client but not profit, so they find out late that an account costs more than it pays. A monthly report fixes that. On the third business day, n8n pulls your invoices, timesheets and tool costs, plain code does all the arithmetic, and Claude writes a short summary that is checked against the data. The result is a monthly view of which clients earn their place and which ones need repricing, rescoping or a goodbye. Below are the formula, the only outside numbers we use, and what to check before you build it.

How the automation runs

Marketing agency profit margin is easiest to improve when you see it per client. This automation works out revenue minus time cost minus tool costs each month, using plain code, and Claude writes the summary.

Monthly profit report: who does each stepStarts when: Third business day. Step 1, Pull revenue: done by an app (Billing tool). Step 2, Pull time cost: done by an app (Time tracker). Step 3, Add tool costs: done by an app (Google Sheets). Step 4, Calculate profit: done by a rule. Step 5, Write the summary: done by Claude AI. Step 6, Deliver the report: done by an app (Sheets + Slack). You get: Profit per client, every month.WHO DOES EACH STEPRule, no AIClaude AIA person (none)An appSTARTS WHENThird business day1 · APPPull revenueBilling tool2 · APPPull time costTime tracker3 · APPAdd tool costsGoogle Sheets4 · RULECalculate profitn8n5 · CLAUDE AIWrite the summaryClaude6 · APPDeliver the reportSheets + SlackYOU GETProfit per client, every month

How do you calculate profit per client?

Profit per client is the revenue for the month, minus the time cost, minus the tool costs. Margin is profit divided by revenue.

Time cost is hours worked times each person's loaded cost rate. A loaded rate is salary plus tax and benefits, and a market rate for founders' time. Tool costs include software and contractors, assigned to clients by a fixed rule such as share of hours.

How do you calculate profit per client?
LineWhere it comes from
RevenuePaid invoices per client from Stripe, QuickBooks or Xero
Time costHours per person per client from Harvest, Toggl or Clockify, times each person's loaded cost rate
Tool costsA Google Sheet of tool and contractor costs, assigned by share of hours
Profit and marginRevenue minus time cost minus tool costs, then profit divided by revenue, calculated by code

What do outside surveys say about agency margins?

Treat these as a reference point. They come from Promethean Research, read here as a third-party summary of a survey, at https://prometheanresearch.com/how-profitable-are-digital-agencies/. We did not confirm the sample size on Promethean's own page, and we do not extend these numbers beyond what is listed.

What do outside surveys say about agency margins?
FigurePromethean Research result
Average net margin after tax, 202513%
Average since 2015About 15%
Agencies under 10 people19%
Agencies with 10 to 24 people12%
Average project margin, among the 59% that track it35%

How does the monthly profit report work?

Rules compute every number. Claude only writes the summary, and a Code step checks that each number in the text exists in the data. The 35% project margin figure is before overhead, so do not compare it with the 13% net figure.

How does the monthly profit report work?
StepWhat happensWho does it
1. Pull revenuePaid invoices per clientApp
2. Pull time costHours per person per clientApp
3. Add tool costsCosts read from a Google SheetApp
4. Calculate profitProfit and margin per client, compared with your target and the last 3 monthsRule
5. Write the summaryTop three problems and three suggested actions, checked against the dataClaude AI
6. DeliverRows to a Sheet that feeds Looker Studio, summary to SlackApp

What data do you need before you start?

You need paid or accrued revenue per client for the month, and hours per person per client. You need a loaded cost rate for each person, and your tool and contractor costs with a rule for assigning them to clients. You also need a mapping that links each client across your billing tool, your time tracker and your report, plus your target client margin. The mapping sheet is most of the setup work.

Once the report runs, you see profit per client every month. You can reprice, rescope or drop a client with numbers in hand, instead of finding out at year end.

What can go wrong with a profit report?

Time that was never logged makes a client look more profitable than they are. Send a weekly timesheet reminder, and flag anyone whose logged hours are well under their weekly capacity.

Check these first. n8n has no Toggl action node, so Toggl data needs a custom HTTP call. Xero and QuickBooks reports also use the HTTP Request node, and we have not tested those setups. We did not re-verify that Looker Studio reads from Google Sheets. On n8n Cloud Starter an execution is capped at 5 minutes, so split large pulls into sub-workflows or self-host.

Our estimate for the build: 10 to 16 hours, based on three data pulls, the client mapping sheet and the number check. Our estimate for time saved: about 3 to 5 hours a month, based on exporting from three systems for 10 to 20 clients.

Frequently asked questions

What is a good profit margin for a marketing agency?

Promethean Research, in a third-party summary of a survey, reports a 13% net margin after tax in 2025 for the average digital agency, and about 15% on average since 2015. Agencies under 10 people averaged 19% and those with 10 to 24 people averaged 12%. Use these as a reference, not a rule.

How do I calculate profit per client?

Take the month's revenue, subtract hours worked times each person's loaded cost rate, and subtract the tool and contractor costs you can assign to that client. Margin is profit divided by revenue.

Does Claude do the maths?

No. Plain rules in n8n compute every number. Claude only writes the summary from the finished numbers, and a Code step checks that each number in the text is in the data.

Why does missing time make a client look better?

Unlogged hours lower the time cost, so profit looks higher than it is. A weekly timesheet reminder and a flag for hours well under weekly capacity help catch this.

Want these running in your agency?

Book a free call. We look at your process, pick the automations that fit and tell you what the build involves. There is no price on this page, because it depends on what you need.

Book your free call

Tell us a little about your agency. After you send it, you pick a time on the calendar.

Free to request. No payment on this form. Continuing opens our Calendly calendar, which sets cookies from calendly.com. Calendly privacy. We use your email only to reply about this call. No spam.

Build times and time saved are estimates, tool plans and features change, so test every automation on your own plan before you rely on it.