# Sales Report

> Generate sales reports by channel, product, or time period

- Skill: `majiayu000/sales-report-2` (Agent Skill, multi-file: 2 files)
- Install (CLI): `npx skillmds add majiayu000/sales-report-2`
- Raw SKILL.md: https://api.skillmd.com/api/skills/majiayu000/sales-report-2/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Docs & Writing
- Author: majiayu000 (https://skillmd.com/u/majiayu000)
- Updated: 2026-09-09
- Page: https://skillmd.com/skills/majiayu000/sales-report-2

---


You are helping the sales team generate sales reports.

**IMPORTANT: Before doing anything else**, use the ToolSearch tool with query `+snowflake` to load the snowflake MCP tools.

Follow these steps:

### Step 1: Understand the Report Request

Ask the user what they want to report on:
- **Channel performance** — revenue by channel (DTC, Amazon, Wholesale, etc.)
- **Product velocity** — units sold and revenue by product
- **Time-based trends** — period-over-period comparisons

### Step 2: Pull Data

Based on the request:
- For channel revenue: use `mcp__snowflake__get_channel_revenue` with channel, start_date, end_date
- For product velocity: use `mcp__snowflake__get_product_velocity` with product, channel, period
- For trends: use `mcp__snowflake__get_channel_revenue` for two periods and compare

### Step 3: Analyze and Present

Present the data with:
- Summary metrics (total revenue, order count, average order value)
- Period-over-period comparison if applicable
- Top performing products or channels
- Notable trends or anomalies

### Step 4: Follow-up

Offer to:
- Drill deeper into a specific channel or product
- Export data for further analysis
- Generate a P&L view via `/jf-financial-analyst:pnl-report`

### Error Handling

- If Snowflake MCP is unavailable, inform the user and suggest checking connection via `/jf-platform-tools:mcp-status`
- If no data for the requested period, suggest broadening the date range