[Foundation-l] Fundraising Data Dump
phamdinhhaird2002 at yahoo.com
Fri Mar 20 02:42:22 UTC 2009
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 at gmail.com>
To: Wikimedia Foundation Mailing List <foundation-l at lists.wikimedia.org>
Sent: Friday, March 20, 2009 8:22:27 AM
Subject: Re: [Foundation-l] Fundraising Data Dump
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:
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
(blank template) 658,074.82
I also asked swivel to make a similar graph for tracking source instead of
Tracking Source total Converted Amount (USD)
Note: I might have done something wrong and swivel might have done something
wrong. Caveat emptor.
On Thu, Mar 19, 2009 at 5:15 PM, Rand Montoya <rand at wikimedia.org> wrote:
> Thomas Dalton <thomas.dalton at ...> writes:
> > 2009/3/19 Troy McConaghy <troy.mcconaghy at ...>:
> > > 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
> > > 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 at ...
> > Unsubscribe: https://lists.wikimedia.org/mailman/listinfo/foundation-l
> Hey All--
> (I responded to Troy directly...re-posting most of it here with more
> 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
> 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),
> 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.
> foundation-l mailing list
> foundation-l at lists.wikimedia.org
> Unsubscribe: https://lists.wikimedia.org/mailman/listinfo/foundation-l
foundation-l mailing list
foundation-l at lists.wikimedia.org
More information about the foundation-l