Background

WMDE reporting instructions for strategic goals prescribe the Cloud team to provide measurements of # of people directly or indirectly connected through services provided by WMDE.

According to instructions, we should be counting *"users of tools and platforms provided by WMDE that enable interaction, exchange, or collaboration between multiple people (e.g. returning Wikidata editors)"* and should not be counting *"mere reach metrics (e.g., website visits, social media impressions)"*.

After consultation with the driver of this reporting, we agreed that Cloud will provide the number of wiki users registered on Cloud who actually made a contribution.

The problem is most of the users registered on Cloud are spambots.
By analyzing the population of the top 10 Wikibases that have the most users, we identified that a good way to filter out the spambots is to only consider users who made at least 3 edits. This will be our interpretation of the indicator.

Task

Take measurements of # of qualifying users (at least 3 edits) who registered on Cloud by end of 2022, 2023, 2024, 2025 across all Wikibases on Cloud (including deleted ones).
For simplicity, we won't care about the date when the edits were actually made.

Example of a code that could be used to find a number for a single DB:

SET @db     = 'mwdb_9834829bc6';
SET @prefix = 'mwt_dae5ce376e';
SET @min_edits = 3;                 -- count users with editcount >= this
SET @ts = '20251231235959';         -- registered before 2025 ended

SET @sql = CONCAT(
  'SELECT COUNT(*) AS users_count
   FROM `', @db, '`.`', @prefix, '_user` u
   WHERE u.user_editcount >= ', @min_edits, '
     AND u.user_registration <= ', QUOTE(@ts),
  ';'
);

PREPARE stmt FROM @sql;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;

Acceptance Criteria

• A list of for measurements is provided that shows how the # of users grew over 4 years, for example:

2022 - 10
2023 - 24
2024 - 55
2025 - 122

• The script is saved, so we could take measurements each year going forward.