Change Details

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 [x] retrieve edit tags that correspond to other upload tools. UW seems to have `ct_tag_id=12` [x] re-use relevant parts of [this notebook](https://gitlab.wikimedia.org/cparle/notebooks/-/blob/main/T348845.ipynb) to compute counts of other tools --- ==Tools considered | **name** | **Edit tag ID** | **# edits** | | Upload Wizard | 12 | 24,885,182 | | [OAuth Uploader](https://commons.wikimedia.org/wiki/Commons:OAuth_Uploader) `*` | 37 | 6,406,377 | | [improved old upload form](https://commons.wikimedia.org/wiki/MediaWiki:UploadForm.js/Documentation) | 19 | 2,697,046 | | Cross-wiki upload | 17 | 1,823,387 | | [FileImporter](https://commons.wikimedia.org/wiki/Commons:Upload_tools#FileImporter) | 424 | 1,209,076 | | [CropTool](https://commons.wikimedia.org/wiki/Commons:CropTool) 1.5 (latest version) | 486 | 930,297 | `*` [CommonsHelper](https://iw.toolforge.org/commonshelper) + [Flickr2Commons](https://commons.wikimedia.org/wiki/Commons:Flickr2Commons) + [Url2Commons](https://iw.toolforge.org/url2commons) + [geograph2commons](https://iw.toolforge.org/geograph2commons) See T368167#9939792 for more details.

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 [x] retrieve edit tags that correspond to other upload tools. UW seems to have `ct_tag_id=12` [x] re-use relevant parts of [this notebook](https://gitlab.wikimedia.org/cparle/notebooks/-/blob/main/T348845.ipynb) to compute counts of other tools --- ==Tools considered | **name** | **Edit tag ID** | **# edits** | | Upload Wizard | 12 | 24,885,182 | | [OAuth Uploader](https://commons.wikimedia.org/wiki/Commons:OAuth_Uploader) `*` | 37 | 6,406,377 | | [improved old upload form](https://commons.wikimedia.org/wiki/MediaWiki:UploadForm.js/Documentation) | 19 | 2,697,046 | | Cross-wiki upload | 17 | 1,823,387 | | [FileImporter](https://commons.wikimedia.org/wiki/Commons:Upload_tools#FileImporter) | 424 | 1,209,076 | | [CropTool](https://commons.wikimedia.org/wiki/Commons:CropTool) 1.5 (latest version) | 486 | 930,297 | `*` [CommonsHelper](https://iw.toolforge.org/commonshelper) + [Flickr2Commons](https://commons.wikimedia.org/wiki/Commons:Flickr2Commons) + [Url2Commons](https://iw.toolforge.org/url2commons) + [geograph2commons](https://iw.toolforge.org/geograph2commons) See T368167#9939792 for more details. ==Method - input: edit tag ID; deletion requests (DR) dataset as per [this script](https://gitlab.wikimedia.org/mfossati/scriptz/-/blob/977df47f5281bf9f95bbc9cdda04a705978e85d2/extract_commons_deletion_requests.py) - 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)

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 [x] retrieve edit tags that correspond to other upload tools. UW seems to have `ct_tag_id=12` [x] re-use relevant parts of [this notebook](https://gitlab.wikimedia.org/cparle/notebooks/-/blob/main/T348845.ipynb) to compute counts of other tools --- ==Tools considered | **name** | **Edit tag ID** | **# edits** | | Upload Wizard | 12 | 24,885,182 | | [OAuth Uploader](https://commons.wikimedia.org/wiki/Commons:OAuth_Uploader) `*` | 37 | 6,406,377 | | [improved old upload form](https://commons.wikimedia.org/wiki/MediaWiki:UploadForm.js/Documentation) | 19 | 2,697,046 | | Cross-wiki upload | 17 | 1,823,387 | | [FileImporter](https://commons.wikimedia.org/wiki/Commons:Upload_tools#FileImporter) | 424 | 1,209,076 | | [CropTool](https://commons.wikimedia.org/wiki/Commons:CropTool) 1.5 (latest version) | 486 | 930,297 | `*` [CommonsHelper](https://iw.toolforge.org/commonshelper) + [Flickr2Commons](https://commons.wikimedia.org/wiki/Commons:Flickr2Commons) + [Url2Commons](https://iw.toolforge.org/url2commons) + [geograph2commons](https://iw.toolforge.org/geograph2commons) See T368167#9939792 for more details. ==Method - input: edit tag ID; deletion requests (DR) dataset as per [this script](https://gitlab.wikimedia.org/mfossati/scriptz/-/blob/977df47f5281bf9f95bbc9cdda04a705978e85d2/extract_commons_deletion_requests.py) - 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)