Research:Daily edits

Daily edits

Specification

${\text{daily edits}}(D)$ is a count of the number of edits saved by any users on date

D

.

WMF Standard

no parameters

Measures

Contribution

Status

completed

SQL

SET @date = "20140101";

SELECT
    SUM(revisions) AS revisions
FROM (
    SELECT
        COUNT(*) AS revisions
    FROM revision
    WHERE
        rev_timestamp BETWEEN @date AND
            DATE_FORMAT(DATE_ADD(@date, INTERVAL 1 DAY), "%Y%m%d%H%i%S") 
    UNION ALL
    SELECT
        COUNT(*) AS revisions
    FROM archive
    WHERE
        ar_timestamp BETWEEN @date AND
            DATE_FORMAT(DATE_ADD(@date, INTERVAL 1 DAY), "%Y%m%d%H%i%S") 
) AS all_revisions;

Discussion

Time lag

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.

Edits on deleted pages

This metric includes edits on existing pages as well as pages that have been or will later be deleted. This allows us to define a metric as stateless, in other words historical values will not change in the future depending on the status of a page (existing/deleted/moved) at the time the metric is computed. Deletion-related activity is tracked via a separate set of metrics.

Edits across all namespaces

This metric counts activity across all namespaces of a project: whether an edit is a new page creation, a revision to an existing page or a draft, a message left on a talk page or a contribution to a Wikiproject, the edit is counted as a contribution to the project. The metrics is agnostic about the quality, size or purpose of the edit. Specific types of contribution are measured via dedicated metrics or breakdowns.

Analysis

Discussion

Notes