• Worked with marketing team to understand analytical needs, including identifying critical metrics and KPIs in various marketing campaigns to drive business growth and conducted webpage data tracking design.• Conducted customer retention strategy analysis, explored data and analyzed variability from trends with 3 years’ customer data and proved the retention strategy’s effectiveness.• Used Tableau and other technologies to pull data from different backend systems including company’s database, Google Analytics, Google Ads and HubSpot and conducted data cleaning and monitored marketing performance daily, weekly and monthly providing reporting to improve efficiencies. • Provided full data analysis support for 2017&2018 e-commerce sales review report and developed data visualization integrating various reporting components from multiple data sources; Come up with optimization strategies to boost e-commerce traffic and conversion rate including SEM and SEO strategies.

• Led a five-member team reviewing data of approximately 2500 dealers’ marketing activities across China of first quarter in 2017 as part of Mercedes-Benz Project in Auto team by using Excel and compose reporting of dealers’ marketing performance based on collected data. • Created Cars Land business plan for Cangzhou Economic Development Zone Management Committee and presented to client in a team environment. • Wrote proposal of consumer market research for a new designed car of BAIC Group.

• Leveraged Google Analytics and Adobe Analytics to monitor data and wrote weekly and monthly reports to optimize Audi’s search engine marketing strategies and official website layout settings for three months.• Finished year-end report by building pivot tables analyzing raw data and solved abnormal data problem.• Devised guideline reports as pre-reading of interns summarizing working experiences including how to utilize data in Google Analytics and Adobe Analytics and common errors in processing data.