Page MenuHomePhabricator

[Scarper] Track “Number of active editors (1 or more edits in the past 30 days)”
Closed, ResolvedPublic

Description

Current Situation:

  • Wikidata tracks the number of active editors with 1 or more edits in the past 30 days.
  • Wikibase Cloud does not currently track this exact metric but has a ticket open to begin doing so. They intend to track monthly casual and active users separately, counting all actions (not just edits) and excluding bots.
  • Wikibase Suite shows active editors from a special stats page, but this does not align with the "1 or more edits" threshold and may use different logic or definitions.
  • We have access to the wbs meta data pipeline, but it is unclear whether this metric is currently calculated in parity with other teams.

Goal:

  • Confirm whether Wikibase Suite is currently tracking the number of active editors (defined as users with 1 or more edits in the past 30 days).
  • If not, adjust or add tracking logic via the wbs meta data pipeline to ensure alignment with the approach used in Wikidata and proposed in Wikibase Cloud.
  • Flag differences in definition or logic and propose next steps for harmonization.

Acceptance Criteria:

  • Confirm whether active editor count (1+ edits in last 30 days) is being tracked.
  • Ensure the following logic is applied (or document how our implementation differs):
    • Rolling 30-day window not a thing anymore
    • User must have made at least 1 edits
    • Only human editors (exclude bots)
  • If current tracking is not aligned, update or extend the wbs meta data pipeline logic.
  • Submit metric output at both:
    • Per-instance level (e.g. per Suite deployment)
    • Aggregated macro level (e.g. across Suite deployments)
  • Document current calculation method if different from the standard definition and share options with PM for feedback.

Notes:

  • Wikibase Suite’s current stats page uses a broader definition of "active editor" that may include users with only 1 edit.
  • There is a TODO note in the image to review how logs-based calculations currently work—this should be included in the investigation.

Event Timeline

jon_amar-WMDE triaged this task as Medium priority.
Leif_WMDE raised the priority of this task from Medium to High.Jul 2 2025, 8:16 AM
Leif_WMDE renamed this task from Track “Number of active editors (5 or more edits in the past 30 days)” to Track “Number of active editors (1 or more edits in the past 30 days)”.Jul 22 2025, 2:08 PM
Leif_WMDE renamed this task from Track “Number of active editors (1 or more edits in the past 30 days)” to [Scarper] Track “Number of active editors (1 or more edits in the past 30 days)”.Jul 24 2025, 2:10 PM
roti_WMDE changed the task status from Open to In Progress.Jul 28 2025, 1:14 PM

https://github.com/wmde/wikibase-metadata/pull/89

Bot identification relies on flags reported by MediaWiki recent changes API

https://www.mediawiki.org/wiki/API:RecentChanges

While we have been at it, bot change tracking has been added too.