Yujia Fan

• Conducting strategic analysis on customer data using BigQuery(SQL) to identify, quantify, and execute opportunities for revenue and customer profitability growth;
• Supporting customer lifecycle strategy, optimize loyalty structure and strategy, and analyze data model performance;
• Continuously improving customer-targeted marketing processes, including pre and post campaign analysis, sizing analysis, customer profile analysis, A/B testing for offer identification, communication channels, and fulfillment;
• Establishing and maintaining working relationships with key stakeholders, quickly responding to ad hoc analytical requests.

Achievements:

• Enhanced customer engagement by 20% through optimized loyalty program structure;
• Boosted ROI by 18% through optimized campaign targeting strategy;
• Reduced marketing campaign costs by 10% through process automation;
• Improved accuracy of customer models by 25%, leading to more effective marketing campaigns.

• Conducted A/B testing to optimize website and get insights from web analytics tools such as FullStory to improve website/mobile apps UI design;
• Worked closely with marketing team to perform and present analysis using Python, SQL and Tableau to support campaign and product design;
• Managed creation, delivery and amplification through social media to increase brand awareness and lead generation;
• Designed email, building customer journey and automation workflow in MailChimp;
• Delivered and reported analysis by Tableau and Google Analytics and provided actionable insight and recommendations.

Achievements:

• Decreasing the bounce rate of website homepage from 65% to under 40%;
• Increasing email campaign efficiency by 12.5% through customer analysis;
• Increasing e-commerce sales by 20% in 3 months by creating social media strategy;
• Developing clear CTA's on all website and social media copy, delivering a 50% uplift in leads.

• Developed social media calendar, which included scheduling posts, marketing campaigns and website updates;
• Optimized social media channels and web pages to improve SEO, SEM and usability.
• Managed email marketing strategy by SQL and MailChimp, including email creatives, audience segmentation, A/B testing, delivery and reporting of metrics.
• Tracked and reported on marketing campaign performance monthly by Google Analytics and Tableau to help with optimizing current and future plans.

Achievements:

• Boosted online sales by 20% through managing a multi-channel digital marketing campaign;
• Reduced customer acquisition costs by 15% through optimizing paid search and social media advertising campaigns.