# Project 1 — Monthly Sales Commentary Generator
# From Spreadsheets to AI Tools — Book 6, Waskey Press

WHAT YOU WILL BUILD:
A reusable prompt chain that generates monthly sales commentary
automatically from your data.

STEP 1 — PREPARE YOUR DATA
Open sales.csv and filter to one month.
Copy 20-30 rows.

STEP 2 — RUN PROMPT 1 (Extract KPIs)
─────────────────────────────────────
Here is my sales data for [Month Year]:
[PASTE YOUR DATA]

Extract these KPIs:
- Total revenue (Delivered orders only)
- Order count (total and per status)
- Top 3 customers by revenue
- Top 3 products by revenue
- Region with highest revenue and its share of total
Format as a numbered list with exact figures.

STEP 3 — RUN PROMPT 2 (Write Commentary)
─────────────────────────────────────────
Using these KPIs for [Month Year]:
[PASTE PROMPT 1 OUTPUT]

Write a 3-paragraph monthly sales commentary:
Para 1: Overall performance vs [prior month or target if known]
Para 2: Regional and product highlights
Para 3: One forward-looking observation or recommendation

Tone: professional analyst report. No bullet points. No "this report".
Maximum 200 words total.

STEP 4 — RUN PROMPT 3 (Format for Slide)
─────────────────────────────────────────
Convert this commentary into 4 PowerPoint bullets:
[PASTE PROMPT 2 OUTPUT]
- Max 12 words per bullet
- Start with a verb or metric
- Keep all key numbers

STEP 5 — SAVE YOUR TEMPLATE
Save the three prompts above in a text file.
Replace [Month Year] and the data section each month.
You now have a repeatable 5-minute monthly reporting workflow.
