Page MenuHomePhabricator

cchen (connie)
User

Projects

Today

  • Clear sailing ahead.

Tomorrow

  • Clear sailing ahead.

Thursday

  • Clear sailing ahead.

User Details

User Since
Jul 17 2019, 10:09 PM (36 w, 5 d)
Availability
Available
LDAP User
Unknown
MediaWiki User
CChen (WMF) [ Global Accounts ]

Recent Activity

Yesterday

cchen moved T244780: [REQUEST] updated analysis of Wiki Education participants as a share of new active editors from Doing to Needs Review on the Product-Analytics (Kanban) board.
Mon, Mar 30, 9:39 PM · Product-Analytics (Kanban)
cchen moved T245761: QA edit_hourly table with bot definition fix from Doing to Next 2 weeks on the Product-Analytics (Kanban) board.
Mon, Mar 30, 4:49 PM · Product-Analytics (Kanban)

Fri, Mar 27

cchen added a comment to T244780: [REQUEST] updated analysis of Wiki Education participants as a share of new active editors.

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

Fri, Mar 27, 11:03 PM · Product-Analytics (Kanban)
cchen moved T247331: Create revised version of Key Product Metrics with February's metrics. from Next 2 weeks to Doing on the Product-Analytics (Kanban) board.
Fri, Mar 27, 7:39 AM · Product-Analytics (Kanban)
cchen moved T245761: QA edit_hourly table with bot definition fix from Next 2 weeks to Doing on the Product-Analytics (Kanban) board.
Fri, Mar 27, 7:38 AM · Product-Analytics (Kanban)
cchen moved T239811: Investigate recent increase in pageviews in September and October from Doing to Next 2 weeks on the Product-Analytics (Kanban) board.
Fri, Mar 27, 7:38 AM · Product-Analytics (Kanban)
cchen added a comment to T244780: [REQUEST] updated analysis of Wiki Education participants as a share of new active editors.

Updated the analysis with Spring/Fall 2019 in this repo.

Fri, Mar 27, 7:36 AM · Product-Analytics (Kanban)

Wed, Mar 25

cchen closed T246737: High-level investigation on Google Search updates on featured snippets for Quarterly Insights, a subtask of T246690: Quarterly Insights through Q2 FY2019-20, as Resolved.
Wed, Mar 25, 6:58 PM · Product-Analytics (Kanban)
cchen closed T246737: High-level investigation on Google Search updates on featured snippets for Quarterly Insights as Resolved.

Repo for this task

Wed, Mar 25, 6:58 PM · Product-Analytics (Kanban)
cchen closed T246737: High-level investigation on Google Search updates on featured snippets for Quarterly Insights, a subtask of T247909: Investigation on Google Search updates on featured snippets, as Resolved.
Wed, Mar 25, 6:58 PM · Product-Analytics (Kanban)
cchen moved T244780: [REQUEST] updated analysis of Wiki Education participants as a share of new active editors from Next 2 weeks to Doing on the Product-Analytics (Kanban) board.
Wed, Mar 25, 4:28 AM · Product-Analytics (Kanban)

Mon, Mar 23

cchen triaged T248356: March 2020 Wikimedia movement metrics as High priority.
Mon, Mar 23, 9:09 PM · Product-Analytics (Kanban)
cchen created T248356: March 2020 Wikimedia movement metrics.
Mon, Mar 23, 9:09 PM · Product-Analytics (Kanban)
cchen closed T245471: February 2020 Wikimedia movement metrics as Resolved.
Mon, Mar 23, 9:08 PM · Product-Analytics (Kanban)

Wed, Mar 18

cchen updated the task description for T247907: Investigation into editors & readers relating to COVID-19.
Wed, Mar 18, 8:45 PM · Readers-Web-Backlog (Needs Product Owner Decisions), covid-19, Product-Analytics (Kanban)
cchen moved T247331: Create revised version of Key Product Metrics with February's metrics. from Doing to Next 2 weeks on the Product-Analytics (Kanban) board.
Wed, Mar 18, 6:04 PM · Product-Analytics (Kanban)
cchen moved T244780: [REQUEST] updated analysis of Wiki Education participants as a share of new active editors from Doing to Next 2 weeks on the Product-Analytics (Kanban) board.
Wed, Mar 18, 6:04 PM · Product-Analytics (Kanban)
cchen moved T230092: Data exploration capabilities in Superset and Turnilo for editing data at “editor” level from Next 2 weeks to Doing on the Product-Analytics (Kanban) board.
Wed, Mar 18, 6:03 PM · Product-Analytics
cchen closed T245049: Draft for Editor schemas, a subtask of T230092: Data exploration capabilities in Superset and Turnilo for editing data at “editor” level, as Resolved.
Wed, Mar 18, 6:01 PM · Product-Analytics
cchen closed T245049: Draft for Editor schemas as Resolved.
Wed, Mar 18, 6:01 PM · Product-Analytics (Kanban)
cchen moved T230092: Data exploration capabilities in Superset and Turnilo for editing data at “editor” level from Backlog to Kanban on the Product-Analytics board.
Wed, Mar 18, 5:59 PM · Product-Analytics

Tue, Mar 17

cchen moved T247331: Create revised version of Key Product Metrics with February's metrics. from Next 2 weeks to Doing on the Product-Analytics (Kanban) board.
Tue, Mar 17, 3:17 AM · Product-Analytics (Kanban)
cchen closed T247366: Graphs and data for high level metrics for Quarterly Insights, a subtask of T246690: Quarterly Insights through Q2 FY2019-20, as Resolved.
Tue, Mar 17, 3:17 AM · Product-Analytics (Kanban)
cchen closed T247366: Graphs and data for high level metrics for Quarterly Insights as Resolved.
Tue, Mar 17, 3:17 AM · Product-Analytics (Kanban)

Tue, Mar 10

cchen moved T247331: Create revised version of Key Product Metrics with February's metrics. from Doing to Next 2 weeks on the Product-Analytics (Kanban) board.
Tue, Mar 10, 5:53 PM · Product-Analytics (Kanban)
cchen moved T247331: Create revised version of Key Product Metrics with February's metrics. from Next 2 weeks to Doing on the Product-Analytics (Kanban) board.
Tue, Mar 10, 5:53 PM · Product-Analytics (Kanban)
cchen triaged T247331: Create revised version of Key Product Metrics with February's metrics. as High priority.
Tue, Mar 10, 5:53 PM · Product-Analytics (Kanban)
cchen created T247331: Create revised version of Key Product Metrics with February's metrics..
Tue, Mar 10, 5:52 PM · Product-Analytics (Kanban)
cchen closed T244925: Review top "non-bot" contributors in 2019 as Resolved.
Tue, Mar 10, 5:32 PM · Product-Analytics (Kanban)
cchen moved T245761: QA edit_hourly table with bot definition fix from Doing to Next 2 weeks on the Product-Analytics (Kanban) board.
Tue, Mar 10, 5:20 PM · Product-Analytics (Kanban)
cchen moved T245471: February 2020 Wikimedia movement metrics from Next 2 weeks to Doing on the Product-Analytics (Kanban) board.
Tue, Mar 10, 5:19 PM · Product-Analytics (Kanban)

Wed, Mar 4

cchen added a comment to T244780: [REQUEST] updated analysis of Wiki Education participants as a share of new active editors.

Thanks @Ragesoss ! just tested the changes in notebook, it works.

Wed, Mar 4, 11:17 PM · Product-Analytics (Kanban)
cchen added a comment to T243090: Add new dimensions to druid's pageview_hourly datasource.

@mforns thanks for working on this! We only need project_family and namespace data for pageviews table.

Wed, Mar 4, 7:53 PM · Product-Analytics, Patch-For-Review, Analytics-Kanban, Analytics
cchen renamed T245761: QA edit_hourly table with bot definition fix from Investigate discrepancy between edit_hourly table in Superset/Turnilo and mediawiki_history query results to QA edit_hourly table with bot definition fix.
Wed, Mar 4, 6:12 AM · Product-Analytics (Kanban)

Tue, Mar 3

cchen added a parent task for T246737: High-level investigation on Google Search updates on featured snippets for Quarterly Insights: T246690: Quarterly Insights through Q2 FY2019-20.
Tue, Mar 3, 6:26 AM · Product-Analytics (Kanban)
cchen added a subtask for T246690: Quarterly Insights through Q2 FY2019-20: T246737: High-level investigation on Google Search updates on featured snippets for Quarterly Insights.
Tue, Mar 3, 6:26 AM · Product-Analytics (Kanban)
cchen created T246737: High-level investigation on Google Search updates on featured snippets for Quarterly Insights.
Tue, Mar 3, 6:25 AM · Product-Analytics (Kanban)

Feb 28 2020

cchen added a comment to T245679: Support CSV uploads in Superset.

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

Feb 28 2020, 6:12 PM · Analytics-Kanban, Analytics

Feb 27 2020

cchen edited projects for T209771: Calculate Global South new editor retention within the limits of geolocation data purging, added: Product-Analytics (Kanban); removed Product-Analytics.
Feb 27 2020, 6:51 PM · Product-Analytics
cchen closed T238793: Update automate process to have key metrics for Emerging&Established markets as Resolved.
Feb 27 2020, 6:50 PM · Product-Analytics (Kanban)

Feb 20 2020

cchen moved T245761: QA edit_hourly table with bot definition fix from Next 2 weeks to Doing on the Product-Analytics (Kanban) board.
Feb 20 2020, 6:46 PM · Product-Analytics (Kanban)
cchen triaged T245761: QA edit_hourly table with bot definition fix as Medium priority.
Feb 20 2020, 6:46 PM · Product-Analytics (Kanban)
cchen created T245761: QA edit_hourly table with bot definition fix.
Feb 20 2020, 6:46 PM · Product-Analytics (Kanban)

Feb 18 2020

cchen closed T245045: Preliminary investigation into revert rate by project, editor type, and edit quantity as Resolved.
Feb 18 2020, 6:45 PM · Product-Analytics (Kanban)
cchen closed T245045: Preliminary investigation into revert rate by project, editor type, and edit quantity, a subtask of T233364: Examine recent trend of decline in revert rate across projects, as Resolved.
Feb 18 2020, 6:45 PM · Product-Analytics
cchen added a comment to T245045: Preliminary investigation into revert rate by project, editor type, and edit quantity.

(Copy from parent task)

Feb 18 2020, 6:44 PM · Product-Analytics (Kanban)
cchen added a project to T245466: Publish data on editors per country for sister projects: Analytics.
Feb 18 2020, 6:23 PM · Analytics, Product-Analytics
cchen moved T245466: Publish data on editors per country for sister projects from Triage to Tracking on the Product-Analytics board.
Feb 18 2020, 6:22 PM · Analytics, Product-Analytics
cchen added a comment to T244925: Review top "non-bot" contributors in 2019.

Notebook for ref.

Feb 18 2020, 3:18 AM · Product-Analytics (Kanban)

Feb 17 2020

cchen triaged T245471: February 2020 Wikimedia movement metrics as Medium priority.
Feb 17 2020, 10:32 PM · Product-Analytics (Kanban)
cchen created T245471: February 2020 Wikimedia movement metrics.
Feb 17 2020, 10:32 PM · Product-Analytics (Kanban)
cchen closed T242786: January 2020 Wikimedia movement metrics as Resolved.
Feb 17 2020, 10:31 PM · Product-Analytics (Kanban)

Feb 11 2020

cchen added a comment to T244925: Review top "non-bot" contributors in 2019.

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 11 2020, 10:45 PM · Product-Analytics (Kanban)
cchen moved T244925: Review top "non-bot" contributors in 2019 from Next 2 weeks to Doing on the Product-Analytics (Kanban) board.
Feb 11 2020, 9:01 PM · Product-Analytics (Kanban)

Feb 10 2020

cchen renamed T238793: Update automate process to have key metrics for Emerging&Established markets from Add and automate monthly queries for Emerging&Established markets. to Update automate process to have key metrics for Emerging&Established markets.
Feb 10 2020, 7:25 PM · Product-Analytics (Kanban)
cchen moved T233364: Examine recent trend of decline in revert rate across projects from Doing to Backlog on the Product-Analytics board.
Feb 10 2020, 7:13 PM · Product-Analytics
cchen edited projects for T233364: Examine recent trend of decline in revert rate across projects, added: Product-Analytics; removed Product-Analytics (Kanban).
Feb 10 2020, 7:12 PM · Product-Analytics
cchen moved T230091: Data exploration capabilities in Superset and Turnilo for Wiki project-level data from Triage to Backlog on the Product-Analytics board.
Feb 10 2020, 7:08 PM · Product-Analytics
cchen edited projects for T230091: Data exploration capabilities in Superset and Turnilo for Wiki project-level data, added: Product-Analytics; removed Product-Analytics (Kanban).
Feb 10 2020, 7:08 PM · Product-Analytics

Feb 6 2020

cchen moved T242786: January 2020 Wikimedia movement metrics from Next 2 weeks to Doing on the Product-Analytics (Kanban) board.
Feb 6 2020, 5:51 PM · Product-Analytics (Kanban)

Feb 4 2020

cchen added a comment to T243090: Add new dimensions to druid's pageview_hourly datasource.

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

Feb 4 2020, 10:05 PM · Product-Analytics, Patch-For-Review, Analytics-Kanban, Analytics

Jan 21 2020

cchen added a comment to T243090: Add new dimensions to druid's pageview_hourly datasource.

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

Jan 21 2020, 9:34 PM · Product-Analytics, Patch-For-Review, Analytics-Kanban, Analytics
cchen added a comment to T232659: Add dimensions for Project type & language to Edits_hourly.

@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 21 2020, 6:32 PM · Analytics-Kanban, Analytics, Patch-For-Review, Product-Analytics (Kanban)

Jan 17 2020

cchen added a comment to T232659: Add dimensions for Project type & language to Edits_hourly.

Yes, i am seeing those fields now in Turnilo, but not in Superset.

Jan 17 2020, 6:31 PM · Analytics-Kanban, Analytics, Patch-For-Review, Product-Analytics (Kanban)
cchen added a comment to T232659: Add dimensions for Project type & language to Edits_hourly.

@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 17 2020, 4:59 PM · Analytics-Kanban, Analytics, Patch-For-Review, Product-Analytics (Kanban)

Jan 16 2020

cchen closed T236429: Update "platform" field in edit_hourly table with "mobile app edit" as Resolved.
Jan 16 2020, 7:48 PM · Product-Analytics (Kanban)
cchen added a comment to T242870: Upgrade to Superset 0.35.2.

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

Jan 16 2020, 5:26 PM · User-Elukey, Better Use Of Data, Analytics-Kanban, Product-Analytics

Jan 14 2020

cchen triaged T242786: January 2020 Wikimedia movement metrics as Medium priority.
Jan 14 2020, 7:38 PM · Product-Analytics (Kanban)
cchen created T242786: January 2020 Wikimedia movement metrics.
Jan 14 2020, 7:38 PM · Product-Analytics (Kanban)
cchen closed T240592: December 2019 Wikimedia movement metrics as Resolved.
Jan 14 2020, 7:36 PM · Product-Analytics (Kanban)

Jan 10 2020

cchen added a comment to T242407: Replace SSH key for cchen.

Thank you @Dzahn !!

Jan 10 2020, 8:08 PM · Operations, SRE-Access-Requests
cchen added a comment to T242407: Replace SSH key for cchen.

hi @Dzahn, just sent via SMS! Thank you!

Jan 10 2020, 6:59 PM · Operations, SRE-Access-Requests
cchen updated subscribers of T242407: Replace SSH key for cchen.

Hi @Dzahn , i see you are on the clinic duty this week. do i need to assign the ticker to you?

Jan 10 2020, 6:19 PM · Operations, SRE-Access-Requests
cchen created T242407: Replace SSH key for cchen.
Jan 10 2020, 4:30 AM · Operations, SRE-Access-Requests

Jan 6 2020

cchen added a comment to T241741: Keep canonical_data.wikis updated.

Currently the canonical table is created by this notebook occasionally.

Jan 6 2020, 4:06 PM · Analytics-Kanban, Product-Analytics, Analytics

Dec 12 2019

cchen triaged T240592: December 2019 Wikimedia movement metrics as Medium priority.
Dec 12 2019, 5:18 PM · Product-Analytics (Kanban)
cchen created T240592: December 2019 Wikimedia movement metrics.
Dec 12 2019, 5:17 PM · Product-Analytics (Kanban)
cchen updated the task description for T225237: Better Use of Data.
Dec 12 2019, 5:16 PM · Epic, Goal, Better Use Of Data, Product-Infrastructure-Team-Backlog, Product-Analytics
cchen closed T238241: November 2019 Wikimedia movement metrics as Resolved.
Dec 12 2019, 4:49 PM · Product-Analytics (Kanban)

Dec 9 2019

cchen added a comment to T236429: Update "platform" field in edit_hourly table with "mobile app edit".
Dec 9 2019, 5:47 PM · Product-Analytics (Kanban)
cchen moved T236429: Update "platform" field in edit_hourly table with "mobile app edit" from Next 2 weeks to Doing on the Product-Analytics (Kanban) board.
Dec 9 2019, 5:46 PM · Product-Analytics (Kanban)
cchen moved T239811: Investigate recent increase in pageviews in September and October from Next 2 weeks to Doing on the Product-Analytics (Kanban) board.
Dec 9 2019, 5:45 PM · Product-Analytics (Kanban)
cchen triaged T240032: Create data dictionary for data sources available in Superset/Turnilo as Low priority.
Dec 9 2019, 5:44 PM · Product-Analytics
cchen moved T240032: Create data dictionary for data sources available in Superset/Turnilo from Kanban to Backlog on the Product-Analytics board.
Dec 9 2019, 5:44 PM · Product-Analytics

Dec 6 2019

cchen created T240032: Create data dictionary for data sources available in Superset/Turnilo.
Dec 6 2019, 6:22 PM · Product-Analytics
cchen added a comment to T232659: Add dimensions for Project type & language to Edits_hourly.

Fields submitted for edit_hourly table:

Dec 6 2019, 6:03 PM · Analytics-Kanban, Analytics, Patch-For-Review, Product-Analytics (Kanban)

Dec 4 2019

cchen added a comment to T239811: Investigate recent increase in pageviews in September and October.

Here is a current summary of findings:

Dec 4 2019, 6:29 PM · Product-Analytics (Kanban)
cchen triaged T239811: Investigate recent increase in pageviews in September and October as Medium priority.
Dec 4 2019, 1:23 PM · Product-Analytics (Kanban)
cchen created T239811: Investigate recent increase in pageviews in September and October.
Dec 4 2019, 1:21 PM · Product-Analytics (Kanban)

Dec 3 2019

cchen added a comment to T230090: Automate Monthly Contributors report in Superset.

Draft for editing metrics: https://superset.wikimedia.org/superset/dashboard/50/

Dec 3 2019, 5:32 PM · Product-Analytics (Kanban)
cchen closed T237676: Finish SQL style guide draft, a subtask of T237671: Document Outcomes from Product Analytics Offsite, as Resolved.
Dec 3 2019, 10:35 AM · Product-Analytics, Epic
cchen closed T237676: Finish SQL style guide draft as Resolved.

Draft for SQL style guide: https://www.mediawiki.org/wiki/Product_Analytics/Query_Style_Guide

Dec 3 2019, 10:35 AM · Product-Analytics (Kanban)
cchen moved T238793: Update automate process to have key metrics for Emerging&Established markets from Next 2 weeks to Doing on the Product-Analytics (Kanban) board.
Dec 3 2019, 7:28 AM · Product-Analytics (Kanban)
cchen moved T233364: Examine recent trend of decline in revert rate across projects from Doing to Next 2 weeks on the Product-Analytics (Kanban) board.
Dec 3 2019, 7:27 AM · Product-Analytics

Dec 2 2019

cchen moved T238241: November 2019 Wikimedia movement metrics from Next 2 weeks to Doing on the Product-Analytics (Kanban) board.
Dec 2 2019, 5:35 PM · Product-Analytics (Kanban)
cchen moved T237676: Finish SQL style guide draft from Next 2 weeks to Doing on the Product-Analytics (Kanban) board.
Dec 2 2019, 5:35 PM · Product-Analytics (Kanban)

Nov 22 2019

cchen closed T237141: Q1 MTP and annual plan metrics for emerging vs existing markets as Resolved.
Nov 22 2019, 7:34 PM · Product-Analytics (Kanban)
cchen closed T235921: Contribute slides for BUOD stakeholder update as Resolved.
Nov 22 2019, 6:03 PM · Better Use Of Data

Nov 21 2019

cchen added a comment to T237141: Q1 MTP and annual plan metrics for emerging vs existing markets.

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

Nov 21 2019, 9:39 PM · Product-Analytics (Kanban)
cchen removed a parent task for T238793: Update automate process to have key metrics for Emerging&Established markets: T237141: Q1 MTP and annual plan metrics for emerging vs existing markets.
Nov 21 2019, 9:37 PM · Product-Analytics (Kanban)