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:

Thomas Dalton <thomas.dalton@...> writes: Hey All-- (I responded to Troy directly...re-posting most of it here with more information.) Yes, there will be many donations for 0.00 USD and for many different reasons, including, but not limited to: 1) Refunds via paypal (They still may exist as gift records...but null transactions. We attempted to pull all these, but some may be lingering.) 2) 1 yen contributions (or similar low exchange currency) than can translate to 0.00 USD 3) Soft-credits for matching gift information. (If they happen all at once, they are soft credits for a company...where the company can give one donation that is soft credited towards many employees.) 4) Something else...we've done the best we can. As for the site notices, since our tracking mechanism was dependent on the donor going directly from a (the site notice) to b (the donation page), it sometimes was skewed if the donor went to a, then c (donor comments), then d (the transparency page) then b. It could also be the donor was linked directly via another web page or blog post or something like that. And like Thomas said, if a donor went directly from the donate link in the WP sidebar, they wouldn't have any tracking information either. So, yes, not every value will have tracking information. In a perfect world, we'd like to analyze the trackable data and see what kind of cool info comes out in terms of donation trends from countries via certain site notices and so forth. -Rand

Hello, I received your email. Do you want to co-operate with me for a new project - planting Jatropha in Vietnam. and manufacture Biodiesel. All the Bests. Pham Dinh Hai ________________________________ From: Troy McConaghy &lt;troy.mcconaghy(a)gmail.com&gt; To: Wikimedia Foundation Mailing List &lt;foundation-l(a)lists.wikimedia.org&gt; Sent: Friday, March 20, 2009 8:22:27 AM Subject: Re: [Foundation-l] Fundraising Data Dump Hello, I uploaded the 2008 fundraising campaign tracking data (i.e. 2008_Fundraiser_Tracking.csv.gz) into swivel.com, blank fields and all. You can see it and analyze it at: http://www.swivel.com/data_sets/show/1017762 Rand seemed interested in how various templates fared. I asked swivel to graph total Converted Amount (USD) by Template. Below is a list of the top 20 templates in order of total Converted Amount (USD). (Swivel can give the graph as a table.) Template total Converted Amount (USD) ================================================================ 2008_jimmy_letter_r 773,860.41 2008_jimmy_letter 727,368.60 (blank template) 658,074.82 2008_nometer_2 300,727.70 2008_meter_1 293,450.74 2008_meter_2 277,320.68 2008_wiki_is_there_meter 167,323.41 2008_wiki_is_there_learn_meter 113,285.38 2008_has_helped_learn_meter 110,919.17 2008_meter_1c 96,800.03 2008_is_a_nonprofit_meter 94,255.87 2008_needs_you_nonprofit_meter 89,749.44 2008_jimmy_thank_you 85,893.99 2008_nometer_1_collapsed 78,740.51 2008_meter_2c 70,745.89 2008_meter_2b 60,949.65 2008_nometer_1 29,143.18 2008_scales_learn 25,092.43 2008_quote_reading_this 24,877.07 2008_quote_project_beautiful 24,024.07 I also asked swivel to make a similar graph for tracking source instead of template: Tracking Source total Converted Amount (USD) ================================================================ sitenotice 2,038,450.41 jimmy_letter 1,501,229.01 (blank) 658,110.89 jimmy_thank_you 109,533.48 learnmore 36,254.66 2008_sitenotice 43.34 s 25.0 Note: I might have done something wrong and swivel might have done something wrong. Caveat emptor. Sincerely, Troy McConaghy On Thu, Mar 19, 2009 at 5:15 PM, Rand Montoya &lt;rand(a)wikimedia.org&gt; wrote: _______________________________________________ foundation-l mailing list foundation-l(a)lists.wikimedia.org Unsubscribe: https://lists.wikimedia.org/mailman/listinfo/foundation-l