Research talk:Teahouse long term new editor retention/Work log/2015-12-15

Tuesday, December 15, 2015

Dumping the November-December A/B test data from the HostBot invite table for upload to:

s1-analytics-slave.eqiad.wmnet

#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";