Mobile-l August 2016

mobile-l@lists.wikimedia.org

27 participants
23 discussions

[Apps] Android Wikipedia beta app release (2.3.151-beta-2016-08-17)
by Stephen Niedzielski 18 Aug '16

18 Aug '16

The Android team[0] is pleased to announce a new Wikipedia Android app beta release, v2.3.151-beta-2016-08-17[1]. This revision contains the following new functionality[2]: - New button for direct access to open article tabs from the Explore feed - Tabs button now shows number of active tabs - Cards dismissed from the Explore feed are now remembered between sessions - Miscellaneous bug fixes Included in this version are patches from repeat contributor Dan Garry[3]. Way to go Dan! You too can help make it better! Read our getting started guide[4]. We can't wait for your contributions! -The WMF Android team [0] https://www.mediawiki.org/wiki/Wikimedia_Apps/Team#Android_App [1] Rolling out at https://play.google.com/store/apps/details?id=org.wikipedia.beta [2] A complete list of changes is available at https://phabricator.wikimedia.org/diffusion/APAW/history/master/;beta/2.3.1… [3] IRC: Deskana, https://twitter.com/danjgarry [4] https://www.mediawiki.org/wiki/Wikimedia_Apps/Team/Wikipedia_Android_app_ha…

1 0

mobile-l：如何成为销售冠军？w1d
by qirzzwufw 17 Aug '16

17 Aug '16

mobile-l：您好！如何成为业务冠军，如何得业绩得天下。。。更多精彩内容，请查阅附件。。。 2016-8-171:58:00

1 0

iOS 5.0.6 released to store, 5.1.0 released to beta
by Joshua Minor 16 Aug '16

16 Aug '16

Hello mobile Wikimedians, This morning the WMF's iOS App team released an update to the Wikipedia app for iOS. This is a minor update to continue to improve stability and performance, especially for users with large libraries of saved articles. We also fixed minor issues with language switching for search, added more informative crash logging, and fixed hieroglyphics in articles. Again, major thanks to our beta testers and crash reporters who helped us diagnose our remaining issues. *Download the update from the app store now[1]!* Speaking of beta testers, we also pushed our first beta of our next major update to testers late on Friday. Version 5.1.0 includes improved design for larger screens on the Explore feed and article reader. It also *adds Find in Page* to the article toolbar, our most frequently requested feature! If you are already a beta tester, please check it out on TestFlight, especially if you are an iPad or iPhone Plus user. If you are not a beta tester, please sign up here, and you'll be added for our next beta update[2]. Thanks, Wikimedia iOS app team [1] - https://itunes.apple.com/us/app/wikipedia/id324715238?mt=8 [2] - https://docs.google.com/forms/d/e/1FAIpQLSfW7zFnUDYABvHLWlFclZ7OJEK82WjVIjs…

1 0

mobile-l:HR最棘手的十类核心问题及解决方案？02512
by hidqrri 15 Aug '16

15 Aug '16

HR最棘手的十类60个核心问题及解决方案 2016年 8月17日上海--东锦江希尔顿逸林酒店学习费用：3500 （含发票，教材，午餐及上下午茶点）学习对象：企业人力资源部门专业人士；企业法务部门专业人士咨询热线：021-31006787, 18917870808 许先生微信、QQ：320588808 【Training Background|课程背景】随着员工维权意识的觉醒，HR普遍感觉劳动关系的处理越来越难了，各种各样新的问题层出不穷，如续订无固定条件双方协商不一致？单位调岗员工拒绝？员工泡病假对抗公司管理、员工不辞而别？公司因经营需要不再需要该员工？由于大量的实务问题在劳动法规中并不能找到正确答案，劳动法的属地化特征又使得各地的司法裁判口径差异极大，极大地增加了企业处理员工关系的难度。 ICH将邀请有丰富实践经验的法律专家洪桂彬律师，梳理出员工管理中十大类型最核心的60个问题，通过亲自办理的大量案例演绎，深入解析劳动合同的解除误区、技巧、补偿成本控制等，分享新形势下员工关系管理的疑难杂症及处理对策，提高企业解雇的安全性与灵活性。【Outline Content|大纲内容】一、入职管理棘手问题 1．入职资料不齐（如无离职证明），急于用工如何办理入职手续？ 2．已发offer,但体检不合格能否取消录用？ 3．因项目取消岗位撤销能否撤回已发的offer? 4．员工须遵守原单位竞业限制义务，如何办理入职手续？ 5．原单位社保不退，公司办入职有何风险？二、试用期管理棘手问题 1．试用期如何明确考核机制？没有约定录用条件是否只能劝退？ 2．试用期发现入职前已怀孕，能否以违反诚信解聘？ 3．试用期不符合录用条件如何证明？ 4．试用期大部分时间在泡病假怎么办，能否将试用期出勤天数作为录用条件？ 5．试用期可否经双方协商一致延长？劳动关系转移至关联企业能否重设试用期？三、工时加班管理棘手问题 1．合同约定标准工时，后审批不定时是否要变更合同？ 2．合同约定不定时，但没审批或审批已过期不定时是否仍然有效？ 3．综合工时加班费如何计算？能否跨周期调休？周期内提前离职如何核算加班？ 4．平时加班执行1:1调休是否合法？员工事后能否主张1.5倍加班费？ 5．公司执行调休6个月内未申请自动作废是否有效？ 6．不定时工时制度人员如何认定旷工？ 7．加班费计算基数如何确定？固定发放的津贴补贴奖金能否作为基数？合同约定或规章制度规定加班费基数是否可行？四、休假管理棘手问题 1．年休假逾期未申请自动作废是否有效？ 2．新员工入职第1年是否有年休假？工龄如何审查？ 3．员工病假流程不合规如材料不齐可否算旷工？可否要求制定医院复查？ 4．员工享受哺乳假的条件，产后抑郁能否申请哺乳假？ 5．员工工作地和合同签订地不一致，适用何地的休假规定？五、社保管理棘手问题 1．异地代缴社保是否合法？如何规避？ 2．社保缴费基数不对员工能否要去离职补偿金？ 3．因原单位未退保新单位发生工伤怎么办？六、工资奖金提成管理棘手问题 1．凭票报销的津贴补贴是否属于工资？ 2．年终奖提前离职不享受是否有效？ 3．员工工作满1年但年终考核前离职是否可享受年终奖？ 4．员工提起离职不享受提成是否合法？合同已签销售回款未到账可否拒发提成？七、调岗调薪、搬迁、考核奖惩棘手问题 1．工作地点变更如何处理？员工以离家远增加路途时间拒绝怎么办？ 2．拒绝同级别的岗位调整可否违纪处分？合同已约定公司有权调岗事后还需员工同意吗？ 3．不胜任调岗可否降薪？降薪的幅度如何确定？调岗合理性如何判断？员工实际从事新岗位职责但拒绝签署转岗协议怎么办？ 4．增加工作量，增加或缩小部分工作职责、临时外派是否需要员工同意？ 5．员工拒绝在警告信上签字怎么办？如何预防快递被退回？ 6．考核表必须员工签字吗？考核分数单位是否有单方判断权？八、合同终止续订棘手问题 1．合同到期终止是否需要提前1个月通知员工？ 2．合同因各种原因过期，过期后还能以不续订为由终止原合同吗？ 3．两次合同到期后员工拒绝续订固定合同，公司可否终止？ 4．工作满10年员工未提出续订无固定，单位可否终止？ 5．员工在续订意见表上表态同意续订固定合同，但事后反悔要求无固定怎么办？ 6．因双方就新合同的岗位薪酬协商不一致，单位能否终止合同？九、员工离职棘手问题 1．员工不辞而别且无法联系怎么办？可否视为自动离职？ 2．员工辞职不提前30天通知或者交接不完整，可否暂缓办理退工手续暂扣末月工资？ 3．协商解除签约日和离职日不一致，员工患病、怀孕、工伤怎么办？ 4．严重违纪如何证明？应当固定那些证据？ 5．不胜任解除如何进行培训或调岗，员工拒绝培训调岗如何处理？ 6．医疗期满解除是否必须进行劳动能力鉴定？抑郁症是否有24个月医疗期？ 7．部门撤销、岗位精简能算客观情况发生重大变化吗？没有岗位提供如何协商变更合同？ 8．经济性裁员劳动局不给备案回执怎么办？何为经营发生严重困难？ 9．单方解除如何通知工会？没工会是否必须通知上级工会？ 10．公司违法解除赔偿金如何计算？ 11．HR如何汇报违法解除风险？ 12．经济补偿金计算基数如何计算，高温费、凭票报销的津贴、加班费算吗？ 13．经济补偿金何时分段计算？何时无需分段计算？ 14．代通知金、医疗补助费和补偿金是否同享一个基数？十、离职后管理棘手问题 1．员工一直不来领取劳动手册公司是否有风险？ 2．离职时如何免除员工竞业限制义务，何时通知最妥？ 3．违反竞业限制义务如何调查？ 4．员工离职后主张恢复劳动关系怎么办？ 5．离职员工来公司闹事威胁同事怎么办？注：如不需此类信件信息，请发送“删除”至tuiding02(a)163.xn--com,,!-lz8iim437ak8m1ouv1dosqb41cca123hy29fvpia

1 0

[KIWIX] for iOS 1.7 released
by Emmanuel Engelhart 14 Aug '16

14 Aug '16

Hi Last week we have released the version 1.7! What's new? * Informative bookmarks * New add / remove bookmarks interface * Bookmarks Today Widget * Bug fixes and performance improvements Here is a small roadmap of the features we want to implement next https://gist.github.com/automactic/53d62c09d56d0707936c1a82920c6b0a Regards Emmanuel -- Kiwix - Wikipedia Offline & more * Web: http://www.kiwix.org * Twitter: https://twitter.com/KiwixOffline * more: http://www.kiwix.org/wiki/Communication

1 0

Wiki Conference India 2016 (Chandigarh hackathon)
by Santosh Shingare 12 Aug '16

12 Aug '16

Hello all, I am happy to announce, chandigarh hackathon WCI2016, close with 7 application, which is useful to all community. *1)* *WikiSpeak with native language :* (Hindi) (*Web Application* + *Android Mobile application*). *2)* *Edit Tamil Wiktionary **(Tamil community request)** :* - (*Android application*) *3)* *Audio file upload to WikiData (Punjabi community request) :* (*Android application*) *4) Wikipedia articles on google map :* find wikipedia articles on google map (with latitude and longitude) as per city. *5) OCR (Native Application) *: Convert scanned book copy to Indian language text with google doc (Tested for Hindi and Malayalam). *6) Communication platform[WebRTC] (Web Application)* : Community used this to talk or conference (Audio/video web conferencing application) *7) Notification (Event based)* : showing popup on event eg (If recent changes happen, It will show popup which article was updated) Thank you all participant. who participate in hackathon and deliver a big success *Note : I will share code, links and other details very shortly.* Thank you *Santosh Shingare.* *User:cherishsantosh*

1 0

Language switching improvements on mobile web
by Jon Katz 12 Aug '16

12 Aug '16

Hey Everyone, A big shout out to the reading web team (and Adam B), who rolled out a number of subtle, but important changes to the mobile web sites of all our projects earlier this week. Through a series of UX improvements, the team made it easier for people to switch between languages in an article on mobile web. To all you monolinguists out there, this is a very common and vital ability for people who speak more than one language. In addition to being a big improvement for our multi-lingual users, the development of this feature followed many of the best practices we aspire to at the foundation: - language switching on mobile initially discovered as a problem to be solved through quantitative research - tied to reading team's early strategic objective of better serving global readers - development stages included: - community consultation <https://www.mediawiki.org/wiki/Reading/Web/Projects/Improve_in-article_lang…> - iteration based on results - a/b testing and analysis in beta - qualitative research with live users <https://docs.google.com/a/wikimedia.org/presentation/d/1gbqV0fDHUDJjDZgYNDY…> - iteration based on results - collaboration with the language team (they are simultaneously rolling out compact language links <https://www.mediawiki.org/wiki/Universal_Language_Selector/Design/Interlang…> out of beta on desktop) - iteration based on collaboration Am I missing anything? More on the project here <https://www.mediawiki.org/wiki/Reading/Web/Projects/Improve_in-article_lang…> and a screenshot of the new language switching button is below Best, J

1 0

Fwd: The Wikimedia Research Newsletter 6(7) is out
by Tilman Bayer 11 Aug '16

11 Aug '16

Forwarding, as the reviewed paper on wikilinks and navigability might be of interest to this list too. ---------- Forwarded message ---------- From: Mohammed Sadat <masssly(a)ymail.com> Date: Wed, Aug 10, 2016 at 6:22 AM Subject: The Wikimedia Research Newsletter 6(7) is out To: Wikimedia Research Mailing List <wiki-research-l(a)lists.wikimedia.org> Cc: Tilman Bayer <tbayer(a)wikimedia.org>, Dario Taraborelli < dtaraborelli(a)wikimedia.org> The July 2016 issue of the Wikimedia Research Newsletter is out: https://blog.wikimedia.org/2016/08/10/research-newsletter-july-2016/ https://meta.wikimedia.org/wiki/Research:Newsletter/2016/July In this issue: 1 Making it easier to navigate within article networks via better wikilinks 2 Briefly 2.1 New research journal about Wikipedia and higher education 2.2 Conferences and events *** 19 recent publications were covered or listed in this issue *** Thanks to Jonathan Morgan for contributing. Masssly, Tilman Bayer and Dario Taraborelli --- Wikimedia Research Newsletter https://meta.wikimedia.org/wiki/Research:Newsletter/ * Follow us on Twitter: @WikiResearch <http://twitter.com/Wikiresearch> * Receive this newsletter by mail: https://lists.wikimedia.org/mailman/listinfo/research-newsletter * Subscribe to the RSS feed: http://blog.wikimedia.org/c/research-2/wikimedia-research-newsletter/feed/ -- Tilman Bayer Senior Analyst Wikimedia Foundation IRC (Freenode): HaeB

1 0

Readership metrics for the timespan until July 31, 2016
by Tilman Bayer 10 Aug '16

10 Aug '16

Hi all, this resumes the usual look <https://www.mediawiki.org/wiki/Reading/Readership_metrics_reports> at our most important readership metrics. This edition of the report introduces a new year-over-year comparison chart to better understand which traffic changes are seasonal, and highlights a recent browser-related issue that has, suddenly and probably artificially, increased our global usage by 11%. We also take a first look of how the ratio of pageviews per device has been developing over time, and point out some other events that had an impact on core metrics. As laid out earlier <https://lists.wikimedia.org/pipermail/mobile-l/2015-September/009773.html>, the main purpose is to raise awareness about how these are developing, call out the impact of any unusual events, and facilitate thinking about core metrics in general. As always; feedback and discussion welcome. Week-over-week and month-over-month changes are now being recorded on the Product page <https://www.mediawiki.org/wiki/Wikimedia_Product#Reading> at MediaWiki.org. This edition of the report covers a timespan of 14 weeks. Some other recent items of interest, in case they didn’t already catch your attention: - The WMF Reading team published its quarterly review presentation for Q4 2015-16 (April-June), which includes lots of traffic and usage data <https://commons.wikimedia.org/w/index.php?title=File:Reading_Quarterly_Revi…> . - I gave an update on long-term traffic trends at the Foundation’s metrics meeting in May, see slides <https://commons.wikimedia.org/w/index.php?title=File%3AWMF_Metrics_%26_Acti…> (and will again later this month). Now to the usual data. (All numbers below are averages for April 25-July 31, 2016 unless otherwise noted.) Pageviews Total: 511 million/day (-5.0% from the previous report) Context (April 2015-July 2016): <https://commons.wikimedia.org/wiki/File:Wikimedia_daily_pageviews,_all_vs._…> See also the Vital Signs dashboard <https://analytics.wikimedia.org/dashboards/vital-signs/#projects=all/metric…> (Small caveat: Android app pageviews in April and early May were undercounted by up to 1-2 million/dayl due to a bug <https://phabricator.wikimedia.org/T132965>.) Overall pageviews developed relatively uneventfully during the timespan of this report until around July 20, when the desktop traffic to the main pages of several large Wikipedias (including English, Russian and Dutch) suddenly increased drastically. The investigation <https://phabricator.wikimedia.org/T141506> is still ongoing. At this point though it seems likely that this is not due an undetected spider or such, but caused by browsers of real users behaving in an unusual way, namely an old version of Chrome on Windows. Overall pageviews for all projects appear to have increased around 11% due to this. To improve our understanding of which traffic movements are seasonal and which may indicate lasting changes, I have pieced together a chart overlaying the total pageview numbers back to May 2013 (the earliest time for which we have data according to the current pageview definition): <https://commons.wikimedia.org/wiki/File:Wikimedia_pageviews_year-over-year_…> For example, we talked before about how the large year-over-year decrease seen in earlier months (e.g. -11.9% from April 2015 to April 2016) could probably be attributed to two one-time events in May/June 2015: the switch to HTTPS-only connections and the block of the Chinese Wikipedia in China. At the time this was based on more indirect evidence, in particular changes in the ratio of pageviews from the Global North. Now that a year has passed, we can directly compare data from after these events year-over-year. It confirms that conclusion (in the chart, compare the red line against the other three on the left hand side). In July 2016 there actually was a 1.1% increase compared to July 2015. Of course this is partly due to the aforementioned main pages anomaly, which is also visible clearly in this chart. Desktop: 54.1% (previous report: 55.2%) Mobile web: 44.6% (previous report: 43.6%) Apps: 1.3% (previous report: 1.2%) (small caveat: app percentage is a bit too low due to the aforementioned Android-related bug in April/May) Context (April 2015-July 2016): <https://commons.wikimedia.org/wiki/File:Wikimedia_daily_pageviews,_mobile_p…> After largely stagnating earlier this year following the christmas bump, the mobile percentage started to rise again towards parity around May (reaching 48.6% in the week until July 11). However, the recent anomalously high main pages traffic described above was entirely on desktop and has thus, perhaps temporarily, brought this percentage down again (to 42.7% in the week until July 31). As a reminder, mobile already has a solid majority in terms of unique devices, cf. below. Global North ratio: 75.5% of total pageviews (previous report: 76.5%) Context (last seven months): After a notable decrease (or, increase in the Global South ratio) at the beginning of the year, this number was relatively steady over the timespan of this report. NB: We are currently rethinking this metric and might replace it with a different country selection constructed as part of the work on the New Readers project. Unique devices See the announcement blog post <https://blog.wikimedia.org/2016/03/30/unique-devices-dataset/> from March for background and details on this recently introduced metric. These estimated numbers are provided for all Wikimedia language projects (separately for the desktop and mobile web version). Because of the instrumentation method, there is no global metric for all projects and all languages, but following some recent discussions it is now planned <https://phabricator.wikimedia.org/T138027> to extend it to a cross-language global metric per project at least. For now, we track the daily numbers of the English Wikipedia in this report. Daily unique devices estimate for English Wikipedia: - Mobile web: 32.2 million (previous report: 33.2 million) - Desktop: 22.3 million (previous report: 25.7 million) - Total: 54.5 million (previous report: 58.9 million) - Average mobile web ratio: 59.3% (previous report: 56.5%) Context (January-August 2016): See also the new Vital Signs dashboard <https://analytics.wikimedia.org/dashboards/vital-signs/#projects=enwiki/met…> As mentioned in the previous report, there was a drop in early to mid March which hasn’t seen an explanation so far. This metric hasn’t existed long enough yet to get a good sense of what yearly seasonalities may exist, but it looks a bit like a decreasing trend in desktop devices during these seven months. Interestingly though, pageviews did not decrease as much. Or to put it differently, pageviews per device rose during this time (even if one disregards the aforementioned main page increase since the end of July): <https://commons.wikimedia.org/wiki/File:Daily_views_per_unique_device_for_E…> New app installations Android:19.7k/day (-37.7% from the previous report) Daily installs per device, from Google Play Context (last six months): As described in the previous report, in March a Google bug had accidentally increased visitor number to the app’s Play Store listing enormously (spike cut off in this chart). So this it’s not surprising that the average install rate over the timespan of this report is much lower. Even disregarding this factor though, the install rates have been decreasing over the last few months and are matched by uninstalls on most days (except for a bump during two weeks in July whose reason is unknown to me). Combined with devices going inactive etc. this has meant that the app’s install base has been shrinking, from from 15.5 million on March 31 to 15.1 million today. On July 28, an updated version of the app with several exciting new features was launched, with a blog post <https://blog.wikimedia.org/2016/07/28/wikipedia-android-redesign/> that had very high pageview numbers and was picked up by media outlets in various countries. Unfortunately this public attention has not translated into a lot of downloads - we estimate around 3000 (a few hours’ worth at the normal rate). In comparison, the relaunch of the OS app in March brought roughly 50k additional installs (see previous report). iOS: 3.18 k/day (-37.2% from the previous report) Download numbers from App Annie Context (last six months): As mentioned, the iOS app’s huge relaunch fell into the timespan of the previous report, so the decrease here is not surprising. App user retention Android: 16.7% (previous report: 15.4%) (Ratio of app installs opened again 7 days after installation, among all installed one week before a date that falls within this report. 1:100 sample) Context (last six months): As remarked in earlier reports, this data is a bit too noisy for drawing conclusions about whether retention changed significantly between different releases. But we can at least rule out the existence of major shifts during this timespan. iOS: N/A <https://phabricator.wikimedia.org/T126693> Unique app users Android: 1.145 million / day (-5.0% from the previous report timespan, reconstructed <https://phabricator.wikimedia.org/T132965>) Context (last six months): Continuing the slight but steady decline that had been interrupted by the aforementioned Google bug windfall in March. iOS: N/A <https://phabricator.wikimedia.org/T130432> While we don’t have total active user numbers available for the iOS app any more, let’s mention an interesting increase that happened in the app’s pageviews back in May, by around 20%. (Because of the app’s small share in overall traffic, it did not affect the global pageviews discussed above in a notable way.) After some investigation, it turned out this coincided with the release of version 5.0.3 of the app, see the yellow slice on the right: Josh and I are planning to look further into possible causes; at the moment it’s still possible that this is either an artefact or due to real improvements in the app. ---- For reference, the queries and source links used are listed below (access is needed for each). Unless otherwise noted, all content of this report is © Wikimedia Foundation and released under the CC BY-SA 3.0 <https://creativecommons.org/licenses/by-sa/3.0/> license. Most of the above charts are available on Commons, too <https://commons.wikimedia.org/w/index.php?title=Special:ListFiles&offset=20…>; together with PDF versions of this report. 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>0 AND agent_type = 'user' GROUP BY year, month, day ORDER BY year, month, day LIMIT 1000; SELECT LEFT(timestamp, 10) AS date, sum(IF(access_method <> 'desktop', pageviews, null)) AS mobileviews, SUM(pageviews) AS allviews FROM staging.pageviews05 WHERE is_spider = FALSE AND is_automata = FALSE GROUP BY date; SELECT access_method, SUM(view_count)/(7*14) FROM wmf.projectview_hourly WHERE agent_type = 'user' AND CONCAT(year,"-",LPAD(month,2,"0"),"-",LPAD(day,2,"0")) BETWEEN "2016-04-25" AND "2016-07-31" GROUP BY access_method; SELECT year, month, day, CONCAT(year,"-",LPAD(month,2,"0"),"-",LPAD(day,2,"0")), SUM(view_count) AS all, 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)) AS Global_North_views FROM wmf.projectview_hourly WHERE year > 0 AND agent_type='user' GROUP BY year, month, day ORDER BY year, month, day LIMIT 1000; https://console.developers.google.com/storage/browser/pubsite_prod_rev_0281… (“overview”) https://www.appannie.com/dashboard/252257/item/324715238/downloads/ (select “Total”) SELECT LEFT(timestamp, 8) AS date, SUM(IF(event_appInstallAgeDays = 0, 1, 0)) AS day0_active, SUM(IF(event_appInstallAgeDays = 7, 1, 0)) AS day7_active FROM log.MobileWikiAppDailyStats_12637385 WHERE userAgent LIKE '%-r-%' AND userAgent NOT LIKE '%Googlebot%' GROUP BY date ORDER BY DATE; (with the retention rate calculated as day7_active divided by day0_active from seven days earlier, of course) 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'; SELECT year, month, day, CONCAT(year,'-',LPAD(month,2,'0'),'-',LPAD(day,2,'0')) AS date, CONCAT(SPLIT(user_agent_map['wmf_app_version'], '\\.')[0], COALESCE( CONCAT('.', SPLIT(user_agent_map['wmf_app_version'], '\\.')[1]), ''), COALESCE( CONCAT('.', SPLIT(user_agent_map['wmf_app_version'], '\\.')[2]), '')) AS app_version, SUM(view_count) AS views FROM wmf.pageview_hourly WHERE year >0 AND access_method = 'mobile app' AND user_agent_map['os_family'] = 'iOS' AND agent_type = 'user' GROUP BY year, month, day, user_agent_map['wmf_app_version'] ORDER BY year, month, day, app_version LIMIT 20000; -- Tilman Bayer Senior Analyst Wikimedia Foundation IRC (Freenode): HaeB

2 2

Reading team updates from last quarter and planning for next quarter
by Moushira Elamrawy 10 Aug '16

10 Aug '16

Good day everyone, Planning for the next quarter is coming soon, if you have relevant ideas that the reading team <https://www.mediawiki.org/wiki/Reading> can consider to work on for the upcoming 3 months, please add them to the page here <https://www.mediawiki.org/wiki/Reading/Quarterly_planning/FY2016-2017/Q2>[0]. The page has archives for quarterly planning from previous months, and you can review ideas from last quarter here <https://www.mediawiki.org/wiki/Reading/Quarterly_planning/FY2016-2017/Q1> [1] There is also a summary for Reading team updates during the last quarte <https://www.mediawiki.org/wiki/Reading_team_updates_April_2016_-_July_2016>r [2], major highlights include, a) Lazy loading of images <https://www.mediawiki.org/wiki/Reading/Web/Projects/Performance/Lazy_loadin…>,[3] b) new readers <https://meta.wikimedia.org/wiki/New_Readers>,[4] c) and the move of the language switching button on mobile. Hope that was helpful, looking forward to your ideas and input! Regards, Moushira [0] https://www.mediawiki.org/wiki/Reading/Quarterly_planning/FY2016-2017/Q2 [1] https://www.mediawiki.org/wiki/Reading/Quarterly_planning/FY2016-2017/Q1 [2] https://www.mediawiki.org/wiki/Reading_team_updates_April_2016_-_July_2016 [3] https://www.mediawiki.org/wiki/Reading/Web/Projects/Performance/Lazy_loadin… [4] https://meta.wikimedia.org/wiki/New_Readers

3 2

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

Mobile-l August 2016