Research:Recent global monthly registrations (2015)

Created
23:03, 13 February 2015 (UTC)
Collaborators
Tbayer (WMF)
This page documents a completed research project.


A request was filed to gather the global registration data for a specific set of months [1]:

Generate the number for this report: File:Wikimedia Foundation Quarterly Report, 2014-15 Q2.pdf

Notes:

Recommendation: generate data from EL or using the NRU definition (Analytics)

Methods

edit

Use a script to run the following query against all project databases on stat1003:

SELECT
    DATABASE() AS wiki,
    LEFT(log_timestamp, 6) AS month,
    COUNT(*) AS registrations
FROM logging
WHERE
    log_type = "newusers" AND
    log_action = "create" AND
    log_timestamp >= "20131001"
GROUP BY 1,2

And then use this query to aggregate the result to global counts:

SELECT
    month,
    SUM(registrations) AS registrations
FROM staging.wiki_month_registrations
GROUP BY month

Results

edit
month registrations
201310 342352
201311 334420
201312 325100
201401 343938
201402 302244
201403 336585
201404 320647
201405 341800
201406 310818
201407 406188
201408 699264
201409 514879
201410 530475
201411 513857
201412 483259
201501 514498
201502 477897
201503 514508
201504 713884
201505 195341
201506 419895