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 <erik(a)wikimedia.org> wrote:
2009/3/13 Rand Montoya
<rmontoya(a)wikimedia.org>rg>:
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
foundation-l(a)lists.wikimedia.org
Unsubscribe:
https://lists.wikimedia.org/mailman/listinfo/foundation-l