...so tasks can still be performed by someone else if someone is not available.
Plus we might not remember too well what we did three months ago.
=== Quick brain dump, feel free to {nav icon=pencil, name=Edit Task} / correct: ===
* Timeline (relevant events which took place to cover):
** maintained by @srishakatux
* Survey (maintained by @srishakatux (running & analyzing))
** Here are some steps to follow:
*** Follow the instructions in https://office.wikimedia.org/wiki/Qualtrics/Accounts to set up a Qualtrics account.
*** @aklapper to gather email addresses of last 3 months' newcomers listed on https://wikimedia.biterg.io/app/kibana#/dashboard/C_Gerrit_Demo by searching in the JSON dump file of the wikimedia.biterg.io database
*** Everyone in the Developer Relations team to agree on the list of newcomers reflected in the metrics and events organized
*** @srishakatux to contact these newcomers via email with a link to the survey form at the end of each month in a quarter (three times)
*** Additional info:
**** See [[ https://phabricator.wikimedia.org/T167085#3603445 | example of an email ]] used in the past. Make sure, it contains a link to the [[ https://wikimediafoundation.org/wiki/New_Developer_Survey_Privacy_Statement | survey privacy statement ]]
**** Send a reminder to unfinished respondents a week after piloting the survey
* Quantitative data / KPIs:
** maintained by @aklapper, to gather directly after the quarter ends
** Right before the quarter ends, @aklapper to contact Bitergia to update data on [[ https://wikimedia.biterg.io/app/kibana#/dashboard/C_Gerrit_Demo | C_Gerrit_Demo ]] (needed until https://phabricator.wikimedia.org/T151161 is fixed)
*** For contacting Bitergia, see https://office.wikimedia.org/wiki/User:AKlapper/continuity#Access_lock-in
** The three KPIs have to be in sync with / a copy of https://meta.wikimedia.org/wiki/Technical_Collaboration/Metrics#Onboarding_New_Developers
** For any stats on https://wikimedia.biterg.io, make sure to
*** [[ https://www.mediawiki.org/wiki/Community_metrics#wikimedia.biterg.io | filter the view ]] to only display individuals (`author_org_name:Independent`)
*** set the time span accordingly in the upper corner, like `From 2016-04-01 00:00:00.000 | To 2016-06-30 23:59:59.999`
*** exclude certain upstream repositories - see the second (Gerrit) block in https://phabricator.wikimedia.org/T146135#3176718
** Manually review the lists of developers displayed as the database might not have most recent affiliations. If you spot names who are staff, manually exclude them via `(NOT author_name:"Foo") AND (NOT author_name:"Bar") AND ...`
** Double-check that lists of people list ALL names (compare with the number in the box at the top).
*** If lists do not display, as an admin, edit that visualization to include more data: Go to https://wikimedia.biterg.io/edit/app/kibana#/visualize/edit/C_Gerrit_Demo_Table (or whatever page you are on, note the additional `/edit` in the URL) and under `buckets: Split Rows`, set "Size" to a value larger than the number displayed in the box at the top. Then click Save and explicitly overwrite the saved query.
** In general, specific steps / sources for each data item are linked from each section in the (previous edition of the) report itself. (You create those sources links by using "Share" and the second "Short URL" link on https://wikimedia.biterg.io , see https://www.mediawiki.org/wiki/Community_metrics#wikimedia.biterg.io )
* After a Hackathon event has taken place:
** @rfarrand (with input from others) to decide who to consider newcomers, in a spreadsheet.
** For newcomers who have not provided a Phab/Gerrit/mw.org username, @aklapper to manually search for their real names in the JSON dump file of the wikimedia.biterg.io database to potentially find them in our systems, and add the username to the spreadsheet row
** Someone to put the final 'newcomer attendance' number for an event into the report
** If a full quarter has passed since that event, @aklapper to check for retention of attendees in that quarter by taking the usernames and email addresses from the "Newcomers" spreadsheet and following https://phabricator.wikimedia.org/T175854#3605693 (construct SQL query, run it, use output to construct search term on https://wikimedia.biterg.io, then share that URL)
* Survey analysis, Key findings:
** maintained by @srishakatux
* Link published report from https://meta.wikimedia.org/wiki/Technical_Collaboration/Onboarding_New_Developers