Closed Bug 1481829 Opened 7 years ago Closed 7 years ago

Drop bad dates from clients_daily

Categories

(Data Platform and Tools :: General, enhancement)

Product:
Data Platform and Tools
Component:
General
Type:
enhancement
Priority:
Not set
Severity:
normal

Tracking

(Not tracked)

Status:
RESOLVED INVALID

People

(Reporter: frank, Unassigned)

Details

(Whiteboard: [DataPlatform])

The beginning of time until ~2016-12-01 has extremely low counts in clients_daily that are probably not trustworthy. It may be worth it to purge this data from the dataset so that anyone running "on all of time" can trust that the data is correct. See for example [0], aDAU query. [0] https://sql.telemetry.mozilla.org/queries/58129#151105
Also main_summary, because it's the source for those odd results in clients_daily
Upon review, data looks fine. The artifact for aDAU was due to the delayed landing of total_uri_count. https://sql.telemetry.mozilla.org/queries/58130/source#151107 Carry on!
Status: NEW → RESOLVED
Closed: 7 years ago
Resolution: --- → INVALID
Component: Datasets: General → General
You need to log in before you can comment on or make changes to this bug.