David Park·
Built my email KPI hierarchy with alert thresholds and the exact ROI and rev-per-email formulas
Build a complete email marketing analytics framework with KPI definitions, reporting templates, and optimization triggers.
Email Analytics Dashboard & KPI Framework
You are a marketing analytics director. Create an Email Marketing Analytics Dashboard & KPI Framework for {{company_name}}, a {{business_type}} using {{email_platform}}.
PROGRAM SCOPE:
- List size: {{list_size}}
- Monthly email volume: {{monthly_volume}}
- Attribution model: {{attribution_model}}
- Industry benchmark: {{industry}}
DELIVERABLES:
1. KPI HIERARCHY (3-tier)
PRIMARY: Revenue per email, total email revenue, list growth, ROI calculation
SECONDARY: Open rate, CTR, conversion rate, unsubscribe rate, bounce rate, spam rate
TERTIARY: Deliverability, engagement by segment, LTV by cohort, forward/share rate
2. DASHBOARD STRUCTURE
- Executive, Campaign Manager, Deliverability Health, Segment Performance views
3. REPORTING TEMPLATES
- Weekly campaign report, Monthly business impact, Quarterly review, Annual retrospective
- Fill-in templates with formulas
4. ALERT & THRESHOLD SYSTEM
- Green/Yellow/Red thresholds, automated triggers, escalation protocol
5. A/B TEST TRACKING
- Test log template, winner implementation, compound optimization tracking
6. COHORT ANALYSIS FRAMEWORK
- Acquisition month tracking, retention curves, cohort LTV, comparison methodology
7. TOOL SETUP GUIDE
- {{email_platform}} tracking setup, GA4 configuration, UTM naming convention
Provide ready-to-use spreadsheet templates in markdown table format.
Ergebnisse
# Email Analytics Framework — Harborlight (DTC coffee subscription)
Platform: Klaviyo. 95k list, 40 sends/mo, last-click attribution.
## KPI hierarchy
| Tier | Metrics |
|------|---------|
| Primary | Revenue per email, total email revenue, list growth rate, email ROI |
| Secondary | Open %, CTR, conversion %, unsub %, bounce %, spam complaint % |
| Tertiary | Deliverability %, revenue by segment, LTV by cohort, forward rate |
## Dashboards
- **Executive:** monthly email revenue, % of total revenue, list growth, ROI
- **Campaign manager:** per-send open/CTR/conv/revenue
- **Deliverability:** bounce, spam rate, inbox placement by domain
- **Segment:** revenue/recipient per segment
## Weekly report template
| Campaign | Sent | Open % | CTR | Conv % | Revenue | Rev/email |
|----------|------|--------|-----|--------|---------|-----------|
| (fill) | | | | | | |
**ROI formula:** `(email revenue − platform cost) / platform cost`.
**Rev per email:** `total attributed revenue / emails delivered`.
## Alert thresholds
| Metric | Green | Yellow | Red |
|--------|-------|--------|-----|
| Bounce | <1% | 1–2% | >2% |
| Spam | <0.05% | 0.05–0.1% | >0.1% |
| Open | >35% | 25–35% | <25% |
Red on spam rate → pause sends, investigate list source. **UTM convention:** `utm_source=klaviyo&utm_medium=email&utm_campaign=[flow]_[date]`.
Modell: Claude Sonnet 4
12 Likes2 SavesScore: 11
1 Kommentar
Marcus Bell·
The avatar is scary specific. That's how you know it'll convert.