nettrom_WMF (Morten Warncke-Wang)
Data Analyst, Product Analytics

Today

  • Clear sailing ahead.

Tomorrow

  • Clear sailing ahead.

Saturday

  • Clear sailing ahead.

User Details

User Since
Aug 21 2018, 8:23 PM (16 w, 1 d)
Availability
Available
IRC Nick
Nettrom
LDAP User
Unknown
MediaWiki User
MWang (WMF) [ Global Accounts ]

Recent Activity

Yesterday

nettrom_WMF moved T210899: Personalized first day: initial reporting from Triage to Next Up on the Product-Analytics board.
Wed, Dec 12, 12:50 AM · Product-Analytics, Growth-Team (Current Sprint)
nettrom_WMF added a project to T210899: Personalized first day: initial reporting: Product-Analytics.
Wed, Dec 12, 12:50 AM · Product-Analytics, Growth-Team (Current Sprint)

Tue, Dec 11

nettrom_WMF updated subscribers of T211739: Help panel: Extend EditorJourney data capturing to 14 days for help desk pages.
Tue, Dec 11, 11:05 PM · Growth-Team
nettrom_WMF added a parent task for T211739: Help panel: Extend EditorJourney data capturing to 14 days for help desk pages: T206719: Help panel: instrumentation.
Tue, Dec 11, 11:04 PM · Growth-Team
nettrom_WMF added a subtask for T206719: Help panel: instrumentation: T211739: Help panel: Extend EditorJourney data capturing to 14 days for help desk pages.
Tue, Dec 11, 11:04 PM · Growth-Team (Current Sprint), Product-Analytics
nettrom_WMF created T211739: Help panel: Extend EditorJourney data capturing to 14 days for help desk pages.
Tue, Dec 11, 11:03 PM · Growth-Team

Mon, Dec 10

nettrom_WMF created T211627: Mediawiki history has no data on IP blocks.
Mon, Dec 10, 8:25 PM · Anti-Harassment, Product-Analytics, Analytics

Sat, Dec 8

Neil_P._Quinn_WMF awarded T211263: Pair with Neil on the contributor health metrics for December 2018 a Party Time token.
Sat, Dec 8, 6:22 PM · Product-Analytics

Fri, Dec 7

nettrom_WMF added a comment to T208332: Add EditAttemptStep properties to the schema whitelist.

After discussing this with @Neil_P._Quinn_WMF, we propose to remove the information that identifies what page the user was attempting to edit. I've updated the patch so that the page_id, page_title, and revision_id fields are deleted.

Fri, Dec 7, 5:26 PM · Analytics, Patch-For-Review, Growth-Team, Product-Analytics
nettrom_WMF added a comment to T209982: Help panel: Develop Schema .

That also reminds me: would it be a good idea to enable oversampling of EditAttemptStep events when the help panel is enabled? On the one hand, it seems useful to be able to cross-reference to that schema; on the other hand, I don't think that anything that's been requested requires that, and the increase in the number of events would be more substantial than that done by EditorJourney.

Fri, Dec 7, 1:06 AM · Growth-Team (Current Sprint), Product-Analytics

Thu, Dec 6

nettrom_WMF moved T209982: Help panel: Develop Schema from Triage to Tracking on the Product-Analytics board.
Thu, Dec 6, 9:23 PM · Growth-Team (Current Sprint), Product-Analytics

Wed, Dec 5

nettrom_WMF moved T211263: Pair with Neil on the contributor health metrics for December 2018 from Triage to Next Up on the Product-Analytics board.
Wed, Dec 5, 11:56 PM · Product-Analytics
nettrom_WMF triaged T211263: Pair with Neil on the contributor health metrics for December 2018 as High priority.
Wed, Dec 5, 11:56 PM · Product-Analytics
nettrom_WMF added a parent task for T211263: Pair with Neil on the contributor health metrics for December 2018: T210040: Calculate and report contributors health metrics for November 2018.
Wed, Dec 5, 11:55 PM · Product-Analytics
nettrom_WMF added a subtask for T210040: Calculate and report contributors health metrics for November 2018: T211263: Pair with Neil on the contributor health metrics for December 2018.
Wed, Dec 5, 11:55 PM · Contributors-Analysis, Product-Analytics
nettrom_WMF created T211263: Pair with Neil on the contributor health metrics for December 2018.
Wed, Dec 5, 11:55 PM · Product-Analytics
nettrom_WMF moved T206719: Help panel: instrumentation from Backlog to Doing on the Product-Analytics board.
Wed, Dec 5, 10:50 PM · Growth-Team (Current Sprint), Product-Analytics
nettrom_WMF moved T206720: Help panel: experiments from Backlog to Doing on the Product-Analytics board.
Wed, Dec 5, 10:50 PM · Growth-Team (Current Sprint), Product-Analytics

Tue, Dec 4

nettrom_WMF added a comment to T206720: Help panel: experiments.

To capture the further discussions we had about this today, the current proposal is:

Tue, Dec 4, 8:18 PM · Growth-Team (Current Sprint), Product-Analytics
nettrom_WMF added a comment to T206720: Help panel: experiments.

I had a look at this and have a bunch of questions and thoughts that we should discuss and make decisions on.

Tue, Dec 4, 1:25 AM · Growth-Team (Current Sprint), Product-Analytics

Fri, Nov 30

nettrom_WMF added a comment to T210040: Calculate and report contributors health metrics for November 2018.

@nettrom_WMF, should we plan to pair on this? I'm doing a bunch of cleanup to the code right now, so it should be in a pretty good state by next month.

Fri, Nov 30, 7:28 PM · Contributors-Analysis, Product-Analytics
nettrom_WMF moved T206720: Help panel: experiments from Needs Design/Design Doing to In Progress on the Growth-Team (Current Sprint) board.
Fri, Nov 30, 6:58 PM · Growth-Team (Current Sprint), Product-Analytics
nettrom_WMF moved T206182: Understanding first day: write analytics queries in advance from In Progress to Ready for Development on the Growth-Team (Current Sprint) board.
Fri, Nov 30, 6:58 PM · Product-Analytics, Growth-Team (Current Sprint)
nettrom_WMF moved T209009: Understanding first day: post-deployment QA from In Progress to Ready for Development on the Growth-Team (Current Sprint) board.
Fri, Nov 30, 6:58 PM · Growth-Team (Current Sprint), Product-Analytics

Mon, Nov 26

nettrom_WMF updated the task description for T210434: Understanding first day: analysis caveats.
Mon, Nov 26, 7:27 PM · Product-Analytics, Growth-Team
nettrom_WMF updated the task description for T210434: Understanding first day: analysis caveats.
Mon, Nov 26, 7:19 PM · Product-Analytics, Growth-Team
nettrom_WMF added a comment to T210417: return/returnto query not always hashed as intended.

I looked through the questions we're asking about new users, particularly around account creation, and this issue isn't a problem for us.
We're only concerned about the context in which the account was created (reading/editing, which is answered by the ServerSideAccountCreation schema) rather than more specifically what the users were reading prior to creating their account. It's still worthwhile to take note of this, so I've created T210434 to track the things I need to keep in mind as I'm working with the data.

Mon, Nov 26, 7:10 PM · Growth-Team (Current Sprint), Product-Analytics
nettrom_WMF created T210434: Understanding first day: analysis caveats.
Mon, Nov 26, 7:04 PM · Product-Analytics, Growth-Team

Sat, Nov 17

nettrom_WMF added a comment to T207307: Understanding first day: testing and QA.

Oh, my bad, sorry! Should've asked first. I somehow ended up thinking that it was in production since I was seeing the logout events in the data.

Sat, Nov 17, 2:40 AM · MW-1.33-notes (1.33.0-wmf.4; 2018-11-13), Patch-For-Review, Growth-Team (Current Sprint)
nettrom_WMF added a comment to T207307: Understanding first day: testing and QA.

@kostajh : Good news: Logout events are now captured by the schema! Bad news: user_id = 0 for all events, so we don't know which user logged out.

Sat, Nov 17, 1:51 AM · MW-1.33-notes (1.33.0-wmf.4; 2018-11-13), Patch-For-Review, Growth-Team (Current Sprint)

Fri, Nov 16

nettrom_WMF updated subscribers of T200970: Add logging to gauge TemplateWizard usage.

@Niharika : You're welcome! stat1006 doesn't have access to Hive (the query tool for the Data Lake), so you'll need access to either stat1004 or stat1007. There's also a browser interface called Hue, but I'm unsure if that's a tool that Analytics recommends.

Fri, Nov 16, 10:38 PM · MW-1.33-notes (1.33.0-wmf.2; 2018-10-30), Patch-For-Review, Community-Tech-Sprint, Product-Analytics, Community-Tech, MediaWiki-extensions-TemplateWizard
nettrom_WMF closed T209540: Audit special pages to identify hashing requirements as Resolved.

Based on our findings, I don't see a reason for not closing this at this point.

Fri, Nov 16, 9:20 PM · Product-Analytics, Growth-Team
nettrom_WMF updated subscribers of T200970: Add logging to gauge TemplateWizard usage.

@kaldari asked me to look into this, so I did and here's a bit of info. Data for this schema is being captured (ref this dashboard) and stored in the Data Lake (see more info below), but does not appear to be whitelisted to be ingested into MariaDB (ref this documentation and this file). I'm not sure what the process is to get this data into MariaDB if that's needed, but Analytics can hopefully advise.

Fri, Nov 16, 7:12 PM · MW-1.33-notes (1.33.0-wmf.2; 2018-10-30), Patch-For-Review, Community-Tech-Sprint, Product-Analytics, Community-Tech, MediaWiki-extensions-TemplateWizard
nettrom_WMF added a comment to T206380: Personalized first day: experiments (Variation A).

We wrote up our experiment plan and put it under our team pages on mw.org.

Fri, Nov 16, 6:42 PM · Growth-Team (Current Sprint), Product-Analytics
nettrom_WMF added a parent task for T209721: Understanding first day: decide on a purging strategy for the EditorJourney schema: T205763: Understanding first day: "Schema:EditorJourney" instrumentation specification.
Fri, Nov 16, 6:23 PM · Growth-Team (Current Sprint), Product-Analytics
nettrom_WMF added a subtask for T205763: Understanding first day: "Schema:EditorJourney" instrumentation specification: T209721: Understanding first day: decide on a purging strategy for the EditorJourney schema.
Fri, Nov 16, 6:23 PM · Growth-Team (Current Sprint)
nettrom_WMF created T209721: Understanding first day: decide on a purging strategy for the EditorJourney schema.
Fri, Nov 16, 6:22 PM · Growth-Team (Current Sprint), Product-Analytics

Thu, Nov 15

nettrom_WMF added a comment to T209635: Update EventLogging kafkacat examples to use jumbo.

I updated the "How do I" section of Kafka on Wikitech as well, as it was mentioned there.

Thu, Nov 15, 8:35 PM · Analytics-Kanban, Analytics
nettrom_WMF added a comment to T209540: Audit special pages to identify hashing requirements.

@Tbayer : that is very useful, thanks so much for bringing it to our attention!

Thu, Nov 15, 1:00 AM · Product-Analytics, Growth-Team
nettrom_WMF closed T206377: Personalized first day: how many accounts are made from which contexts? as Resolved.

Thanks for helping make this happen, @revi!

Thu, Nov 15, 12:36 AM · User-revi, Growth-Team (Current Sprint), Product-Analytics
nettrom_WMF closed T206377: Personalized first day: how many accounts are made from which contexts?, a subtask of T206365: [EPIC] Growth: Personalized first day (Part 1), as Resolved.
Thu, Nov 15, 12:36 AM · Epic, Growth-Team

Wed, Nov 14

nettrom_WMF created T209540: Audit special pages to identify hashing requirements.
Wed, Nov 14, 9:17 PM · Product-Analytics, Growth-Team
nettrom_WMF added a project to T209403: 👩‍👧‍👦 Measure the effectiveness of blocks: Product-Analytics.
Wed, Nov 14, 12:48 AM · Anti-Harassment, Product-Analytics, MediaWiki-User-management

Tue, Nov 13

nettrom_WMF added a subtask for T207307: Understanding first day: testing and QA: T209431: Mobile edits not logged in EditAttemptStep schema.
Tue, Nov 13, 11:27 PM · MW-1.33-notes (1.33.0-wmf.4; 2018-11-13), Patch-For-Review, Growth-Team (Current Sprint)
nettrom_WMF added a parent task for T209431: Mobile edits not logged in EditAttemptStep schema: T207307: Understanding first day: testing and QA.
Tue, Nov 13, 11:27 PM · Growth-Team (Current Sprint), MW-1.33-notes (1.33.0-wmf.4; 2018-11-13), Patch-For-Review
nettrom_WMF created T209431: Mobile edits not logged in EditAttemptStep schema.
Tue, Nov 13, 11:26 PM · Growth-Team (Current Sprint), MW-1.33-notes (1.33.0-wmf.4; 2018-11-13), Patch-For-Review
nettrom_WMF added a comment to T207307: Understanding first day: testing and QA.
  • @nettrom_WMF and @kostajh will look into why a certain event got recorded twice, with exactly the same content, but three seconds apart. The event in question was when I clicked to edit/create my User Talk page as User:MMiller Test 01 test.
Tue, Nov 13, 10:30 PM · MW-1.33-notes (1.33.0-wmf.4; 2018-11-13), Patch-For-Review, Growth-Team (Current Sprint)
nettrom_WMF created T209401: EditorJourney title hashing issue.
Tue, Nov 13, 5:55 PM · MW-1.33-notes (1.33.0-wmf.4; 2018-11-13), User-kostajh, Growth-Team (Current Sprint)

Nov 10 2018

nettrom_WMF added a comment to T207307: Understanding first day: testing and QA.

Current status on my end is that I have not found any significant issues with the data.

Nov 10 2018, 4:10 AM · MW-1.33-notes (1.33.0-wmf.4; 2018-11-13), Patch-For-Review, Growth-Team (Current Sprint)

Nov 9 2018

nettrom_WMF added a subtask for T205763: Understanding first day: "Schema:EditorJourney" instrumentation specification: T209195: Make the EditorJourney schema not log autocreated users.
Nov 9 2018, 11:13 PM · Growth-Team (Current Sprint)
nettrom_WMF added a parent task for T209195: Make the EditorJourney schema not log autocreated users: T205763: Understanding first day: "Schema:EditorJourney" instrumentation specification.
Nov 9 2018, 11:13 PM · MW-1.33-notes (1.33.0-wmf.4; 2018-11-13), Patch-For-Review, Growth-Team (Current Sprint)
nettrom_WMF created T209195: Make the EditorJourney schema not log autocreated users.
Nov 9 2018, 11:12 PM · MW-1.33-notes (1.33.0-wmf.4; 2018-11-13), Patch-For-Review, Growth-Team (Current Sprint)
nettrom_WMF moved T208089: [EPIC] Infrastructure for interventions impacting editing metrics from Triage to Backlog on the Product-Analytics board.
Nov 9 2018, 7:41 PM · Epic, Product-Analytics
nettrom_WMF moved T208438: Mechanism for selecting contributors for A/B tests from Triage to Backlog on the Product-Analytics board.
Nov 9 2018, 7:40 PM · Product-Analytics
nettrom_WMF moved T208440: Tracking contributions made by contributors enrolled in A/B tests from Triage to Backlog on the Product-Analytics board.
Nov 9 2018, 7:40 PM · Product-Analytics
nettrom_WMF moved T199726: Understand if ru.wikipedia main page changes had impact on mobile users from Triage to Backlog on the Product-Analytics board.
Nov 9 2018, 7:40 PM · Product-Analytics, New-Readers
nettrom_WMF moved T208977: Prepare readers section of Audiences quarterly metrics review from Triage to Doing on the Product-Analytics board.
Nov 9 2018, 7:39 PM · Product-Analytics
nettrom_WMF moved T209009: Understanding first day: post-deployment QA from Triage to Next Up on the Product-Analytics board.
Nov 9 2018, 7:37 PM · Growth-Team (Current Sprint), Product-Analytics
nettrom_WMF moved T209087: [EventLogging Sanitization] Update EL sanitization white-list for field renames in EL schemas from Triage to Next Up on the Product-Analytics board.
Nov 9 2018, 7:37 PM · Product-Analytics, Reading-analysis, Analytics
nettrom_WMF added a comment to T206377: Personalized first day: how many accounts are made from which contexts?.

@revi : that sounds great, thanks!

Nov 9 2018, 6:49 PM · User-revi, Growth-Team (Current Sprint), Product-Analytics
nettrom_WMF added a comment to T206377: Personalized first day: how many accounts are made from which contexts?.

@revi : after a bit more discussion with @SBisson and @MMiller_WMF, we have two options on how to do this. I'll first describe our preferred approach (option 1), and then provide an alternative (option 2).

Nov 9 2018, 4:37 PM · User-revi, Growth-Team (Current Sprint), Product-Analytics

Nov 7 2018

nettrom_WMF added a comment to T206377: Personalized first day: how many accounts are made from which contexts?.

I'd like to keep things transparent, so here's an update on why I edited this comment to remove my suggestion. The proposal was to add the returnto and returntoquery parameters to the signup link in the warning message shown to users who try to edit without logging in (the anoneditwarning message). Currently, neither of those are present, which means that after signing up, the user is returned to the main page. Adding those two will change the user experience so that they return to the page they tried to edit, and the editor will load.

Nov 7 2018, 9:28 PM · User-revi, Growth-Team (Current Sprint), Product-Analytics

Nov 6 2018

nettrom_WMF moved T206182: Understanding first day: write analytics queries in advance from Triage to Doing on the Product-Analytics board.
Nov 6 2018, 6:19 PM · Product-Analytics, Growth-Team (Current Sprint)
nettrom_WMF moved T206182: Understanding first day: write analytics queries in advance from Ready for Development to In Progress on the Growth-Team (Current Sprint) board.
Nov 6 2018, 6:19 PM · Product-Analytics, Growth-Team (Current Sprint)
nettrom_WMF added a comment to T206377: Personalized first day: how many accounts are made from which contexts?.

@MMiller_WMF : Good testing! I hadn't caught that the text editor and Visual Editor have different tab behavior.

Nov 6 2018, 5:09 AM · User-revi, Growth-Team (Current Sprint), Product-Analytics
nettrom_WMF removed Due Date on T206377: Personalized first day: how many accounts are made from which contexts?.
Nov 6 2018, 12:54 AM · User-revi, Growth-Team (Current Sprint), Product-Analytics
nettrom_WMF reopened T206377: Personalized first day: how many accounts are made from which contexts? as "Open".

Today I learned that my data gathering is most likely biased, shifting accounts from the "editing" to the "reading' context. @SBisson showed me that the English Wikipedia's warning message that is shown to users who try to edit without being logged in does not contain the returntoqueryparameter that we check for. This means that if a user clicks on the link to create an account from that warning message, it would not be counted. Note that the "Create account" link in the upper right hand corner on English Wikipedia does contain the returntoquery parameter if an edit is attempted, so those account creations are counted correctly.

Nov 6 2018, 12:54 AM · User-revi, Growth-Team (Current Sprint), Product-Analytics
nettrom_WMF reopened T206377: Personalized first day: how many accounts are made from which contexts?, a subtask of T206365: [EPIC] Growth: Personalized first day (Part 1), as Open.
Nov 6 2018, 12:54 AM · Epic, Growth-Team

Nov 2 2018

nettrom_WMF added a comment to T206371: Personalized first day: build Variation A.

I think modulo would work relatively well. It has a nice property of alternating. Consecutive users would get groups: a, b, c, a, b, c, etc. However, it assumes that all groups are of equal size. If it's not the case, we can assign weight to groups but it gets complicated quickly. Another drawback here is that some user ids are taken by auto-created users so as far as our population is concerned, they are skipped.

Nov 2 2018, 5:12 PM · MW-1.33-notes (1.33.0-wmf.4; 2018-11-13), Patch-For-Review, Growth-Team (Current Sprint)

Nov 1 2018

nettrom_WMF added a comment to T206371: Personalized first day: build Variation A.

@SBisson : This makes sense, thanks for explaining that! I don't see a need to change the way groups are set up, because we can define the names of the groups in such a way that it would be possible to track experiments and assignments. If the format is set to something like "[experiment name]_[group name]" it's easy for me to split that later if I need to. So for a hypothetical first experiment with two groups "survey" and "control", the group names could be "exp1_survey" and "exp1_control".

Nov 1 2018, 10:56 PM · MW-1.33-notes (1.33.0-wmf.4; 2018-11-13), Patch-For-Review, Growth-Team (Current Sprint)
nettrom_WMF added a comment to T208332: Add EditAttemptStep properties to the schema whitelist.

@Ottomata and @Nuria : thanks for pointing that out!

Nov 1 2018, 5:01 PM · Analytics, Patch-For-Review, Growth-Team, Product-Analytics
nettrom_WMF added a project to T208332: Add EditAttemptStep properties to the schema whitelist: Analytics.

Patch submitted, adding Analytics so they can triage and review.

Nov 1 2018, 4:22 PM · Analytics, Patch-For-Review, Growth-Team, Product-Analytics
nettrom_WMF added a comment to T208332: Add EditAttemptStep properties to the schema whitelist.

The only thing I see is that you have latency: keep in there, but there's no latency property. Copy-paste issue?

Nov 1 2018, 4:04 PM · Analytics, Patch-For-Review, Growth-Team, Product-Analytics
nettrom_WMF updated the task description for T208332: Add EditAttemptStep properties to the schema whitelist.
Nov 1 2018, 4:01 PM · Analytics, Patch-For-Review, Growth-Team, Product-Analytics

Oct 31 2018

nettrom_WMF added a comment to T206371: Personalized first day: build Variation A.

@SBisson : I thought about this, and I think it would be fantastic if we can record data for all users so that we know what experiment and group they were in and have that readily available for all users that were in an experiment. My main concern is that we'll switch between experiments and conditions, and knowing exactly when they started & ended, what the various groups were, and so forth, will become complicated over time. If we store it explicitly, we don't need to document the set of rules needed to infer it.

Oct 31 2018, 11:56 PM · MW-1.33-notes (1.33.0-wmf.4; 2018-11-13), Patch-For-Review, Growth-Team (Current Sprint)
nettrom_WMF closed T206377: Personalized first day: how many accounts are made from which contexts? as Resolved.

I updated the work log today to add to the description of the contexts. This was done to make it clear that we capture 100% of the relevant contexts, and that the "reading" context does not exclusively mean they were reading a wiki page, it will also capture for instance looking at search results.

Oct 31 2018, 11:03 PM · User-revi, Growth-Team (Current Sprint), Product-Analytics
nettrom_WMF closed T206377: Personalized first day: how many accounts are made from which contexts?, a subtask of T206365: [EPIC] Growth: Personalized first day (Part 1), as Resolved.
Oct 31 2018, 11:03 PM · Epic, Growth-Team
nettrom_WMF moved T206377: Personalized first day: how many accounts are made from which contexts? from Blocked to Doing on the Product-Analytics board.
Oct 31 2018, 9:58 PM · User-revi, Growth-Team (Current Sprint), Product-Analytics
nettrom_WMF created T208373: Request for access to the beta cluster.
Oct 31 2018, 3:46 AM · Beta-Cluster-Infrastructure, Release-Engineering-Team, Growth-Team

Oct 30 2018

nettrom_WMF added a comment to T206380: Personalized first day: experiments (Variation A).

The main question being asked here is whether the survey we are adding has a detrimental effect on user activity. I've discussed this with @MMiller_WMF, and also with the Product-Analytics team. Out of those meetings comes the following recommendations and questions:

Oct 30 2018, 11:49 PM · Growth-Team (Current Sprint), Product-Analytics
nettrom_WMF added a comment to T206371: Personalized first day: build Variation A.

I'm trying to be conscious of db size in general but for this field specifically, it's a mysql blob (65k) so we have more than enough room.

We can keep or leave the _duration, it's your call.

Oct 30 2018, 11:26 PM · MW-1.33-notes (1.33.0-wmf.4; 2018-11-13), Patch-For-Review, Growth-Team (Current Sprint)
nettrom_WMF added a comment to T206377: Personalized first day: how many accounts are made from which contexts?.

@MMiller_WMF : I looked into the queries behind this and found that I was incorrect. As far as I can tell, the query captures 100% of reading/editing contexts but the "reading" context does not mean only reading an article. It will also capture accounts created from a context that has a query associated with it (e.g. a search). I don't think it's feasible to separate out queries, because they can also be used to read articles.

Oct 30 2018, 6:30 PM · User-revi, Growth-Team (Current Sprint), Product-Analytics
nettrom_WMF added a comment to T208332: Add EditAttemptStep properties to the schema whitelist.

@Neil_P._Quinn_WMF : Could you look over the specification and see if you spot any errors or omissions?

Oct 30 2018, 5:23 PM · Analytics, Patch-For-Review, Growth-Team, Product-Analytics
nettrom_WMF updated the task description for T208332: Add EditAttemptStep properties to the schema whitelist.
Oct 30 2018, 4:59 PM · Analytics, Patch-For-Review, Growth-Team, Product-Analytics
nettrom_WMF created T208332: Add EditAttemptStep properties to the schema whitelist.
Oct 30 2018, 4:57 PM · Analytics, Patch-For-Review, Growth-Team, Product-Analytics
nettrom_WMF triaged T201656: Growth: 2018-2019 annual plan metrics report as Normal priority.
Oct 30 2018, 4:42 PM · Growth-Team (Current Sprint), Product-Analytics
nettrom_WMF changed Due Date from Oct 29 2018, 7:00 AM to Fri, Nov 30, 8:00 AM on T201656: Growth: 2018-2019 annual plan metrics report.
Oct 30 2018, 4:41 PM · Growth-Team (Current Sprint), Product-Analytics
nettrom_WMF added a comment to T206371: Personalized first day: build Variation A.

_render_date UNIX timestamp when the survey was generated on the server (not exactly the same as when it is shown to the users but close enough I think)

_submit_date UNIX timestamp when the responses are received on the server

_duration Elapsed time between the 2 previous timestamps, in seconds. This can easily be recomputed from the previous timestamp. I'm happy to remove it to save space if it's not that useful.

Oct 30 2018, 4:38 PM · MW-1.33-notes (1.33.0-wmf.4; 2018-11-13), Patch-For-Review, Growth-Team (Current Sprint)
nettrom_WMF added a comment to T206182: Understanding first day: write analytics queries in advance.

@MMiller_WMF : I see that I maybe shouldn't phrase loose thoughts as questions when there's a dozen other people subscribed to a task, sorry! It was mainly intended as a mental note that these two tasks appear to be connected, so I should keep an eye on the progress made over there since it looked like they're working on it. But, I could also make sure everyone knows about all the symptoms, so thanks for tagging @kostajh!

Oct 30 2018, 4:25 PM · Product-Analytics, Growth-Team (Current Sprint)
nettrom_WMF added a comment to T206182: Understanding first day: write analytics queries in advance.

In preparation for this task, I looked into whether EventLogging data for our EditorJourney schema would be available in the Data Lake while being tested (i.e. on betalabs). My understanding is that the raw data will be available as it goes through Kafka, ref this part of the EL documentation.

Oct 30 2018, 12:04 AM · Product-Analytics, Growth-Team (Current Sprint)

Oct 29 2018

nettrom_WMF added a comment to T207803: Update EventLogging code to facilitate move to EditAttemptStep schema.

Per T202348#4697469, the page_token and session_token properties have been updated to be optional.

Oct 29 2018, 6:44 PM · Growth-Team (Current Sprint), MW-1.33-notes (1.33.0-wmf.2; 2018-10-30)
nettrom_WMF updated the task description for T207803: Update EventLogging code to facilitate move to EditAttemptStep schema.
Oct 29 2018, 6:41 PM · Growth-Team (Current Sprint), MW-1.33-notes (1.33.0-wmf.2; 2018-10-30)
nettrom_WMF renamed T207803: Update EventLogging code to facilitate move to EditAttemptStep schema from Update EventLogging code to facilitate move to EditAttempStep schema to Update EventLogging code to facilitate move to EditAttemptStep schema.
Oct 29 2018, 6:39 PM · Growth-Team (Current Sprint), MW-1.33-notes (1.33.0-wmf.2; 2018-10-30)
nettrom_WMF renamed T207803: Update EventLogging code to facilitate move to EditAttemptStep schema from Update EventLogging code to facilitate move to Edit2 schema to Update EventLogging code to facilitate move to EditAttempStep schema.
Oct 29 2018, 6:39 PM · Growth-Team (Current Sprint), MW-1.33-notes (1.33.0-wmf.2; 2018-10-30)

Oct 25 2018

nettrom_WMF added a comment to T203136: Develop new schema for editing feature usage.

@Neil_P._Quinn_WMF : I wanted to let you know, and at the same time document, that since the proposed Schema:Edit2 uses snake_case (per recommendations from AE), the editingSessionId property in the Edit schema becomes editing_session_id in the new version. In this (VisualEditorFeatureUse) schema it's camelCase. This might make joins between the two schemas somewhat confusing. Wanted to flag that so you can consider whether to keep it or not.

Oct 25 2018, 9:50 PM · 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
nettrom_WMF renamed T207803: Update EventLogging code to facilitate move to EditAttemptStep schema from Change EventLogging column names in editor code to Update EventLogging code to facilitate move to Edit2 schema.
Oct 25 2018, 8:43 PM · Growth-Team (Current Sprint), MW-1.33-notes (1.33.0-wmf.2; 2018-10-30)
nettrom_WMF added a comment to T202348: Resume refinement of edit events in Data Lake.

I've created Schema:Edit2, and its talk page has the standard template as well as documentation of its relationship and some information about the properties. Once it's finalized, I'll also update the talk page of Schema:Edit to reflect its successor.

Oct 25 2018, 7:22 PM · Growth-Team (Current Sprint), Analytics-Data-Quality, Analytics, Contributors-Analysis, Product-Analytics

Oct 24 2018

nettrom_WMF added a comment to T202348: Resume refinement of edit events in Data Lake.

Thanks for the feedback, @Nuria and @Ottomata! Discussed this with the Growth Team, and we all agree that creating a new schema is the better solution in this case.

Oct 24 2018, 11:46 PM · Growth-Team (Current Sprint), Analytics-Data-Quality, Analytics, Contributors-Analysis, Product-Analytics
nettrom_WMF moved T206377: Personalized first day: how many accounts are made from which contexts? from Doing to Blocked on the Product-Analytics board.
Oct 24 2018, 9:37 PM · User-revi, Growth-Team (Current Sprint), Product-Analytics
nettrom_WMF moved T206377: Personalized first day: how many accounts are made from which contexts? from In Progress to Needs PM Review on the Growth-Team (Current Sprint) board.
Oct 24 2018, 9:37 PM · User-revi, Growth-Team (Current Sprint), Product-Analytics