Re: [Analytics] Fwd: follow-up on editors

2017-03-22 Thread Federico Leva (Nemo)
Aaron Halfaker, 22/03/2017 22:43: __· __Number of editors who contribute 1 edit per month? __ First column of https://stats.wikimedia.org/EN/TablesWikimediaAllProjects.htm . __· Is it possible/feasible to run editor retention metrics globally (versus just based on a single p

Re: [Analytics] Maintenance on Eventlogging Database - Renaming of tables

2017-03-22 Thread Tilman Bayer
Hi Nuria, as part of the Reading team's offsite meeting next week we already have a session scheduled for that day which will involve various people running EventLogging queries. Could we move the outage once more, to Wednesday or later? Many thanks! On Tue, Mar 21, 2017 at 3:22 PM, Nuria Ruiz w

Re: [Analytics] Top editors in a certain namespace across sites?

2017-03-22 Thread Aaron Halfaker
https://quarry.wmflabs.org/query/17556 On Wed, Mar 22, 2017 at 11:43 AM, Federico Leva (Nemo) wrote: > (I confirm my advice. I usually use Labs of course.) > > > Nemo > > ___ > Analytics mailing list > Analytics@lists.wikimedia.org > https://lists.wiki

Re: [Analytics] Fwd: follow-up on editors

2017-03-22 Thread Aaron Halfaker
We could use the labor-hours measurement based on activity sessions[1]. But I don't think that analytics keeps that metric yet. I've been following their history reconstruction work as that would feed directly into generating metrics like edit sessions. It's not a perfect approximation, but it's

Re: [Analytics] Fwd: follow-up on editors

2017-03-22 Thread Pine W
Hi Aaron and Shannon, Could you clarify " Average hours of spent by editors by segment (5+ edits and 100+ edits)?" If that's referring to logged-in time, that information might be available, but keep in mind that a number of contributors do a variety of Wikimedia-related activities off-wiki, so th

[Analytics] Fwd: follow-up on editors

2017-03-22 Thread Aaron Halfaker
Hey folks, I just got the following data requests emailed to me and I figured that this list is probably best equipped to answer: · Number of editors who contribute 1 edit per month? · Is it possible/feasible to run editor retention metrics globally (versus just based on a single

Re: [Analytics] Top editors in a certain namespace across sites?

2017-03-22 Thread Federico Leva (Nemo)
(I confirm my advice. I usually use Labs of course.) Nemo ___ Analytics mailing list Analytics@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/analytics

Re: [Analytics] Top editors in a certain namespace across sites?

2017-03-22 Thread Jaime Crespo
On Wed, Mar 22, 2017 at 3:44 PM, Federico Leva (Nemo) wrote: > Andre Klapper, 22/03/2017 13:51: > >> Does anyone know of a way to look up the top editors for a certain >> namespace (like "Module") across all Wikimedia sites? >> > > The easiest way is usually to run the relevant SELECT queries wit

Re: [Analytics] Top editors in a certain namespace across sites?

2017-03-22 Thread Federico Leva (Nemo)
Andre Klapper, 22/03/2017 13:51: Does anyone know of a way to look up the top editors for a certain namespace (like "Module") across all Wikimedia sites? The easiest way is usually to run the relevant SELECT queries with a small bash script on Labs or with sql.php on tin (e.g. https://phabric

[Analytics] Top editors in a certain namespace across sites?

2017-03-22 Thread Andre Klapper
Hi, Does anyone know of a way to look up the top editors for a certain namespace (like "Module") across all Wikimedia sites? I'm asking as I'm wondering how to get more aware of developer activity outside of Wikimedia Git/Gerrit. Thanks for any ideas (or pointing out a better place to ask)! Che