Home > How Kakaobuy Leveraged Spreadsheet Analytics to Optimize Nike Dunk Colorways by Region

How Kakaobuy Leveraged Spreadsheet Analytics to Optimize Nike Dunk Colorways by Region

2025-06-01

In the dynamic world of sneaker commerce, data-driven decision making has become the cornerstone of successful merchandising. Kakaobuy's recent innovation in applying spreadsheet analytics to their Nike Dunk inventory management demonstrates how granular data analysis revolutionizes regional buying strategies.

Sneaker data visualization dashboard using Kakaobuy spreadsheets
Kakaobuy's regional color preference heatmap for Nike Dunks

The Data Discovery: Two Hemispheres, Two Preferences

By scraping global trend data across five key metrics - click-through rates, cart additions, social media mentions, resale market premiums, and return rates - Kakaobuy's spreadsheet system revealed striking regional variations:

  • North America:
  • Asia-Pacific:
  • Europe:

The Operational Impact

Implemented in Q3 inventory planning, these insights enabled Kakaobuy to develop three regionalized allocation strategies:

Region Previously Dominant SKUs Optimized Selection (Post-Analysis)
North America 60% neutral tones, 40% statement colors 30% neutrals, 70% high-visibility options
Asia 50% new designs, 50% retros 20% current season, 80% heritage styles

Execution & Results

Over 180 days post-implementation, Kakaobuy recorded:

▲ 40% improvement in inventory turnover rate

▼ 22% reduction in seasonal markdowns

★ 18% increase in premium pricing acceptance

The solution wasn't revolutionary technology, but rather smarter applicationquarterly operations report: "When you normalize the data for cultural context and consumption patterns, color preferences telegraphed more meaningful signals than price or size data."

Beyond Sneakers: The Data Democratization Effect

This case study demonstrates three transferable principles for e-commerce businesses:

  1. Use basket abandonment rates as a cultural indicator - not just a conversion issue
  2. Map hex color values along geographic boundaries to identify style corridors
  3. Benchmark regional sell-through against Instagram filter popularity analyses
```