Jon, just to clarify, wouldn't this query also work? Seems easier to write. Also, where do you run it? I would love to play with it some day.

SELECT
      event_name, count(1) count
FROM
      MobileWebMainMenuClickTracking_11568715
WHERE
      event_mobileMode = 'beta' AND wiki = 'enwiki'
GROUP BY event_name;

On Wed, Apr 15, 2015 at 9:37 PM, Moiz Syed <msyed@wikimedia.org> wrote:
If these numbers grow for collections maybe we can make a case for rolling Watchlist into Collections altogether.

On Wed, Apr 15, 2015 at 2:36 PM, Joaquin Oltra Hernandez <jhernandez@wikimedia.org> wrote:
Very interesting, thanks for sharing Jon.

On Wed, Apr 15, 2015 at 8:25 PM, Jon Robson <jdlrobson@gmail.com> wrote:
This is clicks on English Wikipedia in the beta version of mobile web
within the 'hamburger menu' (the menu accessed by clicking on the 3
line icon in the top left corner). We've seen lots of data on mobile
web that suggest people use the watchlist in this way.

If we look at watchlist behaviour, although the editor watchlist sees
more general activity, if you look at unique users, in this month,
1117 known users have used the watchlist as a bookmarking tool for
jumping to pages [1] whereas 1090 have used it to get to diffs, so
there is thus mounting evidence to show there is a need for a reader
version of the watchlist.

[1] select count(distinct event_username) from
MobileWebWatchlistClickTracking_10720361 where timestamp >
20150401000000 and event_name = 'watchlist-a-z-view';
[2] select count(distinct event_username) from
MobileWebWatchlistClickTracking_10720361 where timestamp >
20150401000000 and event_name = 'watchlist-feed-view';

On Wed, Apr 15, 2015 at 11:10 AM, James Alexander
<jalexander@wikimedia.org> wrote:
> Thanks Jon,
>
> Just for clarity: Is this clicks on watch list links "in general" (mobile
> and desktop), clicking on the watchlist button on mobile or clicking on
> watchlist links on mobile? (or something else)
>
> James Alexander
> Community Advocacy
> Wikimedia Foundation
> (415) 839-6885 x6716 @jamesofur
>
> On Wed, Apr 15, 2015 at 10:45 AM, Jon Robson <jdlrobson@gmail.com> wrote:
>>
>> In beta on enwiki, there were 400 clicks on watchlist compared to 587
>> on collections since we launched it. It will be interesting how it
>> holds out, as I suspect it is "new feature curiosity" but it adds more
>> value to the idea that people use the watchlist for things other than
>> editing. It's even more popular than nearby at current time.
>>
>> That said It still fails to compete with our most popular 'features'
>> home, random and settings.
>>
>> Result of SQL Query [1]:
>> Home Random Nearby Watchlist Uploads Settings Profile Logout Login
>> Collections
>> 1308 851 500 400 0 1188 258 99 373 587
>>
>> [1]    SELECT
>>       sum(if(event_name = 'home', 1, 0)) as Home,
>>       sum(if(event_name = 'random', 1, 0)) as Random,
>>       sum(if(event_name = 'nearby', 1, 0)) as Nearby,
>>       sum(if(event_name = 'watchlist', 1, 0)) as Watchlist,
>>       sum(if(event_name = 'uploads', 1, 0)) as Uploads,
>>       sum(if(event_name = 'settings', 1, 0)) as Settings,
>>       sum(if(event_name = 'profile', 1, 0)) as Profile,
>>       sum(if(event_name = 'logout', 1, 0)) as Logout,
>>       sum(if(event_name = 'login', 1, 0)) as Login,
>>       sum(if(event_name = 'collections', 1, 0)) as Collections
>>     FROM
>>       MobileWebMainMenuClickTracking_11568715
>> WHERE
>> event_mobileMode = 'beta'
>> and wiki = 'enwiki'
>>
>> _______________________________________________
>> Mobile-l mailing list
>> Mobile-l@lists.wikimedia.org
>> https://lists.wikimedia.org/mailman/listinfo/mobile-l
>
>



--
Jon Robson
* http://jonrobson.me.uk
* https://www.facebook.com/jonrobson
* @rakugojon

_______________________________________________
Mobile-l mailing list
Mobile-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mobile-l


_______________________________________________
Mobile-l mailing list
Mobile-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mobile-l



_______________________________________________
Mobile-l mailing list
Mobile-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mobile-l