Marketing Analytics Dashboard & Report Template

## ROLE
You are a marketing analytics lead who has built reporting systems for marketing teams spending $50K to $5M per month. You bridge the gap between raw data and strategic decisions, creating dashboards and reports that CMOs and CEOs actually read and act on.

## OBJECTIVE
Design a complete marketing analytics reporting framework for [COMPANY NAME] that tracks the right metrics at every funnel stage, attributes revenue accurately, and presents insights in executive-ready format for [REPORTING AUDIENCE].

## TASK

**STEP 1: METRICS HIERARCHY**
Define the metrics pyramid for [COMPANY NAME]:

Level 1 — North Star Metrics (Board/CEO level):
- Revenue attributed to marketing: $[CURRENT/TARGET]
- Customer Acquisition Cost (CAC): $[CURRENT/TARGET]
- Marketing-sourced pipeline: $[CURRENT/TARGET]
- Marketing ROI: [CURRENT/TARGET]x return

Level 2 — Channel Performance (CMO level):
- Cost per lead by channel: [PAID SEARCH / SOCIAL / CONTENT / EMAIL / EVENTS]
- Conversion rate by funnel stage: Visitor → Lead → MQL → SQL → Customer
- Channel-specific ROAS: return on ad spend per platform
- Organic traffic growth rate: [MONTHLY TARGET]%

Level 3 — Campaign Metrics (Manager level):
- Individual campaign ROI and lead volume
- Email performance: open rate, CTR, conversion rate
- Content performance: traffic, engagement, lead gen per asset
- Social media: reach, engagement rate, referral traffic
- Paid media: CPC, CPM, CTR, conversion rate, ROAS

Level 4 — Operational Metrics (Specialist level):
- Website: sessions, bounce rate, time on site, pages per session
- SEO: keyword rankings, backlinks, domain authority, organic CTR
- Technical: page load speed, mobile performance, crawl errors
- Database health: list growth rate, deliverability, unsubscribe rate

**STEP 2: ATTRIBUTION MODEL SETUP**
Recommended attribution model for [BUSINESS MODEL]:

| Model | When to Use | How It Works |
|-------|------------|--------------|
| First Touch | Brand awareness focus | 100% credit to first interaction |
| Last Touch | Short sales cycle | 100% credit to converting touchpoint |
| Linear | Multiple equal touchpoints | Equal credit across all touches |
| Time Decay | Long sales cycle (recommended for B2B SaaS) | More credit to recent touches |
| Position-Based | Balanced view | 40% first, 40% last, 20% middle |
| Data-Driven | Advanced (needs 300+ conversions/month) | ML-based credit distribution |

Implementation for [COMPANY NAME]:
- Primary model: [RECOMMENDED MODEL] for executive reporting
- Secondary model: [ALTERNATIVE] for channel optimization
- UTM parameter structure: utm_source / utm_medium / utm_campaign / utm_content / utm_term
- Standard naming conventions for all campaigns: [NAMING FRAMEWORK]
- CRM integration: [CRM NAME] ↔ [ANALYTICS TOOL] sync

**STEP 3: DASHBOARD DESIGN**

Dashboard 1 — Executive Overview (Updated: Real-time):
Row 1: Revenue / Pipeline / CAC / Marketing ROI (big number cards)
Row 2: Funnel visualization — Visitors → Leads → MQLs → SQLs → Customers (with conversion rates)
Row 3: Channel performance comparison — leads and cost per lead by channel (bar chart)
Row 4: Month-over-month trend lines for top 5 KPIs
Row 5: Top 5 campaigns by ROI this month (table)

Dashboard 2 — Channel Deep-Dive (Updated: Weekly):
- Tab per channel: [PAID SEARCH / PAID SOCIAL / ORGANIC / EMAIL / CONTENT / EVENTS]
- Each tab includes: spend, leads, CPL, conversion rate, ROAS, trending
- Comparison view: this month vs. last month vs. same month last year
- Budget pacing: actual spend vs. planned spend with projection

Dashboard 3 — Content Performance (Updated: Weekly):
- Top 10 pages by traffic and lead generation
- Content type performance: [BLOG / EBOOK / WEBINAR / VIDEO / PODCAST]
- SEO keyword ranking movement tracker
- Content ROI: production cost vs. attributed pipeline per asset

Dashboard 4 — Email & Nurture (Updated: Weekly):
- Campaign performance overview: sends, opens, clicks, conversions
- List health: growth rate, deliverability, engagement score distribution
- Automation performance: drip campaign conversion rates
- A/B test results log

**STEP 4: MONTHLY REPORT TEMPLATE**

[COMPANY NAME] Marketing Report — [MONTH YEAR]

1. Executive Summary (half page):
- Headline metrics vs. targets (green/yellow/red indicators)
- Top 3 wins this month
- Top 3 challenges or misses
- Key strategic recommendation

2. Funnel Performance (1 page):
- Full funnel metrics table with MoM and YoY comparison
- Conversion rate analysis at each stage
- Bottleneck identification and recommended actions

3. Channel Performance (1-2 pages):
- Spend allocation vs. results by channel
- Channel efficiency ranking
- Budget reallocation recommendations for next month

4. Campaign Highlights (1 page):
- Top 3 campaigns by ROI with breakdown
- Underperforming campaigns and learnings
- Upcoming campaign preview for next month

5. Pipeline & Revenue Attribution (1 page):
- Marketing-sourced vs. marketing-influenced pipeline
- Closed-won revenue attributed to marketing
- Average deal cycle length from marketing leads

6. Next Month Plan (half page):
- Budget allocation
- Key campaigns planned
- Tests and experiments to run
- Resource needs

**STEP 5: TOOL STACK RECOMMENDATIONS**
Based on [COMPANY SIZE] and [BUDGET]:

| Function | Tool Options | Cost Range |
|----------|-------------|------------|
| Web Analytics | GA4 / Plausible / Mixpanel | Free-$$$  |
| Dashboard | Looker Studio / Databox / Klipfolio | Free-$$$  |
| Attribution | HubSpot / Dreamdata / Bizible | $$-$$$$ |
| SEO | Ahrefs / SEMrush / Moz | $$-$$$ |
| Email Analytics | Built into ESP | Included |
| Social Analytics | Sprout Social / Buffer / Native | $-$$$ |
| BI Layer | Metabase / Tableau / Power BI | Free-$$$$ |

**STEP 6: IMPLEMENTATION ROADMAP**
- Week 1-2: Audit current tracking, fix UTM gaps, connect data sources
- Week 3-4: Build executive dashboard and first monthly report
- Month 2: Add channel dashboards and begin attribution tracking
- Month 3: Full reporting system live with automated data pulls
- Ongoing: Monthly report delivery on [DAY OF MONTH], quarterly deep dives

## INPUT
- **Company**: [COMPANY NAME AND BUSINESS MODEL]
- **Marketing channels used**: [LIST ALL ACTIVE CHANNELS]
- **Monthly marketing budget**: [TOTAL SPEND]
- **Current tools**: [ANALYTICS, CRM, ESP, AD PLATFORMS]
- **Reporting audience**: [WHO READS THE REPORTS — CEO/CMO/TEAM]
- **Biggest analytics gap**: [WHAT YOU CURRENTLY CANNOT MEASURE]