cpg-category-analyst

Drop a raw Nielsen, SPINS, or Circana export into a Claude Code session. It runs an intake interview, builds a semantic layer, and produces a branded slide deck. What I used to do by hand at Red Fox Analytics, mostly automated.

RAW DATA          Nielsen · SPINS · Circana exports
                   detect source, map columns, validate
──────────────────────────────────────────────────────
NORMALIZED MODEL  DuckDB — 12 views, 80+ metrics
                   distribution · velocity · share · pricing
                   [adjustable: add views, redefine KPIs]
──────────────────────────────────────────────────────
SEMANTIC CONFIG   brand mappings, thresholds, category
                   definitions, competitive sets
                   [swap config per client or category]
──────────────────────────────────────────────────────
ANALYSIS FLOWS    competitive grid · story mining · pricing
                   distribution gaps · trend analysis · ...
──────────────────────────────────────────────────────
PLUGINS           ┌────────────────────────────────────┐
                   │ category-review-deck  [downloadable]│
                   │ competitive-grid      [downloadable]│
                   └────────────────────────────────────┘

Claude · DuckDB · MARP