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

== Wednesday, September 30, 2015 ==
<!-- Put work log content here.  -->

Looking into users who were auto created.  

<pre>
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)
</pre>

--[[User:Halfak (WMF)|Halfak (WMF)]] ([[User talk:Halfak (WMF)|talk]]) 20:31, 30 September 2015 (UTC)

<!-- Leave this category alone. -->
[[Category:{{#titleparts: {{PAGENAME}} | 1 | 1 }} work log entries]]