Research:Attached user

This page describes the class of registered users with a new account in a given Wikimedia project but previously registered on another project.

• When a user becomes attached to a project other than the home project, a record is created in the new project database. Attached users are not genuinely "new" and should not be counted as newly registered users.
• An attached user's registration time corresponds to the time of the "attachment" event to the new project.

Attached users are logged locally on a per-project basis via MediaWiki's logging table. Attachment history is logged globally in the localuser table of the CentralAuth database.

Attached users (local)

SELECT
`log_user`ASuser_id,
`log_timestamp`ASuser_registration
FROM
enwiki.logging
WHERE
`log_type`='newusers'
AND
`log_action`='autocreate'/* only include attached users, exclude new and proxy-registered users */
AND
`log_timestamp`>='20131001000000'/* specify a datetime range */
AND
`log_timestamp`<'20131101000000'/* specify a datetime range */

• Metrics with no measured phenomena specified
• Standardized metric draft

• Pages using deprecated source tags