Hmm, I thought that was a really interesting question (How our user base breaks down into orders of magnitude of edits)
We have 15 such users (including bots) with over a million edits:
MariaDB [enwiki_p]> select count(*), floor( log10( user_editcount ) ) from user group by floor( log10( user_editcount ) ); +----------+----------------------------------+ | count(*) | floor( log10( user_editcount ) ) | +----------+----------------------------------+ | 14392731 | NULL | | 5843417 | 0 | | 1132181 | 1 | | 157056 | 2 | | 29970 | 3 | | 6400 | 4 | | 401 | 5 | | 15 | 6 | +----------+----------------------------------+ 8 rows in set (12.14 sec)
If you limit it to non-bots, that number goes down to 2 (Koavf and Waacstats):
MariaDB [enwiki_p]> select count(*), floor( log10( user_editcount ) ) from user left outer join user_groups on ug_user = user_id and ug_group = 'bot' where ug_user is null group by floor( log10( user_editcount ) ); +----------+----------------------------------+ | count(*) | floor( log10( user_editcount ) ) | +----------+----------------------------------+ | 14392718 | NULL | | 5843411 | 0 | | 1132140 | 1 | | 156951 | 2 | | 29769 | 3 | | 6160 | 4 | | 290 | 5 | | 2 | 6 | +----------+----------------------------------+ 8 rows in set (1 min 5.53 sec)
--bawolff
On 6/9/14, Oliver Keyes okeyes@wikimedia.org wrote:
Re user counts; we have, I think, 1 editor who has 1M+ edits. I imagine we don't have many with 100K edits. How big are those user groups? It's useful to know that power users are more likely to opt out, great, but if you only have 30 users in your definition of 'power users' it's going to be thrown off very easily.
My big worry would be that finding this out only tells you that either (1) only power users have a problem or (2) only power users can find the off-switch. Comparing with other features that also feature an off-switch would allow you to eliminate this as an independent variable.
On 9 June 2014 11:55, Gergo Tisza gtisza@wikimedia.org wrote:
On Mon, Jun 9, 2014 at 11:20 AM, Aaron Halfaker ahalfaker@wikimedia.org wrote:
Also, opt-out rates tend to be low no matter how obvious and desired they are. If the goal of this analysis is to find out if opt-out rates are high (or low), then I'd recommend comparing them with opt-out rates for another feature.
One thing I did was to compare opt-out rates with other wikis where we have received fewer complaints (fr, es), and enwiki optouts seem to be in the same range. Do you think that is a useful indicator, or comparing optout rates for wikis with a different userbase size is not particularly useful?
Analytics mailing list Analytics@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/analytics
-- Oliver Keyes Research Analyst Wikimedia Foundation