Schema talk:MobileWebWatchlistClickTracking
Add topicAppearance
Latest comment: 7 years ago by Tbayer (WMF) in topic Definition of "...watch" and "...unwatch" events
Maintainer: | Jon Katz & Sam Smith |
---|---|
Team: | Reading - Web |
Please specify the project using this schema. | |
Status: | inactive |
Purge: | Bucketize userEditCount and auto-purge username and destination + eventCapsule PII after 90 days |
This page holds a JSON schema that specifies a data model for EventLogging.
Definition of "...watch" and "...unwatch" events
[edit]I have recently been looking into the data from this schema, assuming that it contains some information about how often pages are being watched and unwatched on mobile web. However, the watchlist-a-z-watch
and watchlist-a-z-unwatch
events seem to record something else - in particular, there are many more "unwatch" than "watch" events:
SELECT DATE(timestamp) AS date, SUM( IF(event_name = 'watchlist-a-z-watch', 1, 0)) AS watches, SUM( IF(event_name = 'watchlist-a-z-unwatch', 1, 0)) AS unwatches FROM log.MobileWebWatchlistClickTracking_10720361 WHERE MONTH(timestamp) =3 AND YEAR(timestamp) = 2016 GROUP BY date ORDER BY date; +------------+---------+-----------+ | date | watches | unwatches | +------------+---------+-----------+ | 2016-03-01 | 9 | 43 | | 2016-03-02 | 8 | 115 | | 2016-03-03 | 5 | 55 | | 2016-03-04 | 6 | 71 | | 2016-03-05 | 9 | 76 | | 2016-03-06 | 6 | 32 | | 2016-03-07 | 6 | 38 | | 2016-03-08 | 3 | 20 | | 2016-03-09 | 5 | 91 | | 2016-03-10 | 4 | 58 | | 2016-03-11 | 15 | 62 | | 2016-03-12 | 8 | 55 | | 2016-03-13 | 5 | 100 | | 2016-03-14 | 11 | 29 | | 2016-03-15 | 3 | 47 | | 2016-03-16 | 3 | 36 | | 2016-03-17 | 9 | 47 | | 2016-03-18 | 11 | 165 | | 2016-03-19 | 7 | 40 | | 2016-03-20 | 12 | 121 | | 2016-03-21 | 22 | 98 | | 2016-03-22 | 16 | 165 | | 2016-03-23 | 12 | 86 | | 2016-03-24 | 4 | 49 | | 2016-03-25 | 11 | 94 | | 2016-03-26 | 6 | 110 | | 2016-03-27 | 22 | 106 | | 2016-03-28 | 4 | 65 | | 2016-03-29 | 5 | 42 | | 2016-03-30 | 7 | 31 | | 2016-03-31 | 5 | 35 | +------------+---------+-----------+ 31 rows in set (1.10 sec)
Just leaving this here for the record, as I won't use be using that data for now. But it might be worth improving the documentation on the meaning of these events in case we need to look again into whatever questions the corresponding data was meant to answer. Regards, Tbayer (WMF) (talk) 08:10, 22 May 2017 (UTC)