Wikitech-l December 2016

wikitech-l@lists.wikimedia.org

83 participants
84 discussions

Notes on creating a RTL-accessible tool in MediaWiki
by Leszek Manicki 14 Dec '16

14 Dec '16

Hi all! When developing the Revision Slider extension [1] earlier this year, we (at Wikimedia Germany) have learned quite some things about making extensions and gadgets accessible for RTL language users. We have just published the write up [2] summarizing what we've discovered. We hope people developing new and existing tools, and in general developers sensitive to RTL accessibility issues will find these notes interesting and/or helpful. Any comments are welcome! [1] https://www.mediawiki.org/wiki/Extension:RevisionSlider [2] https://www.mediawiki.org/wiki/Extension:RevisionSlider/Developing_a_RTL-ac… Best, -- Leszek Manicki Software Developer Wikimedia Deutschland e. V. | Tempelhofer Ufer 23-24 | 10963 Berlin Phone: +49 (0)30 219 158 26-0 http://wikimedia.de Imagine a world, in which every single human being can freely share in the sum of all knowledge. That‘s our commitment. Wikimedia Deutschland - Gesellschaft zur Förderung Freien Wissens e. V. Eingetragen im Vereinsregister des Amtsgerichts Berlin-Charlottenburg unter der Nummer 23855 B. Als gemeinnützig anerkannt durch das Finanzamt für Körperschaften I Berlin, Steuernummer 27/029/42207.

2 1

Re: [Wikitech-l] [Analytics] Readership metrics for the timespan until December 4, 2016
by Olga Vasileva 14 Dec '16

14 Dec '16

Thanks Zareen, it's great to see so much in-depth data! Also, it answers so many questions and curiosities from the past few months. - Olga On Wed, Dec 14, 2016 at 1:15 PM Caitlin Cogdill <ccogdill(a)wikimedia.org> wrote: > Yes, thanks so much for sharing this! It's fascinating and encouraging to > see the November impressions bump. > > On Wed, Dec 14, 2016 at 11:12 AM, Toby Negrin <tnegrin(a)wikimedia.org> > wrote: > > Thank you so much for this Zareen! It's really great to see this report -- > so much interesting data to think about! > > -Toby > > On Mon, Dec 12, 2016 at 5:45 PM, Zareen Farooqui <zareenf(a)gmail.com> > wrote: > > Hi all, > > This resumes the usual look > <https://www.mediawiki.org/wiki/Reading/Readership_metrics_reports> at > our most important readership metrics. This time we can report that daily > pageviews are up 4.8% (since the last report), with an interesting recent > peak which meant that November’s pageviews surpassed those of November 2015 > (coincidentally also) by 4.8%, after October had already seen a 2.1% > year-over-year increase. The iOS Wikipedia app saw increased downloads, > while the Android app’s install base has stopped its previous downward > trend. > > 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 metrics 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 eighteen > 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 > <https://commons.wikimedia.org/wiki/File:Reading_and_Comm_Tech_Quarterly_Rev…> > for Q1 2016-17 (July-September), which includes lots of traffic and usage > data. > - > > At the Foundation’s August metrics meeting > <https://commons.wikimedia.org/w/index.php?title=File%3AAugust_2016_Monthly_…>, > the Reading team gave an update on longer-term traffic trends since 2013. > (TL;DR: Overall pageviews have been flat to slightly declining, mobile has > been steadily rising but recently slowed down, desktop has declining during > these three years. However, total pageviews have been slightly increasing > year-over-year in the last few months.) See the chart below, updated with > data until November: > > [image: Wikimedia monthly pageviews (desktop+mobile), 2013-2016 (version > December 2016).png] > > In particular, as mentioned, the number of total pageview saw > year-over-year increases of +2.1% for October and +4.8% in November, in > contrast to e.g. the -10.5% we had for May 2015-May 2016. > > Now to the usual data. (All numbers below are averages for August > 1-December 4, 2016 unless otherwise noted.) > > Pageviews > > Total: 529 million/day (+4.76% from the previous report timeframe, with > corrected numbers for anomalously high traffic on some main pages > <https://phabricator.wikimedia.org/T141506>) > > > Context (April 2015-December 2016): > > > > See also the Vital Signs dashboard > <https://analytics.wikimedia.org/dashboards/vital-signs/#projects=all/metric…> > > (Small caveats: iOS app’s pageviews were undercounted by about 1.6 > million/day from mid September to early November due to a bug > <https://phabricator.wikimedia.org/T148663>.) > > Overall pageviews increased steadily during the timespan of this report > aside from the week ending October 30th (right before Halloween) and the > end of November. There appears to be a peak in pageviews in November. > > To facilitate our understanding of which traffic movements are seasonal > and which may indicate lasting changes, here is 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): > > The blue line indicates a non-seasonal rise peaking around November 12. We > checked whether this peak came from a particular country and were able to > exclude that possibility. > > Wikimedia Daily Pageviews from US > > > Pageviews in US do not show any drastic changes (even around the time of > the US elections). > > > Wikimedia Daily Pageviews from Mexico > > > In Mexico, there seems to been a huge drop starting October 27th (perhaps > some sort of local outage). > > > Wikimedia Daily Pageviews from Ecuador > > > Ecuador shows a huge spike on October 30th, followed by a drop for several > days. > > Desktop: 54.1% (previous report: 54.1%) > > Mobile web: 44.8% (previous report: 44.6%) > > Apps: 1.1% (previous report: 1.3%) (missing some iOS pageviews, cf. > above) > > Context (December 2015 - December 2016): > > Overall mobile percentage is similar to the last report, but we did see a > small increase (besides one week in August) until late September. As a > reminder, mobile already has a solid majority in terms of unique devices, > cf. below. > > > > Global North ratio: 75.3% of total pageviews (previous report: 75.5%) > > Context (January - December 2016): > > > > There is a slight increase in Global North percentage in late October and > November, but overall this number is relatively steady. > > 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: 33.9 million (previous report: 32.2 million) > - > > Desktop: 24.1 million (previous report: 22.3 million) > - > > Total: 57.9 million (previous report: 54.5 million) > - > > Average mobile web ratio: 58.7% (previous report: 59.3%) > > > > Context (January- December 2016): > > > > This metric hasn’t existed long enough yet to get a good sense of what > yearly seasonalities may exist, but since the last report time frame daily > unique desktop devices show an increasing upward trend until early > November, where there is a peak and then an apparent drop (which parallels > the peak in pageviews). > > > > To understand the peak in daily unique devices, we plotted the ratio of > daily pageviews to daily unique devices. There is a small bump in the > mobile ratio in early November, but it is too small to fully explain the > rise in pageviews around this time. > New app installations > > Android: 19.9k/day (+1.21% from the previous report) > > Daily installs per device, from Google Play > > Context (last seven months): > > > > > Download numbers increased in September and have sustained previous levels > so far, possibly helped by the app’s inclusion on the Education category > page <https://play.google.com/store/apps/category/EDUCATION> in Google’s > Play Store. There was an additional bump in mid September (reason unknown). > The number of daily uninstalls decreased slightly. During the timespan of > the previous report, installs had markedly decreased (except for a so far > unexplained bump during two weeks in July), which combined with the high > uninstall numbers had caused the app’s install base to shrink from 15.5 > million on March 31 to 15.1 million at the beginning of August. This trend > has now been stopped, although the number was still at 15.1 million on > November. (Google has since discontinued > <https://support.google.com/googleplay/android-developer/answer/7003402#acti…> > this “current installs” metric in favor of a new “installs on active > devices" metric.) > > > > iOS: 6.35k/day (+99.9% from the previous report) > > Download numbers from App Annie > > Daily downloads (with the largest countries broken out): > > [image: Wikipedia iOS app daily downloads by country, Aug 1 ~ Dec 7, 2016 > (App Annie).png] > > The iOS Wikipedia app was promoted on iTunes in September, with huge > impact (twice as many downloads than resulted from a comparable promotion > in September 2015). Total daily downloads remained on a higher level > afterwards (4.8k/day during the last week of this report, Nov 28-Dec 4). > Around October 24, downloads from the US spiked, possibly helped by some > organic media coverage such as this > <http://thetechbeard.com/best-free-ios-10-widgets/>. On November 11, we > registered an extra 9000 downloads from Sweden, for unknown reasons (no app > store promotions or media coverage that we are aware of). > App user retention > > Android: 16.4% (previous report: 16.7%) > > (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 seven months): > > As remarked in earlier reports, this data is a bit too noisy for drawing > conclusions about whether retention changed significantly between different > releases. Retention appears to have dropped somewhat in September after > having gradually grown earlier during the timespan of the last report and > after. > > iOS: N/A <https://phabricator.wikimedia.org/T126693> > > (We recently began measuring this on the iOS app - using the same method > as on Android, restricted to users who opt-in to data collection - but > there is not enough data yet.) > Unique app users > > Android: 1.146 million / day (+0.0% from the previous report) > > Context (last six months): > > In September/October, there seems to be a very small growth in daily > average users. > > iOS: N/A <https://phabricator.wikimedia.org/T130432> > > Zareen Farooqui, Data Analyst Intern, Wikimedia Foundation > > Tilman Bayer, Senior Analyst, Wikimedia Foundation > Data sources > > 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/wiki/Category:Wikimedia_readership_metrics_re…> > > > 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; > > Pivot URLs: > > United States > <https://pivot.wikimedia.org/#pageviews-daily/line-chart/2/EQUQLgxg9AqgKgYWA…> > > Mexico > <https://pivot.wikimedia.org/#pageviews-daily/line-chart/2/EQUQLgxg9AqgKgYWA…> > > Ecuador > <https://pivot.wikimedia.org/#pageviews-daily/line-chart/2/EQUQLgxg9AqgKgYWA…> > > SELECT access_method, SUM(view_count)/(7*18) FROM wmf.projectview_hourly > WHERE agent_type = 'user' AND > CONCAT(year,"-",LPAD(month,2,"0"),"-",LPAD(day,2,"0")) BETWEEN "2016-08-01" > AND "2016-12-04" 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; > > SELECT year, month, day, > CONCAT(year,"-",LPAD(month,2,"0"),"-",LPAD(day,2,"0")) as date, > SUM(IF(uri_host LIKE 'en.m.wikipedia%', uniques_estimate, 0)) AS > enwiki_mobile_web > > FROM wmf.last_access_uniques_daily > > WHERE year=2016 GROUP BY year, month, day ORDER BY year, month, day LIMIT > 1000; > > SELECT year, month, day, > CONCAT(year,"-",LPAD(month,2,"0"),"-",LPAD(day,2,"0")) as date, > SUM(IF(uri_host LIKE 'en.wikipedia%', uniques_estimate, 0)) AS > enwiki_desktop > > FROM wmf.last_access_uniques_daily > > WHERE year=2016 GROUP BY year, month, day ORDER BY year, month, day LIMIT > 1000; > > SELECT year, month, day, > CONCAT(year,"-",LPAD(month,2,"0"),"-",LPAD(day,2,"0")) AS date, > > SUM(IF(access_method = 'mobile web', view_count, null)) AS mobilewebviews, > > SUM(IF(access_method = 'desktop', view_count, null)) AS desktopviews > > FROM wmf.projectview_hourly WHERE year=2016 AND agent_type = 'user' AND > project = 'en.wikipedia' > > GROUP BY year, month, day ORDER BY year, month, day LIMIT 1000; > > 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 timestamp LIKE > '201510%' AND 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) > > https://analytics.itunes.apple.com/#/retention?app=324715238 > > 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'; > > > https://console.developers.google.com/storage/browser/pubsite_prod_rev_0281… > (“overview”) > > https://www.appannie.com/dashboard/252257/item/324715238/downloads/ > (select “Total”) > > > > Zareen Farooqui > > > _______________________________________________ > Analytics mailing list > Analytics(a)lists.wikimedia.org > https://lists.wikimedia.org/mailman/listinfo/analytics > > > > > > -- > Caitlin Cogdill > Senior Fundraising Email Manager > Wikimedia Foundation > > Imagine a world in which every single human being can freely share in > the sum of all knowledge. Help us make it a reality! > > *https://donate.wikimedia.org <https://donate.wikimedia.org/>* > _______________________________________________ > Analytics mailing list > Analytics(a)lists.wikimedia.org > https://lists.wikimedia.org/mailman/listinfo/analytics > -- Olga Vasileva // Product Manager // Reading Web Team https://wikimediafoundation.org/

1 0

Re: [Wikitech-l] [Analytics] Readership metrics for the timespan until December 4, 2016
by Toby Negrin 14 Dec '16

14 Dec '16

Thank you so much for this Zareen! It's really great to see this report -- so much interesting data to think about! -Toby On Mon, Dec 12, 2016 at 5:45 PM, Zareen Farooqui <zareenf(a)gmail.com> wrote: > Hi all, > > This resumes the usual look > <https://www.mediawiki.org/wiki/Reading/Readership_metrics_reports> at > our most important readership metrics. This time we can report that daily > pageviews are up 4.8% (since the last report), with an interesting recent > peak which meant that November’s pageviews surpassed those of November 2015 > (coincidentally also) by 4.8%, after October had already seen a 2.1% > year-over-year increase. The iOS Wikipedia app saw increased downloads, > while the Android app’s install base has stopped its previous downward > trend. > > 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 metrics 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 eighteen > 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 > <https://commons.wikimedia.org/wiki/File:Reading_and_Comm_Tech_Quarterly_Rev…> > for Q1 2016-17 (July-September), which includes lots of traffic and usage > data. > - > > At the Foundation’s August metrics meeting > <https://commons.wikimedia.org/w/index.php?title=File%3AAugust_2016_Monthly_…>, > the Reading team gave an update on longer-term traffic trends since 2013. > (TL;DR: Overall pageviews have been flat to slightly declining, mobile has > been steadily rising but recently slowed down, desktop has declining during > these three years. However, total pageviews have been slightly increasing > year-over-year in the last few months.) See the chart below, updated with > data until November: > > [image: Wikimedia monthly pageviews (desktop+mobile), 2013-2016 (version > December 2016).png] > > In particular, as mentioned, the number of total pageview saw > year-over-year increases of +2.1% for October and +4.8% in November, in > contrast to e.g. the -10.5% we had for May 2015-May 2016. > > Now to the usual data. (All numbers below are averages for August > 1-December 4, 2016 unless otherwise noted.) > > Pageviews > > Total: 529 million/day (+4.76% from the previous report timeframe, with > corrected numbers for anomalously high traffic on some main pages > <https://phabricator.wikimedia.org/T141506>) > > > Context (April 2015-December 2016): > > > > See also the Vital Signs dashboard > <https://analytics.wikimedia.org/dashboards/vital-signs/#projects=all/metric…> > > (Small caveats: iOS app’s pageviews were undercounted by about 1.6 > million/day from mid September to early November due to a bug > <https://phabricator.wikimedia.org/T148663>.) > > Overall pageviews increased steadily during the timespan of this report > aside from the week ending October 30th (right before Halloween) and the > end of November. There appears to be a peak in pageviews in November. > > To facilitate our understanding of which traffic movements are seasonal > and which may indicate lasting changes, here is 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): > > The blue line indicates a non-seasonal rise peaking around November 12. We > checked whether this peak came from a particular country and were able to > exclude that possibility. > > Wikimedia Daily Pageviews from US > > > Pageviews in US do not show any drastic changes (even around the time of > the US elections). > > > Wikimedia Daily Pageviews from Mexico > > > In Mexico, there seems to been a huge drop starting October 27th (perhaps > some sort of local outage). > > > Wikimedia Daily Pageviews from Ecuador > > > Ecuador shows a huge spike on October 30th, followed by a drop for several > days. > > Desktop: 54.1% (previous report: 54.1%) > > Mobile web: 44.8% (previous report: 44.6%) > > Apps: 1.1% (previous report: 1.3%) (missing some iOS pageviews, cf. > above) > > Context (December 2015 - December 2016): > > Overall mobile percentage is similar to the last report, but we did see a > small increase (besides one week in August) until late September. As a > reminder, mobile already has a solid majority in terms of unique devices, > cf. below. > > > > Global North ratio: 75.3% of total pageviews (previous report: 75.5%) > > Context (January - December 2016): > > > > There is a slight increase in Global North percentage in late October and > November, but overall this number is relatively steady. > > 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: 33.9 million (previous report: 32.2 million) > - > > Desktop: 24.1 million (previous report: 22.3 million) > - > > Total: 57.9 million (previous report: 54.5 million) > - > > Average mobile web ratio: 58.7% (previous report: 59.3%) > > > > Context (January- December 2016): > > > > This metric hasn’t existed long enough yet to get a good sense of what > yearly seasonalities may exist, but since the last report time frame daily > unique desktop devices show an increasing upward trend until early > November, where there is a peak and then an apparent drop (which parallels > the peak in pageviews). > > > > To understand the peak in daily unique devices, we plotted the ratio of > daily pageviews to daily unique devices. There is a small bump in the > mobile ratio in early November, but it is too small to fully explain the > rise in pageviews around this time. > New app installations > > Android: 19.9k/day (+1.21% from the previous report) > > Daily installs per device, from Google Play > > Context (last seven months): > > > > > Download numbers increased in September and have sustained previous levels > so far, possibly helped by the app’s inclusion on the Education category > page <https://play.google.com/store/apps/category/EDUCATION> in Google’s > Play Store. There was an additional bump in mid September (reason unknown). > The number of daily uninstalls decreased slightly. During the timespan of > the previous report, installs had markedly decreased (except for a so far > unexplained bump during two weeks in July), which combined with the high > uninstall numbers had caused the app’s install base to shrink from 15.5 > million on March 31 to 15.1 million at the beginning of August. This trend > has now been stopped, although the number was still at 15.1 million on > November. (Google has since discontinued > <https://support.google.com/googleplay/android-developer/answer/7003402#acti…> > this “current installs” metric in favor of a new “installs on active > devices" metric.) > > > > iOS: 6.35k/day (+99.9% from the previous report) > > Download numbers from App Annie > > Daily downloads (with the largest countries broken out): > > [image: Wikipedia iOS app daily downloads by country, Aug 1 ~ Dec 7, 2016 > (App Annie).png] > > The iOS Wikipedia app was promoted on iTunes in September, with huge > impact (twice as many downloads than resulted from a comparable promotion > in September 2015). Total daily downloads remained on a higher level > afterwards (4.8k/day during the last week of this report, Nov 28-Dec 4). > Around October 24, downloads from the US spiked, possibly helped by some > organic media coverage such as this > <http://thetechbeard.com/best-free-ios-10-widgets/>. On November 11, we > registered an extra 9000 downloads from Sweden, for unknown reasons (no app > store promotions or media coverage that we are aware of). > App user retention > > Android: 16.4% (previous report: 16.7%) > > (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 seven months): > > As remarked in earlier reports, this data is a bit too noisy for drawing > conclusions about whether retention changed significantly between different > releases. Retention appears to have dropped somewhat in September after > having gradually grown earlier during the timespan of the last report and > after. > > iOS: N/A <https://phabricator.wikimedia.org/T126693> > > (We recently began measuring this on the iOS app - using the same method > as on Android, restricted to users who opt-in to data collection - but > there is not enough data yet.) > Unique app users > > Android: 1.146 million / day (+0.0% from the previous report) > > Context (last six months): > > In September/October, there seems to be a very small growth in daily > average users. > > iOS: N/A <https://phabricator.wikimedia.org/T130432> > > Zareen Farooqui, Data Analyst Intern, Wikimedia Foundation > > Tilman Bayer, Senior Analyst, Wikimedia Foundation > Data sources > > 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/wiki/Category:Wikimedia_readership_metrics_re…> > > > 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; > > Pivot URLs: > > United States > <https://pivot.wikimedia.org/#pageviews-daily/line-chart/2/EQUQLgxg9AqgKgYWA…> > > Mexico > <https://pivot.wikimedia.org/#pageviews-daily/line-chart/2/EQUQLgxg9AqgKgYWA…> > > Ecuador > <https://pivot.wikimedia.org/#pageviews-daily/line-chart/2/EQUQLgxg9AqgKgYWA…> > > SELECT access_method, SUM(view_count)/(7*18) FROM wmf.projectview_hourly > WHERE agent_type = 'user' AND CONCAT(year,"-",LPAD(month,2,"0"),"-",LPAD(day,2,"0")) > BETWEEN "2016-08-01" AND "2016-12-04" 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; > > SELECT year, month, day, CONCAT(year,"-",LPAD(month,2,"0"),"-",LPAD(day,2,"0")) > as date, SUM(IF(uri_host LIKE 'en.m.wikipedia%', uniques_estimate, 0)) AS > enwiki_mobile_web > > FROM wmf.last_access_uniques_daily > > WHERE year=2016 GROUP BY year, month, day ORDER BY year, month, day LIMIT > 1000; > > SELECT year, month, day, CONCAT(year,"-",LPAD(month,2,"0"),"-",LPAD(day,2,"0")) > as date, SUM(IF(uri_host LIKE 'en.wikipedia%', uniques_estimate, 0)) AS > enwiki_desktop > > FROM wmf.last_access_uniques_daily > > WHERE year=2016 GROUP BY year, month, day ORDER BY year, month, day LIMIT > 1000; > > SELECT year, month, day, CONCAT(year,"-",LPAD(month,2,"0"),"-",LPAD(day,2,"0")) > AS date, > > SUM(IF(access_method = 'mobile web', view_count, null)) AS mobilewebviews, > > SUM(IF(access_method = 'desktop', view_count, null)) AS desktopviews > > FROM wmf.projectview_hourly WHERE year=2016 AND agent_type = 'user' AND > project = 'en.wikipedia' > > GROUP BY year, month, day ORDER BY year, month, day LIMIT 1000; > > 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 timestamp > LIKE '201510%' AND 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) > > https://analytics.itunes.apple.com/#/retention?app=324715238 > > 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'; > > https://console.developers.google.com/storage/browser/pubsite_prod_rev_ > 02812522755211381933/stats/installs/ (“overview”) > > https://www.appannie.com/dashboard/252257/item/324715238/downloads/ > (select “Total”) > > > > Zareen Farooqui > > > _______________________________________________ > Analytics mailing list > Analytics(a)lists.wikimedia.org > https://lists.wikimedia.org/mailman/listinfo/analytics > >

1 0

Changes in colors of user interface
by Amir Ladsgroup 14 Dec '16

14 Dec '16

Hey, With the deployment of 1.29.0-wmf.5 which just finished on all wikis, several changes were made in user interface colors. * Gray boxes (TOC, Wikitables, catlinks, thumbnails, elements in history etc.) has changed from #f9f9f9 as background to #f8f9fa and #aaa as border to #a2a9b1. [1] This change is almost not noticeable but in order to keep consistency between all elements of a wiki page, change such usages in your Mediawiki:Common.css (for example for infoboxes). * Search results border and background colors also changed and this one is also not noticeable. [2] * "You have new message in your talk page" notification color has changed from #f9c557 to #fc3 (yellow). [3] This change is noticeable. These all are parts of works ongoing by WMF designers and engineers to have a standard UI [4] using standard colors picked from Wikimedia color palette. [5] Using consistent colors helps users have better experience and strengthen branding. Also these colors have passed WCAG standard for accessibility (for color blind people). Lots have been done already. Such as content translation [6] wikipedia.org portal [7] [8], mobile frontend [9], Echo email notification [10], Deffered changes [11] ORES review tool [12], disambig icon [13] [14], WMF wiki main page [15] and a lot more. So I recommend you to use the color palette [5] as much as possible. I must explicitly note that I did a little and I don't think I can talk on behalf of UI-standardization team :) [1]: https://gerrit.wikimedia.org/r/324534 [2]: https://gerrit.wikimedia.org/r/324549 [3]: https://gerrit.wikimedia.org/r/324161 [4]: https://phabricator.wikimedia.org/tag/ui-standardization [5]: Wikimedia color palette: https://phabricator.wikimedia.org/M82 [6]: https://gerrit.wikimedia.org/r/321609 [7]: https://gerrit.wikimedia.org/r/322831 [8]: https://gerrit.wikimedia.org/r/325057 [9]: https://gerrit.wikimedia.org/r/317746 [10]: https://gerrit.wikimedia.org/r/323554 [11]: https://gerrit.wikimedia.org/r/323558 [12]: https://gerrit.wikimedia.org/r/320341 [13]: https://commons.wikimedia.org/wiki/File:Disambig.svg [14]: https://commons.wikimedia.org/wiki/File:Disambig_gray.svg [15]: https://wikimediafoundation.org/wiki/Home Best

17 35

Google Code-in 2016: We need your tasks!; 2nd week achievements
by Andre Klapper 14 Dec '16

14 Dec '16

We are soon going to run out of Google Code-in tasks. Please mentor small and easy tasks! https://www.mediawiki.org/wiki/Google_Code-in_2016 Contact us if you need help or have questions! Some GCI achievements of the last week (week 2 out of 7): * Newsletter extension again received numerous patches * Proposals for a redesign of the Romanian Wikipedia's main page * MobileFrontend hooks documentation got updated * One Wikispeech logo proposal (student still needs to upload to Commons) * A long CREDIT showcase video got split into 'one video per topic' parts on Commons * Deprecated "Article::getContent()" calls got replaced in several MediaWiki extensions * Wikidata user docs were analyzed and improvements proposed * In WikiEduDashboard, .erb html templates were converted to .haml * The RelatedArticles extension received a design fix for the footer * Updated screencast videos in the Phabricator help on mw.org * More screenshots on extension pages (Echo, Poem, TemplateSandbox, …) * Soon in the pageview API: Monthly request stats per article title! * …and many many more. Congratulations to all our students and thanks to all our mentors! Thanks, andre -- Andre Klapper | Wikimedia Bugwrangler http://blogs.gnome.org/aklapper/

2 1

ArchCom Meeting Minutes (2016-12-07)
by Daniel Kinzler 14 Dec '16

14 Dec '16

Hi all! Please find below minutes of the last ArchCom meeting The minutes can be fond at <https://www.mediawiki.org/wiki/Architecture_committee/2016-12-07>. See also the ArchCom status page at <https://www.mediawiki.org/wiki/Architecture_committee/Status> and the RFC board <https://phabricator.wikimedia.org/tag/mediawiki-rfcs/>. ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ People present: Members: Brion, Daniel (chair), Gabriel, Tim. Guest: Victoria Coleman (CTO) * Victoria joined to meeting to get an idea of how ArchCom operates * Victoria will attend ArchCom meetings as much as time allows * Work on thumbnail API (T66214) is progressing, follow-up meeting to be announced (Gabriel) * Web API outage (T151702) is being investigated/evaluated (Gabriel, Tim, Kunal, and others) * Code experiments started for using Varnish’s xkey feature in Wikibase (T152425) (Daniel) * Victoria suggest to have a regular meeting to review/prioritize technical debt. ArchCom to be invited. * Lego’s Deprecation Policy RFC (T146965) to be discussed on December 14. Fallback: thumb API (T66214). -- Daniel Kinzler Senior Software Developer Wikimedia Deutschland Gesellschaft zur Förderung Freien Wissens e.V.

3 2

Gerrit upgrade (w/ short downtime) tomorrow
by Chad Horohoe 13 Dec '16

13 Dec '16

Hi all, Tomorrow evening (18:30–19:30 UTC) I'll be taking Gerrit offline shortly for a planned upgrade from 2.12.5 to 2.13.3. It shouldn't take the full hour, but you never know :) If you play the deployment game regularly, you'll notice I've cancelled[0] tomorrow's "SF Morning SWAT" window because it overlaps with the time I picked ;-) Thanks! -Chad [0] https://wikitech.wikimedia.org/w/index.php?title=Deployments&type=revision&…

6 5

phan (new static analysis tool) is now voting on MediaWiki core
by Legoktm 13 Dec '16

13 Dec '16

Hi! Thanks to some awesome work by Erik Bernhardson, phan[1], a new static analysis tool, is now voting[2] on MediaWiki core patches. It's significantly more advanced than any of our other current tools, and should help identify some types of errors. It uses PHP 7's AST to process code, but is capable of analyzing PHP5 code. There's documentation on mediawiki.org[3] about how it is currently configured, and how to set it up locally. You'll need PHP 7 with the ast extension to actually run phan. If that's not possible for your system, you can rely on jenkins to run it for you. [1] https://github.com/etsy/phan [2] https://phabricator.wikimedia.org/T132636 [3] https://www.mediawiki.org/wiki/Continuous_integration/Phan -- Legoktm

4 4

Wikimedia Developer Summit DRAFT program
by Quim Gil 13 Dec '16

13 Dec '16

Hi, the Wikimedia Developer Summit Program committee is happy to announce a draft schedule: https://www.mediawiki.org/wiki/Wikimedia_Developer_Summit/2017/Program#Sche… This schedule includes two plenary sessions: * Has our success made it hard to see your own contribution? <https://phabricator.wikimedia.org/T153024> by Ward Cunningham * Wikimedia Foundation Technology and Product Q&A, with Victoria Coleman (CTO) and Wes Moran (VP of Product). You can propose and vote questions for Victoria and Wes between now and the beginning of the Summit: http://www.allourideas.org/wikidev17-product-technology-questions We welcome feedback about possible improvements to the schedule. Please share your suggestions at the related discussion page <https://www.mediawiki.org/wiki/Talk:Wikimedia_Developer_Summit/2017/Program>. We plan to confirm the final schedule on Friday, December 23rd. We are working on the Unconference, the third day of the Summit, and the social events. We will share more details soon. Stay tuned! -- Quim Gil Engineering Community Manager @ Wikimedia Foundation http://www.mediawiki.org/wiki/User:Qgil

1 1

No Tech News the weeks of December 26 and January 2
by Johan Jönsson 13 Dec '16

13 Dec '16

Hi everyone, As there are no deployments scheduled for the weeks of December 19 and December 26, Tech News[1] will take a hiatus for two weeks, too. The next issue will be distributed to the wikis on Monday; the issue after that one on January 9. If you have something you need included in Tech News before the end of the year, please add the user-notice tag in Phabricator, write me or add it to the current draft[2] before Friday this week. Deadlines and inclusion critera: https://meta.wikimedia.org/wiki/Tech/News/For_contributors [1] https://meta.wikimedia.org/wiki/Tech/News [2] https://meta.wikimedia.org/wiki/Tech/News/2016/51 //Johan Jönsson --

1 0

← Newer
1
2
3
4
5
6
7
8
9
Older →

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

2004

2003

2002

Wikitech-l December 2016