550893 - Add a cross-locale dashboard to compare locale stats

Status: RESOLVED FIXED

(support.mozilla.org :: Localization, task)

Description

[Axel Hecht [:Pike]]

It'd be good to know which locales are doing how across locales. Just a simple metric per locale, showing them all in one page, similar to what we do on the product or amo dashboards.

Comment 1

[David Tenser [:djst]]

Yes, it'd be very useful. This is actually related to tracking the overall l10n completion on SUMO, which is something we'd like to keep track of anyway. 

Cheng, is this something that we can get out of the Tiki db and export to e.g. a csv/spreadsheet for public viewing?

Comment 2

[David Tenser [:djst]]

I spent 30 minutes going through each locale's http://support.mozilla.com/%LOCALE%/kb/all+Knowledge+Base+articles manually and created this spreadsheet: http://spreadsheets.google.com/ccc?key=tSklOlSt-Bk48v03UMVgCUA&hl=en

Look in column D. This at least provides a static overview as of March 17 2010, but it will have to be manually updated to remain up to date.

The other columns are not updated, but this bug is specifically about getting an overview of the SUMO KB status per locale, and that's what column D provides.

Comment 3

[Axel Hecht [:Pike]]

That's pretty nifty.

If we want to relate the sumo data with ADUs, which sounds like a good idea, maybe "we" can export the data into the metrics database and hold one version of the dashboard there.

A direct JSON export for the column D data would be good for the l10n.m.o dashboard, too.

Comment 4

[David Tenser [:djst]]

Note that I'm using a 7-day total of ADUs to get a more stable userbase % per locale.

Axel, when you say "we", do you mean that the SUMO team should export this data to the l10n drivers? Just want to make sure that we're on the same page here. :) Cheng is about to write a simple perl script that pulls this data out of the html output because apparently calculating the numbers straight from the db is more complicated.

Cheng, does a JSON export fall in line with what you suggested before about writing a Perl script to get the column D data? Is that just a matter of reformatting the resulting output?

Comment 5

[[:Cww]]

Unfortunately, I've been unable to install the JSON perl module on sumotools but if you give me a formatting example, I can manually construct it.

Comment 6

[Kadir Topal [:atopal]]

Cheng, the JSON format is super simple,{"name":"value",}, have a look at the wikipage: http://en.wikipedia.org/wiki/JSON

Comment 7

[Axel Hecht [:Pike]]

Additional kudos for sending it with cross-site xhr headers, https://developer.mozilla.org/En/HTTP_Access_Control. Non-preflighted GET should be good enough. That's what you can do with current jquery and $.getJSON.

Comment 8

[Rosana Ardila]

Really looking forward for this. Let me know if I can be of any help.

Comment 9

[Kadir Topal [:atopal]]

Rosana, this is not part of our L10n tools project, maybe it should be?

Comment 10

[Rosana Ardila]

Kadir, isn't it more a question of having the time next quarter?

Comment 11

[Kadir Topal [:atopal]]

Rosana, sure, it's our choice though. I'll have a look at it if you are interested.

Comment 12

[Ricky Rosario [:rrosario, :r1cky]]

We have this now.

https://support.mozilla.org/en-US/kb/dashboard/metrics/aggregated