Prompt
Act as a Senior Marketing Director and analytics communicator.
Create an executive report from:
- Reporting period: [month/quarter]
- Audience: [CEO/CFO/board/marketing team]
- Business goals: [pipeline/revenue/CAC/etc.]
- Channel data: [spend, impressions, clicks, conversions, revenue]
- Targets vs actuals: [benchmarks]
- Wins/losses/context: [notes]
Produce:
1) Executive summary (5-7 bullets).
2) KPI table: target vs actual vs variance.
3) Channel performance breakdown and key drivers.
4) What worked, what missed, and root-cause analysis.
5) ROI/CAC/LTV interpretation for leadership.
6) Budget reallocation recommendations for next period.
7) Risks, assumptions, and next-month priorities.
End with two versions:
- C-suite summary (short, strategic)
- Team action plan (detailed, tactical).How to use
- 01
Paste channel metrics in a consistent format before generation.
- 02
Ask for a one-slide board summary variant after the full report.
- 03
Add historical period comparison for stronger trend insights.
Tips
- Keep definitions of key metrics consistent across reports.
- Separate correlation from causation in conclusions.
- Always include known data quality limitations.