@cchen can you add an update on the status of work relating to this?

@nshahquinn-wmf @cchen: Can you please clarify

Wondering how geo-categorization changing over time would affect inclusion or exclusion in the metric calculation.

Nov1, 2021 Editor Retention discussions with Christina and Rui
What we discussed

• Readout from DSE Hackathon geo metrics projects
• Calculate unique editors across geo instead of project
• Use user_name instead of user_id, since user_name is global and unique across projects
• Explore solutions for aggregating editor retention at geo level A thought experiment for privacy-friendly retention measurement
• Concerns Raised :
  • Editors who move countries will be excluded from the retention (i.e. numerator) because their repeat edit was not in the same country in which they had their first edit.
  • Small wikis : Editors safety issues
• How is NER calculated currently : Editor registers and edits for the first time within 30 days of creating the account, edits again between 31-60 days of their first edit.
• While we think about new metric for editor retention, or make data available for calculating NER, we need to find a way to calculate NER in the interim, as those discussions about a new metric could take a while
• Try the Proposed Solution : Get a new dataset that will only have country level aggregates of editors and Try using this to calculate geo level retention 2 months later.

How can we arrive at a decision?

• Need Analysis for understanding the impact of our assumptions and concerns
• Look at trends - how predictive is 1month vs 6month retention
• Do a comparison of the old retention and proposed solution for new metric

What is stopping us from taking this on soon?

• prioritization
• capacity

Other discussions that could influence this decision

• do we need 2 month NER? Does it still match the product department’s needs
• Carol, Christina and others are discussing about it, but it hasnt gained traction

Follow up discussion with Kate and Irene - vet Christina’s idea

Immediate next steps:

• Create a temporary table : copy of editors_daily, scrubbing country and replace by Market
• Partner with GDI, Request DE to prioritize: to add new fields ‘user_name’ in editors_daily

Adding @JCarvalho who is creating schema for campaigns-product T289894 and interested in using the global 'user_name' field

Created a copy of editors_daily in mayakpwiki.editors_daily with additonal column 'region' that has break up of economic region of the editor.

Currently working with the Privacy team to retain the data beyond 90 days and Explore solutions for aggregating editor retention at geo level - an experiment for privacy-friendly retention measurement.

Update: Scheduled meeting with Privacy and Security teams to discuss further on Jan 19, 2022.

Meeting has been moved to Feb 24 due to conflict with APP meetings.
Currently Blocked on Legal(Privacy) and Security.

@Mayakp.wiki thank you for the update; we're watching this for T289894