960801 - [dev] Weekly Report on IARC ratings (Mar 21)

Status: RESOLVED FIXED

(Marketplace Graveyard :: General, defect, P3)

Description

[Karen Ward [:kward]]

++ This bug was initially created as a clone of Bug #948100 +++

Need a WEEKLY report to track progress of Developers updating their apps to include IARC Ratings. This report should show which apps have and do not have an IARC rating. See 948100 for details from Rob Hudson on the query. 

Please distribute report to: Karen Ward, Caitlin Galimidi, Lisa Brewster, David Bialer, David Almstrom and Umika Devi.

Comment 1

[Karen Ward [:kward]]

Starting with the March 21 extract, please include the following data in the report for Apps WITHOUT Ratings:
App ID, App Name, Developer Email,Platform (Desktop, Android Mobile, Android Tablet, FireFox OS), Mozilla Contact, Category 1,Category 2, Number of Downloads, User Ratings, and the list of countries where the app is listed.

Comment 2

[Rob Hudson [:robhudson]]

(In reply to Karen Ward [:kward] from comment #1)
> Starting with the March 21 extract, please include the following data in the
> report for Apps WITHOUT Ratings:
> App ID, App Name, Developer Email,Platform (Desktop, Android Mobile, Android
> Tablet, FireFox OS), Mozilla Contact, Category 1,Category 2, Number of
> Downloads, User Ratings, and the list of countries where the app is listed.

Would a URL to the lookup tool detail page work? I'm not sure I can get all of this in a single query. If not, I'll have to rewrite this as a script to do multiple queries and pull together all the data.

Comment 3

[Lisa Brewster [:adora]]

A link to the lookup tool won't work.  We need that data all in one list so that we can start prioritizing the remaining apps.

Comment 4

[Wil Clouser [:clouserw]]

Rob is using a single SQL query to generate these, not a full script.  Rob - include any fields you can, stuff like moz contact, downloads, and rating should be easy.  If you can't magic-join in stuff like the list of countries skip it for now.  Lisa - I'm on IRC if you want to chat about priorities and we can figure something out, I'm not sure how critical some of those fields are. Thanks.

Comment 5

[Rob Hudson [:robhudson]]

Email sent. All additional fields were included except countries.