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 troy.mcconaghy@gmail.com To: Wikimedia Foundation Mailing List foundation-l@lists.wikimedia.org 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 rand@wikimedia.org wrote:
Thomas Dalton <thomas.dalton@...> writes:
2009/3/19 Troy McConaghy <troy.mcconaghy@...>:
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.
Could they be people that went direct to the donation page (donate link in the sidebar, typing in the URL, link from another site, etc.) rather than clicking on a site notice?
foundation-l mailing list foundation-l@... Unsubscribe: https://lists.wikimedia.org/mailman/listinfo/foundation-l
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:
- 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
foundation-l mailing list foundation-l@lists.wikimedia.org Unsubscribe: https://lists.wikimedia.org/mailman/listinfo/foundation-l
_______________________________________________ foundation-l mailing list foundation-l@lists.wikimedia.org Unsubscribe: https://lists.wikimedia.org/mailman/listinfo/foundation-l