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