Jump to content

Research talk:Onboarding new Wikipedians/Rollout/Work log/2014-02-14

Add topic
From Meta, a Wikimedia project coordination wiki

Friday, February 14th

[edit]

Yesterday, I made this: http://ee-dashboard.wmflabs.org/dashboards/growth

Today, I want to work out a funnel analysis for GettingStarted for the new wikis. Sadly, in reworking the logging setup (Schema:GettingStartedRedirectImpression), I did not realize that we wanted to do a funnel analysis, so it's not exactly tuned to do one well.

First, what does our funnel look like? --Halfak (WMF) (talk) 20:43, 14 February 2014 (UTC)Reply


I got side-tracked by some code review, but now I'm back with a figure.

Onboarding funnel. 

That's a lot of funneling to look at.

First things first, I need to figure out when the first event hit EventLogging.

> select min(timestamp) from GettingStartedRedirectImpression_7355552 where wiki = "enwiki";
+----------------+
| min(timestamp) |
+----------------+
| 20140211174924 |
+----------------+
1 row in set (0.06 sec)


Now, I need to figure out how newcomers make it to the first part of the funnel, the return.

> SELECT event_displayMobile, event_isSelfMade, event_pageNS, count(*) FROM GettingStartedRedirectImpression_7355552 WINNER JOIN ServerSideAccountCreation_5487345 USING (event_userId) group by 1,2,3;
+---------------------+------------------+--------------+----------+
| event_displayMobile | event_isSelfMade | event_pageNS | count(*) |
+---------------------+------------------+--------------+----------+
|                   0 |                0 |           -1 |        3 |
|                   0 |                0 |            0 |       24 |
|                   0 |                0 |            1 |        1 |
|                   0 |                0 |            2 |        2 |
|                   0 |                0 |            3 |        1 |
|                   0 |                0 |            4 |        4 |
|                   0 |                0 |           12 |        1 |
|                   0 |                0 |           14 |        1 |
|                   0 |                0 |          100 |        1 |
|                   0 |                1 |           -1 |      519 |
|                   0 |                1 |            0 |     6981 |
|                   0 |                1 |            1 |      133 |
|                   0 |                1 |            2 |      121 |
|                   0 |                1 |            3 |       36 |
|                   0 |                1 |            4 |     1750 |
|                   0 |                1 |            5 |       29 |
|                   0 |                1 |            6 |       85 |
|                   0 |                1 |            7 |       13 |
|                   0 |                1 |           10 |        1 |
|                   0 |                1 |           12 |      121 |
|                   0 |                1 |           13 |        2 |
|                   0 |                1 |           14 |       62 |
|                   0 |                1 |          100 |      191 |
|                   0 |                1 |          101 |        2 |
|                   0 |                1 |          102 |       14 |
|                   0 |                1 |          103 |        1 |
|                   0 |                1 |          104 |        9 |
|                   0 |                1 |          446 |       21 |
|                   1 |                0 |            0 |       10 |
|                   1 |                1 |           -1 |       25 |
|                   1 |                1 |            0 |      271 |
|                   1 |                1 |            1 |        4 |
|                   1 |                1 |            2 |        2 |
|                   1 |                1 |            4 |       82 |
|                   1 |                1 |            6 |        3 |
|                   1 |                1 |           12 |        6 |
|                   1 |                1 |           14 |        4 |
|                   1 |                1 |          100 |       20 |
+---------------------+------------------+--------------+----------+
38 rows in set (0.27 sec)

--Halfak (WMF) (talk) 22:08, 14 February 2014 (UTC)Reply