Marketing Campaign Fact
Module: Marketing Campaigns
CAMPAIGN_ID
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
---|---|---|---|---|---|---|---|
CAMPAIGN_ID | NUMBER | 38 | 0 | True | Primary key. | ||
SOURCE_RECORD_ID | VARCHAR2 | 256 | Unique Identifier | ||||
STRING_CAMPAIGN_ID | VARCHAR2 | 256 | Unique Identifier | ||||
CAMPAIGN_ACTUAL_COST | NUMBER | Amount of money spent to run the campaign. | |||||
CAMPAIGN_BUDGETED_COST | NUMBER | Amount of money budgeted for the campaign. | |||||
CAMPAIGN_CURRENCY_CODE | VARCHAR2 | 16 | Currency code | DW_CURRENCY_DETAILS_D_TL | CURRENCY_CODE | ||
CAMPAIGN_OWNER_RESOURCE_PARTY_ID | NUMBER | 38 | 0 | Owner of the campaign row. | DW_CXS_RESOURCE_D | RESOURCE_ID | |
CAMPAIGN_CREATED_BY | VARCHAR2 | 64 | Campaign Created By | ||||
CAMPAIGN_REGION_CODE | VARCHAR2 | 128 | Region code of the Campaign. | ||||
CAMPAIGN_NAME | VARCHAR2 | 128 | Name of the campaign | ||||
CAMPAIGN_START_DATE | DATE | Starting Date for the campaign | |||||
CAMPAIGN_START_TIMESTAMP | TIMESTAMP | Starting TIMESTAMP for the campaign | |||||
CAMPAIGN_END_DATE | DATE | Ending date for the campaign. Responses received after this date are still counted | |||||
CAMPAIGN_END_TIMESTAMP | TIMESTAMP | Ending TIMESTAMP for the campaign. Responses received after this date are still counted | |||||
CAMPAIGN_PRODUCT_DESCRIPTION | VARCHAR2 | 128 | Product Name on the Campaign. | ||||
CAMPAIGN_STATUS_CODE | VARCHAR2 | 32 | Status code of the Campaign created. ('ORA_DRAFT', 'ORA_COMPLETED, ORA_ACTIVE') | DW_CXM_CAMPAIGN_STATUS_D_TL | CODE | ||
CAMPAIGN_TYPE_CODE | VARCHAR2 | 32 | Type of campaign. ( 'ORA_EVENT','ORA_BLOG_POST') | DW_CXM_CAMPAIGN_TYPE_D_TL | CODE | ||
CAMPAIGN_DESCRIPTION | VARCHAR2 | 999 | Description of the campaign | ||||
CAMPAIGN_ACTIVE_FLAG | VARCHAR2 | 16 | Indicates whether the campaign is active('Y') or not ('N') | ||||
GLOBAL_CURRENCY_CAMPAIGN_ACTUAL_COST | NUMBER | Campaign actual cost in global currency | |||||
GLOBAL_CURRENCY_CAMPAIGN_BUDGETED_COST | NUMBER | Campaign budgeted cost in global currency | |||||
GLOBAL_CURRENCY_CODE | VARCHAR2 | 16 | Global currency code. | DW_CURRENCY_DETAILS_D_TL | CURRENCY_CODE | ||
CAMPAIGN_CREATION_DATE | DATE | Campaign Creation date | |||||
CAMPAIGN_CREATION_TIMESTAMP | TIMESTAMP | Campaign Creation TimeStamp | |||||
CREATION_DATE | DATE | Who column: indicates the date of the creation of the row. | |||||
CREATED_BY | VARCHAR2 | 64 | Who column: indicates the user who created the row. | ||||
CREATION_TIMESTAMP | TIMESTAMP | Campaign Creation TimeStamp | |||||
CAMPAIGN_CATEGORY_CODE | VARCHAR2 | 32 | Category of the Campaign | DW_CXM_CAMPAIGN_CATEGORY_D_TL | CODE |
Copyright © 2019, 2023, Oracle and/or its affiliates.