Research talk:Newcomer task suggestions/Work log/2014-09-22

Monday, September 22nd

Woo! New data. Time to gather some cohorts and generate some preliminary stats.

So, the deployment took place on 9/12 and there were some minor issues fixed. I'll be starting data collection on 9/13 UTC.

> select log_user % 4, count(*) from logging where log_type = "newusers" and log_action = "create" and log_timestamp BETWEEN "20140913" AND "20140920" group by 1;
+--------------+----------+
| log_user % 4 | count(*) |
+--------------+----------+
|            0 |    13964 |
|            1 |    13992 |
|            2 |    13972 |
|            3 |    14060 |
+--------------+----------+
4 rows in set (0.40 sec)

Cool. We have about 14000 observations per bucket on enwiki. But wait. We deployed widely. Time to list some wikis.

mysql:research@analytics-store.eqiad.wmnet [log]> select distinct wiki from TaskRecommendation_9266319;
+--------+
| wiki   |
+--------+
| dewiki |
| enwiki |
| eswiki |
| fawiki |
| frwiki |
| hewiki |
| itwiki |
| nlwiki |
| ruwiki |
| svwiki |
| ukwiki |
| wiki   |
| zhwiki |
+--------+
13 rows in set (0.00 sec)

"wiki" isn't real. That means we're getting events for 12 wikis. Time to get my stats generation scripts working. --Halfak (WMF) (talk) 00:27, 23 September 2014 (UTC)

---