Hi all,
here is the weekly look at our most important readership metrics.
As laid out last week, the main purpose is to raise awareness about how
these are developing, call out the impact of any unusual events in the
preceding week, and facilitate thinking about core metrics in general.
We will iterate on the presentation (e.g. to better take seasonality into
account, in particular including year-over-year comparisons) and eventually
want to create dashboards for those which are not already available in that
form already. Feedback and discussion welcome.
(All numbers below are averages for September 14-20, 2015 unless otherwise
noted.)
Pageviews:
Total: 523 million/day
Context (April 2015-September 2015):
Pageviews were down 4.3% from last week, a somewhat noticeable drop (for a
more dramatized view, see the Vital Signs dashboard
<https://vital-signs.wmflabs.org/#projects=all/metrics=Pageviews>).
Desktop: 58.1%
Mobile web: 40.7%
Apps: 1.2%
Global North ratio: 77.4% of total pageviews
Context (April 2015-September 2015):
Unique app users
Android: 1.303 million /day
Context (January 2015-September 2015):
A slight rise in the last two weeks, but we’re not seeing a clear effect of
the recent media promotion for the Android app (blog post
<https://blog.wikimedia.org/2015/09/10/wikipedia-app-new-navigation-features/>
on September 10, media coverage
<https://meta.wikimedia.org/wiki/Communications_committee/Press_clippings/2015#September>
on September 10, 11 and 13) - compare the bump in April around the time
when the app was featured in the Play store and the media promotion for the
iOS app happened (with much wider media coverage
<https://meta.wikimedia.org/wiki/Communications_committee/Press_clippings/2015#April>
).
iOS: 319k / day
Context (January 2015-September 2015):
No news here.
New app installations
Android: 44,066/day (installs per device, from Google Play, September 14-19)
Context (Aug 21, 2015 - Sep 21, 2015):
One is tempted to see a bit of a bump after the start of the media
promotion on September 10 (concretely, average daily installs in the time
from September 10-19 were 2.5% higher than in the time from August
21-September 9), but in the end we can’t really be certain whether it had
an effect. (Compare again very visible peak in April in the year-over-year
graph
<https://commons.wikimedia.org/wiki/File:Wikipedia_Android_app_-_daily_installs_by_device,_Sep_11,_2014_-_Sep_11,_2015_(Google_Play).png>
I posted last week.)
The drop on Sunday September 20 seems to be a problem with Google Play’s
statistics (several other metrics like uninstall numbers show a similar
drop) and not something we need to worry about; I left it out from the
average above as an outlier.
iOS: 4,839/day (download numbers from App Annie)
Context (September 2014-September 2015):
----
For reference, the queries and source links used are listed below (access
is needed for each). Most of the above charts have been updated on Commons,
too
<https://commons.wikimedia.org/w/index.php?title=Special:ListFiles&offset=20150923010000&user=Tbayer+%28WMF%29&ilshowall=1&limit=4>
.
hive (wmf)> SELECT SUM(view_count)/7000000 AS avg_daily_views_millions FROM
wmf.projectview_hourly WHERE agent_type = 'user' AND
CONCAT(year,"-",LPAD(month,2,"0"),"-",LPAD(day,2,"0"))
BETWEEN "2015-09-14"
AND "2015-09-20";
hive (wmf)> SELECT year, month, day,
CONCAT(year,"-",LPAD(month,2,"0"),"-",LPAD(day,2,"0"))
as date,
sum(IF(access_method <> 'desktop', view_count, null)) AS mobileviews,
SUM(view_count) AS allviews FROM wmf.projectview_hourly WHERE year=2015 AND
agent_type = 'user' GROUP BY year, month, day ORDER BY year, month, day
LIMIT 1000;
hive (wmf)> SELECT access_method, SUM(view_count)/7 FROM
wmf.projectview_hourly WHERE agent_type = 'user' AND
CONCAT(year,"-",LPAD(month,2,"0"),"-",LPAD(day,2,"0"))
BETWEEN "2015-09-14"
AND "2015-09-20" GROUP BY access_method;
hive (wmf)> SELECT SUM(IF (FIND_IN_SET(country_code,
'AD,AL,AT,AX,BA,BE,BG,CH,CY,CZ,DE,DK,EE,ES,FI,FO,FR,FX,GB,GG,GI,GL,GR,HR,HU,IE,IL,IM,IS,IT,JE,LI,LU,LV,MC,MD,ME,MK,MT,NL,NO,PL,PT,RO,RS,RU,SE,SI,SJ,SK,SM,TR,VA,AU,CA,HK,MO,NZ,JP,SG,KR,TW,US')
0, view_count, 0))/SUM(view_count) FROM
wmf.projectview_hourly WHERE
agent_type = 'user' AND
CONCAT(year,"-",LPAD(month,2,"0"),"-",LPAD(day,2,"0"))
BETWEEN "2015-09-14"
AND "2015-09-20";
hive (wmf)> SELECT year, month, day,
CONCAT(year,"-",LPAD(month,2,"0"),"-",LPAD(day,2,"0")),
SUM(view_count) AS
all, SUM(IF (FIND_IN_SET(country_code,
'AD,AL,AT,AX,BA,BE,BG,CH,CY,CZ,DE,DK,EE,ES,FI,FO,FR,FX,GB,GG,GI,GL,GR,HR,HU,IE,IL,IM,IS,IT,JE,LI,LU,LV,MC,MD,ME,MK,MT,NL,NO,PL,PT,RO,RS,RU,SE,SI,SJ,SK,SM,TR,VA,AU,CA,HK,MO,NZ,JP,SG,KR,TW,US')
0, view_count, 0)) AS Global_North_views FROM
wmf.projectview_hourly
WHERE year = 2015 AND agent_type='user' GROUP BY
year, month, day ORDER BY
year, month, day LIMIT 1000;
hive (wmf)> SELECT SUM(IF(platform = 'Android',unique_count,0))/7 AS
avg_Android_DAU_last_week, SUM(IF(platform = 'iOS',unique_count,0))/7 AS
avg_iOS_DAU_last_week FROM wmf.mobile_apps_uniques_daily WHERE
CONCAT(year,LPAD(month,2,"0"),LPAD(day,2,"0")) BETWEEN 20150914 AND
20150920;
hive (wmf)> SELECT
CONCAT(year,"-",LPAD(month,2,"0"),"-",LPAD(day,2,"0"))
as date, unique_count AS Android_DAU FROM wmf.mobile_apps_uniques_daily
WHERE platform = 'Android';
hive (wmf)> SELECT
CONCAT(year,"-",LPAD(month,2,"0"),"-",LPAD(day,2,"0"))
as date, unique_count AS iOS_DAU FROM wmf.mobile_apps_uniques_daily WHERE
platform = 'iOS';
https://play.google.com/apps/publish/?dev_acc=18062848292902787645#StatsPla…
https://www.appannie.com/dashboard/252257/item/324715238/downloads/?breakdo…
--
Tilman Bayer
Senior Analyst
Wikimedia Foundation
IRC (Freenode): HaeB