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(a)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(a)wikimedia.org> wrote:
On Mon, Jun 9, 2014 at 11:20 AM, Aaron Halfaker
<ahalfaker(a)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(a)lists.wikimedia.org
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.