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 <[email protected]> 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 <[email protected]> wrote: > >> On Mon, Jun 9, 2014 at 11:20 AM, Aaron Halfaker <[email protected]> >> 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 >> [email protected] >> https://lists.wikimedia.org/mailman/listinfo/analytics >> >> > > > -- > Oliver Keyes > Research Analyst > Wikimedia Foundation > -- -- - Brian Caution: The mass of this product contains the energy equivalent of 85 million tons of TNT per net ounce of weight. _______________________________________________ Multimedia mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/multimedia
