← All Case Studies

Digital Marketing / SEO

Origin story: the agency that built ARLO for itself first.

Choquer Agency — a boutique SEO and web development shop — built the first version of ARLO as an internal Claude connector. After months of answering client questions by tab-hopping across GA4, Search Console, and Google Ads, the team wired up an MCP so Claude could just ask the right platform directly. That internal tool is the seed product ARLO is built on.

30+

Clients served via MCP

Full Choquer portfolio queryable from Claude Desktop

15

Tools exposed

Across GA4, GSC, Google Ads, YouTube, GBP, and PageSpeed

<2s

p95 latency

Typical query response time end-to-end

5+/wk

Reporting hours saved

Per account manager, within first month

The Challenge

A portfolio of 30+ clients across SEO, Google Ads, and website work meant any "how's it going?" question required logging into five different dashboards, exporting CSVs, and pasting totals into a weekly report. Account managers were spending 4-6 hours per week on manual reporting — and the data was a week stale by the time clients saw it.

The Solution

The team built a private MCP server exposing 15 tools to Claude Desktop: list_clients, marketing_query, marketing_compare, marketing_report, and more. Each tool maps to a Google API (GA4, GSC, Ads, YouTube, GBP, PageSpeed) and resolves a client name to the right property/account via a single database lookup. Within a week, every account manager at Choquer was asking questions in Claude instead of logging into dashboards.

Technology

Next.jsConvexMCP SDKGoogle APIsClaude Desktop

We built this because we needed it. The fact that every other agency has the same problem was the business model reveal.

Bryce Choquer, Founder, Choquer Agency

Free SaaS Replacement Assessment

Ready to own your software?

Find out how much you could save by replacing your SaaS subscriptions with custom software you own.