Research talk:VisualEditor's effect on newly registered editors/Work log/2015-05-01
Latest comment: 8 years ago by Halfak (WMF) in topic Friday, May 1, 2015
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)