Issue with first_seen_date field in fenix.new_profile_activation

[irrationalagent]

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

• 2024-01-02
• 2024-01-04 to 2024-01-07 inclusive
• 2024-01-12

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]

➤ 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).