Marketing performance dashboard.
A real-time KPI dashboard consolidating data from Hootsuite, Squarespace Analytics, and GA4 into a single view. It replaced a manual monthly reporting process.
The problem
Reporting on marketing performance across the three sister agencies was a manual process: pull from Hootsuite, Squarespace Analytics, and GA4 separately, then assemble it by hand each month.
By the time the report landed, the numbers were already old. There was no way to check current figures between cycles without starting over.
The build
The dashboard consolidates data from all three sources into a single view. Data flows through a custom Google Apps Script endpoint connected to Google Sheets, with the front end built using Chart.js.
Social media performance, website analytics, and quarter-over-quarter trends are tracked without anyone having to compile anything manually.
- Website analytics: sessions, sources, top pages, conversion events from GA4
- Social performance: follower growth, engagement, and reach via Hootsuite
- Quarter-over-quarter deltas for every KPI
- Data accessible at any point in the month, not just at the end of it