[WikimediaMobile] Audiences core metrics for Q3 (January-March 2018)

-Mar_2018).pdf [2] https://meta.wikimedia.org/wiki/Wikimedia_Foundation_Annual_Plan/Quarterly_check-ins#Third_quarter_(January%E2%80%93March_2018) -- Tilman Bayer Senior Analyst Wikimedia Foundation IRC (Freenode): HaeB ___ Mobile-l mailing list Mobile-l

[WikimediaMobile] Readers core metrics for Q2 (Oct-Dec 2017)

team's main quarterly check-in presentation, which is available at [2]. [1] https://commons.wikimedia.org/wiki/File:Wikimedia_Foundation_Readers_metrics_Q2_2017-18_(Oct-Dec_2017).pdf [2] https://commons.wikimedia.org/wiki/File:Readers_Q2_check-in_January_2018.pdf -- Tilman Bayer Senior Analyst

[WikimediaMobile] Readers core metrics for Q4 (April-June 2017)

of Wikimedia sites, now also including data about search provided by the Discovery team. [1] https://commons.wikimedia.org/wiki/File:Wikimedia_Foundation_Readers_metrics_Q4_2016-17_(Apr-Jun_2017).pdf [2] https://lists.wikimedia.org/pipermail/wikitech-l/2017-August/088575.html -- Tilman Bayer Senior Analyst

Re: [WikimediaMobile] Readership metrics for the timespan until February 5, 2017

n day 7 retention for >> installs on January 22nd. >> >> iOS: 19.2% (previous report: N/A >> <https://phabricator.wikimedia.org/T126693>) >> >> (Ratio of app installs opened again 7 days after installation for all >> dates that fall within this report. 100:10

Re: [WikimediaMobile] Readership metrics for the timespan until July 31, 2016

On Wed, Aug 10, 2016 at 1:57 AM, Federico Leva (Nemo) <nemow...@gmail.com> wrote: > Thanks. > > Tilman Bayer, 08/08/2016 22:41: > >> Daily unique devices estimate for English Wikipedia: >> > > Is this a median of the daily figure over the course of the month, a

[WikimediaMobile] Readership metrics for the timespan until July 31, 2016

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']

[WikimediaMobile] Mobile sessions at Wikimania

ers: During the session, I and other people posted links to various existing Phabricator tasks related to the suggestions/concerns that were being brought up; but as far I can see those tickets didn't receive any comments or subscriptions subsequently. -- Tilman Bayer Senior

Re: [WikimediaMobile] [Reading-web-team] Comparison of collapsed vs. expanded section view on mobile web

son unless you compare readers outside > the test group to the Android app and talk about the delta. Again, see the Meta page for a discussion of limitations of this comparisons. And I would say that the test condition was clearly still more comparable to the Android app reading experience (because both

Re: [WikimediaMobile] [Reading-web-team] Comparison of collapsed vs. expanded section view on mobile web

riment, I've taken the opportunity to write this up this >>> analysis as a page in the research namespace on Meta, instead of on >>> Phabricator or in form of an email as done on other occasions. >>> Feedback on the format is welcome too.) >>> -- >>> Tilman Bayer >>> Senior Analyst >>> Wik

[WikimediaMobile] Comparison of collapsed vs. expanded section view on mobile web

or in form of an email as done on other occasions. Feedback on the format is welcome too.) -- Tilman Bayer Senior Analyst Wikimedia Foundation IRC (Freenode): HaeB ___ Mobile-l mailing list Mobile-l@lists.wikimedia.org https://lists.wikimedia.org/mailman

Re: [WikimediaMobile] [Apps] New Android production release

is message because you are subscribed to the Google Groups > "android" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to android+unsubscr...@wikimedia.org. > To post to this group, send email to andr...@wikimedia.org. -- Tilman

Re: [WikimediaMobile] [Wikimedia-l] Fwd: "Among mobile sites, Wikipedia reigns in terms of popularity"

the >> good >> > old days when it was an application totally and utterly outside of >> > MediaWiki? >> > Thanks, >> > GerardM >> > >> > On 11 May 2016 at 20:33, Pine W <wiki.p...@gmail.com> wrote: >> > >> &g

Re: [WikimediaMobile] [IEEE-CyberSec2016] Invitation for Participation

nts and extension > within the time frame that will be set by the conference and his/her paper > is approved by the chief editor: > > * International Journal of New Computer Architectures and their Applications > (IJNCAA) > * International Journal of Digital Information and Wireless Commu

[WikimediaMobile] "Among mobile sites, Wikipedia reigns in terms of popularity"

ation each month, according to Knight’s analysis, which used data from the audience-tracking firm Nielsen." -- Tilman Bayer Senior Analyst Wikimedia Foundation IRC (Freenode): HaeB ___ Mobile-l mailing list Mobile-l@lists.wikimedia

[WikimediaMobile] Readership metrics for the timespan until April 24, 2016

bot%' 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 hive (wmf)> SELECT CONCAT(year,"-",LPAD(month,2,"0"),"-",LPAD

[WikimediaMobile] Fwd: The Wikimedia Research Newsletter 6(3) is out

er 6(3) is out To: Wikimedia Research Mailing List <wiki-researc...@lists.wikimedia.org> Cc: Tilman Bayer <tba...@wikimedia.org>, Dario Taraborelli < dtarabore...@wikimedia.org> The March 2016 issue of the Wikimedia Research Newsletter is out: https://blog.wikimedia.org/2016/04/02/r

Re: [WikimediaMobile] Readership metrics for the two months until February 7, 2016

Can you provide a link for this summary below? > > Thank you, > > *~Orsolya* > > 2016-02-18 23:37 GMT+01:00 Tilman Bayer <tba...@wikimedia.org>: > >> Hi all, >> >> this resumes the usual look at our most important readership metrics. >> A

Re: [WikimediaMobile] [Analytics] Readership metrics for the two months until February 7, 2016

nformative, great for transparency, and something more teams >> should be doing. I'm personally gonna be stealing a leaf from your book and >> doing something similar :). >> >> On 18 February 2016 at 17:37, Tilman Bayer <tba...@wikimedia.org> wrote: >> >&g

[WikimediaMobile] Readership metrics for the two months until February 7, 2016

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 hive (wmf)> SELECT CONCAT(year,"-",LPAD(month,2,"

[WikimediaMobile] Lead section improvement contest on English Wikipedia

a.org/wiki/Wikipedia:How_to_create_and_manage_a_good_lead_section . It's a great example of how we can support editors' work with readership data beyond mere pageviews (I also submitted a Wikimania talk about this topic earlier this month). -- Tilman Bayer Senior Analyst Wikimedia Foundation IRC (Freen

Re: [WikimediaMobile] Lead section improvement contest on English Wikipedia

l free refer to the results that are already there. > > > On Wed, Jan 27, 2016 at 11:03 AM, Tilman Bayer <tba...@wikimedia.org> wrote: >> User:Casliber has started an editing contest on the English Wikipedia >> focused on improving or adding lead (intro) sec

Re: [WikimediaMobile] [Analytics] MobileWikiAppShareAFact event stream was: Stopping eventlogging events into MobileWikiAppShareAFact table

through Hive, we could continue storing > all events at the current 1% rate in Hadoop. > > On Mon, Jan 4, 2016 at 11:28 AM, Tilman Bayer <tba...@wikimedia.org> wrote: >> >> Hi Marcel, >> >> yes, this is to be expected, because the schema is now logging more >>

[WikimediaMobile] New iOS app: "Curiosity Shows You Useful Wikipedia Articles Right When You Need Them"

Learn about Famous Inventors, Movies Filmed Nearby, or many other categories being added and updated regularly. Bookmarks & History [...] Search [...] Read & Share [...] " It's *almost* like they saw https://commons.wikimedia.org/wiki/File:IOS_Wikipedia_App_5.0_Update.pdf ;) -- T

[WikimediaMobile] Readership metrics for the fortnight until December 6, 2015

ivided by day0_active from the install date) https://analytics.itunes.apple.com/#/retention?app=324715238 hive (wmf)> SELECT SUM(IF(platform = 'Android',unique_count,0))/7 AS avg_Android_DAU_last_week, SUM(IF(platform = 'iOS',unique_count,0))/7 AS avg_iOS_DAU_last_week FROM wmf.mobile_apps_

[WikimediaMobile] User essay about editing Wikipedia on a smartphone using the desktop version

e of edits from mobile devices that use the desktop version? These observations on the talk page about the shortcomings of the mobile web interface for curation purposes are also worth reading: https://en.wikipedia.org/wiki/User_talk:Cullen328/Smartphone_editing#PamD.27s_comments -- Tilman Ba

[WikimediaMobile] Results of the November 2015 Wikimedia Readers Survey (Fwd: [Wikimedia-l] Fundraising Update)

ikimedia.org <https://meta.wikimedia.org/wiki/Mailing_lists/guidelineswikimedi...@lists.wikimedia.org> Unsubscribe: https://lists.wikimedia.org/mailman/listinfo/wikimedia-l, <mailto:wikimedia-l-requ...@lists.wikimedia.org?subject=unsubscribe> -- Tilman Bayer Senior Analyst Wikimedia Foundation

[WikimediaMobile] Readership metrics for the week until November 22, 2015

count,0))/7 AS avg_iOS_DAU_last_week FROM wmf.mobile_apps_uniques_daily WHERE CONCAT(year,LPAD(month,2,"0"),LPAD(day,2,"0")) BETWEEN 20151116 AND 20151122; hive (wmf)> SELECT CONCAT(year,"-",LPAD(month,2,"0"),"-",LPAD(day,2,"0")) as date

[WikimediaMobile] Readership metrics for the week until November 15, 2015

5238 hive (wmf)> SELECT SUM(IF(platform = 'Android',unique_count,0))/7 AS avg_Android_DAU_last_week, SUM(IF(platform = 'iOS',unique_count,0))/7 AS avg_iOS_DAU_last_week FROM wmf.mobile_apps_uniques_daily WHERE CONCAT(year,LPAD(month,2,"0"),LPAD(day,2,"0")) BETWEEN 20151109 AND 2

[WikimediaMobile] Ars Technica: "User data plundering by Android and iOS apps is as rampant as you suspected"

hird parties at all. (In another context, we made that point with this tweet: https://twitter.com/Wikipedia/status/579220963755044864 ) -- Tilman Bayer Senior Analyst Wikimedia Foundation IRC (Freenode): HaeB ___ Mobile-l mailing list Mobile-l@lists.w

Re: [WikimediaMobile] Ars Technica: "User data plundering by Android and iOS apps is as rampant as you suspected"

ovided > to financial institutions so that the funds can be transferred, right? > > > Pine > > On Sun, Nov 15, 2015 at 10:59 PM, Tilman Bayer <tba...@wikimedia.org> wrote: >> >> Good for some general perspective on (lack of) user privacy in the app >> industry: >>

[WikimediaMobile] Readership metrics for the week until November 8, 2015

SELECT SUM(IF(platform = 'Android',unique_count,0))/7 AS avg_Android_DAU_last_week, SUM(IF(platform = 'iOS',unique_count,0))/7 AS avg_iOS_DAU_last_week FROM wmf.mobile_apps_uniques_daily WHERE CONCAT(year,LPAD(month,2,"0"),LPAD(day,2,"0")) BETWEEN 20151102 AND 20151108; hive

Re: [WikimediaMobile] Readership metrics for the week until November 1, 2015

On Wed, Nov 4, 2015 at 5:39 PM, Tilman Bayer <tba...@wikimedia.org> wrote: > Hi all, > > here is the usual weekly look at our most important readership metrics > (CCing the Analytics-l mailing list too this time). > ... > Desktop: 57.7% > > Mobile web: 1.2% >

[WikimediaMobile] Readership metrics for the week until November 1, 2015

t;-",LPAD(day,2,"0")) as date, unique_count AS Android_DAU FROM wmf.mobile_apps_uniques_daily WHERE platform = 'Android'; hive (wmf)> SELECT CONCAT(year,"-",LPAD(month,2,"0"),"-",LPAD(day,2,"0")) as date, unique_count AS iOS_DAU FROM wmf.mo

[WikimediaMobile] Readership metrics for the week until October 25, 2015

; hive (wmf)> SELECT CONCAT(year,"-",LPAD(month,2,"0"),"-",LPAD(day,2,"0")) as date, unique_count AS iOS_DAU FROM wmf.mobile_apps_uniques_daily WHERE platform = 'iOS'; https://play.google.com/apps/publish/?dev_acc=02812522755211381933#StatsPlace:p=org.wikipedia=DAILY_DEVICE_INSTALLS=OS_VERSION https://www.appannie.com/dashboard/252257/item/324715238/downloads/?breakdown=country=2015-07-28~2015-10-25_type=downloads=ALL (select “Total”) -- Tilman Bayer Senior Analyst Wikimedia Foundation IRC (Freenode): HaeB ___ Mobile-l mailing list Mobile-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mobile-l

[WikimediaMobile] Fwd: [Analytics] Eventlogging replication issues

2. You can follow the work of our DBA on this regard on the following ticket: https://phabricator.wikimedia.org/T116599 Thanks, Nuria ___ Analytics mailing list analyt...@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/analyti

[WikimediaMobile] Readership metrics for the week until October 18, 2015

ECT CONCAT(year,"-",LPAD(month,2,"0"),"-",LPAD(day,2,"0")) as date, unique_count AS iOS_DAU FROM wmf.mobile_apps_uniques_daily WHERE platform = 'iOS'; https://play.google.com/apps/publish/?dev_acc=02812522755211381933#StatsPlace:p=org.wikipedia=DAILY_DEVICE_INSTALLS=OS_VERSION https://www.appannie.com/dashboard/252257/item/324715238/downloads/?breakdown=country=2015-07-24~2015-10-21_type=downloads=ALL (select “Total”) -- Tilman Bayer Senior Analyst Wikimedia Foundation IRC (Freenode): HaeB ___ Mobile-l mailing list Mobile-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mobile-l

Re: [WikimediaMobile] [Wmfall] Tilman is joining the Reading Team!

;jk...@wikimedia.org> wrote: > Hi Everyone, > > I’m happy to announce that, as of today, Tilman Bayer has officially joined > the Reading product team as a Senior Analyst. He will increase our capacity > for understanding our users and the impact of our efforts through data > analysi

[WikimediaMobile] Fwd: Wikimedia Foundation quarterly reviews for July-September 2015

Forwarding regarding the Reading team's quarterly review documentation -- Forwarded message -- From: Tilman Bayer <tba...@wikimedia.org> Date: Fri, Oct 16, 2015 at 10:15 PM Subject: Wikimedia Foundation quarterly reviews for July-September 2015 To: Wikimedia Mailin

[WikimediaMobile] Readership metrics for the week until October 11, 2015

> SELECT CONCAT(year,"-",LPAD(month,2,"0"),"-",LPAD(day,2,"0")) as date, unique_count AS iOS_DAU FROM wmf.mobile_apps_uniques_daily WHERE platform = 'iOS'; https://play.google.com/apps/publish/?dev_acc=02812522755211381933#StatsPlace:p=org.wikipedia=DAILY_DEVICE_INSTALLS=OS_VERSION https://www.appannie.com/dashboard/252257/item/324715238/downloads/?breakdown=country=2015-07-12~2015-10-11_type=downloads=ALL (select “Total”) -- Tilman Bayer Senior Analyst Wikimedia Foundation IRC (Freenode): HaeB ___ Mobile-l mailing list Mobile-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mobile-l

Re: [WikimediaMobile] [reading-wmf] Some interesting stuff from Google

; https://lists.wikimedia.org/mailman/listinfo/mobile-l >> >> > > > -- > Luis Villa > Sr. Director of Community Engagement > Wikimedia Foundation > *Working towards a world in which every single human being can freely > share in the sum of all knowledge.*

[WikimediaMobile] Readership metrics for the week until September 27, 2015

t;0"),"-",LPAD(day,2,"0")) as date, unique_count AS Android_DAU FROM wmf.mobile_apps_uniques_daily WHERE platform = 'Android'; hive (wmf)> SELECT CONCAT(year,"-",LPAD(month,2,"0"),"-",LPAD(day,2,"0")) as date, unique_count AS iOS_DAU FROM wmf.m

Re: [WikimediaMobile] Readership metrics for the week until September 20, 2015

Then again we wanted to keep it flexible at first, and open to feedback - no use building a dashboard for metrics that people tell us they don't find useful. Fortunately, based on the reactions so far, that doesn't seem to be the case. -- Tilman Bayer Senior Analyst Wikimedia Foundation IRC (Freenode):

Re: [WikimediaMobile] Readership metrics for the week until September 20, 2015

e we don't yet have a full year of data, this might be trickier. -- Tilman Bayer Senior Analyst Wikimedia Foundation IRC (Freenode): HaeB ___ Mobile-l mailing list Mobile-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mobile-l

[WikimediaMobile] Readership metrics for the week until September 20, 2015

ve (wmf)> SELECT CONCAT(year,"-",LPAD(month,2,"0"),"-",LPAD(day,2,"0")) as date, unique_count AS iOS_DAU FROM wmf.mobile_apps_uniques_daily WHERE platform = 'iOS'; https://play.google.com/apps/publish/?dev_acc=18062848292902787645#StatsPlace:p=org.wikipedia=DAILY_DEVICE_INSTALLS=OS_VERSION https://www.appannie.com/dashboard/252257/item/324715238/downloads/?breakdown=country=2014-09-14~2015-09-13_type=downloads=ALL -- Tilman Bayer Senior Analyst Wikimedia Foundation IRC (Freenode): HaeB ___ Mobile-l mailing list Mobile-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mobile-l

Re: [WikimediaMobile] Readership metrics for the week until September 13, 2015

t data for ENWP pageviews on stats.wikimedia.org is from >>>> July. A breakdown of ENWP stats into mobile and desktop would also be >>>> helpful. >>>> >>>> Pine >>>> >>>> >>>> On Thu, Sep 17, 2015 at 12:44 PM, Tilm

Re: [WikimediaMobile] Readership metrics for the week until September 13, 2015

n. Is it possible for to get ENWP-only stats for August 2015? > The last data for ENWP pageviews on stats.wikimedia.org is from July. A > breakdown of ENWP stats into mobile and desktop would also be helpful. > > Pine > > > On Thu, Sep 17, 2015 at 12:44 PM, Tilman

[WikimediaMobile] Readership metrics for the week until September 13, 2015

ues_daily WHERE platform = 'Android'; hive (wmf)> 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 = 'iOS'; https://play.google.com/apps/publish/?dev

Re: [WikimediaMobile] [Apps] Android Wikipedia legacy device active maintenance ending

ge 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

Re: [WikimediaMobile] Global South = web, Global North = apps

is people are choosing to invest their internet time on things such as messaging and entertainment rather than web and that we need to find ways to engage people in the Wikipedia rabbit hole/experience, the platform not being relevant. On Thu, Aug 27, 2015 at 8:26 AM, Tilman Bayer tba

[WikimediaMobile] Global South = web, Global North = apps

-heres-the-data-that-proves-it/ (According to Yahoo’s data, the use of the browser on smartphones is quickly declining [in the US]. From 2013 to 2015, the company saw the usage time of the mobile browser drop by over 50 percent as they moved to native apps instead.) -- Tilman Bayer Senior Analyst

[WikimediaMobile] Fwd: Interesting WSJ article: The Rise of Phone Reading

Forwarding to the public list too. -- Forwarded message -- From: Tilman Bayer tba...@wikimedia.org Date: Sun, Aug 16, 2015 at 9:40 PM Subject: Interesting WSJ article: The Rise of Phone Reading To: Internal communication for WMF Reading team reading-...@lists.wikimedia.org Some

[WikimediaMobile] Fwd: Wikimedia Foundation quarterly reviews for April-June 2015

Forwarding the link to the Reading team's quarterly review documentation, as it just occurred to me that not everyone might have caught it on the other lists. -- Forwarded message -- From: Tilman Bayer tba...@wikimedia.org Date: Thu, Jul 16, 2015 at 7:50 AM Subject: Wikimedia

Re: [WikimediaMobile] Who is responsible for the Wiktionary app?

://play.google.com/store/apps/details?id=org.wiktionary ___ Mobile-l mailing list Mobile-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mobile-l -- Tilman Bayer Senior Analyst Wikimedia Foundation IRC (Freenode): HaeB

Re: [WikimediaMobile] Apps FAQ

/listinfo/mobile-l -- Tilman Bayer Senior Analyst Wikimedia Foundation IRC (Freenode): HaeB ___ Mobile-l mailing list Mobile-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mobile-l

[WikimediaMobile] Wikimedia Foundation quarterly reviews

...@lists.wikimedia.org Unsubscribe: https://lists.wikimedia.org/mailman/listinfo/wikimedia-l -- Tilman Bayer Senior Analyst Wikimedia Foundation IRC (Freenode): HaeB ___ Mobile-l mailing list Mobile-l@lists.wikimedia.org https://lists.wikimedia.org/mailman

[WikimediaMobile] How a Chaos Monkey Created Wikipedia Mobile

that the mobile site he created is still being used, although with a few new features. [disclaimer: haven't actually listened to the audio] -- Tilman Bayer Senior Analyst Wikimedia Foundation IRC (Freenode): HaeB ___ Mobile-l mailing list Mobile-l

Re: [WikimediaMobile] [Wikimedia-l] Quarterly reviews of high priority WMF initiatives

Foundation Support Free Knowledge: https://wikimediafoundation.org/wiki/Donate ___ Wikimedia-l mailing list wikimedi...@lists.wikimedia.org Unsubscribe: https://lists.wikimedia.org/mailman/listinfo/wikimedia-l -- Tilman Bayer Senior Operations Analyst

Re: [WikimediaMobile] New Android alpha/beta update!

@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mobile-l -- Tilman Bayer Senior Operations Analyst (Movement Communications) Wikimedia Foundation IRC (Freenode): HaeB ___ Mobile-l mailing list Mobile-l@lists.wikimedia.org https