WHAT WE DID (how the numbers were made)

1. Read the file

Opened sales_pulse.csv — 1,200 rows, Jan–Sep 2026.

2. Counted everything

Added revenue, orders per month, per product, per region.

3. Cross-checked

Every stat computed twice, straight from rows — no guessing.

4. Looked for stories

Found the July spike and the returns pattern.

5. Wrote the verdict

Scored what is fine and what needs fixing.

KEY FINDINGS (the 4 big takeaways)

1. Money looks great

✅$1.49M total — about $5.5k every single day. Typical order: $1,240.

Source: totals, all 1,200 rows

2. Nobody carries the team

✅5 products within 22%–17% share; 4 regions within 3 points. Balanced.

Source: product & region tallies

3. July went wild

❓153 orders vs 119 in June (+29%) — then back to normal. Cause unknown.

Source: monthly counts

4. Returns are heavy

⚠️1 in 4 orders comes back (25.4%). Only Doohickeys stays low at 20.3%.

Source: returned column

BABY GRAPH (orders per month)

🟩 normal month · 🟧 the July spike (153)

TL;DR BABY MODE (one-liners)

✅ Selling: strong and steady, no bad months.
✅ Risk: no product or region dependency.
❓ July: awesome, but nobody knows why yet.
⚠️ Returns: 1 in 4 back — biggest fixable leak.

👶

Money OK?
YES ✅

➜

Balanced?
YES ✅

➜

July explained?
NOT YET ❓

➜

Returns fine?
NO ⚠️

➜

OVERALL: HEALTHY

(fix the returns)

💡 Bottom line: The store earns well and stands on many legs — but 1 of every 4 boxes comes back. Fix returns first; investigate July second.

Sales Pulse — Data Verdict Report