---
aliases: ["Set up new analytics dashboard"]
Is A: Task
Belongs to: "[[24q2]]"
Status: Done
Owner: "[[person-luca-rossi]]"
---
# Set up new analytics dashboard

The existing analytics setup was fragmented across multiple tools -- Substack's built-in analytics for email metrics, Google Analytics for the website, and manual spreadsheets for sponsor tracking. This task consolidated everything into a single dashboard that provides a unified view of the key metrics: [[measure-subscribers]], [[measure-sponsorship-mrr]], [[measure-podcast-downloads]], and engagement metrics (open rate, click-through rate).

The dashboard was built using a combination of Google Sheets (for data aggregation) and a simple Retool dashboard for visualization. The goal was a single URL that [[person-luca-rossi]] and [[person-paco-furiani]] could check daily without needing to log into multiple tools.

## Acceptance criteria

- [x] Consolidate subscriber, revenue, and engagement data into a single data source
- [x] Build dashboard with daily/weekly/monthly views for all key metrics
- [x] Set up automated data pulls from Substack API and Google Analytics
- [x] Add sponsor pipeline tracking (leads, proposals sent, contracts signed)
- [x] Share dashboard access with [[person-paco-furiani]]

## Notes

- The Retool dashboard took longer to set up than expected (about 3 days instead of the planned 1 day), but the ongoing time savings are substantial. Checking metrics went from a 20-minute multi-tool process to a 2-minute glance.
- Discovered that Substack's API has rate limits that required batching data pulls overnight. The sync runs at 3am CET.
- This dashboard became the source of truth for all quarterly target tracking going forward.
