https://bugzilla.wikimedia.org/show_bug.cgi?id=55542
Aaron Halfaker <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #2 from Aaron Halfaker <[email protected]> --- We do have some users who have more hide events recorded than impressions. > 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 | +--------------+----------------+-------+-------------+ | 19770442 | 20131013014124 | 6 | 5 | | 19889814 | 20131009001851 | 1 | 0 | | 19905630 | 20131011033720 | 4 | 2 | | 19909312 | 20131011163054 | 3 | 2 | | 19915156 | 20131012163322 | 2 | 1 | | 19918164 | 20131013060206 | 4 | 3 | | 19920569 | 20131013151144 | 2 | 1 | | 19932222 | 20131015082941 | 1 | 0 | | 19933356 | 20131015120432 | 5 | 3 | | 19990948 | 20131023143148 | 2 | 1 | +--------------+----------------+-------+-------------+ 10 rows in set (2.87 sec) I picked out user 19770442 since his first event was well after the "20131009" cutoff. > SELECT timestamp, event_action, event_tourName FROM GuidedTour_5222838 WHERE > event_userId = 19770442 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 [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
