Highlights

Developed a unified analytics dashboard merging Universal Analytics and GA4 for continuous integration with existing systems
Created a new data model and ETL pipelines to consolidate data from both Universal Analytics and GA4 sources
Designed a comprehensive dashboard to showcase key insights from the website’s analytics
Engaged with stakeholders and data source owners to verify and ensure data quality
This project streamlined analytics practices, enhancing decision-making for the global e-commerce giant

KPIs & Metrics Tracked

Generic Web KPIs tracked in GA4 & UA - Sessions, Users, Page Views, Bounce Rate, Sales & Revenue
Average Loading Time - Average duration for complete webpage loading, considering all factors.
Add-to-Cart - Number of users indicating purchase intent by adding items to cart.
Average Purchase Value - Mean spending value per transaction, including all purchased items.
Transactions - Total count of successful purchase transactions completed by users.
% Sales Conversion - Proportion of visits resulting in purchases, indicating conversion efficiency.
Newsletter Subscriptions - Total user sign-ups for newsletter, gauging email campaign success.