Thanks for your input, Sam.

Looking at all wikipedias projects, non-reverted edits (excluding bot and revert edits) increased significantly in the last year. For 20/21 Q2, the monthly average increased 1.3M (13.5%) YoY.

Move to "Needs Sign-off".
@JAnstee_WMF, let me know if you have any questions.

We excluded the revert edits in order to measure the net edits by human users, excluding any edits created due to vandalism. In summary, the YoY trend of net edits is not clear. Net edits reduced in some months but also grew in some months. Net content edits decreased every month. Please find the details below.

@ifried, Sure. Also, I added 'Product-Analytics' tag to this ticket so that it is under our team's radar.

@ifried, is it a task you want product analytics team to take on?

@GoEThe, good point.

@Albertoleoncio , I created a sub-task ( https://phabricator.wikimedia.org/T277715) to track any findings in the number of protected pages.

Document changes here. @JAnstee_WMF
Monthly editors, monthly active editors, monthly new active editors, and unique devices per editor (Column H, I, L,G in datasheet ‘Dec 2020’ ) were updated on Feb 26, 2021.

Sure. Close the ticket.

Summary of Metric Differences

Unique devices
First, product metrics only report unique devices of one project family: wikipedia. Wiki comparison report 16 project families: wikipedia, commons, incubator, foundation, mediawiki, meta, sources, species,wikibooks, wikidata, wikinews,, wikiquote, wikisource, wikiversity, wikivoyage, and wiktionary.

Thanks. I have updated the column names in 2020 datasheet.

I reviewed update history on github. I have not found any change records for overall size rank, second month editor retention, monthly structured discussions messages in update history after December 2019. @nshahquinn-wmf , want to double check with you for the consistency of the query definition before I update the table, in case I overlooked something. Thanks.

Don't forget to push your important bug fix to the repo 😊

Have enabled in weekly report.

Have reviewed the result with Niharika today.

Data of 2020 has been added to wiki comparison tool.

When we monitor the impact of tuning off IP editing, we are especially interested in the impact on edits by human editors (anonymous editors and registered editors ). The fluctuation of edits by bots possibly mislead the Year over Year comparison. We'd like to see the YoY trend of edits without the bot edits.

@Chicocvenancio, I created a sub-task ( https://phabricator.wikimedia.org/T273518) for your request.

Have reviewed @ifried . Marked it as resolved.

@kaldari thanks for the suggestion. I have added quantitative summary in description.
Observations by the end of November 2020 (Week 48th)
After turning off IP editing on ptwiki, we saw:

• a 57% YoY increase in active registered editors
• a 20% YoY increase in new accounts
• a 10% YoY decrease in total edits
• a 50% YoY decrease in reverts
• a 3% YoY decrease in non-reverted edits
• a 85% YoY decrease in blocks

@NNair has confirmed that she is OK with the received data. So mark it as resolved.

@Samwilson, totally understand. Thanks for sharing.

@NNair, I have shared data via your original email. Let me know if you have any questions.

@Samwilson, I am curious what the pros and cons are to store data on a user created database on Toolforge, compared with the other options, like product mariadb or eventlogging database, from a developer's perspective?

Connie in Product Analytics team has enabled project_filter and project_family_filter on editors self-serve dashboard. Now we are able to see the total number of active editors by wikisource only and individual wikisource project.
Dashboard link: https://superset.wikimedia.org/r/410

I explored ORES damage scores of edits on ptwiki. Here are my findings.

Thanks for the review and suggestion. Mark it as resolved.

Mark it as resolved. Feel free to open if you have more questions, @Cdesoto705 .