Here: https://www.mediawiki.org/wiki/User:SSethi_(WMF)/Quarterly/2018-01#New_developers_metrics_and_trends for Wikimedia/Wikimania Hackathon 2017
Description
Description
| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| Resolved | srishakatux | T164084 [FY 17-18] Program 12: Onboarding new developers | |||
| Resolved | srishakatux | T176481 Goal: Understand how and why new developers start contributing and stay or leave | |||
| Resolved | srishakatux | T178627 Release "New Developers Quarterly Report" for October-December 2017 in early January 2018 | |||
| Resolved | Aklapper | T186515 Add "new developers" statistics for outreach events in metrics section of Q4/2017 report |
Event Timeline
Comment Actions
This is a PITA as usual... Here we go:
- So I need data of volunteers at "Wikimania Hackathon 2017" to construct a query.
- I find a spreadsheet called "Wikimania Hackathon newcomers".
- I copy the email addresses and user names included in it.
- I manually remove those names which are not considered newcomers by us. (Though for three names I personally still would not see them as newcomers.)
- Now I follow the steps in https://phabricator.wikimedia.org/T175854#3605693 to construct an SQL query.
- I realize that I don't have a fresh DB dump locally installed, so pulling a JSON dump and importing it will block me for the next ~6h to work on this...
Comment Actions
Continuation from previous comment
- DB dump imported
- Use email addresses and user names to create SQL query in P6671
- Use SQL query results to form the Sparql query
- Go to https://wikimedia.biterg.io/app/kibana#/dashboard/Overview
- Adjust time frame in upper right corner to only cover Q4/2017
- Enter the Sparql query in the search field
- Get: https://wikimedia.biterg.io/goto/4071fa89a225e462eda688e1dd8ed70e with one person active in Q4/2017.
Comment Actions
Sad, but true that one person who was active in Q4/2017 from Wikimania Hackathon 2017 never actually attended the event, also not a newcomer, etc.
Comment Actions
@srishakatux: Well, then https://www.mediawiki.org/wiki/New_Developers/Quarterly/2018-01#Outreach_programs_and_events is wrong and should be fixed?
Or what does that mean?