Size-per-view ratio Options

[thekohser]

Interesting question, I think.

What do you think might be a candidate for the longest Wikipedia article that receives the fewest number of page views?

In other words, this would be the Wikipedia equivalent of an "FT2 Award" for tl;dr.

[MBisanz]

Interesting question, I think.

What do you think might be a candidate for the longest Wikipedia article that receives the fewest number of page views?

In other words, this would be the Wikipedia equivalent of an "FT2 Award" for tl;dr.

Throwing up a bad guessesList of Advanced Dungeons & Dragons 2nd edition monsters, 390,000 characters and 1,000 views per month; Austrian legislative election, 2008, 299,000 characters and 1,000 views per month. I couldn't help but note the large size of List of mass murderers and spree killers by number of victims, 140,000 characters, but a good 16,000 views.

[CharlotteWebb]

Interesting question, I think.

What do you think might be a candidate for the longest Wikipedia article that receives the fewest number of page views?

In other words, this would be the Wikipedia equivalent of an "FT2 Award" for tl;dr.

I do know there's enough db dump data to answer this with absolute certainty. I have a good idea how to go about it but I think it would require more time than four days, plus a larger hard-drive.

[radek]

Interesting question, I think.

What do you think might be a candidate for the longest Wikipedia article that receives the fewest number of page views?

In other words, this would be the Wikipedia equivalent of an "FT2 Award" for tl;dr.

Throwing up a bad guessesList of Advanced Dungeons & Dragons 2nd edition monsters, 390,000 characters and 1,000 views per month; Austrian legislative election, 2008, 299,000 characters and 1,000 views per month. I couldn't help but note the large size of List of mass murderers and spree killers by number of victims, 140,000 characters, but a good 16,000 views.

This mammoth of an article, which I created (for future expansion), got 0 views in 8/2009, which means that length/views=INFINITY!!!

[MZMcBride]

Interesting question, I think.

What do you think might be a candidate for the longest Wikipedia article that receives the fewest number of page views?

In other words, this would be the Wikipedia equivalent of an "FT2 Award" for tl;dr.

I do know there's enough db dump data to answer this with absolute certainty. I have a good idea how to go about it but I think it would require more time than four days, plus a larger hard-drive.

It would only require a large hard drive if you tried to process the squid logs by yourself. Anyone with sense would just use Henrik's stats.grok.se. (Pro-tip: It has a JSON module.)

[Eva Destruction]

Interesting question, I think.

What do you think might be a candidate for the longest Wikipedia article that receives the fewest number of page views?

In other words, this would be the Wikipedia equivalent of an "FT2 Award" for tl;dr.

List of tablets on the Memorial to Heroic Self Sacrifice has got to be up there.

[MBisanz]

Interesting question, I think.

What do you think might be a candidate for the longest Wikipedia article that receives the fewest number of page views?

In other words, this would be the Wikipedia equivalent of an "FT2 Award" for tl;dr.

List of tablets on the Memorial to Heroic Self Sacrifice has got to be up there.

Not even close, 35,000 characters to 214 page views.

[gomi]

List of tablets on the Memorial to Heroic Self Sacrifice has got to be up there.

Funny, I thought that this was the "List of tablets on the Memorial to Heroic Self Sacrifice". Silly me.

[MZMcBride]

Interesting question, I think.

What do you think might be a candidate for the longest Wikipedia article that receives the fewest number of page views?

In other words, this would be the Wikipedia equivalent of an "FT2 Award" for tl;dr.

It seems I already had a script lying around that was pretty much capable of doing this without much modification. I queried the 6,000 longest non-redirects in the article namespace (according to the page.page_len field). This means there will be some mismatch if a page has dramatically grown since December or if a page has been moved, but it's good enough™ data.

The raw results are available here (sorted by page length): http://toolserver.org/~mzmcbride/yahoo-size-views-output.txt

The columns are page title, page length, total views in 2009-12, and ratio (page length / total views).

Dump the data into Excel or whatever if you want to calculate a better ratio.

[Random832]

I queried the 6,000 longest non-redirects in the article namespace (according to the page.page_len field).

Er. Is there a significant difference between this set and the 6,000 longest pages including redirects?

[Sarcasticidealist]

Er. Is there a significant difference between this set and the 6,000 longest pages including redirects?

I understand that [[pi]] has all kinds of redirects, including [[3.14]], [[3.142]], [[3.1415]], and so on to the six hundred thousandth decimal place.

Edit: Wait, that joke fell flat. For the redirect to be one of Wikipedia's longest pages, [[pi]] would have to redirect *to* some incredibly close approximation. Bah. Just pretend I got the joke right, and try to imagine how funny it would have been.

This post has been edited by Sarcasticidealist: Sat 13th February 2010, 3:21am

[tarantino]

Interesting question, I think.

What do you think might be a candidate for the longest Wikipedia article that receives the fewest number of page views?

In other words, this would be the Wikipedia equivalent of an "FT2 Award" for tl;dr.

It seems I already had a script lying around that was pretty much capable of doing this without much modification. I queried the 6,000 longest non-redirects in the article namespace (according to the page.page_len field). This means there will be some mismatch if a page has dramatically grown since December or if a page has been moved, but it's good enough™ data.

The raw results are available here (sorted by page length): http://toolserver.org/~mzmcbride/yahoo-size-views-output.txt

The columns are page title, page length, total views in 2009-12, and ratio (page length / total views).

Dump the data into Excel or whatever if you want to calculate a better ratio.

It's hard to believe the mammoth article Astor House Hotel (Shanghai) (T-H-L-K-D) would have 0 page views for months at a time. There's another 99 articles on the list also with 0 page views. Something must be broken in the way the database keeps track of page views.

[MZMcBride]

I queried the 6,000 longest non-redirects in the article namespace (according to the page.page_len field).

Er. Is there a significant difference between this set and the 6,000 longest pages including redirects?

I doubt it. Though people have a tendency to put unusual shit below redirects. It's mostly new editors (or clueless ones). The parser doesn't really parse most content below the initial line if it's a redirect. Though it takes exception to certain aspects like template links, category links, and maybe other types of links. This level of bizarreness is par for the course for MediaWiki. There's a whole list of this phenomenon here, if you're interested: Wikipedia:Database reports/Redirects obscuring page content. It doesn't look as though any of those titles are long enough to be in the top 6,000, but saying "non-redirects in the article namespace" is a good level of specificity, all things considered. At least in my opinion!

It's hard to believe the mammoth article Astor House Hotel (Shanghai) (T-H-L-K-D) would have 0 page views for months at a time. There's another 99 articles on the list also with 0 page views. Something must be broken in the way the database keeps track of page views.

From the article's page history:

7 February 2010 Smjwalsh (talk | contribs) m (204,227 bytes) (moved Astor House, Shanghai to Astor House Hotel (Shanghai): Change to actual name and putting disambiguation location.) (undo)

That'd be your answer there. The actual value for that page should be 1697. Any 0 value is likely the result of a page move or a new article. Though, given the length requirement, a new article is pretty unlikely. So I calculated about 5,900 entries instead of 6,000; you can handle the other 100.

[Enric_Naval]

It's hard to believe the mammoth article Astor House Hotel (Shanghai) (T-H-L-K-D) would have 0 page views for months at a time. There's another 99 articles on the list also with 0 page views. Something must be broken in the way the database keeps track of page views.

From the article's page history:

7 February 2010 Smjwalsh (talk | contribs) m (204,227 bytes) (moved Astor House, Shanghai to Astor House Hotel (Shanghai): Change to actual name and putting disambiguation location.) (undo)

That'd be your answer there. The actual value for that page should be 1697. Any 0 value is likely the result of a page move or a new article. Though, given the length requirement, a new article is pretty unlikely. So I calculated about 5,900 entries instead of 6,000; you can handle the other 100.

Another example. The List of restriction enzyme cutting sites article was created in 4th January and moved in 7th January. The visit data is from December (I think) so it had zero visits in December because it didn't exist yet when the visit data was gathered.

[tarantino]

That'd be your answer there. The actual value for that page should be 1697. Any 0 value is likely the result of a page move or a new article. Though, given the length requirement, a new article is pretty unlikely. So I calculated about 5,900 entries instead of 6,000; you can handle the other 100.

Ahh, my mistake. I didn't think to look for page moves. Of course, some of the 5,900 may have been moved during December, so they would show less than the actual number of views.

[thekohser]

Some enterprising member of Yahoo! Answers could get an easy 10 points about now.

Thanks, MZMcBride! (Please don't tell the world about your other data run that I got from you a few days ago. Its awesomeness for me depends in part on it not becoming public.)

Greg