# SWAPA Number Podcast — Analytics Report Brief
*Paste this into Cowork along with the contents of data/podcast_stats.json to generate reports.*

---

## Context
**The SWAPA Number** is the official podcast of the Southwest Airlines Pilots Association (SWAPA).
It covers contract negotiations, pilot benefits, scheduling, and union news.

**Brand:** SWAPA Blue `#074F71`, Orange `#D86018`. Fonts: Barlow Condensed (display), Source Sans 3 (body).

**Platform note:**
- Before March 23, 2026: Buzzsprout hosted everything (one download count = external + app combined)
- After March 23, 2026: Podbean = external listeners (Apple Podcasts, Spotify, etc.), Buzzsprout = SWAPA app only

**"Unknown" in Buzzsprout app breakdown = SWAPA internal app listeners.** Not a data gap — confirmed.

---

## What I Need From You

### Option A — Weekly Summary Email (for Amy, Director of Communications)
Generate a brief email (3–4 paragraphs, professional tone) summarizing:
- Total downloads this week vs last week
- Top episode and why it performed well
- Any notable trends
- One recommendation

Recipient: Amy (Director of Communications)
Tone: Informative, brief, no jargon

---

### Option B — PowerPoint Slide Deck
Generate a SWAPA-branded PowerPoint with these slides:
1. Title slide: "The SWAPA Number — Podcast Analytics [Month Year]"
2. Key Metrics (total downloads, avg per episode, top episode)
3. Downloads by Episode (bar chart)
4. Monthly Trend (line chart — external vs app)
5. Episode Detail table (newest to oldest)
6. External Platform Distribution (Apple, Spotify, Web/Browser, etc.)

Use SWAPA brand colors throughout. Match the style of the existing deck.

---

### Option C — Executive Summary (1 page)
A concise written summary covering:
- Performance vs prior period
- Top 3 performing episodes with context
- App vs external listener split and what it means
- Platform transition impact (pre/post March 23 switch)
- Recommended actions

---

## Data (paste podcast_stats.json contents below this line)