USP_MKTSEGMENTATIONSEGMENTACTIVE_LOAD

Loads the activated marketing effort segment or test segment calculations.
Parameters

Parameter	Parameter Type	Mode	Description
@SEGMENTID	uniqueidentifier	IN
@TESTSEGMENTID	uniqueidentifier	IN
Definition

Copy


CREATE procedure dbo.[USP_MKTSEGMENTATIONSEGMENTACTIVE_LOAD]
(
  @SEGMENTID uniqueidentifier,
  @TESTSEGMENTID uniqueidentifier = null
)
as
  set nocount on;

  select
    [MKTSEGMENTATIONSEGMENTACTIVE].[IMPRESSIONS],
    [MKTSEGMENTATIONSEGMENTACTIVE].[IMPRESSIONCALCULATIONMETHODCODE],
    [MKTSEGMENTATIONSEGMENTACTIVE].[QUANTITY],
    [MKTSEGMENTATIONSEGMENTACTIVE].[RESPONDERS],
    [MKTSEGMENTATIONSEGMENTACTIVE].[RESPONSES],
    [MKTSEGMENTATIONSEGMENTACTIVE].[VARIABLECOST],
    [MKTSEGMENTATIONSEGMENTACTIVE].[FIXEDCOST],
    [MKTSEGMENTATIONSEGMENTACTIVE].[TOTALCOST],
    [MKTSEGMENTATIONSEGMENTACTIVE].[COSTPERDOLLARRAISED],
    [MKTSEGMENTATIONSEGMENTACTIVE].[TOTALGIFTAMOUNT],
    [MKTSEGMENTATIONSEGMENTACTIVE].[AVERAGEGIFTAMOUNT],
    [MKTSEGMENTATIONSEGMENTACTIVE].[RESPONSERATE],
    [MKTSEGMENTATIONSEGMENTACTIVE].[LIFT],
    [MKTSEGMENTATIONSEGMENTACTIVE].[ROIAMOUNT],
    [MKTSEGMENTATIONSEGMENTACTIVE].[ROIPERCENT],
    [MKTSEGMENTATIONSEGMENTACTIVE].[EXPECTEDCOSTPERDOLLARRAISED],
    [MKTSEGMENTATIONSEGMENTACTIVE].[EXPECTEDRESPONDERS],
    [MKTSEGMENTATIONSEGMENTACTIVE].[EXPECTEDTOTALGIFTAMOUNT],
    [MKTSEGMENTATIONSEGMENTACTIVE].[EXPECTEDROIAMOUNT],
    [MKTSEGMENTATIONSEGMENTACTIVE].[EXPECTEDROIPERCENT],
    [MKTSEGMENTATIONSEGMENTACTIVE].[ORGANIZATIONVARIABLECOST],
    [MKTSEGMENTATIONSEGMENTACTIVE].[ORGANIZATIONFIXEDCOST],
    [MKTSEGMENTATIONSEGMENTACTIVE].[ORGANIZATIONTOTALCOST],
    [MKTSEGMENTATIONSEGMENTACTIVE].[ORGANIZATIONCOSTPERDOLLARRAISED],
    [MKTSEGMENTATIONSEGMENTACTIVE].[ORGANIZATIONTOTALGIFTAMOUNT],
    [MKTSEGMENTATIONSEGMENTACTIVE].[ORGANIZATIONAVERAGEGIFTAMOUNT],
    [MKTSEGMENTATIONSEGMENTACTIVE].[ORGANIZATIONROIAMOUNT],
    [MKTSEGMENTATIONSEGMENTACTIVE].[ORGANIZATIONEXPECTEDCOSTPERDOLLARRAISED],
    [MKTSEGMENTATIONSEGMENTACTIVE].[ORGANIZATIONEXPECTEDTOTALGIFTAMOUNT],
    [MKTSEGMENTATIONSEGMENTACTIVE].[ORGANIZATIONEXPECTEDROIAMOUNT],
    [MKTSEGMENTATIONSEGMENTACTIVE].[BASECURRENCYID],
    [MKTSEGMENTATIONSEGMENT].[EXCLUDE],
    [MKTSEGMENTATIONSEGMENTACTIVE].[COSTTOACQUIRE],
    [MKTSEGMENTATIONSEGMENTACTIVE].[COSTPERTHOUSAND],
    [MKTSEGMENTATIONSEGMENTACTIVE].[NETPERTHOUSAND],
    [MKTSEGMENTATIONSEGMENTACTIVE].[GROSSPERTHOUSAND],
    [MKTSEGMENTATIONSEGMENTACTIVE].[ORGANIZATIONCOSTTOACQUIRE],
    [MKTSEGMENTATIONSEGMENTACTIVE].[ORGANIZATIONCOSTPERTHOUSAND],
    [MKTSEGMENTATIONSEGMENTACTIVE].[ORGANIZATIONNETPERTHOUSAND],
    [MKTSEGMENTATIONSEGMENTACTIVE].[ORGANIZATIONGROSSPERTHOUSAND]
  from dbo.[MKTSEGMENTATIONSEGMENTACTIVE]
  inner join dbo.[MKTSEGMENTATIONSEGMENT] on [MKTSEGMENTATIONSEGMENT].[ID] = [MKTSEGMENTATIONSEGMENTACTIVE].[SEGMENTID]
  where [MKTSEGMENTATIONSEGMENTACTIVE].[SEGMENTID] = @SEGMENTID
  and ((@TESTSEGMENTID is null and [MKTSEGMENTATIONSEGMENTACTIVE].[TESTSEGMENTID] is null) or (@TESTSEGMENTID is not null and [MKTSEGMENTATIONSEGMENTACTIVE].[TESTSEGMENTID] = @TESTSEGMENTID));

  return 0;