The Problem
David, an operations manager, spent every Friday compiling a weekly report from 5 different data sources: sales numbers, support tickets, engineering sprint velocity, marketing metrics, and budget tracking.
Time spent: 5 hours every Friday Frustration: High — it was copy-paste work that required zero thinking
The Solution
David created a master prompt that he pastes into Claude with his raw data:
"You are a business analyst. Below is raw data from 5 sources. Create a weekly executive summary report with:
1. Overall Summary (3-4 sentences)
2. Key Wins (bullet points, 3-5 items)
3. Areas of Concern (bullet points with data)
4. Metrics Table (formatted markdown)
5. Recommendations (2-3 actionable items)
>
Keep it concise. Use numbers. Flag anything that changed more than 10% from last week."
Before vs After
| Aspect | Before | After | |--------|--------|-------| | Time | 5 hours | 15 minutes | | Quality | Inconsistent | Consistent, professional | | Stress | High (Friday dread) | Minimal | | Format | Varies week to week | Standardized | | Distribution | Manual copy-paste to email | Copy once, paste to email |
The Setup Process
- Collect data: Export CSVs from each tool (10 min)
- Paste data: Copy key numbers into the prompt (3 min)
- Generate: Run the prompt (30 sec)
- Review: Quick sanity check (2 min)
- Send: Copy to email and distribute (1 min)
Total: ~15 minutes per week
Annual Impact
- Time saved: 5 hrs × 50 weeks = 250 hours/year
- Equivalent salary savings: ~$12,500/year (at $50/hr equivalent)
- Better reports: CEO said the AI reports were clearer than David's manual ones
Key Takeaway
The best AI use cases aren't always glamorous. Automating boring, repetitive tasks gives you hours back every week.
Try It
Browse our productivity prompts for similar automation ideas.