Page MenuHomePhabricator

Neil_P._Quinn_WMF
product analyst at the Wikimedia Foundation

Today

  • Clear sailing ahead.

Tomorrow

  • Clear sailing ahead.

Sunday

  • Clear sailing ahead.

User Details

User Since
Apr 16 2015, 4:17 PM (201 w, 18 h)
Availability
Available
IRC Nick
neilpquinn
LDAP User
Unknown
MediaWiki User
Neil P. Quinn-WMF [ Global Accounts ]

Recent Activity

Yesterday

Neil_P._Quinn_WMF edited parent tasks for T212386: Provide tools for querying MediaWiki replica databases without having to specify the shard, added: T215589: Migrate users to dbstore100[3-5]; removed: T172410: Replace the current multisource analytics-store setup.
Thu, Feb 21, 6:13 PM · Product-Analytics, Patch-For-Review, Analytics, WMDE-Analytics-Engineering, User-Addshore, User-Elukey, Research
Neil_P._Quinn_WMF removed a subtask for T172410: Replace the current multisource analytics-store setup: T212386: Provide tools for querying MediaWiki replica databases without having to specify the shard.
Thu, Feb 21, 6:13 PM · Product-Analytics, Analytics, WMDE-Analytics-Engineering, User-Addshore, User-Elukey, Research
Neil_P._Quinn_WMF added a subtask for T215589: Migrate users to dbstore100[3-5]: T212386: Provide tools for querying MediaWiki replica databases without having to specify the shard.
Thu, Feb 21, 6:13 PM · User-Marostegui, Analytics-Kanban, Analytics
Neil_P._Quinn_WMF claimed T184576: Make an Analytics Data Lake table to provide meta info about wikis .
Thu, Feb 21, 6:10 PM · Product-Analytics, Analytics, Contributors-Analysis
Neil_P._Quinn_WMF moved T216658: Timestamp column in EventLogging tables have incompatible collation from Triage to Tracking on the Product-Analytics board.
Thu, Feb 21, 5:03 PM · Analytics, Product-Analytics
Neil_P._Quinn_WMF added a comment to T184576: Make an Analytics Data Lake table to provide meta info about wikis .

@EBernhardson, actually this is quite close to being done! If you look at the wiki segmentation spreadsheet, the database code is in column Z and the language name in English is in column AD. It doesn't include private wikis at all, and the data past row 663 is messed up (T199266), but it wouldn't be that much work to fix it up.

Thu, Feb 21, 9:53 AM · Product-Analytics, Analytics, Contributors-Analysis

Wed, Feb 20

Neil_P._Quinn_WMF moved T194641: Measure newcomers using Content Translation from Next Up to Doing on the Product-Analytics board.
Wed, Feb 20, 6:34 PM · Language-Team (Language-2019-January-March), Product-Analytics, Contributors-Analysis, CX-analytics
Neil_P._Quinn_WMF moved T216634: Update wmfdata package to support sharded wiki replicas from Triage to Next Up on the Product-Analytics board.
Wed, Feb 20, 5:16 PM · Product-Analytics
Neil_P._Quinn_WMF lowered the priority of T216634: Update wmfdata package to support sharded wiki replicas from High to Normal.
Wed, Feb 20, 5:15 PM · Product-Analytics
Neil_P._Quinn_WMF triaged T216634: Update wmfdata package to support sharded wiki replicas as High priority.
Wed, Feb 20, 5:15 PM · Product-Analytics
Neil_P._Quinn_WMF moved T209544: Vet the EditAttemptStep and VisualEditorFeatureUse data streams from Doing to Next Up on the Product-Analytics board.
Wed, Feb 20, 5:06 PM · Contributors-Analysis, Product-Analytics
Neil_P._Quinn_WMF moved T188391: Develop strategies and tools for segmenting wikis [2018-19 AP output 4.3] from Doing to Next Up on the Product-Analytics board.
Wed, Feb 20, 5:06 PM · Better Use Of Data, Product-Design-Strategy, Epic, Product-Analytics, Contributors-Analysis

Fri, Feb 15

Neil_P._Quinn_WMF closed T198776: Set up data infrastructure for program metrics as Declined.

As Kate said, closing this because this parent task doesn't have any value. I've separated out the reverts issue as T216297.

Fri, Feb 15, 11:01 PM · Contributors-Analysis, Product-Analytics
Neil_P._Quinn_WMF created T216297: Develop method for identifying reverts in EventBus data.
Fri, Feb 15, 11:00 PM · Contributors-Analysis, Product-Analytics
Neil_P._Quinn_WMF raised the priority of T216294: Hive log4j logging is misconfigured from Normal to Needs Triage.
Fri, Feb 15, 10:45 PM · Analytics
Neil_P._Quinn_WMF created T216294: Hive log4j logging is misconfigured.
Fri, Feb 15, 10:44 PM · Analytics
Neil_P._Quinn_WMF updated subscribers of T173853: Calculate movement-wide contributor metrics using the Analytics Data Lake.

@kzimmerman based on my discussions with Analytics, I decided that I should move my calculations away the slowly dying dbstore1002 immediately rather than working around the locking of the staging database (T215589#4958363). That means I'll need to do this before we can run the February metrics.

Fri, Feb 15, 9:17 PM · Product-Analytics, Contributors-Analysis
Neil_P._Quinn_WMF added a comment to T215589: Migrate users to dbstore100[3-5].

Per irc conversation we are good to proceed with migration Monday the 18th. As @JAllemandou mentioned the next scooping should include the change tag table even if the change tag data is not yet in the denormalized tables.

Fri, Feb 15, 9:13 PM · User-Marostegui, Analytics-Kanban, Analytics
Neil_P._Quinn_WMF moved T173853: Calculate movement-wide contributor metrics using the Analytics Data Lake from Blocked to Next Up on the Product-Analytics board.
Fri, Feb 15, 9:10 PM · Product-Analytics, Contributors-Analysis
Neil_P._Quinn_WMF closed T196936: Convert contributors health metric queries to use reportupdater as Declined.

It's not clear that porting these queries to reportupdater would be worth the effort, so we have no particular plans to actually do this right now.

Fri, Feb 15, 9:09 PM · Contributors-Analysis, Product-Analytics

Thu, Feb 14

Neil_P._Quinn_WMF added a comment to T202148: Instrument editing pipeline to be able to figure out which common editing features are used.

@DLynch, if you look at the full list of logged features we already have a table, window-open event being logged. Will this be different from that?

Thu, Feb 14, 7:01 PM · MW-1.33-notes (1.33.0-wmf.19; 2019-02-26), MW-1.32-notes (WMF-deploy-2018-10-16 (1.32.0-wmf.26)), Patch-For-Review, Editing Q1 2018-19 mobile improvements, VisualEditor (Current work), Product-Analytics
Neil_P._Quinn_WMF added a comment to T202148: Instrument editing pipeline to be able to figure out which common editing features are used.

Change 490661 had a related patch set uploaded (by DLynch; owner: DLynch):
[VisualEditor/VisualEditor@master] Track feature-use activity for tables

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

Thu, Feb 14, 6:59 PM · MW-1.33-notes (1.33.0-wmf.19; 2019-02-26), MW-1.32-notes (WMF-deploy-2018-10-16 (1.32.0-wmf.26)), Patch-For-Review, Editing Q1 2018-19 mobile improvements, VisualEditor (Current work), Product-Analytics
Neil_P._Quinn_WMF added a comment to T215589: Migrate users to dbstore100[3-5].

Message to everybody:

Analytics and the Data Persistence team are planning to schedule the official cut off date for the staging database on dbstore1002 for Monday 18th (US holiday) during the EU morning. This is the plan:

  • set the staging database as read only on dbstore1002
  • dump the database and import it to dbstore1005 (takes hours to complete)
  • set dbstore1005 as read/write and official supported staging database

    Important considerations:
  • dbstore1002 will not be decommissioned or stopped during this maintenance window, all the database/tables will be available. The only difference will be that the staging database will be read-only.
  • we are doing this to allow people to migrate their (stateful) scripts to the new system and avoid loosing data. Basically we want to have a clean date/time of the last snapshot taken for staging.

    Please let us know if this is too soon or impossible to coordinate/sustain, we'll find another timing. Going also to send an email to people to alert about this change.
Thu, Feb 14, 6:53 PM · User-Marostegui, Analytics-Kanban, Analytics

Tue, Feb 12

Neil_P._Quinn_WMF moved T202133: Snapshot: usage of common editing features from Doing to Blocked on the Product-Analytics board.
Tue, Feb 12, 6:55 PM · Editing Q1 2018-19 mobile improvements, Product-Analytics, VisualEditor
Neil_P._Quinn_WMF updated subscribers of T202133: Snapshot: usage of common editing features.

Thanks to @DLynch's bugfixes, we are now properly collecting mobile feature use data (P8074). We will have 2 weeks of data after 22 February, so at that point I will be able to calculate the corresponding numbers for the mobile editor.

Tue, Feb 12, 6:54 PM · Editing Q1 2018-19 mobile improvements, Product-Analytics, VisualEditor
Neil_P._Quinn_WMF created P8074 Mobile visual editor feature use events.
Tue, Feb 12, 6:53 PM
Neil_P._Quinn_WMF added a comment to T212386: Provide tools for querying MediaWiki replica databases without having to specify the shard.
Tue, Feb 12, 6:28 PM · Product-Analytics, Patch-For-Review, Analytics, WMDE-Analytics-Engineering, User-Addshore, User-Elukey, Research
Neil_P._Quinn_WMF moved T194650: Measure the surviving translations by newcomers from Next Up to Doing on the Product-Analytics board.
Tue, Feb 12, 4:14 PM · Language-Team (Language-2019-January-March), Contributors-Analysis, Product-Analytics, CX-analytics
Neil_P._Quinn_WMF moved T213878: Calculate and report contributors health metrics for January 2019 from Blocked to Doing on the Product-Analytics board.
Tue, Feb 12, 4:13 PM · Contributors-Analysis, Product-Analytics
Neil_P._Quinn_WMF moved T131280: Make aggregate data on editors per country per wiki publicly available from Triage to Tracking on the Product-Analytics board.
Tue, Feb 12, 1:39 PM · Product-Analytics, Analytics-Kanban
Neil_P._Quinn_WMF added a project to T131280: Make aggregate data on editors per country per wiki publicly available: Product-Analytics.
Tue, Feb 12, 1:39 PM · Product-Analytics, Analytics-Kanban

Mon, Feb 11

Neil_P._Quinn_WMF added a comment to T215830: Requesting access to analytics-privatedata for esanders.

For the record, he needs this access so he can inspect EventLogging data related to the Editing team's products in Hadoop (one of the most important data streams, EditAttemptStep, is not available in the MariaDB EventLogging store).

Mon, Feb 11, 7:32 PM · Patch-For-Review, Operations, SRE-Access-Requests
Neil_P._Quinn_WMF moved T209995: Investigate why init->loaded drop-off is so high in desktop wikitext metrics from Q3 to Analysis on the VisualEditor board.
Mon, Feb 11, 6:23 PM · Product-Analytics, VisualEditor
Neil_P._Quinn_WMF moved T202132: EPIC: Generate one-off metric snapshots for mobile editing documentation from Q3 to Analysis on the VisualEditor board.
Mon, Feb 11, 6:23 PM · Editing Q1 2018-19 mobile improvements, Product-Analytics, VisualEditor
Neil_P._Quinn_WMF moved T198369: Start calculating Editing's annual plan metrics from Q3 to Analysis on the VisualEditor board.
Mon, Feb 11, 6:23 PM · VisualEditor, Editing-team, Contributors-Analysis, Product-Analytics
Neil_P._Quinn_WMF moved T211239: Analyze impact of section editing in the mobile visual editor from Q3 to Analysis on the VisualEditor board.
Mon, Feb 11, 6:23 PM · Product-Analytics, VisualEditor
Neil_P._Quinn_WMF moved T211949: Show Rummana how to query EventLogging databases using Hive from Current work to Analysis on the VisualEditor board.
Mon, Feb 11, 6:22 PM · VisualEditor, Contributors-Analysis, Product-Analytics
Neil_P._Quinn_WMF moved T214450: Analyze impact of parallel loading of page content and mobile visual editor code from Current work to Analysis on the VisualEditor board.
Mon, Feb 11, 6:19 PM · VisualEditor, Product-Analytics, Performance, VisualEditor-MediaWiki-Mobile
Neil_P._Quinn_WMF moved T202132: EPIC: Generate one-off metric snapshots for mobile editing documentation from Epics to Q3 on the VisualEditor board.
Mon, Feb 11, 6:19 PM · Editing Q1 2018-19 mobile improvements, Product-Analytics, VisualEditor
Neil_P._Quinn_WMF moved T209705: Dashboard EditSchema timing metrics from Current work to Analysis on the VisualEditor board.
Mon, Feb 11, 6:19 PM · VisualEditor, Product-Analytics
Neil_P._Quinn_WMF moved T212137: Analyze impact of mobile visual editor load screen improvements from Up next to Analysis on the VisualEditor board.
Mon, Feb 11, 6:17 PM · Product-Analytics, VisualEditor
Neil_P._Quinn_WMF moved T202133: Snapshot: usage of common editing features from Up next to Analysis on the VisualEditor board.
Mon, Feb 11, 6:17 PM · Editing Q1 2018-19 mobile improvements, Product-Analytics, VisualEditor
Neil_P._Quinn_WMF added a comment to T212386: Provide tools for querying MediaWiki replica databases without having to specify the shard.

SRV records deployed and documentation updated! If anybody could give it a try, I'd be really glad :)

Mon, Feb 11, 2:04 PM · Product-Analytics, Patch-For-Review, Analytics, WMDE-Analytics-Engineering, User-Addshore, User-Elukey, Research

Sun, Feb 10

Neil_P._Quinn_WMF added a comment to T209087: [EventLogging Sanitization] Update EL sanitization white-list for field renames in EL schemas.

@mpopov Just a heads-up that we'll be turning on the deletion script that will delete unsanitized EL data very soon.
If there are no changes to EL sanitization whitelist, the data that this task refers will be irrecoverable after the script runs.
If you want me to backfill (thus fix) any renamed fields that are missing today, now would be the time! :]

Sun, Feb 10, 3:42 PM · Patch-For-Review, Product-Analytics, Reading-analysis, Analytics
Neil_P._Quinn_WMF added a project to T212588: Whitelist VisualEditorFeatureUse data stream: Analytics-Kanban.

@JAllemandou, @Ottomata, I'd like to get this deployed 😁

Sun, Feb 10, 3:37 PM · Analytics-Kanban, Patch-For-Review, Contributors-Analysis, Product-Analytics
Neil_P._Quinn_WMF moved T212386: Provide tools for querying MediaWiki replica databases without having to specify the shard from Triage to Tracking on the Product-Analytics board.
Sun, Feb 10, 3:26 PM · Product-Analytics, Patch-For-Review, Analytics, WMDE-Analytics-Engineering, User-Addshore, User-Elukey, Research
Neil_P._Quinn_WMF added a project to T212386: Provide tools for querying MediaWiki replica databases without having to specify the shard: Product-Analytics.
Sun, Feb 10, 3:25 PM · Product-Analytics, Patch-For-Review, Analytics, WMDE-Analytics-Engineering, User-Addshore, User-Elukey, Research
Neil_P._Quinn_WMF added a comment to T212386: Provide tools for querying MediaWiki replica databases without having to specify the shard.

I had the chance to have a chat with a lot of people during all hands, this is a summary:

  • Mikhail/Chelsy mostly use R for their work, and it seems that the move to a multi dbstore hosts setup should not impact their work too much.
  • Tilman/Morten/Neil are using mostly python ad-hoc scripts for their daily work, so as starting point we agreed to 1) add snippets of Python code to generate a host:port mysql combination (to create a valid connection) from a dbname 2) have a tool like the one described above to wrap mysql commands for quick and interactive exploratory use cases.

    I already started to modify https://wikitech.wikimedia.org/wiki/Analytics/Data_access#MariaDB_replicas :)
Sun, Feb 10, 8:21 AM · Product-Analytics, Patch-For-Review, Analytics, WMDE-Analytics-Engineering, User-Addshore, User-Elukey, Research

Thu, Feb 7

Neil_P._Quinn_WMF moved T214929: Change ContentTranslation to log EditAttemptStep events as a distinct editor_interface from Triage to Tracking on the Product-Analytics board.
Thu, Feb 7, 6:51 PM · ContentTranslation, Contributors-Analysis, Product-Analytics
Neil_P._Quinn_WMF moved T214931: Consider how the EditAttemptStep schema can apply to ContentTranslation from Triage to Backlog on the Product-Analytics board.
Thu, Feb 7, 6:50 PM · CX-analytics, Epic, Product-Analytics, Contributors-Analysis
Neil_P._Quinn_WMF moved T215201: Document support for MariaDB EL data access in wmfdata from Triage to Backlog on the Product-Analytics board.
Thu, Feb 7, 6:31 PM · Product-Analytics
Neil_P._Quinn_WMF added a comment to T215201: Document support for MariaDB EL data access in wmfdata.

You can do this using the mariadb.run function with the parameter host = "logs"—see https://github.com/neilpquinn/wmfdata/blob/master/wmfdata/mariadb.py#L21 for details.

Thu, Feb 7, 6:31 PM · Product-Analytics
Neil_P._Quinn_WMF renamed T215201: Document support for MariaDB EL data access in wmfdata from Add or document support for MariaDB EL data access in wmfdata to Document support for MariaDB EL data access in wmfdata.
Thu, Feb 7, 6:29 PM · Product-Analytics

Wed, Jan 30

Neil_P._Quinn_WMF moved T212824: notebook/stat server(s) running out of memory from Triage to Tracking on the Product-Analytics board.
Wed, Jan 30, 11:50 PM · Patch-For-Review, Product-Analytics, User-Elukey, Operations, Analytics
Neil_P._Quinn_WMF added a project to T212824: notebook/stat server(s) running out of memory: Product-Analytics.
Wed, Jan 30, 11:50 PM · Patch-For-Review, Product-Analytics, User-Elukey, Operations, Analytics

Tue, Jan 29

Neil_P._Quinn_WMF updated the task description for T211951: Prepare wmfdata for general use.
Tue, Jan 29, 6:42 PM · Contributors-Analysis, Product-Analytics
Neil_P._Quinn_WMF triaged T214931: Consider how the EditAttemptStep schema can apply to ContentTranslation as Normal priority.
Tue, Jan 29, 6:41 PM · CX-analytics, Epic, Product-Analytics, Contributors-Analysis
Neil_P._Quinn_WMF created T214929: Change ContentTranslation to log EditAttemptStep events as a distinct editor_interface.
Tue, Jan 29, 6:40 PM · ContentTranslation, Contributors-Analysis, Product-Analytics
Neil_P._Quinn_WMF updated the task description for T118063: Clean up the EditAttemptStep schema and its implementations.
Tue, Jan 29, 6:06 PM · Epic, Product-Analytics, VisualEditor, VisualEditor-MediaWiki, Contributors-Analysis

Thu, Jan 24

Neil_P._Quinn_WMF moved T211933: Update CE Insights query and bot from Triage to Next Up on the Product-Analytics board.
Thu, Jan 24, 10:37 PM · Product-Analytics, CE Insights - Survey Design

Wed, Jan 23

Neil_P._Quinn_WMF created T214533: Mobile visual editor not logging EditAttemptStep abort actions .
Wed, Jan 23, 11:33 PM · MW-1.33-notes (1.33.0-wmf.18; 2019-02-19), Patch-For-Review, VisualEditor (Current work), Contributors-Analysis, Product-Analytics
Neil_P._Quinn_WMF moved T209544: Vet the EditAttemptStep and VisualEditorFeatureUse data streams from Next Up to Doing on the Product-Analytics board.
Wed, Jan 23, 9:48 PM · Contributors-Analysis, Product-Analytics
Neil_P._Quinn_WMF added a comment to T209052: Load page content in parallel with VE code on Mobile with ArticleTargetLoader.

Should probably compare before/after numbers as part of QA. I don't know where they are logged.

Wed, Jan 23, 9:27 PM · MW-1.33-notes (1.33.0-wmf.14; 2019-01-22), VisualEditor (Current work), Patch-For-Review, Performance, VisualEditor-MediaWiki-Mobile
Neil_P._Quinn_WMF updated subscribers of T212588: Whitelist VisualEditorFeatureUse data stream.

@JAllemandou, @Ottomata: do I need to do anything to schedule a deploy of the updated whitelist? From what I understand, it doesn't happen automatically.

Wed, Jan 23, 8:13 PM · Analytics-Kanban, Patch-For-Review, Contributors-Analysis, Product-Analytics

Jan 23 2019

Neil_P._Quinn_WMF claimed T214450: Analyze impact of parallel loading of page content and mobile visual editor code.
Jan 23 2019, 1:22 AM · VisualEditor, Product-Analytics, Performance, VisualEditor-MediaWiki-Mobile
Neil_P._Quinn_WMF created T214450: Analyze impact of parallel loading of page content and mobile visual editor code.
Jan 23 2019, 1:21 AM · VisualEditor, Product-Analytics, Performance, VisualEditor-MediaWiki-Mobile

Jan 22 2019

Neil_P._Quinn_WMF added a comment to T213597: [REQUEST] Baselines for structured data on Commons.

Thank you so much, @Neil_P._Quinn_WMF! Really appreciate you catching that and correcting. I had incorrectly assumed that initial metadata would not be included. I'm currently looking into your suggested method of filtering revisions and comparing it to using revision_parent_id > 0, which should theoretically yield the same result but is not the case in practice.

Jan 22 2019, 11:56 PM · SDC General, Product-Analytics

Jan 19 2019

Neil_P._Quinn_WMF moved T202133: Snapshot: usage of common editing features from Next Up to Doing on the Product-Analytics board.
Jan 19 2019, 1:49 AM · Editing Q1 2018-19 mobile improvements, Product-Analytics, VisualEditor
Neil_P._Quinn_WMF moved T212588: Whitelist VisualEditorFeatureUse data stream from Doing to Blocked on the Product-Analytics board.
Jan 19 2019, 1:49 AM · Analytics-Kanban, Patch-For-Review, Contributors-Analysis, Product-Analytics
Neil_P._Quinn_WMF updated the task description for T212529: Standardize datetimes/timestamps in the Data Lake.
Jan 19 2019, 1:06 AM · Analytics, Product-Analytics
Neil_P._Quinn_WMF placed T214132: Switch the 2010 wikitext editor's EditAttemptStep logging to the client side up for grabs.
Jan 19 2019, 12:58 AM · Product-Analytics, VisualEditor

Jan 18 2019

Neil_P._Quinn_WMF added a comment to T213597: [REQUEST] Baselines for structured data on Commons.

Here's the query I used, which I would like someone in Product-Analytics (e.g. @chelsyx and @Neil_P._Quinn_WMF) to review:

Jan 18 2019, 11:48 PM · SDC General, Product-Analytics
Neil_P._Quinn_WMF placed T211173: "Edit" equivalent of pageviews daily available to use in Turnilo and Superset up for grabs.

That is quite easy, it just will take a few hours to load data with different transformations and see how the data looks in turnilo, probably @mforns will be doing this work

Jan 18 2019, 6:45 PM · Product-Analytics, Analytics
Neil_P._Quinn_WMF placed T211274: Write Hive UDF that does date arithmetic on full datetimes up for grabs.
Jan 18 2019, 2:01 AM · Contributors-Analysis, Product-Analytics
Neil_P._Quinn_WMF added a comment to T211274: Write Hive UDF that does date arithmetic on full datetimes.

This is actually kind of blocked on T212529: Standardize datetimes/timestamps in the Data Lake, unless we want to code the UDF to deal with four possible formats...

Jan 18 2019, 2:01 AM · Contributors-Analysis, Product-Analytics
Neil_P._Quinn_WMF renamed T212529: Standardize datetimes/timestamps in the Data Lake from Columns named "dt" in the Data Lake have different formats to Standardize datetimes/timestamps in the Data Lake.
Jan 18 2019, 1:59 AM · Analytics, Product-Analytics
Neil_P._Quinn_WMF added a comment to T212529: Standardize datetimes/timestamps in the Data Lake.

I going to boldly broaden this into a plea to fully standardize datetimes/timestamps in the Data Lake 🙏 There are actually two more formats that Morten didn't mention! I'll update the description.

Jan 18 2019, 1:39 AM · Analytics, Product-Analytics
Neil_P._Quinn_WMF moved T211274: Write Hive UDF that does date arithmetic on full datetimes from Triage to Backlog on the Product-Analytics board.
Jan 18 2019, 1:28 AM · Contributors-Analysis, Product-Analytics
Neil_P._Quinn_WMF moved T214132: Switch the 2010 wikitext editor's EditAttemptStep logging to the client side from Triage to Tracking on the Product-Analytics board.
Jan 18 2019, 1:27 AM · Product-Analytics, VisualEditor
Neil_P._Quinn_WMF moved T209995: Investigate why init->loaded drop-off is so high in desktop wikitext metrics from Triage to Blocked on the Product-Analytics board.
Jan 18 2019, 1:27 AM · Product-Analytics, VisualEditor
Neil_P._Quinn_WMF updated subscribers of T214132: Switch the 2010 wikitext editor's EditAttemptStep logging to the client side.

Perhaps I can convince you to do the dirty work, @DLynch? 😁

Jan 18 2019, 1:26 AM · Product-Analytics, VisualEditor
Neil_P._Quinn_WMF moved T214132: Switch the 2010 wikitext editor's EditAttemptStep logging to the client side from To Triage to Needs Discussion/Analysis on the VisualEditor board.
Jan 18 2019, 1:25 AM · Product-Analytics, VisualEditor
Neil_P._Quinn_WMF created T214132: Switch the 2010 wikitext editor's EditAttemptStep logging to the client side.
Jan 18 2019, 1:25 AM · Product-Analytics, VisualEditor
Neil_P._Quinn_WMF added a comment to T209995: Investigate why init->loaded drop-off is so high in desktop wikitext metrics.

As I mentioned at the Editing offsite in December, my hypothesis is that the difference is due to 2010 wikitext editor init events triggered by bots.

Jan 18 2019, 1:22 AM · Product-Analytics, VisualEditor
Neil_P._Quinn_WMF added a comment to T211173: "Edit" equivalent of pageviews daily available to use in Turnilo and Superset.

@Milimetric How quickly will you be able to set the cube up in Turnilo once we provide the transform spec? We're trying to prioritize this among our other work 😁

Jan 18 2019, 1:14 AM · Product-Analytics, Analytics
Neil_P._Quinn_WMF added a subtask for T214093: Modern Event Platform: Schema Guidelines and Conventions: T214129: Provide Product Analytics input on Modern Event Platform schema conventions.
Jan 18 2019, 12:36 AM · Patch-For-Review, Product-Analytics, Core Platform Team Backlog (Watching / External), Core Platform Team (Modern Event Platform (TEC2)), Goal, Services (watching), Analytics-EventLogging, EventBus, Analytics-Kanban
Neil_P._Quinn_WMF removed a project from T214129: Provide Product Analytics input on Modern Event Platform schema conventions: Contributors-Analysis.
Jan 18 2019, 12:36 AM · Product-Analytics
Neil_P._Quinn_WMF added a parent task for T214129: Provide Product Analytics input on Modern Event Platform schema conventions: T214093: Modern Event Platform: Schema Guidelines and Conventions.
Jan 18 2019, 12:36 AM · Product-Analytics
Neil_P._Quinn_WMF created T214129: Provide Product Analytics input on Modern Event Platform schema conventions.
Jan 18 2019, 12:36 AM · Product-Analytics
Neil_P._Quinn_WMF closed T208504: Review CE Insights survey plan and prioritize our survey questions as Resolved.
Jan 18 2019, 12:33 AM · CE Insights - Survey Design, Product-Design-Strategy, Contributors-Analysis, Product-Analytics
Neil_P._Quinn_WMF added a comment to T212386: Provide tools for querying MediaWiki replica databases without having to specify the shard.

Product Analytics met with @elukey and @Milimetric on Monday and had a good discussion about this project, which they are planning to work on (full notes).

There were a couple of action items for me:

  • Write [Python] pseudo-code demonstrating how I would invoke and use a hypothetical library used to make the queries.
  • Test the existing tools discussed here and determine whether that level of functionality works for us (it likely does)
Jan 18 2019, 12:30 AM · Product-Analytics, Patch-For-Review, Analytics, WMDE-Analytics-Engineering, User-Addshore, User-Elukey, Research
Neil_P._Quinn_WMF added a comment to T172410: Replace the current multisource analytics-store setup.

I discussed this with @Nuria in a meeting today and she clarified that T212386 is important work to Analytics Engineering and said the team plans to try installing the production SQL query script on the new hardware once it's set up (probably in mid-February). However, she can't make any commitments about what the team might do after that.

Jan 18 2019, 12:21 AM · Product-Analytics, Analytics, WMDE-Analytics-Engineering, User-Addshore, User-Elukey, Research
Neil_P._Quinn_WMF moved T208504: Review CE Insights survey plan and prioritize our survey questions from Doing to Blocked on the Product-Analytics board.
Jan 18 2019, 12:12 AM · CE Insights - Survey Design, Product-Design-Strategy, Contributors-Analysis, Product-Analytics
Neil_P._Quinn_WMF added a comment to T208504: Review CE Insights survey plan and prioritize our survey questions.

I sent the list to Edward, and now I'm just waiting for him to make the changes (or possibly object) before I close this.

Jan 18 2019, 12:12 AM · CE Insights - Survey Design, Product-Design-Strategy, Contributors-Analysis, Product-Analytics
Neil_P._Quinn_WMF moved T188391: Develop strategies and tools for segmenting wikis [2018-19 AP output 4.3] from Backlog to Epics on the Better Use Of Data board.
Jan 18 2019, 12:08 AM · Better Use Of Data, Product-Design-Strategy, Epic, Product-Analytics, Contributors-Analysis
Neil_P._Quinn_WMF removed a subtask for T188391: Develop strategies and tools for segmenting wikis [2018-19 AP output 4.3]: T203034: Construct and personify wiki clusters [segmentation phase 3].
Jan 18 2019, 12:08 AM · Better Use Of Data, Product-Design-Strategy, Epic, Product-Analytics, Contributors-Analysis
Neil_P._Quinn_WMF removed a parent task for T203034: Construct and personify wiki clusters [segmentation phase 3]: T188391: Develop strategies and tools for segmenting wikis [2018-19 AP output 4.3].
Jan 18 2019, 12:07 AM · Product-Design-Strategy, Epic, Product-Analytics, Contributors-Analysis

Jan 17 2019

Neil_P._Quinn_WMF moved T188391: Develop strategies and tools for segmenting wikis [2018-19 AP output 4.3] from Next Up to Doing on the Product-Analytics board.
Jan 17 2019, 11:42 PM · Better Use Of Data, Product-Design-Strategy, Epic, Product-Analytics, Contributors-Analysis
Neil_P._Quinn_WMF moved T188391: Develop strategies and tools for segmenting wikis [2018-19 AP output 4.3] from Backlog to Next Up on the Product-Analytics board.
Jan 17 2019, 11:42 PM · Better Use Of Data, Product-Design-Strategy, Epic, Product-Analytics, Contributors-Analysis
Neil_P._Quinn_WMF claimed T188391: Develop strategies and tools for segmenting wikis [2018-19 AP output 4.3].
Jan 17 2019, 11:42 PM · Better Use Of Data, Product-Design-Strategy, Epic, Product-Analytics, Contributors-Analysis