GameCo Global Sales Strategy

Regional sales intelligence to guide development budget allocation

Excel Pivot Tables Statistical Analysis

Overview

Analyzed 16,598 video game titles spanning 1980–2016 to identify regional demand patterns and genre preferences across North America, Europe, Japan, and other markets. The analysis revealed Europe overtook North America as the largest market by 2016, and delivered data-backed budget allocation recommendations.

Business Problem

GameCo's development and marketing budgets were allocated without clear regional demand signals. Genre investments weren't aligned with market preferences, and the team had limited visibility into competitive positioning.

Business Objectives

  • Identify highest-value regions
  • Match genres to regional demand
  • Optimize development and marketing spend allocation

Data

  • 16,598 video game titles
  • 1980–2016 historical sales
  • NA, EU, JP, Other regional breakdown
  • Unit sales in millions

Analytical Approach

Used pivot tables by region, genre, and year, market share trend analysis, franchise and publisher aggregation, and competitive benchmarking to identify actionable patterns.

Stacked bar chart showing franchise performance in North America over time
Franchise performance in North America: Call of Duty, FIFA, and Pokémon dominate regional sales, revealing franchise-driven revenue patterns.

Key Findings

Europe's rising market share overtaking North America by 2016
Europe overtook North America by 2016 (37.7% vs. 31.9%), shifting future investment priorities.

Top Insights

  • Europe overtook North America by 2016 (37.7% vs. 31.9%)
  • Western markets favor Action/Shooter titles
  • Japan strongly prefers RPGs
  • Top franchises dominate regionally (FIFA in EU, CoD in NA, Pokémon in JP)
  • Demand patterns differ by geography → one-size strategy underperforms

Deliverables

Genre preferences by region and deliverables summary
Japan over-indexes in RPG while Western markets favor Action/Shooter. Content strategy must be regionalized.

Full stakeholder presentation with regional analysis, genre performance breakdowns, and data dictionary delivered to the GameCo Strategy Team.

← Back to Homepage