yuesci

Data Management & Analysis: Managed membership application data for 420 members using Google Sheets to ensure accuracy and completeness. Employed OpenRefine to process over 420 customer inquiry records, enhancing understanding and response time to customer needs. Audience Analysis & Strategy: Utilized Tableau's visualization capabilities to analyze backend data from social media platforms, including audience preferences. Based on the analysis, devised tailored content strategies for different audience segments to enhance social media marketing effectiveness.

Market Research and Analysis: Conducted thorough market research for 21 opera performances, examining audience demographics, preferences, and trends. Leveraged survey findings to inform marketing strategies, leading to a 7% increase in attendance for the performances. Leadership Skill: Led 3 interns to be responsible for writing 7 market analysis reports based on market research information for three performance seasons in 2022. Marketing content planning: Responsible for social media marketing content writing and poster design, drafting press releases for official media. The average number of views per tweet reached 5,000+.

Marketing strategy planning: Responsible for social media content creation, poster design, and press release drafting, achieving over 5,000 views per tweet on average. Data-Driven Report Writing: Crafted 15 reports based on collected media report data and ticketing platform analytics, with six reports selected as exemplars in Beijing Modern Music 2021.

Business Strategy Formulation: Formulating product pricing systems, establishing sales channels, negotiating cooperation plans, maintaining over 200 customers, and achieving annual sales exceeding $430,000 in music courses. Leadership Skill: Led a 6-member team to develop marketing strategies, secure sponsorships, and curate concert programs, leading to the successful execution of 27 concerts over four years and achieving box office revenue surpassing $510,000. Writing and Presentation Skills: Completed the project planning paper and roadshow, the project planning paper was included in the excellent art projectplanning evaluation published in 2023.

Partnership Development: Negotiated sponsorships and established long-term partnerships with three renowned Chinese artists. Organized charity events, raising over $300,000 for 172 families in four years. Curriculum Design: Designed curricula integrating therapeutic education and essential life skills with music therapy for autistic children, while training 31 therapists and treating over 490 autistic children within three years. Writing and Presentation Skills: Completed the project planning paper and project roadshow, won the highest award in the China art business competition, and was selected as the Beijing Young Talent Co-construction Plan.