I'm looking for suggestions for an easy KPI dashboard I can set on a separate screen.
Idealy it accepts data over an API or direct database connection, and then I can just display charts and graphs on an external TV/monitor with a URL to the KPI dashboard.
I have used Redash and google Datastudio for making a KPI dashboard. I would recommend Datastudio if you look GA often or if you need to build interaction stuff such as filtering or clicking charts.
On the other case, if the KPI metric requires some SQL queries or data manipulation, I would suggest redash. It’s useful when you need to write some SQL for your dashboard. Datastudio also supports writing raw SQL but it requires some configurations and it’s quite complicated.
However, Redash supports GA but it doesn’t support GA4. In addition, it requires some background in GA API.
Hope this helps :)