On Fri, Jun 15, 2012 at 2:24 PM, Alexandro Colorado <j...@oooes.org> wrote: > On Wed, Jun 13, 2012 at 12:06 PM, Rob Weir <robw...@apache.org> wrote: > >> Current download count is 3968717. We should hit 4M later today. The >> work Oliver has done to enable the update notifications for OOo 3.3.0 >> users has accelerated the download rate significantly. >> >> And happy anniversary, everyone. It was one year ago today that >> members of the OpenOffice.org community, along with new friends from >> all over the globe moved to Apache. >> >> -Rob >> > > Is there any analytic on this data, like where the downloads came from and > such?
Yes, the stats are collected by SourceForge and can be queried via a REST API. For example, stats for the en_US download for today can be retrieved with this URL: http://sourceforge.net/projects/openofficeorg.mirror/files/stable/3.4.0/Apache_OpenOffice_incubating_3.4.0_Win_x86_install_en-US.exe/stats/json?start_date=2012-06-15&end_date=2012-06-15 That then returns a JSON object, giving the breakdown by OS and country: {"oses": [["Windows", 34041], ["Unknown", 898], ["Linux", 84], ["Macintosh", 50], ["Android", 14], ["BSD", 2]], "end_date": "2012-06-15 00:00:00", "countries": [["United States", 16622], ["United Kingdom", 2363], ["Canada", 2219], ["India", 1930], ["Australia", 1236], ["Singapore", 696], ["Indonesia", 604], ["Nepal", 603], ["Malaysia", 589], ["Romania", 587], ["Philippines", 584], ["Germany", 486], ["Italy", 325], ["South Africa", 312], ["Poland", 299], ["France", 278], ["Thailand", 275], ["Sweden", 270], ["Norway", 257], ["Ireland", 251], ["Japan", 233], ["Viet Nam", 222], ["New Zealand", 212], ["Netherlands", 189], ["Hong Kong", 181], ["Greece", 147], ["China", 146], ["Serbia", 138], ["Bulgaria", 125], ["Turkey", 114], ["Belgium", 104], ["Russia", 102], ["Spain", 100], ["Estonia", 93], ["Bangladesh", 92], ["Lithuania", 86], ["Latvia", 84], ["Switzerland", 81], ["Taiwan", 81], ["Israel", 76], ["Brazil", 74], ["Pakistan", 64], ["United Arab Emirates", 62], ["Korea", 59], ["Finland", 59], ["Puerto Rico", 56], ["Denmark", 56], ["Sri Lanka", 53], ["Kenya", 52], ["Austria", 52], ["Mexico", 52], ["Croatia", 48], ["Ukraine", 47], ["Argentina", 46], ["Europe (specific country unknown)", 40], ["Egypt", 38], ["Hungary", 37], ["Satellite Provider", 34], ["Bosnia and Herzegovina", 33], ["Slovakia", 30], ["Portugal", 30], ["Macedonia", 30], ["Nigeria", 29], ["Slovenia", 27], ["Czech Republic", 27], ["Saudi Arabia", 23], ["Cambodia", 22], ["Chile", 20], ["Malta", 19], ["Georgia", 18], ["Anonymous Proxy", 18], ["Asia/Pacific Region (specific country unknown)", 17], ["Colombia", 17], ["Jamaica", 15], ["Cyprus", 15], ["Iceland", 14], ["Luxembourg", 11], ["Ecuador", 11], ["Peru", 10], ["Panama", 10], ["Belarus", 10], ["Netherlands Antilles", 10], ["Venezuela", 9], ["Trinidad and Tobago", 9], ["Ethiopia", 8], ["Montenegro", 8], ["Qatar", 8], ["Kuwait", 8], ["Costa Rica", 8], ["Uruguay", 8], ["Isle Of Man", 8], ["Jordan", 8], ["Guatemala", 7], ["Ghana", 7], ["Guernsey", 7], ["Fiji", 7], ["Zambia", 7], ["Zimbabwe", 7], ["Botswana", 7], ["Bolivia", 6], ["Tanzania", 6], ["Moldova", 6], ["Dominica", 6], ["Bahrain", 5], ["Virgin Islands", 5], ["Armenia", 5], ["Dominican Republic", 5], ["Morocco", 5], ["Lebanon", 5], ["Honduras", 5], ["Aruba", 4], ["Cayman Islands", 4], ["Mauritius", 4], ["Faroe Islands", 4], ["El Salvador", 4], ["Barbados", 4], ["Sudan", 4], ["Guam", 3], ["Saint Lucia", 3], ["Mongolia", 3], ["Brunei Darussalam", 3], ["Algeria", 3], ["Liechtenstein", 3], ["Syria", 3], ["Guadeloupe", 3], ["Namibia", 3], ["Cameroon", 2], ["Jersey", 2], ["Albania", 2], ["Azerbaijan", 2], ["Saint Kitts and Nevis", 2], ["Libya", 2], ["Belize", 2], ["\u00c5land Islands", 2], ["Iraq", 2], ["Reunion", 2], ["Madagascar", 2], ["Saint Vincent and The Grenadines", 2], ["Senegal", 2], ["Martinique", 2], ["Myanmar", 2], ["Paraguay", 2], ["Saint Pierre and Miquelon", 1], ["Burkina Faso", 1], ["Cape Verde", 1], ["Macao", 1], ["Afghanistan", 1], ["Bermuda", 1], ["Togo", 1], ["Tajikistan", 1], ["Mali", 1], ["Angola", 1], ["Uganda", 1], ["Bahamas", 1], ["Gibraltar", 1], ["Ivory Coast", 1], ["Northern Mariana Islands", 1], ["Haiti", 1], ["Lao People's Democratic Republic", 1], ["Gambia", 1], ["Djibouti", 1], ["Rwanda", 1], ["Burundi", 1], ["Suriname", 1], ["Papua New Guinea", 1], ["Kazakhstan", 1], ["Mayotte", 1]], "downloads": [["2012-06-15 00:00:00", 35089]], "messages": [], "period": "daily", "start_date": "2012-06-15 00:00:00", "total": 35089, "stats_updated": "2012-06-15 18:01:19", "summaries": {"os": {"top": "Windows", "percent": 97, "modifier_text": ""}, "geo": {"top": "United States", "percent": 47, "modifier_text": ""}, "time": {"downloads": 35089}}} (Hmmm one download from Mayotte. I had to check Wikipedia for that.) More info on the API is here: http://sourceforge.net/p/forge/documentation/Download%20Stats%20API/ Note also that I have a python script that wraps this checked in here: https://svn.apache.org/repos/asf/incubator/ooo/devtools/aoo-stats/ > There used to be some scripts that used to parse this for every release, > site traffic, mailing list traffic etc. > http://www.openoffice.org/stats/ > MirrorBrain and Bouncer used to provide also a comprehensive report on this > downloads as well. > http://www.openoffice.org/marketing/marketing_bouncer.html > I think we have some good automation for the download counts, via the SourceForge API. Right now I update the website manually with the data, but I'm looking into automating that part. There was once some good charts for the mailing lists, Apache-wide here: http://pulse.apache.org/ But that appears to have died. If you have any scripts or ideas on getting reports from the archives or MarkMail, that might be useful. As for site visitors, we have Google Analytics on some of key webpages, but not side-wide. The free GA has rate limits, per day and per month: http://support.google.com/analytics/bin/answer.py?hl=en&answer=1070983 Regards, -Rob > Regards.
