To prevent misunderstandings among cursory readers, and to connect a bit with the parallel thread about apps and Global North/South:
Adam's numbers were about ratios among Android app pageviews. If you are instead interested in the overall percentage of WP0 pageviews that come from the app on those legacy Android devices, one needs to consider that the Android app (on any device, new or old) only generates 4.4% of WP0 pageviews anyway [4]. Per Adam [1], between 14.8% and 16.6% of them are on the legacy devices. So that's much less than 1% of the Zero traffic that is affected.
BTW, 95.4% of Zero pageviews are via mobile web [5], and just 0.2% from the iOS app [6].
[4] SELECT SUM(IF(access_method = 'mobile app' AND user_agent_map['os_family'] = 'Android',view_count,0))/SUM(view_count) FROM wmf.pageview_hourly WHERE year = 2015 AND month = 8 AND day > 19 AND day < 27 AND zero_carrier IS NOT NULL;
[5] SELECT SUM(IF(access_method = 'mobile web',view_count,0))/SUM(view_count) FROM wmf.pageview_hourly WHERE year = 2015 AND month = 8 AND day > 19 AND day < 27 AND zero_carrier IS NOT NULL;
[6] SELECT SUM(IF(access_method = 'mobile app' AND user_agent_map['os_family'] = 'iOS',view_count,0))/SUM(view_count) FROM wmf.pageview_hourly WHERE year = 2015 AND month = 8 AND day > 19 AND day < 27 AND zero_carrier IS NOT NULL;
On Fri, Aug 28, 2015 at 12:03 PM, Pine W wiki.pine@gmail.com wrote:
Ok, those numbers might be significant for the WP0 program. Has WMF Partnerships been consulted about this proposed change to app support for legacy Android versions?
Pine
On Aug 28, 2015 10:53 AM, "Adam Baso" abaso@wikimedia.org wrote:
Following up...
For Wikipedia Zero tagged Wikipedia for Android access, looking at days from August 20-26, it looks like about somewhere between 14.8% and 16.6% of pageviews are on Android 2.3-4.0. [1]
Wikipedia Zero tagged Wikipedia for Android access constitutes about 5.3% of the overall Wikipedia for Android app pageviews, based on a week of pageviews from August 20-26.
-Adam
[1]
select day, user_agent_map['os_major'], user_agent_map['os_minor'], sum(view_count) from wmf.pageview_hourly where year = 2015 and month = 8 and day > 19 and day < 27 and access_method = 'mobile app' and zero_carrier is not null and user_agent_map['os_family'] = 'Android' group by day, user_agent_map['os_major'], user_agent_map['os_minor'];
[2]
select sum(view_count) from wmf.pageview_hourly where year = 2015 and month = 8 and day > 19 and day < 27 and access_method = 'mobile app' and user_agent_map['os_family'] = 'Android' and zero_carrier is null;
36197035
select sum(view_count) from wmf.pageview_hourly where year = 2015 and month = 8 and day > 19 and day < 27 and access_method = 'mobile app' and user_agent_map['os_family'] = 'Android' and zero_carrier is not null;
2032938
2032938 / (2032938 + 36197035) = 0.05317654815
On Thu, Aug 27, 2015 at 4:43 PM, Adam Baso abaso@wikimedia.org wrote:
I think I can get this in Hadoop. Will get back on thread.
On Thu, Aug 27, 2015 at 3:22 PM, Pine W wiki.pine@gmail.com wrote:
Just to check: what percentage of Wikipedia Zero users are running Android legacy OS versions?
Pine
On Aug 27, 2015 12:49 PM, "Stephen Niedzielski" sniedzielski@wikimedia.org wrote:
The WMF Android App team will be ceasing active support for older devices soon, namely devices that run Android 4.0 (Ice Cream Sandwich) or older. Our final legacy device release is expected in mid to late September[0]. This release will remain available on the Google Play Store for devices running Android 2.3 (Gingerbread) through 4.0 (Ice Cream Sandwich). However, future releases will only target devices running Android 4.0.3 (Ice Cream Sandwich MR1) and higher. [1]
Why this is happening Devices running Android versions older than 4.0.3 make up less than 8%[2] of the Wikipedia for Android install base, and supporting older devices requires disproportionate developer time and effort. Focusing our efforts on the most recent and widely used versions will allow us to provide a faster, more stable, and more delightful Wikipedia experience.
What this means for older devices Enjoy a stable and beautiful legacy release for as long as you wish. When you're ready for a new device, a sleek and modern app awaits
you.
- What this means for all other devices Reap the benefits of a Wikipedia for Android experience built to take advantage of the latest and greatest Android technology available.
-The Wikimedia Android team
[0] This will be the final planned legacy device release. Allowances will be made to enable back support patches of critical issues. [1] https://source.android.com/source/build-numbers.html [2] Google Play Developer Console, Current Installs by Device on August 20, 2015.
Mobile-l mailing list Mobile-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mobile-l
Mobile-l mailing list Mobile-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mobile-l
Mobile-l mailing list Mobile-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mobile-l
Mobile-l mailing list Mobile-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mobile-l