Yunqi Yang
Marketing Data Analytics Intern · BILIBILI INC
Los Angeles, CAWork Experience
Marketing Data Analytics Intern
BILIBILI INC2021 – 2021
Monitored competitors' business strategy and objectives through multi-channel and launched new campaign for P&G, LOréal, and Estee Lauder which increased Gross merchandise volume (GMV) by 23% in two months. • Supervised 100+ contracted content curators, captured and analyzed User Generated Content (UGC) metrics from MySQL database; increased 100k new subscribers; exceeded quarterly objectives of conversion by 21% • Optimized marketing budget based on Demand Side Platform (DSP) to improve video monetization strategy; adjusted acquisition cost and Ads published prices monthly based on eCPM; increasing ROI by 26% monthly
Marketing/Transportation Analysis Intern
CHEMAXIANG CARLESS CARRIER TRANSPORTATION INC2019 – 2019
China • Spearheaded forecasting model through A/B testing and offline research among potential target users and developed go-to-market strategy for the launch of new mobile application "Mr Truck" resulting in 17,000 downloads; increasing average app engagement time by 2x and decreasing drop off rate by 23% compared to test group • Maintained partnerships with local businesses to grant toll-free passages to trucks, increased number of trips by 12%; increased profit by 25% total • Conducted Search Engine Marketing(SEM) by optimizing segmentations from 2,000 keywords in SAS/JMP; exhausted $15,000 paid advertising budget to increase new signup rate by 38%
Marketing Data Analytics Intern
KEMA HOLDINGS LIMITED2018 – 2018
China • Constructed customer predictive model for new feature launch by using SAS JMP in Southeastern China; cutting 14% from paid advertising budget compared to last month • Implemented Decision Tree model for customer segmentation and hierarchical analysis using SAS database • Modified a major pricing system by different customer segments; increased average margin of 12%
PROJECT Perfumery Recommendation Engine Design • Built enhanced perfumery recommendation using MANOVA and regression model after aggregating data from Frangrantica • Implemented visualization in R Shiny and Tableau to show the most significant variables impacting perfume ratings • Created dashboard showing principal perfume rating influencing features and metrics using R shiny and Tableau, such as sillage and longevity
Movie Recommendation Engine • Aggregated data from IMDB and Rotten Tomatoes, and used k-nearest-neighbors and neutral network by SAS to improve an movie recommendation system • Saved an average of 14 minutes on movie selection relative to previous methodology • Built visualizations in Tableau to show how my ratings changed and how the model performed over time
Education
Bachelor of Science in Business Administration
The Ohio State University2020
Bachelor of Science in Business Administration
Master of Science in Marketing
The University of Southern California, Marshall School of Business2022
Master of Science in Marketing