Kaiyue Bian Email & Phone Number

Los Angeles, Ca, Us

Los Angeles, California, United States

•Campaign Reporting: Identified key metrics, developed reports using Google Analytics and Looker Studio to track performance for digital campaigns and website, provided insights for stakeholders to optimize marketing strategies and website design.•Dashboard Development: Cleaned up datasets using SQL/R/Python; designed and maintained Tableau dashboards to visualize business data including patient volume and annual target progress of each service line for business development team.•Market Research: Collected and analyzed market data, industry reports, and secondary research sources to identify key trends, drivers, and challenges impacting healthcare markets; presented findings during quarterly performance review.•Ad-hoc Analysis: Created reports based on business questions including analyzing the high drop-off rate during website conversion.

Shanghai, China

•Product Development: Participated in new product development projects, brainstormed the product concept and conducted the market research to form product concept boards, conducted consumer research to test the product concepts by interviews and surveys, worked with agencies to create brand and product assets, conducted market research and made proposal slides about the design and material of the new products.•Project Management: coordinated the work of agencies, the R&D center, supply chain department, and brand building team, tracked the project progress, identified the potential problems that would delay the projects and proposed solution.

Shanghai, China

• Project Management: Participated in product launch projects, coordinated the work of the R&D center, laboratory, supply chain department, marketing departments of four countries and regions in North Asia; collected the market information in North Asia and analyzed the data to support the local marketing strategies in terms of product positioning, pricing, marketing assets demand, etc.• Strategic Marketing: Assisted in the completion of the future-three-year growth plan report in North Asia, analyzed market performance data, consolidated local consumer insights and market research, proposed the implementation plan for the product launch and branding with 50-page slides.• Industry Research: Used excel to analyze the market share, consoled net sales and campaign cost proportion, etc. by category, franchise, channel, etc.; conducted the competitor analysis; made the monthly reports.

Shanghai, China

• Campaigns Management: Participated in 2 campaigns, served a client from the education sector, collected information from various sources, combed them into tables for the campaign strategy reference; conducted interviews to study the new user's behavior and demand; brainstormed with the team, provided the general creative idea for the campaign and being adopted at last; the online activity has attracted 1.3 million views.• Marketing Strategy: Assisted the team to make the marketing communication strategy for 2021 with 56-page slides; collected the advertising data in 2020 from Weibo, WeChat and client's website and visualized the results, concluded the pros and cons of the previous strategy; finished the market research report of the industry; conducted the competitor analysis.• Dynamics Summary: Managed client’s social media accounts; monitored the daily performance data; organized the findings into the monthly report; made the social listening reports based on the users' posts and comments.

中国 上海市

SMG(Shanghai Media Group)

Master'S Degree, Communication Management

Activities and Societies: Oriana Women's Choir Student worker Related courses: -Decision Making Using Marketing Analytics (Conjoint.

Bachelor Of Arts - Ba, Advertising

Activities and Societies: the head of the Academic Department, School Student Union; Fudan News Center’s new media operation department.

Language Interpretation And Translation

中学, /

Activities and Societies: Roots & Shoots (根与芽) AR-PEN