GitHub PR: https://github.com/WikipediaLibrary/TWLight/pull/1465

Not waiting on patch changes necessarily, rather some investigation/decision making

I was going to file a separate data analysis ticket, but because the queries ending up seeming fairly straightforward:

Of the 35,861 English Wikipedia editors who made an edit in the last 6 months and pass the 500 edit / 6 month editing baseline, 4,310 (12%) have disabled the preference enabling them to be emailed through EmailUser. Posting the queries here for reference / in case I did anything obviously wrong:

All 'active' qualifying users

SELECT DISTINCT event_user_id FROM wmf.mediawiki_history
WHERE snapshot = '2025-07'
AND wiki_db = 'enwiki'
AND event_user_registration_timestamp < '2025-02-21'
AND event_user_revision_count > 500
AND event_timestamp > '2025-02-21'

All users with email disabled

SELECT up_user
FROM wmf_raw.mediawiki_user_properties
WHERE snapshot = '2025-07'
AND wiki_db = 'enwiki'
AND up_property = 'disablemail'
AND up_value = '1'

One question I have, because it occurs to me I might have got my wires crossed with T355547, is do we need to send users any emails in this way, or is this all about internal notifications?

In T383070#11107685, @Samwalton9-WMF wrote:

One question I have, because it occurs to me I might have got my wires crossed with T355547, is do we need to send users any emails in this way, or is this all about internal notifications?

Enotif is a separate solution, so doing it this way is mutually exclusive to echo.

In T383070#11119481, @jsn.sherman wrote:

In T383070#11107685, @Samwalton9-WMF wrote:

One question I have, because it occurs to me I might have got my wires crossed with T355547, is do we need to send users any emails in this way, or is this all about internal notifications?

Enotif is a separate solution, so doing it this way is mutually exclusive to echo.

That makes sense, but I'm more asking if this EmailUser API spike is limited to the case where we need to email @wikimedia.org, or if we might also use this approach for users.

No, this is for any wiki account that can receive email, eg. through Special:EmailUser.

@Samwalton9-WMF, if you would like to move forward for this approach, let's create a new task for it and base it on Susana's work here. Either way, can we close this out?