Client reporting + Q&A automated across 40 accounts

The challenge

The agency carried 40 clients, each expecting a weekly report plus quick answers to ad-hoc questions like "how did that campaign do?". Strategists, the people meant to be thinking about strategy, spent roughly half their week assembling reports and answering status pings.

The reporting was mechanical but unavoidable: pull numbers from ad platforms and analytics, format them, write a short narrative, send. Forty times. Every week.

The ad-hoc questions fragmented focus further, arriving at all hours across email and Slack and pulling strategists out of deep work for a 30-second lookup.

The solution

A per-client AI assistant now handles reporting and ad-hoc Q&A, giving strategists their week back:

• Weekly reports, generated automatically, each client's assistant pulls from the connected ad platforms and analytics via MCP custom tools, assembles the weekly report and sends it on schedule.
• Ad-hoc questions answered instantly, "how did that campaign do?" is answered from live data in Slack and Email, so strategists aren't interrupted for lookups.
• One assistant per account, 40 client-specific assistants each hold that client's context, so answers are accurate and personal across the whole book.
• Consistent, on-brand reporting, a shared instruction built in the Configuration Wizard keeps every report's format and tone uniform.
• Strategists escalated to, not interrupted, genuine strategic questions route to the human via Hand-off Control, with routine ones fully self-served.

The roughly half-week strategists lost to reporting went back into actual strategy, and clients got faster answers and more consistent reports than before.

What was deployed