Are there going to be regularly updated dashboards for these KPIs? The Discovery team is happy to lend you some support in getting a platform set up, moving forward.
On 17 September 2015 at 15:55, Pine W <[email protected]> wrote: > Thanks Tilman. Is it possible for to get ENWP-only stats for August 2015? > The last data for ENWP pageviews on stats.wikimedia.org is from July. A > breakdown of ENWP stats into mobile and desktop would also be helpful. > > Pine > > > On Thu, Sep 17, 2015 at 12:44 PM, Tilman Bayer <[email protected]> > wrote: > >> Hi all, >> >> with this email we are starting a weekly look at our most important >> readership metrics. >> >> The main purpose is to raise awareness about how these are developing, >> call out the impact of any unusual events in the preceding week (e.g. the >> media promotion for the Android app this time) 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 7-13, 2015 unless otherwise >> noted.) >> >> Pageviews: >> >> Total: 546 million/day >> >> Context (April 2015-September 2015): >> >> [image: Wikimedia daily pageviews, all vs. mobile (April 2015-).png] >> >> After the drop in June, which by now looks not merely seasonal but likely >> to be at least partially connected to the rollout of HTTPS-only access >> begun on June 12, overall pageviews are slightly rising again recently. >> (Notably, the recent drop >> <https://reportcard.wmflabs.org/graphs/unique_visitors> in comScore’s >> numbers - also in their pageview estimates for Wikimedia sites, not >> reproduced in that report card - is not consistent with our own traffic >> data; these discrepancies are being looked into.) >> >> Desktop: 58.8% >> >> Mobile web: 39.9% >> >> Apps: 1.2% >> >> >> Global North ratio: 77.5% of total pageviews >> >> Context (April 2015-September 2015): >> >> [image: Wikimedia pageviews, Global South vs. Global North (April >> 2015-).png] >> >> >> Unique app users >> >> Android: 1.136 million /day >> >> Context (January 2015-September 2015): >> >> While this number is slightly higher than in the preceding week, there’s >> no noticeable effect visible yet from the 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). >> >> >> iOS: 290k / day >> >> >> Context (January 2015-September 2015): >> >> New app installations >> >> Android: 40,168/day (Daily installs per device, from Google Play, >> September 7-11) >> >> Context (September 2014-September 2015): >> >> Unfortunately, the stats function of the Google Play is having issues >> currently and data for recent days has been delayed. (They “expect to >> resolve the issue shortly”, but the September 11 only became available this >> morning and I’m sending this report out now, a fuller assessment of the >> impact of the media campaign will need to wait.) The first two days after >> the blog post went out on September 10 did not yet show a marked increase: >> >> 20150911 >> >> 40648 >> >> 20150910 >> >> 39862 >> >> 20150909 >> >> 39927 >> >> 20150908 >> >> 39981 >> >> 20150907 >> >> 40420 >> >> >> iOS: 5,262/day (download numbers from App Annie) >> >> Context (September 2014-September 2015): >> >> We seem to have a slight upwards trend in recent weeks, but it’s still >> way below the download rate a year ago. >> >> ---- >> >> For reference, the queries and source links used are listed below (access >> is needed for each). I’ll also see to upload charts to Commons. >> >> 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-07" >> AND "2015-09-13"; >> >> 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 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-07" >> AND "2015-09-13"; >> >> 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-07" >> AND "2015-09-13" GROUP BY access_method; >> >> 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 20150907 AND >> 20150913; >> >> 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 Android_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 > > -- Oliver Keyes Count Logula Wikimedia Foundation
_______________________________________________ Mobile-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/mobile-l
