Closed Bug 1539448 Opened 6 years ago Closed 6 years ago

Bigquery table firefox_desktop_exact_mau28_by_dimensions_v1 missing some attribution data from Apr 28 2017 to May 24 2018

Categories

(Data Platform and Tools :: General, enhancement)

enhancement
Not set
blocker

Tracking

(Not tracked)

RESOLVED FIXED

People

(Reporter: gkaberere, Assigned: relud)

Details

Noticed some data missing in the newly created table firefox_desktop_exact_mau28_by_dimensions_v1 in bigquery. When calculating dau and mau from the table specifically looking at paid media attribution fields, the table does not return any data from April 28 2017 to May 24th 2018 (inclusive).

Sample sql query showing the missing window
SELECT submission_date, SUM(dau) as dau, SUM(mau) as mau FROMmoz-fx-data-derived-datasets.telemetry.firefox_desktop_exact_mau28_by_dimensions_v1WHERE submission_date >= DATE("2017-04-23") AND submission_date <= DATE("2018-06-01") AND medium IN('affilliate', 'banner', 'cpc', 'display', 'paidsearch', 'ppc', 'sem') GROUP BY 1 ORDER BY 1

Took a look at clients_daily_v6 to see if it was a matter of the data not being available as to my knowledge it is the base table from which the new table is calculated from. I was able to find dau for the specific mediums I was interested.

Sample clients_daily_v6 query
SELECT submission_date_s3, count(distinct client_id) as dau FROMmoz-fx-data-derived-datasets.telemetry.clients_daily_v6WHERE submission_date_s3 >= DATE("2017-05-15") AND submission_date_s3 <= DATE("2017-06-01") AND attribution.medium IN('affilliate', 'banner', 'cpc', 'display', 'paidsearch', 'ppc', 'sem') GROUP BY 1 ORDER BY 1

ASK: Could we look into this particular case as well as validate the other attribution fields (source, medium, campaign and content)? We use these to understand how different acquisition funnels are doing. Marking as blocker as we are in the middle of performing analysis for the Quarterly business reviews scheduled next week

The data in clients_daily was fixed in Bug 1533443, so this should be a matter of backfilling firefox_desktop_exact_mau28_by_dimensions_v1 for the affected time period.

Daniel, does that sound right? Is this something you can tackle in the near term?

Flags: needinfo?(dthorn)

yeah, i can try to get this fixed today

Assignee: nobody → dthorn
Flags: needinfo?(dthorn)
Status: NEW → RESOLVED
Closed: 6 years ago
Resolution: --- → FIXED
Component: Datasets: General → General
You need to log in before you can comment on or make changes to this bug.