- Validate new data, new values being sent to schema.
- Also investigate the data to see if there are clearly multiple days missing in between for these events for the same user. See https://phabricator.wikimedia.org/T297752#7586706
Status | Subtype | Assigned | Task | ||
---|---|---|---|---|---|
Resolved | SNowick_WMF | T290920 Create schema to track metrics for user notifications on iOS - ios_notification_interaction | |||
Resolved | • JMinor | T297752 Instrument `inbox_count` and `device_level_enabled` data, sent to MobileWikiAppiOSUserHistory | |||
Resolved | SNowick_WMF | T298820 Validate updated data sent to MobilewikiAppiOSUserHistory |
Verifying I am able to see device_level_enabled and inbox_count values for app_install_ids C58B3FE6-5B7E-4C21-A4EF-F929D247D3A5 and 7FF1F9E3-5911-4E93-99FC-57DBBD1687F7 in MobileWikiAppiOSUserHistory. Query must be specified to be post 2022-01-08 to work in Superset.
Worth noting that I am seeing multiple rows for the same app_install_id for one date, this test data might be useful for @Mazevedo.
date | app_install_id | inbox_count | device_level_enabled |
---|---|---|---|
2022-01-10 | C58B3FE6-5B7E-4C21-A4EF-F929D247D3A5 | 39 | authorized |
2022-01-10 | 7FF1F9E3-5911-4E93-99FC-57DBBD1687F7 | 0 | authorized |
2022-01-10 | 7FF1F9E3-5911-4E93-99FC-57DBBD1687F7 | 0 | notDetermined |
2022-01-10 | 7FF1F9E3-5911-4E93-99FC-57DBBD1687F7 | 0 | notDetermined |
2022-01-11 | 7FF1F9E3-5911-4E93-99FC-57DBBD1687F7 | 41 | authorized |
2022-01-11 | 7FF1F9E3-5911-4E93-99FC-57DBBD1687F7 | 9 | authorized |
Query: SELECT SUBSTR(dt, 1, 10) AS `date`, event.app_install_id, event.inbox_count, event.device_level_enabled FROM event.MobileWikiAppiOSUserHistory WHERE YEAR = 2022 AND MONTH >= 1 and DAY >= 8 AND event.device_level_enabled IS NOT NULL