Page MenuHomePhabricator

SNowick_WMF (Shay)
User

Today

  • Clear sailing ahead.

Tomorrow

  • Clear sailing ahead.

Tuesday

  • Clear sailing ahead.

User Details

User Since
Dec 16 2019, 7:20 PM (44 w, 5 d)
Availability
Available
LDAP User
Unknown
MediaWiki User
SNowick (WMF) [ Global Accounts ]

Recent Activity

Thu, Oct 22

SNowick_WMF added a comment to T266056: Trend analysis for search by source and decline in start events.

@schoenbaechler Hi Robin - I was able to find out why counts for results are higher than start in the MobileWikiAppSearch schema. For every start there are 2 searches initiated: one for title and and one for full text, so when results are returned they are automatically double the start events. Additionally when a user scrolls to see more results that counts as a result event as well, and this can generate multiple counts while scrolling. When we move to the MEP platform we may consider adding a singular result_returned event separate from these counts so that we are able to do a 1:1 start vs result event comparison, as it stands now the results count doesn't allow for that.

Thu, Oct 22, 9:43 PM · Wikipedia-Android-App-Backlog (Android-app-release-v2.7.33x-R-Rosgulla)
SNowick_WMF triaged T266047: Instrumentation and Analytics for usage of font theme option as Low priority.
Thu, Oct 22, 8:30 PM · Product-Analytics (Kanban), Wikipedia-Android-App-Backlog
SNowick_WMF moved T266047: Instrumentation and Analytics for usage of font theme option from Triage to Kanban on the Product-Analytics board.
Thu, Oct 22, 8:29 PM · Product-Analytics (Kanban), Wikipedia-Android-App-Backlog
SNowick_WMF added a comment to T246402: Android Editor Retention stats by task - manual and automated - title descriptions vs image captions.

@schoenbaechler We do have a schema to track user exposure to CTAs and secondary CTAs https://phabricator.wikimedia.org/T258080 but that has been de-prioritized while we re-org the analytics workflow for Android. Agree with the assumption that CTAs are motivating returning editors.

Thu, Oct 22, 7:58 PM · Wikipedia-Android-App-Backlog (Android-app-release-v2.7.33x-R-Rosgulla), Product-Analytics (Kanban)
SNowick_WMF added a comment to T266047: Instrumentation and Analytics for usage of font theme option.

@Dbrant yes, fixed on schema MobileWikiAppAppearanceSettings

Thu, Oct 22, 6:46 PM · Product-Analytics (Kanban), Wikipedia-Android-App-Backlog
SNowick_WMF closed T246402: Android Editor Retention stats by task - manual and automated - title descriptions vs image captions, a subtask of T245560: Revert rate user profiling, as Resolved.
Thu, Oct 22, 1:48 AM · Product-Analytics (Kanban)
SNowick_WMF closed T246402: Android Editor Retention stats by task - manual and automated - title descriptions vs image captions as Resolved.
Thu, Oct 22, 1:48 AM · Wikipedia-Android-App-Backlog (Android-app-release-v2.7.33x-R-Rosgulla), Product-Analytics (Kanban)
SNowick_WMF added a comment to T246402: Android Editor Retention stats by task - manual and automated - title descriptions vs image captions.

An analysis of editor activity between 2020-08-01 and 2020-09-31 showed the following editor retention percentages.
(An editor counts as retained if they were active on or after a specific day cohort, these are averages across all active editors.)

Thu, Oct 22, 1:42 AM · Wikipedia-Android-App-Backlog (Android-app-release-v2.7.33x-R-Rosgulla), Product-Analytics (Kanban)

Wed, Oct 21

SNowick_WMF added a comment to T264057: Post-exposure survey for Article as a Living Document.

@Tsevener For 1. I am not sure, will follow up with @JMinor and get a definitive answer. Let's assume yes and if not we can take out the value from the URL

  1. Agree we should track both of these values
Wed, Oct 21, 8:10 PM · iOS-app-Bonefish-On-A-Balloon, Wikipedia-iOS-App-Backlog
SNowick_WMF added a comment to T266047: Instrumentation and Analytics for usage of font theme option.

@cooltey Thanks, I've updated the schema https://meta.wikimedia.org/wiki/Schema:MobileWikiAppAppearanceSettings. Please let me know when we will be ready to QA the data.

Wed, Oct 21, 7:19 PM · Product-Analytics (Kanban), Wikipedia-Android-App-Backlog
SNowick_WMF added a comment to T262941: Article as a Living Doc - Add A/B testing to the app.

@Tsevener Those test group names are fine, if you want to shorten them we could use LivingDoc_Test and LivingDoc_Control but if length doesn't matter let's go with what you prefer.

Wed, Oct 21, 6:58 PM · iOS-app-Bonefish-On-A-Balloon, Wikipedia-iOS-App-Backlog

Tue, Oct 20

SNowick_WMF created T266047: Instrumentation and Analytics for usage of font theme option.
Tue, Oct 20, 4:34 PM · Product-Analytics (Kanban), Wikipedia-Android-App-Backlog
SNowick_WMF removed a project from T258081: Analytics for adding image tags from Commons filepage: Product-Analytics.
Tue, Oct 20, 4:27 PM · Wikipedia-Android-App-Backlog (Android-app-release-v2.7.33x-R-Rosgulla)
SNowick_WMF added a comment to T254142: Support adding image tags from Commons filepage.

Since we don't have a distinct source for image tags from Commons filepage we will count these new image tags with the regular image tags as Suggested Edit actions. Closing ticket.

Tue, Oct 20, 4:26 PM · Wikipedia-Android-App-Backlog (Android-app-release-v2.7.32x-Q-Qurabiya)

Mon, Oct 19

SNowick_WMF added a comment to T258079: Analytics for enhanced submission warnings.

As of 2020-10-19 we have a month's worth of users in both test groups, ~7000 users total. Can start analysis on this depending on priority.

Mon, Oct 19, 10:56 PM · Wikipedia-Android-App-Backlog (Android-app-release-v2.7.33x-R-Rosgulla), Product-Analytics
SNowick_WMF closed T240627: Suggested Edits in Superset/Turnilo as Resolved.

Dashboards on Superset:
SuggestedEditsEditingImpact

Mon, Oct 19, 4:54 PM · Product-Analytics
SNowick_WMF moved T253982: Analytics for account creation via Suggested edits from Doing to Needs Review on the Product-Analytics (Kanban) board.
Mon, Oct 19, 4:05 PM · Wikipedia-Android-App-Backlog (Android-app-release-v2.7.33x-R-Rosgulla), Product-Analytics (Kanban)

Fri, Oct 16

SNowick_WMF added a comment to T264193: Investigate differences in counts between legacy & modern-v1 Edit History Compare events.

More findings, I checked the rest of the iOS data schemas for events and records for the 12 app_install_ids that show up on Modern and not Legacy for thank_try and found that only 4 of the 12 app_install_ids appear in other tables. I've added those ids/events to the spreadsheet but it looks like most of these users were not getting tracked on other tables and none of them show up in mobilewikiappdailystats

Fri, Oct 16, 10:58 PM · Product-Analytics (Kanban), iOS-app-Bonefish-On-A-Balloon, iOS-app-feature-Analytics, Product-Infrastructure-Data, Wikipedia-iOS-App-Backlog

Thu, Oct 15

SNowick_WMF added a comment to T264193: Investigate differences in counts between legacy & modern-v1 Edit History Compare events.

More research for all to look through. thank_try and compare1. The first sheet has results.

Thu, Oct 15, 12:49 AM · Product-Analytics (Kanban), iOS-app-Bonefish-On-A-Balloon, iOS-app-feature-Analytics, Product-Infrastructure-Data, Wikipedia-iOS-App-Backlog

Wed, Oct 14

SNowick_WMF added a comment to T264193: Investigate differences in counts between legacy & modern-v1 Edit History Compare events.

@Tsevener to clarify MEP meta.dt is equal to Legacy dt, MEP client_dt is equal to Legacy event.event_dt (on Android it's event.client_dt)

Wed, Oct 14, 8:06 PM · Product-Analytics (Kanban), iOS-app-Bonefish-On-A-Balloon, iOS-app-feature-Analytics, Product-Infrastructure-Data, Wikipedia-iOS-App-Backlog

Tue, Oct 13

SNowick_WMF moved T241272: Initial plan for measurement and variant testing support for editing awareness experiments from Blocked to Doing on the Product-Analytics (Kanban) board.
Tue, Oct 13, 5:07 PM · Product-Analytics (Kanban), Wikipedia-iOS-App-Backlog
SNowick_WMF moved T253982: Analytics for account creation via Suggested edits from Blocked to Doing on the Product-Analytics (Kanban) board.
Tue, Oct 13, 5:06 PM · Wikipedia-Android-App-Backlog (Android-app-release-v2.7.33x-R-Rosgulla), Product-Analytics (Kanban)
SNowick_WMF moved T241272: Initial plan for measurement and variant testing support for editing awareness experiments from Needs Review to Blocked on the Product-Analytics (Kanban) board.
Tue, Oct 13, 5:04 PM · Product-Analytics (Kanban), Wikipedia-iOS-App-Backlog
SNowick_WMF moved T262616: Event logging interactions with Living Doc from Needs Review to Doing on the Product-Analytics (Kanban) board.
Tue, Oct 13, 5:03 PM · iOS-app-Bonefish-On-A-Balloon, Product-Analytics (Kanban), Epic, Wikipedia-iOS-App-Backlog

Mon, Oct 12

SNowick_WMF added a comment to T264193: Investigate differences in counts between legacy & modern-v1 Edit History Compare events.

I made spreadsheets with events for 2 actions show_history and compare1 on both Legacy and Modern tables. First page of sheets is data from Modern and the most left column with dt from Legacy to compare events by initial timestamp. Rows with blank legacy dt field are events that only appear in Modern, rows with blank meta.dt field are events that only appear in Legacy.

Mon, Oct 12, 11:37 PM · Product-Analytics (Kanban), iOS-app-Bonefish-On-A-Balloon, iOS-app-feature-Analytics, Product-Infrastructure-Data, Wikipedia-iOS-App-Backlog

Fri, Oct 9

SNowick_WMF added a comment to T264193: Investigate differences in counts between legacy & modern-v1 Edit History Compare events.

... preparing some analysis that I will go over with @Tsevener and @mpopov when it's ready

@SNowick_WMF mind if I join in that?

Fri, Oct 9, 10:22 PM · Product-Analytics (Kanban), iOS-app-Bonefish-On-A-Balloon, iOS-app-feature-Analytics, Product-Infrastructure-Data, Wikipedia-iOS-App-Backlog
SNowick_WMF added a comment to T264193: Investigate differences in counts between legacy & modern-v1 Edit History Compare events.

For the events where we have anomalies I am seeing counts off on both tables, there is still not a consistent pattern I am seeing but I am preparing some analysis that I will go over with @Tsevener and @mpopov when it's ready. I also ran the validation query again and we still are seeing higher counts on legacy table.

Fri, Oct 9, 10:12 PM · Product-Analytics (Kanban), iOS-app-Bonefish-On-A-Balloon, iOS-app-feature-Analytics, Product-Infrastructure-Data, Wikipedia-iOS-App-Backlog
SNowick_WMF added a comment to T264057: Post-exposure survey for Article as a Living Document.

List of pages for survey.

Fri, Oct 9, 9:55 PM · iOS-app-Bonefish-On-A-Balloon, Wikipedia-iOS-App-Backlog

Tue, Oct 6

SNowick_WMF added a comment to T264057: Post-exposure survey for Article as a Living Document.

Article List Updated

Tue, Oct 6, 6:10 PM · iOS-app-Bonefish-On-A-Balloon, Wikipedia-iOS-App-Backlog
SNowick_WMF reassigned T253982: Analytics for account creation via Suggested edits from SNowick_WMF to Dbrant.
Tue, Oct 6, 5:10 PM · Wikipedia-Android-App-Backlog (Android-app-release-v2.7.33x-R-Rosgulla), Product-Analytics (Kanban)
SNowick_WMF moved T253982: Analytics for account creation via Suggested edits from Doing to Blocked on the Product-Analytics (Kanban) board.
Tue, Oct 6, 5:09 PM · Wikipedia-Android-App-Backlog (Android-app-release-v2.7.33x-R-Rosgulla), Product-Analytics (Kanban)

Mon, Oct 5

SNowick_WMF added a comment to T264210: [REQUEST] Get page creation time data and relationship between quality and time of deletion.

Sam -the closest I have gotten to finding any info on the deleted pages was using logging.log_id to query archive and revision using archive.ar_page_id = logging.log_id and logging.log_id=revision.rev_page. (I added log_id to your query and made a spreadsheet with results here.

Mon, Oct 5, 9:48 PM · Product-Analytics (Kanban)
SNowick_WMF added a comment to T264057: Post-exposure survey for Article as a Living Document.

@Tsevener Just to clarify, by modal do you mean the survey itself? So adding survey_click and survey_cancel?

Mon, Oct 5, 5:04 PM · iOS-app-Bonefish-On-A-Balloon, Wikipedia-iOS-App-Backlog

Fri, Oct 2

SNowick_WMF updated the task description for T253982: Analytics for account creation via Suggested edits.
Fri, Oct 2, 11:02 PM · Wikipedia-Android-App-Backlog (Android-app-release-v2.7.33x-R-Rosgulla), Product-Analytics (Kanban)
SNowick_WMF claimed T264193: Investigate differences in counts between legacy & modern-v1 Edit History Compare events.
Fri, Oct 2, 10:36 PM · Product-Analytics (Kanban), iOS-app-Bonefish-On-A-Balloon, iOS-app-feature-Analytics, Product-Infrastructure-Data, Wikipedia-iOS-App-Backlog
SNowick_WMF added a comment to T263051: Migration QA for MEP iOS schema .

Additional data QA process info here: https://phabricator.wikimedia.org/T264193

Fri, Oct 2, 10:33 PM · Product-Analytics (Kanban), Wikipedia-iOS-App-Backlog

Thu, Oct 1

SNowick_WMF added a comment to T264193: Investigate differences in counts between legacy & modern-v1 Edit History Compare events.

I'll pull the data and go through it to see if we can verify any of these possible scenarios, stay tuned.

Thu, Oct 1, 9:36 PM · Product-Analytics (Kanban), iOS-app-Bonefish-On-A-Balloon, iOS-app-feature-Analytics, Product-Infrastructure-Data, Wikipedia-iOS-App-Backlog

Wed, Sep 30

SNowick_WMF added a comment to T260382: Migrate MobileWikiAppiOSEditHistoryCompare schema to MEP.

@mpopov I think we are ok without the extra edit subdirectory for now, we have a few schemas that combine editing with other data I wouldn't want to get lost. Let's go with /analytics/mobile_app/ios/edit_history_compare

Wed, Sep 30, 5:03 PM · Product-Infrastructure-Data, Product-Analytics (Kanban), iOS-app-v6.7-Bonefish-On-A-Bus, Wikipedia-iOS-App-Backlog
Samwalton9 awarded T264210: [REQUEST] Get page creation time data and relationship between quality and time of deletion a Yellow Medal token.
Wed, Sep 30, 4:39 PM · Product-Analytics (Kanban)
SNowick_WMF moved T264210: [REQUEST] Get page creation time data and relationship between quality and time of deletion from Triage to Kanban on the Product-Analytics board.
Wed, Sep 30, 4:16 PM · Product-Analytics (Kanban)
SNowick_WMF created T264210: [REQUEST] Get page creation time data and relationship between quality and time of deletion.
Wed, Sep 30, 4:15 PM · Product-Analytics (Kanban)
SNowick_WMF added a comment to T253982: Analytics for account creation via Suggested edits.

@Charlotte @Dbrant @cooltey
Looking at total accounts w/ action = success in the MobileWikiAppCreateAccount table I'm seeing a 39% drop in total accounts post 2020-08-05. Did something change with the counting mechanism. We went from and avg. 1400 success daily to avg. 842 daily. Charts Here

Wed, Sep 30, 1:42 AM · Wikipedia-Android-App-Backlog (Android-app-release-v2.7.33x-R-Rosgulla), Product-Analytics (Kanban)

Tue, Sep 29

SNowick_WMF moved T257277: Re-define what constitutes a mobile pageview from Needs Investigation to Backlog on the Product-Analytics board.
Tue, Sep 29, 5:20 PM · Analytics-Radar, Product-Infrastructure-Team-Backlog, Epic, Product-Analytics
SNowick_WMF moved T249970: Measure Reward Interstitials from Doing to Next 2 weeks on the Product-Analytics (Kanban) board.
Tue, Sep 29, 5:06 PM · Wikipedia-Android-App-Backlog (Android-app-release-v2.7.33x-R-Rosgulla), Product-Analytics (Kanban), Android-app-feature-Description-Editing
SNowick_WMF claimed T258080: Analytics for secondary SE CTAs.
Tue, Sep 29, 5:04 PM · Product-Analytics (Kanban), Wikipedia-Android-App-Backlog (Android-app-release-v2.7.32x-Q-Qurabiya)

Mon, Sep 28

SNowick_WMF added a comment to T258080: Analytics for secondary SE CTAs.

Confirming the latest version we are seeing in the mobilewikiappsuggestededitsfeed table is 2.7.50332-beta-2020-09-28

Mon, Sep 28, 11:49 PM · Product-Analytics (Kanban), Wikipedia-Android-App-Backlog (Android-app-release-v2.7.32x-Q-Qurabiya)
SNowick_WMF raised the priority of T184096: Editor analytics report for Android app (language) from Medium to High.
Mon, Sep 28, 8:31 PM · Product-Analytics (Kanban), Wikipedia-Android-App-Backlog (Android-app-release-v2.7.32x-Q-Qurabiya)
SNowick_WMF moved T184096: Editor analytics report for Android app (language) from Next 2 weeks to Needs Review on the Product-Analytics (Kanban) board.
Mon, Sep 28, 8:31 PM · Product-Analytics (Kanban), Wikipedia-Android-App-Backlog (Android-app-release-v2.7.32x-Q-Qurabiya)
SNowick_WMF added a comment to T184096: Editor analytics report for Android app (language).

Was waiting for image tag data but since they are Wikidata items and are translated by Wikidata the entry language is not tracked. Dashboard ends at last month since we use mediawiki_history to collect this aggregated data.

Mon, Sep 28, 8:31 PM · Product-Analytics (Kanban), Wikipedia-Android-App-Backlog (Android-app-release-v2.7.32x-Q-Qurabiya)
SNowick_WMF updated the task description for T184096: Editor analytics report for Android app (language).
Mon, Sep 28, 8:20 PM · Product-Analytics (Kanban), Wikipedia-Android-App-Backlog (Android-app-release-v2.7.32x-Q-Qurabiya)
SNowick_WMF updated the task description for T184096: Editor analytics report for Android app (language).
Mon, Sep 28, 8:16 PM · Product-Analytics (Kanban), Wikipedia-Android-App-Backlog (Android-app-release-v2.7.32x-Q-Qurabiya)
SNowick_WMF updated the task description for T184096: Editor analytics report for Android app (language).
Mon, Sep 28, 8:15 PM · Product-Analytics (Kanban), Wikipedia-Android-App-Backlog (Android-app-release-v2.7.32x-Q-Qurabiya)
SNowick_WMF lowered the priority of T246402: Android Editor Retention stats by task - manual and automated - title descriptions vs image captions from Low to Lowest.
Mon, Sep 28, 8:15 PM · Wikipedia-Android-App-Backlog (Android-app-release-v2.7.33x-R-Rosgulla), Product-Analytics (Kanban)
SNowick_WMF raised the priority of T253982: Analytics for account creation via Suggested edits from Low to High.
Mon, Sep 28, 8:15 PM · Wikipedia-Android-App-Backlog (Android-app-release-v2.7.33x-R-Rosgulla), Product-Analytics (Kanban)
SNowick_WMF moved T253982: Analytics for account creation via Suggested edits from Next 2 weeks to Doing on the Product-Analytics (Kanban) board.
Mon, Sep 28, 8:14 PM · Wikipedia-Android-App-Backlog (Android-app-release-v2.7.33x-R-Rosgulla), Product-Analytics (Kanban)
SNowick_WMF raised the priority of T254779: Usage and retention report for SE v5 - Contributions List from Medium to High.
Mon, Sep 28, 8:14 PM · Wikipedia-Android-App-Backlog (Android-app-release-v2.7.32x-Q-Qurabiya), Product-Analytics (Kanban)
SNowick_WMF moved T254779: Usage and retention report for SE v5 - Contributions List from Doing to Needs Review on the Product-Analytics (Kanban) board.
Mon, Sep 28, 8:14 PM · Wikipedia-Android-App-Backlog (Android-app-release-v2.7.32x-Q-Qurabiya), Product-Analytics (Kanban)
SNowick_WMF added a comment to T254779: Usage and retention report for SE v5 - Contributions List.

Dashboard is here, calculations for retention and SE interactions were done off Superset.

Mon, Sep 28, 8:13 PM · Wikipedia-Android-App-Backlog (Android-app-release-v2.7.32x-Q-Qurabiya), Product-Analytics (Kanban)

Fri, Sep 25

SNowick_WMF closed T262426: [Shay] Review "Schema Migration Audit" document, a subtask of T261794: [REQUEST] Event Schema Audit Review, as Resolved.
Fri, Sep 25, 6:49 PM · Product-Analytics (Kanban), Better Use Of Data, Product-Infrastructure-Data
SNowick_WMF closed T262426: [Shay] Review "Schema Migration Audit" document as Resolved.
Fri, Sep 25, 6:49 PM · Product-Analytics (Kanban)
SNowick_WMF updated the task description for T261794: [REQUEST] Event Schema Audit Review.
Fri, Sep 25, 6:48 PM · Product-Analytics (Kanban), Better Use Of Data, Product-Infrastructure-Data

Sep 22 2020

SNowick_WMF added a comment to T262616: Event logging interactions with Living Doc.

Met to discuss flow and metrics. Added back the card_editor, card_discuss, card_change and card_more metrics, added card_multiple for multiple elements shown on card.

Sep 22 2020, 10:41 PM · iOS-app-Bonefish-On-A-Balloon, Product-Analytics (Kanban), Epic, Wikipedia-iOS-App-Backlog

Sep 21 2020

SNowick_WMF added a comment to T262616: Event logging interactions with Living Doc.

@cmadeo just to confirm - we want to consolidate all the links on the card (card_editor, card_discuss, card_change and card_more) to just be one metric (user clicks) - I will update docs, using card_click for metric name. Just want to be sure I'm not missing any detail we might want to keep measured separately.

Sep 21 2020, 5:14 PM · iOS-app-Bonefish-On-A-Balloon, Product-Analytics (Kanban), Epic, Wikipedia-iOS-App-Backlog

Sep 14 2020

SNowick_WMF removed a project from T258111: [BUG] Investigate Drop in User Count and Activity for Image Tags: Product-Analytics (Kanban).
Sep 14 2020, 4:47 PM · MW-1.36-notes (1.36.0-wmf.1; 2020-07-21), Wikipedia-Android-App-Backlog (Android-app-release-v2.7.32x-Q-Qurabiya), Android-app-Bugs

Sep 10 2020

SNowick_WMF added a comment to T254142: Support adding image tags from Commons filepage.

We will need the names of CTA location/prompt when they are ready, @Dbrant will add them to the analytics for image tags in table MobileWikiAppEdit. Tags will be modified from '#suggestededit-imgtag-custom 1.0' to '#suggestededit-imgtag-custom_$SOURCE 1.0'

Sep 10 2020, 11:26 PM · Wikipedia-Android-App-Backlog (Android-app-release-v2.7.32x-Q-Qurabiya)
SNowick_WMF moved T258111: [BUG] Investigate Drop in User Count and Activity for Image Tags from Doing to Needs Review on the Product-Analytics (Kanban) board.
Sep 10 2020, 9:37 PM · MW-1.36-notes (1.36.0-wmf.1; 2020-07-21), Wikipedia-Android-App-Backlog (Android-app-release-v2.7.32x-Q-Qurabiya), Android-app-Bugs
SNowick_WMF triaged T262616: Event logging interactions with Living Doc as Medium priority.
Sep 10 2020, 9:37 PM · iOS-app-Bonefish-On-A-Balloon, Product-Analytics (Kanban), Epic, Wikipedia-iOS-App-Backlog
SNowick_WMF moved T262616: Event logging interactions with Living Doc from Next 2 weeks to Needs Review on the Product-Analytics (Kanban) board.
Sep 10 2020, 9:36 PM · iOS-app-Bonefish-On-A-Balloon, Product-Analytics (Kanban), Epic, Wikipedia-iOS-App-Backlog
SNowick_WMF moved T262616: Event logging interactions with Living Doc from Triage to Kanban on the Product-Analytics board.
Sep 10 2020, 9:36 PM · iOS-app-Bonefish-On-A-Balloon, Product-Analytics (Kanban), Epic, Wikipedia-iOS-App-Backlog
SNowick_WMF added a project to T262616: Event logging interactions with Living Doc: Product-Analytics.
Sep 10 2020, 9:35 PM · iOS-app-Bonefish-On-A-Balloon, Product-Analytics (Kanban), Epic, Wikipedia-iOS-App-Backlog
SNowick_WMF updated the task description for T262616: Event logging interactions with Living Doc.
Sep 10 2020, 9:28 PM · iOS-app-Bonefish-On-A-Balloon, Product-Analytics (Kanban), Epic, Wikipedia-iOS-App-Backlog
SNowick_WMF created T262616: Event logging interactions with Living Doc.
Sep 10 2020, 9:28 PM · iOS-app-Bonefish-On-A-Balloon, Product-Analytics (Kanban), Epic, Wikipedia-iOS-App-Backlog
SNowick_WMF added a comment to T258111: [BUG] Investigate Drop in User Count and Activity for Image Tags.

@Charlotte @Dbrant Changed chart to show total count rather than split by user type (which may not be accurate anyway and not relevant for this task.)

Sep 10 2020, 2:16 PM · MW-1.36-notes (1.36.0-wmf.1; 2020-07-21), Wikipedia-Android-App-Backlog (Android-app-release-v2.7.32x-Q-Qurabiya), Android-app-Bugs
Dbrant awarded T258111: [BUG] Investigate Drop in User Count and Activity for Image Tags a Mountain of Wealth token.
Sep 10 2020, 12:45 PM · MW-1.36-notes (1.36.0-wmf.1; 2020-07-21), Wikipedia-Android-App-Backlog (Android-app-release-v2.7.32x-Q-Qurabiya), Android-app-Bugs
SNowick_WMF added a comment to T258111: [BUG] Investigate Drop in User Count and Activity for Image Tags.

This is resolved, data is on Dashboard Android Image Tags

Sep 10 2020, 1:16 AM · MW-1.36-notes (1.36.0-wmf.1; 2020-07-21), Wikipedia-Android-App-Backlog (Android-app-release-v2.7.32x-Q-Qurabiya), Android-app-Bugs

Sep 1 2020

SNowick_WMF closed T261015: [REQUEST] Number of editors across all Wikipedias, Editors across all projects per month as Resolved.
Sep 1 2020, 10:18 PM · Product-Analytics (Kanban)
SNowick_WMF added a comment to T261015: [REQUEST] Number of editors across all Wikipedias, Editors across all projects per month.

Data is updated on Registered editors and Wikipedia editors by month spreadsheet with corrected editor counts. Note the counts that changed were the Wikipedia editors, the average monthly Wikipedia editor count for the last 12 months is 285798. The counts for all project editors have not changed.

Sep 1 2020, 9:35 PM · Product-Analytics (Kanban)
SNowick_WMF closed T256804: Identify next steps for dealing with missing mobile app pageview counts as Resolved.

Affected Builds:
Android Build 2.7.50318-r-2020-05-18
iOS Build 6.6.1 1743 2020-06-05

Sep 1 2020, 7:31 PM · Analytics-Radar, Product-Analytics (Kanban)
SNowick_WMF closed T256804: Identify next steps for dealing with missing mobile app pageview counts, a subtask of T256508: API pageview counts for 'Mobile app' are incorrect since switch to mobile-html , as Resolved.
Sep 1 2020, 7:31 PM · Epic, Product-Analytics
SNowick_WMF added a comment to T258535: Annotate pageview data to alert users that previously included mobile app pageview data is NOT included in refined pageview datasets.

Affected Builds:
Android Build 2.7.50318-r-2020-05-18
iOS Build 6.6.1 1743 2020-06-05

Sep 1 2020, 7:30 PM · Research, Analytics, Product-Analytics
SNowick_WMF updated the task description for T258535: Annotate pageview data to alert users that previously included mobile app pageview data is NOT included in refined pageview datasets.
Sep 1 2020, 7:15 PM · Research, Analytics, Product-Analytics
SNowick_WMF added a comment to T261015: [REQUEST] Number of editors across all Wikipedias, Editors across all projects per month.

Hi @ASvitak I will re-run this query and let you know here when data is updated, thanks @nshahquinn-wmf for the info/assist.

Sep 1 2020, 5:57 PM · Product-Analytics (Kanban)
SNowick_WMF assigned T258111: [BUG] Investigate Drop in User Count and Activity for Image Tags to Dbrant.
Sep 1 2020, 5:06 PM · MW-1.36-notes (1.36.0-wmf.1; 2020-07-21), Wikipedia-Android-App-Backlog (Android-app-release-v2.7.32x-Q-Qurabiya), Android-app-Bugs

Aug 31 2020

SNowick_WMF added a comment to T261015: [REQUEST] Number of editors across all Wikipedias, Editors across all projects per month.

Hi @nshahquinn-wmf Presto query below. It does look like my percentages are higher than your past data, there might be something missing in how I differentiated all vs Wikipedia edits. I used wikis ending with regex wiki to get Wikipedia edits.

select
month,
count(*) as active_editors
from (
select
cast(month as date) as month,
user_name,
sum(edits) as all_edits,
max(bot_by_group) as bot_by_group,
cast(date_trunc('month',min(user_registration)) as date) as registration_month
from neilpquinn.editor_month
where
month > TIMESTAMP '2019-01-01 00:00:00.000' and
user_id != 0
AND regexp_like(wiki, 'wiki$')
group by month, user_name
) global_edits
where
not bot_by_group and
not regexp_like(user_name, 'bot\\b')
Aug 31 2020, 3:46 PM · Product-Analytics (Kanban)

Aug 27 2020

SNowick_WMF added a comment to T261261: [BUG] Presto Error: parquet file declares column as wrong type for wmf..mediawiki_history.

Looks good, queries are working now, thanks!

Aug 27 2020, 4:51 PM · Patch-For-Review, Analytics-Kanban, Analytics
SNowick_WMF updated subscribers of T258111: [BUG] Investigate Drop in User Count and Activity for Image Tags.

@Dbrant @Charlotte I am not seeing counts back to expected values, not seeing event.source:#suggestededit-imgtag-custom 1.0 as result when querying using latest app version.

Aug 27 2020, 4:49 PM · MW-1.36-notes (1.36.0-wmf.1; 2020-07-21), Wikipedia-Android-App-Backlog (Android-app-release-v2.7.32x-Q-Qurabiya), Android-app-Bugs

Aug 26 2020

SNowick_WMF renamed T261261: [BUG] Presto Error: parquet file declares column as wrong type for wmf..mediawiki_history from Presto Error: parquet file declares column as wrong type for wmf..mediawiki_history to [BUG] Presto Error: parquet file declares column as wrong type for wmf..mediawiki_history.
Aug 26 2020, 1:57 AM · Patch-For-Review, Analytics-Kanban, Analytics
SNowick_WMF created T261261: [BUG] Presto Error: parquet file declares column as wrong type for wmf..mediawiki_history.
Aug 26 2020, 1:57 AM · Patch-For-Review, Analytics-Kanban, Analytics

Aug 25 2020

SNowick_WMF claimed T258111: [BUG] Investigate Drop in User Count and Activity for Image Tags.
Aug 25 2020, 8:45 PM · MW-1.36-notes (1.36.0-wmf.1; 2020-07-21), Wikipedia-Android-App-Backlog (Android-app-release-v2.7.32x-Q-Qurabiya), Android-app-Bugs

Aug 21 2020

SNowick_WMF closed T261015: [REQUEST] Number of editors across all Wikipedias, Editors across all projects per month as Resolved.
Aug 21 2020, 9:58 PM · Product-Analytics (Kanban)
SNowick_WMF updated subscribers of T261015: [REQUEST] Number of editors across all Wikipedias, Editors across all projects per month.

Data collected using @nshahquinn-wmf's editor_month table, updated counts here.

Aug 21 2020, 9:58 PM · Product-Analytics (Kanban)
SNowick_WMF moved T261015: [REQUEST] Number of editors across all Wikipedias, Editors across all projects per month from Triage to Kanban on the Product-Analytics board.
Aug 21 2020, 8:09 PM · Product-Analytics (Kanban)
SNowick_WMF triaged T261015: [REQUEST] Number of editors across all Wikipedias, Editors across all projects per month as High priority.
Aug 21 2020, 8:05 PM · Product-Analytics (Kanban)

Aug 20 2020

SNowick_WMF updated the task description for T256508: API pageview counts for 'Mobile app' are incorrect since switch to mobile-html .
Aug 20 2020, 3:07 AM · Epic, Product-Analytics

Aug 19 2020

SNowick_WMF added a comment to T260332: Explore vs Home A/B test.

Thanks @Dbrant, should the event data for Explore and Home be in the MobileWikiAppNavMenu table? Not seeing any events for Home or Explore. I did a SELECT distinct(event.menuItem) FROM MobileWikiAppNavMenu query and got the following:

Aug 19 2020, 11:23 PM · Wikipedia-Android-App-Backlog (Android-app-release-v2.7.32x-Q-Qurabiya)
SNowick_WMF added a comment to T256804: Identify next steps for dealing with missing mobile app pageview counts.
  • Write incident report, stored in Product Analytics shared drive 'Data Incident Reports"
  • Documenting fix process in ticket (there were several different changes)
  • Noting dates and app versions that were affected - for future data knowledge, how do we exclude/include where data was missing. Where can we put those to make sure they aren't lost?
  • Estimating lost views and validating that fix is actually working (depends on new app version saturation) Estimated App Pageviews
  • Who else needs that estimated data? CChen: Key product metrics, which goes into quarterly deck, publish key metrics on Commons. Also CChen for Superset. @cchen has estimated pageview counts
Aug 19 2020, 11:05 PM · Analytics-Radar, Product-Analytics (Kanban)

Aug 12 2020

SNowick_WMF added a comment to T257941: Add SE feed link to "published" snackbar.

If the captions are finalized can we have a flow chart of user actions - where the user could potentially encounter and what happens for each possible action? It is difficult to write a schema without clear visualization of user flow.

Aug 12 2020, 8:40 PM · Wikipedia-Android-App-Backlog (Android-app-release-v2.7.32x-Q-Qurabiya)
SNowick_WMF closed T259747: Review identifiers schema fragment (Shay), a subtask of T259750: Review schema fragments (Shay), as Resolved.
Aug 12 2020, 7:09 PM · Product-Analytics
SNowick_WMF closed T259747: Review identifiers schema fragment (Shay) as Resolved.

This looks good to me. Signing off as approved.

Aug 12 2020, 7:09 PM · Product-Analytics (Kanban)
SNowick_WMF updated subscribers of T258079: Analytics for enhanced submission warnings.

Use an A/B test to see if these warnings reduce the revert rate and/or retention rate and editing volume. @Dbrant let's discuss analytics for this.

Aug 12 2020, 5:57 PM · Wikipedia-Android-App-Backlog (Android-app-release-v2.7.33x-R-Rosgulla), Product-Analytics