Marketing Performance Audit: Q1 2026 (Data cleaning and KPI engineering)
Created and consolidated cleaned marketing datasets from multiple ad platforms to support performance analysis. Normalized different schemas and naming conventions into a unified format to ensure consistent downstream interpretation. Investigated calculation issues and missing metrics to maintain ROI accuracy for reporting. • Consolidated marketing data from Google Ads, Facebook, and Mailchimp. • Normalized schemas and naming conventions. • Corrected calculation errors and handled missing cost metrics. • Engineered KPIs (ROI, CPC, CPL) for actionable budget allocation.