The report that sends itself.
Reporting day is the tax you pay for having clients. Position 11 generates, renders and sends — per client, on the cadence each one is on.
The last week of every month
Export, paste, screenshot, write the commentary, export to PDF, attach, send. Multiply by the number of clients. It is the least valuable work in the agency and it lands at the same time every month.
The commentary is the part that matters, and it is the part that gets rushed because the first four steps ate the afternoon.
Position 11 produces the analysis and the document. What is left is the judgement, which is the part you are actually paid for.
How it works
Queued
Generation runs on a queue worker, not in a web request, so a slow API call cannot time out a report.
Rendered
Branded HTML email with the client’s own colour, plus a PDF attachment generated from the same snapshot.
Delivered
On each client’s own cadence — weekly, monthly, or off entirely.
Stored
Every run is persisted as a snapshot, so the history exists whether or not anyone opened the email.
The detail that matters
Per-client cadence, including off
Some clients want it weekly, some monthly, some never — and “never” should not mean their data stops updating. The dashboard refreshes daily regardless of whether an email goes out.
Snapshots, not live queries
The dashboard reads stored snapshots rather than hitting Google on every page view. Faster, and it keeps you well inside API quotas.
The same numbers as the screen
The email, the PDF and the dashboard all render one stored snapshot, so a client quoting a figure back at you is always quoting a figure you can find.
A failed run says so
If a month’s report cannot be generated, the dashboard shows that it failed and why, rather than a report that silently never arrived.
What this doesn’t do
Reports are sent from Position 11’s own mail service, and it cannot see inside a recipient’s inbox: if their spam filtering quarantines a report, we will not know it was missed. A report that could not be sent at all is logged, and the dashboard always has the same numbers.
Reasonable questions
Can clients receive it directly?
Yes. Give a client their own login to that account and they receive its reports on its cadence. Or keep the reports to your team and send your own version.
Is the PDF just a print of the email?
It is generated from the same snapshot with a layout meant for a document rather than an inbox.
What if a data source fails that month?
The report still goes out with whatever it could gather. A Search Console outage does not cost the client their paid-search report.