Product Data Analytics
1. Data Replay: Utilized SQL to capture data on products and sellers in the apparel industry. Conducted weekly data reviews across different dimensions such as products and sellers, analyzing the relationship between GMV, sales volume, and seller count changes. Compared with overall market trends and analysed abnormal data to identify reasons for changes, culminating in weekly replay reports.2. Promotional Activity Submission: Segmented products based on price and seller needs for promotional activities. Classified products into high-priced, zero-bid, and bid-but-limited-supply categories, designing tailored promotional activities to achieve an average GMV_ROI of 25. Sellers were segmented into retention, re-engagement, and cross-category acquisition categories. Developed a seller reservation system from 0-1 based on seller bid frequency and order volume, issuing coupons to recently inactive sellers to prevent attrition, successfully retaining 4,000 sellers. Achieved 150% of the quarterly KPI completion rate.3. Cross-Category Acquisition: Proposed cross-category acquisition activities targeting sellers with sales in other categories of the same brand. Issued seller coupons based on different sales volumes, continuously optimizing sensitivity towards these coupons. Analyzed monthly GMV trends and assessed main seller group GMV proportions through month-over-month and year-over-year comparisons. Engaged with industry colleagues for revisits to top and middle-tier sellers showing data anomalies to prevent seller loss.