1. Campaign A/B test and Consumer behavioral analysis
Build up framework and capture data with SQL from our database to analyze our customers’ behavior on our platform. Design A/B test and Make XP recommendation for our promotion construct based on analysis result.
2. Budget analysis and Strategy making
Evaluate and quantify the benefits brought to the company as a whole by various campaigns, and adjust or make plans for campaigns within a limited budget.
3. Dashboard maintenance
Build visualized dashboard for tracking top-line/bottom-line and other meaningful metrics to make assessment for our campaign efficiency.
5. Data Pipeline Automation
Build data pipeline and update data in our database with Python script or developed tool to make data input/output process automated
4. Alarming Chatbot
Create alarming Chatbot to auto send error message while wrong input happened to make sure our input data quality.
6. Gmail auto-sending system
Create Gmail auto-sending program wit Python script, which reduce the regular manual work for our team member.