FACT_REVENUECAMPAIGN_STAGE
The Revenue Campaign fact contains campaign information about revenue.
Fields
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| REVENUECAMPAIGNSYSTEMID | uniqueidentifier | yes | dbo.[REVENUESPLITCAMPAIGN].[ID] | |
| REVENUEAPPLICATIONSYSTEMID | uniqueidentifier | yes | dbo.[REVENUESPLITCAMPAIGN].[REVENUESPLITID] | |
| CAMPAIGNDIMID | int | yes | Reference key to the campaign dimension, derived from dbo.[REVENUESPLITCAMPAIGN].[CAMPAIGNID] | |
| CAMPAIGNPRIORITYDIMID | int | yes | Reference key to the campaign priority dimension, derived from dbo.[REVENUESPLITCAMPAIGN].[CAMPAIGNSUBPRIORITYID] | |
| ISINCLUDED | bit | yes | Flag indicating when data should be included in results. | |
| SOURCEDIMID | int | yes | Source system used | |
| ETLCONTROLID | int | yes | ID generated through the ETL process |