https://bugzilla.wikimedia.org/show_bug.cgi?id=55542
--- Comment #3 from Aaron Halfaker <aaron.halfa...@gmail.com> --- We do have some users who have more hide events recorded than impressions. (Note that user IDs have been censored for privacy.) > SELECT event_userId, MIN(timestamp) AS first_event, SUM(event_action = "hide") as hides, SUM(event_action = "impression") as impressions FROM GuidedTour_5222838 WHERE timestamp > "20131009" AND wiki = "enwiki" GROUP BY event_userId HAVING SUM(event_action = "hide") > SUM(event_action = "impression") LIMIT 10; +--------------+----------------+-------+-------------+ | event_userId | first_event | hides | impressions | +--------------+----------------+-------+-------------+ | <snip> | 20131013014124 | 6 | 5 | | <snip> | 20131009001851 | 1 | 0 | | <snip> | 20131011033720 | 4 | 2 | | <snip> | 20131011163054 | 3 | 2 | | <snip> | 20131012163322 | 2 | 1 | | <snip> | 20131013060206 | 4 | 3 | | <snip> | 20131013151144 | 2 | 1 | | <snip> | 20131015082941 | 1 | 0 | | <snip> | 20131015120432 | 5 | 3 | | <snip> | 20131023143148 | 2 | 1 | +--------------+----------------+-------+-------------+ 10 rows in set (2.87 sec) I picked out a user with his first event was well after the "20131009" cutoff. > SELECT timestamp, event_action, event_tourName FROM GuidedTour_5222838 WHERE event_userId = <snip> AND timestamp >= "20131009"; +----------------+--------------+-----------------------------+ | timestamp | event_action | event_tourName | +----------------+--------------+-----------------------------+ | 20131013014124 | impression | gettingstartedtasktoolbarve | | 20131013014126 | hide | gettingstartedtasktoolbarve | | 20131013014131 | impression | gettingstartedtasktoolbarve | | 20131013014133 | hide | gettingstartedtasktoolbarve | | 20131013122419 | impression | gettingstartedtasktoolbarve | | 20131013122422 | hide | gettingstartedtasktoolbarve | <-- | 20131013122427 | hide | gettingstartedtasktoolbarve | <-- | 20131013122431 | impression | gettingstartedtasktoolbarve | | 20131013122433 | hide | gettingstartedtasktoolbarve | | 20131013122502 | impression | gettingstartedtasktoolbarve | | 20131013122507 | hide | gettingstartedtasktoolbarve | +----------------+--------------+-----------------------------+ 11 rows in set (1.05 sec) Note the two hide events occurring 5 seconds apart. I see this sort of pattern when I look through other users too. We'll often have an "impression" followed by one or more "hide"s that are separated by 5-10 seconds. -- You are receiving this mail because: You are on the CC list for the bug. _______________________________________________ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
