Brand Protection / Website Revamp / Domain Product

1. System Design✔ Use Google Sheet Query to build a material database, and use tags to build an automatic recommendation system✔ Integrate Internet public opinion through GAS link API, and create a reminder system by sending emails through Gmail2. PR Marketing✔ Facebook public opinion monitoring✔ Fundraising-related copywriting

1. Data Analysis✔ Set key marketing indicators and build a site-wide traffic monitoring dashboard through Data studio✔Using Google Analytics to build a product marketing monitoring dashboard and provide strategic recommendations to produce daily and weekly reports✔Using open data and web crawlers to build information collection spreadsheets, saving the team more than 40h of working hours per month2. Community management✔Facebook, Instagram copywriting and advertising✔Design EDM template, EDM delivery, and tracking mechanism

1. Content editing✔ Copywriting more than 380 websites articles and 280 Facebook posts ✔ Pack 9 topics and write 5 articles✔ Optimize SEO, keep it on the first page during article maintenance✔ Design chat robot interactive posts. create more than 60% of readers convert and fill in the form, and 80% of readers create additional traffic2. Data analysis✔ Annual analysis of 3 flow pipelines✔ Use Tableau, Flourish, Excel to analyze the effectiveness of 3 projects✔ Use Mixpanel to create a dynamic dashboard of product user data✔ Use Python to crawl data and produce analysis reports3. Other✔ Development 3 new content reprint author✔ Automated e-book production process, saving labor hours up to 4.5h✔ Assist in the design of automated newspaper logic

1. Customer Service Specialist✔ Act as a bridge between customers and the hotel, soothe their emotions and gather opinions report to the hotel2. Propose solutions and optimization plans based on business conditions✔ Design and preparation of sales report✔ Analyze and design consumer profile reports, which integrate customer opinions and characteristics.✔ First-month entry, salespeople speak highly of reports