[Foundation-l] Fundraising Data Dump

[Troy McConaghy]

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 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
> 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 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
> 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
> foundation-l at lists.wikimedia.org
> Unsubscribe: https://lists.wikimedia.org/mailman/listinfo/foundation-l
>