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 <[email protected]> To: Wikimedia Foundation Mailing List <[email protected]> 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 <[email protected]> wrote: > > > Thomas Dalton <thomas.dal...@...> writes: > > > > > 2009/3/19 Troy McConaghy <troy.mccona...@...>: > > > 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 > > foundatio...@... > > 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: > 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 > > > _______________________________________________ > foundation-l mailing list > [email protected] > Unsubscribe: https://lists.wikimedia.org/mailman/listinfo/foundation-l > _______________________________________________ foundation-l mailing list [email protected] Unsubscribe: https://lists.wikimedia.org/mailman/listinfo/foundation-l _______________________________________________ foundation-l mailing list [email protected] Unsubscribe: https://lists.wikimedia.org/mailman/listinfo/foundation-l
