@TBolliger Probably only want to look at full protection for the information we are trying to obtain. https://meta.wikimedia.org/wiki/Help:Protection

Something else to think about — probably for a different task — is how can we measure protections that are modified? How often does page protection escalate from none to semi and then from semi to full. On English Wikipedia there is also extended between semi & full.

We could also determine the amount of time between these escalations, the number of edits, the topics of these pages, etc. There's a lot to explore.

Way out of scope for this task but this kind of data and the slices you want to look at would be PERFECT for an ELK stack. You could even have a dashboard that showed these numbers in real-time.

Specific technology aside, it does look like we could do this in a way that is repeatable and mildly configurable by an end user of the data: https://wikitech.wikimedia.org/wiki/Analytics/Tutorials/Dashboards

In T195202#4670814, @aezell wrote:

Way out of scope for this task but this kind of data and the slices you want to look at would be PERFECT for an ELK[1] stack. You could even have a dashboard that showed these numbers in real-time.

Specific technology aside, it does look like we could do this in a way that is repeatable and mildly configurable by an end user of the data: https://wikitech.wikimedia.org/wiki/Analytics/Tutorials/Dashboards

That would probably be in scope for T206023: AHT: Implement weekly reports about Page Protection usage!

@TBolliger Take a look and see if this is the data you were expecting: https://docs.google.com/spreadsheets/d/1ORQKUYUa0XaCDCfB-2tJGSlyXBopRkF0k5JbWu6OKcQ/edit?usp=sharing

In T195202#4671457, @aezell wrote:

@TBolliger Take a look and see if this is the data you were expecting: https://docs.google.com/spreadsheets/d/1ORQKUYUa0XaCDCfB-2tJGSlyXBopRkF0k5JbWu6OKcQ/edit?usp=sharing

Yes, this is exactly the presentation I was expecting. I was anticipating more weekly protections, but it sounds reasonable. Would appreciate @SPoore to double check.

I looked at the protection log on Italian Wikipedia and made this rudimentary spreadsheet to count protection actions by namespace. It shows 93 mainspace actions and your data shows 70. I'll do a little more digging to see why there's a difference of 23 and post another comment.

I can't quite figure out exactly what's wrong, but my best guess is that your script is missing protections for full protection (admin) with indefinite expiration. Your spreadsheet only shows 2 full protection and 68 semi, while mine shows 42/49. Different namespace could also be at play.

Here are the other potential factors:

• create vs. edit/protect
• admin vs autoconfirmed (full/semi)
• expiration
• duplicate pagenames
• namespace

I just looked at some of the raw data instead of the counts and I need to redo these queries. It's definitely not correct.

Let me work on it a bit more.

Protections set this week

From October 11 to October 18, this many page protections were set:

Active protections

As of today, this many pages are currently protected:

Distributions of protection expirations

For all the wikis we generated data on, there was a high cluster of protections for a month or shorter, then clusters 6, 12, and 24 months later. Not many were of indefinite length.

On English Wikipedia most page edit protections (67%) are for the 30 days are shorter, but you can see a small patch that are 6 months, then 12 months, then 2 years, then 3 years. And only 8% are indefinite length

Other data:

• only 0.25% of all content pages on ENWP are protected right now, 0.11% for German Wikipedia