Set up queries and dashboard for new profiles

mozilla-l10n / pm-projects

Storage for Project Manager Group's projects

7 stars 2 forks source link

Set up queries and dashboard for new profiles #271

Closed flodolo closed 3 years ago

flodolo commented 3 years ago

Telemetry has a new_profile table that can be used for it:

It has a normalized_country_code, so no issue for the country.
Locale is a lot more complicated. It includes environment settings, so intl fields. I can split the array and consider the first appLocales, but a lot of new profiles seem to not have any intl field associated.

flodolo commented 3 years ago

Countries
Locales

I've arbitrary chosen Sep 1 as starting date (6 months ago), but it could be changed. Queries are set to refresh automatically once a week until July 1st.

Dashboard here.