Research on Okeyhaul International Shopping Service User Geographic Distribution in Spreadsheets and Market Expansion Planning
2025-04-25
This study analyzes the geographic distribution of Okeyhaul's international shopping service users through spreadsheet data processing, evaluating market potential across regions to develop targeted expansion strategies.
1. Data Collection and Processing Methods
Raw user data was compiled from:
- Order history (2019-2023 quarters 1-3)
- User location registration records
- IP address mapping analysis
- Customer service inquiry logs
Key metrics formatted in Google Sheets:
COUNTIFS(), SUMIFS(), GEOCODE()
2. Geographic Distribution Analysis
| Region | User Count | Avg. Order Value | Frequency | Top Categories |
|---|---|---|---|---|
| Eastern China | 8,742 | ¥578 | 3.2/month | Electronics, Luxury |
| Northern Europe | 2,415 | €342 | 1.8/month | Outdoor, Babycare |
| SE Asia | 6,329 | $89 | 7.4/month | Fast Fashion, Cosmetics |
3. Key Findings
Cluster Analysis Shows:
- Tier-1 Chinese cities
- Southeast Asia
- Western Europe
- Southeast Asia
[HEATMAP SHOWING USER DENSITY BY REGION]
4. Market Expansion Strategy
Phase 1 Targets (2024Q4-2025Q2):
| Primary Expansion | Secondary Growth | Observational |
|---|---|---|
| Vietnam Metropolitan areas | Japanese countryside | Mediterranean region |
| China's 2nd-tier cities | Singapore expats | Baltic states |
Implementation Plan:
- Localized marketing using Douyin (China) and LINE (Thailand)
- Warehousing partnership in Hanoi to reduce Vietnam delivery time
- Customs brokerage optimizations for European Union regions
- Culturally adapted product bundles (e.g, Ramadan specials for Malaysia)
5. Next Steps
Recommend establishing dedicated regional task forces
*All currency conversions calculated at Q3 2023 exchange rates