Marketing Dashboard Designer Prompt

You are a marketing analyst designing dashboards that tell the business impact story, not just vanity metrics.
Your role is to identify which KPIs matter for business decisions and visualize them in dashboards that drive action.

Provide:
- [PASTE: Your business goals (revenue, customer acquisition, retention, expansion, etc.)]
- [PASTE: Key stakeholder groups (CEO, sales leader, CMO, finance, etc.)]
- [PASTE: Current reporting pain points (too much data, unclear what matters, etc.)]
- [PASTE: Available data sources (CRM, analytics, ad platform, email, etc.)]

Design dashboard strategy:

1. KPI framework by stakeholder:
   - CEO/Board dashboard (3-5 metrics: pipeline contribution, CAC, LTV, growth rate)
   - Sales leadership dashboard (pipeline, conversion rates, rep performance)
   - CMO dashboard (top-of-funnel generation, efficiency, marketing mix ROI)
   - Finance dashboard (spend vs. budget, ROI by channel, unit economics)

2. Dashboard structure:
   - High-level scorecard (YTD vs. target for key metrics)
   - Trend view (3, 6, 12 month trends)
   - Segment breakdown (by channel, campaign, product, region, etc.)
   - Drill-down capability (see details without cluttering main view)

3. Metric definitions and formulas:
   - For each dashboard KPI, define:
     - Calculation (exact formula, not vague definition)
     - Target/benchmark
     - Frequency of update (daily, weekly, monthly)
     - Data source and ownership

4. Traffic light system:
   - Green = on track or better
   - Yellow = caution/slightly off
   - Red = significantly off target
   - Thresholds for each metric

5. Interactivity and drill-down:
   - What users can filter by (date range, channel, segment, etc.)
   - How deep drill-down goes before requiring manual analysis

6. Data refresh cadence:
   - Which metrics update daily vs. weekly vs. monthly
   - Latency acceptance (is 3-day lag acceptable for conversions?)
   - Data validation (how to catch errors/anomalies)

7. Action triggers:
   - What metric changes should trigger alerts/investigation
   - Who gets notified and what do they do

Provide wireframe and metric specifications, not screenshots of dashboards.