1811079 - unified_metrics disagrees with telemetry.clients_daily/last_seen

Status: RESOLVED WONTFIX

(Data Platform and Tools :: General, defect)

Description

[Leif Oines [:loines]]

When calculating qualified DAU for desktop I am getting order of mag. 10k difference between clients_daily/clients_last_seen and unified_metrics. Unified metrics has the higher number [1].

Strangely there is a period in Dec 2022 where they match exactly, and they match on the most recent two days, but other days they disagree.

[1] https://sql.telemetry.mozilla.org/queries/89772/source

Comment 1

[Rob Miller [:rmiller]]

Hello,

The Mozilla Data Engineering organization is currently going through our extensive backlog, consisting of hundreds of issues stretching back for nearly 10 years. We've done a pass through all of the open bugzilla bugs and have identified and tagged the ones that we think are relevant enough to still need attention. The rest, including the bug with which this comment is associated, we are closing as "WONTFIX" in a single bulk operation.

If you feel we have closed this (or any) issue in error, please feel free to take the following actions:

• Reopen the bug.
• Edit the bug to add the string [dataplatform] (including the brackets) to the Whiteboard field. (Note that you must edit the Whiteboard, not the similarly named QA Whiteboard.)

Doing this will ensure that we see the bug in our weekly triage process, where we will decide how to proceed.

Thank you.