Marketing Campaigns Table Formats (MktCampaign)
Follow DPS specifications for preparing a file containing marketing campaign data.
| Field Name | Data Type | Length | Notes |
|---|---|---|---|
| CampaignID | varchar | 32 | Internal reference number for the marketing campaign record; primary key |
| Name | varchar | 100 | Marketing campaign's name; required field |
| Number | varchar | 50 | Marketing campaign's number |
| Description | text | 16 | User-entered description of the marketing campaign |
| Org | varchar | 14 | Marketing campaign's Organization; null or must exist in Organization |
| Type | varchar | 10 | Marketing campaign's type; CFGCampaignType (Code/Description) |
| Audience | varchar | 10 | Marketing campaign's audience; CFGCampaignAudience (Code/Description) |
| Objective | varchar | 10 | Marketing campaign's objective; CFGCampaignObjective (Code/Description) |
| Budget | decimal | 9 | Marketing campaign's budget |
| ActualCost | decimal | 9 | Marketing campaign's actual cost |
| Revenue | decimal | 9 | Marketing campaign's revenue |
| CampaignMgr | varchar | 20 | Employee number of the marketing campaign's campaign manager; null or must exist in EM |
| MktgMgr | varchar | 20 | Employee number of the marketing campaign's marketing manager; null or must exist in EM |
| Manager3 | varchar | 20 | Employee number of a third manager for the marketing campaign, as selected in the Manager3 field; null or must exist in EM |
| LaunchDate | datetime | 8 | Marketing campaign's launch date |
| EndDate | datetime | 8 | Marketing campaign's end date |
| FirstAction | varchar | 10 | First action in the marketing campaign; CFGCampaignAction (Code/Description) |
| CurrentAction | varchar | 10 | Current action in the marketing campaign; CFGCampaignAction (Code/Description) |
| NextAction | varchar | 10 | Next action in the marketing campaign; CFGCampaignAction (Code/Description) |
| Status | varchar | 10 | Marketing campaign's status; CFGCampaignStatus (Code/Description) |
| PotentialResponses | smallint | 2 | User-entered number of total potential responses to the campaign |
| RecordStatus | varchar | 10 | Marketing campaign record's status; valid options are Active and Inactive |
| WBS1 | varchar | 30 | Marketing campaign's promotional project |
| WBS2 | varchar | 7 | Marketing campaign's promotional phase |
| WBS3 | varchar | 7 | Marketing campaign's promotional task |
| CustomCurrencyCode | varchar | 3 | Currency code of any custom currency fields in the Marketing Campaigns hub |