Page MenuHomePhabricator

Create new schema to track state and changes related to notifications
Closed, ResolvedPublic

Description

Background:
As detailed in T285775, we will establish a baseline for notification engagement in the Android app. Our existing schema has incomplete data, as seen in this spreadsheet.

In order to answer our research questions we need an updated schema that tracks both state and changes related to notifications.

Event Timeline

SNowick_WMF moved this task from Triage to Kanban on the Product-Analytics board.

Current schema MobileWikiAppNotificationPreferences is outdated and missing current Notification Preference options in tracking.

The proposed solution has 2 parts: 1. Implement a schema that tracks user preference change events and 2. Implement a user state schema (or add to existing schema) . This structure follows the iOS app data organization that uses 2 tables: MobileWikiAppiOSSettingAction and MobileWikiAppiOSUserHistory to track user state for all users and user change events. (See https://phabricator.wikimedia.org/T192819 for further documentation.) Will track decisions and next steps here. The first phase of this schema architecture will be for Notifications with the second phase moving all user Settings/Preference tracking to these schemas).

Current Notification Preference Settings (need to be added to new UserSetting schema):

  • Poll notifications (allow the app to use data to check for new notifications in the background)
  • System messages
  • Milestone (Certain edit counts are reached)
  • Thanks (Someone thanks you for an edit)
  • Revert (One of your contributions was reverted)
  • Talk page (Messages from talk pages)
  • Login (Your login activities)
  • Mention (Someone mentions you in a page)

UserSettings will track changes to these settings and UserState will track all users/setting states when user logs in/opens app.

Android_Notification_Prefs.png (1×720 px, 184 KB)

SNowick_WMF lowered the priority of this task from High to Medium.Jul 13 2021, 5:03 PM