Where does the money actually come from — and how much of it rides on the top few titles?
Revenue concentration asks one thing: how much of the money depends on how few titles?
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.)
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.
Top 10 titles · share of platform revenue (example data)
How much of total revenue the biggest N titles hold.
Sum of squared shares. Below 1,500: spread out. Above 2,500: concentrated.
The same number, tracked quarter over quarter. Direction matters more than level.
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.