Sign in

Social Media Marketing analytics

Brooklyn, New York, United States
December 18, 2018

Contact this candidate


CAN LIU +1-507-***-**** http:/


SIMON BUSINESS SCHOOL, University of Rochester- Rochester, NY Dec. 2018 Master of Science in Marketing Analytics (STEM Certified Program, available for full-time and relocation from Jun 2018)

Core Courses: Data Analytics, Marketing Analytics, Marketing Research, Pricing Policies, Advanced Business Modeling Social Media Analysis, Digital Marketing Strategy. St. Olaf College - Northfield, MN Mar. 2017

Bachelor of Arts in Economics and Studio Art

Core Courses: Statistic for Economists, Accounting, Management, Urban Economics, Health Care Economics, Art Relevant courses.

Technical skills: Expert in R, Tableau, MySQL, Advanced Excel (Regression, Analytic Solver, VBA, Marco, Pivot table), SEO, Photoshop, illustrator, Video Editing, In Processing, 3D modeling.


Mayo Clinic - Rochester, Minnesota

Graduate Intern, Innovation Marketing Department Jun. 2018 - Sep.2018

● Examined the pattern of Course Registrations by incorporating with Google Analytics data and transaction data to find the positive influential factors to be replicated in future courses and reported to the leadership.

● Analyzed the monthly email marketing performance (CTR, CTOR, Conversion Rate) to determine which sent dates and subject lines that generates the highest conversion rate and presented the recommendations to managers.

● Analyzed the users experience to determine users interface changes for the and offering the suggestions to maximize user engagement.

● Organized content management database and assisted daily management of marketing efforts across all channels.

Huawei Technologies Co. Ltd. - Sichuan, China Dec. 2016 - Jan. 2017 Marketing Intern,

Marketing and Problem-Solving Department

● Evaluated channel partners’ annual revenue of each product category and identified top ten partners and presented revenue distribution across product categories and locations to guide investments.

● Created marketing strategies and provided support with social media efforts by analyzing and collecting customers’ feedback and click rates from the social media platforms.

● Planned and coordinated the Channel Partner Reciprocal Banquet with more than 400 participants.

ShangXia Trading (Shanghai) Co. Ltd - Shanghai, China July. 2016 - Aug. 2016 Sales/Marketing Intern, Marketing Department

● Provided recommendation on sales report, sales growth and market response by analyzing day to day sales.

● Recommended enhancing social media presence by collaborating with famous artist for designing new collection. Sichuan Swan - Lake Development Co., Ltd., Chengdu, China July. 2014 - Aug. 2014 Sales & Marketing Intern, Marketing Department

● Increased sales by 118% by conducting marketing research and SWOT analysis and developed promotional strategies for 5100 Tibet Spring Water Company.

● Proposed new promotional campaigns using new media channels such as WeChat and Weibo.


Xerox Corporation - Rochester, New York Jan.2018 - Jun.2018 Market Research Analyst (Simon Project)

● Created customer profiles and identified target customer segments by cleansing and analyzing data, implementing principle component analysis and cluster analysis with R.

● Provided recommendations on the product and services for different segments by synthesizing value proposition, social media measurement, and competitive analysis, and created data visualizations using Tableau. Wegmans Food Chain- Rochester, New York Feb.2018 - March.2018 Marketing Analyst

● Analyzed customer feedback survey data related to new products for a prestigious national food market chain, using R and built a predictive model to determine key attributes for potential new product, making a presentation to client and recommending a product launch.

Project: Analysis of Cost of Asthma in Rice County, St. Olaf College Oct. 2014 - Dec.2014

● Analyzed uncompensated asthma care cost, gathered data from MN Department of Health; reduced ER departments uncompensated health care by 54% by proving cost-effectiveness of hospital in-kind donation programs for Health Finders’ cooperative; estimated ROI and break-even analysis.


● Certifications: Google Analytics Advanced Certificated, Google AdWords Fundamental Certificated, Marketing Evolution Certificated.

● Leadership: Co-Chair and VP, Public Relations, St Olaf’s Chinese Culture Club, three years.

● Volunteer: Golf Coach - Coached golf summer camp for children in Chengdu.

● Interests: Photography, Painting and Hiking

Contact this candidate