small-business-sales-brieflisted
Install: claude install-skill simongonzalezdc/codex-small-business-skills
Run the sales analysis and content brief. Pull what sold (and what didn't), explain why, and produce a ready-to-use content plan that acts on the data.
Parse arguments:
- `--lookback` (default: `30d`) — `30d`, `60d`, or `90d` lookback window
## Step 1 — Sales breakdown
Using the `content-strategy` skill workflow for sales analysis:
1. Pull PayPal transactions for the lookback period grouped by item/service/SKU.
2. Pull QuickBooks revenue by product/service category.
3. Rank products by: total revenue, unit volume, and margin (if available in QB).
4. Calculate each product's share of total revenue vs. prior equivalent period.
Top sellers: products that grew share or maintained top-3 rank.
Bottom sellers: products with declining volume or below 5% of revenue.
## Step 2 — Seasonality check
1. Compare current period to same period in prior year (if QB history available).
2. Flag any items with a seasonal pattern (e.g., spikes in Q4, slow summers).
3. Note any new products with insufficient history to detect seasonality.
## Step 3 — Why analysis
For each top and bottom seller, explain the likely driver:
- Price change, promo, new channel, seasonal demand, competitor move
- Cross-reference with HubSpot campaign activity for the period
- Note where attribution is inferred vs. confirmed
## Step 4 — 2-week content brief
Produce a ready-to-use content brief:
```
2-Week Content Brief — {date range}
PUSH THESE (winners)
• {product}: {suggested angle} — {channel: email|social