| QUANTITY |
int |
|
Default = 0 |
The number of people that were mailed to for the marketing effort. |
| RESPONDERS |
int |
|
Default = 0 |
The number of people that responded to the marketing effort. |
| RESPONSES |
int |
|
Default = 0 |
The number of gifts from people that responded to the marketing effort. |
| VARIABLECOST |
money |
|
Default = 0 |
The package costs for the marketing effort. |
| TOTALCOST |
money |
|
Default = 0 |
The total cost (variable + fixed) for the marketing effort. |
| COSTPERDOLLARRAISED |
money |
|
Default = 0 |
The cost per dollar raised for the marketing effort. |
| TOTALGIFTAMOUNT |
money |
|
Default = 0 |
The total gift amount received for the marketing effort. |
| AVERAGEGIFTAMOUNT |
money |
|
Default = 0 |
The average gift amount received for the marketing effort. |
| RESPONSERATE |
decimal(19, 4) |
|
Default = 0 |
The response rate for the marketing effort. |
| ROIAMOUNT |
money |
|
Default = 0 |
The ROI as a dollar amount for the marketing effort. |
| ROIPERCENT |
decimal(19, 4) |
|
Default = 0 |
The ROI as a percentage for the marketing effort. |
| EXPECTEDRESPONDERS |
int |
|
Default = 0 |
The number of expected responders for the marketing effort. |
| EXPECTEDTOTALGIFTAMOUNT |
money |
|
Default = 0 |
The expected total gift amount for the marketing effort. |
| EXPECTEDRESPONSERATE |
decimal(19, 4) |
|
Default = 0 |
The expected response rate for the marketing effort. |
| EXPECTEDROIAMOUNT |
money |
|
Default = 0 |
The expected ROI as a dollar amount for the marketing effort. |
| EXPECTEDROIPERCENT |
decimal(19, 4) |
|
Default = 0 |
The expected ROI as a percentage for the marketing effort. |
| INDIRECTRESPONDERS |
int |
|
Default = 0 |
The number of people that indirectly responded to the marketing effort. |
| INDIRECTRESPONSES |
int |
|
Default = 0 |
The number of gifts from people that indirectly responded to the marketing effort. |
| INDIRECTTOTALGIFTAMOUNT |
money |
|
Default = 0 |
The total gift amount indirectly received for the marketing effort. |
| INDIRECTAVERAGEGIFTAMOUNT |
money |
|
Default = 0 |
The average gift amount indirectly received for the marketing effort. |
| DATEADDED |
datetime |
|
Default = getdate() |
Indicates the date this record was added. |
| DATECHANGED |
datetime |
|
Default = getdate() |
Indicates the date this record was last changed. |
| TS |
timestamp |
|
|
Timestamp. |
| TSLONG |
bigint (Computed) |
yes |
CONVERT(bigint, TS) |
Numeric representation of the timestamp. |
| EXPECTEDCOSTPERDOLLARRAISED |
money |
|
Default = 0 |
The expected cost per dollar raised for the marketing effort. |
| EXPECTEDAVERAGEGIFTAMOUNT |
money |
|
Default = 0 |
The expected average gift amount for the marketing effort. |
| UNRESOLVEDRESPONDERS |
int |
|
Default = 0 |
The number of people that gave a gift to the appeal but the gift has not been credited to the marketing effort. |
| UNRESOLVEDRESPONSES |
int |
|
Default = 0 |
The number of gifts that were received for an appeal but the gifts have not been credited to the marketing effort. |
| UNRESOLVEDTOTALGIFTAMOUNT |
money |
|
Default = 0 |
The total gift amount that was received for an appeal but the gifts have not been credited to the marketing effort. |
| UNRESOLVEDAVERAGEGIFTAMOUNT |
money |
|
Default = 0 |
The average gift amount that was received for an appeal but the gifts have not been credited to the marketing effort. |
| ORGANIZATIONVARIABLECOST |
money |
|
Default = 0 |
The package costs, in organization currency, for the marketing effort. |
| ORGANIZATIONTOTALCOST |
money |
|
Default = 0 |
The total cost (variable + fixed), in organization currency, for the marketing effort. |
| ORGANIZATIONCOSTPERDOLLARRAISED |
money |
|
Default = 0 |
The cost per dollar raised, in organization currency, for the marketing effort. |
| ORGANIZATIONTOTALGIFTAMOUNT |
money |
|
Default = 0 |
The total gift amount, in organization currency, received for the marketing effort. |
| ORGANIZATIONAVERAGEGIFTAMOUNT |
money |
|
Default = 0 |
The average gift amount, in organization currency, received for the marketing effort. |
| ORGANIZATIONROIAMOUNT |
money |
|
Default = 0 |
The ROI as a dollar amount, in organization currency, for the marketing effort. |
| ORGANIZATIONEXPECTEDCOSTPERDOLLARRAISED |
money |
|
Default = 0 |
The expected cost per dollar raised, in organization currency, for the marketing effort. |
| ORGANIZATIONEXPECTEDTOTALGIFTAMOUNT |
money |
|
Default = 0 |
The expected total gift amount, in organization currency, for the marketing effort. |
| ORGANIZATIONEXPECTEDAVERAGEGIFTAMOUNT |
money |
|
Default = 0 |
The expected average gift amount, in organization currency, for the marketing effort. |
| ORGANIZATIONEXPECTEDROIAMOUNT |
money |
|
Default = 0 |
The expected ROI as a dollar amount, in organization currency, for the marketing effort. |
| ORGANIZATIONINDIRECTTOTALGIFTAMOUNT |
money |
|
Default = 0 |
The total gift amount, in organization currency, indirectly received for the marketing effort. |
| ORGANIZATIONINDIRECTAVERAGEGIFTAMOUNT |
money |
|
Default = 0 |
The average gift amount, in organization currency, indirectly received for the marketing effort. |
| ORGANIZATIONUNRESOLVEDTOTALGIFTAMOUNT |
money |
|
Default = 0 |
The total gift amount, in organization currency, that was received for an appeal but the gifts have not been credited to the marketing effort. |
| ORGANIZATIONUNRESOLVEDAVERAGEGIFTAMOUNT |
money |
|
Default = 0 |
The average gift amount, in organization currency, that was received for an appeal but the gifts have not been credited to the marketing effort. |
| COSTTOACQUIRE |
money |
|
Default = 0 |
|
| COSTPERTHOUSAND |
decimal(22, 4) |
|
Default = 0 |
|
| GROSSPERTHOUSAND |
decimal(22, 4) |
|
Default = 0 |
|
| NETPERTHOUSAND |
decimal(22, 4) |
|
Default = 0 |
|
| ORGANIZATIONCOSTTOACQUIRE |
money |
|
Default = 0 |
|
| ORGANIZATIONCOSTPERTHOUSAND |
decimal(22, 4) |
|
Default = 0 |
|
| ORGANIZATIONGROSSPERTHOUSAND |
decimal(22, 4) |
|
Default = 0 |
|
| ORGANIZATIONNETPERTHOUSAND |
decimal(22, 4) |
|
Default = 0 |
|
| FIRSTRESPONSEDATE |
datetime |
yes |
|
|