Prompt: Write a Campaign Performance Report Narrative
For Email Marketing Specialists
Level 1 — Free chatbot (ChatGPT or Claude) | Time: 5 minutes
The Prompt
Analyze the following email campaign performance data and write a stakeholder report.
Campaign period: [week/month/quarter and date range]
Campaigns sent: [number]
Performance data:
[paste your metrics table — open rate, CTR, conversion rate, revenue, unsubscribes, etc.]
Context:
- Industry benchmarks: [open rate X%, CTR X%, conversion X%]
- What we were testing this period: [A/B tests run]
- External factors: [sales, holidays, deliverability issues, list changes]
- Audience size change: [list growth or decline]
Write:
1. Executive summary (3 sentences: what happened, key highlight, key concern)
2. Performance vs. benchmark (table comparing our metrics to benchmarks with delta)
3. What drove performance (top 3 factors, data-supported)
4. What underperformed and likely why (1-2 items)
5. A/B test results and what we learned
6. 3 strategic recommendations for next period (specific and actionable)
Tone: Professional but plain. No jargon. Written for a marketing director who understands metrics but doesn't want to decode data.
How to Use This
Have your data pulled and organized before running this prompt. The AI can't pull data from your ESP — your job is to extract and paste the numbers. Once the numbers are in, the interpretation and narrative writing takes about 30 seconds.
For the "context" section: Don't skip it. The AI will interpret a low open rate as a content problem when it was actually a deliverability issue. Give it the context and it will interpret correctly.
The recommendations section is where AI earns its keep. You know what performed — the AI can surface strategic frameworks for why and what to do about it. Review its recommendations critically; they're often textbook-correct but may miss something specific to your brand or audience.
Example Input
Period: February 2026
Campaigns sent: 8 (4 promotional, 2 automated, 2 transactional)
Data:
| Campaign | Open Rate | CTR | Conv Rate | Revenue |
|----------|-----------|-----|-----------|---------|
| Valentine's promo | 31% | 4.2% | 2.1% | $8,400 |
| Flash sale | 28% | 3.8% | 1.9% | $6,200 |
| Win-back series | 18% | 1.2% | 0.4% | $1,100 |
| New arrivals | 22% | 2.9% | 1.2% | $3,800 |
[etc.]
Industry benchmarks: Open 22%, CTR 2.5%, Conv 1.5%
Testing: Personalized vs. generic subject lines (4 campaigns)
External: Valentine's Day drove above-average engagement Feb 10-14
List change: +800 new subscribers from paid social campaign
What good output looks like:
- Executive summary that leads with the Valentine's success and flags win-back underperformance
- Clear table showing we beat benchmarks on open rate and CTR but missed on conversions for win-back
- Recommendation to audit win-back flow incentive timing (introducing discount too early)
Variations
For a quick weekly summary (not a full report):
Write a 5-bullet weekly email performance summary for my manager.
This week's results: [paste metrics].
Tone: Casual Slack message. Lead with what's interesting, not what's obvious.
For a client-facing agency report:
Add: "Audience: external client who doesn't see our ESP day-to-day.
Include a 'What This Means for Your Business' section that connects metrics
to business outcomes, not just email outcomes."
Works with: ChatGPT (free), Claude (free) — Claude is particularly good at structured report writing