YY

Yunqi Yang

Marketing Data Analytics Intern · BILIBILI INC

Los Angeles, CA

Work Experience

Marketing Data Analytics Intern

BILIBILI INC

2021 – 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 INC

2019 – 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 LIMITED

2018 – 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 University

2020

Bachelor of Science in Business Administration

Master of Science in Marketing

The University of Southern California, Marshall School of Business

2022

Master of Science in Marketing