Sponsored By

Estimating Steam and console sales: two hot methods!

Do you want two essential spreadsheets for estimating Steam & console game sales? Because that's what you've got, alongside lots more game discovery news.

Simon Carless, Blogger

August 11, 2021

10 Min Read
Game Developer logo in a gray background | Game Developer

[The GameDiscoverCo game discovery newsletter is written by ‘how people find your game’ expert & GameDiscoverCo founder Simon Carless, and is a regular look at how people discover and buy video games in the 2020s.]

Time for the second free GameDiscoverCo newsletter of the week, and we’re excited about this one - which has been in development for some time. Launch and post-launch sales curve for your games can be a tricky beast.

And while we can’t predict perfectly, we can present new ways of approaching it! Plus a whole bunch of other active news from the game discovery landscape. Let’s do it.

Your game’s sales estimates: 2 hot spreadsheets

One of the things we get asked about a lot at GameDiscoverCo is: what financial expectations should I have for my game, based on how it’s pacing pre-launch or at launch? To which our answer is… every sale is like a blessed drop of water as you trudge through an endless desert, my son.

But more seriously, we can get very basic, ‘indicative’ ideas of how titles will do, pre-release or shortly post-release. How? We can combine pre-release info like Steam wishlists with post-release info like pricing, sales ratios, and ‘gross to net’ rates.

And while the following two spreadsheets will come with masses of disclaimers, they provide some important data to ballpark estimate possible returns on your game(s). A lot of the time, devs just have no idea what to expect. So here’s a starting point.

Method 1: GameDiscoverCo’s BASIC predictions

Look, GameDiscoverCo made a super simple Google spreadsheet for some of our regular clients, and is now sharing it with you all. Copy or save the spreadsheet to edit it. There are just two things you can change without editing formulas: the number of Steam wishlists at launch, and the average global price in USD of your game.

From there, the spreadsheet makes a bunch of extrapolations to work out: Week 1 Steam sales (as well as Day 1 Steam sales as a bonus)Week 1 Gross & Net Steam revenue (presuming you’re not in a country that has 30% tax withholding from the U.S.!); Year 1 console net revenueYear 1 total net revenue, and then 3-year Steam revenue, 3-year console revenue and 3-year total net revenue.

So the example here: a game with 10,000 Steam wishlists on launch that converted its first week at 0.2 sales per wishlist (so 2,000 sales in its first week) would end up making a net of $222,290 across PC and console over 3 years. (Presuming you discount it, and all that good stuff.)

The biggest gotcha here by far is ‘Week 1 sales compared to launch wishlists’, as we constantly mention - our data says it can be as low as 0.03 and as high as 1 sales per wishlist. So tweak the formula for a variety of scenarios.

Also: this particular spreadsheet is a bit more conservative on Week 1: Year 1 revenue ratio (which we put as 3x) than our actual surveys. And console revenue vs. PC is just a total handwave. But if you want a super easy look at possibilities - here it is!

Method 2: Fellow Traveller’s SOPHISTICATED predictions

What’s that, you say? You want the Rolls Royce of prediction models, and not the spluttering old jalopy that GameDiscoverCo just tried to sell you? Fine, just fine.

Well, good news - the wonderful folks at narrative game publisher Fellow Traveller are making freely available via the GameDiscoverCo newsletter its internal forecasting template (Google spreadsheet link, make a copy to edit) which it shares with all its developers. The publisher uses this model to “have some sort of month by month forecast both for our own budgeting and to give our developers an idea around monthly cashflow, when funding will be recouped, etc.”

The publishers of Paradise KillerGenesis Noir & Neo Cab - who put out narrative game of a specific type, so “wouldn't want to imply that these numbers are gospel or industry standard” - have constructed a much more sophisticated version of the GameDiscoverCo spreadsheet. We’d particularly like to highlight the following:

  • All of the Fellow Traveller calculations are based on Month 1: Launch Wishlist numbers (not Week 1: Launch Wishlist, as we generally tend towards!) So don’t get confused, as we initially did.

  • The document specifically allows you to easily switch your game’s Month 1 Sales: launch wishlist ratio between multiple possibilities: everywhere from 10% (0.1) to 90% (0.9), and all of these options and many more are very possible! (Don’t count your chickens, etc.)

  • There’s some really nice bells and whistles built in, like: being able to enter the launch discount, tweaking the global average price vs. the USD price depending on your country mix, and so on.

  • What’s even nicer is: there’s some clever sales percentages built in to estimate the effect of being in a regular weeklong Steam discount vs. a ‘big’ seasonal sale like the Summer Sale vs. a spotlight sale like Daily Deal/Midweek Madness. They’re all listed as a percentage of month 1 revenue, and broadly based on real-world Fellow Traveller data.

What this document doesn’t show is PC revenue outside of Steam (you’ll have to input those percentages yourself), or console revenue (again, you’ll need to enter those percentages by hand. There’s a very rough estimation at Switch sales boost %s at lower discount rates.)

Why? It’s just that Fellow Traveller (and GameDiscoverCo) didn’t feel comfortable putting ‘typical’ console market share percentages there, because it can vary so radically. We’ve covered this a couple of times in the newsletter - here’s an example from late in 2020, if you want to peep some numbers.

Chris Wright at Fellow Traveller also wanted to add: “The model is most useful once you have real data from your launch, and then update [the spreadsheet] over time... Once you can see things like where your baseline is, what boosts you're getting from promotions and you start to schedule in your sales, it allows you to more accurately predict the tail.”

Anyhow, thanks again to Fellow Traveller for putting this out there. We do feel like this level of communication for publishers to pass on to devs really helps everyone understand what might happen revenue-wise, before and after recoup. (And individual devs can use something like this for revenue estimation, too.) Transparency is king!

Are there more games being released in 2021?

Had a brief Twitter DM conversion with Axios’ Stephen Totilo recently where he asked (in conjunction with an Axios article about how July was packed with interesting new games) what the empirical stats were for game debuts, year on year.

You can argue that, in the era of GaaS titles, there’s so many more actively developed games vying for attention, years after release. So ‘new releases’ is perhaps no longer the best metric. But it’s still a really good one. So this is what I swiftly dug up, and am passing along:

  • On Steam, we have this handy monthly releases chart from SteamDB, which shows that some months are edging over 1,000 games released on Steam. (Sure, a lot of them are hobbyist, but nonetheless.) And the ICO Steam newsletter lists numbers of weekly releases, and I know I saw a week with 260 releases recently. So the answer is - volume is up (June 2021 is 25% increased over June 2020, for example!), but not crazily.

  • On Nintendo Switch, I don’t know of a SteamDB-like site providing monthly release stats (if you do, ping me!) But there’s two newsletters that keep up with weekly releases: the ICO Switch newsletter (which is retrospective) and the Switch Weekly newsletter (which lists games coming out in the next week!)

  • Looking up Switch release numbers listed in the ICO newsletter, we can see: June 2020 newsletters: 39, 28, 31, 37 releases = 135 total, and June 2021 newsletters: 43, 32, 24, 36 releases = also 135 total. These aren’t EXACT month comparisons, because it’s four week rolling numbers. But it looks like Switch releases are broadly flat - at a much elevated number compared to 2017 or 2018 - year on year.

Anyhow, thought that was interesting - and if anyone has a lead on easy ways of tracking new PlayStation and Xbox releases by sheer number, feel free to follow up with us.

(Semi-related: we’re now going to be covering Switch _and_ Xbox ‘recent game’ top charts - by download counts - in addition to Steam Hype/results, via our Friday GameDiscoverCo Plus-exclusive newsletters.)

The game discovery news round-up..

 

OK, let’s round up the remaining game discovery news for the week with some kind of raffish style, shall we? Or at least we’ll manifest a shambling magnificence, as we secretly pretend to be Hunter S. Thompson covering the Kentucky Derby:

Finally, imagine us at GameDiscoverCo, as data nerds, discovering a Valve document in the Apple vs. Epic lawsuit document cache, eagerly opening it, and discovering… this. (We’re still crying theatrically and cursing the redactions.) See you next week!

[We’re GameDiscoverCo, a new agency based around one simple issue: how do players find, buy and enjoy your premium PC or console game? You can subscribe to GameDiscoverCo Plus to get access to exclusive newsletters, interactive daily rankings of every unreleased Steam game, and lots more besides.]

Read more about:

2021Featured Blogs

About the Author

Simon Carless

Blogger

Simon Carless is the founder of the GameDiscoverCo agency and creator of the popular GameDiscoverCo game discoverability newsletter. He consults with a number of PC/console publishers and developers, and was previously most known for his role helping to shape the Independent Games Festival and Game Developers Conference for many years.

He is also an investor and advisor to UK indie game publisher No More Robots (Descenders, Hypnospace Outlaw), a previous publisher and editor-in-chief at both Gamasutra and Game Developer magazine, and sits on the board of the Video Game History Foundation.

Daily news, dev blogs, and stories from Game Developer straight to your inbox

You May Also Like