All Projects
A deep dive into my technical implementations, data architectures, and automation workflows.
Fragmented data across GA4 and Shopify made it impossible to see true drop-off points or attribute revenue correctly. Implemented GA4 raw data export to BigQuery, modeled data into a reporting mart, and visualized in Looker Studio.
- ✓ Unified view of Sessions → Add to Cart → Checkout → Purchase
- ✓ Identified 15% drop-off at shipping step, leading to UX fix
- ✓ Automated weekly revenue reporting saving 5 hours/week
Generic 'batch and blast' emails were resulting in high churn and low engagement (12% Open Rate). Segmented audience based on RFM analysis and built triggered flows for Abandoned Cart, Welcome Series, and Win-back.
- ✓ 35% increase in Open Rate via personalization
- ✓ 22% recovery rate on abandoned carts
- ✓ Generated $50k incremental revenue in Q1
Ad blockers and ITP were causing 20-30% signal loss in conversion data. Deployed GTM Server-Side container on GCP Cloud Run with custom domain and Consent Mode v2 logic.
- ✓ Restored ~15% of lost conversion data
- ✓ Fully GDPR/CCPA compliant architecture
- ✓ Improved site speed by offloading client-side scripts
Merchandising team lacked visibility into which products had high views but low conversion. Created a 'Product Performance Matrix' dashboard correlating view content_ids with purchase events.
- ✓ Identified underperforming hero products
- ✓ Optimized cross-sell recommendations
- ✓ Data-driven inventory planning for seasonal sales