Dear Alec,
Maybe the Community Department can help you out with your question. We are doing a number of research sprints this summer to map out different aspects of the Wikipedia communities and this sounds like a great question and we have some researchers available to help write the queries. So please contact me and I'll hook you up with the right people. Best, Diederik
On Thu, Jun 16, 2011 at 4:40 AM, Platonides Platonides@gmail.com wrote:
Alec Conroy wrote:
I think I can build you something if you give me appropiate values for the above definition.
Cheers
Excellent-- so striking while the iron is hot-- I see that [[Special:Statistics]] defines active as "edited within the last 30 days". I'm open to whoever many users we can realistically get info on-- the more the merrier, at least until I run out of ram. :)
My initial query my go something like "Select users where lasttouched was within the last month and total edit counts are greater than 500".
And then, adding in the requirement of second project will narrow that pool. And then adding the constraint of a second project with a second language will narrow the pool even more.
We're looking for the orphan community who have a lot of editors but little connection to English and Meta.
I have added a small script at http://www.toolserver.org/~platonides/activeusers/activeusers.php to show active users per project and language. Requisites for appearing there are more than 500 edits (total) and at least one action (usually an edit) in the last month (since May 16, data is cached). Bots appear in the list. I'm still populating the data, but it should be completed by the time you read this.
Wikitech-l mailing list Wikitech-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikitech-l