Research:Daily main namespace pages created by bots
Appearance
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
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.