--- name: executive-marketing-dashboard description: 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, presenting marketing performance to leadership, tracking marketing ROI, monitoring budget utilization, generating executive marketing reports, or creating stakeholder presentations. Triggers on phrases like "executive dashboard", "marketing KPIs", "executive report", "marketing ROI report", "board presentation", "stakeholder report", "marketing performance summary", "budget vs actual", "marketing metrics executive", "C-level marketing report". --- # 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 - **Google Analytics 4**: Traffic, conversions, revenue attribution, audience analytics, multi-channel funnel - **HubSpot / Salesforce**: Pipeline value, deal stage tracking, MQL/SQL generation, revenue attribution - **Google Ads / Meta Ads / LinkedIn Ads**: Ad spend, ROAS, conversion data, campaign performance - **Mailchimp / HubSpot / Braze**: Email marketing performance, revenue attribution, list growth - **Supermetrics / Funnel.io**: Data connectors between marketing platforms and BI tools - **Looker Studio / Data Studio**: Executive dashboard building, automated report scheduling - **Tableau / Power BI**: Advanced executive dashboards, predictive analytics, drill-down capabilities - **Databox / Geckoboard**: Real-time KPI dashboards for office displays and mobile - **Google BigQuery**: Raw data warehouse for custom analysis and advanced reporting - **AgencyAnalytics / ReportGiant**: White-labeled executive reporting for agency clients - **Slack / Microsoft Teams**: Automated KPI alerts, weekly flash report distribution ## Edge Cases - **Revenue attribution complexity**: Connecting marketing activity to actual closed revenue - Challenge: Long B2B sales cycles (60-180 days) with multiple touchpoints - Solution: Multi-touch attribution (data-driven or position-based) - Solution: CRM integration with offline conversion import - Solution: Marketing influenced revenue (not just last-click) - Reporting: Show both directly-attributed and influenced revenue - Caveat: No attribution model is perfect — communicate limitations - **Executive audience variability**: Different stakeholders care about different metrics - CEO: Revenue, ROI, growth rate, CAC - CFO: Budget utilization, cost efficiency, ROI, payback period - CRO / VP Sales: Lead volume, lead quality, pipeline value, SQL rate - Product: Feature adoption, user engagement, product-led growth metrics - Approach: Build role-specific dashboard views (same data, different emphasis) - Best practice: Lead with business outcomes (revenue), then marketing metrics - **Data latency and freshness**: Executives need near-real-time data but systems have delays - GA4: 24-48 hour delay for processed data - Ad platforms: Real-time for spend, 4-24 hour delay for conversions - CRM: Real-time for deals, batch sync for historical data - Solution: Specify "as of" timestamp on all dashboards - Solution: Use platform-native real-time dashboards for urgent decisions - Solution: Daily data sync at consistent time (e.g., 6 AM) for morning reporting - **Cross-channel data consolidation**: Combining data from 10+ marketing platforms - Challenge: Different metrics, different attribution, different data freshness - Solution: Designated source of truth per metric type - Solution: ETL pipeline (Supermetrics, Funnel, Fivetran) for automated consolidation - Solution: Data warehouse (BigQuery, Snowflake) for unified data model - Governance: Document data definitions and calculations for consistency - Validation: Monthly data audit to ensure accuracy across sources - **Board-level reporting for startups vs. enterprises**: Very different expectations and needs - Startup (pre-Series A): Focus on growth rate, CAC, burn multiple, user acquisition - Metrics: MoM growth, CAC payback, activation rate, viral coefficient - Format: Simple, visual, growth-focused (5 slides max) - Growth-stage (Series B+): Add unit economics, channel scalability, LTV:CAC - Metrics: MER, LTV:CAC, payback period, channel ROAS, cohort retention - Format: Detailed but concise (10-15 slides) - Enterprise: Add marketing mix modeling, brand health, market share - Metrics: Marketing-attributed revenue, share of voice, brand lift, ROMI - Format: Comprehensive (20+ slides) with appendices for deep dives