Assigned to: paulproteus

---------- Forwarded message ----------
Date: Fri, 24 Apr 2009 17:26:41
From: Nathan Kinkade <nkinkade@creativecommons.org>
To: Melissa Reeder <melissa@creativecommons.org>
Cc: Asheesh Laroia <asheesh@creativecommons.org>,
     Nathan Yergler <nathan@creativecommons.org>,
     Allison Domicone <allison@creativecommons.org>
Subject: Re: monthly donation reports

As I started to look at creating custom searches to make Asheesh's
scraping more efficient, I realized that they really aren't necessary.
  The built-in search forms are just fine.  Asheesh, below is a summary
on how to get to the information we need.  Melissa, see the notes for
#4 and #5 below.  CiviCRM generally reports the number of
contributions, not the number of *contributors*.  I suspect that those
two numbers will always be very close to one another.  Is that
acceptable, or do I need to make custom searches for those?

Asheesh,  my PHP script is located at
a9:/var/www/support.creativecommons.org/bin/donations_stats.php.  It
outputs an HTML table to STDOUT, which you could drop into your
~/public_html directory if you want to check your numbers or compare.
An example of the output is here:

http://a9.creativecommons.org/~nkinkade/donations.html

It's pretty ugly, and negative numbers look like $-156,000, but I
*think* it should be accurate.  Melissa, I just put that HTML file
there, so the numbers are current as of the writing of this email.

Let me know if you need anything else for now.

Nathan

* Go to: https://support.creativecommons.org/civicrm/contribute/search?reset=1
* Fill out appropriate date range fields.
* Check "Completed" for Contribution Status
* Select "Donation" for Contribution Type

* Same as #1.

* Go to: https://support.creativecommons.org/civicrm/contact/search/custom?csid=13&reset=1
* Fill in Minimum contribution with, say, 1 so that we only get people
who actually gave something
* Fill in date ranges, then check "First time donor only?"

* Same as #1 ... the results page tells you the number of
contributions.  Subtract the number of "First time donors" from #3
from the number of contributions from this search.  Granted, this
could yield very slightly skewed results if someone contributed more
than once, but in the period of some number of months it's unlikely
that the number of people who donated multiple times in that period
will be more than a very small handful.

* Same as #1 ... just grab number of contributions from results page.
Again, this is the number of contributions, no contributors, so the
numbers could be off by a few.

* Same as #1 ... the results page includes an average donation amount.

* Repeat all of the above with "Store" selected for Contribution Type

On Fri, Apr 24, 2009 at 3:53 PM, Melissa Reeder
<melissa@creativecommons.org> wrote:
> Ok. Can we get an updated eta? Just wanting to know if I need to run these
> reports manually for beginning of May board/sen. staff report or if this
> will be up and running by then.
>
> Thanks,
>
> M