Content translation/Deletion statistics comparison

Data on the deletion ratio of Wikipedia articles created with and without Content Translation.

Wikis with higher deletion ratios for CX created articlesEdit

We reviewed wikis where the deletion rate of articles created with content translation is higher than the deletion rate for articles created with other tools as part of T286636 during a specified timeframe. This data is updated quarterly (every three months) to assess the evolution of deletion rates as improvements are made. This timeframe was selected to capture a sufficient time for editors to review content and limit seasonality effects.

Data comes from mediawiki_history and reflects the deletion ratios of main namespace articles that were created using Content Translation compared to the deletion ratios of main namespace articles created without the tool. Bots were excluded. We also removed wikis where 15 or fewer articles were created with content translation during the reviewed timeframe to reduce noise in the data and focus on wikis with more representative data.

SummaryEdit

Time period Overall CX articles deletion ratio 1 Overall non-CX articles deletion ratio 2 Number of wikis with higher cx article deletion ratios3 Wiki with the highest deletion ratio difference Per Wiki deletion ratio results
January 2022 - March 2022 3.1% 5.0% 13 wikis Estonian Wikipedia (29.4% cx; 11.7% non-cx) Q3 2022 wiki results
October 2021 - December 2021 2.9% 4.3% 16 wikis Lithuanian Wikipedia (47.4% cx; 15.3% non-cx) Q2 2021 wiki results
July 2021 - September 2021 2.4% 3.8% 13 wikis Javanese Wikipedia (96.2% cx; 12% non-cx) Q1 2021 wiki results
April 2021 - June 2021 3.9% 5.4% 15 wikis Moroccan Arabic Wikipedia (36% cx; 1.64% non-cx) Q4 2021 wiki results
January 2021 - March 2021 3.4% 8.9% 13 wikis Hawaiian Wikipedia (39% cx; 1.2% non-cx) Q3 2021 wiki results
1 Defined as the ratio of all deleted articles created with CX to all articles created with CX across all wikis.

2 Defined as the ratio of all deleted articles created without CX to all articles created without CX across all wikis.

3 Excludes wikis with 15 or fewer articles created with Content Translation during the reviewed time period.

Quarterly ResultsEdit

January 2022 through March 2022 (Q3 2022)Edit

Wikis with higher deletion ratios for articles created with Content Translation
Reviewed Time Period: January 2022 through March 2022 (Q3)
Wiki project1 Created Articles Deleted Articles Deletion Ratios
Created CX Articles Created non-CX Articles Deleted CX Articles Deleted non-CX Articles CX Articles Deletion Ratio Non-CX Articles Deletion Ratio Deletion Ratio Difference
etwiki 17 4503 5 528 29.41% 11.73% −17.69%
skwiki 29 2587 8 424 27.59% 16.39% −11.20%
mnwiki 17 378 11 214 64.71% 56.61% −8.09%
bewiki2 165 5291 15 99 9.09% 1.87% −7.22%
ltwiki2 31 2996 10 754 32.26% 25.17% −7.09%
astwiki 27 1833 3 105 11.11% 5.73% −5.38%
ckbwiki 69 7850 4 41 5.80% 0.52% −5.27%
eowiki 202 10469 4 67 1.98% 0.64% −1.34%
bclwiki 176 508 2 3 1.14% 0.59% −0.55%
bswiki 145 2143 7 92 4.83% 4.29% −0.53%
ttwiki 497 95099 2 33 0.40% 0.03% −0.37%
arzwiki2 659 55894 4 272 0.61% 0.49% −0.12%
skrwiki 295 526 2 3 0.68% 0.57% −0.11%
1 Excludes wikis with 15 or fewer articles created with Content Translation during the reviewed time period

2 Also identified in the prior quarter as a wiki with a higher deletion ratio for articles created with Content Translation

October 2021 through December 2021 (Q2 2021)Edit

Wikis with higher deletion ratios for articles created with Content Translation
Reviewed Time Period: October 2021 through December 2021 (Q2)
Wiki project1 Created Articles Deleted Articles Deletion Ratios
Created CX Articles Created non-CX Articles Deleted CX Articles Deleted non-CX Articles CX Articles Deletion Ratio Non-CX Articles Deletion Ratio Deletion Ratio Difference
ltwiki 38 4431 18 676 47.37% 15.26% −32.11%
lawiki2 21 1084 4 45 19.05% 4.15% −14.90%
ocwiki 20 405 2 12 10.00% 2.96% −7.04%
arzwiki 62 170066 4 219 6.45% 0.13% −6.32%
hywiki 43 2328 9 344 20.93% 14.78% −6.15%
swwiki 71 1673 4 19 5.63% 1.14% −4.50%
fiwiki2 38 8220 5 715 13.16% 8.70% −4.46%
thwiki2 69 7307 4 157 5.80% 2.15% −3.65%
mrwiki2 98 3421 5 52 5.10% 1.52% −3.58%
iswiki 20 706 2 54 10.00% 7.65% −2.35%
afwiki 82 1309 5 63 6.10% 4.81% −1.28%
nlwiki 236 14644 36 2175 15.25% 14.85% −0.40%
orwiki 150 383 5 12 3.33% 3.13% −0.20%
kmwiki 43 557 7 90 16.28% 16.16% −0.12%
bewiki 154 5133 3 95 1.95% 1.85% −0.10%
twwiki 82 274 3 10 3.66% 3.65% −0.01%
1 Excludes wikis with 15 or fewer articles created with Content Translation during the reviewed time period

2 Also identified in the prior quarter as a wiki with a higher deletion ratio for articles created with Content Translation

July 2021 through September 2021 (Q1 2021)Edit

Wikis with higher deletion ratios for articles created with Content Translation
Reviewed Time Period: July 2021 through September 2021 (Q1)
Wiki project1 Created Articles Deleted Articles Deletion Ratios
Created CX Articles Created non-CX Articles Deleted CX Articles Deleted non-CX Articles CX Articles Deletion Ratio Non-CX Articles Deletion Ratio Deletion Ratio Difference
jvwiki2 105 434 101 52 96.19% 11.98% −84.21%
kuwiki 21 12573 3 69 14.29% 0.55% −13.74%
skwiki 34 1341 9 266 26.47% 19.84% −6.63%
fawiki2 1340 57805 169 3789 12.61% 6.55% −6.06%
lvwiki 70 2224 10 232 14.29% 10.43% −3.85%
lawiki 17 958 2 77 11.76% 8.04% −3.73%
mrwiki2 66 5294 2 58 3.03% 1.10% −1.93%
thwiki 34 7722 2 316 5.88% 4.09% −1.79%
fiwiki 33 8375 3 662 9.09% 7.90% −1.19%
aswiki 25 1666 1 57 4.00% 3.42% −0.58%
zh_yuewiki 35 9546 1 218 2.86% 2.28% −0.57%
eowiki 261 7012 3 59 1.15% 0.84% −0.31%
ttwiki2 579 20023 3 43 0.52% 0.21% −0.30%
1 Excludes wikis with 15 or fewer articles created with Content Translation during the reviewed time period

2 Also identified in the prior quarter as a wiki with a higher deletion ratio for articles created with Content Translation

April 2021 through June 2021 (Q4 2021)Edit

Wikis with higher deletion ratios for articles created with Content Translation
Reviewed Time Period: April 2021 through June 2021 (Q4)
Wiki project1 Created Articles Deleted Articles Deletion Ratios
Created CX Articles Created non-CX Articles Deleted CX Articles Deleted non-CX Articles CX Articles Deletion Ratio Non-CX Articles Deletion Ratio Deletion Ratio Difference
arywiki 25 1461 9 24 36.00% 1.64% −34.36%
jvwiki 890 721 162 22 18.20% 3.05% −15.15%
kawiki2 48 4558 10 519 20.83% 11.39% −9.45%
afwiki 100 1735 10 93 10.00% 5.36% −4.64%
astwiki 37 14525 1 150 2.70% 1.03% −1.67%
mrwiki2 99 5864 2 60 2.02% 1.02% −1.00%
ttwiki 952 32396 10 22 1.05% 0.07% −0.98%
crhwiki 75 1883 1 8 1.33% 0.42% −0.91%
bewiki2 174 4215 5 87 2.87% 2.06% −0.81%
hiwiki 385 2735 93 639 24.16% 23.36% −0.79%
ckbwiki 94 3892 3 97 3.19% 2.49% −0.70%
pswiki 47 335 2 13 4.26% 3.88% −0.37%
swwiki 95 3305 2 59 2.11% 1.79% −0.32%
urwiki 132 3043 7 158 5.30% 5.19% −0.11%
fawiki 1897 81694 110 4699 5.80% 5.75% −0.05%
1 Excludes wikis with 15 or fewer articles created with Content Translation during the reviewed time period

2 Also identified in the prior quarter as a wiki with a higher deletion ratio for articles created with Content Translation

January 2021 through March 2021 (Q3 2021)Edit

Wikis with higher deletion ratios for articles created with Content Translation
Reviewed Time Period: January 2021 through March 2021 (Q3)
Wiki project1 Created Articles Deleted Articles Deletion Ratios
Created CX Articles Created non-CX Articles Deleted CX Articles Deleted non-CX Articles CX Articles Deletion Ratio Non-CX Articles Deletion Ratio Deletion Ratio Difference
hawwiki 64 85 25 1 39.06% 1.18% −37.89%
kuwiki 204 4011 34 69 16.67% 1.72% −14.95%
lawiki 25 923 3 48 12.00% 5.20% −6.80%
ltwiki 23 2272 13 1135 56.52% 49.96% −6.57%
fiwiki 83 9448 12 787 14.46% 8.33% −6.13%
fiu_vrowiki 16 131 1 4 6.25% 3.05% −3.20%
eowiki 123 5221 5 62 4.07% 1.19% −2.88%
kawiki 122 5434 23 889 18.85% 16.36% −2.49%
arzwiki 110 37033 3 335 2.73% 0.90% −1.82%
thwiki 17 4635 1 208 5.88% 4.49% −1.39%
bewiki 256 5225 9 115 3.52% 2.20% −1.31%
mrwiki 164 4771 3 60 1.83% 1.26% −0.57%
bswiki 52 1953 5 187 9.62% 9.58% −0.04%
1 Excludes wikis with 15 or fewer articles created with Content Translation during the reviewed time period

Monthly deletion ratios for representative wikis (Jan 2016 - Jan 2019)Edit

Monthly data about the deletion of articles created with and without Content Translation on several Wikipedias was prepared as part of T215397. This data is for whole months, not quarters, from January 2016 until January 2019.

The results can be found in a Google spreadsheet.

This spreadsheet is publicly shared and can be filtered, copied, etc. Note that only pages in the main namespace are counted. This may lead to discrepancies between this data and the data at Special:CXStats, which includes all namespaces.

The queryEdit

To examine the queries used to created and to run this yourself, see query 53775 in Quarry. To look at different languages and dates, replace the database name and the timestamp value.