I'd suggest looking for deleted revisions where the oldid is 0; that's
a reliable basis (ish) for identifying page deletions without
duplication.
There are certainly no dashboards, but Aaron had done a one-off
research project on this that lives somewhere on Meta; I don't have
the URL, but he will!
On 31 May 2015 at 08:26, Amir E. Aharoni <amir.aharoni(a)mail.huji.ac.il> wrote:
Hi,
Are there any easy to see statistics about the survival rate of
newly-created pages in Wikipedias in different languages?
I need this for understanding the success of ContentTranslation, which is
primarily an article creation tool
I couldn't find something like this in
stats.wikimedia.org. It does have the
number of created pages per day. For en.wikipedia, for example, it's about
800. But how many are deleted the same day ("speedy")? Knowing that alone
would be very useful, and there are other possible questions, such as: How
many are deleted within a week or a month? What is the age distribution of
the articles that are deleted every day - how many of them were created the
same day, how many were created a year ago, and so on.
Using a simple (and possibly wrong - I don't do this often) query,[1] I
found that around 500 or 600 deletions happen each day in the English
Wikipedia. Does this sound sensible? Is there a better query that I could
run, or a dashboard where I could see such a thing conveniently? And of
course, I'd love to see it for all languages and not just English.
Thanks for any help!
[1] SELECT max(ar_id), ar_title, ar_timestamp FROM `archive` WHERE
ar_namespace = 0 and ar_timestamp between 20150521000000 and 20150521999999
group by ar_title ORDER BY NULL;
--
Amir Elisha Aharoni · אָמִיר אֱלִישָׁע אַהֲרוֹנִי
http://aharoni.wordpress.com
“We're living in pieces,
I want to live in peace.” – T. Moore
_______________________________________________
Analytics mailing list
Analytics(a)lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/analytics