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 (66 w, 2 d)
Availability
Available
LDAP User
Unknown
MediaWiki User
CChen (WMF) [ Global Accounts ]

Recent Activity

Thu, Oct 15

cchen closed T260369: Determine global percentage of new active editors from education program as Resolved.
Thu, Oct 15, 7:34 AM · Product-Analytics (Kanban)

Wed, Oct 14

cchen closed T234839: Review Adam's Topic Dataset as Resolved.

Research team will provide guidelines for how to use the topic models and post processing. Updates will be in the parent task.

Wed, Oct 14, 6:45 PM · Product-Analytics (Kanban)
cchen closed T234839: Review Adam's Topic Dataset, a subtask of T257638: Topic Dataset : Model, Threshold, Post-processing, as Resolved.
Wed, Oct 14, 6:45 PM · Product-Analytics (Kanban)
cchen added a parent task for T234839: Review Adam's Topic Dataset: T257638: Topic Dataset : Model, Threshold, Post-processing.
Wed, Oct 14, 6:43 PM · Product-Analytics (Kanban)
cchen added a subtask for T257638: Topic Dataset : Model, Threshold, Post-processing: T234839: Review Adam's Topic Dataset.
Wed, Oct 14, 6:43 PM · Product-Analytics (Kanban)

Tue, Oct 13

cchen added a comment to T264689: Q2 Risks and Dependencies - Content Data Accessibility & Editor Dataset.
  1. Do you have any known risks in the upcoming quarter?
    • What is the cause? Potential technical limitations, for instance, access aggregated sample dataset in Superset through Presto.
    • What is the impact? If we do not rollout the sample dataset in Superset, we may not be able to get feedback from PMs and iterate datasets in Q3.
Tue, Oct 13, 6:34 AM · Product-Analytics (Kanban)

Fri, Oct 9

cchen moved T264689: Q2 Risks and Dependencies - Content Data Accessibility & Editor Dataset from Next 2 weeks to Doing on the Product-Analytics (Kanban) board.
Fri, Oct 9, 9:47 PM · Product-Analytics (Kanban)
cchen added a comment to T262954: Add editors metrics to Superset dashboards .

Added metrics section for active editors in editors dashboard.

Fri, Oct 9, 8:27 PM · Product-Analytics (Kanban)
cchen closed T261922: Add diversity metrics and anonymous edits to Superset dashboards as Resolved.

Added diversity metrics for active editors and content interactions in Superset. and add filter for anonymous/non-anonymous edits.

Fri, Oct 9, 8:26 PM · Product-Analytics (Kanban)
cchen added a comment to T256050: Add dimensions to editors_daily dataset.

Thank you @JAllemandou !!

Fri, Oct 9, 8:23 PM · Analytics-Kanban, Patch-For-Review, Product-Analytics, Analytics
cchen added a comment to T256050: Add dimensions to editors_daily dataset.

@JAllemandou @Milimetric thanks for confirming this with me. I confirm that PMs are aware the data related to platforms are non-additive and they are interested to see editor counts in by platforms. We want to start experiment with creating some test aggregation tables and making sample charts and dashboards in Superset using Presto.

Fri, Oct 9, 12:39 AM · Analytics-Kanban, Patch-For-Review, Product-Analytics, Analytics

Fri, Oct 2

cchen moved T263685: Sept 2020 Wikimedia movement metrics from Next 2 weeks to Doing on the Product-Analytics (Kanban) board.
Fri, Oct 2, 8:17 PM · Product-Analytics (Kanban)

Sep 24 2020

cchen closed T255722: Check and update reporting related to "automated" traffic change for product teams as Resolved.

Close the ticket since there's no additional action needed.

Sep 24 2020, 2:40 AM · Product-Analytics (Kanban)
cchen closed T255722: Check and update reporting related to "automated" traffic change for product teams, a subtask of T251827: Update regular reporting to reflect break-out of "automated" traffic, as Resolved.
Sep 24 2020, 2:40 AM · Product-Analytics (Kanban)

Sep 23 2020

cchen added a comment to T255722: Check and update reporting related to "automated" traffic change for product teams.

@nettrom_WMF can you confirm there's no impact in report/metrics?

Sep 23 2020, 7:27 PM · Product-Analytics (Kanban)
cchen closed T261028: Aug 2020 Wikimedia movement metrics as Resolved.
Sep 23 2020, 7:24 PM · Product-Analytics (Kanban)
cchen triaged T263685: Sept 2020 Wikimedia movement metrics as Medium priority.
Sep 23 2020, 7:24 PM · Product-Analytics (Kanban)
cchen created T263685: Sept 2020 Wikimedia movement metrics.
Sep 23 2020, 7:24 PM · Product-Analytics (Kanban)

Sep 22 2020

cchen moved T262954: Add editors metrics to Superset dashboards from Next 2 weeks to Doing on the Product-Analytics (Kanban) board.
Sep 22 2020, 2:56 AM · Product-Analytics (Kanban)
cchen moved T257636: Technical Requirements for Content dataset from Doing to Next 2 weeks on the Product-Analytics (Kanban) board.
Sep 22 2020, 2:55 AM · Product-Analytics (Kanban)

Sep 21 2020

cchen changed the status of T253161: Review "Topics for each Wikipedia Article across Languages" dataset from Duplicate to Resolved.

Updates will be in parent task.

Sep 21 2020, 4:49 PM · Product-Analytics (Kanban)
cchen changed the status of T253161: Review "Topics for each Wikipedia Article across Languages" dataset, a subtask of T234701: "Content" equivalent of pageviews daily or edits_hourly available to use in Turnilo and Superset, from Duplicate to Resolved.
Sep 21 2020, 4:49 PM · Epic, Product-Analytics
cchen changed the status of T253161: Review "Topics for each Wikipedia Article across Languages" dataset, a subtask of T257638: Topic Dataset : Model, Threshold, Post-processing, from Duplicate to Resolved.
Sep 21 2020, 4:49 PM · Product-Analytics (Kanban)
cchen merged T253161: Review "Topics for each Wikipedia Article across Languages" dataset into T257638: Topic Dataset : Model, Threshold, Post-processing.
Sep 21 2020, 4:46 PM · Product-Analytics (Kanban)
cchen merged task T253161: Review "Topics for each Wikipedia Article across Languages" dataset into T257638: Topic Dataset : Model, Threshold, Post-processing.
Sep 21 2020, 4:46 PM · Product-Analytics (Kanban)
cchen closed T257634: User Requirements for Content dataset as Resolved.
Sep 21 2020, 4:35 PM · Product-Analytics (Kanban)
cchen closed T257634: User Requirements for Content dataset, a subtask of T255496: Identify stakeholders, gather requirements, and determine maintenance and ownership responsibilities for the content dataset, as Resolved.
Sep 21 2020, 4:35 PM · Product-Analytics (Kanban)
cchen added a comment to T257634: User Requirements for Content dataset.

Maya finished Requirement Document : Content Data Accessibility and shared the requirement document with stakeholders.

Sep 21 2020, 4:35 PM · Product-Analytics (Kanban)
cchen moved T258985: Sample content dataset to explore and iterate from Triage to Upcoming Quarter on the Product-Analytics board.
Sep 21 2020, 4:12 PM · Product-Analytics, Spike
cchen edited projects for T258985: Sample content dataset to explore and iterate, added: Product-Analytics; removed Product-Analytics (Kanban).
Sep 21 2020, 4:12 PM · Product-Analytics, Spike
cchen closed T251827: Update regular reporting to reflect break-out of "automated" traffic as Resolved.
Sep 21 2020, 8:04 AM · Product-Analytics (Kanban)
cchen moved T253161: Review "Topics for each Wikipedia Article across Languages" dataset from Doing to Next 2 weeks on the Product-Analytics (Kanban) board.
Sep 21 2020, 8:02 AM · Product-Analytics (Kanban)
cchen moved T257638: Topic Dataset : Model, Threshold, Post-processing from Doing to Next 2 weeks on the Product-Analytics (Kanban) board.
Sep 21 2020, 8:02 AM · Product-Analytics (Kanban)

Sep 15 2020

cchen moved T261922: Add diversity metrics and anonymous edits to Superset dashboards from Next 2 weeks to Doing on the Product-Analytics (Kanban) board.
Sep 15 2020, 5:17 PM · Product-Analytics (Kanban)
cchen triaged T262954: Add editors metrics to Superset dashboards as Medium priority.
Sep 15 2020, 5:16 PM · Product-Analytics (Kanban)
cchen created T262954: Add editors metrics to Superset dashboards .
Sep 15 2020, 5:16 PM · Product-Analytics (Kanban)
cchen moved T230092: Data exploration capabilities in Superset and Turnilo for editing data at “editor” level from Current Quarter to Upcoming Quarter on the Product-Analytics board.
Sep 15 2020, 5:12 PM · Product-Analytics

Sep 9 2020

cchen moved T260369: Determine global percentage of new active editors from education program from Doing to Needs Review on the Product-Analytics (Kanban) board.
Sep 9 2020, 5:45 AM · Product-Analytics (Kanban)

Sep 4 2020

cchen moved T261446: [REQUEST] Data about top articles for Wikipedia's 20th birthday from Next 2 weeks to Doing on the Product-Analytics (Kanban) board.
Sep 4 2020, 9:09 PM · Product-Analytics (Kanban)
cchen added a comment to T261446: [REQUEST] Data about top articles for Wikipedia's 20th birthday.

@hdothiduc Thanks for the meeting and a great introduction to the project yesterday. And the blog post for the 15th Birthday of Wikipedia is a helpful reference!

Sep 4 2020, 5:06 PM · Product-Analytics (Kanban)

Sep 3 2020

cchen moved T260369: Determine global percentage of new active editors from education program from Next 2 weeks to Doing on the Product-Analytics (Kanban) board.
Sep 3 2020, 8:56 PM · Product-Analytics (Kanban)
cchen moved T261028: Aug 2020 Wikimedia movement metrics from Next 2 weeks to Doing on the Product-Analytics (Kanban) board.
Sep 3 2020, 8:56 PM · Product-Analytics (Kanban)
cchen added a comment to T260369: Determine global percentage of new active editors from education program.

Thanks! Just to clarify, the usernames I provided were on behalf of the Wikipedia & Education User Group, not Wiki Education, so they include usernames from about 20 global education programs worldwide, not just Wiki Education's Student Program!

Sep 3 2020, 6:05 PM · Product-Analytics (Kanban)
cchen added a comment to T260369: Determine global percentage of new active editors from education program.

Based on the usernames you provided, between July 1, 2019 and June 30, 2020, there are 10.4% (1,887 out of 18,168) of new active editors are from the Wikipedia & Education User Group in an average month.

Sep 3 2020, 5:38 PM · Product-Analytics (Kanban)
cchen triaged T261922: Add diversity metrics and anonymous edits to Superset dashboards as Medium priority.
Sep 3 2020, 7:45 AM · Product-Analytics (Kanban)
cchen created T261922: Add diversity metrics and anonymous edits to Superset dashboards.
Sep 3 2020, 7:45 AM · Product-Analytics (Kanban)

Sep 1 2020

cchen moved T260369: Determine global percentage of new active editors from education program from Current Quarter to Kanban on the Product-Analytics board.
Sep 1 2020, 7:54 AM · Product-Analytics (Kanban)
cchen moved T260399: Desktop pageviews: entrances, internally referred pageviews, and previews from Doing to Needs Review on the Product-Analytics (Kanban) board.
Sep 1 2020, 7:53 AM · Product-Analytics (Kanban)
cchen added a comment to T260399: Desktop pageviews: entrances, internally referred pageviews, and previews.

Red line - internal interactions per external pageview
Purple line - internal pageviews per external pageview

Sep 1 2020, 7:53 AM · Product-Analytics (Kanban)

Aug 21 2020

cchen closed T258131: July 2020 Wikimedia movement metrics as Resolved.
Aug 21 2020, 9:34 PM · Product-Analytics (Kanban)
cchen triaged T261028: Aug 2020 Wikimedia movement metrics as Medium priority.
Aug 21 2020, 9:34 PM · Product-Analytics (Kanban)
cchen moved T261028: Aug 2020 Wikimedia movement metrics from Triage to Kanban on the Product-Analytics board.
Aug 21 2020, 9:34 PM · Product-Analytics (Kanban)
cchen created T261028: Aug 2020 Wikimedia movement metrics.
Aug 21 2020, 9:34 PM · Product-Analytics (Kanban)

Aug 19 2020

cchen moved T260399: Desktop pageviews: entrances, internally referred pageviews, and previews from Next 2 weeks to Doing on the Product-Analytics (Kanban) board.
Aug 19 2020, 5:57 AM · Product-Analytics (Kanban)

Aug 18 2020

cchen added a comment to T260369: Determine global percentage of new active editors from education program.

@LiAnna for the lists of username you shared with me, are there any target wikis for these lists?

Aug 18 2020, 7:34 PM · Product-Analytics (Kanban)

Aug 17 2020

cchen closed T237128: Create content interaction datasource to use in Superset/Turnilo as Invalid.
Aug 17 2020, 4:51 PM · Product-Analytics

Aug 11 2020

cchen updated the task description for T257638: Topic Dataset : Model, Threshold, Post-processing.
Aug 11 2020, 10:32 PM · Product-Analytics (Kanban)
cchen updated the task description for T257638: Topic Dataset : Model, Threshold, Post-processing.
Aug 11 2020, 10:05 PM · Product-Analytics (Kanban)
cchen added a comment to T257638: Topic Dataset : Model, Threshold, Post-processing.

For both topic dataset, we keep predictions over 0.5 threshold since 0.5 is the official threshold for applying a topic.

Aug 11 2020, 9:42 AM · Product-Analytics (Kanban)
cchen closed T260013: Add net new content metrics to Superset Dashboard as Resolved.

Metrics added to content metrics dashboard with filters.

Aug 11 2020, 6:45 AM · Product-Analytics (Kanban)
cchen updated the task description for T260013: Add net new content metrics to Superset Dashboard.
Aug 11 2020, 6:43 AM · Product-Analytics (Kanban)

Aug 10 2020

cchen moved T251827: Update regular reporting to reflect break-out of "automated" traffic from Doing to Next 2 weeks on the Product-Analytics (Kanban) board.
Aug 10 2020, 8:42 AM · Product-Analytics (Kanban)
cchen moved T260013: Add net new content metrics to Superset Dashboard from Next 2 weeks to Doing on the Product-Analytics (Kanban) board.
Aug 10 2020, 8:42 AM · Product-Analytics (Kanban)
cchen triaged T260013: Add net new content metrics to Superset Dashboard as Medium priority.
Aug 10 2020, 4:55 AM · Product-Analytics (Kanban)
cchen created T260013: Add net new content metrics to Superset Dashboard.
Aug 10 2020, 4:55 AM · Product-Analytics (Kanban)

Aug 5 2020

cchen closed T258825: The count of File: namespace articles in the commonswiki database is slightly higher than what's shown on Wikistats as Resolved.

Close this ticket since it's not a bug. We need to document a clearer metrics definitions for Wikistats if we encounter a similar issue again.

Aug 5 2020, 11:31 PM · Product-Analytics

Aug 3 2020

cchen moved T258131: July 2020 Wikimedia movement metrics from Next 2 weeks to Doing on the Product-Analytics (Kanban) board.
Aug 3 2020, 4:43 AM · Product-Analytics (Kanban)

Jul 29 2020

cchen added a comment to T258825: The count of File: namespace articles in the commonswiki database is slightly higher than what's shown on Wikistats.

Not a bug, the difference is because of metrics definitions. According to this comment, the net new content metric in Wikistats does not include redirects.

Jul 29 2020, 3:19 PM · Product-Analytics

Jul 27 2020

cchen closed T256025: Check Product Analytics team's standard datasets and remove COUNT(*), a subtask of T255725: Remove COUNT(*) from datasets when not useful in Superset & Turnilo, as Resolved.
Jul 27 2020, 7:09 PM · Analytics, Product-Analytics
cchen closed T256025: Check Product Analytics team's standard datasets and remove COUNT(*) as Resolved.

Removed COUNT(*) from data sources and data tables in Superset. Didn't see COUNT(*) as metrics in datasets in Turnilo.

Jul 27 2020, 7:09 PM · Product-Analytics (Kanban), Analytics-Radar

Jul 20 2020

cchen added a comment to T258447: Virtual training for Superset/Turnilo .

Initially, we want to work with Carol as a potential audience and record the training. But the main blockers for her are creating develop account access and availability.
We need to find another candidate who's willing to be recorded.

Jul 20 2020, 9:01 PM · Product-Analytics (Kanban)
cchen created T258447: Virtual training for Superset/Turnilo .
Jul 20 2020, 8:57 PM · Product-Analytics (Kanban)
cchen moved T230092: Data exploration capabilities in Superset and Turnilo for editing data at “editor” level from Upcoming Quarter to Current Quarter on the Product-Analytics board.
Jul 20 2020, 4:22 PM · Product-Analytics
cchen moved T234839: Review Adam's Topic Dataset from Upcoming Quarter to Kanban on the Product-Analytics board.
Jul 20 2020, 4:15 PM · Product-Analytics (Kanban)
cchen moved T256025: Check Product Analytics team's standard datasets and remove COUNT(*) from Upcoming Quarter to Kanban on the Product-Analytics board.
Jul 20 2020, 4:05 PM · Product-Analytics (Kanban), Analytics-Radar

Jul 16 2020

cchen triaged T258131: July 2020 Wikimedia movement metrics as Medium priority.
Jul 16 2020, 7:17 AM · Product-Analytics (Kanban)
cchen created T258131: July 2020 Wikimedia movement metrics.
Jul 16 2020, 7:17 AM · Product-Analytics (Kanban)
cchen closed T255908: June 2020 Wikimedia movement metrics as Resolved.
Jul 16 2020, 7:16 AM · Product-Analytics (Kanban)

Jul 14 2020

cchen moved T256719: Add editors_monthly data to Druid from Triage to Tracking on the Product-Analytics board.
Jul 14 2020, 5:05 PM · Product-Analytics, Analytics
cchen edited projects for T256719: Add editors_monthly data to Druid, added: Product-Analytics; removed Product-Analytics (Kanban).
Jul 14 2020, 5:04 PM · Product-Analytics, Analytics

Jul 10 2020

cchen closed T252716: Investigate continued declines in new editor retention as Resolved.

The drop in new editor retention are from:

  • Lower retention rate from European languages wikis, like fr.wiki, de.wiki, pt.wiki and ru.wiki. See this chart in Superset for more details.
Jul 10 2020, 6:23 AM · Product-Analytics (Kanban)
cchen updated the task description for T257638: Topic Dataset : Model, Threshold, Post-processing.
Jul 10 2020, 4:52 AM · Product-Analytics (Kanban)

Jul 7 2020

cchen updated the task description for T253161: Review "Topics for each Wikipedia Article across Languages" dataset.
Jul 7 2020, 7:52 PM · Product-Analytics (Kanban)
cchen added a comment to T255207: Request admin access to Superset.

Thanks for granting us the access @elukey. I just checked with Maya, both of us can see the user list and update dashboards now.

Jul 7 2020, 6:07 PM · Analytics-Clusters, Product-Analytics
cchen closed T247331: Create revised version of Key Product Metrics for Product Leaders as Resolved.
Jul 7 2020, 5:02 PM · Product-Analytics (Kanban)

Jul 5 2020

cchen moved T255908: June 2020 Wikimedia movement metrics from Next 2 weeks to Doing on the Product-Analytics (Kanban) board.
Jul 5 2020, 6:44 AM · Product-Analytics (Kanban)

Jun 30 2020

cchen triaged T256719: Add editors_monthly data to Druid as Medium priority.
Jun 30 2020, 7:01 AM · Product-Analytics, Analytics
cchen added a parent task for T256050: Add dimensions to editors_daily dataset: T256719: Add editors_monthly data to Druid.
Jun 30 2020, 7:01 AM · Analytics-Kanban, Patch-For-Review, Product-Analytics, Analytics
cchen added a subtask for T256719: Add editors_monthly data to Druid: T256050: Add dimensions to editors_daily dataset.
Jun 30 2020, 7:01 AM · Product-Analytics, Analytics
cchen moved T256719: Add editors_monthly data to Druid from Next 2 weeks to Doing on the Product-Analytics (Kanban) board.
Jun 30 2020, 7:00 AM · Product-Analytics, Analytics
cchen moved T256719: Add editors_monthly data to Druid from Triage to Kanban on the Product-Analytics board.
Jun 30 2020, 7:00 AM · Product-Analytics, Analytics
cchen created T256719: Add editors_monthly data to Druid.
Jun 30 2020, 6:59 AM · Product-Analytics, Analytics
cchen moved T230092: Data exploration capabilities in Superset and Turnilo for editing data at “editor” level from Current Quarter to Upcoming Quarter on the Product-Analytics board.
Jun 30 2020, 3:59 AM · Product-Analytics

Jun 29 2020

cchen moved T234839: Review Adam's Topic Dataset from Current Quarter to Upcoming Quarter on the Product-Analytics board.
Jun 29 2020, 3:43 AM · Product-Analytics (Kanban)

Jun 26 2020

cchen updated the task description for T255816: Collect metrics/tables which might be touched by IP masking feature.
Jun 26 2020, 7:20 PM · Product-Analytics, Analytics-Radar
cchen updated the task description for T255816: Collect metrics/tables which might be touched by IP masking feature.
Jun 26 2020, 7:12 PM · Product-Analytics, Analytics-Radar
cchen closed T255723: Remove static axes from Reading & Editing dashboards in Superset as Resolved.

Updated static axes for charts in editing and readers dashboard.

Jun 26 2020, 3:43 PM · Product-Analytics (Kanban)

Jun 24 2020

cchen moved T255723: Remove static axes from Reading & Editing dashboards in Superset from Next 2 weeks to Doing on the Product-Analytics (Kanban) board.
Jun 24 2020, 6:43 PM · Product-Analytics (Kanban)

Jun 22 2020

cchen moved T256050: Add dimensions to editors_daily dataset from Triage to Tracking on the Product-Analytics board.
Jun 22 2020, 7:40 PM · Analytics-Kanban, Patch-For-Review, Product-Analytics, Analytics
cchen triaged T256050: Add dimensions to editors_daily dataset as Medium priority.
Jun 22 2020, 7:40 PM · Analytics-Kanban, Patch-For-Review, Product-Analytics, Analytics