Hmm... It's hard to evaluate your strategy without more context.  Why are you limiting your query to users with more than 10k lifetime edits?  Are your trying to generate a proportion of a subset of users?  If so, what's the denominator?

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.


On Mon, Jun 9, 2014 at 2:52 AM, Gergo Tisza <> wrote:
Hi all,

after rolling out MediaViewer to the English and German Wikipedias, we have gotten quite a few complaints; to understand how representative they are, I have looked at the number of users who have opted out (there is a user preference for that; it is linked from the MediaViewer interface, although one of the recurring complaints is that it is still not trivial to find). I would appreciate opinions on whether this is a good approach and whether I did it the right way.

The queries I have run look like this:

select up_value, count(*) from user left join user_properties on user_id = up_user and up_property = 'multimediaviewer-enable' where user_touched > '20140604000000' and user_editcount > 10000 group by up_value;

for various edit count limits (the timestamp is the time of deployment on enwiki plus a few hours).

Analytics mailing list