Marketing Analytics Dashboard - User Guide

# 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. 📊✨