Tue, Apr 13
Link to the document under data dictionary: https://www.mediawiki.org/wiki/Wikimedia_Product/Data_dictionary/Reconcile_datasets_in_Superset_with_Key_Product_Metrics
Wed, Apr 7
Updated sample query and the code used to transform raw data into intermediate table.
Tue, Apr 6
Updated the document and linked it with relevant pages.
Mon, Apr 5
Thu, Apr 1
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
Wed, Mar 31
Thu, Mar 25
Session length dashboard with production data :
Mon, Mar 22
Fri, Mar 19
Thu, Mar 18
Mar 16 2021
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
Mar 15 2021
Reviewed dashboard with Kate.
Mar 12 2021
Link to ashboard with production dataset (wmf.session_length_daily): https://superset.wikimedia.org/r/495.
Mar 9 2021
The sample rate for dashboard was updated to 1/10.
Mar 8 2021
Mar 3 2021
@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.
Feb 25 2021
Feb 24 2021
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.
Feb 16 2021
@hdothiduc It sounds good to me.
Feb 10 2021
In Superset data table session_length:
Feb 8 2021
Hi @hdothiduc, the full year data for 2020 is updated in here.
Feb 3 2021
Feb 1 2021
Presented at Q2 Tuning session
Jan 28 2021
Jan 25 2021
Jan 21 2021
Jan 19 2021
Jan 14 2021
Jan 11 2021
@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.
Jan 5 2021
project and project family filter added to the editors dashboard in Superset.
Dec 23 2020
Dec 22 2020
Dec 17 2020
Dec 16 2020
Dec 15 2020
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.
Dec 14 2020
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.
Dec 11 2020
Dec 9 2020
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.