Research talk:VisualEditor's effect on newly registered editors/Work log/2015-05-01
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)