Research on Okeyhaul International Shopping Service User Geographic Distribution in Spreadsheets and Market Expansion Planning

2025-04-25
Jordan 4 Retro (40 color)-0001
Jordan 4 Retro (40 color)-0001
$34.25
AirPods 3-0102
AirPods 3-0102
$7.53
casabianca(40 styles)-1146
casabianca(40 styles)-1146
$25.89
Prada Casual Sneakers (22 color)-0015
Prada Casual Sneakers (22 color)-0015
$38.08
dior b22-b23-0027
dior b22-b23-0027
$45.21
AMIRI MA-1-0024
AMIRI MA-1-0024
$71.23
Dior B30 Series (20 style)-0416
Dior B30 Series (20 style)-0416
$45.21
2024 New Jordan 4 (12 colors)-0010
2024 New Jordan 4 (12 colors)-0010
$38.36
New Balance 9060 series (20 style)-0011
New Balance 9060 series (20 style)-0011
$38.36
Denim tears T-shirt -0930
Denim tears T-shirt -0930
$9.32
Rolex watches (3 qualities 14 styles)-0396
Rolex watches (3 qualities 14 styles)-0396
$52.05
GOYARD Fashion bags-0182
GOYARD Fashion bags-0182
$9.45
OG Balenciaga speed-1047
OG Balenciaga speed-1047
$44.93
dunk low （30 color）-0003
dunk low （30 color）-0003
$19.18
Amiri Cap-0662
Amiri Cap-0662
$13.56
Louis Vuitton fashion bag-0185
Louis Vuitton fashion bag-0185
$47.95
Balenciaga Triples (7 styles) -0515
Balenciaga Triples (7 styles) -0515
$82.19
24-25 Football Jerseys (40+ Colors)-0948
24-25 Football Jerseys (40+ Colors)-0948
$9.32
LV bucket bag（10 styles）-0187
LV bucket bag（10 styles）-0187
$54.66
LV Louis vuitton belt（36 style）-0246
LV Louis vuitton belt（36 style）-0246
$11.64

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

[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:

  1. Localized marketing using Douyin (China) and LINE (Thailand)
  2. Warehousing partnership in Hanoi to reduce Vietnam delivery time
  3. Customs brokerage optimizations for European Union regions
  4. Culturally adapted product bundles (e.g, Ramadan specials for Malaysia)

5. Next Steps

Recommend establishing dedicated regional task forces

  • Automated Google Apps Script imports
  • Dynamic dashboard in Google Data Studio

*All currency conversions calculated at Q3 2023 exchange rates

```

Hoobuy.club Legal Disclaimer: Our platform functions exclusively as an information resource, with no direct involvement in sales or commercial activities. We operate independently and have no official affiliation with any other websites or brands mentioned. Our sole purpose is to assist users in discovering products listed on other Spreadsheet platforms. For copyright matters or business collaboration, please reach out to us. Important Notice: Hoobuy.club operates independently and maintains no partnerships or associations with Weidian.com, Taobao.com, 1688.com, tmall.com, or any other e-commerce platforms. We do not assume responsibility for content hosted on external websites.