Page MenuHomePhabricator

cchen (connie)
User

Projects

Today

  • Clear sailing ahead.

Tomorrow

  • Clear sailing ahead.

Sunday

  • Clear sailing ahead.

User Details

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

Recent Activity

Tue, Apr 13

cchen moved T278873: [FY2020-21 Q3 Tuning Session] Worldwide Readership Metrics from Next 2 weeks to Doing on the Product-Analytics (Kanban) board.
Tue, Apr 13, 5:09 PM · Product-Analytics (Kanban)
cchen moved T278874: [FY2020-21 Q3 Tuning Session] Thriving Movement Metrics from Next 2 weeks to Doing on the Product-Analytics (Kanban) board.
Tue, Apr 13, 5:09 PM · Product-Analytics (Kanban)
cchen added a comment to T273823: Reconcile datasets in Superset with Key Product Metrics.

Link to the document under data dictionary: https://www.mediawiki.org/wiki/Wikimedia_Product/Data_dictionary/Reconcile_datasets_in_Superset_with_Key_Product_Metrics

Tue, Apr 13, 5:00 PM · Product-Analytics (Kanban)

Wed, Apr 7

cchen moved T277807: March 2021 Wikimedia movement metrics from Next 2 weeks to Doing on the Product-Analytics (Kanban) board.
Wed, Apr 7, 9:41 PM · Product-Analytics (Kanban)
cchen moved T268089: Content dataset with pageviews, edits and topics from Doing to Next 2 weeks on the Product-Analytics (Kanban) board.
Wed, Apr 7, 9:41 PM · Product-Analytics (Kanban)
cchen moved T273313: [SessionLength] SessionLength Documentation from Doing to QA/Review on the Better Use Of Data board.
Wed, Apr 7, 9:39 PM · Better Use Of Data
cchen reassigned T273313: [SessionLength] SessionLength Documentation from cchen to kzimmerman.
Wed, Apr 7, 9:39 PM · Better Use Of Data
cchen added a comment to T273313: [SessionLength] SessionLength Documentation.

Updated sample query and the code used to transform raw data into intermediate table.

Wed, Apr 7, 9:38 PM · Better Use Of Data

Tue, Apr 6

cchen added a comment to T273313: [SessionLength] SessionLength Documentation.

Updated the document and linked it with relevant pages.

Tue, Apr 6, 3:36 PM · Better Use Of Data

Mon, Apr 5

cchen moved T267496: [SessionLength] Allow data consumers to interact with data related to Session Length from Doing to Needs Review on the Product-Analytics (Kanban) board.
Mon, Apr 5, 7:27 AM · Product-Analytics (Kanban), Product-Data-Infrastructure, Better Use Of Data
cchen moved T277807: March 2021 Wikimedia movement metrics from Upcoming Quarter to Kanban on the Product-Analytics board.
Mon, Apr 5, 7:26 AM · Product-Analytics (Kanban)

Thu, Apr 1

cchen closed T278502: [REQUEST] Editor count for Product Platform Strategy deck as Resolved.

Got the reply from Carol that she will stick to the numbers in the deck to avoid messing up the model.
Another note is, the definition for "established" markets in the deck is US, CA, JP, and Europe

Thu, Apr 1, 5:18 AM · Product-Analytics (Kanban)

Wed, Mar 31

cchen updated the task description for T273313: [SessionLength] SessionLength Documentation.
Wed, Mar 31, 6:18 PM · Better Use Of Data
cchen moved T267496: [SessionLength] Allow data consumers to interact with data related to Session Length from Doing to QA/Review on the Better Use Of Data board.
Wed, Mar 31, 6:14 PM · Product-Analytics (Kanban), Product-Data-Infrastructure, Better Use Of Data

Thu, Mar 25

cchen added a comment to T267496: [SessionLength] Allow data consumers to interact with data related to Session Length.

Session length dashboard with production data :

Thu, Mar 25, 7:41 PM · Product-Analytics (Kanban), Product-Data-Infrastructure, Better Use Of Data
cchen updated the task description for T267496: [SessionLength] Allow data consumers to interact with data related to Session Length.
Thu, Mar 25, 7:39 PM · Product-Analytics (Kanban), Product-Data-Infrastructure, Better Use Of Data
hdothiduc awarded T272825: Update 2020 data about top articles for Wikipedia's 20th birthday a Like token.
Thu, Mar 25, 8:05 AM · Product-Analytics (Kanban)

Mon, Mar 22

cchen closed T272825: Update 2020 data about top articles for Wikipedia's 20th birthday as Resolved.
Mon, Mar 22, 6:00 PM · Product-Analytics (Kanban)

Fri, Mar 19

cchen closed T272051: Details on the emerging market pageviews and edits as Resolved.
Fri, Mar 19, 9:43 PM · Product-Analytics (Kanban)
cchen moved T273823: Reconcile datasets in Superset with Key Product Metrics from Next 2 weeks to Doing on the Product-Analytics (Kanban) board.
Fri, Mar 19, 9:39 PM · Product-Analytics (Kanban)

Thu, Mar 18

cchen moved T277807: March 2021 Wikimedia movement metrics from Backlog to Upcoming Quarter on the Product-Analytics board.
Thu, Mar 18, 9:20 PM · Product-Analytics (Kanban)
cchen moved T277807: March 2021 Wikimedia movement metrics from Triage to Backlog on the Product-Analytics board.
Thu, Mar 18, 9:20 PM · Product-Analytics (Kanban)
cchen triaged T277807: March 2021 Wikimedia movement metrics as Medium priority.
Thu, Mar 18, 9:19 PM · Product-Analytics (Kanban)
cchen closed T277477: February 2021 Wikimedia movement metrics as Resolved.
Thu, Mar 18, 9:19 PM · Product-Analytics (Kanban)
cchen created T277807: March 2021 Wikimedia movement metrics.
Thu, Mar 18, 9:19 PM · Product-Analytics (Kanban)

Mar 16 2021

cchen reopened T267496: [SessionLength] Allow data consumers to interact with data related to Session Length as "Open".

Reopen this for the optimized intermediate session length data set mentioned in T277512.

Mar 16 2021, 10:35 PM · Product-Analytics (Kanban), Product-Data-Infrastructure, Better Use Of Data
cchen reopened T267496: [SessionLength] Allow data consumers to interact with data related to Session Length, a subtask of T267494: [SessionLength] View how long users interact with our products, as Open.
Mar 16 2021, 10:35 PM · Epic, Product-Data-Infrastructure, Product-Analytics, Better Use Of Data
cchen added a comment to T273313: [SessionLength] SessionLength Documentation.

Data dictionary for session_length_daily table is available here: https://www.mediawiki.org/wiki/Wikimedia_Product/Data_dictionary/session_length_daily

Mar 16 2021, 5:24 PM · Better Use Of Data

Mar 15 2021

cchen closed T267496: [SessionLength] Allow data consumers to interact with data related to Session Length as Resolved.

Reviewed dashboard with Kate.

Mar 15 2021, 9:29 PM · Product-Analytics (Kanban), Product-Data-Infrastructure, Better Use Of Data
cchen closed T267496: [SessionLength] Allow data consumers to interact with data related to Session Length, a subtask of T267494: [SessionLength] View how long users interact with our products, as Resolved.
Mar 15 2021, 9:29 PM · Epic, Product-Data-Infrastructure, Product-Analytics, Better Use Of Data
cchen moved T277102: [SessionLength] Prepare demo of Superset dashboard for May 2021 staff meeting from Inbox to To Do on the Better Use Of Data board.
Mar 15 2021, 4:17 PM · Product-Analytics, Better Use Of Data
cchen moved T273823: Reconcile datasets in Superset with Key Product Metrics from Doing to Next 2 weeks on the Product-Analytics (Kanban) board.
Mar 15 2021, 4:08 PM · Product-Analytics (Kanban)
cchen triaged T277477: February 2021 Wikimedia movement metrics as Medium priority.
Mar 15 2021, 4:07 PM · Product-Analytics (Kanban)
cchen created T277477: February 2021 Wikimedia movement metrics.
Mar 15 2021, 4:07 PM · Product-Analytics (Kanban)
cchen closed T272641: January 2021 Wikimedia movement metrics as Resolved.
Mar 15 2021, 4:06 PM · Product-Analytics (Kanban)

Mar 12 2021

cchen added a comment to T267496: [SessionLength] Allow data consumers to interact with data related to Session Length.

Link to ashboard with production dataset (wmf.session_length_daily): https://superset.wikimedia.org/r/495.

Mar 12 2021, 2:40 PM · Product-Analytics (Kanban), Product-Data-Infrastructure, Better Use Of Data
cchen updated the task description for T267496: [SessionLength] Allow data consumers to interact with data related to Session Length.
Mar 12 2021, 4:41 AM · Product-Analytics (Kanban), Product-Data-Infrastructure, Better Use Of Data

Mar 9 2021

cchen added a comment to T267496: [SessionLength] Allow data consumers to interact with data related to Session Length.

The sample rate for dashboard was updated to 1/10.

Mar 9 2021, 11:11 PM · Product-Analytics (Kanban), Product-Data-Infrastructure, Better Use Of Data

Mar 8 2021

cchen updated the task description for T276849: [REQUEST] Caption and alternative text data related to image files.
Mar 8 2021, 6:47 PM · Research, Product-Analytics
cchen renamed T276849: [REQUEST] Caption and alternative text data related to image files from [REQUEST] to [REQUEST] Caption and alternative text data related to image files.
Mar 8 2021, 6:11 PM · Research, Product-Analytics
cchen created T276849: [REQUEST] Caption and alternative text data related to image files.
Mar 8 2021, 6:09 PM · Research, Product-Analytics

Mar 3 2021

cchen added a comment to T272825: Update 2020 data about top articles for Wikipedia's 20th birthday.

@hdothiduc thanks for pointing this out. the pageviews for #1 article in Chinese Wikipedia has one more digit by mistake. I've updated the number in the file.

Mar 3 2021, 8:17 AM · Product-Analytics (Kanban)

Feb 25 2021

cchen closed T275741: February 2021 Wikimedia movement metrics as Resolved.
Feb 25 2021, 8:32 AM · Product-Analytics (Kanban)
cchen triaged T275741: February 2021 Wikimedia movement metrics as Medium priority.
Feb 25 2021, 8:32 AM · Product-Analytics (Kanban)
cchen moved T275741: February 2021 Wikimedia movement metrics from Triage to Kanban on the Product-Analytics board.
Feb 25 2021, 8:32 AM · Product-Analytics (Kanban)
cchen created T275741: February 2021 Wikimedia movement metrics.
Feb 25 2021, 8:31 AM · Product-Analytics (Kanban)

Feb 24 2021

cchen closed T271849: Add Platform evolution/reuse and structured data metrics to Key Product Metrics as Resolved.

The platform evolution/structured data metrics were added to key product metrics slides in January, with chart for each metric (slides).

Feb 24 2021, 8:03 PM · Product-Analytics (Kanban)
cchen moved T271849: Add Platform evolution/reuse and structured data metrics to Key Product Metrics from Current Quarter to Kanban on the Product-Analytics board.
Feb 24 2021, 7:56 PM · Product-Analytics (Kanban)
cchen added a comment to T267496: [SessionLength] Allow data consumers to interact with data related to Session Length.

Switch the data source for dashboard to session_length_daily table.

Feb 24 2021, 7:55 PM · Product-Analytics (Kanban), Product-Data-Infrastructure, Better Use Of Data

Feb 16 2021

cchen added a comment to T272825: Update 2020 data about top articles for Wikipedia's 20th birthday.

@hdothiduc It sounds good to me.

Feb 16 2021, 6:05 PM · Product-Analytics (Kanban)
cchen moved T272641: January 2021 Wikimedia movement metrics from Next 2 weeks to Doing on the Product-Analytics (Kanban) board.
Feb 16 2021, 6:00 PM · Product-Analytics (Kanban)

Feb 10 2021

cchen added a comment to T267496: [SessionLength] Allow data consumers to interact with data related to Session Length.

In Superset data table session_length:

Feb 10 2021, 4:40 PM · Product-Analytics (Kanban), Product-Data-Infrastructure, Better Use Of Data

Feb 8 2021

cchen moved T272825: Update 2020 data about top articles for Wikipedia's 20th birthday from Doing to Needs Review on the Product-Analytics (Kanban) board.
Feb 8 2021, 9:17 AM · Product-Analytics (Kanban)
cchen added a comment to T272825: Update 2020 data about top articles for Wikipedia's 20th birthday.

Hi @hdothiduc, the full year data for 2020 is updated in here.

Feb 8 2021, 9:17 AM · Product-Analytics (Kanban)
cchen moved T272641: January 2021 Wikimedia movement metrics from Doing to Next 2 weeks on the Product-Analytics (Kanban) board.
Feb 8 2021, 8:39 AM · Product-Analytics (Kanban)
cchen moved T272641: January 2021 Wikimedia movement metrics from Next 2 weeks to Doing on the Product-Analytics (Kanban) board.
Feb 8 2021, 8:39 AM · Product-Analytics (Kanban)
cchen moved T272825: Update 2020 data about top articles for Wikipedia's 20th birthday from Next 2 weeks to Doing on the Product-Analytics (Kanban) board.
Feb 8 2021, 8:39 AM · Product-Analytics (Kanban)

Feb 3 2021

cchen moved T272825: Update 2020 data about top articles for Wikipedia's 20th birthday from Current Quarter to Kanban on the Product-Analytics board.
Feb 3 2021, 9:23 PM · Product-Analytics (Kanban)

Feb 1 2021

cchen moved T268088: Content dataset with pageviews, edits and content properties from Doing to Next 2 weeks on the Product-Analytics (Kanban) board.
Feb 1 2021, 7:07 PM · Product-Analytics (Kanban)
cchen moved T257638: Topic Dataset : Model, Threshold, Post-processing from Triage to Current Quarter on the Product-Analytics board.
Feb 1 2021, 7:07 PM · Product-Analytics
cchen edited projects for T257638: Topic Dataset : Model, Threshold, Post-processing, added: Product-Analytics; removed Product-Analytics (Kanban).
Feb 1 2021, 7:07 PM · Product-Analytics
cchen closed T272099: Prepare Worldwide Readership & Thriving Movement metrics slides and narratives as Resolved.

Presented at Q2 Tuning session

Feb 1 2021, 7:06 PM · Product-Analytics (Kanban)
cchen closed T272099: Prepare Worldwide Readership & Thriving Movement metrics slides and narratives, a subtask of T272096: Prepare slides and narrative for FY2020-21/Q2 Tuning Sessions, as Resolved.
Feb 1 2021, 7:06 PM · Product-Analytics (Kanban)
cchen moved T267496: [SessionLength] Allow data consumers to interact with data related to Session Length from To Do to Doing on the Better Use Of Data board.
Feb 1 2021, 7:04 PM · Product-Analytics (Kanban), Product-Data-Infrastructure, Better Use Of Data

Jan 28 2021

cchen moved T267496: [SessionLength] Allow data consumers to interact with data related to Session Length from Upcoming Quarter to Current Quarter on the Product-Analytics board.
Jan 28 2021, 4:30 AM · Product-Analytics (Kanban), Product-Data-Infrastructure, Better Use Of Data

Jan 25 2021

cchen added a comment to T272051: Details on the emerging market pageviews and edits.

Hi @Arrbee, please find pageviews breakdown by topics for Q2/2020 and Q2/2019.

Jan 25 2021, 10:07 PM · Product-Analytics (Kanban)
cchen moved T272825: Update 2020 data about top articles for Wikipedia's 20th birthday from Triage to Current Quarter on the Product-Analytics board.
Jan 25 2021, 8:34 AM · Product-Analytics (Kanban)
cchen triaged T272825: Update 2020 data about top articles for Wikipedia's 20th birthday as Medium priority.
Jan 25 2021, 8:34 AM · Product-Analytics (Kanban)
cchen created T272825: Update 2020 data about top articles for Wikipedia's 20th birthday.
Jan 25 2021, 8:30 AM · Product-Analytics (Kanban)
cchen moved T272051: Details on the emerging market pageviews and edits from Next 2 weeks to Doing on the Product-Analytics (Kanban) board.
Jan 25 2021, 7:42 AM · Product-Analytics (Kanban)

Jan 21 2021

cchen triaged T272641: January 2021 Wikimedia movement metrics as Medium priority.
Jan 21 2021, 9:51 PM · Product-Analytics (Kanban)
cchen created T272641: January 2021 Wikimedia movement metrics.
Jan 21 2021, 9:51 PM · Product-Analytics (Kanban)
cchen closed T270791: December 2020 Wikimedia movement metrics as Resolved.
Jan 21 2021, 9:51 PM · Product-Analytics (Kanban)

Jan 19 2021

cchen moved T272051: Details on the emerging market pageviews and edits from Triage to Kanban on the Product-Analytics board.
Jan 19 2021, 6:08 PM · Product-Analytics (Kanban)

Jan 14 2021

cchen triaged T272051: Details on the emerging market pageviews and edits as Medium priority.
Jan 14 2021, 4:30 PM · Product-Analytics (Kanban)
cchen created T272051: Details on the emerging market pageviews and edits.
Jan 14 2021, 4:28 PM · Product-Analytics (Kanban)

Jan 11 2021

cchen added a comment to T271601: Axios data request: 2001-2021.

@Cdesoto705 Thanks for submitting a ticket. The Product Analytics will review and prioritize this request during our next board review meeting tomorrow 12 January 2021.

Jan 11 2021, 9:01 AM · Product-Analytics (Kanban)

Jan 5 2021

cchen added a comment to T262954: Add editors metrics to Superset key metrics dashboards .

project and project family filter added to the editors dashboard in Superset.

Jan 5 2021, 7:00 PM · Product-Analytics (Kanban)
cchen moved T257636: Technical Requirements for Content dataset from Upcoming Quarter to Current Quarter on the Product-Analytics board.
Jan 5 2021, 6:19 PM · Product-Analytics
cchen moved T262954: Add editors metrics to Superset key metrics dashboards from Upcoming Quarter to Current Quarter on the Product-Analytics board.
Jan 5 2021, 6:19 PM · Product-Analytics (Kanban)
cchen moved T270791: December 2020 Wikimedia movement metrics from Next 2 weeks to Doing on the Product-Analytics (Kanban) board.
Jan 5 2021, 6:02 PM · Product-Analytics (Kanban)

Dec 23 2020

cchen edited projects for T270791: December 2020 Wikimedia movement metrics, added: Product-Analytics (Kanban); removed Product-Analytics.
Dec 23 2020, 8:37 PM · Product-Analytics (Kanban)
cchen triaged T270791: December 2020 Wikimedia movement metrics as Medium priority.
Dec 23 2020, 8:36 PM · Product-Analytics (Kanban)
cchen created T270791: December 2020 Wikimedia movement metrics.
Dec 23 2020, 8:36 PM · Product-Analytics (Kanban)
cchen closed T268209: November 2020 Wikimedia movement metrics as Resolved.
Dec 23 2020, 8:36 PM · Product-Analytics (Kanban)

Dec 22 2020

cchen closed T268262: [REQUEST] End-of-year pageview statistics as Resolved.
Dec 22 2020, 6:53 AM · Product-Analytics (Kanban)

Dec 17 2020

cchen moved T268262: [REQUEST] End-of-year pageview statistics from Doing to Needs Review on the Product-Analytics (Kanban) board.
Dec 17 2020, 9:03 AM · Product-Analytics (Kanban)

Dec 16 2020

cchen added a comment to T268262: [REQUEST] End-of-year pageview statistics.

@EdErhart-WMF here's the updated data for page and pageviews between 2020/01/01 - 2020/12/15

Dec 16 2020, 6:39 PM · Product-Analytics (Kanban)

Dec 15 2020

cchen moved T268262: [REQUEST] End-of-year pageview statistics from Needs Review to Doing on the Product-Analytics (Kanban) board.
Dec 15 2020, 6:23 PM · Product-Analytics (Kanban)
cchen added a comment to T268089: Content dataset with pageviews, edits and topics .

After reviewing the feedback with Kate, we want to have aggregation for each level of topics.
The next step is to create another table to use in Superset based on this schema.

Dec 15 2020, 6:19 PM · Product-Analytics (Kanban)
cchen moved T268185: Email about Superset updates from Doing to Needs Sign-off on the Product-Analytics (Kanban) board.
Dec 15 2020, 6:07 PM · Product-Analytics (Kanban)
cchen moved T268185: Email about Superset updates from Next 2 weeks to Doing on the Product-Analytics (Kanban) board.
Dec 15 2020, 5:57 AM · Product-Analytics (Kanban)

Dec 14 2020

cchen added a comment to T268185: Email about Superset updates.

FY20-21 Q2 Superset Updates email sent out today.

Dec 14 2020, 6:21 PM · Product-Analytics (Kanban)
cchen added a comment to T268089: Content dataset with pageviews, edits and topics .

Added cchen.repo_topic_pv_edit table as a data source in Superset. And created monthly topic pageviews and edits dashboard in Superset.

Dec 14 2020, 9:08 AM · Product-Analytics (Kanban)
cchen moved T268209: November 2020 Wikimedia movement metrics from Next 2 weeks to Doing on the Product-Analytics (Kanban) board.
Dec 14 2020, 7:44 AM · Product-Analytics (Kanban)
cchen closed T261446: [REQUEST] Data about top articles for Wikipedia's 20th birthday as Resolved.
Dec 14 2020, 7:44 AM · Product-Analytics (Kanban)

Dec 11 2020

hdothiduc awarded T261446: [REQUEST] Data about top articles for Wikipedia's 20th birthday a 100 token.
Dec 11 2020, 6:44 PM · Product-Analytics (Kanban)

Dec 9 2020

cchen added a comment to T261446: [REQUEST] Data about top articles for Wikipedia's 20th birthday.

Top pages with pageviews and edits by wiki were update in this folder. We reviewed text and notes for the data this week.

Dec 9 2020, 9:11 PM · Product-Analytics (Kanban)
cchen added a comment to T268089: Content dataset with pageviews, edits and topics .

Dataset: cchen.article_pv_edit with monthly data from 2020/06- 2020/11 from top 23 Wikipedias.

Dec 9 2020, 8:36 PM · Product-Analytics (Kanban)
cchen updated the task description for T268790: Feedback on sample content dataset and dashboards.
Dec 9 2020, 10:07 AM · Product-Analytics (Kanban)