Added in Version 7.0
The MKTGSVC_OPEN table stores all the information collected when a user opens a link within an e-mail from the marketing service. This table contains information including, but not limited to the lead's response ID, the campaign ID, the date a link was opened, status, and information if a target wishes to no longer subscribe to a campaign.
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
MKTGSVC_OPENID (PK) |
char(12) |
NOT NULL |
MKTGSVC_OPEN_OPENID_PK (CA) |
|
|
|
MKTGSVC_RECIPIENTID (FK) |
char(12) |
NOT NULL |
MKTGSVC_OPEN_RECID (IE) |
(Many) to (One) |
|
|
CREATEUSER (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
CREATEDATE |
datetime(8) |
NULLS |
|
|
|
|
MODIFYUSER (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
MODIFYDATE |
datetime(8) |
NULLS |
|
|
|
|
OPENDATE |
datetime(8) |
NULLS |
|
|
|
|
STATUS |
smallint(2) |
NULLS |
|
|
|
|
UNSUBSCRIBECAMPAIGNNAME |
varchar(50) |
NULLS |
|
|
|
|
UNSUBSCRIBEDATE |
datetime(8) |
NULLS |
|
|
|