# Research:Daily edits by registered users

Standard metric
Daily edits by registered users
Specification
${\displaystyle {\text{daily edits by registered users}}(D)}$ is a count of the number of edits saved by non-bot-flagged registered users on date ${\displaystyle 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
rev_user = ug_user AND
ug_group = "bot"
WHERE
rev_timestamp BETWEEN @date AND
DATE_FORMAT(DATE_ADD(@date, INTERVAL 1 DAY), "%Y%m%d%H%i%S") AND
rev_user > 0 AND
ug_group IS NULL
UNION
SELECT
COUNT(*) AS revisions
FROM archive
ar_user = ug_user AND
ug_group = "bot"
WHERE
ar_timestamp BETWEEN @date AND
DATE_FORMAT(DATE_ADD(@date, INTERVAL 1 DAY), "%Y%m%d%H%i%S") AND
ar_user > 0 AND
ug_group IS NULL
) AS table_revisions;


Daily edits by registered users is a standardized metric used to measure the number of edits saved by registered users in a given day. It's used as a proxy for the rate of overall contribution.

## Discussion

### Filtering bot accounts

Bot accounts are filtered using the bot flag strategy. This allows for straightforward and efficient bot filtering, but it is also possible that unflagged bots will be counted. Given the proportion of bot editors, this should have minuscule effect on the overall count.

### 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.