Home
cd ../playbooks
Data & ReportingIntermediate

Executive Dashboard

Design executive marketing dashboards.

15 minutes
By communitySource
#executive#dashboard

Marketing teams lose hours to ad-hoc, inconsistent executive dashboard work — Design executive marketing dashboards. Use when: building CMO reports, board metrics, or leadership views. This playbook turns the process into a repeatable, brand-aware workflow.

Who it's for: marketing analysts, growth analysts, BI leads

Example

"Run /executive-dashboard for our brand" → Executive Dashboard workflow output with brand context, structured inputs captured, process steps executed, and a complete deliverable ready for review.

CLAUDE.md Template

New here? 3-minute setup guide → | Already set up? Copy the template below.

# Executive Dashboard

# /dm: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):

Get new playbooks like this one

One email a week with new Claude Code workflows. Free, like everything here.

No spam. Unsubscribe anytime.

README.md

What This Does

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.


Quick Start

Step 1: Create a Project Folder

Create a dedicated folder for this workflow (e.g. ~/marketing/executive-dashboard).

Step 2: Download the Template

Click Download above and save the file as CLAUDE.md in that folder.

Step 3: Run the Workflow

Open the folder in Claude Code and describe your goal. Claude will prompt you for any missing inputs, follow the structured process, and produce a complete deliverable.


Inputs You'll Need

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

How It Works

  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 (/dm: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

What You Get

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

$Related Playbooks

Data & Reporting

Excel Automation Workflows

Automate Excel workflows including real-time control, VBA execution, and dashboard updates using xlwings.

10 minutes
Advanced
Data & Reporting

GEO Monthly Delta Report

Compare two GEO audits of the same site and generate a client progress report showing exactly what moved, by how much, and what is next

10 minutes
Intermediate
Data & Reporting

GEO Report PDF Renderer

Render a GEO audit markdown file into a styled client-ready PDF with a cover page, color-coded score tables, and severity callouts

10 minutes
Intermediate
Data & Reporting

GEO Client Report Generator

Turn AI-search audit findings into a client-ready GEO report with a weighted 0-100 readiness score and a three-tier action plan

10 minutes
Intermediate
Data & Reporting

Interactive Dashboard Builder

Build self-contained HTML dashboards with Chart.js for data visualization

10 minutes
Intermediate
Data & Reporting

Intelligence Report

Generate marketing intelligence briefings.

15 minutes
Intermediate
Data & Reporting

Funnel Metrics Analyst

Get a daily one-paragraph analysis of your funnel metrics — what moved, what's stalling, and what to do about it. An actual opinion, not a dashboard.

15 minutes
Advanced
Data & Reporting

Live Dashboard

Create live Looker Studio dashboards.

15 minutes
Intermediate
Data & Reporting

Natural Language SQL Writer

Write optimized SQL queries from plain English across multiple database dialects

10 minutes
Intermediate
Data & Reporting

Performance Check

Pull live metrics for a performance snapshot.

15 minutes
Intermediate
Data & Reporting

Performance Report

Generate performance reports.

15 minutes
Intermediate
Data & Reporting

Prompt Test

A/B test content variations.

15 minutes
Intermediate

Browse all Data & Reporting playbooks →