Camellia Guo

About

With a diverse educational background spanning Mathematics at the University of Birmingham, Strategic Fashion Marketing at Rosso Arts & Design Education, and Marketing at Columbia University, I am currently pursuing further studies at the University of Southern California. My professional journey includes roles such as Content Creator & Digital Influencer at Orange Wine Studio, where I enhanced data accessibility and improved ROI by 15%. At EVE LOM, I increased repeat purchases by 8% through SQL-based analyses and customer segmentation. My tenure at Galenic Cosmetics Laboratory involved managing cross-functional teams and implementing predictive models. Additionally, I have experience in market research with Shanghai Fashion Weekend and digital media content operations at Guangzhou Xuekun Network Technology Co., Ltd.

Experience

• Content Creator & Digital Influencer on Social Media · Orange Wine Studio07-01-2021 – 04-01-2023

  During my time at Orange Wine Studio, I implemented data pipelines to consolidate performance data from multiple sources, including Google Ads and Facebook Ads, improving data accessibility for over 10 clients. I developed and maintained interactive Tableau dashboards to provide clear visualizations of campaign performance across channels, which enabled clients to make informed decisions more quickly. My in-depth analysis of paid search and social campaigns led to a 15% increase in ROI, and I supported marketing strategy planning with KPI predictions and performance impact assessments.

• Marketing Analytics · EVE LOM04-01-2022 – 08-01-2022

  At Eve Lom, I developed SQL-based analyses and Tableau dashboards to track customer behaviors and promotions, resulting in an 8% increase in repeat purchases. I designed an RFM model for customer segmentation, refined a loyalty program, and optimized the churn rate. Additionally, I conducted factor analysis and directed K-means clustering to boost skincare sales by 15%.

• Marketing Analytics · GALENIC COSMETICS LABORATORY12-01-2021 – 05-01-2022

  At Galenic, I managed cross-functional teams in a Python-based A/B testing project, collaborated with sales teams to integrate real-time transaction data using SQL, and implemented predictive models to forecast customer purchase intent. Additionally, I conducted market research and competitor analysis to inform the development of a limited edition product.

• Market research · Shanghai Fashion Weekend01-01-2021 – 03-01-2021

  Conducted market research to gather insights on fashion trends and consumer preferences, supporting event planning and marketing strategies.

• Digital Media Content Operations Intern · Guangzhou Xuekun Network Technology Co., Ltd.04-01-2019 – 06-01-2019

  Assisted in the management of digital media content operations, including content creation, scheduling, and performance analysis.

Education

• University of Southern California
• University of BirminghamMathematics
• Rosso Arts & Design EducationStrategic Fashion marketing
• Columbia UniversityMarketing

Similar talent on Pangea

Sreeja K.Experienced Marketing Analyst and Data Scientist with Expertise in Data Analytics and Machine LearningSShambhavi S.Marketing Analyst | Expert in Data Storytelling, Insights, and StrategyCollege Park, MD 20742Tanya S.Data-Driven Marketing and Analytics SpecialistNaila K.Marketing Analyst & Data Analyst | SQL, Python, Dashboards | Web + UI/GraphicsBengaluru, Karnataka