[go: nahoru, domu]

Page MenuHomePhabricator

Update Wikifunctions Dashboard to reference new mediawiki_product_metrics_wikifunctions_ui table
Closed, ResolvedPublic

Description

The Wikilambda instrument was migrated to use core interaction events in T350497 and QA was completed in T358873.

We now need to update the presto queries currently used to generate all of the charts in the "Interaction metrics" tab of the wikifunctions superset dashboard to reference the new table event.mediawiki_product_metrics_wikifunctions_ui

In addition to changing the referenced table, queries will need to be updated to account for changes made in how events were organized and labeled in the table. See QA report for details.

Event Timeline

MNeisler renamed this task from Update Wikifunctions Dashboard to reference new table `event.mediawiki_product_metrics_wikifunctions_ui` to Update Wikifunctions Dashboard to reference new mediawiki_product_metrics_wikifunctions_ui table.Jun 17 2024, 3:15 PM
MNeisler created this task.
MNeisler triaged this task as Medium priority.Jun 24 2024, 5:02 PM
MNeisler moved this task from Next 2 weeks to Doing on the Product-Analytics (Kanban) board.

I've updated the "Interactions tab" of the wikifunctions superset dashboard to reference event.mediawiki_product_metrics_wikifunctions_ui.

Note: A sanitized version of data from this table is not currently on the allowlist and, as a result, all data from this table will be removed after 90 days. This will only impact data queried to create the charts on the "Interaction metrics Tab" of the dashboard. Data on the other tabs (pageviews, edits, unique devices) are kept indefinitely.

If you wish to retain any of the data from this table, there are a couple of options:
(1) Identify the key metrics that are valuable for the team to track over the long-term. For example, monthly functions call or function call completion rate. Product analytics can create an airflow pipeline to query the table daily or monthly and save the aggregate data for these metrics in a separate table retained past 90 days.
(2) Add any non-PII fields from mediawiki_product_metrics_wikifunctions_ui to the event sanitization allowlist so they are retained past 90 days. Note: The old stream and table wikifunctions_ui were added in T344277 and data for non-PII fields are currently retained past 90 days as long as that table remains available.

cc @Sharvaniharan