668100 - Featured add-ons stats viewer

Status: RESOLVED WONTFIX

(addons.mozilla.org Graveyard :: Admin/Editor Tools, defect, P3)

Description

[Justin Scott [:fligtar]]

We need a way to let the people managing featured add-ons see the health of add-ons currently featured. We're now rotating featured add-ons on a monthly basis, but only adding new add-ons, not removing them, since there's not an easy way to see the retention.

A more complex tool can be devised later, but right now, all I need is:

-----------------------------------------------------------------------
|                   |    DOWNLOADS      |      ADU        |           |
| Add-on Name       |   start / now     |  start / now    | retention |
|---------------------------------------------------------------------|
| Password Exporter | 100,000 / 150,000 | 50,000 / 70,000 | 40%       |
-----------------------------------------------------------------------

start is the date that the add-on became featured, now is now, and retention is (now adu - start adu) / (now downloads - start downloads)

I should also be able to give particular AMO permission groups access to this page.

Comment 1

[Justin Scott [:fligtar]]

I wrote an sql query that basically does this, so this isn't a rush job anymore.

Comment 2

[Wil Clouser [:clouserw]]

featured apps and add-ons are a whole 'nuther thing now with their own pile of tools/wishes.  wontfixing this