Research:Recent global monthly registrations (2015)
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:
- there is no report for global signups
- it would need to be generated (data available via EventLogging: ServerSideAccountCreation or logging table (see https://meta.wikimedia.org/wiki/Research:Newly_registered_user)
- Vital Signs already has counts per project and [2] has some
- Historical data: available
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 |