Closed Bug 1522958 Opened 7 years ago Closed 7 years ago

New dataset request: Firefox Desktop exact MAU28

Categories

(Data Platform and Tools :: General, enhancement, P1)

Product:
Data Platform and Tools
Component:
General
Type:
enhancement
Points:
2

Tracking

(Not tracked)

Status:
RESOLVED FIXED

People

(Reporter: mreid, Assigned: relud)

References

Details

We should produce a simple dataset that computes exact MAU28 for Firefox Desktop.

I've put together a basic query[1] for computing one day's MAU at a time based on the documentation at [2].

We still need to

  • schedule this to run daily in airflow
  • make it a downstream dependency of the job that imports the clients daily data into bigquery.

[1] https://console.cloud.google.com/bigquery?sq=630180991450:ad9d9b7c223d48c7a2d8ef21966f0ae9
[2] https://docs.telemetry.mozilla.org/cookbooks/dau.html

Assignee: nobody → dthorn
Points: --- → 2
Priority: -- → P1

I've filed a pull request to start running this in airflow[1] with additions as discussed in slack

[1] https://github.com/mozilla-services/spark-parquet-to-bigquery/pull/2

Blocks: 1525689
Status: NEW → RESOLVED
Closed: 7 years ago
Resolution: --- → FIXED
Component: Datasets: General → General
You need to log in before you can comment on or make changes to this bug.