How Programmatic SEO Delivered 135,000 Organic Clicks and ~830 Ranked Pages Across 5 Client Sites in 16 Months

Last week we almost shipped a case study with a $9.58 million headline.

The number was technically defensible. It was total organic search revenue across three ecommerce clients over the last 12 months. Pulled straight from Google Analytics 4. Receipts, screenshots, everything.

We killed the draft.

Because that $9.58 million included every organic click. Homepage brand searches. Default category pages. Product pages the ecommerce platform generates by default. All of it got lumped into a programmatic SEO case study, and the headline implied we built templates that generated $9.58 million.

We didn't.

We built templates. The templates generated a smaller, specific, honest number.

That number is what this post is about.

The Real Headline

~830 templated pages. 135,000 organic clicks. 3.54 million impressions. Across 5 client sites in 16 months.

Every number pulled directly from Google Search Console on 6 October 2026, for the 16 months ending 3 October 2026. Only URL patterns we actually built as programmatic templates are counted.

No homepage brand traffic. No default category pages. No standard product pages. No hand-built utility pages.

Just the templates. Just the work we actually did.

Why The Smaller Number Matters

Programmatic SEO means something specific.

You design one page layout. You identify a variable. You feed structured data into the template at scale. Each generated page targets a long-tail query that would be uneconomical to write by hand.

That's the work.

What it is not:

• The default category pages Shopify generates when a merchant creates a collection.
• The product pages the platform generates when a merchant adds an SKU.
• The homepage traffic from branded searches somebody already knew to type.

Those are platform-default outputs. Lumping them into a "programmatic SEO" headline makes the agency's work look bigger than it was.

We'd rather lead with the honest number and keep the trust.

Our broader explainer on how templated page systems get built lives at Programmatic SEO for Ecommerce. This post is the case study that sits underneath it.

What Did 16 Months of Templates Actually Deliver?

Five sites. Five different programmatic patterns. Five different maturity stages. One honest subset of numbers.

1. A US Shopify Store in the Kratom and 7-Hydroxymitragynine Category

Mature DTC commerce in a health and wellness vertical. Templates deployed at two URL patterns.

Pattern one. A blog comparison hub.

The template answers one commercial query at scale: "[compound A] vs [compound B]" and the long-tail variants. Alongside the comparison template, "Is [compound] legal in [state]" templated legal guides, "Top N [products] for [use case]" listicles, "Can you take [compound A] with [compound B]" interaction guides, and "Does [product] show up on [test type]" medical guides.

The variable changes. The template stays.

Result over 16 months on the blog hub alone:

• 21,100 organic clicks
• 760,000 impressions
• 2.8% CTR, position 6.4
• 135 articles ranked in Google

Pattern two. A product and brand comparison page hub under /pages/*.

Same mechanic. Different template. "[brand A] vs [brand B]" and "[product A] vs [product B]" permutations across every pair the merchant stocks. 181 total pages after we exclude a couple of hand-built utility pages.

Result over the same 16 months:

• ~10,075 clicks
• ~317,000 impressions
• ~181 comparison pages ranked

Combined for this client:

• ~31,175 clicks
• ~1.07M impressions
• ~316 ranked programmatic URLs

2. A US Shopify Plus Store Across THC, HHC and Mushroom Verticals

The template on this site is a brand hub.

Every stocked brand in the catalog gets its own page at /brand/[name]/, generated from the product catalog. The page answers "I am looking for products from [brand]" with a filtered product grid, a brand description, policy notes, and internal links to related brands.

When a new brand lands in the catalog, the brand hub ships automatically with it.

Result over 16 months:

• 104,000 organic clicks
• 2.37M impressions
• 4.4% CTR, position 8.3
• 423 brand hubs ranked

The top brand hub alone pulled 32,140 clicks over 16 months. The next nine each pulled between 2,400 and 6,400 clicks.

One template. 423 pages. 104,000 clicks.

That's the programmatic SEO equation.

3. A European Legacy CBD Brand (Programmatic Work Started ~45 Days Ago)

Early-stage rollout on an established domain.

The template is a cannabinoid comparison hub at /comparisons/*. Every pair of related compounds in the taxonomy gets its own templated page. CBD vs CBG. THCV vs CBD. CBDa vs CBD. CBD vs ashwagandha. Hemp oil vs CBD oil.

CBD is a regulated category where paid acquisition is restricted. That means organic search carries more weight on a CBD site than almost anywhere else, and templates matter more because the long-tail query space is wide and specific. We cover the broader context in SEO strategy for regulated CBD ecommerce brands.

45 days in:

• 7 clicks
• 1,230 impressions
• 31 unique comparison pages ranked in Google

Seven clicks is almost zero in absolute terms. We're including it anyway. Because 31 pages ranking in Google inside the first 45 days of a brand new programmatic rollout is a very strong leading indicator.

Programmatic SEO compounds.

Month six and twelve will not look like month one.

4. A UK Parcel Shipping Comparison Marketplace (New Launch, July 2026)

Three templates live on the site, launched three months ago. Logistics and parcel comparison is a category where structured data at scale (every carrier, every service, every weight band) maps directly to real commercial search demand. More context on this vertical lives at Shopify for transportation and logistics.

Template one. The classic two-variable commercial pattern. /couriers/[carrier]/[service]. Royal Mail Tracked 48. Royal Mail Tracked 24. Parcelforce Express 48. Evri Standard 48. DPD Saturday. Each page targets a specific commercial query.

Template two. /services/*. Specific service types. "Send parcel no printer", "recorded delivery", "collection services".

Template three. /blog/*. Long-tail commercial intent articles. "Cheapest way to send a parcel UK", "Large parcel delivery UK", "Same day next day delivery UK".

Three months of data across all three templates:

• 167 clicks
• ~76,000 impressions
• 45 ranked programmatic URLs (22 under /couriers, 7 under /services, 16 under /blog)

That's 45 pages ranking in Google in the first 90 days of a brand new site.

Hand-written content pages at that rate are not possible on a small-team budget.

5. A UK Same-Day Courier Franchise (New Launch, August 2026)

Two months of data. One programmatic pattern.

/news/[article]. Long-tail commercial-intent articles. "What is a same-day courier". "Same-day courier cost UK". "Same day vs next day delivery". "Dedicated vs multi-drop courier".

Result:

• 38 clicks
• 18,200 impressions
• 15 ranked articles

Same template mechanic. Different vertical. Same compounding story in motion. If you work with a UK-based ecommerce team, our UK Shopify Plus agency page covers the regional work in more detail.

What Does "Programmatic SEO" Actually Mean?

Three definitions matter.

One. It's page generation from a template. You design one layout. You identify a variable. You feed structured data. The template produces as many pages as the variable has values.

Two. It's not what the ecommerce platform does by default. Shopify generates a category page every time a merchant creates a collection. That's the platform doing its job, not an agency building programmatic SEO. Clients who are not told the difference end up paying for work that already shipped when they installed Shopify. We walked through the shape of that work in our guide to Shopify collection page SEO templates.

Three. It's a traffic asset, not a traffic spike. The compound value shows up in month 6, 9, 12. Not week 2. Every single site in this case study followed the same curve.

That's the model.

Short, specific, boring.

Everything interesting is downstream of it being set up correctly.

What Works With Programmatic SEO? And What Quietly Kills It?

Templates are cheap to ship.

That is both the advantage and the biggest danger. Once you have a template, you can generate thousands of pages. The question is whether you should.

A few patterns became clear across these five sites.

1. The Template Has To Answer A Real Query

The best templates don't manufacture demand.

They meet it.

"[Brand A] vs [Brand B]" works because somebody is already typing that into Google. "[Compound A] vs [Compound B]" works because somebody wants a structured comparison. "[Carrier] [Service] cost" works because that search exists.

When no one is already searching the pattern, no template is going to rank. We check keyword demand against every variable before we ship the template.

2. The Data Feed Has To Be Substantive

A template is a shell. The feed makes the shell useful.

For the brand hub pattern on the Shopify Plus client, the feed includes the brand's product collection, a brand description, policy information, and internal links to related brands. For the courier marketplace, the feed includes real carrier policies, real service tiers, real timing data.

A template filled with thin data produces thin pages. Thin pages fail.

3. Internal Linking Has To Be Designed, Not Bolted On

Templates generate hundreds or thousands of pages. If each page is three clicks deep from the homepage and has no inbound internal link from anywhere relevant, Google will not crawl it. Pages that are not crawled do not rank.

We plan the hub structure, navigation placement, breadcrumbs, and in-template cross-links before the template ships.

4. Timing Compounds

A programmatic SEO template deployed in January is a different asset by October than it was in June.

The kratom DTC client's blog hub shipped its first articles in Q3 2025. First real click volume showed up Q2 2026. By Q3 2026, the hub peaked at roughly 2,000 clicks in its best week.

That is not a channel you judge in month two.

5. Shipping Too Much Hurts More Than Shipping Too Little

Every programmatic SEO engagement has a decision point: which permutations of the variable get indexed, and which get noindex.

More indexed pages is not better.

More useful indexed pages is better.

If the template produces 5,000 permutations but only 800 of them answer a real query substantively, the other 4,200 should carry a noindex tag. Google's quality systems are good enough to penalize sites that ship 5,000 thin pages. We have seen it happen on sites that didn't filter.

The 4 Programmatic SEO Patterns Every Store Should Consider

If your site has structured data at scale, one of these patterns will apply to you.

1. The X vs Y Comparison Hub

Template. Variable: a pair of entities to compare.

Works when there are real commercial searches comparing those entities. Products. Brands. Services. Carriers. Compounds. Tools. Platforms.

On the kratom DTC client, 316 ranked URLs across the comparison hub and page hub combined.

2. The Brand Hub

Template. Variable: a brand name.

Works when a site stocks products from many brands and shoppers search for brands by name.

On the Shopify Plus multi-brand client, 423 brand hubs delivering 104,000 clicks.

3. The Concept Comparison Hub

Template. Variable: a pair of related concepts from the same taxonomy.

Works when the category has a vocabulary that shoppers want explained. Cannabinoids. Supplements. Software features. Materials. Nutrients.

On the CBD client, 31 pages ranked in 45 days.

4. The Two-Variable Commercial Marketplace Pattern

Template. Two variables stacked.

Works when the commercial query space is multi-dimensional. Carrier × service. City × specialist. Role × industry. Platform × integration.

On the parcel comparison client, 22 pages ranked under the /couriers/[carrier]/[service] template in 90 days.

Each pattern has the same ingredients.

Structured data. Template. Internal linking. Indexing discipline. Time.

How We Built And Ran These Templates

There is no clever trick behind the numbers in this post.

We ran five engagements the same way. Nothing exotic.

Step 1. Find The Variable With Real Search Demand

Before writing a template, we run keyword research against the variable.

For the brand hub pattern. We pull search volume for every brand in the catalog. Brands with real search demand get a template page. Brands with zero search demand don't.

For the X vs Y pattern. We pull search volume for every potential comparison pair. Pairs with real queries get templated. Pairs with no queries don't.

The variable decides the template, not the other way around.

Step 2. Design The Template Against The Query

The page has to answer what the searcher wants.

A "brand A vs brand B" page needs a side-by-side feature table, pricing, use cases, pros and cons, a verdict. Not a 2,000-word SEO filler article.

A "/couriers/[carrier]/[service]" page needs the actual carrier policy for that service, pricing, timing, tracking method, where it fits in the carrier's lineup.

A brand hub page needs the brand's products, its backstory, its policies, and internal links to related brands.

If the template doesn't answer the query, the pages won't rank, no matter how many of them ship.

Step 3. Build The Data Pipeline

The template needs a feed.

For ecommerce, that's usually the product catalog. For a marketplace, it's the vendor database. For a service directory, it's the service list.

The feed has to be clean. Variants named consistently. Attributes available for every entity. No gaps. If 40% of entries in the feed are missing a key attribute, 40% of pages will look thin.

Step 4. Plan The Internal Linking

Where do these pages sit in the site navigation?

Which pages link to which?

Where are the hub pages that aggregate the template outputs?

What's the breadcrumb structure?

Pages that cannot be crawled do not rank. We plan this before shipping.

Step 5. Ship In Waves, Not All At Once

Launching 500 templated pages overnight is a bad idea.

Shipping 50 per week over 10 weeks lets us watch indexation, crawl behavior, and ranking signals. If something is wrong with the template, we catch it on wave two, not after all 500 pages are live and ranking poorly.

Step 6. Monitor, Prune, Iterate

Not every templated page should stay indexed.

Pages that generate traffic but zero conversions get investigated. Pages that cannibalize each other get consolidated. Pages that don't rank after 6 months get reviewed. Templates that produce consistently thin outputs for certain variable values get noindex rules.

Programmatic SEO is not a one-time ship.

It's a repeating cycle.

Programmatic SEO vs AI-Generated Content vs Hand-Written Content

Different jobs. Not substitutes.

Most mature content programs run all three.

The question is not which approach wins. It's which approach fits each layer of the content strategy.

For 500 brand hub pages, programmatic SEO wins. For a six-part strategic playbook, hand-written wins. For first-draft ideation and summaries, AI-assisted drafts win.

If you're also thinking about how templated pages show up inside AI assistants, our guide to AI visibility foundations on Shopify walks through what GEO work does to existing pages, and getting Shopify products into AI shopping carts covers the agentic-commerce angle.

What Did We Deliberately Not Count?

The transparency on exclusions is part of the point.

Homepage brand traffic. Branded searches that would land on the homepage no matter what. Not programmatic.

Default Shopify category pages. The pages Shopify generates when a merchant creates a collection. Not programmatic.

Brand-named collection pages. Each brand in a merchant's catalog gets a Shopify-default collection page. These exist because the merchant added products. Not a template we built.

Standard product pages. Platform-default. Not programmatic.

Hand-built utility pages. /pages/contact. /pages/brands as an index hub. /about. One-off builds, not templates.

Pre-existing multilingual catalog shells. The CBD client had localized catalogs long before our 45-day engagement started. Not our deliverable.

The result of all those exclusions is 135,400 clicks instead of 1.21 million.

The smaller number is defensible. The bigger number was not.

What About Revenue?

Here is where we have to be careful.

Across the three ecommerce clients, total organic search revenue over the last 12 months was significant. On the two mature DTC clients, organic search was between 36 and 40 percent of total site revenue. On the CBD client, organic search was 38 percent of revenue despite being only 1.4 percent of sessions.

Those are real numbers. They are impressive on their own.

But they are not "programmatic SEO revenue".

Organic search revenue includes homepage brand traffic, default category pages, product page SEO, and every other organic landing point. Only a portion is specifically attributable to the templates we built.

The honest estimate.

Programmatic click share of total organic clicks per site, applied against organic revenue:

• Kratom DTC client: programmatic clicks were roughly 7 percent of total organic clicks. Applied against the 12-month organic revenue figure, that is approximately $447,000 in attributable programmatic revenue.
• Multi-brand Shopify Plus client: programmatic clicks were roughly 15 percent of total organic clicks. Applied against the 12-month organic revenue figure, approximately $413,000. The real number is probably higher because brand-hub searches typically convert above site average, something we see consistently when we audit commerce conversion rates.
• CBD client: negligible at this early stage.

Rough combined attributable programmatic revenue: $860,000 to $1 million over 12 months.

Call it one tenth of the inflated $9.58M we almost led with.

It is still a strong case study. It is just an honest one.

The parcel comparison and courier franchise sites are both still in their first 90 days of lead-generation work. There is no attributable revenue to report yet. We will refresh in April 2027.

A Note On The CBD Site's Conversion Math

The CBD client's organic traffic converted at roughly 82 times the rate of its direct traffic, measured as session-level key events. That number is accurate as reported in GA4.

Two things worth saying about it. First, the organic traffic on this site is low in volume but high in intent, because it arrives via long-tail commercial queries rather than a homepage brand search. Second, the direct channel in GA4 is almost certainly inflated by internal app traffic, operations team visits, and bot or crawler sessions that bypass channel attribution. The gap is real but the ratio reads bigger than the underlying commercial reality because the denominator is noisy.

The honest read: organic traffic on this site is unusually commercial. Not 82 times more commercial, but materially more commercial than the headline ratio implies.

Can Your Store Achieve The Same?

Anyone promising a specific revenue number from programmatic SEO without seeing your site is guessing.

Your site is different.

• Your query space is different.
• Your data feed is different.
• Your competition is different.
• Your conversion path is different.
• Your product margins are different.

The ~830 templated pages across these five clients came from five different template designs, four different URL patterns, three different maturity stages, and two different site categories (ecommerce vs lead-gen marketplace). You can see the shape of the work we've shipped across other verticals on our portfolio page.

What they all shared.

Structured data at scale that mapped to real search demand.

A template that answered the query substantively.

Internal linking that made the templates discoverable.

Discipline about which permutations should be indexed.

Time.

If your site has structured data at scale and your long-tail query space is bigger than your content team's writing capacity, programmatic SEO is probably worth evaluating.

If your site has neither, probably not.

That's the honest filter.

Before You Spend More On Ad Traffic, Find Out What Your Query Space Is Actually Worth

Here's the part worth taking away from this whole post.

135,000 programmatic clicks weren't hiding inside an SEO tool.

They were sitting inside unmet long-tail queries. The brand name somebody typed. The comparison somebody was researching. The compound somebody wanted explained. The carrier-service combination somebody was pricing.

Templates gave us a way to answer more of those queries at scale.

Discipline turned the templates into a system.

The system turned demand that already existed into measurable traffic.

That's the opportunity.

Not "more pages".

More answers to queries somebody is already typing.

If your business has structured data at scale and you've never audited whether a programmatic template would multiply your organic coverage, that is exactly the kind of problem we work on.

• We look at your query space.
• We look at your data feed.
• We look at your existing organic footprint.
• We look at competitor coverage.
• We model what a template could ship against each variable.

And then we tell you whether programmatic SEO is actually worth pursuing on your site.

Because maybe it is. Maybe it isn't.

Either way, we'd rather know before you spend another month throwing hand-written content at a query space a template could cover in weeks.

Want to know what your query space could be doing? We find the long-tail coverage your site could be ranking for, but isn't yet.

Talk to our SEO team →

For a deeper walkthrough of how templates get built, see our Programmatic SEO for Ecommerce guide.

Related Reading

• Programmatic SEO for Ecommerce: the pillar guide this case study sits under
• Shopify Collection Page SEO Template: how templated pages inside Shopify get built
• SEO Strategy For Regulated CBD Ecommerce Brands: the context behind the CBD scene above
• GEO Foundation And AI Visibility On Shopify: how templated pages surface inside AI assistants
• Shopify Web Push Case Study: our companion case study on web push for Shopify
• Replatform Or Optimize? A Decision Framework For Ageing Stores: the decision framework that often precedes a programmatic SEO engagement

Frequently Asked Questions

What is programmatic SEO?

Programmatic SEO is generating many pages from a single template, each targeting a specific long-tail search query. Instead of writing one page by hand, you build one template and feed it with structured data so hundreds or thousands of pages ship together. Each page ranks for its own long-tail query.

Does programmatic SEO still work in 2026?

Yes. The five sites in this case study together ranked around 830 templated pages and pulled 135,000 organic clicks and 3.54 million impressions in the 16 months ending October 2026. Programmatic SEO works when templates answer real search intent, the data feed is substantive, internal linking is planned, and indexing is disciplined.

How long does programmatic SEO take to show results?

The leading indicator (templated URLs ranking in Google) shows within 60 to 90 days of launch. The lagging indicator (clicks and revenue) compounds over 6 to 12 months. Every site in this case study followed the same curve. Slow start, acceleration around month six, meaningful traffic around month twelve.

What kinds of businesses benefit from programmatic SEO?

Any business with structured data at scale. Ecommerce catalogs with brand portfolios. Comparison marketplaces. Service directories. Legacy brands with ingredient or compound taxonomies. Franchise logistics sites. Anywhere the long-tail query space is bigger than the content team's writing capacity.

How is programmatic SEO different from AI-generated content?

Programmatic SEO uses a template filled with structured data from a source of truth. AI-generated content uses language models to write page bodies, usually without a structured data source. The two can combine. The work in this case study is template plus data feed, not generative language model output.

Is programmatic SEO just thin content at scale?

No. Thin content at scale fails Google's quality systems. Programmatic SEO works because the templates answer real user intent, the data feed is substantive, internal linking is planned, and permutations that would produce thin pages carry a noindex tag.

What's the biggest risk with programmatic SEO?

Shipping thin or duplicate pages that trigger a quality update or a manual action. The risk is highest on templates with weak differentiation per generated page. We constrain the permutations allowed into indexable templates, block low-value ones with noindex, and monitor Search Console for quality signals.

How much revenue did these specific sites generate from programmatic SEO?

Approximately $860,000 to $1 million across the three ecommerce sites over 12 months, based on proportional attribution of programmatic click share to organic revenue. The two new logistics sites are in their first 90 days of lead-generation work with no attributable revenue to report yet.

Why isn't the headline $9.58 million?

Because $9.58 million was total organic revenue across all channels and all page types, including homepage brand traffic and default category pages that were not generated by a template we built. The honest subset attributable to our programmatic deliverables is roughly one tenth of that.

Can programmatic SEO work on a brand new site?

Yes. One of the sites in this case study hit 45 ranked templated URLs within 90 days of launch. Another hit 15 ranked URLs within 60 days. Clicks are small early because position-25 rankings do not drive volume, but page coverage is the leading indicator. Clicks and revenue follow over the next 6 to 12 months.

How do we know these numbers are real?

Every GSC number in this post was pulled directly from the Huptech Web agency account on seo@huptechweb.com on 6 October 2026, filtered to only the URL patterns we built as programmatic templates. GA4 revenue numbers come from the same account. The attribution math (programmatic click share applied against organic revenue) is modeled and clearly flagged as an estimate throughout.

Can Huptech Web run programmatic SEO for our Shopify store?

Yes. We build templates, data pipelines, internal linking architecture, and ongoing optimization for programmatic SEO across ecommerce, directory, and marketplace sites. More importantly, we can first determine whether programmatic SEO is actually worth pursuing for your site. The goal isn't to ship more pages. It's to answer more queries that already exist.