Research talk:Teahouse long term new editor retention/Work log/2015-12-15
Jump to navigation Jump to search
Tuesday, December 15, 2015
Dumping the November-December A/B test data from the HostBot invite table for upload to:
#6758 items returned SELECT user_id, user_name, user_registration, sample_date, CASE sample_group WHEN 'th exp' THEN "invited" WHEN 'th control'THEN "control" END AS sample_group, user_talkpage AS user_talk_id, ut_is_redirect FROM th_up_invitees_experiment_2 WHERE sample_type = 4 AND sample_group IS NOT NULL AND hostbot_skipped = 0;
Saves the results to CSV and loaded them into jmorgan.th_retention_sample_2...
...done! How many in each group?
#invited: 3319 #control: 3439 select count(*) as "invited" from th_retention_sample_2 where sample_group = "invited" UNION select count(*) as "control" from th_retention_sample_2 where sample_group = "control";