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 <[email protected]> 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 <
> [email protected]> wrote:
>
>> Very interesting, thanks for sharing Jon.
>>
>> On Wed, Apr 15, 2015 at 8:25 PM, Jon Robson <[email protected]> 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
>>> <[email protected]> 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 <[email protected]>
>>> 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
>>> >> [email protected]
>>> >> https://lists.wikimedia.org/mailman/listinfo/mobile-l
>>> >
>>> >
>>>
>>>
>>>
>>> --
>>> Jon Robson
>>> * http://jonrobson.me.uk
>>> * https://www.facebook.com/jonrobson
>>> * @rakugojon
>>>
>>> _______________________________________________
>>> Mobile-l mailing list
>>> [email protected]
>>> https://lists.wikimedia.org/mailman/listinfo/mobile-l
>>>
>>
>>
>> _______________________________________________
>> Mobile-l mailing list
>> [email protected]
>> https://lists.wikimedia.org/mailman/listinfo/mobile-l
>>
>>
>
> _______________________________________________
> Mobile-l mailing list
> [email protected]
> https://lists.wikimedia.org/mailman/listinfo/mobile-l
>
>
_______________________________________________
Mobile-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mobile-l
