+ Analytics Tilman, this is great. I find myself enjoying the stats/graphs and analysis/commentary equally and so far I don't see anything that isn't very helpful. Two considerations:
- Two app-level metrics I would like to see moving forward would be a number showing a daily/monthly visit count divided by the install base (if it is achievable): 15% of Android users visit every day, 45% visit every month. Along those lines, I am very interested to see the retention data that Android is now collecting. - Ultimately, I think 30 day views (or 28 day views) are less subject to noise than 7-day. - On a related note, so far the weekly cadence is great. It might also be that after 3 weeks we realize that a biweekly or monthly cadence is all we really need. At some point, we will have to solidify this so that we can automate some/most of it. Perhaps we should chat offline about what your tolerance is in that regard. -J On Wed, Sep 23, 2015 at 12:26 AM, Tilman Bayer <[email protected]> wrote: > 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#StatsPlace:p=org.wikipedia&statm=DAILY_DEVICE_INSTALLS&statd=OS_VERSION > > > https://www.appannie.com/dashboard/252257/item/324715238/downloads/?breakdown=country&date=2014-09-14~2015-09-13&chart_type=downloads&countries=ALL > > > -- > Tilman Bayer > Senior Analyst > Wikimedia Foundation > IRC (Freenode): HaeB > > _______________________________________________ > Mobile-l mailing list > [email protected] > https://lists.wikimedia.org/mailman/listinfo/mobile-l > >
_______________________________________________ Mobile-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/mobile-l
