Page MenuHomePhabricator

Add flagged revision status statistics to Wikistats 2.0
Open, LowPublic

Description

Nobody chimed in on the discussion of this, https://www.mediawiki.org/wiki/Topic:Tq5qpc3emof83azo, but I still think it's important and am adding it to the list of metrics to include in the near future with Wikistats 2.0.

Event Timeline

Thank you for remembering this and it is important .

Any hope that this would go forward?

I think that low hanging fruit statistics with historical data for all wmf wikis with flaggedrevs enabled

1.) Median graph from flagged revs statistics table.

https://quarry.wmflabs.org/query/42183

select 
   floor(frs_timestamp/1000000) as d, 
   frs_stat_key, round(avg(frs_stat_val)) as avg_frs_stat_val 
from 
   flaggedrevs_statistics 
where 
   frs_stat_key="pendingLag-average" 
group by d

2.) Number of pending pages in content namespace

https://quarry.wmflabs.org/query/42184

select 
   frs1.d, 
   syncedpagesNS0, 
   reviewedpagesNS0, 
   reviewedPagesNS0 - syncedPagesNS0 as pending_pages 
from 
   (
     select 
        floor(frs_timestamp/1000000) as d, 
        frs_stat_key, 
        round(avg(frs_stat_val)) as syncedPagesNS0 
    from 
       flaggedrevs_statistics 
    where 
       frs_stat_key="syncedPages-NS:0" 
    group by d
 ) as frs1, 
 (
    select 
       floor(frs_timestamp/1000000) as d, 
       frs_stat_key, 
       round(avg(frs_stat_val)) as reviewedPagesNS0 
    from 
      flaggedrevs_statistics 
    where 
      frs_stat_key="reviewedPages-NS:0" 
    group by d
) as frs2 
where 
   frs1.d=frs2.d 
order by frs1.d;
Nuria subscribed.

Putting on wikistats backlog. In the near team our plans are around reporting active editors for all wikis which is still a pending metric in wikistats so i doubt we would get to this.

Milimetric lowered the priority of this task from Medium to Low.Mar 6 2020, 4:47 PM
Milimetric moved this task from Backlog (Later) to Wikistats on the Analytics board.