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
>
Tilman Bayer
Senior Analyst
Wikimedia Foundation
IRC (Freenode): HaeB
_______________________________________________
Mobile-l mailing list
Mobile-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mobile-l