An end-to-end ETL pipeline that unifies marketing data from Google Analytics 4, social media platforms, and CRM systems into a BigQuery data warehouse, exposed via a FastAPI REST API for analytics and ...

In November 2025, Google solved a persistent SEO reporting challenge: separating branded from non-branded search performance directly in Google Search Console (GSC). The feature is now fully rolled ...

This dbt project builds a clean, testable user 360 dimension (dim_users) in BigQuery. It aggregates user identity with resolved hierarchical location data and multi ...