[go: up one dir, main page]
More Web Proxy on the site http://driver.im/
Page MenuHomePhabricator
Create Task
Maniphest T304422

Welcome emails: Maintenance script for periodic exports
Closed, ResolvedPublic
Actions

Description

In T303240: Welcome emails: opt-in checkbox we created a checkbox for opting-in to the mailing list. In this task we want to generate CSV exports with the emails of user accounts who checked this box.

We'll want a maintenance script that has the following features:

  • support querying by dates with --from and --to fields
  • --output-mode, default is 'text' to print to stdout (one entry per line), otherwise --output-mode=csv would create a CSV for importing in Mailchimp
  • allow outputting data on whether the user has a confirmed email or not
  • allow outputting null value for email in case the user has checked the opt-in box but doesn't have a supplied email (for QA purposes, really)
  • add the "Email Address" header per the mailchimp requirements https://mailchimp.com/help/import-contacts-mailchimp/#Import_new_contacts

Details

SubjectRepoBranchLines +/-
Pilot: Update export script to add headers and more datamediawiki/extensions/GrowthExperimentsmaster+36 -11
Pilot: Maintenance script for exporting emails that opt-in to mailing listmediawiki/extensions/GrowthExperimentsmaster+102 -0
Customize query in gerrit

Related Objects
Search...

Event Timeline

kostajh created this task.Mar 22 2022, 12:41 PM
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptMar 22 2022, 12:41 PM
kostajh claimed this task.Mar 22 2022, 12:41 PM
kostajh triaged this task as High priority.
kostajh moved this task from Incoming to In Progress on the Growth-Team (Sprint 0 (Growth Team)) board.
kostajh mentioned this in T303240: Welcome emails: opt-in checkbox.
gerritbot added a comment.Mar 23 2022, 12:26 PM

Change 773210 had a related patch set uploaded (by Kosta Harlan; author: Kosta Harlan):

[mediawiki/extensions/GrowthExperiments@master] Pilot: Maintenance script for exporting emails that opt-in to mailing list

https://gerrit.wikimedia.org/r/773210

gerritbot added a project: Patch-For-Review.Mar 23 2022, 12:26 PM
kostajh moved this task from In Progress to Code Review on the Growth-Team (Sprint 0 (Growth Team)) board.Mar 23 2022, 12:26 PM
Sgs subscribed.Mar 24 2022, 11:55 AM

The task description states support querying by dates with --from and --to fields, e.g. --from=2022-22-03 --to=2022-23-03 but I think that's not the format we will be supporting. Maybe we should update the task description for future context.

kostajh updated the task description. (Show Details)Mar 24 2022, 1:40 PM
gerritbot added a comment.Mar 24 2022, 6:01 PM

Change 773210 merged by jenkins-bot:

[mediawiki/extensions/GrowthExperiments@master] Pilot: Maintenance script for exporting emails that opt-in to mailing list

https://gerrit.wikimedia.org/r/773210

Maintenance_bot removed a project: Patch-For-Review.Mar 24 2022, 6:11 PM
ReleaseTaggerBot added a project: MW-1.39-notes (1.39.0-wmf.5; 2022-03-28).Mar 24 2022, 7:00 PM
gerritbot added a comment.Mar 24 2022, 9:21 PM

Change 773640 had a related patch set uploaded (by Kosta Harlan; author: Kosta Harlan):

[mediawiki/extensions/GrowthExperiments@master] Pilot: Update export script to add headers and more data

https://gerrit.wikimedia.org/r/773640

gerritbot added a project: Patch-For-Review.Mar 24 2022, 9:21 PM
MShilova_WMF added a parent task: T303779: [Epic] Welcome emails.Mar 28 2022, 2:09 PM
gerritbot added a comment.Apr 6 2022, 9:56 AM

Change 773640 merged by jenkins-bot:

[mediawiki/extensions/GrowthExperiments@master] Pilot: Update export script to add headers and more data

https://gerrit.wikimedia.org/r/773640

ReleaseTaggerBot edited projects, added MW-1.39-notes (1.39.0-wmf.7; 2022-04-11); removed MW-1.39-notes (1.39.0-wmf.5; 2022-03-28).Apr 6 2022, 10:00 AM
kostajh moved this task from Code Review to QA on the Growth-Team (Sprint 0 (Growth Team)) board.Apr 8 2022, 8:00 PM

I think this is done, unless we make changes to the experiment/control definitions (see T305015#7836990). When we're ready, we would run this manually on eswiki and share the results using mechanism-to-be-determined.

Etonkovidova subscribed.EditedApr 25 2022, 7:29 PM

Checked in beta cluster - the script will export users who are not in controls group and who checked the checkbox - ("mailinglist":true,"_group":"T303240_mailinglist").

If a user

  • never confirms email and the token is exires
  • never enters email
  • deletes email after entering it

the script will still export such users with empty email field, e.g.

"Email Address","Opt-in date",Group,"User ID","Is email address confirmed"
,20220511165349,T303240_mailinglist,3404,0
,20220511165650,T303240_mailinglist,3405,0
test1@server.com,20220511220200,T303240_mailinglist,3407,0
Etonkovidova moved this task from QA to Test in Production | Watching on the Growth-Team (Sprint 0 (Growth Team)) board.Apr 25 2022, 7:29 PM
KStoller-WMF closed this task as Resolved.Jul 7 2022, 10:34 PM
MRaishWMF mentioned this in T342353: enable opt-in checkbox on the Welcome Survey allowing new account holders to consent to being contacted for design research.Jul 20 2023, 2:36 PM
Maintenance_bot removed a project: Patch-For-Review.Jul 20 2023, 3:11 PM
Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL · Credits