Manuel created this task.
Manuel added projects: Wikidata Analytics, Wikidata.
Restricted Application added a subscriber: Aklapper.
TASK DESCRIPTION
Scope
-----
- How many active editors use Babels?
- How are the languages distributed?
Desired output
--------------
How many active editors use this?
- Population: active UI editors; Diagram: Number of Babels
How are the languages distributed?
- Population: Babels; Split: N, 4, 3, 2, 1, 0
- Population: Babels; Split: N/4, 3/2/1, 0
- Population: active UI editors; typical combinations (optional)
- Population: active UI editors; most important bridge languages (optional)
Definitions:
- An active UI editor:
- registered user
- made at least 5 edits using the UI in the last 30 days (to any namespace)
Notes
-----
MariaDB [wikidatawiki]> SELECT * FROM babel WHERE babel_user = (SELECT
user_id FROM user WHERE user_name = 'Lydia Pintscher (WMDE)');
sudo -u analytics-wmde analytics-mysql metawiki
MariaDB [metawiki]> SELECT * FROM babel WHERE babel_user = (SELECT user_id
FROM user WHERE user_name = 'Lucas Werkmeister');
Lydia has contents in the wikidatawiki babel table because she has a local
user page, whereas I don’t. and at read time, Babel::getUserLanguagesDB() reads
from the local DB, then falls back to the central DB, if I’m reading the code
correctly
Urgency
-------
When this task should be completed by. If this task is time sensitive then
please make this clear. Please also provide the date when the output will be
used if there is a specific meeting or event, for example.
DD.MM.YYYY
---
**Information below this point is filled out by the Wikidata Analytics team.**
General Planning
----------------
Information is filled out by the analytics product manager.
Assignee Planning
-----------------
Information is filled out by the assignee of this task.
Estimation
----------
Estimate:
Actual:
Sub Tasks
---------
Full breakdown of the steps to complete this task:
[ ] subtask
Data to be used
---------------
See Analytics/Data_Lake
<https://wikitech.wikimedia.org/wiki/Analytics/Data_Lake> for the breakdown of
the data lake databases and tables.
The following tables will be referenced in this task:
- link_to_table
Notes and Questions
-------------------
Things that came up during the completion of this task, questions to be
answered and follow up tasks:
- Note
TASK DETAIL
https://phabricator.wikimedia.org/T349071
EMAIL PREFERENCES
https://phabricator.wikimedia.org/settings/panel/emailpreferences/
To: Manuel
Cc: Aklapper, Manuel, Danny_Benjafield_WMDE, Astuthiodit_1, karapayneWMDE,
Invadibot, maantietaja, ItamarWMDE, Akuckartz, Nandana, Lahi, Gq86,
GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Scott_WUaS,
Wikidata-bugs, aude, Mbch331
_______________________________________________
Wikidata-bugs mailing list -- [email protected]
To unsubscribe send an email to [email protected]
