Wikipedia talk:WikiProject Video games/Traffic statistics

WikiProject iconVideo games Project‑class
WikiProject iconThis page is within the scope of WikiProject Video games, a collaborative effort to improve the coverage of video games on Wikipedia. If you would like to participate, please visit the project page, where you can join the discussion and see a list of open tasks.
ProjectThis page does not require a rating on the project's quality scale.
Summary of Video games WikiProject open tasks:

Template for future months edit

views views views views views views views views views views views views views views views views views views views views views

Stats spreadsheet edit

In case anyone is interested, the spreadsheet (use OpenOffice.org) used to create the charts can be found here. JACOPLANE • 2008-04-3 18:31

Kind of skimpy edit

The current table isn't terribly informative. Is there any way we can get a breakdown of such things as the number of page views by article quality or importance? The top 100 articles by page views? SharkD (talk) 05:07, 24 January 2009 (UTC)Reply

Other ideas edit

Some other ideas would be to a) create a bot to automatically update the table (since it seems to be dead), b) use a logarithmic scale and combine all the graphs into a single image, and c) put the image on the main project page next to the quality/importance table. The table should also be transposed so that new entries get added to the bottom instead of to the right. SharkD (talk) 05:26, 24 January 2009 (UTC)Reply

I've requested that a bot be created to update the tables. Hopefully the 8 month backlog of missing data will get filled when this happens. SharkD (talk) 22:19, 26 January 2009 (UTC)Reply
I'll add traffic stats for the other, related Wikiprojects as well. SharkD (talk) 21:53, 27 January 2009 (UTC)Reply
There's also some other pages that were missed and are listed here. SharkD (talk) 22:13, 27 January 2009 (UTC)Reply

I've added data for the remaining task forces as well as our sister WikiProjects. It would be nice to have data for the task forces that used to be WikiProjects from before they were transitioned. SharkD (talk) 03:02, 28 January 2009 (UTC)Reply

Done. SharkD (talk) 04:17, 28 January 2009 (UTC)Reply

Different chart format edit

I've been experimenting with different charts and came up with this one. I was wondering whether it is easier to understand. You get somewhat of an indication of how the volume of activity has changed over time, which is lacking in the current charts. At the same time, you still can see the proportion of activity associated with each page like you can in the current charts. This is better than a simple line graph, IMO, because there are so many lines that you wouldn't be able to make each of them out individually. Also, the big "dip" in the middle is due to a gap in the source data for most of a month. They could be "ironed out" by using an average for only those days that were recorded instead of the entire month (which is something I should do anyway since teh different numbers of days in each month aren't being considered). SharkD (talk) 07:03, 28 January 2009 (UTC)Reply

I updated the test image. The "dip" and other gaps in the data are no longer visible. SharkD (talk) 09:55, 28 January 2009 (UTC)Reply
I like the new chart better. It gives you more of an understanding at first glance.--ZXCVBNM [TALK] 20:16, 28 January 2009 (UTC)Reply
EDIT: Wait...I think I confused it for a regular line graph too. You'd better stick to the first one.--ZXCVBNM [TALK] 03:12, 29 January 2009 (UTC)Reply
I have a good question: Why not both? The left is better at indicating proportion of editsviews; the right is better at indicating volume of editsviews. --Izno (talk) 03:15, 29 January 2009 (UTC)Reply
Because the only difference between the two is the fact that the second one has the overall "mountainous" shape as opposed to being fully expanded to the top edge of the graph. In OpenOffice the first chart is called "Percent Stacked" and the second is called "Stacked". The "Stacked" chart also shows proportion: i.e. the thickness of each band corresponds with the proportion of views for that page. It's just bounded by the maxima (the white area). The problem with a regular "Line" graph, however, is that there are so many lines that it ends up just looking like a tangle of yarn. And, if you split the lines into separate graphs (as is done in the first three charts in the actual article), then you loose the ability to directly compare them and you also have to display/upload/maintain three times as many images. (I probably haven't explained things very well.) SharkD (talk) 03:48, 29 January 2009 (UTC)Reply
Second one because it clearly gives us an indication when things are slowing down...like right now.じんない 07:04, 30 January 2009 (UTC)Reply

Featured articles edit

I'm considering adding a section for our featured articles. There's over 100 of them, however, which might be too many. SharkD (talk) 22:09, 28 January 2009 (UTC)Reply

It might also be a good idea to list stats for Talk pages. SharkD (talk) 02:37, 30 January 2009 (UTC)Reply

Alternate imate format suggestions? edit

Does anyone have any suggestions for an alternate image format instead of PNG? OpenOffice screws up the text when exporting as SVG. It exports properly to EMF and WMF; however, Commons won't allow me to upload them, and I can't use Inkscape to export them as SVG because it also screws up the text. *sigh* SharkD (talk) 05:59, 10 June 2009 (UTC)Reply

Different set of data edit

I have another set of data where the task forces that were once WikiProjects are included in the WikiProject tables up until the time they were converted. Not sure whether this data is better to put in the article or not. (It makes the charts a lot more confusing to look at.) SharkD (talk) 06:01, 12 June 2009 (UTC)Reply

Table format edit

I think the horizontal listing of stats is a poor choice of table design, as it breaks every rule of database design, and means we have to omit dates before 2009 or risk extending the page beyond the browser borders. I suggest changing it back to the way it was before. SharkD  Talk  01:38, 9 July 2011 (UTC)Reply

The way it was was just as poor design from an HTML point. I think an overflow auto would fix the problem of extending the page beyond. Which is still a problem of accessibility, actually, but it's my preferred solution. That said, I think it's undesirable to list every page that's been deleted or is now a redirect, which is what would end up happening (the 0s would not just "fall off" the table). --Izno (talk) 04:09, 9 July 2011 (UTC)Reply
Of course, with that approach, we run the risk of not being able to see the top of the table while we go and scroll. We can set a vertical overflow as well, if I recall correctly; that just requires a min height. But double overflow is quite the big no-no. There must be a better way to do this. --Izno (talk) 04:51, 9 July 2011 (UTC)Reply
I don't see the problem with the current way. Do stats matter from more than 2 years ago? Even so, they can be retrieved from the history. Flipping it back has the same problem if pages are added to the project or task forces are created/deleted. MrKIA11 (talk) 14:21, 9 July 2011 (UTC)Reply
I would like to see data going back to when stats started being recorded in 2007. Truncating the data kind of defeats the point of this article, and you should focus instead on making the page accessible to people who are actually going to use the data. SharkD  Talk  06:30, 10 July 2011 (UTC)Reply
The point of the page isn't the people who want to use the data, else we'd have links to data files (excel and such)... which we don't. The image description pages are broke, and even then, that would be the improper place. From what I can tell, this page is simply to give users of the project an idea of traffic...
That said, you are welcome to make a personal subpage with the full data if you really must have it on wiki. But I think the easier method is to add links to the data in non-html form to this page rather than the image description pages. The people who want the data get it and the people who want the html get it; the former in a form which they can use, and the latter in a form which doesn't run into load problems (though I realize this table is small compared to many others I've seen). --Izno (talk) 14:33, 10 July 2011 (UTC)Reply
@Izno: What should I name the sub-page? Should it use a forward slash? SharkD  Talk  08:46, 13 December 2015 (UTC)Reply

I've tested again with vertical orientation. User:SharkD/Sandbox/Vertical_table_cell_text. It works pretty well and doesn't require SVG for the text. It's a lot more compact than my last attempt and easier to add data to. I can also turn the text 45 degrees instead of 90 degrees for extra readability with a little more work but haven't gotten around to it yet. SharkD  Talk  06:04, 11 December 2015 (UTC)Reply

Current data edit

I was thinking of gathering more data, but http://stats.grok.se/ is too much of a PITA to use. You can only view one month at a time, per article. It would be a lot more useful if you could specify a range of dates. SharkD  Talk  06:11, 11 December 2015 (UTC)Reply

There's a new PageView API; see phab:T44259#1747860 (I couldn't find a mediawikiwiki: page for it using Google...). It's only populated so far backward, but will be updated going forward, and I don't know what kind of data you're looking for... --Izno (talk) 12:23, 11 December 2015 (UTC)Reply
Just a little playing with a user-facing page at [1], I got [2], which is the pageviews for the set of days November 1 to November 30 for the main project page. --Izno (talk) 12:37, 11 December 2015 (UTC)Reply
Daily views are even less useful. :( Also, it doesn't go back very far in time. Hopefully they will update the tool. One thing to watch out for is that sometimes there are gaps in the data collected. For instance, in July 2008 data for only 11 days was collected, throwing the stats out of whack for that month. SharkD  Talk  18:44, 11 December 2015 (UTC)Reply
They're working on monthlies. However, this does give you a range to play with, so you can query from May 1 and then do the post-processing to rip out the month-counts. --Izno (talk) 19:10, 11 December 2015 (UTC)Reply
Stats.grok.se also offers JSON pages. http://stats.grok.se/json/en/200910/Wikipedia:WikiProject%20Video%20games/Traffic%20statistics. If I had raw data like this I could probably calculate the totals. I don't know how to write a tool to query a Web page though. On Linux I could probably use wget I suppose. SharkD  Talk  20:07, 11 December 2015 (UTC)Reply

I was able to fetch and process the JSON files from stats.grok.se successfully. But there is a problem. Take a look at these values for daily_views;

List of daily views for June 2008
  • "2008-06-01": 0,
  • "2008-06-02": 0,
  • "2008-06-03": 167,
  • "2008-06-04": 177,
  • "2008-06-05": 163,
  • "2008-06-06": 152,
  • "2008-06-07": 143,
  • "2008-06-08": 150,
  • "2008-06-09": 136,
  • "2008-06-10": 166,
  • "2008-06-11": 160,
  • "2008-06-12": 171,
  • "2008-06-13": 119,
  • "2008-06-14": 134,
  • "2008-06-15": 123,
  • "2008-06-16": 126,
  • "2008-06-17": 162,
  • "2008-06-18": 120,
  • "2008-06-19": 117,
  • "2008-06-20": 160
  • "2008-06-21": 153,
  • "2008-06-22": 147,
  • "2008-06-23": 134,
  • "2008-06-24": 156,
  • "2008-06-25": 152,
  • "2008-06-26": 150,
  • "2008-06-27": 152,
  • "2008-06-28": 162,
  • "2008-06-29": 108,
  • "2008-06-30": 133,
  • "2008-06-31": 217,

There are no page views for June 1 and 2, and there are 217 page views for June 31 even though there are only 30 days in June. This may not mess up the monthly totals much, but I am also calculating views per day. Oh well. SharkD  Talk  06:07, 14 December 2015 (UTC)Reply

I don't think I'd worry too much. Make a note of which days return 0 views and then move forward, IMO. You can post the days with 0 views later--I know there is at least one user who keeps a close track and who makes a bother at WP:VPT on a fairly-regular basis about it. --Izno (talk) 14:07, 14 December 2015 (UTC)Reply
Okay, I'm done. The raw data can now be found at Wikipedia:WikiProject Video games/Traffic statistics/Raw data. SharkD  Talk  06:36, 15 December 2015 (UTC)Reply
1. Might be nicer to formulate #N/A as 0. 2. I am surprised by the 6k views per day to Portal:Video games. Wonder if it's a false positive for Portal. --Izno (talk) 12:29, 15 December 2015 (UTC)Reply

Short data edit

short data
Days Counted,Date,Anime and manga,Dungeons & Dragons,Games,Halo,Machinima,Pinball,Pokémon,Role-playing games,Sega,Sports,Square Enix
31,13/12,1376,190,134,121,31,32,256,354,30,405,294
31,14/01,1425,202,158,151,24,30,313,232,26,541,267
31,14/02,1492,176,138,109,15,46,396,169,34,449,314
31,14/03,1898,248,200,227,19,67,582,196,49,524,523
31,14/04,1505,238,160,103,11,35,478,194,45,483,288
31,14/05,1559,267,198,113,14,133,542,212,53,494,316
31,14/06,1337,194,237,98,12,127,425,210,45,576,285
31,14/07,1599,218,217,81,13,103,469,231,36,536,359
31,14/08,1707,229,171,101,9,60,442,242,35,602,259
31,14/09,1523,334,183,111,9,74,464,252,27,619,272
31,14/10,1755,345,249,142,22,89,511,256,48,600,258
31,14/11,10239,310,236,193,33,104,493,243,64,772,274
31,14/12,1574,313,216,138,32,87,508,215,76,600,298
31,15/01,1830,336,219,171,35,108,496,200,78,514,305
31,15/02,1349,272,186,144,28,76,510,208,79,435,225
31,15/03,2007,367,523,187,40,78,628,233,98,579,281
31,15/04,1960,337,265,198,27,95,655,225,104,620,336
31,15/05,1798,405,336,218,12,138,711,185,66,654,253
31,15/06,1335,227,211,128,16,87,549,244,67,582,261
31,15/07,1271,186,178,75,27,78,414,272,40,465,261
31,15/08,1636,214,168,89,19,88,404,216,51,392,215
30,15/09,1436,171,149,147,34,81,347,202,66,392,193
30,15/10,1735,203,165,121,28,101,350,187,50,507,193
30,15/11,1404,205,228,131,31,97,380,222,51,750,239

Days Counted,Date,Adventure games,Arcade,Atari,Atlus,Bethesda,BioWare,Blizzard,Call of Duty,Castlevania,Command & Conquer,Devil May Cry,D&D,eSports,Gears of War,id Software,Indie,Insomniac,Mega Man,Mortal Kombat,MUD,Nintendo,PlayStation,Retro games,Rockstar,Sega,Silent Hill,The Sims,Soul,StarCraft,Strategy,Ultima,Valve,Visual novels,Warcraft,Xbox
31,13/12,75,44,73,47,30,48,-,75,53,53,70,77,89,42,55,78,43,48,45,71,153,199,45,62,140,54,42,25,35,29,14,64,66,120,139
31,14/01,60,50,84,43,38,38,-,65,38,36,68,99,71,38,52,88,49,39,44,137,178,224,36,61,109,55,52,29,58,36,21,113,71,106,110
31,14/02,64,36,73,35,36,36,-,60,38,44,53,74,86,44,63,84,51,52,69,377,212,248,45,67,164,36,56,31,36,20,15,342,92,82,120
31,14/03,102,76,91,75,61,74,-,147,173,60,225,101,129,69,92,110,73,80,70,249,241,368,65,90,216,251,70,73,73,46,33,142,309,141,191
31,14/04,57,50,53,52,43,43,-,241,47,40,48,73,77,46,47,59,40,51,65,206,215,390,47,73,213,62,58,33,52,34,13,78,63,94,103
31,14/05,125,55,70,54,34,50,11,176,46,54,42,86,98,36,64,108,43,54,45,210,202,338,36,25,166,42,55,33,59,35,13,67,89,125,134
31,14/06,141,63,70,49,34,44,10,137,34,33,49,71,74,36,44,93,49,35,61,110,210,331,32,22,125,44,45,41,52,39,23,63,81,97,133
31,14/07,158,38,101,95,41,51,56,169,56,37,66,70,339,43,66,93,-,44,66,224,237,362,52,36,128,64,55,40,-,22,22,90,97,-,123
31,14/08,87,68,73,38,42,60,56,223,45,34,49,74,93,41,59,130,-,64,72,158,221,307,61,41,137,42,47,37,-,26,15,68,114,-,141
31,14/09,59,66,59,43,52,51,77,115,40,38,57,104,87,35,68,121,-,56,124,114,237,334,41,29,146,48,41,35,-,28,11,61,103,-,148
31,14/10,68,74,40,32,31,30,62,66,40,27,33,55,81,43,24,134,-,32,54,137,193,243,21,34,90,37,39,17,-,34,11,56,82,-,91
31,14/11,62,67,45,32,27,53,76,125,56,36,40,82,52,25,49,105,-,41,59,116,213,255,48,39,151,39,39,25,-,44,13,59,66,-,174
31,14/12,63,31,51,36,59,51,75,81,43,34,45,48,62,31,42,80,-,22,35,112,200,236,28,30,143,52,40,26,-,49,10,59,77,-,111
31,15/01,347,352,354,309,347,346,137,397,356,119,95,340,176,338,301,404,-,178,357,333,225,304,177,50,387,95,97,334,-,49,15,117,374,-,340
31,15/02,82,57,54,37,48,50,63,92,67,51,49,65,100,57,36,68,-,38,53,93,202,258,57,45,140,51,48,47,-,32,16,85,84,-,164
31,15/03,109,62,78,58,65,82,79,108,70,47,79,93,95,61,75,104,-,55,87,90,274,314,66,56,151,68,69,52,-,44,13,91,119,-,141
31,15/04,76,51,69,44,65,54,122,114,54,46,58,65,203,37,63,96,-,43,91,96,276,342,74,46,137,46,42,34,-,43,19,106,95,-,143
31,15/05,80,82,66,55,54,57,176,120,-,49,72,78,216,46,77,102,-,91,95,97,292,342,59,64,179,58,56,42,-,40,12,111,115,-,167
31,15/06,70,-,66,-,-,-,83,-,-,-,-,-,156,34,39,75,-,-,-,88,251,258,-,63,142,-,-,-,-,32,-,106,82,-,129
31,15/07,-,-,-,-,-,-,98,-,-,-,-,-,116,-,-,87,-,-,-,-,209,-,-,70,132,-,-,-,-,-,-,96,113,-,-
31,15/08,-,-,-,-,-,-,81,-,-,-,-,-,2234,-,-,78,-,-,-,-,237,-,-,72,111,-,-,-,-,-,-,95,95,-,-
30,15/09,-,-,-,-,-,-,117,-,-,-,-,-,159,-,-,76,-,-,-,-,240,-,-,75,129,-,-,-,-,-,-,103,111,-,-
30,15/10,-,-,-,-,-,-,120,-,-,-,-,-,144,-,-,92,-,-,-,-,256,-,-,57,144,-,-,-,-,-,-,96,104,-,-
30,15/11,-,-,-,-,-,-,152,-,-,-,-,-,181,-,-,124,-,-,-,-,296,-,-,68,152,-,-,-,-,-,-,144,128,-,-

Days Counted,Date,Main page,Talk page,Article guidelines,Naming conventions,Templates,Sources,Assessment,Assessment requests,Collaboration,Reference library,Print archive,Newsletter,Current issue,Article alerts,Pages for deletion,New pages,Article requests,Essential articles,Popular articles,Featured content,Good content,Recognized content,Project portal,Project category,Inactive project cleanup,Traffic statistics,Article statistics,Member category,Wikipedia 0.7 workshop
31,13/12,1539,2849,677,101,109,385,443,210,129,197,85,264,35,342,519,251,367,102,67,248,193,70,7001,96,66,53,48,73,24
31,14/01,1984,2710,570,140,109,511,468,265,-,145,81,231,62,333,424,290,323,108,139,240,486,88,7981,145,61,49,50,77,27
31,14/02,1826,4032,606,174,99,386,505,303,-,97,93,297,54,346,368,997,513,94,98,265,280,119,7845,78,68,59,54,60,19
31,14/03,2347,5558,827,175,137,530,666,360,-,139,108,269,71,460,398,535,466,149,111,465,565,186,8631,187,67,56,39,89,20
31,14/04,1982,3539,757,157,122,454,529,221,-,143,113,273,74,335,414,632,476,144,110,285,362,163,7344,93,69,58,59,89,20
31,14/05,2175,2213,836,201,136,412,563,224,-,118,117,237,67,363,614,679,402,132,105,354,334,65,7215,84,56,56,36,95,18
31,14/06,1721,2393,665,169,108,396,379,126,-,144,146,251,134,205,260,633,425,107,105,173,197,98,6968,116,43,43,45,99,15
31,14/07,2151,4279,801,219,170,545,479,166,-,149,124,292,249,265,244,1135,466,127,169,177,268,212,6604,112,65,50,69,114,21
31,14/08,2240,4698,806,213,165,578,563,157,-,171,112,307,190,258,261,1082,551,241,77,266,299,108,6229,109,88,46,40,109,15
31,14/09,2416,4080,812,354,133,547,499,131,-,148,133,292,187,257,209,1247,551,167,112,285,412,155,6719,122,63,45,73,108,18
31,14/10,2485,6395,666,268,166,738,524,177,-,149,114,314,239,186,206,2061,746,121,82,213,310,131,7185,107,45,26,36,97,16
31,14/11,2513,5779,804,262,126,532,723,265,-,150,99,285,394,261,202,797,661,151,62,175,229,99,7387,163,45,50,37,114,10
31,14/12,2574,5296,838,213,132,721,915,253,-,147,81,288,305,269,202,826,726,120,141,136,189,89,7536,123,45,31,25,107,8
31,15/01,2571,6721,843,267,375,546,1040,306,-,454,104,928,454,870,221,445,527,184,97,158,209,96,7186,166,305,90,90,132,14
31,15/02,1993,5711,628,237,110,418,614,233,-,153,67,211,288,160,155,418,682,140,92,166,155,152,6554,125,43,34,56,111,14
31,15/03,2753,8136,962,364,164,504,661,350,-,160,101,343,353,374,184,774,591,146,110,138,163,103,7485,143,64,70,82,104,27
31,15/04,2785,7761,1271,278,126,559,678,348,-,186,102,627,403,377,195,664,908,125,79,140,198,239,7536,173,44,47,69,124,23
31,15/05,2346,7372,1239,253,130,600,700,144,-,205,131,440,335,607,157,1230,844,158,88,194,254,99,7603,231,98,44,96,175,22
31,15/06,2041,6323,790,217,134,578,595,33,-,139,82,381,269,615,112,3303,833,103,154,122,188,121,6616,133,54,37,48,103,18
31,15/07,2194,5581,1167,182,125,710,627,56,-,172,106,507,266,496,153,3691,697,89,65,142,207,173,6735,123,55,70,45,81,13
31,15/08,2126,6717,597,244,113,744,621,24,-,168,93,372,192,518,122,2865,660,156,80,130,216,157,5717,87,46,66,46,64,18
30,15/09,1892,7248,552,246,86,1648,694,57,-,156,128,376,197,525,109,4937,603,124,77,168,228,136,6130,144,57,99,67,93,33
30,15/10,2182,7479,655,249,97,974,802,31,-,173,105,529,369,545,82,2473,658,159,60,180,231,110,6382,110,51,124,52,109,20
30,15/11,2057,7288,821,248,157,1444,753,30,-,166,97,325,293,592,86,4268,690,219,91,167,227,150,6534,120,54,70,88,86,31

Here's the data for the main stats page. I have not formatted it to match the current orientation. I forgot to transpose it before exporting as CSV. SharkD  Talk  08:31, 17 December 2015 (UTC)Reply