incubator-ooo-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rob Weir <robw...@apache.org>
Subject Re: 4M later today
Date Fri, 15 Jun 2012 19:23:28 GMT
On Fri, Jun 15, 2012 at 2:24 PM, Alexandro Colorado <jza@oooes.org> wrote:
> On Wed, Jun 13, 2012 at 12:06 PM, Rob Weir <robweir@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.

Mime
View raw message