About Services Tools Blog Contact us

Search Demand Guide Articles

Turns grouped search queries into size guide and buying guide articles, using a batch writer that can resume where it stopped and has already produced hundreds of pages.

  • Copywriting & Text Generation
  • Footwear retail
  • Pipeline
  • Productised
  • Local/private
  • 2026

The problem

Useful size and buying questions show up in Google Search Console, but nobody can write a page for each one by hand. The one-off buying guides that do get written repeat the same blocks of text across the site.

What it does

A batch writer reads the grouped queries, skips any already written according to a progress record, and writes an article for each remaining question. A lock and an automatic stop prevent a double run or a string of failures. Buying guides for a use or a brand follow the same pattern: a size section, a short list of answers and standard page details. A check removes repeated wording before publishing.

Outcomes

  • Hundreds of size guide articles can be produced from grouped demand.
  • A stopped batch resumes without rewriting finished pages.
  • Buying guides publish on OpenCart with page details and without repeated blocks.
  • Failures stay on a list for a retry.

Simplified mockup

Interactive preview with sample data. Nothing is sent to a server.

Children’s sizing cluster

Written
214
skipped on resume
Waiting
4
this cluster
Failed
2
kept for retry
Lock
Clear
breaker closed
Progress ledger
QueryFileStatus
children shoe length in centimetreschildren-shoe-length-cm.htmldone
uk to eu child size chartuk-eu-child-size-chart.htmldone
how to measure shoe length at homenot writtenwaiting
wide fit school shoes size guidenot writtenwaiting
when to size up winter bootsnot writtenwaiting
what half sizes meannot writtenwaiting
This run
Ready · two done, four waiting

Finished article

ledger · done
uk-eu-child-size-chart.html 2,640 characters

UK to EU child size chart

Foot length decides the size. If the two feet differ, fit the longer one. A conversion chart is a starting point: a wide foot may need the next length so the toes are not cramped.

UKEUFoot cmAge guide
72414.3about 2 years
92716.0about 4 years
112917.6about 6 years
133119.4about 8 years
23421.2junior

Already in the ledger from an earlier run. Resume will skip it.

Boots for wet weather

Page draft 1 repeated block

A country boot for rain needs length for a thick sock, and a shaft tall enough for wet grass. The notes below are the three answers the brief asked for.

Size. From the indoor measurement, go up half a size when the sock is thick. Do not add a full size or the heel slips.

Do I need a membrane?
A lined boot shrugs off puddles. A plain leather upper can be re-proofed, and it breathes on a dry day.
How tall should the shaft be?
Choose a shaft that clears the wet grass, or water runs straight onto the sock.
Can the proofing be renewed?
Wash off mud, dry away from direct heat, and rub in a wax made for the upper.
Repeated

Choose a shaft that clears the wet grass, or water runs straight onto the sock.

Before publish
Duplicate still in the draft

Failures kept for retry

Lock file
Absent
a second run may start
Circuit breaker
0 / 5
closed
Attempts cap
3
then the row stays listed
Failed rows
QueryReasonTryStatus
sandals or a closed shoe for a school dayempty model reply2failed
boot shaft height for long grasstimed out1failed
Retry
Nothing dropped · both rows are still listed

How it works

  1. Read the grouped query files and skip anything already written.
  2. Send each remaining query to Nemotron on Ollama.
  3. Save each article in one step, so a failed write never leaves half a page.
  4. Use a lock and an automatic stop to prevent a second run or a string of failures.
  5. Let an operator retry failures or reset the progress record.
  6. Give buying guides page details and a check for repeated wording before publishing.

Pipeline

flowchart LR
  Queries[Clustered queries] --> Ledger[Skip finished rows]
  Ledger --> Write[Write HTML article]
  Write --> Lock[Lock and circuit breaker]
  Lock --> Out[Article folder]
  Out --> Dedupe[Strip duplicate blocks]
  Dedupe --> Publish[Guide with metadata]