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

From Meta, a Wikimedia project coordination wiki

Friday, May 1, 2015[edit]

Doing some work this morning to look into the proportion of VE tagged edits that have a corresponding EL event.

> select LEFT(timestamp, 8) AS day, COUNT(*) as events, SUM(rev_id IS NOT NULL) as matched from log.Edit_11448630 LEFT JOIN enwiki.revision ON wiki = "enwiki" AND `event_page.revid` = rev_id WHERE wiki = "enwiki" AND event_editor = "visualeditor" AND event_action = "saveSuccess" AND timestamp > "20150420" GROUP BY 1;
+----------+--------+---------+
| day      | events | matched |
+----------+--------+---------+
| 20150420 |    901 |     890 |
| 20150421 |    958 |     931 |
| 20150422 |    960 |     944 |
| 20150423 |   1052 |    1035 |
| 20150424 |    733 |     723 |
| 20150425 |    570 |     564 |
| 20150426 |    683 |     680 |
| 20150427 |    859 |     847 |
| 20150428 |    730 |     725 |
| 20150429 |    735 |     730 |
| 20150430 |    434 |     421 |
| 20150501 |    563 |     563 |
+----------+--------+---------+
12 rows in set (3 min 26.31 sec)

The missing matches could be in the Archive table.--Halfak (WMF) (talk) 17:39, 1 May 2015 (UTC)[reply]