Yuhan Li
Social Intelligence Analytics Intern · Ipsos
Work Experience
Social Intelligence Analytics Intern
Ipsos2022 – 2022
Monitored 50k+ e-commerce reviews for 20 primary competing products of Philips across 5 categories consistently; leveraging text-mining and sentiment analysis to identify key insights into market response in monthly reports • Assessed online campaign performance for 16 competing brands of Philips through quantitative and qualitative analysis; consolidated insights into media strategies aimed at improving a 20% engagement rate • Conducted competitive research on small appliances, including key profitable features, product position, and innovation trends to bridge perception gaps, optimize differentiation marketing and prospect growth opportunities • Evaluated brand-enhancing effectiveness of product placement for Ford Territory on consumer & product dimensions through the integration and cross-analysis of 400+ questionnaires using Excel's pivot table and t-testing
Media Planner
Market Plan for Family Resiliency Center at UIUC2021 – 2021
Targeted scholars and service providers on different platforms by devising annual social media strategy with a pulsing schedule, tracking online and offline communication channels, and tailoring content for different platforms • Optimized budget allocation through leveraging public resources including university newsletter and library digital display to reduce costs by 17% and to reach a greater target audience • Convened with the client on a regular basis to align the process with organization's goal and make timely adjustments; the final proposal was chosen by client among 7 competing groups for future implementation
TECHNICAL SKILLS & LANGUAGES Computer: MS Office; Adobe Photoshop & Lightroom; RStudio, Python (in-progress); Google Analytic; Canva Languages: English (Proficient), Mandarin Chinese (Native)
Account Executive Intern
Ogilvy2021 – 2021
Orchestrated communication among co-organizers and vendors to assist in event implementation of the 2021 World Artificial Intelligence Conference for representatives from 300+ industry-leading companies and institutions • Oversaw the operation of the opening ceremony and 4 sub-forums by leading 12 volunteers to perform field control; formulated procedures to respond to unplanned circumstances, vacant seat relocation, and material distribution • Translated and proofread 7k+ words of external and internal documents for pharmaceutical client; aligned schedules and calibrated scripts with client and press release distribution platform; integrated follow-up media reports
Remember Their Voices (NGO) New York City, NY Part-time Social Media Creative Dec 2020 - Apr 2021 • Administrated day-to-day social media accounts management and executed highly engaging social media campaigns • Enhanced public awareness of underrated injustices against BIPOC and disadvantaged groups by updating social media 3 times a week with 3 different columns that share facts, concepts, and stories of historical figures • Researched and generated infographics via the Canva platform; published 20 Instagram and Facebook posts and obtained a 26% increase in engagement rate as well as over 120 new followers
ACADEMIC PROJECT
Education
Master of Science in Marketing Analytics
Johns Hopkins University Carey Business School2023
Master of Science in Marketing Analytics
Bachelor of Science in Advertising
University of Illinois at Urbana-Champaign College of Media2018 – 2021
Bachelor of Science in Advertising