mforns (Marcel Ruiz Forns)
Software Engineer @ Analytics

Today

  • Clear sailing ahead.

Tomorrow

  • Clear sailing ahead.

Monday

  • Clear sailing ahead.

User Details

User Since
Nov 7 2014, 8:52 PM (202 w, 23 h)
Availability
Available
IRC Nick
mforns
LDAP User
Mforns
MediaWiki User
Unknown

Recent Activity

Yesterday

mforns added a comment to T202751: Ingest data from PageIssues EventLogging schema into Druid.

@Tbayer
Yes, no renames will be needed! We'll find a solution to the array field and implement it soon.
The only caveat is that fields (dimensions) with high cardinality, like pageToken, sessionToken, pageTitle and pageIdSource perform very bad in Druid, so I would blacklist them from Druid ingestion if possible.

Fri, Sep 21, 3:27 PM · Reading-analysis, Product-Analytics, Readers-Web-Backlog (Tracking), Page-Issue-Warnings, Analytics

Fri, Sep 14

mforns added a comment to T203180: Wikistats: add functions you apply to dimensional data such as "accumulate".

@Nuria, I totally agree that "1-Month" is too short to percieve any change, and the graph becomes totally useless.
On the other hand, "All" has too many data points for this particular metric (even if monthly). And you can not distinguish the last data points.
You can see the slope, but not follow the recent progress of the metric.

Fri, Sep 14, 3:42 PM · Analytics-Kanban, Patch-For-Review, Analytics

Thu, Sep 13

mforns added a comment to T203826: Decide whether enable per-editor edits stats (community decision).

Hi all :]

Thu, Sep 13, 8:29 PM · Community-consensus-needed, Analytics

Mon, Sep 10

srishakatux awarded T189210: [Analytics] Improvements to Wikistats2 front-end a Love token.
Mon, Sep 10, 8:12 PM · Outreach-Programs-Projects, Analytics-Kanban, Google-Summer-of-Code (2018)
mforns added a comment to T191086: Instrument and collect data via CitationUsage schema.

There's also about 20 citationUsage events per minute dropped client-side before sending (about 1% of potential events), due to urlSize constraints.

Mon, Sep 10, 5:43 PM · MW-1.32-release-notes (WMF-deploy-2018-09-18 (1.32.0-wmf.22)), Discovery-Search (Current work), Research-Archive, Performance-Team (Radar), Patch-For-Review, Research-2017-18-Q4
mforns closed T189210: [Analytics] Improvements to Wikistats2 front-end as Resolved.

Resolved! Kudos to Sahil

Mon, Sep 10, 5:22 PM · Outreach-Programs-Projects, Analytics-Kanban, Google-Summer-of-Code (2018)
mforns added a comment to T128623: Purge all Schema:Echo data after 90 days.

Let's 1) stop purging 2) drop all echo tables on events and events sanitized database 3) start purging again

Mon, Sep 10, 5:09 PM · Analytics-Kanban, Growth-Team, Notifications, Collaboration-Team-Triage, Analytics, DBA

Aug 22 2018

mforns claimed T199900: [EL sanitization] Store the old salt for 2 extra weeks.
Aug 22 2018, 7:17 PM · Patch-For-Review, Analytics-Kanban, Analytics-EventLogging, Analytics
mforns moved T199900: [EL sanitization] Store the old salt for 2 extra weeks from Next Up to In Progress on the Analytics-Kanban board.
Aug 22 2018, 7:17 PM · Patch-For-Review, Analytics-Kanban, Analytics-EventLogging, Analytics
mforns added a project to T199900: [EL sanitization] Store the old salt for 2 extra weeks: Analytics-Kanban.
Aug 22 2018, 7:17 PM · Patch-For-Review, Analytics-Kanban, Analytics-EventLogging, Analytics
mforns moved T200497: [Wikistats 2] Bug in time-range selector on detail page from In Code Review to Ready to Deploy on the Analytics-Kanban board.
Aug 22 2018, 3:09 PM · Patch-For-Review, Analytics-Kanban, Analytics, Analytics-Wikistats
mforns moved T202429: [EL sanitization] Make cron send alert emails if job fails before calling refine from In Progress to In Code Review on the Analytics-Kanban board.
Aug 22 2018, 3:09 PM · Patch-For-Review, Analytics-EventLogging, Analytics-Kanban, Analytics
mforns renamed T202429: [EL sanitization] Make cron send alert emails if job fails before calling refine from [EL sanitization] Modify spark log4j params to output to stdout instead of stderr to [EL sanitization] Make cron send alert emails if job fails before calling refine.
Aug 22 2018, 2:57 PM · Patch-For-Review, Analytics-EventLogging, Analytics-Kanban, Analytics

Aug 21 2018

mforns moved T202429: [EL sanitization] Make cron send alert emails if job fails before calling refine from Next Up to In Progress on the Analytics-Kanban board.
Aug 21 2018, 4:51 PM · Patch-For-Review, Analytics-EventLogging, Analytics-Kanban, Analytics
mforns triaged T202429: [EL sanitization] Make cron send alert emails if job fails before calling refine as Normal priority.
Aug 21 2018, 4:50 PM · Patch-For-Review, Analytics-EventLogging, Analytics-Kanban, Analytics
mforns moved T199902: [EL sanitization] Retroactively sanitize (including hash and salt appInstallId fields) data in the events database from In Progress to Done on the Analytics-Kanban board.
Aug 21 2018, 4:47 PM · Patch-For-Review, Analytics-Kanban, Analytics-EventLogging, Analytics

Aug 20 2018

mforns added a comment to T202312: Transform EventLoggingToDruid job to read schemas to ingest from a whitelist and process them all.

As part of this task, we should also add/change a/the puppet cron job to launch this properly.

Aug 20 2018, 6:17 PM · Analytics
mforns created T202312: Transform EventLoggingToDruid job to read schemas to ingest from a whitelist and process them all.
Aug 20 2018, 6:17 PM · Analytics

Aug 14 2018

mforns moved T199899: [EL Sanitization] Set up salt creation and rotation from In Code Review to Done on the Analytics-Kanban board.
Aug 14 2018, 12:04 PM · Patch-For-Review, Analytics-Kanban, Analytics-EventLogging, Analytics

Aug 13 2018

mforns added a comment to T201873: [EventLoggingToDruid] Allow ingestion of simple-type arrays by converting them to strings.

Should we sort the array before stringifying?
Like: [1,2] and [2,1] generate the same string "[1,2]"?
This would reduce the number of possible string values, and make differently ordered arrays match.
However, if the order in the array has a specific semantics, that would be lost in the stringification.

Aug 13 2018, 9:38 PM · Analytics
mforns added a project to T201873: [EventLoggingToDruid] Allow ingestion of simple-type arrays by converting them to strings: Analytics.
Aug 13 2018, 8:05 PM · Analytics
mforns created T201873: [EventLoggingToDruid] Allow ingestion of simple-type arrays by converting them to strings.
Aug 13 2018, 8:04 PM · Analytics

Aug 9 2018

mforns moved T198426: [EL sanitization] Add ability to salt and hash to eventlogging sanitization in Hive from Ready to Deploy to Done on the Analytics-Kanban board.
Aug 9 2018, 8:38 PM · Patch-For-Review, Analytics, Analytics-Kanban

Aug 6 2018

mforns moved T199902: [EL sanitization] Retroactively sanitize (including hash and salt appInstallId fields) data in the events database from Next Up to In Progress on the Analytics-Kanban board.
Aug 6 2018, 3:10 PM · Patch-For-Review, Analytics-Kanban, Analytics-EventLogging, Analytics
mforns added a project to T199902: [EL sanitization] Retroactively sanitize (including hash and salt appInstallId fields) data in the events database: Analytics-Kanban.
Aug 6 2018, 3:10 PM · Patch-For-Review, Analytics-Kanban, Analytics-EventLogging, Analytics
mforns moved T200497: [Wikistats 2] Bug in time-range selector on detail page from In Progress to In Code Review on the Analytics-Kanban board.
Aug 6 2018, 3:04 PM · Patch-For-Review, Analytics-Kanban, Analytics, Analytics-Wikistats

Aug 2 2018

mforns added a comment to T200497: [Wikistats 2] Bug in time-range selector on detail page.

You can also reproduce the error just by selecting a monthly time range and then changing to a daily time range.
The selected period is inconsistent with the shown data.

Aug 2 2018, 5:48 PM · Patch-For-Review, Analytics-Kanban, Analytics, Analytics-Wikistats

Aug 1 2018

mforns moved T200497: [Wikistats 2] Bug in time-range selector on detail page from Next Up to In Progress on the Analytics-Kanban board.
Aug 1 2018, 8:23 PM · Patch-For-Review, Analytics-Kanban, Analytics, Analytics-Wikistats
mforns added a project to T200497: [Wikistats 2] Bug in time-range selector on detail page: Analytics-Kanban.
Aug 1 2018, 8:23 PM · Patch-For-Review, Analytics-Kanban, Analytics, Analytics-Wikistats
mforns moved T198426: [EL sanitization] Add ability to salt and hash to eventlogging sanitization in Hive from In Code Review to Ready to Deploy on the Analytics-Kanban board.
Aug 1 2018, 8:22 PM · Patch-For-Review, Analytics, Analytics-Kanban
mforns created T200904: Use Snakebite instead of subprocess.Popen in HdfsUtils.
Aug 1 2018, 1:49 PM · Analytics

Jul 30 2018

mforns moved T199899: [EL Sanitization] Set up salt creation and rotation from In Progress to In Code Review on the Analytics-Kanban board.
Jul 30 2018, 7:15 PM · Patch-For-Review, Analytics-Kanban, Analytics-EventLogging, Analytics
mforns added a comment to T200498: [Wikistats 2] Provide metric area headings in the 'Explore Topics' dropdown.

@sahil505
Let's concentrate on the popups fix, and then if we have time, we can work on this. Is this OK?

Jul 30 2018, 3:59 PM · Analytics, Analytics-Wikistats

Jul 27 2018

mforns moved T199899: [EL Sanitization] Set up salt creation and rotation from Next Up to In Progress on the Analytics-Kanban board.
Jul 27 2018, 3:52 PM · Patch-For-Review, Analytics-Kanban, Analytics-EventLogging, Analytics
mforns claimed T199899: [EL Sanitization] Set up salt creation and rotation.
Jul 27 2018, 3:52 PM · Patch-For-Review, Analytics-Kanban, Analytics-EventLogging, Analytics
mforns moved T198426: [EL sanitization] Add ability to salt and hash to eventlogging sanitization in Hive from In Progress to In Code Review on the Analytics-Kanban board.
Jul 27 2018, 3:51 PM · Patch-For-Review, Analytics, Analytics-Kanban

Jul 20 2018

mforns created T200095: Add app_install_id and other renamed fields to EL sanitization whitelist.
Jul 20 2018, 4:26 PM · Analytics-Kanban, Patch-For-Review, Analytics-EventLogging, Analytics

Jul 19 2018

mforns added a comment to T199693: Table view of timely results in wikistats 2 should be ordered in time descending.

Makes sense to me!

Jul 19 2018, 8:50 PM · Analytics

Jul 18 2018

mforns created T199902: [EL sanitization] Retroactively sanitize (including hash and salt appInstallId fields) data in the events database.
Jul 18 2018, 11:30 AM · Patch-For-Review, Analytics-Kanban, Analytics-EventLogging, Analytics
mforns added a parent task for T199900: [EL sanitization] Store the old salt for 2 extra weeks: T199898: EventLogging sanitization.
Jul 18 2018, 11:26 AM · Patch-For-Review, Analytics-Kanban, Analytics-EventLogging, Analytics
mforns added a subtask for T199898: EventLogging sanitization: T199900: [EL sanitization] Store the old salt for 2 extra weeks.
Jul 18 2018, 11:26 AM · Analytics-EventLogging, Analytics-Kanban, Analytics
mforns created T199900: [EL sanitization] Store the old salt for 2 extra weeks.
Jul 18 2018, 11:26 AM · Patch-For-Review, Analytics-Kanban, Analytics-EventLogging, Analytics
mforns added a subtask for T199898: EventLogging sanitization: T199899: [EL Sanitization] Set up salt creation and rotation.
Jul 18 2018, 11:23 AM · Analytics-EventLogging, Analytics-Kanban, Analytics
mforns added a parent task for T199899: [EL Sanitization] Set up salt creation and rotation: T199898: EventLogging sanitization.
Jul 18 2018, 11:23 AM · Patch-For-Review, Analytics-Kanban, Analytics-EventLogging, Analytics
mforns created T199899: [EL Sanitization] Set up salt creation and rotation.
Jul 18 2018, 11:22 AM · Patch-For-Review, Analytics-Kanban, Analytics-EventLogging, Analytics
mforns added subtasks for T199898: EventLogging sanitization: T199836: [EL sanitization] Write and productionize script to drop partitions older than 90 days in events database, T198426: [EL sanitization] Add ability to salt and hash to eventlogging sanitization in Hive, T199230: [EL sanitization] Make WhitelistSanitization support arrays of structs, maps or other arrays.
Jul 18 2018, 11:19 AM · Analytics-EventLogging, Analytics-Kanban, Analytics
mforns added a parent task for T198426: [EL sanitization] Add ability to salt and hash to eventlogging sanitization in Hive: T199898: EventLogging sanitization.
Jul 18 2018, 11:19 AM · Patch-For-Review, Analytics, Analytics-Kanban
mforns added a parent task for T199230: [EL sanitization] Make WhitelistSanitization support arrays of structs, maps or other arrays: T199898: EventLogging sanitization.
Jul 18 2018, 11:19 AM · Analytics
mforns added a parent task for T199836: [EL sanitization] Write and productionize script to drop partitions older than 90 days in events database: T199898: EventLogging sanitization.
Jul 18 2018, 11:19 AM · Analytics-Kanban
mforns renamed T178174: [EL sanitization] Remove AppInstallIId from EventLogging purging white-list from Remove AppInstallIId from EventLogging purging white-list to [EL sanitization] Remove AppInstallIId from EventLogging purging white-list.
Jul 18 2018, 11:18 AM · Analytics-EventLogging, Patch-For-Review, Analytics-Kanban
mforns added a subtask for T199898: EventLogging sanitization: T178174: [EL sanitization] Remove AppInstallIId from EventLogging purging white-list.
Jul 18 2018, 11:13 AM · Analytics-EventLogging, Analytics-Kanban, Analytics
mforns added a parent task for T178174: [EL sanitization] Remove AppInstallIId from EventLogging purging white-list: T199898: EventLogging sanitization.
Jul 18 2018, 11:13 AM · Analytics-EventLogging, Patch-For-Review, Analytics-Kanban
mforns claimed T199898: EventLogging sanitization.
Jul 18 2018, 11:12 AM · Analytics-EventLogging, Analytics-Kanban, Analytics
mforns moved T199898: EventLogging sanitization from Next Up to Parent Tasks on the Analytics-Kanban board.
Jul 18 2018, 11:12 AM · Analytics-EventLogging, Analytics-Kanban, Analytics
mforns set the point value for T199898: EventLogging sanitization to 0.
Jul 18 2018, 11:11 AM · Analytics-EventLogging, Analytics-Kanban, Analytics
mforns created T199898: EventLogging sanitization.
Jul 18 2018, 11:11 AM · Analytics-EventLogging, Analytics-Kanban, Analytics
mforns renamed T199230: [EL sanitization] Make WhitelistSanitization support arrays of structs, maps or other arrays from Make WhitelistSanitization support arrays of structs, maps or other arrays to [EL sanitization] Make WhitelistSanitization support arrays of structs, maps or other arrays.
Jul 18 2018, 11:06 AM · Analytics
mforns moved T193176: [EL sanitization] Productionize EventLoggingSanitization.scala from In Code Review to Done on the Analytics-Kanban board.
Jul 18 2018, 11:05 AM · Patch-For-Review, Analytics-Kanban, Analytics
mforns renamed T193176: [EL sanitization] Productionize EventLoggingSanitization.scala from Productionize EventLogging sanitization to [EL sanitization] Productionize EventLoggingSanitization.scala.
Jul 18 2018, 11:05 AM · Patch-For-Review, Analytics-Kanban, Analytics
mforns renamed T198426: [EL sanitization] Add ability to salt and hash to eventlogging sanitization in Hive from Ability to salt and hash in hadoop eventlogging sanitization backend to [EL sanitization] Add ability to salt and hash to eventlogging sanitization in Hive.
Jul 18 2018, 11:03 AM · Patch-For-Review, Analytics, Analytics-Kanban
mforns renamed T199836: [EL sanitization] Write and productionize script to drop partitions older than 90 days in events database from Hadoop Sanitization. Drop partitions older than 90 days in events database to [EL sanitization] Write and productionize script to drop partitions older than 90 days in events database.
Jul 18 2018, 11:02 AM · Analytics-Kanban

Jul 16 2018

mforns closed T187452: We should prevent the user from trying to rediscover America as Resolved.

Already resolved by Sahil and Amit, thaaanks!

Jul 16 2018, 2:21 PM · Analytics

Jul 13 2018

mforns added a comment to T196904: Some VirtualPageView are too long and fail EventLogging processing.

@phuedx @elukey
I think a minimal amount of errors is expected.
AFAIK we only shorten the source_url, but there are other potentially long fields like source_title, that combined still can make the event overflow the max 2000 chars.
So, the errors should be a lot less frequent but not disappear, no?

Jul 13 2018, 3:20 PM · Readers-Web-Backlog (Readers-Web-Kanbanana-Board-2018-19-Q1), User-Ryasmeen, Readers-Web-Kanbanana-Board-Old, Page-Previews, Analytics, Analytics-EventLogging

Jul 12 2018

mforns added a comment to T199148: Consider changing EventLogging to encode events using base64 instead of uriEncode.

Base64 includes a-z, A-Z, 0-9, +, and /. So, all except / are 'legal'. I bet pivot/turnilo URI encode the base64 string to avoid problems with the /. This would add 2 extra chars for every / (it frequency being 1/64 in average), so a 3% increase. Theoretically, then, using base64+uriEncoding would be ~17% (not ~20%) shorter than using uriEncoding only.

Jul 12 2018, 5:37 PM · Analytics
mforns added a comment to T195269: Partially purge MobileWikiAppiOSUserHistory eventlogging schema.

I just merged the change, because it got a +1 from Nuria and a +1 from Chelsy.
We'll deploy that with the next refinery deployment.
I think we can close this task as resolved.

Jul 12 2018, 5:27 PM · Patch-For-Review, Analytics-Kanban, Product-Analytics, Analytics
phuedx awarded T186728: Record and aggregate page previews a Love token.
Jul 12 2018, 12:42 PM · MW-1.31-release-notes (WMF-deploy-2018-02-27 (1.31.0-wmf.23)), Patch-For-Review, Analytics-Kanban

Jul 11 2018

mforns added a comment to T192819: Event Logging schemas for Wikipedia iOS app.

@chelsyx Oh, ok! Sorry for the confusion :P

Jul 11 2018, 4:37 PM · Patch-For-Review, Product-Analytics, Wikipedia-iOS-App-Backlog
mforns created T199343: [Wikistats2] Fix topic selector routing.
Jul 11 2018, 4:04 PM · Analytics-Wikistats, Patch-For-Review, Analytics-Kanban, Analytics
mforns added a comment to T192819: Event Logging schemas for Wikipedia iOS app.

Yes, I'm aware that the length of the URL may be more than 2000 chars in some extreme cases (e.g. the user selects many languages). But I don't have other solution except putting it into another schema. Do you have any suggestion?

Jul 11 2018, 1:39 PM · Patch-For-Review, Product-Analytics, Wikipedia-iOS-App-Backlog
mforns added a comment to T199324: [Wikistats 2.0] No data appears by default on New Registered Users Detail page.

I can not reproduce this error, it might be a race condition.

Jul 11 2018, 12:49 PM · Analytics, Analytics-Wikistats

Jul 10 2018

mforns added a comment to T192819: Event Logging schemas for Wikipedia iOS app.

When working on T195269, I saw that a new field was added tho MobileWikiAppiOSUserHistory: feed_enabled_list. This field is a "2-level" nested object with arrays at its leaves; While theoretically this is supported by EL pipeline, we might see some issues. A couple comments on it:

  • As MobileWikiAppiOSUserHistory is already blacklisted for MySQL insertion, there will not be problems inserting events for this schema to MySQL and/or sanitizing these events in MySQL.
  • However, as this field can potentially become very long, it might contribute to the whole event overflowing the max URL length of aprox. 2000 chars. And in this case, the events will fail validation in the EL processors. I saw that the subfield names were shortened on purpose, so I assume you already are aware of this.
  • Fields with complex types are not supported in Druid, so this schema as is, will not be able to be fully imported to Druid (or turnilo).
  • I think the schema does not follow the json schema spec when defining the 'ena' and 'dis' sub-fields. I think the [ and ] are not supposed to be there, but I might be wrong.
Jul 10 2018, 3:14 PM · Patch-For-Review, Product-Analytics, Wikipedia-iOS-App-Backlog
mforns added a comment to T195269: Partially purge MobileWikiAppiOSUserHistory eventlogging schema.

Hi all,

Jul 10 2018, 2:53 PM · Patch-For-Review, Analytics-Kanban, Product-Analytics, Analytics
mforns created T199230: [EL sanitization] Make WhitelistSanitization support arrays of structs, maps or other arrays.
Jul 10 2018, 2:19 PM · Analytics

Jul 9 2018

mforns created T199148: Consider changing EventLogging to encode events using base64 instead of uriEncode.
Jul 9 2018, 8:22 PM · Analytics

Jul 6 2018

mforns set the point value for T195269: Partially purge MobileWikiAppiOSUserHistory eventlogging schema to 8.
Jul 6 2018, 4:06 PM · Patch-For-Review, Analytics-Kanban, Product-Analytics, Analytics
mforns changed the point value for T193176: [EL sanitization] Productionize EventLoggingSanitization.scala from 8 to 34.
Jul 6 2018, 4:06 PM · Patch-For-Review, Analytics-Kanban, Analytics
mforns added a comment to T192416: Improvements to Wikistats2 chart popups.
  • have the popup be the same component for all charts, that receives the data.
Jul 6 2018, 2:23 PM · Patch-For-Review, Analytics-Kanban, Analytics-Wikistats, Analytics
mforns added a comment to T198867: Improve Wikistats2 map zoom.

if the first problem "diagonal zoom" takes a lot of time to solve, don't bother

Jul 6 2018, 2:14 PM · Patch-For-Review, Analytics-Kanban, Analytics-Wikistats, Analytics
mforns added a comment to T183184: Make the colors used the line charts in Wikistats 2 more easy to recognize..
  • keep 3 colors designed for sections: reading, contributing, content (we can use different shades if it looks better)
  • remove black border from line charts
  • maybe thicken the lines
Jul 6 2018, 2:11 PM · Patch-For-Review, Analytics-Kanban, Analytics-Wikistats, Analytics

Jul 5 2018

mforns added a project to T198867: Improve Wikistats2 map zoom: Analytics-Wikistats.
Jul 5 2018, 2:42 PM · Patch-For-Review, Analytics-Kanban, Analytics-Wikistats, Analytics
mforns created T198867: Improve Wikistats2 map zoom.
Jul 5 2018, 2:42 PM · Patch-For-Review, Analytics-Kanban, Analytics-Wikistats, Analytics
mforns renamed T192416: Improvements to Wikistats2 chart popups from When cursor is out of graph overlay should not display to Improvements to Wikistats2 chart popups.
Jul 5 2018, 2:40 PM · Patch-For-Review, Analytics-Kanban, Analytics-Wikistats, Analytics
mforns added a comment to T183184: Make the colors used the line charts in Wikistats 2 more easy to recognize..

We could include here also changing the colors of the bar charts, because some of the colors currently used are too strong.

Jul 5 2018, 2:28 PM · Patch-For-Review, Analytics-Kanban, Analytics-Wikistats, Analytics
mforns added a comment to T192416: Improvements to Wikistats2 chart popups.

This happens in both bar-chart and line-chart.

Jul 5 2018, 2:20 PM · Patch-For-Review, Analytics-Kanban, Analytics-Wikistats, Analytics
mforns closed T189197: Wikistats2 line chart and map displacement bugs in Chrome+Ubuntu as Resolved.

This problem was solved by another task already.

Jul 5 2018, 2:17 PM · Analytics, Analytics-Wikistats

Jul 3 2018

mforns updated the task description for T198766: Deploy refinery to eventlogging hosts.
Jul 3 2018, 9:29 PM · Patch-For-Review, Analytics-Kanban, User-Elukey, Analytics
mforns created T198766: Deploy refinery to eventlogging hosts.
Jul 3 2018, 9:27 PM · Patch-For-Review, Analytics-Kanban, User-Elukey, Analytics
sahil505 awarded T198630: [Wikistats2] Broken down data with different time ranges for each line (or column set) breaks the chart a Like token.
Jul 3 2018, 3:59 PM · Analytics-Wikistats, Patch-For-Review, Analytics
mforns added a comment to T195269: Partially purge MobileWikiAppiOSUserHistory eventlogging schema.

For this particular case, let's not whitelist the os_minor field for now. We released the new version about a week ago and I need to verify that we are collecting data from users as expected. After that, I will run another analysis using the data from this table and check the bucket size to see how small it is.

Jul 3 2018, 1:55 PM · Patch-For-Review, Analytics-Kanban, Product-Analytics, Analytics

Jul 2 2018

mforns created T198630: [Wikistats2] Broken down data with different time ranges for each line (or column set) breaks the chart.
Jul 2 2018, 3:47 PM · Analytics-Wikistats, Patch-For-Review, Analytics

Jun 29 2018

mforns added a comment to T195269: Partially purge MobileWikiAppiOSUserHistory eventlogging schema.

Hi @chelsyx!
Also forgive me for the late response, your thorough report gave me a lot to think about.

Jun 29 2018, 8:24 PM · Patch-For-Review, Analytics-Kanban, Product-Analytics, Analytics
mforns created T198510: [Wikistats2] Negative numbers in chart axis are not abbreviated.
Jun 29 2018, 7:15 PM · Analytics-Wikistats, Patch-For-Review, Analytics-Kanban, Analytics

Jun 27 2018

mforns added a comment to T190856: Archive old geowiki data (editors per country) and make it easily available at WMF.

Oh yea, I meant the tiny inconsistency created by the normalization rounding. I added a one-liner to the docs:
https://wikitech.wikimedia.org/w/index.php?title=Analytics%2FSystems%2FGeoeditors&type=revision&diff=1795553&oldid=1793682

Jun 27 2018, 4:47 PM · Analytics-Kanban, Analytics
mforns added a comment to T190856: Archive old geowiki data (editors per country) and make it easily available at WMF.

Yes, it's better for the map component in Superset to have standard country names, and the names in the original dataset were far from standard (e.g. for Curaçao I found three variations: Curaçao, Curacao and Cura?ao).

Jun 27 2018, 12:29 PM · Analytics-Kanban, Analytics

Jun 26 2018

mforns created T198258: [Wikistats2] Bug in Top Viewed Articles since bookmark routing changes.
Jun 26 2018, 8:22 PM · Analytics
mforns added a comment to T195269: Partially purge MobileWikiAppiOSUserHistory eventlogging schema.

Sorry, this change was not meant to be linked to this task... please ignore.

Jun 26 2018, 2:40 PM · Patch-For-Review, Analytics-Kanban, Product-Analytics, Analytics

Jun 25 2018

mforns moved T197482: Shortcut icon is not showing from In Code Review to Ready to Deploy on the Analytics-Kanban board.
Jun 25 2018, 2:17 PM · Patch-For-Review, Analytics-Kanban, Analytics, Analytics-Wikistats

Jun 22 2018

mforns added a comment to T197897: Review code for fetching Google Search Console data.

Hey @mpopov, sure I can try.

Jun 22 2018, 6:44 PM · Product-Analytics, SEO

Jun 21 2018

mforns added a comment to T196904: Some VirtualPageView are too long and fail EventLogging processing.

I'm still a little cautious about adding additional logic to the client even a simple one. Am happy to be more aggressive with the cut off e.g. 1000 characters and then see what happens.

Jun 21 2018, 9:35 PM · Readers-Web-Backlog (Readers-Web-Kanbanana-Board-2018-19-Q1), User-Ryasmeen, Readers-Web-Kanbanana-Board-Old, Page-Previews, Analytics, Analytics-EventLogging
mforns added a comment to T197897: Review code for fetching Google Search Console data.

Hi @mpopov :]
Did you mean to tag this task with Product-Analytics or with Analytics?
Thanks!

Jun 21 2018, 8:38 PM · Product-Analytics, SEO