Marketing Analytics Report

Prompt

Build a comprehensive monthly marketing analytics report for [COMPANY NAME] for [REPORTING PERIOD].

Marketing channels active: [LIST — PAID SEARCH, PAID SOCIAL, EMAIL, SEO, EVENTS, CONTENT, ETC.]
Marketing spend this period: [TOTAL AMOUNT]
Revenue attributed to marketing: [AMOUNT OR 'UNKNOWN']
Key metrics available: [LIST WHAT DATA YOU HAVE ACCESS TO]
Audience: [CMO / CEO / BOARD / MARKETING TEAM]

Report structure:

1. **Executive Summary** — One page. Performance vs. targets, budget vs. actuals, top wins, top gaps. Any CMO needs to make a decision from this page.

2. **Pipeline and Revenue Attribution** — Marketing-sourced and marketing-influenced pipeline. Revenue closed from marketing leads.

3. **Channel Performance Dashboard** — For each channel:
   - Spend
   - Leads generated
   - Cost per lead
   - Pipeline generated
   - Revenue attributed
   - ROI

4. **Funnel Analysis** — Conversion rates at each stage (visitor → lead → MQL → SQL → opportunity → close).

5. **Content Performance** — Top 5 and bottom 5 pieces of content by business impact (not just traffic).

6. **Email Program Health** — Open rate, click rate, deliverability, list growth.

7. **Brand and Awareness Metrics** — Organic search share, share of voice, branded search volume trend.

8. **Budget Optimization Recommendations** — Where to shift budget for next month based on performance.

9. **Next Month Focus Areas** — Top 3 priorities with success criteria.