Custom report about users on localized versions per channel

RESOLVED FIXED in Unreviewed

Status

Mozilla Metrics
Frontend Reports
RESOLVED FIXED
5 years ago
5 years ago

People

(Reporter: Pike, Unassigned)

Tracking

unspecified
Unreviewed

Details

(Reporter)

Description

5 years ago
Chris had a similar request back in bug 696140.

Here's what I'd like to get out of our ADI data:

For all, or possibly a given list of locales:

How many users have been on the aurora, the beta, and the release update channel over the past N days.

N being something like two weeks is fine. Averages don't really work, we're in particular interested in small locales, where the noise in ADIs is around 100%.

JSON output would work for me, or CSV, not sure which is more tricky for you.

Comment 1

5 years ago
Hi Axel,
Here you have a link for your data:

https://metrics.mozilla.com/pentaho/content/cda/doQuery?solution=metrics2&path=%2Fblocklist%2FdailyADU_filteredBy_countryLocale&file=aduByCountryLocale.cda&dataAccessId=LocalesByChannelADUQuery&paramstartDateParameter=2013-01-10&paramendDateParameter=2013-01-24&paramproductParameter=Firefox&paramchannelParameter=aurora&outputType=csv

In this sample link I put these values:
startDate=2013-01-10
endDate=2013-01-24
product=Firefox
channel=aurora

You can change any of them.
Also, this link exports to csv. You can change the output format to json, xml, xls, or html

Please let me know if you're ok with this, or if you need some adjustment,
thanks
(Reporter)

Comment 2

5 years ago
Hi Maria, thanks.

What are the numbers? Average over time, sum, something else?

Comment 3

5 years ago
sum of total requests
(Reporter)

Comment 4

5 years ago
Could we get the actual data per day instead? I can extract that right now by doing per-day queries, but I guess that's adding unnesseary load.

I'm afraid that the sum is scewing results differently for large and small locales.
(Reporter)

Comment 6

5 years ago
That times out for me, rather consistently :-( , getting connection-reset errors after pondering for a few minutes.
(In reply to Axel Hecht [:Pike] from comment #6)
> That times out for me, rather consistently :-( , getting connection-reset
> errors after pondering for a few minutes.


Sorry for leave this bug open for so long.
Can you check if it's working now?

Thanks.
Status: NEW → RESOLVED
Last Resolved: 5 years ago
Resolution: --- → FIXED
You need to log in before you can comment on or make changes to this bug.