Thanks, Tilman! This is a great start. Oliver, thank you for your offer of support! For now, we are still in an early 'agile' stage of prioritizing features based on stakeholder's feedback (like the one Pine raised). I think dashboard is something we will consider when we are further down the road on this.
On Thu, Sep 17, 2015 at 12:57 PM, Oliver Keyes <[email protected]> wrote: > 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 > >
_______________________________________________ Mobile-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/mobile-l
