Programmatic SEO: what it is, and the distribution nobody prints
Programmatic SEO is presented as a traffic strategy. You want to know what it actually returns before you build a generator.
What it is
Many pages from one template and one data source, each targeting a query that already exists. A page per city, per conversion, per integration. Not new, not a hack: every marketplace and directory has done it for twenty-five years.
The distribution
On this site, 6 of 85 generated pages earned 82.9% of the clicks. Forty-four earned fewer than ten. 22 earned exactly zero. That is programmatic SEO working, not failing.
Which means it is a cost strategy, not a traffic strategy
Each page cost about twenty minutes because the template existed. Forty-four failures cost a day and a half in total, and one of the six winners was written in the same twenty minutes and was indistinguishable at the time. You cannot pick the winner. You can make being wrong cheap.
The distribution nobody shows you
This site ran 85 programmatic pages. 6 of 85 of them took 82.9% of all the clicks the set produced. 22 earned nothing at all. That is not a botched implementation, it is the ordinary outcome, and every case study that omits the distribution is describing its six winners and quietly not mentioning the other seventy-nine.
The version that works
Ship ten, wait sixty days, and read the distribution before shipping any more. Kill the pages that got no impressions rather than rewriting them. Expand only in the direction the winners point. This turns a programmatic set from a bet into an experiment, and it is the difference between finding your six quickly and finding them after a year of maintenance.
Measured, not asserted
85 generated pages, 82.9% of clicks from 6 of 85, 22 pages at zero clicks and not one of them at zero impressions.
Free tool for this: Programmatic Set Analyzer. No account, nothing uploaded.
Where this goes deeper
Every number on this page comes from one complete dataset: one product taken from zero to 100K+ users on search alone, with nothing spent on advertising. The full argument is Chapter 36 of the book. Five chapters are free to read.