Page MenuHomePhabricator

Iflorez (Irene)
User

Projects

Today

  • Clear sailing ahead.

Tomorrow

  • Clear sailing ahead.

Wednesday

  • Clear sailing ahead.

User Details

User Since
May 14 2019, 10:44 PM (169 w, 5 d)
Availability
Available
LDAP User
Iflorez
MediaWiki User
IFlorez (WMF) [ Global Accounts ]

Recent Activity

Wed, Jul 27

Iflorez added a comment to T294458: REQUEST Africa data check.

In practice, it looks like 3-4% of contributors edit from within Africa. However, the best methods to count unique logged-in and IP editors currently allow for pulling data for the latest month only, which makes it hard to get a good snapshot of data over multiple months. Because of this limitation, I'm inclined to say that 3-5% monthly editors across all projects edit from within Africa, this covers variability of methods used to calculate the total and also covers fluctuations over time. The earlier calculation [9%] incorrectly included anonymous contributors in the numerator but not the denominator when calculating the proportion.

Wed, Jul 27, 5:32 PM · Product-Analytics (Kanban)

Mon, Jul 25

Iflorez updated subscribers of T230092: Data exploration capabilities in Superset and Turnilo for editing data at “editor” level.

FYI: @JAnstee_WMF and @CMacholan

Mon, Jul 25, 6:05 PM · Epic, Product-Analytics

Fri, Jul 22

Iflorez updated subscribers of T294458: REQUEST Africa data check.

I discussed with @nshahquinn-wmf the benefits of the following language:
Roughly 3-4%* of Wikimedia contributors (across all projects) edit from within the continent.
~ The earlier calculation incorrectly included anonymous contributors in the numerator but not the denominator.

Fri, Jul 22, 11:49 PM · Product-Analytics (Kanban)
Iflorez renamed T313622: Confirm whether or not the current definition of new_editor_retention is based on global registration and update data glossary from Confirm whether or not the current definition of new editors are based on global registration and update data glossary to Confirm whether or not the current definition of new_editor_retention is based on global registration and update data glossary.
Fri, Jul 22, 9:09 PM · Product-Analytics (Kanban)
Iflorez added a comment to T313622: Confirm whether or not the current definition of new_editor_retention is based on global registration and update data glossary.

The New Editor table (New Editor table update query) pulls data from the MediaWiki history table and filters out accounts created by the system by excluding

Fri, Jul 22, 8:59 PM · Product-Analytics (Kanban)
Iflorez created T313622: Confirm whether or not the current definition of new_editor_retention is based on global registration and update data glossary.
Fri, Jul 22, 8:59 PM · Product-Analytics (Kanban)
Iflorez updated subscribers of T313549: Confirm whether or not the current definition of new active editors are based on global registration and update data glossary.

Confirming, active_editors pulls user_name and the user name's first registration_date min(event_user_creation_timestamp) from Mediawiki_history and is thus a global measure and not a local per wiki measure. Another potential method to ensure first registration dates is to add in a filter by start_timestamp is null from the Mediawiki_user_history table which @Milimetric says should be the first record in every user's history on each wiki, but that seems unnecessary here.

Fri, Jul 22, 8:32 PM · Product-Analytics (Kanban)
Iflorez added a comment to T313549: Confirm whether or not the current definition of new active editors are based on global registration and update data glossary.

The New Editor table (New Editor table update query) pulls data from the MediaWiki history table and filters out accounts created by the system by excluding

Fri, Jul 22, 6:07 PM · Product-Analytics (Kanban)

Thu, Jul 21

Iflorez added a comment to T294458: REQUEST Africa data check.

Related: T310224 New Data Pipeline for Unique Editor metrics by Geo (Country & Region)

Thu, Jul 21, 5:12 PM · Product-Analytics (Kanban)

Tue, Jul 19

Iflorez added a comment to T294458: REQUEST Africa data check.

Calculating the average monthly editors across all projects that edit from within Africa:

Tue, Jul 19, 10:06 PM · Product-Analytics (Kanban)

Jun 14 2022

Iflorez moved T300415: Campaigns: determine definition of organizer and participant retention from Triage to Upcoming Quarter on the Product-Analytics board.
Jun 14 2022, 5:09 PM · Campaign-Tools (Campaign-Tools-Sprint-18), Product-Analytics, Campaign-Registration
Iflorez edited projects for T300415: Campaigns: determine definition of organizer and participant retention, added: Product-Analytics; removed Product-Analytics (Kanban).
Jun 14 2022, 5:08 PM · Campaign-Tools (Campaign-Tools-Sprint-18), Product-Analytics, Campaign-Registration
Iflorez moved T300415: Campaigns: determine definition of organizer and participant retention from Doing to Needs Investigation on the Product-Analytics (Kanban) board.
Jun 14 2022, 5:06 PM · Campaign-Tools (Campaign-Tools-Sprint-18), Product-Analytics, Campaign-Registration
Iflorez closed T307144: Update dataset/query of New Editor Retention metric, a subtask of T287284: Update Superset metrics dashboards to use 'wmf_product' datasource, as Resolved.
Jun 14 2022, 5:06 PM · Epic, Product-Analytics
Iflorez closed T307144: Update dataset/query of New Editor Retention metric as Resolved.
Jun 14 2022, 5:06 PM · Product-Analytics (Kanban)
Iflorez updated the task description for T307144: Update dataset/query of New Editor Retention metric.
Jun 14 2022, 5:06 PM · Product-Analytics (Kanban)
Iflorez closed T305876: March 2022 MM (Movement Metrics) as Resolved.
Jun 14 2022, 5:05 PM · Product-Analytics (Kanban)

Jun 9 2022

Iflorez moved T307144: Update dataset/query of New Editor Retention metric from Next 2 weeks to Doing on the Product-Analytics (Kanban) board.
Jun 9 2022, 9:24 PM · Product-Analytics (Kanban)
Iflorez edited projects for T307144: Update dataset/query of New Editor Retention metric, added: Product-Analytics (Kanban); removed Product-Analytics.
Jun 9 2022, 9:23 PM · Product-Analytics (Kanban)
Iflorez claimed T307144: Update dataset/query of New Editor Retention metric.
Jun 9 2022, 9:23 PM · Product-Analytics (Kanban)
Iflorez updated the task description for T307144: Update dataset/query of New Editor Retention metric.
Jun 9 2022, 9:21 PM · Product-Analytics (Kanban)
Iflorez updated subscribers of T300413: Campaigns data: determine baseline for contributions.

Identify process and tech needs. see also @Isaac's work https://public.paws.wmcloud.org/User:Isaac_(WMF)/Edit%20Diffs/Campaign%20Impact.ipynb

Jun 9 2022, 6:14 PM · Campaign-Registration, Campaign-Tools

Jun 8 2022

Iflorez added a comment to T300411: Campaigns data: determine baseline for campaign events, organizers, and participants.

From meeting with @ifried, delivery of data results will be through numbers on this ticket in June and a deck in July:

  1. The number of number of campaign events (e.g. per month, per year)
    • Year | # total | monthly avg | low # & month | high # & month
  2. The number of campaign participants (e.g. per month, per year)
    • Year | # total | monthly avg | low # & month | high # & month
  3. The number of campaign organizers (e.g. per month, per year)
    • Year | # total | monthly avg | ratio organizers to participants| ratio organizers to events
    • Note: only available for two of the source datasets
Jun 8 2022, 11:33 PM · Campaign-Registration, Campaign-Tools

Jun 7 2022

Iflorez closed T306646: April 2022 Monthly Metrics as Resolved.
Jun 7 2022, 5:09 PM · Product-Analytics (Kanban)
Iflorez moved T306646: April 2022 Monthly Metrics from Next 2 weeks to Doing on the Product-Analytics (Kanban) board.
Jun 7 2022, 5:09 PM · Product-Analytics (Kanban)

May 16 2022

Iflorez updated the task description for T287283: High Level Metrics : Future Improvements.
May 16 2022, 4:50 PM · Product-Analytics

May 12 2022

Iflorez updated the task description for T287283: High Level Metrics : Future Improvements.
May 12 2022, 8:30 PM · Product-Analytics

Apr 28 2022

Iflorez updated the task description for T287283: High Level Metrics : Future Improvements.
Apr 28 2022, 11:23 PM · Product-Analytics
Iflorez updated the task description for T287283: High Level Metrics : Future Improvements.
Apr 28 2022, 11:22 PM · Product-Analytics
Iflorez updated the task description for T287283: High Level Metrics : Future Improvements.
Apr 28 2022, 11:22 PM · Product-Analytics
Iflorez updated the task description for T287283: High Level Metrics : Future Improvements.
Apr 28 2022, 11:20 PM · Product-Analytics
Iflorez updated the task description for T287283: High Level Metrics : Future Improvements.
Apr 28 2022, 10:58 PM · Product-Analytics
Iflorez updated the task description for T287283: High Level Metrics : Future Improvements.
Apr 28 2022, 8:59 PM · Product-Analytics
Iflorez updated the task description for T287283: High Level Metrics : Future Improvements.
Apr 28 2022, 8:56 PM · Product-Analytics
Iflorez updated the task description for T287283: High Level Metrics : Future Improvements.
Apr 28 2022, 8:52 PM · Product-Analytics
Iflorez updated the task description for T287283: High Level Metrics : Future Improvements.
Apr 28 2022, 8:43 PM · Product-Analytics
Iflorez updated the task description for T287283: High Level Metrics : Future Improvements.
Apr 28 2022, 8:38 PM · Product-Analytics
Iflorez updated subscribers of T306202: Determine data structure for storing addresses.

fyi @JAnstee_WMF @KCVelaga

Apr 28 2022, 4:23 PM · Campaign-Tools (Campaign-Tools-Sprint-11), CampaignEvents, Campaign-Registration

Apr 27 2022

Iflorez added a comment to T306984: Denied access error when querying wikishared dbs .

I'm now able to access x1 on sequel pro, the password for sequel pro to access the stat machines had to be reset.

Apr 27 2022, 9:16 PM · DBA, Data-Engineering-Kanban, Product-Analytics, Data-Engineering
Iflorez added a comment to T306984: Denied access error when querying wikishared dbs .

x1 and s7 are not providing error details.
This is the ToolForge error detail:

Apr 27 2022, 5:39 PM · DBA, Data-Engineering-Kanban, Product-Analytics, Data-Engineering
Iflorez added a comment to T306984: Denied access error when querying wikishared dbs .

Hello,
I'm unable to access x1, s7, and ToolForge.

Apr 27 2022, 5:31 PM · DBA, Data-Engineering-Kanban, Product-Analytics, Data-Engineering

Apr 26 2022

Iflorez updated the task description for T287420: Load past data in wmf_product KPM tables.
Apr 26 2022, 9:40 PM · Product-Analytics (Kanban)
Iflorez added a comment to T294458: REQUEST Africa data check.

Results by calendar year:

Apr 26 2022, 8:27 PM · Product-Analytics (Kanban)
Iflorez added a comment to T294458: REQUEST Africa data check.

After some fact-checking, we crafted this paragraph via conversations on Slack:

Apr 26 2022, 8:15 PM · Product-Analytics (Kanban)

Apr 21 2022

Iflorez closed T294458: REQUEST Africa data check as Resolved.
Apr 21 2022, 5:14 PM · Product-Analytics (Kanban)
Iflorez created T306646: April 2022 Monthly Metrics.
Apr 21 2022, 4:35 PM · Product-Analytics (Kanban)
Iflorez updated the task description for T305876: March 2022 MM (Movement Metrics).
Apr 21 2022, 4:34 PM · Product-Analytics (Kanban)
Iflorez added a comment to T287420: Load past data in wmf_product KPM tables.
  • updated code to overwrite instead of Insert
  • Tested a full year of back fill into test table from shell (outside of Jupyter notebooks).
Apr 21 2022, 12:35 AM · Product-Analytics (Kanban)

Apr 20 2022

Iflorez updated the task description for T305876: March 2022 MM (Movement Metrics).
Apr 20 2022, 5:00 PM · Product-Analytics (Kanban)

Apr 14 2022

Iflorez added a comment to T287420: Load past data in wmf_product KPM tables.

Tested and reviewed results using the following queries
And found the same quantities in the tables for April, May, June

Apr 14 2022, 7:17 PM · Product-Analytics (Kanban)

Apr 13 2022

Iflorez updated the task description for T305876: March 2022 MM (Movement Metrics).
Apr 13 2022, 7:18 PM · Product-Analytics (Kanban)
Iflorez added a comment to T287420: Load past data in wmf_product KPM tables.

test code:

import pandas as pd
import datetime
from wmfdata import charting, hive,spark
Apr 13 2022, 7:16 PM · Product-Analytics (Kanban)

Apr 11 2022

Iflorez triaged T305876: March 2022 MM (Movement Metrics) as High priority.
Apr 11 2022, 6:08 PM · Product-Analytics (Kanban)
Iflorez moved T305876: March 2022 MM (Movement Metrics) from Next 2 weeks to Doing on the Product-Analytics (Kanban) board.
Apr 11 2022, 6:08 PM · Product-Analytics (Kanban)
Iflorez created T305876: March 2022 MM (Movement Metrics).
Apr 11 2022, 5:48 PM · Product-Analytics (Kanban)
Iflorez closed T300657: January 2022 Movement Metrics as Resolved.
Apr 11 2022, 5:44 PM · Product-Analytics (Kanban)

Apr 7 2022

Iflorez added a comment to T287420: Load past data in wmf_product KPM tables.

Need to: add data from cchen.new_editors table by cohort

  • check cohorts
  • draft code and create file
  • TEST RUN with print
  • TEST RUN with new test table
  • collaborate with Maya to review the file/code
    • compare between cchen.new_editors and florez test table
  • save files
  • sudo
  • Run the scripts
  • Check that it worked by querying (it will say that it successfully completed regardless)
  • delete test table and its row items
Apr 7 2022, 10:14 PM · Product-Analytics (Kanban)

Apr 6 2022

Iflorez updated subscribers of T287420: Load past data in wmf_product KPM tables.
  1. will need to sudo to backfill now that the table changed ownership per T305109.
Apr 6 2022, 5:35 PM · Product-Analytics (Kanban)

Apr 5 2022

Iflorez updated the task description for T287283: High Level Metrics : Future Improvements.
Apr 5 2022, 12:18 AM · Product-Analytics

Mar 28 2022

Iflorez closed T285954: Onboarding Checklist for Irene Florez as Resolved.
Mar 28 2022, 4:50 PM · Product-Analytics (Kanban)
Iflorez updated subscribers of T304312: Data request for TeWiki diff post.

@PDas notes via email: "This is something significant and strategically placed around the India Brand Experiment and Fundraising Drive for India.
Would you be able to share a reasonable timeline for gathering this type of data?
We can then discuss internally and may push the dates for diff post further."

Mar 28 2022, 4:20 PM · Product-Analytics (Kanban), Campaign-Tools

Mar 25 2022

Iflorez updated the task description for T300410: Compile Campaigns Data - All time from major campaigns tools.
Mar 25 2022, 8:19 PM · Campaign-Tools (Campaign-Tools-Sprint-18), Campaign-Registration, Product-Analytics (Kanban)

Mar 23 2022

Iflorez added a comment to T300411: Campaigns data: determine baseline for campaign events, organizers, and participants.

for those datasets that don't include 'organizer' datatypes, share the % of data that corresponds to

Mar 23 2022, 9:05 PM · Campaign-Registration, Campaign-Tools

Mar 22 2022

Iflorez added a comment to T300410: Compile Campaigns Data - All time from major campaigns tools.

Info from @Samwalton9

Mar 22 2022, 11:20 PM · Campaign-Tools (Campaign-Tools-Sprint-18), Campaign-Registration, Product-Analytics (Kanban)
Iflorez updated the task description for T300410: Compile Campaigns Data - All time from major campaigns tools.
Mar 22 2022, 10:49 PM · Campaign-Tools (Campaign-Tools-Sprint-18), Campaign-Registration, Product-Analytics (Kanban)

Mar 21 2022

Iflorez added a comment to T233805: Discuss the use of Wikidata P5008 for lists tracking for GLOW campaigns.

We decided not to use P5008 due to the complexity involved.

Mar 21 2022, 9:49 PM · Wikidata, GLOW
Iflorez closed T233805: Discuss the use of Wikidata P5008 for lists tracking for GLOW campaigns as Resolved.
Mar 21 2022, 9:49 PM · Wikidata, GLOW
Iflorez closed T234560: identify a reliable user field for use with the revision, page...maybe also the actor table as Resolved.
Mar 21 2022, 9:48 PM · Platform Engineering (Icebox), GLOW
Iflorez closed T234560: identify a reliable user field for use with the revision, page...maybe also the actor table, a subtask of T233806: Prepare a preliminary metric plan for GLOW , as Resolved.
Mar 21 2022, 9:48 PM · GLOW
Iflorez updated the task description for T304113: [Campaigns team review request] Event Center Site Map Options.
Mar 21 2022, 9:30 PM · Campaign-Tools (Campaign-Tools-Sprint-10), Campaign-Registration
Iflorez updated the task description for T285954: Onboarding Checklist for Irene Florez.
Mar 21 2022, 9:05 PM · Product-Analytics (Kanban)
Iflorez moved T303284: Continuity notes for Campaigns-Product's data & analysis plans in FY 2021-22 Q3/Q4 from Next 2 weeks to Doing on the Product-Analytics (Kanban) board.
Mar 21 2022, 8:54 PM · Product-Analytics (Kanban), Campaign-Registration
Iflorez updated the task description for T300657: January 2022 Movement Metrics.
Mar 21 2022, 8:53 PM · Product-Analytics (Kanban)
Iflorez closed T298927: December 2021 Wikimedia movement metrics as Resolved.
Mar 21 2022, 8:50 PM · Product-Analytics (Kanban)
Iflorez added a comment to T304068: 1Lib1Ref January 2022 Data Analysis.

Can you share answers to following to help us prioritize and respond to your request appropriately:

Mar 21 2022, 4:31 PM · Product-Analytics, Campaign-Tools

Mar 16 2022

Iflorez updated the task description for T300410: Compile Campaigns Data - All time from major campaigns tools.
Mar 16 2022, 6:24 PM · Campaign-Tools (Campaign-Tools-Sprint-18), Campaign-Registration, Product-Analytics (Kanban)

Mar 15 2022

Iflorez closed T298061: Investigate drops in non-bot edits, a subtask of T300786: Investigate non-bot mobile edit growth reduction, as Resolved.
Mar 15 2022, 4:50 PM · Product-Analytics
Iflorez closed T298061: Investigate drops in non-bot edits as Resolved.
Mar 15 2022, 4:50 PM · Product-Analytics
Iflorez changed the status of T300786: Investigate non-bot mobile edit growth reduction from Declined to Resolved.
Mar 15 2022, 4:50 PM · Product-Analytics

Mar 14 2022

Iflorez added a comment to T298061: Investigate drops in non-bot edits.

The issue documented here may be caused/impacted by blocks.
We’ll continue to monitor this at the high level through Monthly Key Metrics reporting.

Mar 14 2022, 7:27 PM · Product-Analytics
Iflorez closed T300786: Investigate non-bot mobile edit growth reduction as Declined.
Mar 14 2022, 7:27 PM · Product-Analytics
Iflorez added a comment to T300786: Investigate non-bot mobile edit growth reduction.

The issue documented here may be caused/impacted by blocks.
We’ll continue to monitor this at the high level through Monthly Key Metrics reporting.

Mar 14 2022, 7:26 PM · Product-Analytics

Mar 10 2022

Iflorez updated the task description for T300410: Compile Campaigns Data - All time from major campaigns tools.
Mar 10 2022, 7:43 PM · Campaign-Tools (Campaign-Tools-Sprint-18), Campaign-Registration, Product-Analytics (Kanban)

Mar 9 2022

Iflorez added a comment to T298061: Investigate drops in non-bot edits.

The trend continues in February
YoY change: https://superset.wikimedia.org/r/1312
values: https://superset.wikimedia.org/r/1313

Mar 9 2022, 6:26 PM · Product-Analytics

Mar 8 2022

Iflorez closed T297223: November 2021 Wikimedia movement metrics as Resolved.
Mar 8 2022, 6:11 PM · Product-Analytics (Kanban)
Iflorez closed T301001: backfill missing editor data from cchen tables as Resolved.
Mar 8 2022, 6:10 PM · Product-Analytics (Kanban)
Iflorez added a comment to T301001: backfill missing editor data from cchen tables.

Confirming that the data is in the tables now.
Unfortunately Jan 2020 and 2016 data are still not showing up in the Superset charts. This may be a bug. See the related task: T301895

Mar 8 2022, 6:10 PM · Product-Analytics (Kanban)

Mar 7 2022

Iflorez added a comment to T300786: Investigate non-bot mobile edit growth reduction.

The trend continues
The reduction in non-bot mobile monthly edits continues to see a decrease: https://superset.wikimedia.org/r/1305
In February there was .3% YoY growth, a continued reduction from the previous months and years: https://superset.wikimedia.org/r/1306

Mar 7 2022, 7:36 PM · Product-Analytics

Mar 3 2022

Iflorez updated the task description for T300410: Compile Campaigns Data - All time from major campaigns tools.
Mar 3 2022, 8:14 PM · Campaign-Tools (Campaign-Tools-Sprint-18), Campaign-Registration, Product-Analytics (Kanban)
Iflorez updated the task description for T300410: Compile Campaigns Data - All time from major campaigns tools.
Mar 3 2022, 8:06 PM · Campaign-Tools (Campaign-Tools-Sprint-18), Campaign-Registration, Product-Analytics (Kanban)
Iflorez updated the task description for T300410: Compile Campaigns Data - All time from major campaigns tools.
Mar 3 2022, 8:04 PM · Campaign-Tools (Campaign-Tools-Sprint-18), Campaign-Registration, Product-Analytics (Kanban)

Feb 28 2022

Iflorez added a comment to T300411: Campaigns data: determine baseline for campaign events, organizers, and participants.

due to privacy reasons, I am not able to do the following for all of the data:

Feb 28 2022, 6:05 PM · Campaign-Registration, Campaign-Tools
Iflorez updated the task description for T300411: Campaigns data: determine baseline for campaign events, organizers, and participants.
Feb 28 2022, 6:05 PM · Campaign-Registration, Campaign-Tools
Iflorez added a comment to T300413: Campaigns data: determine baseline for contributions.

due to privacy reasons, I am not able to do the following for all of the data:

Feb 28 2022, 6:00 PM · Campaign-Registration, Campaign-Tools
Iflorez updated the task description for T300413: Campaigns data: determine baseline for contributions.
Feb 28 2022, 6:00 PM · Campaign-Registration, Campaign-Tools
Iflorez updated the task description for T300414: Campaigns data: determine baseline for organizer & participant retention.
Feb 28 2022, 5:57 PM · Campaign-Registration, Campaign-Tools
Iflorez added a comment to T300414: Campaigns data: determine baseline for organizer & participant retention.

@ifried due to privacy reasons, I am not able to do the following for all of the data:

  • Share which campaigns are included in the data
Feb 28 2022, 5:55 PM · Campaign-Registration, Campaign-Tools

Feb 23 2022

Iflorez updated the task description for T300415: Campaigns: determine definition of organizer and participant retention.
Feb 23 2022, 8:28 PM · Campaign-Tools (Campaign-Tools-Sprint-18), Product-Analytics, Campaign-Registration
Iflorez updated the task description for T300415: Campaigns: determine definition of organizer and participant retention.
Feb 23 2022, 7:34 PM · Campaign-Tools (Campaign-Tools-Sprint-18), Product-Analytics, Campaign-Registration

Feb 22 2022

Iflorez updated the task description for T300410: Compile Campaigns Data - All time from major campaigns tools.
Feb 22 2022, 10:47 PM · Campaign-Tools (Campaign-Tools-Sprint-18), Campaign-Registration, Product-Analytics (Kanban)