Added in Version 7.0
The MKTGSVC_CLICK table stores all the information collected when a lead clicks 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 clicked, the name of the link, and the link URL.
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
MKTGSVC_CLICKID (PK) |
char(12) |
NOT NULL |
MKTGSVC_CLICK_PK (CA) |
|
|
|
MKTGSVC_RECIPIENTID (FK) |
char(12) |
NOT NULL |
MKTGSVC_CLICK_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 |
|
|
|
|
CLICKDATE |
datetime(8) |
NULLS |
|
|
|
|
LINKNAME |
varchar(20) |
NULLS |
|
|
|
|
LINKURL |
varchar(256) |
NULLS |
|
|
|