Page MenuHomePhabricator

Update MobileWikiAppTalk Schema to track session length
Open, HighPublic


The Android team is working on updates to talk pages in order to improve discovery in a non intrusive way and user understanding of how to leverage talk pages to communicate with each other and improve articles. One of our research questions is, what if any changes does our interventions make on the time users spend on talk pages.

The Task
Update our existing schema to ensure we are tracking session length while adhering to privacy policies

Event Timeline

Note: @JTannerWMF - The MobileWikiAppTalk schema currently tracks time_spent for the following tasks:

  • submit
  • refresh
  • new_topic_click
  • reply_click
  • lang_change

Events open_topic and open_talk are also tracked without time_spent as they are initialization events.

If our Talk Page redesign adds new event/actions we will need to instrument tracking in this schema.

SNowick_WMF renamed this task from Update Schema to track session length to Update MobileWikiAppTalk Schema to track session length.Dec 6 2021, 8:28 PM

This already exists. Disregard.

We will need to add an is_anon column to this schema in order to sort drop off and time spent rates for users by logged in vs. anon.

The field pagens in this schema is populated with the Talk page title (ie. Talk, Discussion, Обсуждение, User Talk), can we add a field that uses the page namespace code number? Using the naming convention of MediaWiki_history namespace is the code and title is the name of the page, should we consider adding a pagetitle field for the title and using pagens for the namespace code? This will mean our data is not backwards compatible but since we only retain 90 days of data and aren't taking away any data this should be ok, pending any objections for reasons I haven't considered. @Dbrant and @Sharvaniharan can you weigh in?

The workaround I'm using for this is to add query parameters to pagens depending on which wiki is being queried, since some of the wiki are non-English and the Talk page names are not in English.

regexp_like(event.pagens, '(?i)talk') -- all Talk (?i) is for case insensitive
regexp_like(event.pagens, '(?i)Discus') -- frwiki Talk
regexp_like(event.pagens, '(?i)نقاش')) -- arwiki Talk
regexp_like(event.pagens, '(?i)संवाद') --hiwikiTalk
regexp_like(event.pagens, '(?i)Pembicaraan') -- idwiki Talk
regexp_like(event.pagens, '(?i)note') -- jawiki Talk
regexp_like(event.pagens, 'ノート') -- jawiki Talk