@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.

Repo for this task

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.

Thank you @Ottomata and @Nuria! i will try out and share with other teams.

(Copy from parent task)

Notebook for ref.

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.

@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.

@Nuria can we add namespace field in this task as well?
related ticket: https://phabricator.wikimedia.org/T237053

@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?

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!

Thank you @Nuria! I just tried the new feature on the dashboard, very useful!

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?

Currently the canonical table is created by this notebook occasionally.

Fields submitted for edit_hourly table:

Here is a current summary of findings:

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

MTP metrics for Q1 and baseline : https://docs.google.com/document/d/1ZiYPl5-IKDIpT5cf3-UNIogrWUHJlwifgIi1FWChAqM/edit