Research talk:Teahouse long term new editor retention/Work log/2015-09-30

Wednesday, September 30, 2015

Looking into users who were auto created.

mysql:research@analytics-store.eqiad.wmnet [staging]> select bucket, count(*) FROM th_experimental_user INNER JOIN enwiki.logging ON log_user = user_id AND log_type = "newusers" AND log_action = "create" group by 1;
+---------+----------+
| bucket  | count(*) |
+---------+----------+
| control |     2932 |
| invited |    10982 |
+---------+----------+
2 rows in set (0.31 sec)

mysql:research@analytics-store.eqiad.wmnet [staging]> select bucket, count(*) FROM th_experimental_user group by 1;+---------+----------+
| bucket  | count(*) |
+---------+----------+
| control |     3092 |
| invited |    11674 |
+---------+----------+
2 rows in set (0.01 sec)

mysql:research@analytics-store.eqiad.wmnet [staging]> select 2932/3092;
+-----------+
| 2932/3092 |
+-----------+
|    0.9483 |
+-----------+
1 row in set (0.00 sec)

mysql:research@analytics-store.eqiad.wmnet [staging]> select 10982/11674;
+-------------+
| 10982/11674 |
+-------------+
|      0.9407 |
+-------------+
1 row in set (0.00 sec)

--Halfak (WMF) (talk) 20:31, 30 September 2015 (UTC)