Page MenuHomePhabricator

[SPIKE] What projects do volunteers from Sub-Saharan African edit most?
Closed, ResolvedPublic

Description

For the 2022-2023 fiscal year, the Editing Team is considering centering the work we will do around people A) who are contributing to a Wikipedia from sub-Saharan Africa and B) who have made fewer than 100 cumulative edits to Wikipedia.

Before moving forward with defining the audience in the ways "A)" and "B)" describe, we would like to understand:

  1. What language Wikipedias the people who are contributing from sub-Saharan Africa and who have made fewer than 100 cumulative edits are most active with?
    • Knowing the above will help us determine what projects we will consider partnering most closely with in the 2022-2023 fiscal year.
  2. On average, how many people from sub-Saharan Africa during a given month are making their first edit to Wikipedia as an account holder?
    • Knowing the above will help us determine how long we can expect the quantitative analyses we have planned to reach statistic significance.

Open questions

  • 1. What language Wikipedias do the people who are contributing from sub-Saharan Africa and who have made fewer than 100 cumulative edits, edit most?
  • 2. On average, how many people from sub-Saharan Africa during a given month are making their first edit to Wikipedia as an account holder?
  • 3. Of the people who edit Wikipedia from Sub-Saharan Africa each month, what percentage of edits do they make using a mobile phone, tablet, and desktop?

Done

  • Answers to all ===Open questions are documented

References

Event Timeline

MNeisler triaged this task as Medium priority.Jun 10 2022, 1:49 PM
MNeisler edited projects, added Product-Analytics (Kanban); removed Product-Analytics.
MNeisler moved this task from Next 2 weeks to Doing on the Product-Analytics (Kanban) board.
ppelberg renamed this task from [SPIKE] How many people does the to [SPIKE] What projects do volunteers from Sub-Saharan African edit most? .Jun 10 2022, 4:36 PM

@ppelberg
Answers to the open questions:

What language Wikipedias the people who are contributing from sub-Saharan Africa and who have made fewer than 100 cumulative edits are most active with?

Here are the top 15 language Wikipedia Projects that contributors with under 100 edits from sub-Saharan Africa contribute to (Data from May 2022):

projectn_editorspct_editors
enwiki301768.17%
frwiki71116.06%
ptwiki1433.23%
arwiki972.19%
swwiki671.51%
igwiki410.93%
hawiki370.84%
simplewiki320.72%
yowiki220.5%
dewiki210.47%
rwwiki210.47%
afwiki180.41%
sowiki140.32%
twwiki130.29%
eswiki120.27%

On average, how many people from sub-Saharan Africa during a given month are making their first edit to Wikipedia as an account holder?

There are 3,006 average monthly distinct registered, first-time editors to Wikipedia from sub-Saharan Africa.

Notes:

  • This reflects the average across only April and May 2022 as identifying the geo location of first-time editors required the use of the editors_daily dataset which only retains data for 90 days.
  • First-time registered editors are defined here as logged-in editors whose cumulative edit count to a Wikipedia project at the time of their published edit is 0.
  • Limited analysis to only editors of Wikipedia projects (i.e. did not look at wiktionary, wikibooks projects etc)

Superset Dashboard
You can view further details on the number of distinct sub-Saharan Africa editors by various projects and Sub-Saharan African countries using this dashboard. Note: This reflects editors across all experience levels as there's not an easy way to access cumulative edit count within the available Superset datasets.

Looks great, @MNeisler.

Next step

  • Per the conversation we had today, we are going to update the superset dashboard to always include data from the most recent 90 days.

Per the conversation we had today, we are going to update the superset dashboard to always include data from the most recent 90 days.

Upon further review, I realized that we do not purge the data that was used to create the Superset dashboard for this task (Geoeditors_Monthly). This data is aggregated and can be retained permanently. As result, we can review data for longer than 90 days. I updated the dashboard to clarfiy the reflected timelines for each chart and added a year over year time series chart to see how the monthly distinct editors in Sub-Saharan Africa have changed over time.

The filter box on the dashboard can be used to view the monthly distinct editors by country and/or project.

The data reported in T310322#8023245, which includes first-time editor and user experience info, is based on the raw data source and only reflects the last 60 days in accordance with the dataset's retention guidelines.

@ppelberg - Please let me know if you have questions or suggested updates. You should also have access to the dashboard if there are any changes you wish to make directly.