Project
A dashboard people might actually open
The problem
On a multi-region site, our Looker Studio report was hard to navigate. Regional managers wanted a quick snapshot and a way to compare regions, without needing an analyst.
What I did
- Brought in a dashboard I had built earlier as open source and showed it to my line manager.
- It connects by API to Google Analytics 4, Search Console and YouTube Analytics. You pick a region and the data you want.
- Semrush and Gravity Forms are built in and waiting on the contract and deployment.
- Added a 404 pages panel, previous-period comparison and CSV or snapshot export, because the monthly report deserves a home.
The result
Being piloted with Europe now, with the Americas and Asia Pacific joining next month. My measure of success is simple: do managers open it more than once a month? It is a pilot, so there is no verdict yet, and I would rather say that than invent one.