858298 - Add Total Ratings to app detail statistics

Status: RESOLVED FIXED

(Marketplace Graveyard :: Statistics, enhancement, P2)

Description

[Wil Clouser [:clouserw]]

Please add a simple 1-line graph to the app-specific statistics pages (eg. https://marketplace.firefox.com/app/twitter/statistics/?last=30)  called "Total Ratings".

The only selector on this graph is date, like the current graphs.

This follows the regular permissions of being developer only unless they opt-in to public.

Comment 1

[Rob Hudson [:robhudson]]

Added ability to do these queries to the Monolith API:
https://github.com/mozilla/zamboni/commit/c1ab915

Comment 2

[Rob Hudson [:robhudson]]

Would it make sense to change this so the histogram chart shows number of ratings each day. Then our "totals" api can report the total ratings of the app (or globally) at the time of the request?

Just visualizing it I liked the idea of seeing number of ratings over time vs a graph that goes from lower left to upper right.

Comment 3

[Wil Clouser [:clouserw]]

Sure - you've got full license to make things better than described :)

Comment 4

[Rob Hudson [:robhudson]]

Updated to be ratings per day over time:
https://github.com/mozilla/zamboni/commit/450f75b

Comment 5

[Rob Hudson [:robhudson]]

Ratings added to stats API:
https://github.com/mozilla/zamboni/commit/b5d824f 

See docs on usage:
http://firefox-marketplace-api.readthedocs.org/en/latest/topics/stats.html#ratings
http://firefox-marketplace-api.readthedocs.org/en/latest/topics/stats.html#id2
http://firefox-marketplace-api.readthedocs.org/en/latest/topics/stats.html#global-totals
http://firefox-marketplace-api.readthedocs.org/en/latest/topics/stats.html#per-app-totals

Comment 6

[Iulian Timis]

Please add STR here or mark it with [qa-] if no QA is needed.

Comment 7

[Rob Hudson [:robhudson]]

Same as https://bugzilla.mozilla.org/show_bug.cgi?id=858299#c4 but for ratings.

Comment 8

[Rob Hudson [:robhudson]]

Re-opening for charts.

Comment 9

[Rob Hudson [:robhudson]]

Added new ratings charts for both global and per-app stats:
https://github.com/mozilla/marketplace-stats/commit/9982e56b

Comment 10

[krupa raj[:krupa]]

Installs, ratings and abuse reports all have related data in prod:

{"installs":{"min":1.0,"sum_of_squares":135875829.0,"max":3708.0,"std_deviation":86.465394369124823,"variance":7476.2644234082836,"total":346139.0,"mean":20.071846912148448},"ratings":{"min":1.0,"sum_of_squares":37690.0,"max":125.0,"std_deviation":7.9149340561401829,"variance":62.646181113047682,"total":1298.0,"mean":2.3471971066907775},"abuse_reports":{"min":1.0,"sum_of_squares":121.0,"max":4.0,"std_deviation":0.52055545387538948,"variance":0.27097798055941275,"total":85.0,"mean":1.1971830985915493}}

However on stage, https://marketplace.allizom.org/api/v1/stats/app/twitter/totals/ here are the issues
1. Ratings and abuse reports data is missing even though the app has reviews and abuse reports
2. Install data doesn't match the value in lookup tool

Comment 11

[krupa raj[:krupa]]

{"installs":{"min":1.0,"sum_of_squares":1663795.0,"max":257.0,"std_deviation":80.736156277883694,"variance":6518.3269305268595,"total":9535.0,"mean":54.176136363636367},"ratings":{},"abuse_reports":{}}

ratings and abuse_reports don't have any info on stage.

Comment 12

[Rob Hudson [:robhudson]]

Stats were behind on stage. Jason just ran them for all of February.

> However on stage,
> https://marketplace.allizom.org/api/v1/stats/app/twitter/totals/ here are
> the issues
> 1. Ratings and abuse reports data is missing even though the app has reviews
> and abuse reports
> 2. Install data doesn't match the value in lookup tool

Can we focus on ratings for this bug?

Comment 13

[krupa raj[:krupa]]

(In reply to Rob Hudson [:robhudson] from comment #12)
> Stats were behind on stage. Jason just ran them for all of February.
> 
> > However on stage,
> > https://marketplace.allizom.org/api/v1/stats/app/twitter/totals/ here are
> > the issues
> > 1. Ratings and abuse reports data is missing even though the app has reviews
> > and abuse reports
> > 2. Install data doesn't match the value in lookup tool
> 
> Can we focus on ratings for this bug?

of course.

Comment 14

[Rob Hudson [:robhudson]]

I think this bug is done. Looking back I'm confused by what needs to be done here. Can we re-verify please?