[Foundation-l] Fundraising Data Dump

Troy McConaghy troy.mcconaghy at gmail.com
Thu Mar 19 19:50:32 UTC 2009


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:


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:




and that's all well and good, but then there are rows like this:


and I don't know what to do with those. They have no values for template,
tracking source, or campaign.

Troy McConaghy

On Tue, Mar 17, 2009 at 4:45 AM, Erik Moeller <erik at wikimedia.org> wrote:

> 2009/3/13 Rand Montoya <rmontoya at wikimedia.org>:
> > 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 at lists.wikimedia.org
> Unsubscribe: https://lists.wikimedia.org/mailman/listinfo/foundation-l

More information about the foundation-l mailing list