templatesmarketing_dashboard

Strategy & Ops

Marketing Dashboard Builder

Design comprehensive analytics dashboards with KPIs by funnel stage and executive reporting.

intermediate~ 1 week

Template

# Marketing Dashboard & Analytics Framework

## Objective
Design a comprehensive marketing analytics dashboard and reporting framework that provides actionable insights, tracks performance against goals, and enables data-driven decision making for {{company_name}}.

## Business Context
**Company**: {{company_name}}
**Website**: {{website}}
**Industry**: {{industry}}
**Product/Service**: {{product_description}}
**Marketing Budget**: {{monthly_marketing_budget}}
**Primary Channels**: {{primary_channels}}
**Key Goals**: {{key_goals}}
**Tech Stack**: {{tech_stack}}

## Deliverables

### 1. Executive Dashboard
**Top-Level KPIs**
- Marketing-sourced revenue and pipeline
- Customer acquisition cost (CAC) trend
- Marketing ROI / ROAS summary
- Lead velocity rate
- Brand awareness metrics

**Visual Design Requirements**
- Executive summary scorecard
- Trend indicators (MoM, YoY)
- Goal progress gauges
- Key insights and recommendations section

### 2. Channel Performance Dashboard
**Paid Media Metrics**
- Spend by channel and campaign
- Cost per acquisition by source
- ROAS by campaign type
- Impression and reach tracking
- Click-through and conversion rates

**Organic Performance**
- Organic traffic trends
- SEO keyword rankings
- Domain authority tracking
- Content performance metrics
- Social engagement analytics

**Email Marketing**
- List growth and health metrics
- Campaign performance tracking
- Engagement trends (open, click, unsubscribe)
- Revenue attribution from email
- Automation performance

### 3. Funnel Analytics Dashboard
**Lead Funnel Metrics**
- Visitor → Lead conversion rate
- Lead → MQL conversion rate
- MQL → SQL conversion rate
- SQL → Opportunity conversion rate
- Opportunity → Customer conversion rate

**Stage Velocity**
- Average time in each stage
- Bottleneck identification
- Cohort progression analysis
- Drop-off point analysis

### 4. Content Performance Dashboard
**Content Metrics**
- Page views and unique visitors
- Time on page and bounce rate
- Content engagement scores
- Conversion by content piece
- Content gap analysis

**Content Attribution**
- First-touch content attribution
- Multi-touch content influence
- Content to revenue mapping
- Topic cluster performance

### 5. Campaign Analytics Dashboard
**Campaign Tracking**
- Active campaign overview
- Performance vs. goals
- A/B test results tracking
- Creative performance comparison
- Audience segment analysis

**Budget & Spend**
- Budget allocation visualization
- Spend pacing tracking
- Cost efficiency trends
- Budget reallocation recommendations

### 6. Data Infrastructure Requirements
**Data Sources & Integration**
- CRM integration (pipeline data)
- Marketing automation platform
- Advertising platforms (Google, Meta, LinkedIn)
- Web analytics (GA4)
- Social media platforms
- Email service provider

**Data Governance**
- Metric definitions and calculations
- Data refresh schedules
- Access control matrix
- Data quality monitoring

### 7. Reporting Automation
**Scheduled Reports**
- Daily performance snapshots
- Weekly channel summaries
- Monthly executive reports
- Quarterly business reviews
- Annual marketing retrospective

**Alert Configuration**
- Budget threshold alerts
- Performance anomaly detection
- Goal achievement notifications
- Campaign end reminders

## Output Format
Provide dashboard specifications, metric definitions, data source requirements, and visualization mockups ready for implementation in your BI tool of choice.

Details

CategoryStrategy & Ops
IndustryHorizontal
Complexityintermediate
Est. time1 week
Added#58

Variables

8
  • Company Name
    {{company_name}}
    text
  • Industry
    {{industry}}
    text
  • Key Goals
    {{key_goals}}
    text
  • Monthly Marketing Budget
    {{monthly_marketing_budget}}
    text
  • Primary Channels
    {{primary_channels}}
    list
  • Product Description
    {{product_description}}
    text
  • Tech Stack
    {{tech_stack}}
    text
  • Website
    {{website}}
    text