Yanran Li

Master's

Business Analytics

Mindshare

Senior Associate Strategy AND Analytics Advanced Analytics

- Built multivariate regressions models (Marketing Mix Modeling) to evaluate the efficiency and effectiveness of different marketing channels (Paid Search, Paid Social, TV, etc), enhancing overall ROI from $7.37 to $8.22 - Led the management and processing of 900,000+ lines of data in a pipeline, establishing a standardized process for retrieving, cleaning, and transforming data for QA using SQL and Alteryx, reducing the timeline by 1 week while - Conducted monthly forecasts and ad-hoc analysis to strategically allocate a $220M budget across 16 different channels - Developed and maintained automated dashboards using Tableau and Power BI, saving teams by 6 hours per week and ensuring real-time access to key metrics for stakeholders - Collaborated with internal teams across Buying, Planning, and Digital Investment team to produce strategic client