Link to the document under data dictionary: https://www.mediawiki.org/wiki/Wikimedia_Product/Data_dictionary/Reconcile_datasets_in_Superset_with_Key_Product_Metrics

Updated sample query and the code used to transform raw data into intermediate table.

Updated the document and linked it with relevant pages.

Got the reply from Carol that she will stick to the numbers in the deck to avoid messing up the model.
Another note is, the definition for "established" markets in the deck is US, CA, JP, and Europe

Session length dashboard with production data :

Reopen this for the optimized intermediate session length data set mentioned in T277512.

Data dictionary for session_length_daily table is available here: https://www.mediawiki.org/wiki/Wikimedia_Product/Data_dictionary/session_length_daily

Reviewed dashboard with Kate.

Link to ashboard with production dataset (wmf.session_length_daily): https://superset.wikimedia.org/r/495.

The sample rate for dashboard was updated to 1/10.

@hdothiduc thanks for pointing this out. the pageviews for #1 article in Chinese Wikipedia has one more digit by mistake. I've updated the number in the file.

The platform evolution/structured data metrics were added to key product metrics slides in January, with chart for each metric (slides).

Switch the data source for dashboard to session_length_daily table.

@hdothiduc It sounds good to me.

In Superset data table session_length:

Hi @hdothiduc, the full year data for 2020 is updated in here.

Presented at Q2 Tuning session

Hi @Arrbee, please find pageviews breakdown by topics for Q2/2020 and Q2/2019.

@Cdesoto705 Thanks for submitting a ticket. The Product Analytics will review and prioritize this request during our next board review meeting tomorrow 12 January 2021.

project and project family filter added to the editors dashboard in Superset.

@EdErhart-WMF here's the updated data for page and pageviews between 2020/01/01 - 2020/12/15

After reviewing the feedback with Kate, we want to have aggregation for each level of topics.
The next step is to create another table to use in Superset based on this schema.

FY20-21 Q2 Superset Updates email sent out today.

Added cchen.repo_topic_pv_edit table as a data source in Superset. And created monthly topic pageviews and edits dashboard in Superset.

Top pages with pageviews and edits by wiki were update in this folder. We reviewed text and notes for the data this week.

Dataset: cchen.article_pv_edit with monthly data from 2020/06- 2020/11 from top 23 Wikipedias.