Since we can't measure/marrow down to sub-topics such as Biographies & Women's Health, Climate & Sustainability, I used the content_gap_metrics database to access quality articles in different categories for a snapshot for February 2024 for some wikis. referring the queries from movement metrics.

In wikistories_consumption_event, referrer_type = "shared_link" if the story view or story impression is from a shared link

• No events were found in the table using the following query. and the referrer_type column is NULL for all the events.

select * from event.mediawiki_wikistories_consumption_event where referrer_type = "shared_link" and year = 2024 and month = 4

• but I was able to find the story views from shares in wmf.pageview_actor using the following query.

select cast(substr(dt,1,10) AS DATE), count(*) from pageview_actor 
where year = 2024 and month = 4 AND uri_host = 'id.wikipedia.org' AND uri_query like '%action=storyview%'
group by cast(substr(dt,1,10) AS DATE)
`

Caption:

• During the upload process, 24.6% of uploads have single-language captions, 21.6% of uploads have multi-language captions, 53.8% of uploads have no captions.

The report for the analysis is https://conniecc1.quarto.pub/wiki-highlights-experment-analysis/

Add query for users with EmailUser enabled for future reference.

@hashar Thank you so much! It works now!

Usage of caption vs description. Also usage of whether people add other languages.

• Over 99% of uploads have descriptions, and 51.7% of them are in English.
• 46.2% of uploads have captions, and 53.8% of them are in English.

Confirmed the webrequest data in analytics table:

Here's a summary of Wikistories editors analysis:

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

@SBisson sounds good, other proposed changes look good to me.

@SBisson can we keep both dt and meta.dt?

Adding the deletion rate we had in T337466 for reference.

Upload wizard uploads in December 2023:

Following are the stats for upload wizard uploads in January 2024:

For testing, @PWaigi-WMF did some shares and opened shared links today.

Deletion rate for cross-wiki uploads by wikis, below is a list of wikis with the most number of cross-wiki uploads:

Updating recent 3 month KaiOS app stats

@BTullis just tried the test case again, and it works for me now. Thank you!

@Jelto I just reset wikitech account. Superset, hue and Jupyterhub access all work now. thank you!

I still not able to access Superset & Hue, and i tried to reset my password again, still not working.

@Dzahn Oh, I see. I found the email and reran the kinit with the temporary password, it works now.

I ssh the stats machine and kinit, and got `Password incorrect while getting initial credentials. and I also tried JupyterHub, and it also showed "Invalid username or password".

@MoritzMuehlenhoff thank you for helping me restoring my access!

QA summary of test data by 2023-11-30 updated in the description.

Instrumentation approved by legal and privacy review.

In T348613#9303544, @mpopov wrote:

@cchen @PWaigi-WMF: can you please confirm that Legal & Security reviewed and approved the data collection / measurement plan for this experiment?

conflict.

@SBisson I've submitted updates to the schemas.

Below is the deletion and upload data from June 2023 - August 2023, the numbers exclude bot and mobile uploads.

@SBisson thanks for reviewing the requirements. I will go ahead and update the ticket and the schema.

Completed the review of 4 schemas in the google sheet:

• wikistories consumption event
• wikistories contribution event
• mediasearch interaction
• searchpreview

Future data will be updated in this sheet https://docs.google.com/spreadsheets/d/1qR6yPFktt-DTfETFJD50a2ooVbPe6Ad9m1S3fEdK2kE/edit#gid=0