Research:Daily main namespace pages created by non-autoconfirmed users

From Meta, a Wikimedia project coordination wiki
Jump to navigation Jump to search
Daily main namespace pages created by non-autoconfirmed users
Specification
is a count of the number of non-redirecting page creations in namespace made by users not identified as bots and who are not members of the "autoconfirmed" user group, on date .
WMF Standard
no parameters
Measures
Status
completed Icon 100 percent.png
SQL
SET @date = "20170801";
SET @wiki = "enwiki";

SELECT
    COUNT(*) AS page_creations_main
FROM
    mediawiki_page_create_2
WHERE
    `database` = @wiki AND
    page_namespace = 0 AND
    page_is_redirect = 0 AND
    performer_user_is_bot = 0 AND
    LOCATE("autoconfirmed", performer_user_groups) = 0 AND
    rev_timestamp BETWEEN @date AND
        DATE_FORMAT(DATE_ADD(@date, INTERVAL 1 DAY), "%Y%m%d%H%i%S")


Daily main namespace pages created by non-autoconfirmed users is a standardized metric used to measure the number of non-redireting pages that are created in the main namespace (page_namespace == 0) by users who are not identified as a bot and who have not yet become members of the "autoconfirmed" user group, on a given day.

Discussion[edit]

Time lag[edit]

As this is a daily metric, a full 24 hours must elapse after the beginning of the date (UTC) in order to calculate an uncensored value.

Analysis[edit]

Discussion[edit]

Notes[edit]