Back to Home
Portfolio Archive

All Case Studies

A complete log of my technical audits, data pipelines, and marketing analytics engineering projects.

Server-Side GTM Cloudflare

First-Party Tracking Pipeline & ITP Bypass

Bypassed standard Safari ITP restrictions by shifting from client-side JavaScript tracking to a resilient, server-side HTTP pipeline.

Read More
SQL Identity Resolution

GA4 & Salesforce Pipeline Reconciliation

Built a deterministic SQL Identity Graph to connect raw GA4 event logs directly to Salesforce CRM data, recovering 1,600 missing leads.

Read More
Attribution SQL

Last-Click Attribution Analysis

Built a custom SQL attribution engine directly within the data warehouse, exposing a $412K misattribution error.

Read More
Data Reconciliation sGTM

Ghost Transactions & Attribution Decay

Reconciled 50,000 backend logs vs front-end events to expose a 36% data loss from ad blockers, solved via server-side architecture.

Read More
SQL Modeling

SQL Business Questions Analysis

Architected a normalized SQL database to eliminate manual spreadsheet merges and calculate true financial ROAS.

Read More
GA4 GTM

GA4 & GTM Event Architecture

Engineered a custom GTM pipeline with strict event taxonomy to capture precise lead-gen interactions and abandonment.

Read More
Power Query ETL

Power Query Automated ETL Pipeline

Engineered a fully automated, refreshable Power Query pipeline using custom M Code to eliminate manual Excel cleanup.

Read More
Next Step

Need help with tracking, reporting, or data architecture?

If you need support with GA4/sGTM setup, Power Query automation, SQL-based attribution, or BI dashboards, let's talk.

Contact Me Back to Home