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.

-Aaron

On Mon, Jun 9, 2014 at 2:52 AM, Gergo Tisza <gtisza@wikimedia.org> 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
Analytics@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/analytics