I wonder if @chelsyx and @mpopov already have this?

If not, it looks like a combination of the ServerSideAccountCreation schema and the logging table should enable us to calculate this (with the latter used to remove the autocreated accounts).

Hi @nettrom_WMF , sorry we don't have the number. Looks like ServerSideAccountCreation schema and the logging table is the way to go!

We also have MobileWikiAppLogin schema, but it only records users who agree to share their usage report with us, and the table got purged after 90 days.

I gathered data, analyzed it, and wrote it up in a work log.

Short summary: about 22–30% of registrations appear to come in through the mobile site, and it appears to be generally stable across the six month dataset I have. Arabic Wikipedia is different, with 57.5%. What type of device differs between wikis, some are 75/25 Android/iOS, while on others it's more 60/40.

• This should exclude auto-created accounts.

Proposing an exception, include accounts with more than X edits/have any non-standard rights (like autopatrolled). There are users who signed up on Commons but are mostly active (and their de-facto home wiki) is cswiki. I guess we don't want to loose those users.

@Deskana @ovasileva -- @DannyH pointed out to me that this analysis might be interesting to your teams, in which we looked at how often people create new accounts from the different platforms. The content is here in @nettrom_WMF's work log.