Hello, I massaged the data in 2008_Fundraiser.csv.gz and uploaded it to swivel.comwith a CC-BY license. You can see it there, along with summary statistics and graphs at:
http://www.swivel.com/data_sets/show/1017757 If you sort by "Converted Amount (USD)" you'll see that there are 15 donations of 0.00 USD. Even more interesting, all but one of the zero donations came in at 12:00:00 am, but the dates of those zero donations vary. I suspect there's a bug somewhere. There is one donation of 0.01 ILS (Israeli New Shekels), which got converted to 0.00 USD. That one came in on Dec 25, 2008 at 1:32:38 pm. As for the other data set, in 2008_Fundraiser_Tracking.csv.gz, there seems to be some problems with the data, or maybe I don't know how to interpret it. A typical row will look like this: 2008_nometer_2,sitenotice,fundraiser2008,38.24,30.00,EUR,DE or 2008_quote_love_library,sitenotice,fundraiser2008,,,, and that's all well and good, but then there are rows like this: ,,,14.10,10.00,EUR,DE and I don't know what to do with those. They have no values for template, tracking source, or campaign. Sincerely, Troy McConaghy On Tue, Mar 17, 2009 at 4:45 AM, Erik Moeller <[email protected]> wrote: > 2009/3/13 Rand Montoya <[email protected]>: > > The dumps are located here: > http://download.wikipedia.org/fundraising/2008/ > > > > The main gift data files are 2008_Fundraiser.csv.gz. > > The fields are date stamp, USD donation amount, original currency amount, > > original currency, country of donation, & payment type > > (paypal/check/cash/dexia/etc.). > > Because this may have been lost in the high foundation-l traffic, I > just want to underscore the significance of this data release. This > allows anyone to find interesting patterns in the data: whether it's > spikes from specific countries, correlations of donation amounts to > the giving levels featured on the donation pages, effectiveness of > sitenotices by country, etc. In short, this analysis can help us do a > better job at appealing for support. > > Rand is working on pulling together information for a public report on > the 2008-09 fundraiser. If you're working on any analysis based on > these dumps, please add your project to this placeholder page so that > work isn't duplicated: > > http://meta.wikimedia.org/wiki/Fundraising_2008/Report > > Thanks for any help :-) > > Erik > -- > Erik Möller > Deputy Director, Wikimedia Foundation > > Support Free Knowledge: http://wikimediafoundation.org/wiki/Donate > > _______________________________________________ > foundation-l mailing list > [email protected] > Unsubscribe: https://lists.wikimedia.org/mailman/listinfo/foundation-l > _______________________________________________ foundation-l mailing list [email protected] Unsubscribe: https://lists.wikimedia.org/mailman/listinfo/foundation-l
