Marketing Analytics Dashboard - User Guide

📊 Dashboard Widgets & Their Purpose

Executive Summary Page

1. KPI Cards (8 Total)

Top Row:

• Spend Card

  • Shows: Total marketing spend ($36.00M)
  • Why it matters: Your total budget allocation across all channels. Helps track if you're on pace with quarterly/annual budgets.
  • The change %: Shows if spending increased or decreased vs. last month (green ▲ = increase, red ▼ = decrease)
  • Sparkline: Mini trend chart showing 12-month spending pattern at a glance

• CPM (Cost Per Mille) Card

  • Shows: Average cost to reach 1,000 impressions ($405K)
  • Why it matters: Efficiency metric - lower CPM means you're paying less to reach people. Critical for budget optimization.
  • Use case: Compare CPM across channels to identify the most cost-effective platforms

• CTR (Click-Through Rate) Card

  • Shows: Percentage of people who clicked your ads (10.5%)
  • Why it matters: Measures ad relevance and appeal. Higher CTR = more engaging creative.
  • Benchmark: Industry average is 2-5%, so 10.5% is excellent performance

• CPC (Cost Per Click) Card

  • Shows: Average amount paid for each click ($4K)
  • Why it matters: Direct cost of user engagement. Lower is better for budget efficiency.
  • Decision point: If CPC is rising, you may need to refine targeting or improve ad quality

Bottom Row:

• Video Views Card

  • Shows: Total video ad views (93K)
  • Why it matters: Brand awareness metric. Video content drives higher engagement than static ads.
  • Action item: If views are declining, consider refreshing video creative

• Impressions Card

  • Shows: How many times your ads were displayed (890K)
  • Why it matters: Reach metric - higher impressions = more eyeballs on your brand.
  • Balance: High impressions with low CTR might indicate poor targeting

• Conversions Card

  • Shows: Total desired actions taken (791 conversions)
  • Why it matters: THE bottom-line metric. This is people actually buying/signing up/downloading.
  • Critical for: ROI calculation and campaign success measurement

• Conversion Rate Card

  • Shows: Percentage of clicks that convert (9.8%)
  • Why it matters: Efficiency of your landing pages and user journey. Industry average is 2-5%.
  • Optimization: If rate drops, check landing page experience, not just ad performance

2. Channel Performance Chart (Multi-Line Graph)

What it shows:

• 4 colored lines tracking impressions over 12 months
  • Purple: Programmatic advertising
  • Pink: Paid Search (Google Ads)
  • Cyan: Paid Social (Facebook, LinkedIn)
  • Green: Organic traffic

Why it matters:

• Trend identification: See which channels are growing or declining
• Seasonality patterns: Spot peak periods (e.g., July spike in the image)
• Channel mix: Ensure you're not over-reliant on one channel
• Budget allocation: Shift spend toward trending-up channels

How to read it:

• Peaks = high performance periods
• Valleys = optimization opportunities
• Crossing lines = shifting channel effectiveness

3. Channel Performance Table

Columns:

• Channel: Marketing channel name
• Impressions: Current month total
• % Δ: Month-over-month change
• CTR: Click-through rate
• % Δ: CTR change

Why it matters:

• Quick comparison: See all channels at once
• Performance ranking: Identify best/worst performers
• Trend spotting: Negative % changes need investigation

Real-world use:

• Programmatic showing -4.2%? Check if bids need adjustment
• Paid Search at 30.7% impressions growth? Consider increasing budget

4. Data Source Performance Table

What it shows:

• Individual ad platforms (Amazon Ads, Facebook, Google, etc.)
• Granular metrics per platform

Why it matters:

• Platform comparison: Facebook vs Google vs LinkedIn - which delivers better ROI?
• Budget distribution: Allocate more to high-performing platforms
• Contract negotiations: Use data to negotiate better rates with platforms

Actionable insights:

• Amazon showing 201% impressions growth? Scale up investment
• LinkedIn at -10% CTR? Time to refresh ad creative

5. Campaign Performance Table

What it shows:

• Individual campaign names
• Campaign-specific metrics
• 10 concurrent campaigns

Why it matters:

• Campaign optimization: Kill underperformers, scale winners
• Creative testing: Compare different messaging approaches
• A/B testing results: See which campaigns resonate with audience

Day-to-day usage:

• "Business-focused zero tolerance" at 10.42% CTR? Use similar messaging
• Campaign showing consistent "-"? It's stagnant - refresh or pause it

---

🎯 How to Use This Dashboard Day-to-Day

Monday Morning Routine (15 minutes)

1. Check KPI Cards

   • Are all metrics green (↑) or red (↓)?
   • Quick health check: Is spend on track? Are conversions growing?

2. Review Channel Performance Chart

   • Any sudden drops or spikes?
   • Identify channels needing attention this week

3. Scan Performance Tables

   • Note campaigns with declining CTR (need creative refresh)
   • Flag platforms with high CPC (optimization opportunity)

Action Items:

• Create task list for underperforming channels
• Schedule creative team meeting if multiple campaigns declining

---

Mid-Week Check (Wednesday, 10 minutes)

1. Navigate to Channel Performance Page

   • Use sidebar: Click "Channel Performance"
   • Multi-select channels to compare
   • Review trend charts

2. Data Source Deep-Dive

   • Click "Data Source Performance" in sidebar
   • Select individual platform from dropdown
   • Analyze impressions and CTR trends

Questions to ask:

• Is the mid-week performance tracking to month-end goals?
• Do we need to adjust bids or budgets before Friday?

---

Weekly Review Meeting (Friday, 30 minutes)

1. Executive Summary Analysis

   • Present KPI cards to team
   • Highlight week-over-week changes
   • Compare sparklines to spot trends

2. Channel Strategy Discussion

   • Share channel performance chart
   • Discuss budget reallocation based on data
   • Plan next week's tests

3. Campaign Review

   • Campaign Performance table open
   • Identify top 3 and bottom 3 performers
   • Decide: pause, optimize, or scale each campaign

Deliverables:

• Action plan for underperforming campaigns
• Budget reallocation recommendations
• Creative brief for new campaigns

---

Month-End Analysis (60 minutes)

1. Full Data Export

   • Review entire 12-month trend (all pages)
   • Calculate month-over-month growth rates
   • Prepare executive report

2. Strategic Planning

   • Identify seasonal patterns in channel chart
   • Plan budget allocation for next month
   • Set targets based on historical performance

3. Stakeholder Communication

   • Screenshot key metrics (KPI cards)
   • Export tables for detailed reports
   • Present ROI calculations to leadership

---

💡 Real-World Scenarios

Scenario 1: Budget Cuts

Problem: Need to reduce spend by 20%

How to use dashboard:

1. Check Channel Performance table
2. Identify lowest CTR and highest CPC channels
3. Reduce spend on underperformers (e.g., Organic at -8%)
4. Maintain spend on high-performers (Paid Search at 30.7% growth)

---

Scenario 2: Campaign Underperformance

Problem: Conversions dropping week-over-week

How to use dashboard:

1. Executive Summary → Check Conversion Rate card
2. Campaign Performance table → Sort by CTR
3. Identify campaigns with "-" (no change) or declining CTR
4. Data Source Performance → Check if issue is platform-specific

Action: Pause low-CTR campaigns, reallocate budget to proven winners

---

Scenario 3: New Platform Evaluation

Problem: Deciding whether to invest in TikTok Ads

How to use dashboard:

1. Review current Data Source Performance
2. Compare Facebook (social) vs Google (search) performance
3. Check social media CTR benchmarks (Paid Social: 10.28%)
4. Use historical data to project TikTok potential

Decision criteria: If Paid Social performing well, TikTok likely worth testing

---

Scenario 4: Seasonal Planning

Problem: Preparing for Q4 holiday push

How to use dashboard:

1. Channel Performance Chart → Identify last year's Q4 patterns
2. Note which channels spiked (e.g., July peak in image)
3. Executive Summary → Calculate budget needed for similar growth
4. Campaign Performance → Review what creatives worked

Strategy: Pre-allocate 30% more budget to historically high-performing months

---

🔄 Dashboard Navigation Tips

Sidebar Menu Structure

Marketing Insights → Cross Channel

• Executive Summary (main overview)
• Channel Performance (deep-dive by channel)
• Channel Segments & Trends (future feature)

Paid Ads x Google Analytics

• Integration points (navigation items)
• Quick links to detailed views

Filter & Interaction

• Date range: Currently showing Jan-Dec 2023
• Multi-select: Channel Performance page allows selecting specific channels
• Dropdown filters: Data Source page for platform selection
• Hover charts: Interactive tooltips on all graphs

---

📈 Key Metrics to Watch Daily

Red Flags (Immediate Action Required)

• Conversion Rate drops below 5%
• CPC increases >20% week-over-week
• Any channel shows -30%+ decline in impressions
• Campaign CTR below 2%

Green Flags (Scale Opportunities)

• CTR above 15%
• Conversion Rate above 12%
• Impressions growing +50% month-over-month
• CPC decreasing while conversions stable

Yellow Flags (Monitor Closely)

• Spend increasing but conversions flat
• Impressions up but CTR down (targeting issue)
• Single channel dominating >60% of conversions (risk)

---

🎓 Best Practices

1. Daily: Quick 5-minute KPI check each morning

2. Weekly: 30-minute deep-dive on channel performance

3. Monthly: Full strategic review with team

4. Quarterly: Historical analysis and trend forecasting

5. Always compare:

   • This month vs last month
   • This year vs last year (when available)
   • Channel vs channel
   • Campaign vs campaign

6. Document decisions:

   • Why budgets were shifted
   • What creative changes were made
   • Platform-specific optimizations

7. Share insights:

   • Export tables for reports
   • Screenshot trends for presentations
   • Use data to justify budget requests

---

🚀 Advanced Usage

For Marketing Managers:

• Focus on Executive Summary for team meetings
• Use Channel Performance for budget allocation
• Campaign Performance for creative direction

For Analysts:

• Deep-dive into Data Source Performance
• Export data for additional statistical analysis
• Track week-over-week trends

For Executives:

• Executive Summary KPI cards tell the full story
• Focus on conversion metrics and ROI
• Use sparklines for at-a-glance trend awareness

---

This dashboard transforms raw marketing data into actionable insights, enabling data-driven decisions that improve campaign performance and maximize ROI. 📊✨