April 2023 Summaries

GA4 is being introduced to replace Universal Analytics (UA) and many users are struggling with the transition, so an internal dashboard demo was created to help understand data attribution for blog posts. A local data load pipeline using GA4 Query Explorer and DuckDB was set up to get the necessary data, which was then used to build a Streamlit dashboard on a system. The dashboard was deployed on a Google Cloud VM instance, where it loads data from a PostgreSQL database daily using a GitHub Actions pipeline.