There were 710 attempts to edit that article [1] by 297 unique users [A], 1618 errors [2] by 290 unique users [B] and 12 successful edits [3] by 12 unique users [C].
There were 1829 clicks on the save button [4] by 345 users [5] (note the increase in users is due to people who started the editing workflow before the start timestamp).
The fact that 290 users hit 1618 errors suggests users retried their edits various times. Error handling in mobile is dumb - it just allows you to retry and doesn't even tell you that an edit conflict occurred.
So yes lots of edits were lost due to this and mobile could probably improve its edit conflict handling as this event lost it about 290 potential edits.
[1] select count(*) from MobileWebEditing_6077315 where event_action = 'attempt' and timestamp > 20131119023000 and timestamp < 20131119030000 and event_pageId = 40462095 [2] select count(*) from MobileWebEditing_6077315 where event_action = 'error' and timestamp > 20131119023000 and timestamp < 20131119030000 and event_pageId = 40462095 [3] select count(*) from MobileWebEditing_6077315 where event_action = 'success' and timestamp > 20131119023000 and timestamp < 20131119030000 and event_pageId = 40462095 [A] select count(distinct event_userName) from MobileWebEditing_6077315 where event_action = 'attempt' and timestamp
20131119023000 and timestamp < 20131119030000 and event_pageId =
40462095 [B] select count(distinct event_userName) from MobileWebEditing_6077315 where event_action = 'error' and timestamp > 20131119023000 and timestamp < 20131119030000 and event_pageId = 40462095 [C] select count(distinct event_userName) from MobileWebEditing_6077315 where event_action = 'success' and timestamp
20131119023000 and timestamp < 20131119030000 and event_pageId =
40462095 [4] select count(*) from MobileWebEditing_6077315 where event_action = 'submit' and timestamp > 20131119023000 and timestamp < 20131119030000 and event_pageId = 40462095 [5] select count(distinct event_userName) from MobileWebEditing_6077315 where event_action = 'submit' and timestamp > 20131119023000 and timestamp < 20131119030000 and event_pageId = 40462095
On Fri, Nov 22, 2013 at 12:58 PM, Aaron Halfaker ahalfaker@wikimedia.org wrote:
Indeed. The thing that I find curious is that 3 times as many edits were lost as were saved.
Then again, it would be nice to know how many got their edits in on retry.
On Fri, Nov 22, 2013 at 2:56 PM, Maryana Pinchuk mpinchuk@wikimedia.org wrote:
On Fri, Nov 22, 2013 at 12:43 PM, Aaron Halfaker ahalfaker@wikimedia.org wrote:
There are fewer edits than there were edit conflicts.
That makes perfect sense, since an edit conflict doesn't lead to a successful edit stored in the revision table :)
Aaron, if you're interested in lining this up with attempted mobile edits, there's a schema tracking the mobile edit funnel (attempts, saves, errors) in log.
select count(*) from revision where rev_page = 40462095;
+----------+ | count(*) | +----------+ | 1216 | +----------+ 1 row in set (0.05 sec)
select count(*) from revision where rev_page = 40462095 and rev_timestamp between '20131119023000' and '20131119030000';
+----------+ | count(*) | +----------+ | 403 | +----------+ 1 row in set (0.12 sec)
On Fri, Nov 22, 2013 at 2:40 PM, Steven Walling swalling@wikimedia.org wrote:
On Fri, Nov 22, 2013 at 12:37 PM, Jon Robson jrobson@wikimedia.org wrote:
40462095 1384
And the winner is... https://en.wikipedia.org/wiki/Midnight_Memories the new album by boy band One Direction.
So basically, 1384 teenage girls all edit conflicted with each other. ;)
-- Steven Walling, Product Manager https://wikimediafoundation.org/
Mobile-l mailing list Mobile-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mobile-l
Mobile-l mailing list Mobile-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mobile-l
-- Maryana Pinchuk Product Manager, Wikimedia Foundation wikimediafoundation.org
Mobile-l mailing list Mobile-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mobile-l