Research talk:VisualEditor's effect on newly registered editors/May 2015 study/Work log/2015-05-21

Thursday, May 21, 2015

Pilot deployed. I'm checking up on the logging to make sure we see a jump in VE usage by newly registered users after the deploy time (~2015-05-21 @ 1500 UTC).

> SELECT LEFT(edit.timestamp, 10) AS hour, `event_user.id` % 2, `event_editor`, COUNT(*)
    -> FROM Edit_11448630 edit
    -> INNER JOIN ServerSideAccountCreation_5487345 registration ON
    ->   event_userId = `event_user.id`
    -> WHERE 
    ->   edit.wiki = 'enwiki' AND 
    ->   registration.wiki = 'enwiki' AND
    ->   edit.timestamp > '20150521140000' AND
    ->   registration.timestamp > '20150521140000' AND
    ->   event_isSelfMade AND 
    ->   NOT event_displayMobile
    -> GROUP BY 1,2,3;
+------------+---------------------+--------------+----------+
| hour       | `event_user.id` % 2 | event_editor | COUNT(*) |
+------------+---------------------+--------------+----------+
| 2015052114 |                   0 | wikitext     |      104 |
| 2015052114 |                   1 | visualeditor |        5 |
| 2015052114 |                   1 | wikitext     |       62 |
| 2015052115 |                   0 | visualeditor |       88 |
| 2015052115 |                   0 | wikitext     |       32 |
| 2015052115 |                   1 | wikitext     |       96 |
+------------+---------------------+--------------+----------+
6 rows in set (14.97 sec)

Just realized I never confirmed with the VE team whether even or odd user_ids would be in the VE condition. It looks like this query can answer the question. We see that, once the 1500 UTC hour starts, there's a dramatic rise in the number of events from visual editor for newcomers who registered on the desktop site (2 --> 88 and the hour is only half-way done). We can also see that this happens for users with user_id % 2 == 0 (evens). Cool! It looks like it is doing what it is supposed to. --Halfak (WMF) (talk) 15:36, 21 May 2015 (UTC)