Page MenuHomePhabricator

mediawiki_ipinfo_interaction: add schema to EventLogging allowlist
Closed, ResolvedPublic

Description

AHT team has deployed the instrumentation to track usage on IP info tool. (T304438) The related events are stored in a schema mediawiki_ipinfo_interaction. We need to add some fields to the allowlist so that the data won't get purged after 90 days.

Schema Documentation

QA ticket: T306278

Here is our proposal of event sanitization.

Proposal

What to keep

  • event_action: identifies the click action on the infobox
  • event_context: identifies the IPInfo feature being clicked
  • event_ipinfo_version: identifies the level of information accessed
  • event_source: identifies where the IPInfo feature is clicked on. For example, pecial_preferences , special_contributions, action_history, special_log, special_watchlist, special_recentchanges
  • user_edit_bucket: user's edit bucket count. For example, '1000+ edits'.
  • user_groups: the user's permissions, which are stored as groups. For example , 'sysop|*|user|autoconfirmed'.
  • meta
    • dt
    • domain
  • normalized_host

Event Timeline

Change 853376 had a related patch set uploaded (by Jenniferwang; author: Jenniferwang):

[analytics/refinery@master] Add mediawiki_ipinfo_interaction schema fields to EventLogging allowlist

https://gerrit.wikimedia.org/r/853376

jwang triaged this task as Medium priority.Nov 4 2022, 6:07 PM
jwang moved this task from Next 2 weeks to Doing on the Product-Analytics (Kanban) board.

Change 853376 merged by Mforns:

[analytics/refinery@master] Add mediawiki_ipinfo_interaction schema fields to EventLogging allowlist

https://gerrit.wikimedia.org/r/853376

mediawiki_ipinfo_interaction events are available in event_sanitized database since Oct 10, 2022. First timestamp is 2022-10-02T16:10:51.063Z .