Research:Daily edits

From Meta, a Wikimedia project coordination wiki
Jump to navigation Jump to search
Standard metric
Daily edits
Specification
is a count of the number of edits saved by any users on date .
WMF Standard
no parameters
Measures
Contribution
Status
completed Icon 100 percent.png
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[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.

Edits on deleted pages[edit]

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[edit]

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[edit]

Discussion[edit]

Notes[edit]