Hey All--
Just announcing the data dumps for our fundraiser data for the 2008 Annual Fundraiser.
As always, we like to provide our anonymitized data to the community...both to show our openness and transparency, but also to ask for the communities help in doing analysis and data crunching to aid our future fundraising efforts.
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.).
The main data on the site notices and their effectiveness is 2008_Fundraiser_Tracking.csv.gz. The fields here are template (the name of the site notice we used), tracking source (from where the click came from, campaign (an internal tag), USD converted amount, original currency, and country of donation.
If any in the community could help analyze the site notice data for effectiveness, it would be greatly appreciated.
Also, I would like to thank the Wikimedia tech team for helping make this possible.
If you have any questions, please send them my way.
-Rand
2009/3/13 Rand Montoya rmontoya@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
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@wikimedia.org wrote:
2009/3/13 Rand Montoya rmontoya@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@lists.wikimedia.org Unsubscribe: https://lists.wikimedia.org/mailman/listinfo/foundation-l
2009/3/19 Troy McConaghy troy.mcconaghy@gmail.com:
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?
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: 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 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
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
wikimedia-l@lists.wikimedia.org