The first working days of the month
On the first of the month every account manager opens the same folder of slide templates. For each client they log into Google Ads, set the date range, export the campaign table, paste it in, fix the column widths. Then Meta Ads Manager, then GA4, then LinkedIn Campaign Manager, then the social scheduling tool for organic numbers, then Search Console. A client with five channels can take most of a morning before a single sentence of analysis is written.
Multiply that by fifteen or twenty clients across the team and a big share of the first week goes on producing reports. Client work waits. The commentary, which is the only part the client actually values, gets written at six in the evening in a hurry.
Why the dashboard tool did not fix it
Many agencies have tried Looker Studio or a reporting platform. It helps, but the copying often comes back.
- Each client is set up slightly differently, so the dashboard template breaks on the account with two GA4 properties or the ads account shared with another agency.
- Connectors to some platforms are paid add-ons or break when the platform changes its API, and nobody in the agency owns fixing them.
- Clients want a PDF or a deck with the agency's own layout, not a link to a dashboard they never open.
- Offline results, such as sales from the client's CRM or calls, are not in any connector and are added by hand.
- The report has to explain changes, and a dashboard only shows them.
So the dashboard becomes one more source to screenshot, and the manual deck survives.
What the reporting week costs
The obvious cost is senior time spent on low-value copying. The quieter costs are errors, such as last month's figure pasted into this month's slide or a date range left on the wrong setting, which the client spots before the agency does. Reports go out late, and a late report makes a good month look less impressive. Account managers who hate the first week of every month start looking for jobs at agencies that have fixed it.
The reporting pipeline we build
- Each client's accounts are listed once: ad accounts, GA4 properties, Search Console sites, social profiles and any CRM or sales source the client shares with you.
- A scheduled job pulls the agreed metrics from each platform's API after month end into a central store, such as BigQuery or a Postgres database, so the data is kept even if a platform later limits history.
- Metrics are mapped to your standard definitions, so "leads" means the same thing across clients even when it comes from different conversion actions.
- The report is generated in your own template as slides or a PDF, with charts and tables already filled and checked against the source totals.
- A draft summary of what changed and why can be written by a language model from the numbers, for the account manager to edit or throw away. It never goes to a client unreviewed.
- Anything that failed to pull, such as an expired login or a missing permission, is listed so it is fixed before the report goes out rather than noticed by the client.
| Task | Before | After |
|---|---|---|
| Logging into each platform | Every client, every month | Only when a connection needs renewing |
| Setting date ranges | By hand, often wrong | Set by the schedule |
| Charts and tables | Pasted and resized | Generated in your template |
| Checking totals | Rarely done | Automatic check against the source |
| Commentary | Rushed at the end | Where the time now goes |
How the first week feels afterwards
On the first working day the account manager opens a folder of draft reports that already have the numbers in. She reads each one, checks anything flagged, rewrites the summary in her own voice and adds what she is recommending next month. The reports go out earlier and read better, because the time went into thinking rather than copying.
When a client asks mid-month how things are going, the numbers are already in the store and a quick interim view is a few clicks away.
You might recognise this
- Account managers log into five or more platforms per client every month.
- Reports are built in slides by copying exports and screenshots.
- A dashboard tool exists but reports are still assembled by hand.
- Clients have spotted wrong figures before you did.
- Commentary is the last thing written and the first thing cut.