[Foundation-l] Fundraising Data Dump

[Troy McConaghy]

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 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
>