Phase 9: Archive Analytics — Phase B: Core Analytics

[elfensky]

Parent: #177

Core Analytics Features

Medium-complexity analytics that require cross-season aggregation or derived computations.

6. Season Report Card

• What: Composite letter grade (A-F) per season based on weighted formula: event win rate, mission success, player retention, kills efficiency
• Fields: All h1_live_snapshot aggregates, h1_event outcomes
• Viz: Large letter grade card, expandable to show individual dimension scores

7. Season Fingerprint (Radar Chart)

• What: Spider/radar chart comparing seasons across 6 normalized axes: player peak, mission efficiency, defend success rate, friendly fire rate, kill rate, campaign volatility
• Fields: All h1_live_snapshot per season, h1_snapshot for volatility
• Viz: Radar chart with season selector/overlay (compare up to 3 seasons)

8. Player Attrition Curve

• What: Player count decay over season duration — when does the community lose interest? Fit decay curve, compare half-lives across seasons
• Fields: players, total_unique_players, time, season_duration
• Viz: Area chart with optional decay curve overlay

9. Momentum Tracker

• What: Rate-of-change of liberation points per faction. Shows when humanity was pushing vs. being pushed back. Highlight inflection points.
• Fields: h1_snapshot.data (points/points_taken over time)
• Viz: Line chart with positive/negative areas (green=pushing, red=losing)

10. Peak Hour Heatmap

• What: 7-day × 24-hour heatmap of player counts. Overlay event success rates to answer: "Do events during peak hours win more?"
• Fields: players, time (derived hour/day-of-week), h1_event outcomes
• Viz: Heatmap grid with tooltip details

Estimates

• Size: L (8-16h total)
• Per feature: ~2-4h each
• Priority: P2

[elfensky]

Potential Feature: Faction Difficulty Rating

Idea: Rank factions by difficulty based on historical event win/loss ratios.

Data source: h1_event table — filter by faction (enemy), aggregate status (success/fail) across seasons or per-season.

Possible metrics:

• Win rate per faction — e.g., Bugs: 40% win rate, Cyborgs: 30%, Illuminate: 55%
• Difficulty tier — derived label (Easy / Moderate / Hard / Nightmare) based on win rate thresholds
• Trend over time — is a faction getting harder or easier across seasons?
• Event type breakdown — defend vs. attack win rates per faction (are Cyborg defenses harder than Cyborg attacks?)

Viz options: Ranked bar chart, faction cards with difficulty badges, or integrate into the Season Report Card (#179 item 6) as a dimension.

Note: The live dashboard already shows per-faction win/loss in the StatGrid (filtered by FactionTabs). This feature would extend that to historical cross-season analysis.