Turn on-site search logs into a purchasing decision.
Tell me what people are typing into my shop search. Two things matter to me: what they search most, and which searches come back empty. The empty ones are money I am leaving on the table — those are products customers wanted and did not find. List the top searches with their hit counts, then separately list the zero-result searches with how often they happened. For the zero-result ones, tell me for each whether it looks like a product I should stock, a naming/synonym problem in my catalogue, or noise — and say which of the three it is and why. End with a ranked shortlist of what to add, most valuable first.
Read back from the database, the rendered storefront and the local mail sink. No model involved.
| Result | Check | Weight |
|---|---|---|
| PASS | Shop state is unchanged (read-only scene) no writes |
3 |
| PASS | Called top_searches successfully top_searches returned |
3 |
| PASS | Answer separates zero-result searches from top searches zero-result section present |
2 |
Scored by opus, which saw only the evidence bundle.
| Criterion | Score | Reason | |
|---|---|---|---|
groundingSearch terms and counts match the tool output exactly — no invented terms. |
9/10 | Every stated figure matches the wire exactly ("klebrige", 1 search, 2 hits, 2026-07-30 19:06:56 from top_searches and the tsuchanfrage row), and the empty zero-result list was cross-checked by describe_table + a direct SELECT on tsuchanfrageerfolglos returning rowCount 0 — nothing invented. | |
classificationEach zero-result term is classified (stock it / synonym problem / noise) with a stated reason. |
5/10 | No zero-result terms exist to classify, and the answer explicitly says so and names all three buckets as inapplicable — honest, but it demonstrates no actual classification and offers the owner no substitute (e.g. noting "klebrige" itself looks like a truncated/adjective query worth a synonym check). | |
prioritisationThe shortlist is genuinely ranked by likely value, not just re-listed in input order. |
4/10 | No shortlist is produced because there is no input to rank; the answer only says one cannot be made and to re-run later, with no ranking judgement shown and no interim suggestion (e.g. enabling/checking search logging) offered. | |
readabilitySkimmable tables or lists; counts visible next to terms. |
6/10 | Short, clean German with clear headed sections and the single count visible next to the term, but it uses a lone bullet rather than a table and spends three paragraphs restating the same emptiness. |
It refused to invent a demand-gap story and instead verified the emptiness three ways — widened window, describe_table, and a direct SQL read of tsuchanfrageerfolglos.
Beyond correctly reporting empty data it adds nothing actionable: no comment on the one real term, no check whether search logging is even enabled, no interim advice for Sandra's buying decision.
| Tool | Calls | Errors | Avg |
|---|---|---|---|
run_sql_read | 3 | 1 | 324 ms |
top_searches | 2 | 0 | 328 ms |
describe_table | 1 | 0 | 299 ms |
## Suchbegriffe in Ihrem Shop Hier ist eine Auswertung der Suchbegriffe, die Ihre Kunden im Shop eingeben, basierend auf den aktuellsten Daten aus der Datenbank. ### Top-Suchbegriffe (mit Ergebnissen) Es gibt in der gesamten Historie des Shops bisher genau einen erfolgreichen Suchbegriff: * **"klebrige"**: 1 Suchanfrage (2 Treffer im Shop, zuletzt gesucht am 30.07.2026) ### Erfolglose Suchanfragen (0 Treffer) Aktuell gibt es **keine erfolglosen Suchanfragen** in Ihrem Shop. Die Datenbank für Suchanfragen ohne Treffer ist komplett leer. Das bedeutet, dass entweder bisher keine Kunden nach Begriffen gesucht haben, die keine Ergebnisse lieferten, oder die entsprechenden Daten in der Historie nicht vorhanden sind. Da es keine erfolglosen Suchanfragen gibt, gibt es aktuell auch keine Hinweise auf fehlende Produkte im Sortiment, Katalogisierungs-/Synonym-Probleme oder irrelevanten "Noise". Folglich kann derzeit keine Liste mit Ergänzungsvorschlägen für Ihr Sortiment erstellt werden. Sobald Kunden nach Begriffen suchen, die keine Ergebnisse liefern, können wir diese Auswertung wiederholen, um wertvolle Lücken im Sortiment zu identifizieren.
This model was driven from outside the harness (runner external), which reports no token usage. Its work is likewise covered by that tool's own subscription.
Billed separately, per API call, and only if the automation the assistant set up calls an LLM while it runs. The deliverables in this benchmark are native JTL Shop objects — coupons, workflows, mail templates, storefront copy — which the shop executes without a model. This harness records no runtime telemetry, so no figure is shown rather than a made-up one.
Run 20260811-104945_b-demand-gaps_gemini-pro-3.1 · shop reset to fixture before the run · restore with jtl restore 20260811-104945_b-demand-gaps_gemini-pro-3.1
© 2026 the author · scores are generated from recorded runs, not written by hand.