This afternoon Dan and I reviewed how tags from the android app are captured in the change_tag and tag_summary tables.
(1) We noticed that the “mobile app edit” tag is applied to recentchanges events that are not edits, but new account registrations:
SELECT * FROM enwiki.change_tag WHERE ct_rev_id IS NULL AND ct_tag = "mobile app edit";
ct_rc_id ct_log_id ct_rev_id ct_tag ct_params 661123291 56899294 NULL mobile app edit NULL 661123407 56899301 NULL mobile app edit NULL 661124928 56899375 NULL mobile app edit NULL 661127933 56899610 NULL mobile app edit NULL 661128644 56899685 NULL mobile app edit NULL 661131626 56899908 NULL mobile app edit NULL 661133278 56899998 NULL mobile app edit NULL 661134572 56900072 NULL mobile app edit NULL 661140653 56900620 NULL mobile app edit NULL 661155198 56901558 NULL mobile app edit NULL 661155799 56901593 NULL mobile app edit NULL 661156983 56901659 NULL mobile app edit NULL
AFAIK this is unusual behavior for tags and will create artifacts in tagged revisions unless people are aware that all these registration-related events always need to be excluded (it’s also confusing because the name of the tag explicitly refers to an edit). As suggested earlier [1], we should not track the source of account registrations via MediaWiki tags but via the ServerSideAccountCreation log.
(2) edits made on apps should be stored with two separate tags: “mobile edit” and “mobile app edit”. The tags are correctly stored in the change_tag table with 2 records for each revisions, e.g.
SELECT * FROM enwiki.change_tag WHERE ct_rc_id = 661110028;
ct_rc_id ct_log_id ct_rev_id ct_tag ct_params 661110028 NULL 611585155 mobile app edit NULL 661110028 NULL 611585155 mobile edit NULL
but when the tags are combined in the tag_summary table, the “mobile app edit” tag is lost:
SELECT * FROM enwiki.tag_summary WHERE ts_rc_id = 661110028;
ts_rc_id ts_log_id ts_rev_id ts_tags 661110028 NULL 611585155 mobile edit
This should not be the case, the 2 tags should be concatenated in the ts_tags field, see for example this desktop revision with 2 tags:
SELECT * FROM enwiki.change_tag WHERE ct_rc_id = 578489188;
ct_rc_id ct_log_id ct_rev_id ct_tag ct_params 578489188 NULL 555564321 gettingstarted edit NULL 578489188 NULL 555564321 visualeditor NULL
SELECT * FROM enwiki.tag_summary WHERE ts_rc_id = 578489188;
ts_rc_id ts_log_id ts_rev_id ts_tags 578489188 NULL 555564321 gettingstarted edit,visualeditor
I believe that neither (1) nor (2) is intended behavior for apps. Can you guys confirm and if so, can we fix this?
Dario
[1] http://lists.wikimedia.org/pipermail/mobile-l/2014-May/007150.html