Ziyu Yan

Prospective strategy Intern @ L'Oréal

About

- Strong analytical skills in market and consumer insights. - Experienced in event planning with excellent coordination skills. - Good interpersonal communication skills, highly adaptable to team dynamics. - Strong multitasking and learning abilities. - Passionate and curious about everything. Please feel free to contact me via LinkedIn! I welcome the opportunity for insightful conversation over coffee or online!

Country

France

City

Lyon

Industry

Market Research

Skill

Social Media Marketing, Integrated Marketing, Marketing Strategy, Business Analysis, Event Planning, Microsoft Office

Experience

Prospective strategy Intern

L'Oréal

2023-8 - 2024-3 · 8 mos

Shanghai, China

Prospective trend research, consumer analysis, brand research... Brand Research: Carried out research on 50 + Chinese emerging beauty brands, deep dived into founders, products, channels, consumer feedback, etc., delivered 100+ pages brand analysis report to support corporate M&A decisions. Trend Research: Collected and analyzed the innovative marketing contents, products, technologies in China, independently completed English market insight reports for Chinese Valentine’s Day, CIIE and Chinese Spring Festival, etc. Event Planning and Execution: Participated in the organization of the group’s biggest internal competition Content Award, including planning, material preparation, cross functional communication.

Marketing Intern, KFC

Yum China

2023-4 - 2023-7 · 4 mos

Shanghai, China

Quantitative Research: Assist in survey design and data analysis for consumer testing of new products according to concept, appearance and taste to optimize the product. Campaign Management & Execution: Deeply involved in new product launches and co-branding campaigns, including projects scheduling, competitive analysis, material preparation, communication with suppliers, etc. to ensure project landing. Social Media Operations: Collected and analyzed the publicity feedback on the new products based on different indicators (e.g., CPV, CPE, etc.), optimized the KOL types, script content and launch time, and achieved over 2 million impressions.

Social Intelligence & Analytics Intern

Ipsos

2022-12 - 2023-3 · 4 mos

Shanghai, China

Market Insights: Conducted desk research on key products and ingredients for beauty industry, analyzed and summarized the most potential new ingredients in the Chinese market to support Estee Lauder’s product R&D. Data Analysis: Tracked data such as buzz, engagement on social media platforms (e.g., Weibo, Xiaohongshu, TikTok, etc.) for healthcare industry; conducted data-driven market report to visualize consumer feedback and market trend. Model Building: Participated in the DBPI model building project, conducted regression analysis of the model with Excel and SPSS, determined the social, search and indicator coefficients to let the model better reflect the brand marketing effect.