Case Study 01

Amazon Seller

Intelligence System

Client

UK-based Amazon seller

Timeline

7 weeks, 4 milestones

Scope

Architecture to deployment

Weekly

Owner briefing, written for a person

9

Parts, one shared record

Daily

Whole catalogue read every morning

Rule-based

Every threshold can be opened

The Problem

Revenue was bleeding through ad spend — and nobody could see where.

A UK-based Amazon Merch seller with a large catalogue of designs was spending on ads across all of it, with no clear view of which products were earning that spend back.

The core metric wasn't ACoS (the industry standard). It was Royalty Per Ad Dollar — how much actual royalty income each advertising dollar generated. Against the threshold the seller set, many products were falling short, and nothing was identifying which ones or what to do about them.

The team was spending hours manually checking spreadsheets. They needed a system that read the whole catalogue every day and surfaced the decisions, not more data.

The Approach

Nine agents. One shared intelligence layer.

Rather than building a monolithic dashboard, I designed a multi-agent architecture where each agent owns one responsibility — but they all share context through a structured observation log in Supabase.

This means the Ad Waste Detector doesn't just flag underperformers — it writes a structured observation that the Pricing Optimizer can read and act on. Every call either of them makes is an explicit rule with a number behind it, which the seller can open and check. That was his requirement, not mine: he wanted thresholds he could inspect rather than a model he had to take on trust.

System Architecture

Data Ingestion

Pretty Merch CSV Parser
Amazon Royalty Import
ClickUp Catalog Sync

Intelligence Layer

Ad Waste Detector
Pricing Optimizer
Trend Analyzer

Delivery

CEO Weekly Brief
Slack Notifications
Google Drive Reports

Shared Context Layer

Supabase PostgreSQL — context_log table, structured observations, cross-agent queries

Tech Stack

Python

Agent orchestration

Claude API

Haiku for routine, Sonnet for complex

Supabase

PostgreSQL + shared context

Amazon Ads API

OAuth2 data ingestion

Keepa API

Pricing & BSR tracking

ClickUp API

Product catalog sync

Slack API

Real-time notifications

Google Drive

Report archival

The Results

From spreadsheet chaos to autonomous intelligence.

Within the first week of deployment, the system surfaced wasted ad spend across underperforming products — spend that had been invisible in manual spreadsheet reviews.

The CEO Brief agent now delivers a weekly executive summary directly to Slack, written in natural language with specific recommendations. The team went from spending hours on data analysis to making decisions in minutes.

Each agent's observations become context for the next one. The Pricing Optimizer reads what the Ad Waste Detector found. The Trend Analyzer informs the CEO Brief. They are not nine separate tools, they are one pipeline with a shared record — and because every decision in it is a written rule, the seller can ask any recommendation why.

“Genuinely the most thorough response I've received. It shows you've understood the brief really well.”

UK-based Amazon Seller

Print on demand, large catalogue