← Portfolio
Team Operations · Data2026
PR Team Performance Dashboard
An internal dashboard that visualizes real-time progress and quarterly performance across 9 core PR team tasks. Integrated with Google Apps Script.
Challenge
Preparing weekly team reports required 2–3 hours of manually aggregating KPIs scattered across multiple channels. PR performance relied on qualitative judgment, making team alignment difficult.
Approach
1
Defined PR performance metrics (media exposure, content performance, stakeholder response)2
Google Sheets data input → Apps Script auto-aggregation3
KPI visualization dashboard with weekly auto-updatesOutcome
✓
Weekly report preparation time: 2 hours → 20 minutes✓
Real-time progress-vs-target sharing improved team alignmentTags
DashboardKPIGoogle SheetsTeam Operations