The Hotness
Games|People|Company
Dominion: Dark Ages
Fantastiqa
Mage Knight: Board Game
Total War
Descent: Journeys in the Dark (Second Edition)
Eclipse
Mice and Mystics
Dungeon Fighter
Collapsible D: The Final Minutes of the Titanic
Lords of Waterdeep
Agricola: All Creatures Big and Small
Libertalia
Android: Netrunner
Virgin Queen
The Lord of the Rings: Nazgul
A Game of Thrones: The Board Game (Second Edition)
Dominion
Star Wars: X-Wing Miniatures Game
Infiltration
The Lord of the Rings: The Card Game
Among the Stars
Twilight Struggle
The Swarm
Agricola
1989: Dawn of Freedom
Goa
7 Wonders
Glory to Rome
Arkham Horror
Village
Ora et Labora
Battles of Westeros: House Baratheon Army Expansion
Through the Ages: A Story of Civilization
Thunder Road
Trajan
Zombicide
The Castles of Burgundy
7 Wonders: Cities
Ace of Spies
War of the Ring
Skyline
Space Alert
Sherlock Holmes Consulting Detective
City of Horror
Race for the Galaxy
Dungeon Command: Sting of Lolth
Twilight Imperium (third edition)
Kingdom Builder
Le Havre
Battlestar Galactica

playing and designing board games

Gaming blog about board games and board game design. Includes reviews and session reports, strategies and variants, thoughts on games in development, tips for hosting game nights, etc.
Recommend
90 
 Thumb up
2.30
 tip
 Thumb up

fun with BGG URLs, part I (AKA the games we actually play)

Dave Ross
United States
Ames
Iowa
designer
Avatar
mbmbmbmbmb
Note: this content has also been posted on my blog, playing and designing board games.


Okay, so I was having a bit of fun on BGG today, trying to figure out how to get at some of all their awesome data. I mean, yes, you can pretty easily sort by rank, or the number of voters, etc., but did you know you can sort by number of owners? Or by number of people who have the game on their wishlist? By the number of people who want a game in trade?

Anyway, I got to playing around a bit with their stats, specifically the number of plays each game has. And I found something interesting: ignoring the number of plays (since this data can be easily corrupted), you can sort by the number of unique users who played the game. Here’s a link that lists all the games in their database, sorted by the number of unique users who have played the game: http://www.boardgamegeek.com/plays/bygame?sortby=distinctuse.... Pretty cool, huh? Who knew that Carcassonne would have the most unique players, followed by Dominion, Agricola, Puerto Rico, and The Settlers of Catan?

Here’s where it gets really interesting, though: you can limit the time-frame you’re looking at, so you get just the number of unique users who played the game, say, in the year 2000.

You can tell where I’m going with this, can’t you?

First, a link or two: if you want to see how many unique users played Settlers of Catan in, say, 2000, just click here. And you can obviously do a little url hacking to change the year from 2000 to 2001 (that’s easier than picking a new range of dates with their chooser and then choosing to sort by number of unique users, though you can do it that way, too).

And you can go through and do this for 2000, 2001, 2002, all the way up to 2010. What do you get when you do all that?

You get a bunch of web pages, that’s what. But if you look at the top ten games of each year, some interesting trends emerge. And if you look at every game that hits the top ten in that period (there are 34), tracking it until it no longer cracks the top 100, you get a rather interesting little graph. But one that’s very hard to read:



A couple things to note: first, each game is just stacked on top of the next. Second, this looks an awfully lot like exponential growth, at least up until 2010. This might represent the growth of the hobby, but more likely it’s just the growth in BGG users / users who record their plays. Third, I’m not sure why things tail off for 2010 — probably it’s just that fewer players recorded their plays that year (for whatever reason).

Playing with it a little, you can “normalize” the graph by converting all the numbers to percents. Here all that dramatic growth goes away, replaced by an easier-to-read graph where each game gets a slice of 100%:



A caveat: of course there are a number of ways this data might be skewed. First, as stated above, the number of users on BGG has been increasing, changing the nature (and the preferences) of the BGG population. Second, not all users record their plays. Third, there are an unknown but possibly large number of shill accounts. And so on.

Still, I think this is fairly interesting. It gives a pretty good idea as to what the big (popular) names in gaming are, and it does so in an easy-to-read way.

I’d upload the spreadsheet I made so other people can play with the data, too, but Wordpress appears to be unwilling to allow me to post an ODS file. ODT, yes, but not ODS. Anyway, I can post an ODT file with a table if folks are interested. Just let me know.

Edited: title, wording of caveat.
Twitter Facebook
16 Comments
Subscribe sub options Fri Jun 3, 2011 4:09 am
Post Comment
Justin
United States
Creve Coeur
MO
Avatar
mbmbmbmbmb
Fascinating, thanks!
1 
 Thumb up
 tip
 Thumb up
  • Posted Fri Jun 3, 2011 4:15 am
    • Choose your Dice
      • Roll
      • Comment (Optional)
    • Reply
    •  
    • Quote
Randy Cox
United States
Clemson
South Carolina
designer
1024x768 works just fine - Don't Wide the Site!
badge
The Back Alley gets no respect.
Avatar
mbmbmbmbmb
I don't know what ODS and ODT formats are, but these are nifty graphs.

Question: after you took games with the most unique players (the only way to go), did you then revert to number of recorded plays for each of those games? It appears that you did, as you have numbers in the first chart like 70000, and there aren't 70000 unique users of each game.

I ask because so many games have ridiculous entries, like one person who plays Magic the Gathering 1,000,000 times or another user who played something 2.14 billion times. And there are "lesser" shills happening with a couple of thousand reported plays. Long story short: you really need to use only unique players and calculate the percentages (normalization) based on that, lest you get one game that shows up higher than it should because of a half-dozen people who insist on logging all the sessions they "think" they played in the past all on the same data in the middle of 2002, for instance.

Speaking of which, I'm amazed that there's enough data to work with before 2003, when game logging began on BGG (and then you could log only one play per day, until around December). I suspect that some people used (often faulty) memory to fill in the blanks for their past gaming and picked a date around 2000 or so to enter them.

Nonetheless, it's very interesting. I wonder if you get that tail-off for 2010 if you eliminate total sessions and go with unique players.
3 
 Thumb up
 tip
 Thumb up
  • Posted Fri Jun 3, 2011 4:19 am
    • Choose your Dice
      • Roll
      • Comment (Optional)
    • Reply
    •  
    • Quote
Chris Berger
United States
Volo
Illinois
Avatar
mbmbmbmbmb
Randy Cox wrote:
Question: after you took games with the most unique players (the only way to go), did you then revert to number of recorded plays for each of those games? It appears that you did, as you have numbers in the first chart like 70000, and there aren't 70000 unique users of each game.


That 70000 is misleading because it's the sum total of unique users for each of the top 34(?) games. That is, each user can be counted up to 34(?) times. The largest band is the green one, which I believe is Dominion (ugh), at what looks like around 8000 unique players.

Oh, also, ODS and ODT formats are those used by Open Office. Open formats, rather than proprietary ones like .xls. It seems ironic to me, although tangential to this topic, that Open Office can read proprietary formats like .xls and .xlsx (better than old versions of Excel can), but MS Office can't read open formats like .ods and .odt...
1 
 Thumb up
 tip
 Thumb up
  • Edited Fri Jun 3, 2011 4:27 am
  • Posted Fri Jun 3, 2011 4:25 am
    • Choose your Dice
      • Roll
      • Comment (Optional)
    • Reply
    •  
    • Quote
Adam Lucas
Canada
Belleville
Ontario
Avatar
mbmbmbmbmb
I'm wondering what happened in 2003. Before then lots of mainstream boardgames were listed as the best games or in the top 100 games. After that they've all disappeared. Elitism became rampant when ranking board games? The division of User Rankings and Geek Rankings? A recoding of BGG that made ranking things easier?
Also it looks like the top 100 games don't really change a lot. Once something is top 10, it seems to share top 100 for a long time.
Still, that's a pretty neat way to look at games and popularity.

EDIT: And. . . my question gets answered while I'm typing it.
1 
 Thumb up
 tip
 Thumb up
  • Edited Fri Jun 3, 2011 4:35 am
  • Posted Fri Jun 3, 2011 4:25 am
    • Choose your Dice
      • Roll
      • Comment (Optional)
    • Reply
    •  
    • Quote
Dave Ross
United States
Ames
Iowa
designer
Avatar
mbmbmbmbmb
Randy Cox wrote:
I don't know what ODS and ODT formats are, but these are nifty graphs.

Question: after you took games with the most unique players (the only way to go), did you then revert to number of recorded plays for each of those games? It appears that you did, as you have numbers in the first chart like 70000, and there aren't 70000 unique users of each game.

I ask because so many games have ridiculous entries, like one person who plays Magic the Gathering 1,000,000 times or another user who played something 2.14 billion times. And there are "lesser" shills happening with a couple of thousand reported plays. Long story short: you really need to use only unique players and calculate the percentages (normalization) based on that, lest you get one game that shows up higher than it should because of a half-dozen people who insist on logging all the sessions they "think" they played in the past all on the same data in the middle of 2002, for instance.

Speaking of which, I'm amazed that there's enough data to work with before 2003, when game logging began on BGG (and then you could log only one play per day, until around December). I suspect that some people used (often faulty) memory to fill in the blanks for their past gaming and picked a date around 2000 or so to enter them.

Nonetheless, it's very interesting. I wonder if you get that tail-off for 2010 if you eliminate total sessions and go with unique players.


ODS and ODT are the Open Office Spreadsheet and Word Processing formats, respectively.

No, I didn't revert back to the number of plays, I just added all the numbers of users together. So if Carcassonne had 3300 and Settlers had 3000 and TtR had 2600 (roughly the 2008 numbers), then the graph just stacked those numbers on top of one another: 8900. That's why the numbers get so big.

And yes, it would be nice if we could clean up the shill votes for number of plays, but hey -- I was just working with what we have.

I was wondering about the validity of the data for 2000 and 2001 especially, as the numbers were fairly close -- it had the feel of numbers that were made up after the fact. Had I known that game logging began in 2003, I wouldn't have included the earlier data (though it is interesting to note that the most-played game through 2002 was, of all things, Risk). surprise

I don't know what explains the tail-off, but I suspect it's just that fewer players are recording their plays. That feels a little counter-intuitive to me, but maybe one of the admins could back it up (or offer a better explanation).
2 
 Thumb up
 tip
 Thumb up
  • Posted Fri Jun 3, 2011 4:31 am
    • Choose your Dice
      • Roll
      • Comment (Optional)
    • Reply
    •  
    • Quote
Dave Ross
United States
Ames
Iowa
designer
Avatar
mbmbmbmbmb
Svengaard wrote:
I'm wondering what happened in 2003. Before then lots of mainstream boardgames were listed as the best games or in the top 100 games. After that they've all disappeared. Elitism became rampant when ranking board games? The division of User Rankings and Geek Rankings? A recoding of BGG that made ranking things easier?
Also it looks like the top 100 games don't really change a lot. Once something is top 10, it seems to share top 100 for a long time.
Still, that's a pretty neat way to look at games and popularity.

I think Randy partially answered this one -- BGG didn't allow users to record plays prior to 2003. But I think the culture here on BGG must have been changing fairly rapidly around that time, too.

And note that these aren't rankings, these are the number of unique users recording one or more plays of the game in that year. It's a measure of what actually makes it to the table, and is, roughly speaking, an indicator of popularity.

It was interesting (though not surprising) to see how Settlers has been so constant. I also thought Attika was interesting: hits the top ten in 2003 and drops out of the top 100 in 2008. Looking at the actual data, though, the number of unique players kept going up (420, 468, 642, 727) -- it's just that other games were outpacing it, and so it fell off the bottom. Kind of like Texas Hold 'Em: if you're not winning fast enough, you're losing.

Edit: changed wording of first paragraph.
3 
 Thumb up
 tip
 Thumb up
  • Edited Fri Jun 3, 2011 4:45 am
  • Posted Fri Jun 3, 2011 4:40 am
    • Choose your Dice
      • Roll
      • Comment (Optional)
    • Reply
    •  
    • Quote
Jeremiah Lee
United States
Ypsilanti
Michigan
flag msg tools
designer
publisher
Avatar
mbmbmbmbmb
Glorious!
2 
 Thumb up
 tip
 Thumb up
  • Posted Fri Jun 3, 2011 5:16 am
    • Choose your Dice
      • Roll
      • Comment (Optional)
    • Reply
    •  
    • Quote
Kevin B. Smith
United States
Margate
Florida
designer
Avatar
mbmbmbmbmb
ddgdrs wrote:
I don't know what explains the tail-off, but I suspect it's just that fewer players are recording their plays. That feels a little counter-intuitive to me, but maybe one of the admins could back it up (or offer a better explanation).

Another possible explanation is that in 2010, BGG users focused their attention on non-top-100 games. I have no idea why it would have happened so suddenly and dramatically, but that is true for the "fewer players recording plays" theory too. It' a good mystery.
2 
 Thumb up
 tip
 Thumb up
  • Posted Fri Jun 3, 2011 5:22 am
    • Choose your Dice
      • Roll
      • Comment (Optional)
    • Reply
    •  
    • Quote
Dave Ross
United States
Ames
Iowa
designer
Avatar
mbmbmbmbmb
There are a couple games I want to try now just based on their appearance on this list: El Grande and Saint Petersburg. If I have time, it'd be fun to do something similar on a slightly larger scale: the top 15, or maybe the top 20. This would pick up T&E, Goa, Princes of Florence, etc. It'd be fun to see how they'd fare.
2 
 Thumb up
 tip
 Thumb up
  • Posted Fri Jun 3, 2011 5:49 am
    • Choose your Dice
      • Roll
      • Comment (Optional)
    • Reply
    •  
    • Quote
Dominic Crapuchettes
United States
Bethesda
MD
designer
publisher
This overtext is brought to you by the abstract strategy game Battle of LITS and the number 20.
badge
Avatar
mbmbmbmbmb
ddgdrs wrote:
If I have time, it'd be fun to do something similar on a slightly larger scale: the top 15, or maybe the top 20. This would pick up T&E, Goa, Princes of Florence, etc. It'd be fun to see how they'd fare.


Yes! Please do!! This is awesome. thumbsup thumbsup
3 
 Thumb up
 tip
 Thumb up
  • Edited Fri Jun 3, 2011 3:30 pm
  • Posted Fri Jun 3, 2011 3:30 pm
    • Choose your Dice
      • Roll
      • Comment (Optional)
    • Reply
    •  
    • Quote
United States
Danbury
Connecticut
Avatar
mbmbmbmbmb
So is this saying that Risk, Monopoly, Clue, et al were one time Top 10 games on BGG? That's the only way they'd make it into the data to begin with, right?

EDIT: or when you say 'top 10' you mean top 10 in unique users playing, not top 10 in the ratings/rankings, right?
2 
 Thumb up
 tip
 Thumb up
  • Edited Fri Jun 3, 2011 5:18 pm
  • Posted Fri Jun 3, 2011 5:17 pm
    • Choose your Dice
      • Roll
      • Comment (Optional)
    • Reply
    •  
    • Quote
dale yu
United States
Cincinnati
Ohio
flag msg tools
admin
designer
If you're not part of the soultion...
badge
You're part of the precipitate!
Avatar
mbmbmbmbmb
domcrap wrote:
ddgdrs wrote:
If I have time, it'd be fun to do something similar on a slightly larger scale: the top 15, or maybe the top 20. This would pick up T&E, Goa, Princes of Florence, etc. It'd be fun to see how they'd fare.


Yes! Please do!! This is awesome. thumbsup thumbsup


Actually, Dominic would like you to go down to #231, but he's too shy to ask.

D
3 
 Thumb up
 tip
 Thumb up
  • Posted Fri Jun 3, 2011 8:11 pm
    • Choose your Dice
      • Roll
      • Comment (Optional)
    • Reply
    •  
    • Quote
László K.
United States
Hopatcong
New Jersey
designer
Avatar
mbmbmbmbmb
Here is a slightly different take on the most played games graph idea. What we see here are the most played games (by unique users) for a specific year irrespective of what the games' current ranks were for that year. This visualizes what the most played games are for a specific year.


Caption: Top 10 Most Played Games (by Unique Users) by Year (2003-2010)
11 
 Thumb up
0.06
 tip
 Thumb up
  • Posted Fri Jun 3, 2011 8:49 pm
    • Choose your Dice
      • Roll
      • Comment (Optional)
    • Reply
    •  
    • Quote
Dave Ross
United States
Ames
Iowa
designer
Avatar
mbmbmbmbmb
cannoneer wrote:
So is this saying that Risk, Monopoly, Clue, et al were one time Top 10 games on BGG? That's the only way they'd make it into the data to begin with, right?

EDIT: or when you say 'top 10' you mean top 10 in unique users playing, not top 10 in the ratings/rankings, right?

Top 10 in unique users playing.
1 
 Thumb up
 tip
 Thumb up
  • Posted Fri Jun 3, 2011 9:09 pm
    • Choose your Dice
      • Roll
      • Comment (Optional)
    • Reply
    •  
    • Quote
Dave Ross
United States
Ames
Iowa
designer
Avatar
mbmbmbmbmb
Ladislaus wrote:
Here is a slightly different take on the most played games graph idea. What we see here are the most played games (by unique users) for a specific year irrespective of what the games' current ranks were for that year. This visualizes what the most played games are for a specific year.


Caption: Top 10 Most Played Games (by Unique Users) by Year (2003-2010)

This is the way I decided to go with the "top twenty" data (as opposed to the "top ten" data) I used in part II. Waiting for games to drop out of the top 100 made the graph too linear and boring.
1 
 Thumb up
 tip
 Thumb up
  • Posted Sat Jun 4, 2011 5:09 pm
    • Choose your Dice
      • Roll
      • Comment (Optional)
    • Reply
    •  
    • Quote
C W


New York
msg tools
Very informative! Guess I'd better start logging my plays.

Also interesting that we don't seem to have any large uphill swings towards the current. A more steady incline due to user numbers? Or well established games? both I suppose.
 
 Thumb up
 tip
 Thumb up
  • Posted Mon Jun 6, 2011 8:27 pm
    • Choose your Dice
      • Roll
      • Comment (Optional)
    • Reply
    •  
    • Quote

Subscribe

Categories

Contributors

Front Page | Welcome | Contact | Privacy Policy | Terms of Service | Advertise | Support BGG | Feeds RSS
Geekdo, BoardGameGeek, the Geekdo logo, and the BoardGameGeek logo are trademarks of BoardGameGeek, LLC.