1295658 - Validate active user numbers in mobile_clients table

Status: RESOLVED FIXED

(Cloud Services Graveyard :: Metrics: Pipeline, defect, P1)

Description

[Georg Fritzsche [:gfritzsche]]

After bug 1286242, we need to validate that the active users numbers look reliable in re:dash / mobile_clients.
We should also look into distribution ids showing up properly, e.g. using Barbaras query here:
https://sql.telemetry.mozilla.org/queries/490/source#table

Comment 1

[Georg Fritzsche [:gfritzsche]]

We can generate DAU numbers from the raw data and compare this to this query:
https://sql.telemetry.mozilla.org/queries/272/source#508

I will generate them mid-week as the mobile_client job was only scheduled in AirFlow on Aug 17, so we should wait for a few more days of data.

Comment 2

[Georg Fritzsche [:gfritzsche]]

I've send a gist with DAU & daily ping numbers off-bug (due to user counts).
Passing this on for cross-checking this with the data in re:dash.

Comment 3

[Georg Fritzsche [:gfritzsche]]

Amit compared this off-bug and the numbers mostly match before Aug 17 and are a stable match after Aug 17.

Amit, i think we can close this?
Can you add the (moco only) links of the comparison sheet for future reference?