Retrieve list of users for cross-wiki uploads research
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	cchen
	Feb 27 2024, 9:15 PM

Description

As part of Cross-wiki media upload research we have a goal to understand the current user behavior for uploading media through Wikipedia editor so that we can identify what might be contributing to the problematic media uploads that moderators are seeing on Commons.

Requirements:

users who uploaded their cross-wiki uploads within the past 60 days
target wiki: English and Arabic
restricting to those who have email user enabled

List of users in this spreadsheet: https://docs.google.com/spreadsheets/d/1vBC-t1Rii8kTs4aVddW4RKDI85YlVzxG-_D9ebn4V34/edit#gid=0

Event Timeline

cchen created this task.Feb 27 2024, 9:15 PM

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptFeb 27 2024, 9:15 PM

cchen triaged this task as Medium priority.Feb 27 2024, 9:15 PM

cchen moved this task from Next 2 weeks to Doing on the Product-Analytics (Kanban) board.

Sneha added a subscriber: Bethany.Feb 27 2024, 9:24 PM

cchen updated the task description. (Show Details)Feb 27 2024, 9:37 PM

cchen updated the task description. (Show Details)Mar 3 2024, 7:09 AM

I updated a list of users for cross-wiki uploads. The data is from 2023-12-01 to 2024-01-31.

English Wikipedia: https://docs.google.com/spreadsheets/d/1vBC-t1Rii8kTs4aVddW4RKDI85YlVzxG-_D9ebn4V34/edit#gid=1461725814

Arabic Wikipedia: https://docs.google.com/spreadsheets/d/1vBC-t1Rii8kTs4aVddW4RKDI85YlVzxG-_D9ebn4V34/edit#gid=600676115

AUgolnikova-WMF moved this task from Triage to Analytics on the Structured-Data-Backlog board.Mar 4 2024, 5:34 PM

Add query for users with EmailUser enabled for future reference.

WITH mail AS (
SELECT up_property AS mail,
    up_value AS mail_value,
    up_user AS user_id
FROM user_properties
WHERE up_property = 'disablemail'
)   
    
SELECT
        u.user_id,
        u.user_name,
        u.user_editcount
FROM user u 
LEFT JOIN mail m ON m.user_id = u.user_id
WHERE user_email IS NOT NULL
  AND user_email_authenticated IS NOT NULL
  AND mail_value IS NULL
  AND user_editcount > 0

cchen closed this task as Resolved.Apr 9 2024, 2:47 PM

Retrieve list of users for cross-wiki uploads researchClosed, ResolvedPublicActions

Description

Event Timeline

Retrieve list of users for cross-wiki uploads research
Closed, ResolvedPublic
Actions