Repeat Contribution Report

This report allows the user to analyze repeat contributions, contributions that come from the same contact during two periods.

The user defines to date ranges, period_1 and period_2. In addition, the user defines grouping variables.

For example, the user may want to see how people who contributed in 2007 and 2008 changed in their contribution behavior (e.g. did average contribution increase/decrease, did the average number of contributions per donor increase/decrease).

The report also allows the user to select grouping variable (e.g. postal code). Returning to the example, the user could analze the

Report Columns

Grouping Variables
Contribution Count in 1st Period
Sum of Contributions in 1st Period
Average Contribution in 1st Period
Average Number of Contributions per Contributor in 1st Period
Contributions Count in 2nd Period
Sum of Contributions in 2nd Period
Average Contributions in 1st Period
Average Number of Contributions per Contributor in 1st Period
Count of Contributors in 1st Period
Count of Contributors in 2nd Period
Count of Contributors who gave in the 1st and 2nd Period
Contribution Count of Repeat Contributors in 1st Period
Contribution Count of Repeat Contributors in 2nd Period
Sum of Contributions of Repeat Contributors in 1st Period
Sum of Contributions of Repear Contributors in 2nd Period
Average Contribution of Repeat Contributors in 1st Period
Average Number of Contributions per Repeat Contributor in 1st Period
Average Contribution of Repeat Contributors in 2nd Period
Average Number of Contributions per Repeat Contributor in 2nd Period

Optional Columns

Filters

Period 1 (Date Range)
Period 2 (Date Range)

Default Filter Values

URL options

Sub-total columns

Other Options

Totals on all columns that are counts or amounts. Global averages for columns with averages.
Group By Variables: country, postal code, ?????

Permissions

Access CiviContribute

SQL

Here is some prortype SQL for pulling some of the columns grouped by postal code: