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.
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.
| Line | Where it comes from |
|---|---|
| Revenue | Paid invoices per client from Stripe, QuickBooks or Xero |
| Time cost | Hours per person per client from Harvest, Toggl or Clockify, times each person's loaded cost rate |
| Tool costs | A Google Sheet of tool and contractor costs, assigned by share of hours |
| Profit and margin | Revenue 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.
| Figure | Promethean Research result |
|---|---|
| Average net margin after tax, 2025 | 13% |
| Average since 2015 | About 15% |
| Agencies under 10 people | 19% |
| Agencies with 10 to 24 people | 12% |
| Average project margin, among the 59% that track it | 35% |
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.
| Step | What happens | Who does it |
|---|---|---|
| 1. Pull revenue | Paid invoices per client | App |
| 2. Pull time cost | Hours per person per client | App |
| 3. Add tool costs | Costs read from a Google Sheet | App |
| 4. Calculate profit | Profit and margin per client, compared with your target and the last 3 months | Rule |
| 5. Write the summary | Top three problems and three suggested actions, checked against the data | Claude AI |
| 6. Deliver | Rows to a Sheet that feeds Looker Studio, summary to Slack | App |
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.
Related automations
Client health checks
Weekly score, red flags first
Payment reminders
Late invoices get a reminder
Weekly client report
Report draft waits in Gmail
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.
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.
