Reading/2015-2016 Q1 Planning Data

Here's some data queried from various systems as part of the Reading 2015-2016 Q1 goal setting, which may also be valuable as a frame of reference in Reading strategy formulation as well.

The following Google Sheet shows some data such as apps uniques, an hour slice of pageview data across multiple days, Wikipedia for Android app installations based on country and device type and Wikipedia for Android app ratings.

https://docs.google.com/spreadsheets/d/10gF_Myr2Y58sS3Fw-iuSCa5xZJ1G6-nmrTVxPvaUcgw/edit?usp=sharing

Uniques data for apps is available when data usage is enabled. Following are some additional data around counts of daily and monthly active users of features.

Table of Contents
meta:Schema:MobileWikiAppToCInteraction

Schema revision 11014396 available since 20-January-2015

Android logging: yes

iOS logging: no

Sampling: 1%

select left(timestamp,8) as dt, count(distinct(event_appInstallID)) from MobileWikiAppToCInteraction_11014396 where timestamp > '201504' and timestamp < '201506' group by dt;

+--+-+ +--+-+ +--+-+
 * dt      | count(distinct(event_appInstallID)) |
 * 20150401 |                               1417 |
 * 20150402 |                               1526 |
 * 20150403 |                               1794 |
 * 20150404 |                               1947 |
 * 20150405 |                               2130 |
 * 20150406 |                               2025 |
 * 20150407 |                               1900 |
 * 20150408 |                               2008 |
 * 20150409 |                               1887 |
 * 20150410 |                               1870 |
 * 20150411 |                               2005 |
 * 20150412 |                               2225 |
 * 20150413 |                               1929 |
 * 20150414 |                               1956 |
 * 20150415 |                               1863 |
 * 20150416 |                               1978 |
 * 20150417 |                               2269 |
 * 20150418 |                               2923 |
 * 20150419 |                               3243 |
 * 20150420 |                               2798 |
 * 20150421 |                               2804 |
 * 20150422 |                               2861 |
 * 20150423 |                               2573 |
 * 20150424 |                               2509 |
 * 20150425 |                               2649 |
 * 20150426 |                               2743 |
 * 20150427 |                               2490 |
 * 20150428 |                               2425 |
 * 20150429 |                               2724 |
 * 20150430 |                               2071 |
 * 20150501 |                               2765 |
 * 20150502 |                               2427 |
 * 20150503 |                               2693 |
 * 20150504 |                               2149 |
 * 20150505 |                               2158 |
 * 20150506 |                               2142 |
 * 20150507 |                               2206 |
 * 20150508 |                               2174 |
 * 20150509 |                               2318 |
 * 20150510 |                               2494 |
 * 20150511 |                               2144 |
 * 20150512 |                               2168 |
 * 20150513 |                               2040 |
 * 20150514 |                               2136 |
 * 20150515 |                               2008 |
 * 20150516 |                               2119 |
 * 20150517 |                               2317 |
 * 20150518 |                               1957 |
 * 20150519 |                               1988 |
 * 20150520 |                               1897 |
 * 20150521 |                               1869 |
 * 20150522 |                               1962 |
 * 20150523 |                               2145 |
 * 20150524 |                               2344 |
 * 20150525 |                               2002 |
 * 20150526 |                               1904 |
 * 20150527 |                               1818 |
 * 20150528 |                               1690 |
 * 20150529 |                               1702 |
 * 20150530 |                               1914 |
 * 20150531 |                               1863 |

select left(timestamp,6) as dt, count(distinct(event_appInstallID)) from MobileWikiAppToCInteraction_11014396 where timestamp > '201504' and timestamp < '201506' group by dt;

++-+ ++-+ ++-+
 * dt    | count(distinct(event_appInstallID)) |
 * 201504 |                              32986 |
 * 201505 |                              27386 |

Search
meta:Schema:MobileWikiAppSearch

Schema revision 10641988 available since 25-November-2014

Android logging: yes

iOS logging: implemented recently (forthcoming releases should generate higher numbers)

Sampling: 1%

select left(timestamp,8) as dt, case when userAgent like '%Android%' then 'Android' when userAgent like '%iPhone%' then 'iOS' else 'other' end as ua, count(distinct(event_appInstallID)) from MobileWikiAppSearch_10641988 where timestamp > '201504' and timestamp < '201506' group by dt, ua;

+--+-+-+ +--+-+-+ +--+-+-+
 * dt      | ua      | count(distinct(event_appInstallID)) |
 * 20150401 | Android |                               3902 |
 * 20150402 | Android |                               3951 |
 * 20150403 | Android |                               4467 |
 * 20150404 | Android |                               4628 |
 * 20150405 | Android |                               5123 |
 * 20150406 | Android |                               4727 |
 * 20150407 | Android |                               4305 |
 * 20150408 | Android |                               4356 |
 * 20150409 | Android |                               4205 |
 * 20150410 | Android |                               4184 |
 * 20150411 | Android |                               4491 |
 * 20150412 | Android |                               4906 |
 * 20150413 | Android |                               4302 |
 * 20150414 | Android |                               4247 |
 * 20150415 | Android |                               4118 |
 * 20150416 | Android |                               4207 |
 * 20150417 | Android |                               4541 |
 * 20150418 | Android |                               5204 |
 * 20150419 | Android |                               5662 |
 * 20150420 | Android |                               5104 |
 * 20150421 | Android |                               5060 |
 * 20150422 | Android |                               5013 |
 * 20150423 | Android |                               4566 |
 * 20150424 | Android |                               4648 |
 * 20150425 | Android |                               4801 |
 * 20150426 | Android |                               4986 |
 * 20150427 | Android |                               4559 |
 * 20150428 | Android |                               4408 |
 * 20150429 | Android |                               4712 |
 * 20150430 | Android |                               3673 |
 * 20150501 | Android |                               5058 |
 * 20150502 | Android |                               4946 |
 * 20150503 | Android |                               5390 |
 * 20150504 | Android |                               4492 |
 * 20150505 | Android |                               4617 |
 * 20150506 | Android |                               4558 |
 * 20150507 | Android |                               4572 |
 * 20150508 | Android |                               4615 |
 * 20150508 | iOS    |                                   1 |
 * 20150509 | Android |                               4876 |
 * 20150510 | Android |                               5172 |
 * 20150511 | Android |                               4620 |
 * 20150511 | iOS    |                                   1 |
 * 20150512 | Android |                               4623 |
 * 20150512 | iOS    |                                   4 |
 * 20150513 | Android |                               4507 |
 * 20150513 | iOS    |                                   7 |
 * 20150514 | Android |                               4618 |
 * 20150514 | iOS    |                                   9 |
 * 20150515 | Android |                               4539 |
 * 20150515 | iOS    |                                   4 |
 * 20150516 | Android |                               4707 |
 * 20150516 | iOS    |                                   4 |
 * 20150517 | Android |                               5133 |
 * 20150517 | iOS    |                                   2 |
 * 20150518 | Android |                               4447 |
 * 20150518 | iOS    |                                   7 |
 * 20150519 | Android |                               4191 |
 * 20150519 | iOS    |                                  12 |
 * 20150520 | Android |                               4225 |
 * 20150520 | iOS    |                                   8 |
 * 20150521 | Android |                               4293 |
 * 20150521 | iOS    |                                   6 |
 * 20150522 | Android |                               4326 |
 * 20150522 | iOS    |                                   5 |
 * 20150523 | Android |                               4796 |
 * 20150523 | iOS    |                                   4 |
 * 20150524 | Android |                               5079 |
 * 20150524 | iOS    |                                  16 |
 * 20150525 | Android |                               4724 |
 * 20150525 | iOS    |                                  33 |
 * 20150526 | Android |                               4500 |
 * 20150526 | iOS    |                                  27 |
 * 20150527 | Android |                               4432 |
 * 20150527 | iOS    |                                  30 |
 * 20150528 | Android |                               4181 |
 * 20150528 | iOS    |                                  30 |
 * 20150529 | Android |                               4104 |
 * 20150529 | iOS    |                                  33 |
 * 20150530 | Android |                               4547 |
 * 20150530 | iOS    |                                  32 |
 * 20150531 | Android |                               4617 |
 * 20150531 | iOS    |                                  31 |

select left(timestamp,6) as dt, case when userAgent like '%Android%' then 'Android' when userAgent like '%iPhone%' then 'iOS' else 'other' end as ua, count(distinct(event_appInstallID)) from MobileWikiAppSearch_10641988 where timestamp > '201504' and timestamp < '201506' group by dt, ua;

++-+-+ ++-+-+ ++-+-+
 * dt    | ua      | count(distinct(event_appInstallID)) |
 * 201504 | Android |                              40579 |
 * 201505 | Android |                              38189 |
 * 201505 | iOS    |                                 153 |

Click through ratio for a day
select count(*) from MobileWikiAppSearch_10641988 where timestamp > '20150531' and timestamp < '201506' and event_action = 'start';

+--+ +--+ +--+
 * count(*) |
 * 11929 |

Clicked:

select count(*) from MobileWikiAppSearch_10641988 where timestamp > '20150531' and timestamp < '201506' and event_action = 'click';

+--+ +--+ +--+
 * count(*) |
 * 10241 |

That's about an 85% clickthrough rate.

Other query examples that could be repurposed can be found at https://docs.google.com/spreadsheets/d/1syLgNygAS7Prxxg7RTIvK3vxwyVG-ZkjxtK0LSbU76w/edit#gid=0.

Saved Pages
meta:Schema:MobileWikiAppSavedPages

Schema revision 10375480 available since 31-October-2014

Android logging: yes

iOS logging: since approximately mid-April 2015

Sampling: 100%

select left(timestamp,8) as dt, case when userAgent like '%Android%' then 'Android' when userAgent like '%iPhone%' then 'iOS' else 'other' end as ua, count(distinct(event_appInstallID)) from MobileWikiAppSavedPages_10375480 where timestamp > '201504' and timestamp < '201506' group by dt, ua;

+--+-+-+ +--+-+-+ +--+-+-+
 * dt      | ua      | count(distinct(event_appInstallID)) |
 * 20150401 | Android |                              13364 |
 * 20150401 | iOS    |                                  11 |
 * 20150402 | Android |                              13344 |
 * 20150402 | iOS    |                                  11 |
 * 20150403 | Android |                              13868 |
 * 20150403 | iOS    |                                  22 |
 * 20150404 | Android |                              13554 |
 * 20150404 | iOS    |                                  10 |
 * 20150405 | Android |                              14755 |
 * 20150405 | iOS    |                                  11 |
 * 20150406 | Android |                              14966 |
 * 20150406 | iOS    |                                   8 |
 * 20150407 | Android |                              15377 |
 * 20150407 | iOS    |                                  15 |
 * 20150408 | Android |                              15701 |
 * 20150408 | iOS    |                                  14 |
 * 20150409 | Android |                              15367 |
 * 20150409 | iOS    |                                  14 |
 * 20150410 | Android |                              14471 |
 * 20150410 | iOS    |                                  19 |
 * 20150411 | Android |                              14491 |
 * 20150411 | iOS    |                                   9 |
 * 20150412 | Android |                              15175 |
 * 20150412 | iOS    |                                  11 |
 * 20150413 | Android |                              15706 |
 * 20150413 | iOS    |                                  10 |
 * 20150414 | Android |                              15973 |
 * 20150414 | iOS    |                                  38 |
 * 20150415 | Android |                              15856 |
 * 20150415 | iOS    |                                1377 |
 * 20150416 | Android |                              16119 |
 * 20150416 | iOS    |                                4532 |
 * 20150417 | Android |                              16919 |
 * 20150417 | iOS    |                                4315 |
 * 20150418 | Android |                              18499 |
 * 20150418 | iOS    |                                4626 |
 * 20150419 | Android |                              20481 |
 * 20150419 | iOS    |                                5386 |
 * 20150420 | Android |                              20842 |
 * 20150420 | iOS    |                                5348 |
 * 20150421 | Android |                              21310 |
 * 20150421 | iOS    |                                4885 |
 * 20150422 | Android |                              20976 |
 * 20150422 | iOS    |                                4730 |
 * 20150423 | Android |                              18778 |
 * 20150423 | iOS    |                                3949 |
 * 20150424 | Android |                              18483 |
 * 20150424 | iOS    |                                4124 |
 * 20150425 | Android |                              16405 |
 * 20150425 | iOS    |                                4121 |
 * 20150426 | Android |                              17144 |
 * 20150426 | iOS    |                                4256 |
 * 20150427 | Android |                              18412 |
 * 20150427 | iOS    |                                4158 |
 * 20150428 | Android |                              18228 |
 * 20150428 | iOS    |                                3897 |
 * 20150429 | Android |                              19710 |
 * 20150429 | iOS    |                                4386 |
 * 20150430 | Android |                              14825 |
 * 20150430 | iOS    |                                3100 |
 * 20150501 | Android |                              17820 |
 * 20150501 | iOS    |                                4446 |
 * 20150502 | Android |                              16323 |
 * 20150502 | iOS    |                                4338 |
 * 20150503 | Android |                              17526 |
 * 20150503 | iOS    |                                4919 |
 * 20150504 | Android |                              17187 |
 * 20150504 | iOS    |                                4407 |
 * 20150505 | Android |                              18295 |
 * 20150505 | iOS    |                                4489 |
 * 20150506 | Android |                              18623 |
 * 20150506 | iOS    |                                4560 |
 * 20150507 | Android |                              17773 |
 * 20150507 | iOS    |                                4343 |
 * 20150508 | Android |                              16797 |
 * 20150508 | iOS    |                                4228 |
 * 20150509 | Android |                              16134 |
 * 20150509 | iOS    |                                4612 |
 * 20150510 | Android |                              17524 |
 * 20150510 | iOS    |                                5046 |
 * 20150511 | Android |                              17897 |
 * 20150511 | iOS    |                                4604 |
 * 20150512 | Android |                              18058 |
 * 20150512 | iOS    |                                4577 |
 * 20150513 | Android |                              17742 |
 * 20150513 | iOS    |                                4969 |
 * 20150514 | Android |                              17508 |
 * 20150514 | iOS    |                                5468 |
 * 20150515 | Android |                              16128 |
 * 20150515 | iOS    |                                4702 |
 * 20150516 | Android |                              15282 |
 * 20150516 | iOS    |                                4648 |
 * 20150516 | other  |                                   1 |
 * 20150517 | Android |                              16804 |
 * 20150517 | iOS    |                                5195 |
 * 20150518 | Android |                              16453 |
 * 20150518 | iOS    |                                4548 |
 * 20150519 | Android |                              14227 |
 * 20150519 | iOS    |                                3734 |
 * 20150520 | Android |                              15539 |
 * 20150520 | iOS    |                                4427 |
 * 20150521 | Android |                              16582 |
 * 20150521 | iOS    |                                4550 |
 * 20150522 | Android |                              15546 |
 * 20150522 | iOS    |                                4253 |
 * 20150523 | Android |                              15015 |
 * 20150523 | iOS    |                                4670 |
 * 20150524 | Android |                              16248 |
 * 20150524 | iOS    |                                5153 |
 * 20150525 | Android |                              16157 |
 * 20150525 | iOS    |                                4890 |
 * 20150526 | Android |                              17088 |
 * 20150526 | iOS    |                                4710 |
 * 20150527 | Android |                              16826 |
 * 20150527 | iOS    |                                4571 |
 * 20150528 | Android |                              16422 |
 * 20150528 | iOS    |                                4461 |
 * 20150529 | Android |                              15182 |
 * 20150529 | iOS    |                                4318 |
 * 20150530 | Android |                              15085 |
 * 20150530 | iOS    |                                4615 |
 * 20150531 | Android |                              14615 |
 * 20150531 | iOS    |                                4762 |

select left(timestamp,6) as dt, case when userAgent like '%Android%' then 'Android' when userAgent like '%iPhone%' then 'iOS' else 'other' end as ua, count(distinct(event_appInstallID)) from MobileWikiAppSavedPages_10375480 where timestamp > '201504' and timestamp < '201506' group by dt, ua;

++-+-+ ++-+-+ ++-+-+
 * dt    | ua      | count(distinct(event_appInstallID)) |
 * 201504 | Android |                             268095 |
 * 201504 | iOS    |                               51105 |
 * 201505 | Android |                             257902 |
 * 201505 | iOS    |                               94940 |
 * 201505 | other  |                                   1 |

Image Gallery
meta:Schema:MobileWikiAppMediaGallery

Schema revision 10923135 available since 9-January-2015

Android logging: yes

iOS logging: no

Sampling: 100

select left(timestamp,8) as dt, case when userAgent like '%Android%' then 'Android' when userAgent like '%iPhone%' then 'iOS' else 'other' end as ua, count(distinct(event_appInstallID)) from MobileWikiAppMediaGallery_10923135 where timestamp > '201504' and timestamp < '201506' group by dt, ua;

+--+-+-+ +--+-+-+ +--+-+-+
 * dt      | ua      | count(distinct(event_appInstallID)) |
 * 20150401 | Android |                              78426 |
 * 20150402 | Android |                              79490 |
 * 20150403 | Android |                              90718 |
 * 20150404 | Android |                              95054 |
 * 20150405 | Android |                             105564 |
 * 20150406 | Android |                              95671 |
 * 20150407 | Android |                              81753 |
 * 20150408 | Android |                              80812 |
 * 20150409 | Android |                              80294 |
 * 20150410 | Android |                              78739 |
 * 20150411 | Android |                              91069 |
 * 20150412 | Android |                              99451 |
 * 20150413 | Android |                              81556 |
 * 20150414 | Android |                              78439 |
 * 20150415 | Android |                              76866 |
 * 20150416 | Android |                              78319 |
 * 20150417 | Android |                              87169 |
 * 20150418 | Android |                             106335 |
 * 20150419 | Android |                             119175 |
 * 20150420 | Android |                             101164 |
 * 20150421 | Android |                              99037 |
 * 20150422 | Android |                              99451 |
 * 20150423 | Android |                              89661 |
 * 20150424 | Android |                              95515 |
 * 20150425 | Android |                             101072 |
 * 20150426 | Android |                             106084 |
 * 20150427 | Android |                              93318 |
 * 20150428 | Android |                              88085 |
 * 20150429 | Android |                              97892 |
 * 20150430 | Android |                              71918 |
 * 20150501 | Android |                             113034 |
 * 20150502 | Android |                             108558 |
 * 20150503 | Android |                             119564 |
 * 20150504 | Android |                              97713 |
 * 20150505 | Android |                              97414 |
 * 20150506 | Android |                              94754 |
 * 20150507 | Android |                              95370 |
 * 20150508 | Android |                              95305 |
 * 20150509 | Android |                             106979 |
 * 20150510 | Android |                             115923 |
 * 20150511 | Android |                              96888 |
 * 20150512 | Android |                              94369 |
 * 20150513 | Android |                              92532 |
 * 20150514 | Android |                             100016 |
 * 20150515 | Android |                              94499 |
 * 20150516 | Android |                             103576 |
 * 20150517 | Android |                             115159 |
 * 20150518 | Android |                              93848 |
 * 20150519 | Android |                              89115 |
 * 20150520 | Android |                              89161 |
 * 20150521 | Android |                              89807 |
 * 20150522 | Android |                              87998 |
 * 20150523 | Android |                             105810 |
 * 20150524 | Android |                             114121 |
 * 20150525 | Android |                             102855 |
 * 20150526 | Android |                              93849 |
 * 20150527 | Android |                              89968 |
 * 20150528 | Android |                              89061 |
 * 20150529 | Android |                              87549 |
 * 20150530 | Android |                              99647 |
 * 20150531 | Android |                             104623 |

(following query skips checks for type of userAgent as they’re all Android) select left(timestamp,6) as dt, count(distinct(event_appInstallID)) from MobileWikiAppMediaGallery_10923135 where timestamp > '201504' and timestamp < '201506' group by dt;

++-+ ++-+ ++-+
 * dt    | count(distinct(event_appInstallID)) |
 * 201504 |                            1509562 |
 * 201505 |                            1604548 |

Share a Fact
Previous data were communicated on mobile-l about the Share a Fact feature.