Rocky is the AI agent that does the analytics work for 18 clients at a media agency. It pulls the data, drafts the analysis and builds the deliverables, and a person approves everything before it leaves. My two analysts run agents cloned from it, and they shipped without me while I was on leave.
What Rocky takes in, what it is built on, how it works and what it ships. Everything passes one checkpoint before it leaves: a person saying yes.
The previous analytics team had left. Ten months later the function serves 18 clients and is part of nearly every new-business pitch. Here is each milestone.
First message in a client channel.
The old way, on purpose, to learn the account from the inside before automating anything.
The shipped-work count starts here.
The workspace initializes. Everything after this traces back to it.
The first React and Netlify build proves the delivery pattern for client dashboards.
One BigQuery view, $120M in media mapped to clients. The warehouse under it cut from 2.2 TB to 93 GB.
Planners browse shipped work and ask for the next piece in their own words.
A new client joins in the morning. Their dashboard is live by evening.
A teammate's own AI workspace goes live, seeded from Rocky and growing its own playbooks.
Rocky starts serving curated benchmarks to an internal planning tool, refreshed daily, with no hand-off.
With me on leave, a teammate diagnoses a client reporting freeze alone (a spreadsheet 851 cells from Google's 10-million-cell ceiling) and lifts it before the client report.
Two weeks out of office. Every client ask answered, 15+ production releases shipped.
They built a daily team digest within their first two weeks, then got an agent of their own.
A brand dashboard to production, end to end, six weeks after getting their agent.
Both onboard the same day, on the same system.
I present the evolution of Rocky to the whole agency.
Analytics and AI work goes into the pitch, as it now does for nearly every new-business pitch the agency makes.
My two analysts now own 8 client accounts each, working through agents cloned from Rocky.
Six new gated sites go live, several of them built by my teammates and reviewed by me.
A 16-page guide, a request-intake channel with turnaround promises, and a leave routine, before I step out.
In under a year, an empty function became a department that is part of nearly every new-business pitch the agency makes. Every step is dated, so you can check it.
Two weeks from first commit to a unified warehouse. Every milestone is anchored to a commit or a deploy, so every claim here can be checked.
Rocky was the first engine. Then I cloned it: every teammate got an agent seeded with what Rocky already knew, and they took it from there.
Diagnosed a client reporting freeze alone and fixed it before the client report.
Shipped a brand dashboard to production, end to end.
Built a daily team digest in their first two weeks, then got an agent of their own.
My analysts started doing work above their titles and kept going when I was out. It is a pattern, and it copies.
Each agent is seeded from Rocky's memory and playbooks, then grows its own. The pattern is a template, not a one-off: it copies person to person, and team to team.
Every deliverable is co-authored: planned together, sourced together, checked together. Here is one request, start to finish.
Here's the promo-week read, with the full breakdown in the dashboard. Two things worth flagging...
A request lands in Slack, email or a meeting. Before anything gets pulled, it gets thought through.
What is really being asked, which sources can answer it, and what could go wrong.
Pull, reconcile, question anything that looks off and rewrite, more than once. Then a draft is staged.
I read it, edit it and send it myself.
Rocky stages drafts. A person reads, edits and sends every one.
Every metric comes from a query or a verified pull. The AI doesn't invent numbers.
A claim check flags any number without a source before a draft is staged.
Rocky works in the same channels with the same permissions I have, and no more.
AI your legal team, your clients and your people can trust, because a person stays in charge of everything that leaves.
Drafts are staged in the real channel and sending is always a human action. Verification happens before the draft exists, not after a client catches it.
Compass is the site I built to sell Rocky inside the agency. It frames the work as the five questions every brand marketer asks, answered on their own data, with an analyst reading every output.
Analytics and Rocky are now part of nearly every new-business pitch the agency makes, including the pitch behind a September agency-of-record win.
One model over 15+ production tools, every output reconciled before it leaves. The partner integrations turned weeks of manual pulls into hours.
Tell me what you're building. I'll walk you through Rocky and what my analysts have done with their agents, and we can see where it fits. Email is fastest. I'm in the Philadelphia area, open to hybrid or remote.