File Layouts for Launch State
NOTES:
-
All timestamps are presented in UTC with this format: DD-Mon-YYYY HH24:MI:SS, where DD is the day, Mon is the month abbreviation (Jan for January), YYYY is the year, HH24 is the hour expressed in 24-hour notation (00 through 23), MI is minutes, and SS is seconds.
-
Post-19A, if you change a campaign’s name, folder, marketing program, marketing strategy, subject line, or external campaign ID, then historical and new launches for both triggered and standard launches will take these new values in Insight. This update applies to all channels and does not impact the CED behavior as CED retains an unchanged ‘snapshot’ of values.
Launch State
|
Field Name |
Type and Max Length |
Null? |
Description/Comments |
|---|---|---|---|
|
ACCOUNT_ID |
NUMBER |
NO |
Account number (for example. 1234) |
|
LIST_ID |
NUMBER |
|
Numerical identifier for the List object used by the Campaign |
|
EVENT_CAPTURED_DT |
TIMESTAMP |
NO |
Date and time the system was informed about the event |
|
EVENT_STORED_DT |
TIMESTAMP |
NO |
Date the event transaction was stored into the Event DB |
|
CAMPAIGN_ID |
NUMBER |
|
Numerical identifier of the specific campaign |
|
LAUNCH_ID |
NUMBER |
NO |
Numerical identifier of the launch instance |
|
EXTERNAL_CAMPAIGN_ID |
VARCHAR2(255) |
|
A string value matching the campaign name assigned by your Web analytics package for the specific campaign Used to associate system events to events and data in your Web analytics package |
|
SF_CAMPAIGN_ID |
VARCHAR2(255) |
|
A string value matching the ID of the associated Salesforce campaign object Only used with Connect for Salesforce integration. |
|
CAMPAIGN_NAME |
VARCHAR2(255)
|
|
Name of the Campaign. |
|
LAUNCH_NAME |
VARCHAR2(255) |
|
Used internally |
|
LAUNCH_STATUS |
CHAR(1) |
NO |
The state of the campaign launch at the time of the event row. See Launch Status Values for more information. |
|
LAUNCH_TYPE |
CHAR(1) |
NO |
The method by which the campaign was launched. See Launch Type Values for more information.
|
|
LAUNCH_CHARSET |
VARCHAR2(255) |
|
Language character set for the campaign. Normally, this value is either ISO-8859-1 or UTF-8, but depends on the exact campaign configuration. |
|
PURPOSE |
CHAR(1) |
|
Campaign purpose: Promotional or Transactional. P = promotional T = transactional |
|
SUBJECT |
VARCHAR2(255) |
|
The campaign’s subject line. Can include built-in functions, as this the raw subject line as configured in the Campaign Dashboard. |
|
DESCRIPTION |
VARCHAR2(4000) |
|
Campaign Description, as entered in the Campaign Dashboard. |
|
PRODUCT_CATEGORY |
VARCHAR2(255) |
|
Ignored |
|
PRODUCT_TYPE |
VARCHAR2(255) |
|
Ignored |
|
MARKETING_STRATEGY |
VARCHAR2(255) |
|
Marketing Strategy Category as configured in the Campaign Dashboard. Possible values are configured in the account’s Administrative Configuration screens available to the admin user.
|
|
MARKETING_PROGRAM |
VARCHAR2(255) |
|
Marketing Program Category as configured in the Campaign Dashboard. Possible values are configured in the account’s Administrative Configuration screens available to the admin user. |
|
LAUNCH_ERROR_CODE |
VARCHAR2(255) |
|
|
|
LAUNCH_STARTED_DT |
TIMESTAMP |
|
|
|
LAUNCH_COMPLETED_DT |
TIMESTAMP |
|
|
|
CUSTOM_PROPERTIES |
|
YES |
Not applicable to LAUNCH_STATE. If included in the feed, the default value is null. |
|
DISPATCHABLE_TYPE |
VARCHAR2(100) |
NO |
Optional. Campaign type associated with the LAUNCH_STATE record: PromotionalCampaign = Promotional email campaign TransactionalCampaign = Transactional email campaign WebformCampaign = Oracle Responsys form PushIOCampaign = Push campaign MobileInAppCampaign = In-App campaign MmsCampaign = MMS campaign SmsCampaign = SMS campaign |
|
PROGRAM_ID |
NUMBER |
YES |
Optional. Numerical identifier for the given program. Only has a value when the launch occurred through Program. |
|
BRAND_ID |
NUMBER |
YES |
Optional. Brand ID associated with the campaign (by way of the profile list associated with the campaign). |
|
CREATOR_NAME |
VARCHAR2 (255) |
YES |
Optional. Login username of the person who created the campaign. |
|
CUSTOM_PROPERTIES |
|
|
|