Yep. The SQL query has to be this way to generate limn graphs and I lazily copy and pasted. If you have access to stat.wikimedia.org I can give you access! On 21 Apr 2015 8:08 pm, "Yuri Astrakhan" <yastrak...@wikimedia.org> wrote:
> 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 <ms...@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 < >> jhernan...@wikimedia.org> wrote: >> >>> Very interesting, thanks for sharing Jon. >>> >>> On Wed, Apr 15, 2015 at 8:25 PM, Jon Robson <jdlrob...@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 >>>> <jalexan...@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 <jdlrob...@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 >> >> > > _______________________________________________ > 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
