T362211#9903480 reports a tiny amount of logo deletion requests out of all Upload Wizard's uploads (see UW_logo_drs_within_30_days versus UW_all columns).
This suggests that UW might not be the main source of logo uploads.
Therefore, we should take into account other upload tools, e.g., Visual Editor.
CC @cchen.
Tasks
- retrieve edit tags that correspond to other upload tools. UW seems to have ct_tag_id=12
- re-use relevant parts of this notebook to compute counts of other tools
Tools considered
| name | Edit tag ID | # edits |
| Upload Wizard | 12 | 24,885,182 |
| OAuth Uploader * | 37 | 6,406,377 |
| improved old upload form | 19 | 2,697,046 |
| Cross-wiki upload | 17 | 1,823,387 |
| FileImporter | 424 | 1,209,076 |
| CropTool 1.5 (latest version) | 486 | 930,297 |
* CommonsHelper + Flickr2Commons + Url2Commons + geograph2commons
See T368167#9939792 for more details.
Method
- input: edit tag ID; deletion requests (DR) dataset as per this script
- gather all deleted and non-deleted file uploads
- with a DR created within 30 days
- maybe with a deletion edit comment
- that have a case-insensitive logo occurrence in the page title or DR title or DR opening reason or DR closing reason or deletion edit comment
Results
The tables below show the percentage of files with DRs and/or deletions due to logo reasons. The percentage is computed against total uploads.
We report a 6-month average and a random`2024-04` snapshot for the sake of comparison with the average.
NOTE: The percentage takes into account open and/or closed DRs, plus files deleted without a DR. See with_logo_dr and deleted_without_dr in detailed results at T368167#9956995 and T368167#9959868.
Average
From 2023-11 to 2024-04.
| edit tag | total uploads | logo % |
| Cross-wiki upload | 17k | 0.5 |
| mobile edit | 80k | 0.29 |
| FileImporter | 1.9k | 0.14 |
| Upload Wizard | 360k | 0.13 |
| improved old form | 39k | 0.05 |
| CropTool 1.5 | 19k | 0.02 |
2024-04
| edit tag | total uploads | logo % |
| Cross-wiki upload | 17k | 0.26 |
| mobile edit | 67k | 0.23 |
| Upload Wizard | 399k | 0.08 |
| FileImporter | 1.3k | 0.07 |
| CropTool | 18k | 0.03 |
| improved old form | 39k | 0.005 |
Detailed results
See T368167#9956995 and T368167#9959868.
Conclusion
- Cross-wiki upload is the tool with the highest percentage of logo-related DRs/deletions
- Mobile edit has way more uploads and has the 2nd highest percentage. According to https://commons.wikimedia.org/wiki/Special:Tags, this edit tag can also indicate edits from the (Android) app
- compared to initial metrics, we report an increase in Upload Wizard's logo DR percentage, likely due to the expanded scope of the query, i.e., case-insensitive and more fields: for e.g., 2024-03, 0.082 in T368167#9956995 VS 0.025 in T362211#9903480 (cf. % logo DRs within 30 days column)