Fri, Mar 27
@Ragesoss, yes. One thing need to change is to pull a list of campaign name to add to "campaign_url" in cell 4. and feel free to reach out to me or our team if you run into any issues.
Updated the analysis with Spring/Fall 2019 in this repo.
Wed, Mar 25
Mon, Mar 23
Wed, Mar 18
Tue, Mar 17
Tue, Mar 10
Wed, Mar 4
Thanks @Ragesoss ! just tested the changes in notebook, it works.
@mforns thanks for working on this! We only need project_family and namespace data for pageviews table.
Tue, Mar 3
Feb 28 2020
Feb 27 2020
Feb 20 2020
Feb 18 2020
(Copy from parent task)
Notebook for ref.
Feb 17 2020
Feb 11 2020
The first sheet is top 100 "non-bot" editors using our current bot definition SIZE(event_user_is_bot_by_historical) = 0 and SIZE(event_user_is_bot_by) = 0 among all the wikis in 2019.
Among these 100 editors, 2% had over 10M edits, 6% had over 5M edits, 30% had over 1M edits.
Feb 10 2020
Feb 6 2020
Feb 4 2020
@mforns in edit_hourly in Superset and Turnilo, we have fields: namespace_is_content, namespace_is_talk and namespace_name. Can add these fields to pageview data as well?
edits_hourl.hql file for reference.
Jan 21 2020
@Nuria I tried to add new columns 'language' in datasource page for edit_hourly as other available columns. Looks like it didn't work. For currently available fields, they have a "type" column in data source as certain type. But for newly added columns the "type" are still NONE. can you point me to the place where i can update this type?
Jan 17 2020
Yes, i am seeing those fields now in Turnilo, but not in Superset.
@Milimetric Thanks for working on this! i noticed the updates in hive table, but not in Superset/Turnilo. Are there any additional queries i need to update in refinery to make this work in Superset? Thanks again!
Jan 16 2020
Thank you @Nuria! I just tried the new feature on the dashboard, very useful!
Jan 14 2020
Jan 10 2020
Thank you @Dzahn !!
hi @Dzahn, just sent via SMS! Thank you!
Hi @Dzahn , i see you are on the clinic duty this week. do i need to assign the ticker to you?
Jan 6 2020
Currently the canonical table is created by this notebook occasionally.
Dec 12 2019
Dec 9 2019
Dec 6 2019
Fields submitted for edit_hourly table:
Dec 4 2019
Here is a current summary of findings:
Dec 3 2019
Draft for editing metrics: https://superset.wikimedia.org/superset/dashboard/50/
Draft for SQL style guide: https://www.mediawiki.org/wiki/Product_Analytics/Query_Style_Guide
Dec 2 2019
Nov 22 2019
Nov 21 2019
MTP metrics for Q1 and baseline : https://docs.google.com/document/d/1ZiYPl5-IKDIpT5cf3-UNIogrWUHJlwifgIi1FWChAqM/edit