YW

Yujun Wang

Senior Media Analyst · PETROL Advertising

Los Angeles, CA

Work Experience

Senior Media Analyst

PETROL Advertising

2017 – Present

Clean, manipulate, and analyze large datasets in Excel & SQL. Lead client-facing report activities to advise and drive media strategies through actionable data-driven insights. ? Automate data transformation and streamline reporting process through business intelligence tools for live campaigns. Create and maintain dashboards to provide weekly updates of relevant KPIs and visualizations to support campaign monitoring and optimizations. ? Stay well-versed in digital marketing tools and trends. Support business pitches with research and data supports. Train an associate media analyst and interns. ? Design measurement plans for traditional and emerging media, set up campaign tracking, and conduct ad-hoc research. Advanced Tech Skills& Tools: Google Analytics, SQL, R, Tableau, Datorama

Social Media Manager

LeEco US

2015 – 2017

? Analyzed data from multiple channels including internal data department, Google Analytics, and social media channels to improve campaign performances. ? Planned and implemented marketing campaigns for new TV shows and movies via online and offline platforms including social media, influencer collaboration, email marketing, media buy, and offline events. Built and maintained relationships with content providers and influencers. Advanced Tech Skills& Tools: Excel, Google Ads, Facebook Business Manager

Marketing and Communications Coordinator

Orb Media Group

2014 – 2015

? Composed investment proposals for upcoming projects. Built and maintained relationships with stakeholders. ? Conducted research and data analysis for project packaging. Prepared company portfolio for PR inquiries. LEADERSHIP EXPERIENCE

Editor in Chief

CHIHUO Inc

2013 – 2014

Built content calendars. Managed 20+ freelance writers. Maintained and cultivated relationships with influencers. ? Generated content on Facebook, Weibo.com, WeChat, and other social media platforms. CHIHUO gained 80K+ followers in one year. Conducted marketing campaigns for more than 20 restaurants.

Education

B.A. in Public Affairs Management

University of International Business and Economics

2008 – 2012

B.A. in Public Affairs Management

M.A. in Communication Management

University of Southern California

2013 – 2014

M.A. in Communication Management