Tool to generate statistics for plugin review admins

[Ipstenu]

We have a tool for repo stats - ​https://wordpress.org/plugins/admin?repostats=1 - which spits out this:

Plugin repository and SupportPress Stats

You can customize the default settings by manually providing query values:

date : The day up to which stats are to be gathered. In YYYY-MM-DD format. Defaults to today (2016-05-19).
days : The number of days before 'date' to include in stats. Default is 7.
recentdays : The number of days before today to consider as "recently" (stats marked with ). Default is 7.

Stats

Displaying stats for the 7 days preceding 2016-05-19 (and some for the 7 most recent days).

Plugin Status Change Stats

Plugins requested : 207
Plugins rejected : 53
Plugins closed : 25
Plugins approved : 139

Plugin Queue Stats (current)

Plugins in the queue* : 156
→ (older than 7 days ago) ** : 23
→ (since the beginning of the defined time window) : 101
→ (without a reply)* : 106

SupportPress Queue Stats

Total open tickets* : 6
→ (with no activity in last 7 days) ** : 2
Within defined 7 day time window:
Total : 138
Closed : 135
Open : 3

* : Stat reflects current size of queue and does not take into account 'date' or 'day' interval
** : Stat reflects activity only within the 'recentdays' from today

Obviously we don't need to edit the support press stuff, but we do need to the Change and Queue stats somehow.

@coffee2code may have insight here.

[obenland]

This feels like it will be more than a quick c/p job from the old system. I think @dd32 mentioned somewhere how we'll have to track times of status changes etc anyway, but I'm not sure we're both certain on how to go about it. Maybe revisions would be something that could work here?

[dd32]

Yeah, this will require the query to be rewritten from bb to wp table syntaxes, shouldn't be too difficult once the dates are stored - #1721

I don't think revisions are the answer here for storing history, they're too convoluted for automated querying, and audit log could work, but postmeta would be simplest.

[Ipstenu]

@dd32 - Is this still on the docket? I will need this :)

[Ipstenu]

FYI - We can't do proper posts on make/updates until this is resolved which means we've got lost documentation about our statistics for reviews/approvals/etc

[coffee2code]

In 5312:

Plugin Directory: Migrate stats admin tool over from bbPress1 implementation.

Shows plugin repo and SupportPress stats.

Available to plugin reviewers via Tools > Stats Report

Stats relating to the number of plugins rejected, approved, or delisted have not been logged since the switchover to WP. Stats for plugins requested may be suspect.

See #1726.

[Ipstenu]

The only aspect this is missing is the count of how many were closed. And I'm okay with that. We can revisit later.