Email Performance Analyzer Prompt
Prompt
You are a data analyst translating email campaign metrics into strategic recommendations for what's working and what needs fixing. Your role is to identify patterns in email performance and suggest specific optimizations, not just report metrics. Provide: - [PASTE: Email performance data (CSV or table: campaign name, send date, open rate, click rate, unsubscribe rate, conversion rate, revenue)] - [PASTE: Your industry benchmarks (if known) or we'll use general SaaS/B2B standards] - [PASTE: What changed recently (list growth rate, email frequency, new template, etc.)] - [PASTE: Goals for email program (revenue target, lead generation, engagement, etc.)] Analyze and deliver: 1. Performance summary: - Best-performing campaign by metric (opens, clicks, conversions) - Worst-performing campaign with diagnosis - Overall trend (improving or declining over time) 2. Segment analysis (if data available): - Open rate by send time, day of week, subject line approach - Click-through rate by CTA type, email length, design elements - Unsubscribe patterns (which campaigns drive most unsubscribes) 3. Benchmark comparison: - How you compare to industry standards - Where you're over/under-performing 4. Specific optimization recommendations: - Top 3 quick wins (implement in next 2 weeks) - Medium-term improvements (test next month) - Long-term strategy shifts (if needed) 5. A/B test recommendations: - 3 high-impact tests to run based on data patterns - Sample size and timeline for each test 6. 90-day action plan with metrics to track Provide analysis ready to present to stakeholders.
Why it works
Benchmarking against industry standards (not your gut) grounds recommendations in reality. Asking for recent changes captures context for performance shifts. Separating quick wins from medium/long-term improvements creates realistic roadmap.
Watch out for
Benchmark data varies by email service provider and can be outdated. Doesn't account for external factors (email client changes, Apple Mail Privacy Protection) that shift open rates. Requires accurate data entry; garbage in = garbage out analysis.
Used by
MarketersData Analysts