https://bugzilla.wikimedia.org/show_bug.cgi?id=55542

Aaron Halfaker <aaron.halfa...@gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |aaron.halfa...@gmail.com

--- Comment #2 from Aaron Halfaker <aaron.halfa...@gmail.com> ---
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
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l

Reply via email to