Programmatic SEO is sold as a cheat code: build one template, spin out 50,000 pages, and harvest the long tail while your competitors hand-write blog posts one at a time. It’s a real strategy — we run it for clients — but the pitch hides the part nobody screenshots for the case study: most programmatic pages get no traffic at all. Not “less than they hoped.” Zero.
So we measured it. We pulled the page-level organic-traffic distribution of nine sites built on programmatic templates — Zapier, G2, Wise, Tripadvisor, Canva, NerdWallet, Yelp, Booking.com, and Dictionary.com — more than 12 million pages in total, every one of them tracked by Ahrefs. Then we asked the only question that matters before you commit a quarter to building 50,000 URLs: of all those pages, how many actually get traffic?
The answer is sobering, consistent, and the opposite of how pSEO gets sold. This is a companion to our Keyword Difficulty validity study — same house style: real data, stated method, no cherry-picking.
Method (reproducible)
- Sample: nine well-known sites whose footprint is overwhelmingly templated/programmatic — app-integration pages, software listings, currency routes, location pages, templates, definitions, business listings. Eight pulled at the whole-domain level; Zapier scoped to its
/apps/section for a clean programmatic cut. - Metric: Ahrefs
pages-by-traffic, which buckets every tracked page by estimated organic visits per month (0, 1–100, 101–1K, 1K–5K, 5K–10K, 10K+). Snapshot pulled 2026-06-27, all locations. - Authority control: Ahrefs Domain Rating (DR) for each site, so we could see whether raw authority rescues the long tail.
- The denominator is conservative. Ahrefs only tracks pages that already have some ranking or link footprint. Every URL a site published that never got off the ground is invisible here — so the real share of dead pages is higher than what we report, not lower.
Limitations, stated up front: these are Ahrefs estimates, not Google’s ground truth; a snapshot is a moment in time; the traffic buckets are size bins, not percentiles; whole-domain pulls include a small slice of non-programmatic pages (help, editorial), which would only understate the dead tail. n = 9 sites is a sample, not a census. None of that moves the central pattern, because the pattern is enormous.
Finding 1 — 96.7% of programmatic pages get almost no traffic
Pool all 12.3 million tracked pages together and the distribution is brutal:
- 28.8% get exactly zero estimated organic traffic.
- 96.7% get 100 visits a month or fewer — that’s roughly three visits a day or less.
- Only 3.3% get more than 100 visits a month, and just 0.3% — about three pages in a thousand — clear 1,000.
Read that again: across the programmatic output of nine of the most authoritative domains on the internet, fewer than one page in thirty gets even 100 visits a month. The other twenty-nine are rounding error — published, indexed (maybe), and ignored.
The pooled number is dominated by the giants (Yelp and Tripadvisor alone are 10 million pages), so look at the per-site medians too, which weight a five-thousand-page site the same as a seven-million-page one:
- Median site: 94.8% of its programmatic pages get ≤100 visits/month.
- Median site: 28.6% get exactly zero.
- Median site: barely 0.27% clear 1,000 visits/month (and only ~5% clear even 100).
Whether you pool or take the median, the verdict is the same. The typical programmatic page is a dud.
Finding 2 — Even DR-90 giants can’t make the tail rank
Here’s the finding that should end the “we’ll just publish enough pages and authority will carry them” fantasy. Every site in our sample is a fortress: Domain Rating 89 to 94. These are the domains other sites beg backlinks from. And it doesn’t save them.
| Site | What it templates | DR | Pages tracked | ≤100 visits/mo | ≥1,000 visits/mo |
|---|---|---|---|---|---|
Zapier (/apps/) | app-integration pages | 91 | 5,604 | 98.8% | 0.02% |
| G2 | software listings | 91 | 65,054 | 98.4% | 0.12% |
| Yelp | business listings | 94 | 7,157,922 | 98.0% | 0.14% |
| Tripadvisor | location pages | 93 | 2,881,171 | 96.7% | 0.24% |
| Booking.com | hotel/location pages | 93 | 1,636,483 | 94.8% | 0.27% |
| Dictionary.com | word definitions | 90 | 127,385 | 90.2% | 1.0% |
| Wise | currency routes | 89 | 299,443 | 86.7% | 2.3% |
| Canva | design templates | 93 | 88,958 | 72.6% | 8.7% |
| NerdWallet | finance pages | 90 | 9,024 | 55.8% | 10.6% |
If domain authority were the lever, these rows would all look alike and all look healthy. They don’t. The dead-tail rate ranges from 56% to 99% among sites that are all DR ~90. Yelp (DR 94) has a worse tail than NerdWallet (DR 90). Authority is the price of admission to the game; it is not what wins it. For a normal business sitting at DR 30–50, the implication is blunt: if a DR-94 site can’t rank 98% of its templated pages, neither can yours.
Finding 3 — It’s a power law: a sliver of pages captures most of the traffic
The traffic isn’t just thin — it’s grotesquely concentrated. Look at where each site’s organic traffic actually comes from:
- G2: the 0.12% of pages clearing 1,000 visits/month capture 30% of the section’s traffic.
- Yelp: the 0.14% of pages over 1,000 visits capture 44% of traffic — and the 0.014% over 10K alone pull 27%.
- Wise: the 2.3% over 1,000 visits capture 80%.
Across the board, the thin sliver of pages that clear 1,000 visits — a fraction of a percent to a couple of percent of the count — captures 30–80% of all the organic traffic the template produces. This is the thin-content reality of pSEO: you are not building 50,000 assets. You are building a few hundred assets and 49,000-plus pages of crawl budget tax — pages Google often files under “discovered, currently not indexed” and never looks at again.
Finding 4 — What actually separates the winners
The spread in that table isn’t random, and it isn’t DR. Sort the sites by how healthy their tail is and a pattern jumps out:
- The worst tails are scale-for-scale’s-sake. Zapier’s
/apps/pairs, G2’s listings, Yelp’s business pages — near-duplicate templates stamped across an enormous, ultra-thin long tail where most individual pages target intent almost nobody actually searches. More pages, more dead weight. - The healthiest tails are differentiated demand. NerdWallet (56% dead — the best in our set) is barely “programmatic” in the spam sense: curated, genuinely editorial finance pages on terms people search with commercial intent. Canva (73%) templates things people literally type into Google (“instagram story template,” “resume template”). Each page maps to a real query and answers it better than the alternatives.
That’s the whole game in one line: a programmatic page earns traffic when it maps 1:1 to a real query a real person types and answers it better than what’s already ranking. Scale doesn’t create that mapping. It just multiplies whatever you started with — including nothing.
So… does programmatic SEO work?
Yes — but not the way it’s pitched. The honest version:
- The page, not the template, is the unit of value. Stamping 50,000 URLs from a thin template manufactures 49,000 zero-traffic pages and a crawl-budget problem. Build pages that deserve to exist individually.
- Validate demand before you generate. If the query behind a template cell has no real search volume and no commercial intent, the page is dead on arrival — at any DR. Prune the template down to cells that map to genuine demand.
- Differentiation is the moat, not volume. Your programmatic page has to beat the SERP it’s entering. If it’s a thinner version of what already ranks, it loses, and your authority won’t bail it out.
- Plan for the power law. Assume only a low-single-digit percent of your pages will carry almost all the traffic. Resource the build so those winners are genuinely good, and so the long tail isn’t actively dragging your site down.
Done right — demand-validated, differentiated, quality-gated — programmatic SEO is one of the highest-leverage plays in search. Done as a page-printing press, it’s an expensive way to generate thin content Google ignores. The difference is engineering and judgment, not template count. That’s exactly the line we walk in our programmatic SEO program — and why “pSEO at scale” and “pSEO without the spam” are the same project, not opposites.
First-party footnote, in the spirit of eating our own cooking: our glossary is 213 programmatic-ish pages, and it’s exactly one week old. Ahrefs currently tracks ten of them — six at zero traffic, four with a trickle. That’s not a failure; it’s month one of the power law, precisely as the model predicts. We’ll publish where it actually lands at the six-month mark, winners and duds alike.
Frequently Asked Questions
Does programmatic SEO actually work?
It can, but most of it doesn’t. Across our 12.3-million-page study of nine DR 89–94 sites, 96.7% of programmatic pages got 100 organic visits a month or fewer and 28.8% got exactly zero. It works only when each page maps to genuine, differentiated demand — not when you print pages at scale and hope authority carries the long tail.
What percentage of programmatic pages get traffic?
In our sample, only ~3.3% of programmatic pages got more than 100 organic visits a month, and barely 0.3% — about three in a thousand — cleared 1,000. Those few winners captured 30–80% of each site’s organic traffic. The large majority of templated pages get little or nothing — a steep power law.
Will a high Domain Rating make my programmatic pages rank?
No. Every site we studied was DR 89–94, yet their dead-tail rates ranged from 56% to 99%. Yelp (DR 94) had a worse distribution than NerdWallet (DR 90). Authority is necessary to compete but doesn’t rescue thin, undifferentiated pages — and most businesses doing pSEO have far less authority than these giants.
How do I make programmatic SEO actually work?
Validate that each template cell maps to a real query with real demand before generating it, make each page genuinely better than what already ranks for that query, prune cells with no search volume or commercial intent, and resource the build around the ~2–5% of pages that will carry the traffic. The page is the unit of value, not the template.
Method note: Ahrefs pages-by-traffic and domain-rating, pulled 2026-06-27, all locations. Sample = 9 sites, 12,271,044 tracked pages; Zapier scoped to /apps/. Traffic figures are Ahrefs estimates bucketed by monthly organic visits; Ahrefs tracks only pages with an existing footprint, so true zero-rates are higher. If you want programmatic SEO that builds assets instead of crawl-budget tax, talk to us.