Skip to content

takechanman1228/claude-ecom / skills/ecom

Ecommerce business review for D2C stores from order transaction CSVs. Runs the bundled Python engine (KPI trees, ~30 pass/watch/fail health checks, 30d/90d/365d windows), then interprets the results: either a full narrative business review written to REVIEW.md, or an inline answer to a focused question.

---
name: ecom
description: >
  Ecommerce business review for D2C stores from order transaction CSVs.
  Runs the bundled Python engine (KPI trees, ~30 pass/watch/fail health
  checks, 30d/90d/365d windows), then interprets the results: either a
  full narrative business review written to REVIEW.md, or an inline
  answer to a focused question.
when_to_use: >
  Use for "ecommerce review", "store review", "store health", "business
  review", revenue/customer/product analysis of an online store, or
  questions over order data like "how was last month", "how's retention",
  "why did revenue drop".
argument-hint: "review [30d|90d|365d] [question]"
allowed-tools:
  - Read
  - Grep
  - Glob
  - Write
  - Bash(ecom *)
---

# ecom β€” Ecommerce Business Review Toolkit

D2C ecommerce analytics. The bundled Python engine computes KPIs, runs
health checks, and scores performance from order transaction data;
**you** (Claude) interpret the numbers and write the human-readable report.

**Key principle:** Python computes the numbers. Claude interprets them.
Never present raw numbers without business context.

**Arguments:** `$ARGUMENTS` (if empty, infer intent from the conversation)

## Mode Selection

| Arguments / intent | Mode | Output |
|---|---|---|
| empty or `review` | Full Review (auto-selects periods from data) | `REVIEW.md` |
| `review 30d` / `90d` / `365d` | Full Review, single period | `REVIEW_{PERIOD}.md` |
| contains a natural-language question | Focused Query | Inline answer, no file |

## Input

Order transaction CSV. Each row = one order or line item.
Required columns: order ID, order date, customer ID (or email), revenue
(after discounts, before tax/shipping). Optional: quantity, SKU/product,
discount amount. Column names are fuzzy-matched by the loader.

If no CSV is specified, Glob for `*.csv` in the working directory and ask
the user if multiple plausible candidates exist.

## Running the Engine

The `ecom` CLI is on PATH while this plugin is enabled:

```bash
ecom review orders.csv --output <output-dir>
ecom review orders.csv --period 90d --output <output-dir>
```

If `ecom` is not on PATH, use the bundled launcher with the same
arguments: `"${CLAUDE_SKILL_DIR}/../../bin/ecom"`. The first run
bootstraps a private Python venv under `~/.local/share/claude-ecom/`
and may take a minute; later runs are instant.

Output: `review.json` (or `review_{period}.json` for `--period` runs)
in the output directory (defaults to current directory).

## Workflow

### Phase 1: Compute (Python)

Run the engine (add `--period` per Mode Selection). It computes, per
available period: summary KPIs with prior-period comparison, a
new-vs-returning KPI tree, revenue driver decomposition (AOV / volume /
mix), and β€” for 365d β€” repeat purchase rate and a 12-month
monthly_trend. It also evaluates ~30 health checks across Revenue,
Customer, and Product; each returns pass / watch / fail and powers the
🟒/🟑/πŸ”΄ markers.

### Phase 2: Interpret (you β€” Claude)

**Full Review:**

1. Read `review.json` (see Data Rules below; full schema in
   [review-schema.md](references/review-schema.md))
2. Read [report-format.md](references/report-format.md) β€” REQUIRED
   before writing; contains all section templates and Finding Quality
   Standards
3. Read [review-narratives.md](references/review-narratives.md) to pick
   the narrative arc
4. Load other references as needed (table below)
5. Write `REVIEW.md` (or `REVIEW_{PERIOD}.md`) satisfying the Report
   Contract below

**Focused Query:**

1. Read [focused-query.md](references/focused-query.md) β€” REQUIRED;
   contains the query-to-period mapping and answer format
2. Run the engine per that mapping, read the JSON, answer inline
   (10-30 lines). Do NOT write a file.

Your job is to weave trends and diagnostics into one coherent story.
Period analysis tells you *where things are heading*; health checks tell
you *what's broken right now*. The report combines both.

## Report Contract (Full Review)

Before writing, verify the report will contain ALL sections in this
exact order. Missing or reordered sections are a format violation.

1. [ ] Executive Summary β€” narrative blockquote (4-6 lines) + Scoreboard table
2. [ ] 30d Pulse section (if data available) β€” KPI tree + max 1 finding
3. [ ] 90d Momentum section (if data available) β€” KPI tree + drivers + max 2 findings
4. [ ] 365d Structure section (if data available) β€” KPI tree + drivers + max 3 findings
5. [ ] Action Plan β€” max 5 items grouped by time horizon + Guardrails (REQUIRED)
6. [ ] Data Notes β€” 2-4 lines

Hard rules:

- Target ~150 lines total; 5-7 findings max across all periods; never
  repeat a finding across periods
- Sections in this order; do NOT reorganize by theme; no standalone
  "What's Working Well" / "Issues to Address" sections β€” positive
  signals live in the Executive Summary and KPI tree markers
- Every period section uses the KPI tree format with 🟒/🟑/πŸ”΄ markers
- Every finding follows **What is β†’ Why it matters β†’ What to do**
  (quantitative fact β†’ data-backed tension β†’ direction; "consider",
  "improve", "optimize", "explore" are banned)
- Action Plan is the single source of truth for deadlines and success
  metrics, and ends with Guardrails (2-3 must-not-deteriorate metrics)

Templates, examples, and the full quality standards are in
[report-format.md](references/report-format.md).

## Reference Files

Load on-demand β€” do NOT load all at startup. Paths are relative to this
skill's directory.

| File | When to load |
|---|---|
| [report-format.md](references/report-format.md) | Every Full Review, before writing |
| [review-narratives.md](references/review-narratives.md) | Every Full Review β€” narrative arc by health level and trajectory |
| [focused-query.md](references/focused-query.md) | Every Focused Query |
| [review-schema.md](references/review-schema.md) | When review.json semantics are unclear |
| [finding-clusters.md](references/finding-clusters.md) | Full Review β€” to group related issues into themes |
| [recommended-actions.md](references/recommended-actions.md) | When turning watch/fail checks into actions |
| [impact-formulas.md](references/impact-formulas.md) | When estimating revenue impact |
| [health-checks.md](references/health-checks.md) | When a check's definition/threshold is unclear |
| [benchmarks.md](references/benchmarks.md) | When comparing KPIs to D2C benchmarks |

## Data Rules

- **review.json only.** All numbers MUST come from review.json or be
  derived from its values. Never reference external sources (Shopify
  Analytics, GA, ...). Recommending an external investigation as an
  action is allowed; quoting numbers from one is not.
- `periods` contains only the periods listed true in `data_coverage`;
  all `_change` fields are proportional vs the prior period (0.08 = +8%).
- `health.top_issues` is the pre-sorted subset of failing checks;
  `action_candidates` are Python's suggestions β€” refine and rewrite them
  in business language, never copy verbatim.
- Never expose internal check IDs or check counts in the report.
- When `data_quality` is non-empty, mention relevant warnings in Data
  Notes, and do not present partial-month MoM as real performance signals.

## Incomplete Data

- Omit what you can't measure. No N/A, no empty sections, no apologies.
- Shorter data = shorter report. Gaps are noted in Data Notes only.

## Language

Write the entire report (including Data Notes) in ONE language β€” match
the user's prompt/store language.

## Quality Gates

- Never present numbers without interpretation β€” always explain why
- Business language, not jargon; explain terms on first use
- Connect related findings into systemic patterns
- 80/20 rule: ~80% confirmation (builds trust), ~20% surprise (drives action)
- No numeric scores, letter grades, or percentage health ratings β€”
  pass/watch/fail signals only
deprecation-and-migrationaddyosmani/agent-skillsManages deprecation and migration. Use when removing old systems, APIs, or features. Use when migrating users from one implementation to another. Use when migrating a database schema in production, such as renaming or dropping a column without downtime (expand/contract). Use when deciding whether to maintain or sunset existing code.Stars: 119kUpdated Claude CodeCodexVerifiedInstall
performance-optimizationaddyosmani/agent-skillsOptimizes application performance across frontend, backend, queries, and databases. Use when performance requirements exist, when you suspect performance regressions, when Core Web Vitals or load times need improvement, when N+1 query patterns need fixing, or when profiling reveals bottlenecks.Stars: 119kUpdated Claude CodeCodexVerifiedInstall
agent-cost-reportthedotmack/claude-memBelievable agent cost report for any period, default the last 7 full days PT, not counting today. Measured tokens from Claude Code transcripts priced at OpenRouter list prices (ESTIMATED), measured provider spend when a sanctioned source exists, note-taker cost separate, Timing-style HTML/PDF plus report.json, line-items.csv, evidence.json.Stars: 118kUpdated Claude CodeCodexUnverifiedInstall
agent-cost-reportthedotmack/claude-memBelievable agent cost report for any period, default the last 7 full days PT, not counting today. Measured tokens from Claude Code transcripts priced at OpenRouter list prices (ESTIMATED), measured provider spend when a sanctioned source exists, note-taker cost separate, Timing-style HTML/PDF plus report.json, line-items.csv, evidence.json.Stars: 118kUpdated Claude CodeCodexUnverifiedInstall