Fenix Nightly Metrics are out of date since April

[edugfilho]

Still investigating, but looks like an issue with determining the latest_version of nightly. We've been assuming Fenix follows the same versioning as FoG, but maybe it is no longer the case for Nightly. Release and Beta look fine.

[edugfilho]

• app_version for most recent Fenix Nightly data on the daily tables (extracted from raw tables) is 124
• while GeckoView changelog shows 128 is the latest version.
• Firefox nightly is also 128.

This app_version column on GLAM's daily tables is not something that comes from telemetry, it is the result of a mapping from app_build to app_version done in geckoview_version_v1, where Fenix versions are estimated based on their build ids.

There's probably something wrong with the way geckoview_version_v1 estimates the version. Maybe something that changed recently... If so, there's a chance this is also affecting beta and release.

[edugfilho]

geckoview_version_v1 says Fenix version has been 124 since Jan 24. It uses the metric metrics.string.geckoview_version for the estimate, but that metric has been migrated to metrics.string.gecko_version, which correctly reports 128 as the most recent version. Release and Beta don't seem affected since fenix nightly ETL is the only one that relies on geckoview_version_v1 for determining app_version.

Next steps:

• [x] Fix geckoview_version_v1 ETL to use the metrics.string.gecko_version instead of metrics.string.geckoview_version
• [x] Run backfills

[edugfilho]

This has been fixed and the data is now available