Yujun Wang
Senior Media Analyst · PETROL Advertising
Los Angeles, CAWork Experience
Senior Media Analyst
PETROL Advertising2017 – 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 US2015 – 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 Group2014 – 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 Inc2013 – 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 Economics2008 – 2012
B.A. in Public Affairs Management
M.A. in Communication Management
University of Southern California2013 – 2014
M.A. in Communication Management