Marketing AI Skill

Executive Marketing Dashboard

High-level marketing performance dashboard for executives and stakeholders with cross-channel KPI aggregation, budget tracking, campaign performance, goal progress, trend analysis, and automated executive reporting. Use when building executive dashboards, p...

Executive Marketing Dashboard

High-impact marketing performance visualization and reporting for executive stakeholders and C-level audiences.

Workflow

  1. Identify executive information needs: What decisions will this data inform?
  2. Define KPI hierarchy: North-star metrics → supporting metrics → diagnostic metrics.
  3. Aggregate data from all marketing channels into unified data warehouse.
  4. Build executive dashboard: Real-time KPI overview with drill-down capability.
  5. Configure automated report scheduling: Weekly flash report, monthly comprehensive report.
  6. Implement alert system for KPI threshold breaches and budget anomalies.
  7. Prepare quarterly business review (QBR) presentation templates.
  8. Conduct monthly executive briefings with insights and strategic recommendations.

KPI Hierarchy

EXECUTIVE KPI PYRAMID
======================

TIER 1 — NORTH-STAR METRICS (C-Level View):
  These 4-6 metrics tell the complete story in 30 seconds.

  1. MARKETING-ATTRIBUTED REVENUE:
     → Total revenue attributed to marketing activities
     → Includes: Direct attribution + assisted attribution
     → Benchmark: Varies by business model (SaaS: 20-40% of total revenue)
     → Trend: Month-over-month and year-over-year comparison

  2. MARKETING ROI (MAR):
     → Formula: (Revenue Attributed to Marketing − Marketing Spend) / Marketing Spend × 100
     → Benchmark: 200-400% for mature marketing organizations
     → Target: > 100% minimum (earning more than spending)
     → Industry average: ~272% (ANA / McKinsey)

  3. CUSTOMER ACQUISITION COST (CAC):
     → Formula: Total Marketing Spend / New Customers Acquired
     → Benchmark: Varies widely by industry
     → SaaS: $500-$2,000 (B2B), $50-$200 (B2C)
     → E-commerce: $20-$100
     → Trend: Should decrease or stay stable as marketing matures

  4. LTV:CAC RATIO:
     → Formula: Customer Lifetime Value / Customer Acquisition Cost
     → Benchmark: 3:1 minimum, 5:1 healthy, 7:1+ excellent
     → Below 2:1: Unsustainable — must reduce CAC or increase LTV
     → Above 10:1: May be under-investing in growth

  5. TOTAL LEADS / PIPELINE GENERATED:
     → Marketing-qualified leads (MQLs) generated
     → Sales-qualified leads (SQLs) passed to sales
     → Pipeline value created by marketing
     → Benchmark: 5-10x marketing budget in pipeline value (B2B)

  6. REVENUE PER DOLLAR SPENT (MER / ROAS):
     → Marketing Efficiency Ratio = Total Revenue / Total Marketing Spend
     → Benchmark: 5:1 to 10:1 healthy
     → Below 3:1: Inefficient marketing
     → Above 15:1: May indicate under-investment

TIER 2 — CHANNEL PERFORMANCE (VP / Director View):

  BY CHANNEL:
  ┌──────────────────┬──────────┬──────────┬──────────┬──────────┬──────────┐
  │ Channel          │ Spend    │ Leads    │ Conv.    │ Revenue  │ ROAS     │
  ├──────────────────┼──────────┼──────────┼──────────┼──────────┼──────────┤
  │ Organic Search   │ $0       │ 1,200    │ 380      │ $95,000  │ ∞        │
  │ Paid Search      │ $18,000  │ 850      │ 290      │ $62,300  │ 3.5x     │
  │ Paid Social      │ $12,000  │ 420      │ 120      │ $24,000  │ 2.0x     │
  │ Email            │ $3,000   │ 380      │ 260      │ $42,800  │ 14.3x    │
  │ Content / Blog   │ $8,000   │ 650      │ 180      │ $32,500  │ 4.1x     │
  │ Display / Video  │ $5,000   │ 120      │ 35       │ $8,750   │ 1.8x     │
  │ Referral / Partner│$2,000   │ 180      │ 75       │ $18,750  │ 9.4x     │
  │ ─────────────────┼──────────┼──────────┼──────────┼──────────┼──────────┤
  │ TOTAL            │ $48,000  │ 3,800    │ 1,340    │ $284,100 │ 5.9x     │
  └──────────────────┴──────────┴──────────┴──────────┴──────────┴──────────┘

TIER 3 — DIAGNOSTIC METRICS (Manager / Analyst View):
  → CTR by channel and campaign
  → CPC / CPM by channel
  → Conversion rate by landing page
  → Email open rate and click rate
  → Social engagement rate
  → Content engagement metrics
  → Funnel drop-off rates
  → Attribution model comparisons

Dashboard Views

EXECUTIVE DASHBOARD — MAIN VIEW
=================================

  ┌───────────────────────────────────────────────────────────────────┐
  │ MARKETING PERFORMANCE DASHBOARD — Q2 2024                         │
  │ Period: Apr 1 — Jun 30  │  Budget: $150,000  │  Spent: $112,400   │
  │ Last updated: 2 hours ago                                           │
  ├───────────────────────────────────────────────────────────────────┤
  │                                                                    │
  │  $847,200          312%            $186           4.2:1            │
  │  Attributed Rev    Marketing ROI   CAC             LTV:CAC         │
  │  ▲ 18.5%           ▲ 45pts         ▼ 12%           ▲ 0.3          │
  │  vs. Q1            vs. Q1          vs. Q1          vs. Q1          │
  │                                                                    │
  │  3,800                 $2.1M             5.9x            78%       │
  │  Total Leads           Pipeline Value    MER             Budget    │
  │  ▲ 22.3%               ▲ 31.2%           ▲ 0.7x          Utilized  │
  │  vs. Q1                vs. Q1            vs. Q1                          │
  │                                                                    │
  ├───────────────────────────────────────────────────────────────────┤
  │  BUDGET VS. ACTUAL:                                               │
  │                                                                    │
  │  Budget:     ████████████████████████████████████████████████ $150K│
  │  Spent:      ████████████████████████████████████░░░░░░░░░░ $112.4K│
  │  Remaining:  ░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░ $37.6K│
  │                                                                    │
  ├───────────────────────────────────────────────────────────────────┤
  │  REVENUE BY CHANNEL:                                              │
  │                                                                    │
  │  Organic:     █████████████████████████░░░░░░░░░░░░░ $95K (11.2%) │
  │  Paid Search: ████████████████░░░░░░░░░░░░░░░░░░░░░░░ $62K (3.5x) │
  │  Email:       ██████████░░░░░░░░░░░░░░░░░░░░░░░░░░░░░ $43K (14.3x)│
  │  Content:     ████████░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░ $33K (4.1x) │
  │  Paid Social: ██████░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░ $24K (2.0x) │
  │  Partners:    ████░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░ $19K (9.4x)│
  │  Display:     ███░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░ $9K (1.8x) │
  │                                                                    │
  ├───────────────────────────────────────────────────────────────────┤
  │  TREND (6-MONTH):                                                 │
  │                                                                    │
  │  Revenue:  ░░░░██████████████████████████████████████████████████ │
  │  Leads:    ░░████████████████████████████████████████████████░░░░ │
  │  CAC:      █████████████████████████████████████████░░░░░░░░░░░░░ │
  │  ROI:      ░░░░░░░░██████████████████████████████████████████████ │
  │                                                                    │
  └───────────────────────────────────────────────────────────────────┘

EXECUTIVE DASHBOARD — GOAL TRACKING:

  ┌───────────────────────────────────────────────────────────────────┐
  │ Q2 2024 GOAL PROGRESS                                             │
  ├──────────────────────┬──────────┬──────────┬──────────────────────┤
  │ Goal                 │ Target   │ Actual   │ Status               │
  ├──────────────────────┼──────────┼──────────┼──────────────────────┤
  │ Revenue Attribution  │ $900K    │ $847K    │ ████████████░░ 94% ⚠ │
  │ New Customers        │ 450      │ 412      │ ██████████░░░░ 92% ⚠ │
  │ MQL Generation       │ 4,000    │ 3,800    │ ██████████░░░░ 95% ⚠ │
  │ CAC Reduction        │ < $200   │ $186     │ ████████████░░ 107% ✅│
  │ Content Pieces       │ 48       │ 52       │ ██████████████ 108% ✅│
  │ Email List Growth    │ 5,000    │ 4,200    │ ████████░░░░░░ 84% 🔴 │
  │ Social Followers     │ 10,000   │ 8,500    │ ███████░░░░░░░ 85% 🔴 │
  └──────────────────────┴──────────┴──────────┴──────────────────────┘

  ✅ = On track or exceeded
  ⚠ = At risk (80-95%)
  🔴 = Behind (below 80%)

Automated Reporting

EXECUTIVE REPORT SCHEDULE
===========================

WEEKLY FLASH REPORT (every Monday, 8 AM):
  → 1-page summary: Spend, leads, conversions, revenue (prior week)
  → Key changes vs. prior week (+/- %)
  → Top 3 performing campaigns
  → Budget pacing status
  → Alerts: Any KPI thresholds breached
  → Format: PDF + email + Slack channel post
  → Audience: Marketing leadership team

MONTHLY EXECUTIVE REPORT (1st business day of month):
  → 5-10 page comprehensive report
  → Executive summary (1 page)
  → Channel performance breakdown
  → Campaign highlights and learnings
  → Budget vs. actual analysis
  → Goal progress tracking
  → Competitive benchmark summary
  → Recommendations and next month priorities
  → Format: PDF + PowerPoint slide deck
  → Audience: VP Marketing, CMO, CEO, stakeholders

QUARTERLY BUSINESS REVIEW (QBR):
  → 15-20 page strategic review
  → Quarter performance vs. plan
  → Year-to-date progress
  → Market and competitive landscape
  → Customer insights and trends
  → Budget analysis and ROI
  → Strategic recommendations for next quarter
  → Budget request for next quarter (if applicable)
  → Format: PowerPoint presentation + live presentation
  → Audience: Executive team, board of directors (if applicable)

ANNUAL MARKETING REVIEW:
  → Full-year performance analysis
  → Budget vs. actual comprehensive
  → Channel performance year-in-review
  → Top campaigns and initiatives
  → Lessons learned and key takeaways
  → Next year strategic plan
  → Budget proposal for next year
  → Format: Board presentation deck
  → Audience: Board of directors, executive team

Integration Points

Edge Cases