search

mozilla / bigquery-etl

Bigquery ETL
https://mozilla.github.io/bigquery-etl
Mozilla Public License 2.0
251 stars 100 forks source link

Issue with first_seen_date field in fenix.new_profile_activation #5192

Open irrationalagent opened 6 months ago

irrationalagent commented 6 months ago

I noticed this for Jan 2024, but other dates could be affected as well. There are no clients with first_seen_date for:

query

There may be other dates affected, I only noticed for jan 2024. There seems to be a normalish amount of rows for each date partition for the above days.

This table is joined to android marketing metrics in looker to power the Google UAC Android campaign activation explore. That's where I initially noticed the problem.

┆Issue is synchronized with this Jira Task

data-sync-user commented 6 months ago

➤ Leif Oines commented:

Arguably, for the looker explore linked above we should be using firefox_android_clients as the source table for new profiles. However, if we still want to report on activations, we would still need to incorporate new_profile_activation in some way (or compute the activations separately somehow).