FACT_MARKETINGSEGMENTATIONDAILYRESPONSE_STAGE

Intermediate storage table for aFACT_MARKETINGSEGMENTATIONDAILYRESPONSE table.

Fields

Field	Field Type	Null	Notes	Description
MARKETINGSEGMENTATIONDAILYRESPONSESYSTEMID	uniqueidentifier			dbo.[MKTSEGMENTATIONDAILYRESPONSE].[ID]
MARKETINGSEGMENTATIONDIMID	int	yes		Reference key to the marketing effort dimension, derived from dbo.[MKTSEGMENTATION].[ID]
SEGMENTATIONDAYSSINCEFIRSTRESPONSE	tinyint	yes		dbo.[MKTSEGMENTATIONDAILYRESPONSE].[DAYSSINCEFIRSTRESPONSE]
SEGMENTATIONCUMULATIVEREVENUE	money	yes		dbo.[MKTSEGMENTATIONDAILYRESPONSE].[CUMULATIVEREVENUE]
SEGMENTATIONCUMULATIVERESPONSES	int	yes		dbo.[MKTSEGMENTATIONDAILYRESPONSE].[CUMULATIVERESPONSES]
SEGMENTATIONDAILYREVENUE	money	yes		dbo.[MKTSEGMENTATIONDAILYRESPONSE].[DAILYREVENUE]
SEGMENTATIONDAILYRESPONSES	int	yes		dbo.[MKTSEGMENTATIONDAILYRESPONSE].[DAILYRESPONSES]
ISINCLUDED	bit	yes		Flag indicating when data should be included in results.
ETLCONTROLID	int	yes		ID generated through the ETL process.
SOURCEDIMID	int	yes		Source system used.