Thanks from me too. It's rare to see such a welcome sight in a more journalistic setting. It's a shame about the pie chart though. They make me cry.[url=http://meincmagazine.com/civis/viewtopic.php?p=26666497#p26666497:ofrkt4y1 said:pqr[/url]"frkt4y1]Kyle, thanks for log-lin plot.
[url=http://meincmagazine.com/civis/viewtopic.php?p=26666493#p26666493:1zq7aygt said:Kyle Orland[/url]":1zq7aygt][url=http://meincmagazine.com/civis/viewtopic.php?p=26666467#p26666467:1zq7aygt said:Zandros[/url]":1zq7aygt]It is somewhat surprising that KSP doesn't show up in any of the charts. I've no idea how much it's sold, but it seems to me like it could've been a contender in the median number of hours played.
KSP is 168th in number of players, with about 645K by our estimates. Not too bad.
[url=http://meincmagazine.com/civis/viewtopic.php?p=26668025#p26668025:2if4cw9c said:AstroGrover[/url]":2if4cw9c]What's with the ones where 100% of all owners have played it? You can't tell me there's not a single person that hasn't played their copy of TF2.
[url=http://meincmagazine.com/civis/viewtopic.php?p=26668101#p26668101:1qlwang6 said:Pantagruel[/url]":1qlwang6]I personally think the "games bought but never played" data from the other article is one of the most important take outs of all this. It seems Steam Sales create an opportunity for titles to generate revenue from audiences they don't even actually appeal to. I really can't decide if this is good or bad.
[url=http://meincmagazine.com/civis/viewtopic.php?p=26666715#p26666715:1uzgiygy said:Kyle Orland[/url]":1uzgiygy][url=http://meincmagazine.com/civis/viewtopic.php?p=26666651#p26666651:1uzgiygy said:Archangel Mychael[/url]":1uzgiygy]I'd like to see some Linux data to see how well it's doing.
I'd love that too, but SteamCommunity doesn't break out which platform version of a game a person is or isn't playing...
[url=http://meincmagazine.com/civis/viewtopic.php?p=26667219#p26667219:12jbsvwo said:Hydrargyrum[/url]":12jbsvwo]Something's gone wrong with the Publisher and Developer columns towards the end of the list - I know that Trine 2 is a Frozenbyte game and Dishonored is Arkane Studios, but this chart has the credits offset by one place, so Dishonored is credited to Frozenbyte and Amnesia: The Dark Descent is credited to Arkane Studios. I'm not sure exactly where the rot sets in but I suspect "War Inc: Battlezone" is not a Valve game.
Steam doesn't measure my gameplay hours correctly, even since 2009. Is this common?
[url=http://meincmagazine.com/civis/viewtopic.php?p=26669037#p26669037:2h4t8zmw said:Orestus[/url]":2h4t8zmw]This is a fascinating article/series and a great piece of reporting and investigation. Bravo!
Is there any explanation as to why DOTA 2 and TF2's owner numbers and player numbers are identical. It would seem to me to be statistically impossible for the 25,926,966 estimated people owning DOTA 2 that every single one of them has in fact played the game. Same w/ TF2 (I have TF2 as an "owned game" in steam and have definitely never played it for instance) I understand the final numbers are estimates based on your polling, but is it really the case that every single account you've polled, which still seems to be a huge volume of accounts, that owned these games has also played them?
I suspect Steam is going to quickly take action to stop this type of reporting considering how tightly they guard their sales numbers, but run w/ this while you can.
[url=http://meincmagazine.com/civis/viewtopic.php?p=26669105#p26669105:47tna2mt said:robotic_tourist[/url]":47tna2mt]From the original article there were a lot of people commenting to ask why the Steam API wasn't used. Any more information on this?
[url=http://meincmagazine.com/civis/viewtopic.php?p=26668263#p26668263:300kfpab said:Astramancer[/url]":300kfpab][url=http://meincmagazine.com/civis/viewtopic.php?p=26666715#p26666715:300kfpab said:Kyle Orland[/url]":300kfpab][url=http://meincmagazine.com/civis/viewtopic.php?p=26666651#p26666651:300kfpab said:Archangel Mychael[/url]":300kfpab]I'd like to see some Linux data to see how well it's doing.
I'd love that too, but SteamCommunity doesn't break out which platform version of a game a person is or isn't playing...
Are there any linux-only games? It wouldn't be a totally accurate picture of who's playing on linux, but if they have linux-only games, you at least have a minimum number. Maybe if someone has a high percentage of crossplatform games and a linux-only game?
[url=http://meincmagazine.com/civis/viewtopic.php?p=26666929#p26666929:1sml2fli said:Sufinsil[/url]":1sml2fli]Any thoughts on separating F2P games from each analysis?
Did not see it addressed in this follow up: How did you treat games with multiple App IDs? Examples: Civ IV, Betas for multiple games.
Civ IV
http://steamdb.info/app/8800/
http://steamdb.info/app/34460/
Betas:
http://steamdb.info/app/223530/
http://steamdb.info/app/219540/
Not sure how I got opted into the Betas to show up, but they certainly would count as a registered unplayed game by default.
[url=http://meincmagazine.com/civis/viewtopic.php?p=26666233#p26666233 said:Bleeprz"I'm on IE11 on WP8.1.
[url=http://meincmagazine.com/civis/viewtopic.php?p=26666187#p26666187:3dmub0t9 said:Schwanz[/url]":3dmub0t9]The DOTA2 being super popular thing baffles me. I ran it up a couple of times, and I can't even figure out WTF is going on in that game. If I could delete it from my steam account, I would.
Apparently the Director's Cut version of DE:HR made some questionable aesthetic changes and added more serious bugs than it fixed. And apparently Eidos has no intention of putting any more work into fixes.[url=http://meincmagazine.com/civis/viewtopic.php?p=26666297#p26666297:20usr3ur said:star skies[/url]":20usr3ur]Wow, Deus Ex: Human Revolution isn't even on there? Not even a million players through Steam? I'm finding it hard to believe that FTL: Faster Than Light did so much better, as much as I love that space sim.
It would be interesting to see a revenue chart (although probably not possible) rather than sales. If you are an indie with 2 staff then 10000 sales seems a lot until you realise that Steam is so very price sensitive that they might mostly be at $5 or $10 a pop, at which point a year's work isn't all that much of a payday at all, after Steam takes their cut...[url=http://meincmagazine.com/civis/viewtopic.php?p=26670311#p26670311:2ec6wrly said:Machtyn[/url]":2ec6wrly]My $0.02
0.01 - That's interesting, the top 200 games have had 1,000,000 or more sales. It's still difficult to see, but I'm supposing the top 50 or top 20 games have had over 9,000,000 sales. However, if you're in the top 80% of sales, you are almost guaranteed 10,000 sales. And if you're an indie company of 1 or 2 people, that makes for a great payday (depending on how much time you put into it.) Of course, these simple numbers don't equate to the realities of game dev and what it takes to create even a top 80% game. (See that bottom 10%?)
0.02 - I'm disappointed to see Portal 2 did not do as well as Portal. Granted, Portal was an add-on with the Orange Box bundle when first released. I purchased the Orange Box specifically for TF2 and was VERY pleasantly surprised with Portal. Portal 2, while not as innovative a single player game as Portal, did add some nice innovation to the multiplayer. Also, Portal 2's story is much better and more in depth than the first. (Both situations, Portal being more innovative and Portal 2 having better story, are natural progressions for a game.)
0.03 ooh, you get an extra penny! Speaking of Valve bundles, I know I have at least 2 copies of the entire Valve library since the last Valve bundle released with Half-Life 2: Ep2. Yes, that was quite a bit of time ago. But that should also clue one in as to how often I purchase Valve Software packed bundles any more. I generally pick a few games or less a year and enjoy them for quite a long time. (Skyrim currently, I still need to finish Fallout: New Vegas, get my money's worth out of Civ5 which seems broken for me, and put more time into the Battlefield game (WW2 flight sim) and RIFT, a free-to-play MMO that is a really good alternative to WoW.)
[url=http://meincmagazine.com/civis/viewtopic.php?p=26668125#p26668125:2pcsnqpb said:vartec[/url]":2pcsnqpb][url=http://meincmagazine.com/civis/viewtopic.php?p=26668101#p26668101:2pcsnqpb said:Pantagruel[/url]":2pcsnqpb]I personally think the "games bought but never played" data from the other article is one of the most important take outs of all this. It seems Steam Sales create an opportunity for titles to generate revenue from audiences they don't even actually appeal to. I really can't decide if this is good or bad.
Well, there are games that I bought but haven't time to play, but that's not very typical. Actually I think most of owned-not-played come from bundles. I've bought quite a few bundles of 6-8 games just to play 2-3 of them.
Would've made it easier for you actually.[url=http://meincmagazine.com/civis/viewtopic.php?p=26669217#p26669217:4d0wealv said:Kyle Orland[/url]":4d0wealv]I'm a bit of a hack programmer?[url=http://meincmagazine.com/civis/viewtopic.php?p=26669105#p26669105:4d0wealv said:robotic_tourist[/url]":4d0wealv]From the original article there were a lot of people commenting to ask why the Steam API wasn't used. Any more information on this?
Seriously, when I started on this, I wasn't even aware that this info was available via API, in addition to the web site. By the time I found out about it it seemed relatively pointless to start over and change everything up... the data is the same either way, right?
from __future__ import division
from __future__ import absolute_import
from __future__ import print_function
from __future__ import unicode_literals
from collections import namedtuple
import urllib2
import urllib
from contextlib import closing
import json
UserData = namedtuple('UserData', 'steamid games')
GameData = namedtuple('GameData', 'appid name playtime')
# get from http://steamcommunity.com/dev/apikey
key = get_key_from http://steamcommunity.com/dev/apikey
def get_data(interface, method, version, **additional_params):
url = 'http://api.steampowered.com/{}/{}/v{:04d}/?'.format(interface, method, version)
params = {
'format': 'json',
'key': key
}
params.update(additional_params)
url = url + urllib.urlencode(params)
try:
with closing(urllib2.urlopen(url)) as stream:
return stream.read()
except urllib2.HTTPError:
raise Exception("Invalid steamid.")
def get_owned_games(steamid):
data = get_data('IPlayerService', 'GetOwnedGames', 1, steamid=steamid, include_appinfo='1', include_played_free_games='1')
parsed = json.loads(data)
games = [GameData(game['appid'], game['name'], game['playtime_forever']) for game in parsed['response']['games']]
return UserData(steamid, games)
# random person for demonstration purposes
print(get_owned_games('76561197960435530'))
[url=http://meincmagazine.com/civis/viewtopic.php?p=26669365#p26669365:34vvxv9p said:Sufinsil[/url]":34vvxv9p]You must not have hit my profile.
Civ 4 + expansions is the only game I have that has 2 app ids for the same exact name. I think I got a 2nd appid from the Humble Bundle? I forget when it happened.
Company of Heroes has the standard and Steam matchmaking version listed. But all Steam owners got the new version.
Ah, that could be the case for the beta. I have not played recently any TF2, L4D2, and the few other games I have a beta version for, which show up on my Community page. Rare enough to not really effect the data really.
[url=http://meincmagazine.com/civis/viewtopic.php?p=26670311#p26670311:1y75qqtd said:Machtyn[/url]":1y75qqtd]
0.02 - I'm disappointed to see Portal 2 did not do as well as Portal. Granted, Portal was an add-on with the Orange Box bundle when first released. I purchased the Orange Box specifically for TF2 and was VERY pleasantly surprised with Portal. Portal 2, while not as innovative a single player game as Portal, did add some nice innovation to the multiplayer. Also, Portal 2's story is much better and more in depth than the first. (Both situations, Portal being more innovative and Portal 2 having better story, are natural progressions for a game.)
This kind of sampling and extrapolating doesn't lend itself well to finding outliers in the full data set, so even if they did post the "most" hours played, there'd be no way to know if it was even close to accurate. Basically, without checking everyone's play time for a game, how will you know one of the ones you haven't checked yet doesn't beat your current highest value by orders of magnitude?[url=http://meincmagazine.com/civis/viewtopic.php?p=26666527#p26666527:1e604kvf said:pqr[/url]":1e604kvf]By the way, small request. Could you post most hours played for those top 100 games? Would tell us how devoted/addicted/loving we are compared to most devoted/addicted/loving person for each game.
TF2 wasn't free to play though - I bought it on release way back when. And it was sold as part of the orange box (among others?) which would make me expect there to be a fair few people that owned it before it was F2P that never played it. That might have been before 2009 and not part of the stats though, I'm not sure.[url=http://meincmagazine.com/civis/viewtopic.php?p=26668061#p26668061:1e604kvf said:vartec[/url]":1e604kvf][url=http://meincmagazine.com/civis/viewtopic.php?p=26668025#p26668025:1e604kvf said:AstroGrover[/url]":1e604kvf]What's with the ones where 100% of all owners have played it? You can't tell me there's not a single person that hasn't played their copy of TF2.
The ones that have 100% are F2P, so I guess Steam only counts people who actually play them.