Research:Daily main namespace pages created by bots

From Meta, a Wikimedia project coordination wiki
Jump to navigation Jump to search
Daily main namespace pages created by bots
Specification
is a count of the number of page creations in namespace on date that were created by users identified as bots.
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
    performer_user_is_bot = 1 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 bots is a standardized metric used to measure the number of pages that are created in the main namespace (page_namespace == 0) by users identified as bots (performer_user_is_bot == 1) 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]