http://drupal.org/sandbox/leez/1929728
A drupal module for querying a CiviCRM database for donor patterns (overview, new, lapsed, upgraded, downgraded, maintained) and producing CSV files from the results.
civicrm/donor_stats_export/overview
- creates a CSV with numbers for new, lapsed, upgraded, downgraded and maintained donors for each target year (these are currently hardcoded to be 2009-2012)
Each of these create a CSV with the breakdown of donors (+contact id, name, email, total) that underly the numbers in overview:
civicrm/donor_stats_export/new *total currently includes all donations
civicrm/donor_stats_export/lapsed *total is for previous year (0 for target)
civicrm/donor_stats_export/upgraded *total is for target year
civicrm/donor_stats_export/downgraded *total is for target year
civicrm/donor_stats_export/maintained *total is for target year (same as previous)
If any additional arguments are passed to the module, they will be used as a filter for the source. For example,
civicrm/donor_stats_export/new/caprica/the%20internet will only look at donations with the source field 'caprica' or 'the internet'
definitions of donor groups:
new: donor's earliest donation is in the target year
lapsed: donor did not give in the target year, but gave in the previous year
upgraded: donor gave more in the target year than in the previous year
downgraded: donor gave less in the target year than in the previous year
maintained: donor gave the same in the target year as in the previous year
