The v1 of the planned of the unified CX dashboard, at a minimum should consolidate the metrics from
- [[ https://superset.wikimedia.org/superset/dashboard/119 | CX key metrics on Superset ]]
- Special:CXStats
- [[ https://www.mediawiki.org/wiki/Content_translation/Deletion_statistics_comparison | CX deletion stats ]]
----
| Metric | Visualization Type | Data Source | Current Update Frequency | For Unified CX Dashboard | Required Update Frequency |
|--------------------------------------------------------------------------------------------|---------------------------------------------|----------------------|--------------------------|--------------------------|---------------------------|
| **CX key metrics** |
| Total translations since deployment | Big number | edit_hourly | monthly | keep | daily |
| Total translations for the selected time range | Big number | edit_hourly | monthly | keep | daily |
| Translations last calendar month | Big number with trendline | edit_hourly | monthly | remove[1] | - |
| Monthly translations year-over-year | Line chart (+ time comparison yoy) | edit_hourly | monthly | keep | monthly |
| User last calendar month | Big number with trendline | edit_hourly | monthly | remove[2] | - |
| Monthly translations by user edit count | Line chart (dimension: edit bucket) | edit_hourly | monthly | keep | monthly |
| Total translations deleted for selected time range | Big number | edit_hourly | monthly | keep | daily |
| Total translations reverted for selected time range | Big number | edit_hourly | monthly | keep | daily |
| Monthly rate of deleted translations | Line chart | edit_hourly | monthly | keep | monthly |
| Monthly rate of translations published high unmodified machine-translated text | Line chart (dimension: edit status) | edit_hourly | monthly | keep | monthly |
| Monthly translations by wiki (top 10) | Line chart (dimension: wiki_db) | edit_hourly | monthly | keep | monthly |
| Average new translator retention for selected time range | Big number | mediawiki_history | monthly | keep | monthly |
| Total number of new users that published a translation 30 days after registration | Big number | mediawiki_history | monthly | keep | monthly |
| New translator retention last month | Line chart (+ time comparison yoy) | mediawiki_history | monthly | keep | monthly |
| Monthly new translator retention year over year | Big number with trendline | mediawiki_history | monthly | keep | monthly |
| **Special:CXStats**
| Total published translations all time (for a given wiki) | Big number | cx_translations | real-time | remove[3] | daily |
| Total published translations last week (for a given wiki) | Big number | cx_translations | real-time | remove[4] | daily |
| Translation to all languages | Line chart (dimension: published/in progress) | cx_translations | real-time | remove[5] | daily |
| Translation to given wiki | Line chart (dimension: published/in progress/deleted) | cx_translations | //real-time// | remove[6] | daily |
| Published translations (from source to targets) | Stacked bar chart (dimension: target) | cx_translations | //real-time// | keep | daily |
| Published translations (from targets to source) | Stacked bar chart (dimension: source) | cx_translations | //real-time// | keep | daily |
| Translations in progress (from source to targets) | Stacked bar chart (dimension: target) | cx_translations | //real-time// | keep | daily |
| Translations in progress (from targets to source) | Stacked bar chart (dimension: source) | cx_translations | //real-time// | keep | daily |
| Number of translators (from source to targets) | Stacked bar chart (dimension: target) | cx_translators | //real-time// | modify[7] | daily |
| Number of translators (from targets to source) | Stacked bar chart (dimension: source) | cx_translators | //real-time// | modify[8] | daily |
| **CX deletion stats**
| Overall CX articles deletion ratio | - | mediawiki_history | quarterly | keep | tbd |
| Overall non-CX articles deletion ratio | - | mediawiki_history | quarterly | keep | tbd |
| Number of wikis with higher cx article deletion ratios | - | mediawiki_history | quarterly | keep | tbd |
| Wiki with the highest deletion ratio difference | - | mediawiki_history | quarterly | keep | tbd |
| Breakdown of deletion ratios by wiki (with higher cx deletion ratio) | Table | mediawiki_history | quarterly | keep | tbd
- [1][2]: Both these numbers can be gathered from the adjacent charts of monthly translations yoy.
- [3]: Already covered under key metrics: Total translations since deployment
- [4]: Instead of defaulting to a wiki, "Total translations for the selected time range" will let users to select whatever period they're interested in.
- [5][6]: Displaying all wikis irrespective of the filter might not be useful. "Monthly translations year-over-year" shows the information, but works based on the filter.
- [7][8]: Combine these with translator metrics from the key metrics. It is better to have monthly unique translation with a year-over-year time window for comparision.
----
List of other open tasks that can potentially be addressed as part of this development
| Task | Notes | Can it be addressed with unified CX dashboard v1? |
|-----------|-------------------------------------------------------------------------------------------------------------------------------|--------------------------------------------------|
| {T100029} | planned for a selected time range based on the filter, but we can also show unfiltered monthly / weekly numbers if needed. | yes |
| {T94806} | for the dashboard and data aggregations, we will follow the [modelling guidelines](https://wikitech.wikimedia.org/wiki/Data_modeling_guidelines#Timestamps) - it should address this task | yes |
| {T100033} | this can be a useful metric to understand adoption CX among other tools | yes |
| {T100034} | can be part of "Translators" tab of the dashboard | yes |
| {T100035} | we currently have this by user edit bucket | no |
| {T103983} | should be fixed with proper filters and scoping | yes |
| {T117855} | internally this is already addressed with having "Translation status" filter | yes |
| {T113337} | - | yes |
| {T137700} | Superset Echarts provides decent interactivity; not sure of pan/zoom | maybe |
| {T123898} | - | maybe |
| {T123859} | internally this is already addressed with having "Translation status" filter | yes |
| {T88281} | - | - |
| {T113336} | dependent on funnel analysis using CX event | no |
| {T228152} | key metrics address this(?) | maybe |
| {T185110} | - | maybe |
| {T94385} | - | yes |