| QUANTITY |
int |
|
Default = 0 |
The number of people in the segment that were mailed to. |
| RESPONDERS |
int |
|
Default = 0 |
The number of people in the segment that responded to the marketing effort. |
| RESPONSES |
int |
|
Default = 0 |
The number of gifts from people in the segment that responded to the marketing effort. |
| VARIABLECOST |
money |
|
Default = 0 |
The package costs for the segment. |
| FIXEDCOST |
money |
|
Default = 0 |
The fixed cost for the segment. |
| TOTALCOST |
money |
|
Default = 0 |
The total cost (variable + fixed) for the segment. |
| COSTPERDOLLARRAISED |
money |
|
Default = 0 |
The cost per dollar raised for the segment. |
| TOTALGIFTAMOUNT |
money |
|
Default = 0 |
The total gift amount received for the segment. |
| AVERAGEGIFTAMOUNT |
money |
|
Default = 0 |
The average gift amount received for the segment. |
| RESPONSERATE |
decimal(19, 4) |
|
Default = 0 |
The response rate for the segment. |
| LIFT |
decimal(19, 4) |
|
Default = 0 |
The lift calculation for the segment. |
| ROIAMOUNT |
money |
|
Default = 0 |
The ROI as a dollar amount for the segment. |
| ROIPERCENT |
decimal(19, 4) |
|
Default = 0 |
The ROI as a percentage for the segment. |
| EXPECTEDRESPONDERS |
int |
|
Default = 0 |
The number of expected responders for the segment. |
| EXPECTEDTOTALGIFTAMOUNT |
money |
|
Default = 0 |
The expected total gift amount for the segment. |
| EXPECTEDROIAMOUNT |
money |
|
Default = 0 |
The expected ROI as a dollar amount for the segment. |
| EXPECTEDROIPERCENT |
decimal(19, 4) |
|
Default = 0 |
The expected ROI as a percentage for the segment. |
| 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 segment. |
| IMPRESSIONS |
int |
|
Default = 0 |
For a public media marketing effort, the number of impressions expected for this segment. |
| IMPRESSIONCALCULATIONMETHODCODE |
tinyint |
|
Default = 0 |
For a public media marketing effort, the method to be used to determine the total number of impressions contributed to a marketing effort by the segment. |
| IMPRESSIONCALCULATIONMETHOD |
nvarchar(20) (Computed) |
yes |
CASE [IMPRESSIONCALCULATIONMETHODCODE] WHEN 0 THEN N'Per day' WHEN 1 THEN N'Per marketing effort' END |
Provides a translation for the 'IMPRESSIONCALCULATIONMETHODCODE' field. |
| ORGANIZATIONVARIABLECOST |
money |
|
Default = 0 |
The package costs, in organization currency, for the segment. |
| ORGANIZATIONFIXEDCOST |
money |
|
Default = 0 |
The fixed cost, in organization currency, for the segment. |
| ORGANIZATIONTOTALCOST |
money |
|
Default = 0 |
The total cost (variable + fixed), in organization currency, for the segment. |
| ORGANIZATIONCOSTPERDOLLARRAISED |
money |
|
Default = 0 |
The cost per dollar, in organization currency, raised for the segment. |
| ORGANIZATIONTOTALGIFTAMOUNT |
money |
|
Default = 0 |
The total gift amount, in organization currency, received for the segment. |
| ORGANIZATIONAVERAGEGIFTAMOUNT |
money |
|
Default = 0 |
The average gift amount, in organization currency, received for the segment. |
| ORGANIZATIONROIAMOUNT |
money |
|
Default = 0 |
The ROI as a dollar amount, in organization currency, for the segment. |
| ORGANIZATIONEXPECTEDCOSTPERDOLLARRAISED |
money |
|
Default = 0 |
The expected cost per dollar raised, in organization currency, for the segment. |
| ORGANIZATIONEXPECTEDTOTALGIFTAMOUNT |
money |
|
Default = 0 |
The expected total gift amount, in organization currency, for the segment. |
| ORGANIZATIONEXPECTEDROIAMOUNT |
money |
|
Default = 0 |
The expected ROI as a dollar amount, in organization currency, for the segment. |
| 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 |
|