Marketing Campaigns Table Formats (MktCampaign)
Follow Vision 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 Info Center |