The catalog is too big to run by hand. Now what?

> WHAT WE WALKED INTO

A stationery partner ran roughly 2,000 active ASINs (about 4,600 in the full catalog) through a campaign structure designed for a store a fraction of that size. At that size “what is working” stops being a question a person can answer, because the answer is spread across thousands of rows nobody can hold at once. The account needed tooling before it needed opinions: a structure a machine can build, and a teardown a person can read. This file carries both, and it carries the down year, because a case file that only shows the flattering half is an ad.

> THE MOMENT · THE REBUILD, AS LOGGED

> STEP 01

Restructured around buyer intent

One structure, about six campaigns per ASIN, organized around what buyers are trying to do rather than the catalog’s own filing system, built in sales-velocity order so the head of the catalog went first. The structure covers the top 998 ASINs today; the actively selling tail below them is not in it yet, and adding it is the open work.

> STEP 02

Built the loader that builds it

The structure is generated from the catalog file, so a rebuild is a run of a tool instead of a quarter of hand work. The 5,988 count is a byproduct of the template. Counting campaigns as a win is how accounts get bloated, so we do not.

> STEP 03

Read the UK the honest way

A year-over-year teardown for the UK marketplace found sales down 6.4% while category search demand rose 12% and the brand’s impression share fell 16%. Stockouts ruled out (0 of 12 declining lines stockout-linked). That is a share loss in a growing market, which is a worse diagnosis than a demand loss and a more useful one, because share can be bought back and demand cannot.

> STEP 04

Ads got cheaper in the same UK read

ACOS 14.0% from 20.9%, 6.9 points lower, on 17% less spend. Cheaper ads and lost share in the same year is the tension in this file, and we are not resolving it on the page: the leaner account spent less on visibility, and visibility is what the teardown says went missing. That is at least a question worth asking. The structure work is the response. Whether it moves the sales line is next year’s file.

> THE NUMBERS, DRAWN FROM THIS FILE ONLY

> WHAT CHANGED · FLIP IT YOURSELF