Executive Email Marketing Dashboard with Strategic KPIs
Dashboard template that consolidates the most important email marketing metrics for stakeholder presentations and decision-making.
Create an actionable dashboard that goes beyond open and click metrics, connecting email marketing performance to business outcomes to support executive reporting and investment decisions.
At a glance
Access
Free prompt
Open to copy — no account or payment needed.
Prompt objective
Create an actionable dashboard that goes beyond open and click metrics, connecting email marketing performance to business outcomes to support executive reporting and investment decisions.
Real use case
The Marketing Head at FarmaVida needs to present monthly email marketing results to the board, but only has isolated open and click numbers. The board wants to see revenue impact, channel comparisons, and growth projections.
Customize these fields first
Replace the placeholders with your own context before you run the prompt. That usually improves the first output more than adding more instructions later.
Prompt
Create an executive email marketing dashboard for [COMPANY NAME], operating in the [INDUSTRY] sector, for [FREQUENCY: weekly/monthly/quarterly] reporting. Context: - Email platform: [PLATFORM] - Analytics platform: [GA4/Mixpanel/Amplitude] - E-commerce/CRM: [PLATFORM] - Dashboard audience: [CEO/CMO/Marketing Head/Team] - Detail level: [EXECUTIVE/OPERATIONAL] **1) Executive-level KPIs (top panel):** **Big numbers (4 cards):** - Revenue attributed to email for the period (currency) - Channel ROI (%) — (Revenue - Cost) / Cost - Net base growth (new subscribers - removed) - Engagement health score (0-100) **Trending indicators (arrows ↑↓):** - Change vs. previous period - Change vs. same period last year - Status: green (above target), yellow (near target), red (below target) **2) Campaign performance KPIs:** **Primary metrics (table with benchmarks):** | Metric | Current | Target | Industry Benchmark | Status | |--------|---------|--------|-------------------|--------| | Open rate | [X]% | [Y]% | [Z]% | ✅/⚠️/❌ | | Click-through rate (CTR) | [X]% | [Y]% | [Z]% | | | Click-to-open rate (CTOR) | [X]% | [Y]% | [Z]% | | | Conversion rate | [X]% | [Y]% | [Z]% | | | Revenue per email sent | [CURRENCY][X] | [CURRENCY][Y] | [CURRENCY][Z] | | | Unsubscribe rate | [X]% | <[Y]% | [Z]% | | | Spam complaint rate | [X]% | <0.1% | [Z]% | | | Bounce rate | [X]% | <[Y]% | [Z]% | | **Trend chart (6-12 months):** - Line: Open rate over time - Bars: Send volume - Overlay: Key events (Black Friday, product launch, etc.) **3) Automation KPIs:** **Per active automation:** | Automation | Emails/month | Opens | Clicks | Conversion | Revenue | |------------|-------------|-------|--------|------------|---------| | Welcome series | [X] | [X]% | [X]% | [X]% | [CURRENCY][X] | | Abandoned cart | [X] | [X]% | [X]% | [X]% | [CURRENCY][X] | | Lifecycle | [X] | [X]% | [X]% | [X]% | [CURRENCY][X] | | Win-back | [X] | [X]% | [X]% | [X]% | [CURRENCY][X] | **4) List health KPIs:** **List composition (donut chart):** - Super engaged: [X]% - Active: [X]% - Warm: [X]% - Cold: [X]% - Inactive: [X]% **Growth metrics:** - New subscribers/month (by acquisition channel) - Churn rate (unsubscribes + bounces + cleaning) - Net growth rate - Projection: List size at 6 and 12 months **5) Cross-channel comparison:** | Channel | Investment | Revenue | ROI | CAC | |---------|------------|---------|-----|-----| | Email Marketing | [CURRENCY][X] | [CURRENCY][X] | [X]% | [CURRENCY][X] | | Meta Ads | [CURRENCY][X] | [CURRENCY][X] | [X]% | [CURRENCY][X] | | Google Ads | [CURRENCY][X] | [CURRENCY][X] | [X]% | [CURRENCY][X] | | Organic/SEO | [CURRENCY][X] | [CURRENCY][X] | [X]% | [CURRENCY][X] | **6) Dashboard implementation:** - Recommended tool: [Google Data Studio/Metabase/Supermetrics/manual] - Data sources and required integrations - Update frequency (automated vs. manual) - Google Sheets template for manual data entry - Slide template for executive presentation (structure) **7) Insights and recommendations (monthly section):** - Top 3 learnings from the period - Top 3 identified opportunities - Recommended actions for next period - Risks and alerts
Open directly in an AI — the text is pre-filled:
How to use this prompt
- 1Replace the key placeholders first: COMPANY NAME, INDUSTRY, FREQUENCY: weekly/monthly/quarterly, PLATFORM.
- 2Replace any bracketed placeholders like [this] with your own context.
- 3Add extra background information when you want more tailored results.
- 4Combine multiple prompts in one conversation when you need a richer output.
- 5Save your best-performing prompts so they are easy to reuse later.
Next best step
Open the guide first, then branch only if you still need more.
A practical guide for marketers who want campaigns, prompts, and automations that shorten execution time.
If this prompt is close but not quite right, generate variants next. If the job is recurring, move into the course library after the guide.
Related prompts
View allComplete Email Deliverability Audit
Diagnostic framework to identify and resolve deliverability issues affecting inbox placement rates.
Best for
Conduct a technical and strategic email deliverability audit, identifying factors harming inbox delivery and creating a prioritized correction plan.
Systematic A/B Testing Framework for Email Marketing
Complete methodology for running statistically valid A/B tests on email campaigns, from planning through analysis.
Best for
Establish a scientific, repeatable process for A/B test optimization that generates incremental, measurable improvements in email marketing performance over time.
Email Marketing ROI Calculator with Financial Model
Complete financial model for calculating return on investment in email marketing, including direct costs, indirect costs, and revenue attribution.
Best for
Build a financial model that demonstrates the true ROI of email marketing, enabling justification of investments, comparison with other channels, and optimization of budget allocation.
Engagement Scoring System for List Quality
A scoring model that classifies each contact by email engagement level, fueling segmentation decisions and list hygiene.
Best for
Build a continuous scoring system that monitors email list health in real time, identifying disengagement trends before they impact deliverability and triggering preventive actions.
Explore other prompt categories
Move sideways into adjacent libraries when the current category is not the full answer.
Every prompt here is free. The course teaches the thinking behind them.
Copy as many prompts as you like. When you want to move from single prompts to a repeatable AI workflow, Learn AI in 30 Days walks through it, one day at a time.
Buy the course once ($15/$20 by length), or go all-access for $10/mo with a verifiable certificate.