Case Studies
Write-ups from consulting engagements.
- Specialty Media Acquisition — Audience Data Integration
Integrating the audience analytics and content tracking of a specialty media brand into a larger publishing group's data infrastructure post-acquisition.
- →Mapped source systems and audience data assets across 4-5 specialty brands prior to close
- →Backfilled and secured 3.7 million historical email addresses for unified audience tracking
- →Reduced field mappings from 3,000 to 900 to meet platform constraints while preserving data fidelity
- →Harmonized audience definitions and content engagement metrics across both organizations
- →Delivered integrated reporting within weeks of close, enabling the combined editorial team to operate from a single data view
- B2B Media Group — Three Years Building a Data Foundation
Analytics engineering across a multi-property B2B publishing company: audience data, advertiser reporting, semantic layer, and two M&A integrations.
- →Unified audience data across multiple editorial properties into a single, tested analytics layer
- →Migrated from fragmented legacy reporting to a dbt + BigQuery stack with documented lineage
- →Unblocked 10+ marketing team members from a single-analyst CSV request queue through self-service analytics
- →Identified $932/day in warehouse waste from over-aggregated dashboards and pre-aggregated the underlying models
- →Reduced sales data entry error rates (25-30% SKU errors) through validated input pipelines
- →Supported data due diligence and post-close integration for two sub-brand acquisitions
- Industrial Trade Publisher Acquisition — Data Due Diligence & Integration
Pre-close data assessment and post-acquisition analytics integration for a specialty B2B media brand in the industrial manufacturing space.
- →Assessed data assets across 80+ websites spanning 3 industry verticals within a compressed pre-close timeline
- →Identified and catalogued gaps in audience data coverage and tracking infrastructure before the transaction closed
- →Integrated 126K+ audience records into the parent company's existing BigQuery + dbt warehouse without disrupting live reporting
- →Reconciled audience and engagement definitions across the two organizations
- Performance Marketing Agency — Identity Resolution Across 8 Data Sources
Building a unified contact and audience record for a digital marketing agency managing campaigns across hundreds of brand clients.
- →Resolved customer identity across 8 data sources — CDP, GA4, email platforms, paid media APIs — into a unified master contact record
- →Lifted audience match rates from 30% to 60%, reclaiming roughly $60K/month in paid search spend on a $200K/month budget
- →Built a GA4 → BigQuery → dbt pipeline covering the agency's full client portfolio of 200+ brands
- →Expanded email marketing tracking from clicks-only to full deliveries, opens, and engagement funnel
- →Enabled phase-based engagement continuation — work that started as a project became a multi-year analytics partnership