Team Operations · Data2026

PR Team Performance Dashboard

An internal dashboard that visualizes real-time progress and quarterly results across the PR team's 9 core workstreams. Integrated with Google Apps Script.

Challenge

Manually aggregating performance data and metrics scattered across multiple channels took 2–3 hours every week for reporting. PR outcomes relied on qualitative judgment, making team alignment difficult.

Approach

Defined a PR performance metrics framework

Google Sheets data input → automated aggregation via Apps Script

Obsidian note-based weekly meetings, tasks, and research consolidated by AI in batch

KPI visualization dashboard built with automated weekly updates

Outcome

✓

Weekly report preparation time reduced from 2 hours to 20 minutes

✓

Real-time progress-against-goals sharing improved team alignment

Insights