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 <[email protected]> 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 <[email protected]> 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" <
>> [email protected]> 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
>>> [email protected]
>>> https://lists.wikimedia.org/mailman/listinfo/mobile-l
>>>
>>>
>> _______________________________________________
>> 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

Reply via email to