1349107 - Verify Fennec RTL DAU query

Status: RESOLVED FIXED

(Firefox for Android Graveyard :: Metrics, enhancement, P3)

Description

[elin]

I'm trying to measure the DAU impact in RTL locales,
and here's the query I came up with:
https://sql.telemetry.mozilla.org/queries/3683/source#7287

What I'm not sure about is:

1. I found that there might be hundreds of different RTL locale strings (e.g. he-GB, ar-AR, fa-AR) in mobile_clients table, does these locale strings matching '^(he|ar|ur|fa)(-.+)?$' represents all RTL locales?

2. Does counting unique clientid in one day gives us (approximately) the unique user count in one day? or is there a better approach?


Any feedback on this query?

Comment 1

[Joe Cheng [:jcheng] (please needinfo)]

Frank should be able to help? :)

Comment 2

[Frank Bertsch [:frank]]

(In reply to elin from comment #0)

> 1. I found that there might be hundreds of different RTL locale strings
> (e.g. he-GB, ar-AR, fa-AR) in mobile_clients table, does these locale
> strings matching '^(he|ar|ur|fa)(-.+)?$' represents all RTL locales?

Unfortunately I don't know anything about this - maybe ask the localization team?

> 2. Does counting unique clientid in one day gives us (approximately) the
> unique user count in one day? or is there a better approach?

This definitely will. That's exactly how we calculate DAU for the KPIs.

Comment 3

[Nevin Chen(Not active on Bugzilla)]

I think Max had that number.