Page MenuHomePhabricator

mpopov (Mikhail Popov)
Manager, Data Science

Today

  • Clear sailing ahead.

Tomorrow

  • Clear sailing ahead.

Sunday

  • Clear sailing ahead.

User Details

User Since
Jul 27 2015, 4:15 PM (367 w, 3 d)
Availability
Available
IRC Nick
bearloga
LDAP User
Bearloga
MediaWiki User
MPopov (WMF) [ Global Accounts ]

Using statistical analysis, Bayesian inference, machine learning, and software/data engineering to solve problems and inform decisions in Product Analytics

Recent Activity

Wed, Aug 10

mpopov added a comment to T306018: Instrument blocked account registration.

Oh it just occurred to me that the http.client_ip fragment thing perhaps doesn't work as expected for server-side events?

Wed, Aug 10, 3:26 PM · Product-Analytics, Patch-For-Review, Growth-Team (Current Sprint)
mpopov added a comment to T306018: Instrument blocked account registration.
  • user ip: Is using $user->getRequest()->getIP() as in PermissionManager::checkUserBlock() reliable to obtain the user IP?
Wed, Aug 10, 3:21 PM · Product-Analytics, Patch-For-Review, Growth-Team (Current Sprint)

Wed, Aug 3

mpopov added a comment to T304086: wmfdata-r v2 should mainly be a wrapper for wmfdata-py.

Repo with package skeleton created at https://gitlab.wikimedia.org/repos/product-analytics/wmfdata-r

Wed, Aug 3, 6:53 PM · Product-Analytics

Tue, Aug 2

mpopov closed T313985: [REQUEST] Number of articles (main namespace) in Swedish Wikipedia over time as Declined.

Looks like Johan is already in conversation with Data Engineering about getting the stats fixed

Tue, Aug 2, 5:13 PM · Product-Analytics
mpopov assigned T313992: Provide FY2021-22 development contributors statistics for WMF Audit report to Mayakp.wiki.
Tue, Aug 2, 5:11 PM · Product-Analytics
mpopov triaged T313774: Wikimedia Descriptive Statistics FY2021-22 update as Medium priority.
Tue, Aug 2, 5:10 PM · Product-Analytics
mpopov triaged T314197: Data Loss Estimation Recommendations as High priority.
Tue, Aug 2, 5:08 PM · Product-Analytics (Kanban)
mpopov edited projects for T314197: Data Loss Estimation Recommendations, added: Product-Analytics (Kanban); removed Product-Analytics.
Tue, Aug 2, 5:08 PM · Product-Analytics (Kanban)
mpopov moved T313561: Integrate iOS editing data into EditAttmptStep schema from Triage to Tracking on the Product-Analytics board.
Tue, Aug 2, 5:07 PM · Product-Analytics, ios-app-v7.0, Wikipedia-iOS-App-Backlog
mpopov edited projects for T313561: Integrate iOS editing data into EditAttmptStep schema, added: Product-Analytics; removed Product-Analytics (Kanban).
Tue, Aug 2, 5:07 PM · Product-Analytics, ios-app-v7.0, Wikipedia-iOS-App-Backlog
mpopov awarded T309013: EditAttemptStep Migration to MP a Stroopwafel token.
Tue, Aug 2, 4:44 PM · MW-1.39-notes (1.39.0-wmf.25; 2022-08-15), Editing-team, DiscussionTools, Metrics-Platform
mpopov closed T182352: UDF for language detection, a subtask of T177358: Metrics for SDoC: translations, as Invalid.
Tue, Aug 2, 2:57 PM · Product-Analytics, Discovery-Analysis (Current work), SDC General, Discovery-ARCHIVED, Wikidata
mpopov closed T182352: UDF for language detection as Invalid.
Tue, Aug 2, 2:57 PM · Analytics-Radar, Discovery-Analysis, Discovery-ARCHIVED
mpopov closed T146337: TSS2 doesn't track pagination & back button as Invalid.
Tue, Aug 2, 2:56 PM · Discovery-ARCHIVED

Fri, Jul 29

mpopov closed T314172: Unable to create web proxies via Horizon UI as Resolved.

It works again, yay!

Fri, Jul 29, 8:16 PM · Horizon
mpopov created T314172: Unable to create web proxies via Horizon UI.
Fri, Jul 29, 6:31 PM · Horizon
mpopov added a comment to T314152: Unable to list web proxies via horizon UI: "upstream request timeout".

I don't know if this is related but when I try to create a proxy I get the spinning thing and "Working…" and then it errors out with the message "Danger: There was an error submitting the form. Please try again."

Fri, Jul 29, 5:32 PM · Horizon
mpopov updated the task description for T313989: Upload shiny-server .deb to our Buster apt repository.
Fri, Jul 29, 5:20 PM · Infrastructure-Foundations, SRE
mpopov added a comment to T314152: Unable to list web proxies via horizon UI: "upstream request timeout".

I can now access the web proxy management part of Horizon now, thank you!

Fri, Jul 29, 3:57 PM · Horizon

Wed, Jul 27

mpopov created T313989: Upload shiny-server .deb to our Buster apt repository.
Wed, Jul 27, 9:04 PM · Infrastructure-Foundations, SRE

Thu, Jul 14

mpopov added a comment to T312134: Request for SQL Templating to be enabled in Superset.

Can confirm templating works! Thank you @EBernhardson @BTullis !

Thu, Jul 14, 5:52 PM · Product-Analytics, Data-Engineering

Wed, Jul 13

mpopov awarded T221482: Identify imported revisions in mediawiki_history a Like token.
Wed, Jul 13, 11:21 PM · Data-Engineering, Product-Analytics

Jul 7 2022

mpopov placed T285110: Review code of interleaved-python up for grabs.

Hm… Perhaps not any time soon. I'm putting it in the icebox for now and then @cchen can thaw it when needed.

Jul 7 2022, 2:49 PM · Product-Analytics

Jul 6 2022

mpopov added a comment to T312134: Request for SQL Templating to be enabled in Superset.

Thank you @EBernhardson!! And good find!

Jul 6 2022, 9:05 PM · Product-Analytics, Data-Engineering

Jul 5 2022

mpopov added a comment to T301921: Update Superset to ingest 2003 wikitext editor change tag.

@ppelberg can you please fill in the details of this task?

Jul 5 2022, 5:20 PM · Editing-team, Product-Analytics, WMF-General-or-Unknown, MediaWiki-Action-API
mpopov triaged T311791: Review and identify candidates for phab tasks from Product People Managers Breakout Groups as Medium priority.
Jul 5 2022, 5:15 PM · Product-Analytics
mpopov triaged T311792: Welcome emails: funnel analysis as Medium priority.
Jul 5 2022, 5:14 PM · Product-Analytics (Kanban), Growth-Team (Current Sprint)
mpopov triaged T311790: Welcome emails: experiment analysis as Medium priority.
Jul 5 2022, 5:14 PM · Product-Analytics (Kanban), Growth-Team (Current Sprint)
mpopov moved T311796: Visualize Pageview and Editor Current Share for iOS relative to market potential from Next 2 weeks to Needs Sign-off on the Product-Analytics (Kanban) board.

Pending sign-off from @JMinor

Jul 5 2022, 5:13 PM · ios-app-v7.0, Product-Analytics (Kanban), Wikipedia-iOS-App-Backlog
mpopov triaged T311796: Visualize Pageview and Editor Current Share for iOS relative to market potential as Medium priority.
Jul 5 2022, 5:12 PM · ios-app-v7.0, Product-Analytics (Kanban), Wikipedia-iOS-App-Backlog
mpopov triaged T311888: Newcomer edit type analysis as Medium priority.
Jul 5 2022, 5:11 PM · Product-Analytics (Kanban), Growth-Team (Current Sprint)
mpopov closed T305633: [REQUEST] Moderator Tools team support for content moderation on mobile web as Declined.

Our team does not have bandwidth to take this on. @kzimmerman has discussed this with Danny and Carol.

Jul 5 2022, 5:08 PM · Product-Analytics (Kanban)
mpopov triaged T304571: [REQUEST] Edit access: druid.pageviews_daily & druid.pageviews_hourly as Low priority.

@kzimmerman will sync on this with @Mayakp.wiki

Jul 5 2022, 5:06 PM · Product-Analytics (Kanban)
mpopov moved T310222: Verify data for Rollback button in Diff view from Blocked to Next 2 weeks on the Product-Analytics (Kanban) board.
Jul 5 2022, 5:04 PM · Product-Analytics (Kanban), Wikipedia-Android-App-Backlog (Android Release FY2022-23)
mpopov moved T312134: Request for SQL Templating to be enabled in Superset from Triage to Tracking on the Product-Analytics board.
Jul 5 2022, 4:33 PM · Product-Analytics, Data-Engineering
mpopov added a project to T312134: Request for SQL Templating to be enabled in Superset: Product-Analytics.
Jul 5 2022, 4:33 PM · Product-Analytics, Data-Engineering
mpopov added a comment to T312134: Request for SQL Templating to be enabled in Superset.

Suppose we have a dashboard with a chart powered by Presto. For simplicity, imagine transformations have been taken care of. The underlying query is then:

Jul 5 2022, 4:33 PM · Product-Analytics, Data-Engineering
mpopov created T312134: Request for SQL Templating to be enabled in Superset.
Jul 5 2022, 4:31 PM · Product-Analytics, Data-Engineering

Jul 1 2022

mpopov updated subscribers of T310847: Validate android_breadcrumbs_event data.

What about starting with 50% of installs? So the stream config would look like:

Jul 1 2022, 3:36 PM · Product-Analytics (Kanban), Wikipedia-Android-App-Backlog (Android Release FY2022-23)

Jun 28 2022

mpopov moved T311532: Analyze Breadcrumb data for Onboarding from Next 2 weeks to Doing on the Product-Analytics (Kanban) board.
Jun 28 2022, 5:18 PM · Product-Analytics (Kanban), Wikipedia-Android-App-Backlog (Android Release FY2022-23)
mpopov triaged T311532: Analyze Breadcrumb data for Onboarding as High priority.
Jun 28 2022, 5:18 PM · Product-Analytics (Kanban), Wikipedia-Android-App-Backlog (Android Release FY2022-23)
mpopov triaged T311534: Analyze pageview results before and after namespace search hints as High priority.
Jun 28 2022, 5:17 PM · Product-Analytics (Kanban), Wikipedia-Android-App-Backlog (Android Release FY2022-23)
mpopov moved T311534: Analyze pageview results before and after namespace search hints from Next 2 weeks to Doing on the Product-Analytics (Kanban) board.
Jun 28 2022, 5:17 PM · Product-Analytics (Kanban), Wikipedia-Android-App-Backlog (Android Release FY2022-23)
mpopov updated Other Assignee for T296661: Welcome Survey: move cron job to analytics-product system user, added: nettrom_WMF.
Jun 28 2022, 5:15 PM · Growth-Team, Product-Analytics
mpopov assigned T311166: Special:Search Quickview analytics to cchen.
Jun 28 2022, 5:14 PM · SDAW-Search-Improvements (Milestone 2: QuickView MVP), Product-Analytics, Structured-Data-Backlog
mpopov assigned T311165: Add CTR for sister projects on special:search to search improvements dashboard to cchen.
Jun 28 2022, 5:13 PM · SDAW-Search-Improvements (Milestone 1: CSS changes to all wikis), Product-Analytics, Structured-Data-Backlog
mpopov triaged T310732: "Source of truth" dataset for pageviews as High priority.
Jun 28 2022, 5:12 PM · Data-Engineering, Product-Analytics, Foundational Technology Requests
mpopov moved T310732: "Source of truth" dataset for pageviews from Triage to Upcoming Quarter on the Product-Analytics board.

Note to future self: not moving to Tracking because this will be a collaboration

Jun 28 2022, 5:11 PM · Data-Engineering, Product-Analytics, Foundational Technology Requests
mpopov triaged T311531: Add an Image: experiment analysis as Medium priority.
Jun 28 2022, 5:10 PM · Growth-Team, Product-Analytics, Image-Suggestions, Growth-Structured-Tasks
mpopov moved T309421: May 2022 Wikimedia movement metrics from Next 2 weeks to Doing on the Product-Analytics (Kanban) board.
Jun 28 2022, 5:09 PM · Product-Analytics (Kanban)
mpopov closed T310743: Instrument for namespace hints in search, a subtask of T308750: Introduce searching for namespaces, as Resolved.
Jun 28 2022, 5:09 PM · Wikipedia-Android-App-Backlog (Android Release FY2022-23)
mpopov closed T310743: Instrument for namespace hints in search as Resolved.

@SNowick_WMF says we have the data already, and there will be a separate ticket to analyze it

Jun 28 2022, 5:09 PM · Product-Analytics (Kanban), Wikipedia-Android-App-Backlog (Android Release FY2022-23)
mpopov closed T310847: Validate android_breadcrumbs_event data, a subtask of T305575: Analytics - Think about onboarding breadcrumbs, as Resolved.
Jun 28 2022, 5:07 PM · Wikipedia-Android-App-Backlog (Android Release FY2022-23)
mpopov closed T310847: Validate android_breadcrumbs_event data as Resolved.
Jun 28 2022, 5:07 PM · Product-Analytics (Kanban), Wikipedia-Android-App-Backlog (Android Release FY2022-23)
mpopov moved T310847: Validate android_breadcrumbs_event data from Blocked to Doing on the Product-Analytics (Kanban) board.
Jun 28 2022, 5:06 PM · Product-Analytics (Kanban), Wikipedia-Android-App-Backlog (Android Release FY2022-23)

Jun 24 2022

mpopov added a comment to T302079: Improvements to mediawiki_geoeditors_monthly dimensions.

I wonder whether the requested change should be done for the data in Druid only, or if it would be valuable to change the geoeditors tables on the cluster.

Jun 24 2022, 10:58 PM · Data-Engineering, Product-Analytics

Jun 23 2022

mpopov placed T295619: Cookie value sent in HTTP requests changes too frequently up for grabs.
Jun 23 2022, 3:53 PM · Metrics-Platform, Performance-Team (Radar), Product-Analytics, MediaWiki-extensions-WikimediaEvents
mpopov awarded T308739: Experimentation capabilities for logged-out users a Love token.
Jun 23 2022, 3:22 PM · Foundational Technology Requests

Jun 21 2022

mpopov moved T310222: Verify data for Rollback button in Diff view from Next 2 weeks to Blocked on the Product-Analytics (Kanban) board.

Blocked on availability of data from production release

Jun 21 2022, 5:14 PM · Product-Analytics (Kanban), Wikipedia-Android-App-Backlog (Android Release FY2022-23)
mpopov edited projects for T310222: Verify data for Rollback button in Diff view, added: Product-Analytics (Kanban); removed Product-Analytics.
Jun 21 2022, 5:13 PM · Product-Analytics (Kanban), Wikipedia-Android-App-Backlog (Android Release FY2022-23)
mpopov moved T310743: Instrument for namespace hints in search from Next 2 weeks to Needs Investigation on the Product-Analytics (Kanban) board.
Jun 21 2022, 5:11 PM · Product-Analytics (Kanban), Wikipedia-Android-App-Backlog (Android Release FY2022-23)
mpopov triaged T310743: Instrument for namespace hints in search as Low priority.
Jun 21 2022, 5:11 PM · Product-Analytics (Kanban), Wikipedia-Android-App-Backlog (Android Release FY2022-23)
mpopov added a comment to T310847: Validate android_breadcrumbs_event data.

Blocked on availability of data from production release

Jun 21 2022, 5:08 PM · Product-Analytics (Kanban), Wikipedia-Android-App-Backlog (Android Release FY2022-23)
mpopov moved T310847: Validate android_breadcrumbs_event data from Next 2 weeks to Blocked on the Product-Analytics (Kanban) board.
Jun 21 2022, 5:08 PM · Product-Analytics (Kanban), Wikipedia-Android-App-Backlog (Android Release FY2022-23)
mpopov triaged T310847: Validate android_breadcrumbs_event data as Medium priority.
Jun 21 2022, 5:08 PM · Product-Analytics (Kanban), Wikipedia-Android-App-Backlog (Android Release FY2022-23)
mpopov updated subscribers of T240676: Develop a consistent rule for which special pages count as pageviews.

Back in March I asked about an issue with us seeing views for Special pages that aren't allowlisted (as mentioned above)

Jun 21 2022, 4:13 PM · Campaign-Registration, Analytics-Radar, Product-Analytics
mpopov awarded T149667: Amazing Article Annotations a Baby Tequila token.
Jun 21 2022, 3:43 PM · Wikispeech-Text-to-Speech, Parsing-Team--ARCHIVED, Cite, VisualEditor, MediaWiki-extensions-Translate, Wikimedia-Developer-Summit (2017)

Jun 14 2022

mpopov raised the priority of T310390: Instrument blocked edit attempts from Medium to High.
Jun 14 2022, 5:13 PM · Product-Analytics (Kanban), Patch-For-Review, Goal, Editing-team (FY2021-22 Kanban Board), VisualEditor
mpopov claimed T303995: Instrument blocked account registration and edit attempts .
Jun 14 2022, 5:13 PM · Editing-team (Tracking), VisualEditor, Anti-Harassment, Product-Analytics, Growth-Team
mpopov triaged T310390: Instrument blocked edit attempts as Medium priority.
Jun 14 2022, 5:11 PM · Product-Analytics (Kanban), Patch-For-Review, Goal, Editing-team (FY2021-22 Kanban Board), VisualEditor

Jun 7 2022

mpopov triaged T302768: Update Superset/Turnilo access instructions to mention analytics-privatedata-users as Low priority.
Jun 7 2022, 5:14 PM · Documentation, Product-Analytics
mpopov reassigned T308618: Request for “source of truth” dataset from Mayakp.wiki to kzimmerman.
Jun 7 2022, 5:13 PM · Product-Analytics (Kanban)
mpopov moved T305990: Additional features in Pageview Loss calculation from Next 2 weeks to Doing on the Product-Analytics (Kanban) board.
Jun 7 2022, 5:12 PM · Product-Analytics (Kanban)
mpopov claimed T305990: Additional features in Pageview Loss calculation.
Jun 7 2022, 5:12 PM · Product-Analytics (Kanban)
mpopov moved T291224: Add an image: export image judgments for analysis from Next 2 weeks to Needs Investigation on the Product-Analytics (Kanban) board.
Jun 7 2022, 5:11 PM · Growth-Team, Product-Analytics (Kanban), Growth-Structured-Tasks
mpopov assigned T291224: Add an image: export image judgments for analysis to nettrom_WMF.
Jun 7 2022, 5:10 PM · Growth-Team, Product-Analytics (Kanban), Growth-Structured-Tasks
mpopov moved T310002: Requesting access to Superset & Turnilo for kstoller from Triage to Tracking on the Product-Analytics board.
Jun 7 2022, 5:08 PM · Product-Analytics, SRE, SRE-Access-Requests
mpopov triaged T309421: May 2022 Wikimedia movement metrics as High priority.
Jun 7 2022, 5:07 PM · Product-Analytics (Kanban)
mpopov moved T306657: Cross-validate estimates for pageview data loss derived from February data with new March data from Needs Review to Blocked on the Product-Analytics (Kanban) board.
Jun 7 2022, 5:06 PM · Product-Analytics (Kanban)
mpopov moved T287420: Load past data in wmf_product KPM tables from Needs Review to Needs Sign-off on the Product-Analytics (Kanban) board.
Jun 7 2022, 5:05 PM · Product-Analytics (Kanban)
mpopov moved T308695: Migrate 'Content Interactions' Metrics tables to analytics/wmf-product/jobs from Needs Review to Needs Sign-off on the Product-Analytics (Kanban) board.
Jun 7 2022, 5:04 PM · Product-Analytics (Kanban)

Jun 6 2022

mpopov committed rAWPJ54c5903102b1: movement_metrics: Migrate Content Interactions tables and ETL (authored by Mayakp.wiki).
movement_metrics: Migrate Content Interactions tables and ETL
Jun 6 2022, 9:41 PM

May 25 2022

mpopov updated subscribers of T252227: Mobile redirects drop provenance parameters.

Thank you @Milimetric for the ping! I missed this earlier in the month.

May 25 2022, 9:19 PM · Data-Engineering, Traffic-Icebox, SRE

May 24 2022

mpopov moved T306176: Event tracking for Realtime Preview from Triage to Tracking on the Product-Analytics board.
May 24 2022, 5:15 PM · MW-1.39-notes (1.39.0-wmf.25; 2022-08-15), Community-Tech (CommTech-Sprint-30), Editing-team (Tracking), Product-Analytics, Realtime Preview
mpopov triaged T309036: Account creation: social media campaign effectiveness analysis as Medium priority.
May 24 2022, 5:08 PM · Product-Analytics (Kanban), Growth-Team (Current Sprint)
mpopov triaged T308774: Account creation: Fundraising TY Page campaign OKR analysis as Medium priority.
May 24 2022, 5:08 PM · Product-Analytics (Kanban), Growth-Team (Current Sprint)
mpopov triaged T308784: Account creation: Fundraising TY Banner campaign OKR analysis as Medium priority.
May 24 2022, 5:08 PM · Product-Analytics (Kanban), Growth-Team (Current Sprint)
mpopov triaged T308695: Migrate 'Content Interactions' Metrics tables to analytics/wmf-product/jobs as High priority.
May 24 2022, 5:06 PM · Product-Analytics (Kanban)
mpopov moved T304972: Upgrade Superset to 1.4.2 from Triage to Tracking on the Product-Analytics board.
May 24 2022, 5:05 PM · Product-Analytics, Patch-For-Review, Data-Engineering-Kanban, Superset, Data-Engineering
mpopov edited projects for T304972: Upgrade Superset to 1.4.2, added: Product-Analytics; removed Product-Analytics (Kanban).
May 24 2022, 5:05 PM · Product-Analytics, Patch-For-Review, Data-Engineering-Kanban, Superset, Data-Engineering

May 20 2022

mpopov closed T305620: TikTok Referrers as Declined.

On May 9, 2022, we had a discussion about expanding our referrer tracking capabilities (notes doc). Attendees: Kinneret G (Partnerships), Kate Z (Product Analytics), Isaac J (Research), Maryana P (Partnerships), Olja D (Data Engineering), and myself (Product Analytics).

May 20 2022, 4:33 PM · Product-Analytics (Kanban)

May 17 2022

mpopov triaged T307143: Update dataset/query of Active Editors metric as Medium priority.
May 17 2022, 5:16 PM · Product-Analytics (Kanban)
mpopov triaged T307144: Update dataset/query of New Editor Retention metric as Medium priority.
May 17 2022, 5:15 PM · Product-Analytics (Kanban)
mpopov triaged T308077: Add partitioning to editors tables as Low priority.
May 17 2022, 5:14 PM · Product-Analytics
mpopov assigned T308079: Add column descriptions to existing tables in wmf_product to Iflorez.
May 17 2022, 5:11 PM · Product-Analytics
mpopov triaged T308297: Summarize Persian (Farsi) Wikipedia metrics 6 months after IP editing was disabled as Medium priority.
May 17 2022, 5:10 PM · Product-Analytics (Kanban), Epic, Anti-Harassment
mpopov assigned T295516: [SPIKE] What percentage of talk page edits are made with DiscussionTools? to MNeisler.
May 17 2022, 5:08 PM · Product-Analytics, Editing-team (Tracking), DiscussionTools
mpopov edited projects for T295516: [SPIKE] What percentage of talk page edits are made with DiscussionTools?, added: Product-Analytics; removed Product-Analytics (Kanban).
May 17 2022, 5:07 PM · Product-Analytics, Editing-team (Tracking), DiscussionTools
mpopov moved T308441: Error when updating dashboard from Triage to Tracking on the Product-Analytics board.
May 17 2022, 5:06 PM · Product-Analytics, Data-Engineering-Kanban, Superset, Data-Engineering
mpopov edited projects for T308441: Error when updating dashboard , added: Product-Analytics; removed Product-Analytics (Kanban).
May 17 2022, 5:06 PM · Product-Analytics, Data-Engineering-Kanban, Superset, Data-Engineering