executive-dashboard

What this skill does

# /digital-marketing-pro:executive-dashboard

## Purpose

Design a C-suite marketing dashboard that translates marketing metrics into business outcomes for executive decision-making. Bridges the gap between marketing activity data and business impact, giving senior leaders the clarity to make faster, better-informed strategic decisions without drowning in operational detail.

## Input Required

The user must provide (or will be prompted for):

- **Executive role**: Primary audience — CEO, CMO, CFO, VP Marketing, or board — each requires different metric emphasis and abstraction level
- **Business model and revenue drivers**: How the company makes money — SaaS, e-commerce, lead gen, marketplace, subscription — and the key revenue levers marketing influences
- **Strategic priorities this quarter**: The 2-4 business priorities the executive team is focused on that marketing should ladder up to
- **Reporting frequency**: How often the dashboard will be reviewed — weekly executive standup, monthly leadership meeting, quarterly board review
- **Current data sources and tools**: Analytics platforms, CRM, ad platforms, attribution tools, and BI systems currently in use with data freshness and reliability notes
- **Existing reports being replaced**: Current reporting artifacts the dashboard will consolidate or replace — helps identify gaps and redundancies
- **Key decisions the dashboard should inform**: Specific decisions executives make that this dashboard should support — budget allocation, channel mix, hiring, campaign scaling, market expansion
- **Stakeholder data literacy level**: How comfortable the audience is with marketing metrics — determines labeling, context, and narrative density needed

## Process

1. **Load brand context**: Read `~/.claude-marketing/brands/_active-brand.json` for the active slug, then load `~/.claude-marketing/brands/{slug}/profile.json`. Apply brand voice, compliance rules for target markets (`skills/context-engine/compliance-rules.md`), and industry context. **Also check for guidelines** at `~/.claude-marketing/brands/{slug}/guidelines/_manifest.json` — if present, load restrictions and relevant category files. Check for custom templates at `~/.claude-marketing/brands/{slug}/templates/`. Check for agency SOPs at `~/.claude-marketing/sops/`. If no brand exists, ask: "Set up a brand first (/digital-marketing-pro:brand-setup)?" — or proceed with defaults.
2. **Identify north-star metrics**: Select 5-7 metrics that directly tie marketing activity to business outcomes — revenue influenced, pipeline generated, customer acquisition cost, lifetime value, market share, brand equity indicators
3. **Design metric hierarchy**: Organize metrics into three tiers — leading indicators (predict future performance), lagging indicators (confirm past results), and health metrics (signal system stability and sustainability)
4. **Select visualization type per metric**: Choose the optimal chart type for each metric based on data shape and decision context — trend lines for trajectory, gauges for targets, bar charts for comparisons, sparklines for density
5. **Define alert thresholds and anomaly triggers**: Set green/yellow/red thresholds for each metric with specific trigger values, and configure anomaly detection rules for unexpected spikes or drops
6. **Map data sources to each metric**: Document which system provides each metric, how it is calculated, data freshness (real-time, daily, weekly), and known limitations or lag
7. **Design layout for scanning speed**: Structure the dashboard for F-pattern or Z-pattern scanning — most critical metrics top-left, summary before detail, consistent visual hierarchy, minimal cognitive load
8. **Add narrative guidance**: Write "how to read this" instructions for each section — what good looks like, what bad looks like, and what action to take in each scenario
9. **Build drill-down structure**: Design three levels of depth — summary view (the dashboard itself), detail view (campaign or channel breakdowns), and root cause view (diagnostic data for investigating anomalies)
10. **Create mobile-friendly variant**: Adapt the dashboard layout for mobile or tablet viewing — prioritize top 3-5 metrics, stack vertically, enlarge touch targets, and simplify visualizations
11. **Add comparison baselines**: Define what each metric is compared against — plan/target, prior period (MoM, QoQ, YoY), industry benchmark, and competitive estimate — with comparison display format

## Output

A structured executive dashboard design containing:

- **North-star metrics (5-7)**: Selected metrics with business rationale explaining why each matters to the executive audience and how it connects to strategic priorities
- **Metric hierarchy diagram**: Visual framework showing leading, lagging, and health metrics with causal relationships and directional influence between them
- **Visualization recommendations**: Chart type, scale, color coding, and annotation style for each metric with rationale for the design choice
- **Alert threshold definitions**: Green/yellow/red boundaries for each metric with specific trigger values, anomaly detection rules, and notification routing
- **Data source mapping**: Metric-by-metric documentation of source system, calculation method, refresh frequency, data latency, and known quality issues
- **Dashboard wireframe layout**: Spatial layout showing metric placement, section grouping, visual hierarchy, and scanning flow optimized for the target audience
- **Narrative guide**: Section-by-section presentation guide explaining how to read each area, what questions it answers, and what actions to consider based on the data shown
- **Drill-down structure**: Three-level depth design — summary (dashboard), detail (channel/campaign breakdown), and root cause (diagnostic investigation) with navigation flow
- **Mobile layout variant**: Adapted design for mobile viewing with prioritized metrics, vertical stacking, simplified charts, and touch-optimized interactions
- **Comparison baseline definitions**: For each metric, the comparison standard (target, prior period, benchmark, competitive) with display format and context notes
- **Refresh cadence and data latency notes**: Documentation of how often each metric updates, expected data lag, and implications for decision timing
- **Executive summary template**: A 3-sentence written narrative template that synthesizes dashboard findings into a verbal briefing — what happened, why it matters, what to do next
- **Glossary of terms**: Plain-language definitions of all metrics and marketing terminology for non-marketing stakeholders with examples and context

## Agents Used

- **analytics-analyst** — Metric selection, hierarchy design, visualization recommendations, data source mapping, alert thresholds, drill-down architecture, refresh cadence, and dashboard layout optimization