Growth/Analytics updates/Work log/2018-10-18

In T206377 I was asked to get statistics on the context of account creations in order to understand the extent to what any intervention directly after account creation would potentially disrupt the workflow. The HQL query I used to grab data for this is listed in the Phabricator task comments. Said query sums up three specific measures for each of the mobile and desktop sites on a monthly basis, and those three measures are the same specified in the task: number of accounts created from the homepage, number of accounts created from a reading context, and number of accounts created from an editing context. In this case we do not want any data based on autocreated accounts, so those are filtered out (and in a separate comment I list the HQL query I used to verify that they were discarded).

Aggregated Counts
The task asks for aggregated counts from the recent few months, and the data gathered spans across March through September 2018. I summed up the counts across that time period, and created the bar charts seen below. These charts are split by site (desktop and mobile), and then by context (editing, reading the main page, and reading another page).

There are several trends visible when looking at these graphs side-by-side. First, we can see that for the Czech, Korean, English, and Ukrainian desktop sites (the three bars on the left side of those) the proportions are roughly similar. Most accounts are created from the reading context, primarily from somewhere that is not the main page, and relatively few appear to be created from an editing context.

Secondly, for the Czech, Korean, German, and Ukrainian mobile sites, the proportions are also roughly similar. Few accounts are created from reading the main page. Instead, they are either created when editing, or when reading a page that is not the main page. English Wikipedia is also similar in this sense, but where the four others appear to have more accounts created from the mobile editing context, English has more accounts created from the reading context.

Third, the proportions on the German desktop site are different from the aforementioned trend. Here we can see that about as many accounts are created from the editing context, as are made from the main page.

Lastly, Arabic Wikipedia is different from all the others. In our October 5 work log, I found that most accounts are registered from mobile. We see that clearly here as well, the number of registrations from both the editing and reading contexts on mobile are higher than the number of registrations from the reading context on the desktop site.

Monthly counts
Will be added soon.

‎