Page MenuHomePhabricator

cchen (connie)
User

Projects

Today

  • Clear sailing ahead.

Tomorrow

  • Clear sailing ahead.

Monday

  • Clear sailing ahead.

User Details

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

Recent Activity

Yesterday

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

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

Fri, Jan 17, 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, Pageviews_hourly, Pageviews_daily.

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

Fri, Jan 17, 4:59 PM · Analytics-Kanban, Analytics, Patch-For-Review, Product-Analytics (Kanban)

Thu, Jan 16

cchen closed T236429: Update "platform" field in edit_hourly table with "mobile app edit" as Resolved.
Thu, Jan 16, 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!

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

Tue, Jan 14

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

Fri, Jan 10

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

Thank you @Dzahn !!

Fri, Jan 10, 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!

Fri, Jan 10, 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?

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

Mon, Jan 6

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

Currently the canonical table is created by this notebook occasionally.

Mon, Jan 6, 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 Up 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 Up 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, Pageviews_hourly, Pageviews_daily.

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: Add and automate monthly queries for Emerging&Established markets. from Next Up 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 Up on the Product-Analytics (Kanban) board.
Dec 3 2019, 7:27 AM · Product-Analytics (Kanban)

Dec 2 2019

cchen moved T238241: November 2019 Wikimedia movement metrics from Next Up 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 Up 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: Add and automate monthly queries 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)
cchen removed a subtask for T237141: Q1 MTP and annual plan metrics for emerging vs existing markets: T238793: Add and automate monthly queries for Emerging&Established markets..
Nov 21 2019, 9:37 PM · Product-Analytics (Kanban)

Nov 20 2019

cchen updated the task description for T238793: Add and automate monthly queries for Emerging&Established markets..
Nov 20 2019, 8:52 PM · Product-Analytics (Kanban)
cchen triaged T238793: Add and automate monthly queries for Emerging&Established markets. as Medium priority.
Nov 20 2019, 8:40 PM · Product-Analytics (Kanban)
cchen created T238793: Add and automate monthly queries for Emerging&Established markets..
Nov 20 2019, 8:40 PM · Product-Analytics (Kanban)

Nov 19 2019

cchen added a comment to T237605: Create kerberos principals for users.

Hi there! here's my request for Kerberos credentials for Hadoop access on stat100X and notebook100X. My username is conniecc1.

Nov 19 2019, 7:03 PM · Patch-For-Review, Analytics-Kanban, Analytics

Nov 15 2019

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

@kzimmerman do you mean for this Q4 2019/20 as goal or Q4 2018/19 as baseline.

Nov 15 2019, 7:25 PM · Product-Analytics (Kanban)
cchen added a comment to T237141: Q1 MTP and annual plan metrics for emerging vs existing markets.

Approaches to estimate the missing Global South New Editor Retention metrics for September

Nov 15 2019, 7:19 PM · Product-Analytics (Kanban)

Nov 14 2019

cchen added a comment to T221566: Update and fix wiki segmentation dataset.

reviewed with the following changes:

  • update canonical wikis table for missing wikis
  • update queries:
    1. Monthly non-bot edits
    2. Bot Editing Proportion
    3. Anonymous Editing Proportion
    4. Mobile Editing Proportion
    5. Majority-mobile editors proportion
    6. Visual edits
Nov 14 2019, 5:41 PM · Product-Analytics (Kanban), Better Use Of Data, Epic

Nov 13 2019

cchen triaged T238241: November 2019 Wikimedia movement metrics as Medium priority.
Nov 13 2019, 6:31 PM · Product-Analytics (Kanban)
cchen created T238241: November 2019 Wikimedia movement metrics.
Nov 13 2019, 6:31 PM · Product-Analytics (Kanban)
cchen closed T237324: October 2019 Wikimedia movement metrics as Resolved.
Nov 13 2019, 6:29 PM · Product-Analytics (Kanban)

Nov 12 2019

cchen added a comment to T237581: external search engine traffic CTR on superset?.

The data is not available in Superset now, i believe @mpopov's dataset is only for testing, right?

Nov 12 2019, 7:24 PM · GLOW
cchen added a comment to T237141: Q1 MTP and annual plan metrics for emerging vs existing markets.

Worldwide Readership (MTP metrics slide):
Content Interactions (pageviews + previews) by emerging vs. existing markets: Feasible
Content Growth (edits, net new content): NOT Feasible for Q1 only past 2 month is available (September and October)

Nov 12 2019, 7:09 PM · Product-Analytics (Kanban)

Nov 8 2019

cchen updated the task description for T236429: Update "platform" field in edit_hourly table with "mobile app edit".
Nov 8 2019, 6:32 PM · Product-Analytics (Kanban)

Nov 7 2019

cchen triaged T237128: Create content interaction datasource to use in Superset/Turnilo as Medium priority.
Nov 7 2019, 7:50 PM · Product-Analytics
cchen updated the task description for T237128: Create content interaction datasource to use in Superset/Turnilo.
Nov 7 2019, 7:41 PM · Product-Analytics

Nov 6 2019

cchen added a comment to T235340: Agree on an SQL style guide for the Product Analytics team.

Draft for style guide.

Nov 6 2019, 11:55 PM · Product-Analytics

Nov 4 2019

cchen triaged T237324: October 2019 Wikimedia movement metrics as Medium priority.
Nov 4 2019, 9:13 PM · Product-Analytics (Kanban)
cchen moved T237324: October 2019 Wikimedia movement metrics from Next Up to Doing on the Product-Analytics (Kanban) board.
Nov 4 2019, 9:12 PM · Product-Analytics (Kanban)
cchen created T237324: October 2019 Wikimedia movement metrics.
Nov 4 2019, 9:12 PM · Product-Analytics (Kanban)

Nov 1 2019

cchen created T237128: Create content interaction datasource to use in Superset/Turnilo.
Nov 1 2019, 6:30 PM · Product-Analytics

Oct 24 2019

cchen moved T236429: Update "platform" field in edit_hourly table with "mobile app edit" from Triage to Kanban on the Product-Analytics board.
Oct 24 2019, 7:18 PM · Product-Analytics (Kanban)
cchen triaged T236429: Update "platform" field in edit_hourly table with "mobile app edit" as Medium priority.
Oct 24 2019, 7:17 PM · Product-Analytics (Kanban)
cchen created T236429: Update "platform" field in edit_hourly table with "mobile app edit".
Oct 24 2019, 7:16 PM · Product-Analytics (Kanban)

Oct 21 2019

cchen added a comment to T235287: Prepare training material for Turnilo/Superset.

Slides and use cases available for PM salon: Superset/Turnilo Sharing

Oct 21 2019, 5:19 PM · Product-Analytics (Kanban)

Oct 18 2019

cchen created T235921: Contribute slides for BUOD stakeholder update.
Oct 18 2019, 8:24 PM · Better Use Of Data

Oct 16 2019

cchen closed T233041: September 2019 Wikimedia movement metrics as Resolved.
Oct 16 2019, 11:12 PM · Product-Analytics (Kanban)

Oct 11 2019

cchen triaged T235287: Prepare training material for Turnilo/Superset as Medium priority.
Oct 11 2019, 5:23 PM · Product-Analytics (Kanban)
cchen moved T235287: Prepare training material for Turnilo/Superset from Triage to Doing on the Product-Analytics board.
Oct 11 2019, 5:23 PM · Product-Analytics (Kanban)
cchen added a project to T235287: Prepare training material for Turnilo/Superset: Product-Analytics.
Oct 11 2019, 5:22 PM · Product-Analytics (Kanban)
cchen created T235287: Prepare training material for Turnilo/Superset.
Oct 11 2019, 5:21 PM · Product-Analytics (Kanban)

Oct 4 2019

cchen moved T233041: September 2019 Wikimedia movement metrics from Next Up to Doing on the Product-Analytics board.
Oct 4 2019, 7:01 PM · Product-Analytics (Kanban)

Oct 1 2019

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

Metrics Added

Oct 1 2019, 5:37 PM · Analytics-Kanban, Analytics, Patch-For-Review, Product-Analytics (Kanban)
cchen added a comment to T233364: Examine recent trend of decline in revert rate across projects.

The link is here.

Oct 1 2019, 5:27 PM · Product-Analytics (Kanban)

Sep 25 2019

cchen added a comment to T233364: Examine recent trend of decline in revert rate across projects.
  • Projects: Considering the YoY % decrease in revert rate and revert volumes, wikidata, enwiki, dewiki, ruwiki, zhwiki, are showing a big drop in revert rate for past few months.
  • Drops in revert rate are correlated to (non-bot) Edit Increase for some projects: The drop in recent revert rate is correlated to (non-bot) edit increases only in wikidata and commons. For some other projects (enwiki, dewiki, ruwiki, zhwiki, frwiki, itwiki). the increases in (non-bot) edits are small over time, and the drop in reverts result in the drop in revert rate.
  • Drops in revert rate/reverts are not correlated to number of users (new & returning) who make reverts: By looking at the number of users who make reverts overtime by tenue and by project, the numbers didn't change much over YoY.
Sep 25 2019, 3:34 PM · Product-Analytics (Kanban)

Sep 18 2019

Charlotte awarded T232765: Count of users who have a reverted suggested edit a Yellow Medal token.
Sep 18 2019, 11:20 AM · Epic, Product-Analytics

Sep 17 2019

cchen moved T232765: Count of users who have a reverted suggested edit from Next Up to Doing on the Product-Analytics board.
Sep 17 2019, 6:40 PM · Epic, Product-Analytics
cchen added a comment to T232765: Count of users who have a reverted suggested edit.

By looking at timeframe: 4/23/2019 - 9/10/2019

Sep 17 2019, 4:50 PM · Epic, Product-Analytics
cchen added a comment to T232765: Count of users who have a reverted suggested edit.
Sep 17 2019, 6:07 AM · Epic, Product-Analytics

Sep 16 2019

cchen created T233042: Calculate and report contributors health metrics for September 2019.
Sep 16 2019, 6:55 PM · Product-Analytics
cchen created T233041: September 2019 Wikimedia movement metrics.
Sep 16 2019, 6:54 PM · Product-Analytics (Kanban)
cchen closed T232153: Calculate and report contributors health metrics for August 2019 as Resolved.
Sep 16 2019, 6:52 PM · Product-Analytics
cchen closed T232155: Calculate and report readers health metrics for August 2019 as Resolved.
Sep 16 2019, 6:52 PM · Product-Analytics

Sep 5 2019

cchen created T232155: Calculate and report readers health metrics for August 2019.
Sep 5 2019, 8:42 PM · Product-Analytics
cchen created T232153: Calculate and report contributors health metrics for August 2019.
Sep 5 2019, 8:40 PM · Product-Analytics

Sep 4 2019

cchen moved T230090: Automate Monthly Contributors report in Superset from Next Up to Doing on the Product-Analytics board.
Sep 4 2019, 9:34 PM · Product-Analytics (Kanban)
cchen moved T230089: Automate Monthly Readers report in Superset from Next Up to Doing on the Product-Analytics board.
Sep 4 2019, 9:34 PM · Product-Analytics (Kanban)
cchen moved T230090: Automate Monthly Contributors report in Superset from Triage to Next Up on the Product-Analytics board.
Sep 4 2019, 5:09 AM · Product-Analytics (Kanban)

Aug 26 2019

cchen added a comment to T231111: Access to HUE for cchen.

Thank you @mforns! I am able to access Hue now!

Aug 26 2019, 6:28 PM · Analytics-Kanban, SRE-Access-Requests, Operations, Analytics

Aug 23 2019

cchen created T231111: Access to HUE for cchen.
Aug 23 2019, 7:05 PM · Analytics-Kanban, SRE-Access-Requests, Operations, Analytics
cchen added a comment to T228722: Key Product Metrics: FY 18-19 Annual Edition.

Just updated two versions in the doc https://docs.google.com/presentation/d/1n3HO9KfCiwhmk4HqPklAmIigQji7owwiRztvbEEwEBg/edit?usp=sharing

Aug 23 2019, 1:29 AM · Product-Analytics

Aug 20 2019

cchen added a comment to T230757: Quarterly Product Insights presentation.

Visualization of YoY trend for net new content created monthly breakdown by content type.

Aug 20 2019, 11:43 PM · Product-Analytics
cchen added a comment to T228722: Key Product Metrics: FY 18-19 Annual Edition.

Here's a mockup for annual key metric. Let me know if any thing need to be updated or change.

Aug 20 2019, 7:30 PM · Product-Analytics
cchen added a comment to T228154: Calculate and report contributors health metrics for July 2019.

@kzimmerman the board slides are updated.

Aug 20 2019, 4:44 PM · Product-Analytics
cchen added a comment to T230627: Unable to access SWAP notebooks using LDAP.

@elukey i update the password and it's working! i am able to log into the SWAP now. Thanks again!

Aug 20 2019, 4:42 PM · Analytics
cchen moved T228722: Key Product Metrics: FY 18-19 Annual Edition from Next Up to Doing on the Product-Analytics board.
Aug 20 2019, 4:41 PM · Product-Analytics

Aug 19 2019

cchen added a comment to T230627: Unable to access SWAP notebooks using LDAP.

@elukey looks like it's still not working :(

Aug 19 2019, 4:53 PM · Analytics
cchen added a comment to T230627: Unable to access SWAP notebooks using LDAP.

@elukey Thanks for the updates.

Aug 19 2019, 4:26 PM · Analytics

Aug 16 2019

cchen created T230627: Unable to access SWAP notebooks using LDAP.
Aug 16 2019, 7:55 PM · Analytics

Aug 13 2019

cchen added a comment to T230242: Membership to 'wmf' LDAP group request for Connie Chen.

Thanks @elukey!

Aug 13 2019, 5:39 PM · LDAP-Access-Requests, Operations
cchen reopened T230242: Membership to 'wmf' LDAP group request for Connie Chen as "Open".

Thanks again for your help @colewhite !

Aug 13 2019, 4:46 PM · LDAP-Access-Requests, Operations
cchen closed T228447: Requesting access to machines [stat1004, stat1007, stat1006, notebook1003 and notebook1004] and groups for cchen as Resolved.
Aug 13 2019, 3:01 PM · SRE-Access-Requests, Operations
cchen reopened T228447: Requesting access to machines [stat1004, stat1007, stat1006, notebook1003 and notebook1004] and groups for cchen as "Open".
Aug 13 2019, 3:01 PM · SRE-Access-Requests, Operations