[Budget Management]- Use Vlookup function to analyze monthly budget expenditures of the team. Assist in expense accruals, and prompt timely reimbursement of expenses by sales teams.[Sales Support]- Collaborate with sales and technical teams to design sales tools for passenger vehicle products. - Communicate with suppliers to update product materials; assist in channel material management and distribution. - Assess sales team's understanding of product selling points.[Audience Research]- Assist to refine selling points for the CK-4 level new product series for commercial vehicles based on the concerns of commercial vehicle owners. The outcomes were successfully accepted by the supervisor and used for sales training materials.[Competitor Analysis]- Analyze the communication strategy of competitor's CK-4 level products launch. - Collect and organize information on major competitors' products, including oil viscosity, OEM certifications and trends in electric vehicle products.

[Project Execution]- Participate in campaign execution for clients such as M&G Stationery, Nippon Paint, The Singleton and Buccellati. Assist in writing social media copy, project competition applications, Retainer monthly reports, and project closures reports; the co-writed May 1st holiday article for Corum's Wechat official account gained a total engagements of 720+[Social Media Research]- Analyze the content formats, product usage scenarios and audience characteristics of Sony and its competitors' communication for their headphones and camera products on Xiaohongshu, Bilibili and Douyin. The research results were accepted and included in the final proposal by the team.[Influencer Advertising]- Responsible for briefing and quality control of content co-created with 17 influencers for M&G Stationery's Sakura Season, generating a total engagements of 24,000+.[Social Media Advertising]- Assist in monitoring the WeChat Moments and Weibo advertising data for Buccellati, and assist in making monthly reports.[Admin Tasks]- Responsible for cross-departmental collaboration to follow up on the supplier payment process, including contract signing, stamping, and payment material organizing.

[Social Media Operations]- Manage Douyin, Xiaohongshu, and Weibo accounts for the "Tengmanyu" online parenting course project.[Community Operations]- Collect and organize learning materials of online parenting. Assist in managing online course communities.

[Promotion Planning]- Learn and plan communication strategies for mobile game promotion. Participate inthe planning of the offline activity execution plan for the mobile game "Encounter in Nishui Han."