Research talk:Onboarding new Wikipedians/Rollout/Work log/2014-02-14
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)
I got side-tracked by some code review, but now I'm back with a figure.
_funnel.svg)
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)