FACT_MARKETINGREVENUE_STAGE

The marketing revenue fact table lists the marketing information for revenue.

Fields

Field	Field Type	Null	Notes	Description
REVENUESYSTEMID	uniqueidentifier	yes		dbo.[REVENUESEGMENT].[REVENUEID]
MARKETINGSEGMENTDIMID	int	yes		Reference key to the marketing segment dimension, derived from dbo.[REVENUESEGMENT].[SEGMENTID] and dbo.[REVENUESEGMENT].[TESTSEGMENTID]
MARKETINGSOURCECODEDIMID	int	yes		Reference key to the marketing source code dimension, derived from dbo.[REVENUESEGMENT].[SOURCECODEMAPID]
MARKETINGSEGMENTATIONDIMID	int	yes		Reference key to the marketing effort dimension, derived from dbo.[MKTSEGMENTATION].[ID]