About this project

The repository provides a solution for obtaining real-time, page-specific analytics from Google Analytics 4, which the standard GA4 UI does not easily offer. It uses the GA4 Data API to pull active users, page views, events, and conversions broken down by page and country. An Apache Airflow DAG (managed via Astro) runs the extraction every five minutes inside a Docker container. The extracted data is transformed with Pandas and loaded into a PostgreSQL database. Metabase is then used to create dashboards that visualize the stored metrics, enabling marketers to monitor individual page performance during campaigns such as product launches. The project includes setup instructions for cloning the repo, configuring a Google Cloud service account, adding the service account to the GA4 property, installing Docker and Astro, making scripts executable, and starting/stopping the application. It also outlines the architecture, table schema, and suggestions for contributing or extending the pipeline.