Revenue concentration analysis

Where does the money actually come from — and how much of it rides on the top few titles?

What is this?

Revenue concentration asks one thing: how much of the money depends on how few titles?

CONCENTRATED Top 10 = 65% of revenue ten bets — one flop moves the total SPREAD OUT Top 10 = 15% of revenue no single title can move the total

Same total revenue — very different risk. The analysis measures which of these you are, and which way it is drifting quarter over quarter. (Blue = top 10 titles, grey = everything else.)

The question

Is revenue isolated to a handful of AAA games, or is it concentrating in a specific area?

You already have the data — purchased market reports and internal flat files. Today the answer is assembled by hand in Excel.

The workflow

Files in
Market reports (PDF)
Sales flat files (CSV / Excel)
The agent works
  1. reads the files
  2. groups by title, genre, region
  3. ranks & computes shares
  4. drafts the memo
Artifacts out
Chart + one-page memo
A reusable skill — re-run next quarter in minutes

What the answer looks like

Top 10 titles · share of platform revenue (example data)

Top 10 titles share of platform revenue, example data Ten titles hold 14, 11, 9, 7, 6, 5, 4, 3.5, 3, and 2.5 percent of revenue. The cumulative share of the top ten is 65 percent. 100% 75% 50% 25% 0% 14% 11% 9% Top 10 = 65% Title A Title B Title C Title D Title E Title F Title G Title H Title I Title J
Two thirds of revenue in ten titles — and the quarter-over-quarter direction of that number is the real answer.

Three numbers that measure it

Top-N share

How much of total revenue the biggest N titles hold.

HHI

Sum of squared shares. Below 1,500: spread out. Above 2,500: concentrated.

The trend

The same number, tracked quarter over quarter. Direction matters more than level.

Before / after

By hand today2–3 days in Excel per refresh, redone from scratch each quarter.

With an agentminutes from files to memo — and the method is saved as a skill anyone on the team can re-run.