keyword-explorer-unified-view

ARCHIVED

"no I want them merged. a list of keywords, regardless of where we got them." "embroidery kits is an example of what I want to eventually happen. data from multiple sources to give different perspectives. So all the fields we have for it should get a column. If its empty its empty. Dont' conflate empty with zero."

STAGES

  1. proposal09-21
  2. requirements09-21
  3. design09-21
  4. tasks09-21
  5. build—
  6. archived09-21

CAPABILITIES — 2 IN ONE CHANGE

  • keyword-explorer2 requirements
  • unified-keyword-row3 requirements

OUTCOMES — AND HOW EACH IS MEASURED

  • ✓1.1A keyword measured by three instruments is one row — `folk art embroidery` appears once, carrying Keyword Tool, Bulk Keywords and Tag Report together — ✓ exercised by `tests/keyword-corpus.test.ts` and `tests/components/KeywordTable.test.tsx` on `main`, and by Katy's walkthrough, 2026-09-21.not stated
  • ✓1.2A keyword only one source has ever seen still gets a row — `bedroom wall art` (Tag Report only) and `snow globe` (Ranked only) both appear — ✓ exercised by `tests/keyword-corpus.test.ts` and `tests/components/KeywordTable.test.tsx` on `main`, and by Katy's walkthrough, 2026-09-21.not stated
  • ✓1.3Near-identical keywords stay separate rows — `snow globe` and `snow globes` remain two rows — ✓ exercised by `tests/keyword-corpus.test.ts` and `tests/components/KeywordTable.test.tsx` on `main`, and by Katy's walkthrough, 2026-09-21.not stated
  • ✓1.4An absent source is never fabricated as zero — `embroidery kits` shows blank Tag Report columns, not `0` — ✓ exercised by `tests/keyword-corpus.test.ts` and `tests/components/KeywordTable.test.tsx` on `main`, and by Katy's walkthrough, 2026-09-21.not stated
  • ✓1.5A reported unknown looks identical to an absent source — `calm stitching`'s `Unknown` Avg searches and empty KD read the same as a source with no row — ✓ exercised by `tests/keyword-corpus.test.ts` and `tests/components/KeywordTable.test.tsx` on `main`, and by Katy's walkthrough, 2026-09-21.not stated
  • ✓1.6A censored value keeps its reported text — `folk art embroidery` shows `< 20`, not blank and not `20` — ✓ exercised by `tests/keyword-corpus.test.ts` and `tests/components/KeywordTable.test.tsx` on `main`, and by Katy's walkthrough, 2026-09-21.not stated
  • ✓1.7Tag Report fields land on the merged row — its seven fields reach the row for a keyword it scores — ✓ exercised by `tests/keyword-corpus.test.ts` and `tests/components/KeywordTable.test.tsx` on `main`, and by Katy's walkthrough, 2026-09-21.not stated
  • ✓1.8Tag-Report-only tags create their own rows — all 258 orphan tags appear rather than being dropped — ✓ exercised by `tests/keyword-corpus.test.ts` and `tests/components/KeywordTable.test.tsx` on `main`, and by Katy's walkthrough, 2026-09-21.not stated
  • ✓1.9Every source is a band of columns on one table — ✓ exercised by `tests/keyword-corpus.test.ts` and `tests/components/KeywordTable.test.tsx` on `main`, and by Katy's walkthrough, 2026-09-21.not stated
  • ✓1.10The Bulk Keywords table is gone — its columns appear as the Bulk Keywords band instead — ✓ exercised by `tests/keyword-corpus.test.ts` and `tests/components/KeywordTable.test.tsx` on `main`, and by Katy's walkthrough, 2026-09-21.not stated
  • ✓1.11Colliding column names are told apart by their band — the three KDs and the doubled Avg columns — ✓ exercised by `tests/keyword-corpus.test.ts` and `tests/components/KeywordTable.test.tsx` on `main`, and by Katy's walkthrough, 2026-09-21.not stated
  • ✓1.12A row is mostly blank without looking broken — no empty state, warning or placeholder — ✓ exercised by `tests/keyword-corpus.test.ts` and `tests/components/KeywordTable.test.tsx` on `main`, and by Katy's walkthrough, 2026-09-21.not stated
  • ✓1.13Blanks sort last on any numeric column — in either direction, on every source's columns — ✓ exercised by `tests/keyword-corpus.test.ts` and `tests/components/KeywordTable.test.tsx` on `main`, and by Katy's walkthrough, 2026-09-21.not stated
  • ✓1.14A range filter excludes blanks rather than counting them as zero — ✓ exercised by `tests/keyword-corpus.test.ts` and `tests/components/KeywordTable.test.tsx` on `main`, and by Katy's walkthrough, 2026-09-21.not stated
  • ✓1.15Ranked and Targeting behave exactly as they do today — ✓ exercised by `tests/keyword-corpus.test.ts` and `tests/components/KeywordTable.test.tsx` on `main`, and by Katy's walkthrough, 2026-09-21.not stated

WHAT HAPPENED

  1. ARCHIVED

    proposal and specs and design and tasks and archive landed

    2026-09-21 · 1 pull request
    • #512chore(openspec): archive five shipped keyword-explorer changes — SHIPPED

History read from a manifest built at 2026-09-30 (09e7bcc).

1 pull request, found by commits touching the change folder