Last modified: 2014-04-21 18:44:17 UTC

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T55118, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 53118 - Large drop in historical total active editors numbers
Large drop in historical total active editors numbers
Status: RESOLVED FIXED
Product: Analytics
Classification: Unclassified
Wikistats (Other open bugs)
unspecified
All All
: Unprioritized major
: ---
Assigned To: Nobody - You can work on this!
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2013-08-20 21:01 UTC by Tilman Bayer
Modified: 2014-04-21 18:44 UTC (History)
7 users (show)

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---


Attachments

Description Tilman Bayer 2013-08-20 21:01:11 UTC
The "Total" active editor numbers for past months on the report card [1] ("Active Wikimedia Editors for All Wikimedia Projects (5+ edits per month)") appear to have changed drastically at some point during the last few months. 


Compare the table with the same numbers on stats.wikimedia.org [2] with its  version as archived by the Internet Archive in May [3]. E.g.:


March 2013:  79346 (current) vs. 82105 (archived, also matches the number given in the monthly WMF report at the time [4])

February 2013:  75140 (current) vs. 77701 (archived)

...
 
June 2012:  77363 (current) vs. 78320 (archived)

...


Note that some shrinkage is expected because of page deletions, but these decreases are way too large to be explained by this effect.


Also, two smaller issues which might be related or not: 

* For some reason, the source CSV file linked in the report card [5] contains empty columns for several other language projects (e.g. Chinese, Portuguese, and Polish Wikipedia, and Meta-Wiki), apart from those included in the charts.

* The June 2013 number for the Italian Wikipedia is currently missing from the report card chart ("NaN"). 


----

[1] http://reportcard.wmflabs.org/graphs/active_editors

[2] http://stats.wikimedia.org/EN/TablesWikimediaAllProjects.htm (Edits ≥ 5 column)

[3] http://web.archive.org/web/20130521103812/http://stats.wikimedia.org/EN/TablesWikimediaAllProjects.htm (Edits ≥ 5 column)

[4] https://meta.wikimedia.org/wiki/Wikimedia_Foundation_Report,_April_2013#Data_and_Trends

[5] http://reportcard.wmflabs.org/data/datafiles/rc/rc_active_editors_count.csv
Comment 1 Erik Zachte 2013-08-21 13:44:45 UTC
Wikistats related:

1. Mismatch between [2] and [3] is under investigation.

Limn related:

2. Incomplete csv file [5] is something in Limn, probably related to missing Italian data (which is last column filled in Limn csv file). All data except last month for Italian were available in wikistats output file 'wikilytics_in_wikistats_core_metrics.csv'

3. Also I just noticed data in [5] are in wrong columns. See e.g. Wikidata:  should be empty till Oct 12.

4. Limn shows a notice: "Jun 2013: Data for Italian Wiki is not yet available. This affects the overall totals and percentages."

It would have been clearer to blank total editors and MoM and YoY percentages, but I understand that wasn't so easy on such a short notice. Maybe tweak Limn, for next time this occurs?

Process flow related:

5. Italian wiki dump was not available till July 29 (dump server migrated to new data center on as far as Wikistats is concerned an ill-timed moment), and last minute processing failed (manual error), so that's why data were missing. I sent an updated data file Aug 8, but Limn was not updated, probably due to vacations.
Comment 2 Dan Andreescu 2013-08-21 14:18:39 UTC
I was indeed on vacation, but I've updated the data now so Italian numbers show up.  MoM and YoY percentages should also be correct.
Comment 3 Toby Negrin 2014-03-03 17:10:41 UTC
Hey Dan/Erik -- can we close this?

thanks,

-Toby
Comment 4 Dan Andreescu 2014-03-04 17:06:45 UTC
It's fine by me as far as I know

Note You need to log in before you can comment on or make changes to this bug.


Navigation
Links