Access of users using the different languages

Edwin · June 26, 2024, 11:27am

Hi Team,
Is there a way we can tell the number of users using the application in the different languages.

We would like to access those numbers .

michael · June 26, 2024, 12:59pm

The CHT records what language the user is using in telemetry.

From the documentation

Sample as found in the telemetry doc

Max, min, sum, and sumsqr are probably not useful at all but the count will tell you the number of times this value was recorded for the user on a specific device in a given day. I’m not 100% sure when this gets incremented but I assume it is probably when the user logs in or the app is reloaded (here’s the PR that added the functionality).

Sample SQL

If you have couch2pg set up and have the useview_telemetry_metrics view, you can use this SQL to see how many users are using which languages.

NOTE: This is just a starter SQL, if the user has used the app in multiple languages, they will be counted in both.

SELECT
	metric,
	count(distinct(user_name)) AS count_distinct_users

FROM
	useview_telemetry_metrics

WHERE
	metric LIKE 'user_settings:language%'

GROUP BY
	metric

Sample Output

metric	count_distinct_users
user_settings:language:en	60
user_settings:language:fr	3504