emailevents
The emailevents table describes the email activity that is available for a participant.
Table Schema
| Name | Type | Description |
|---|---|---|
| personid | VARCHAR |
Internal identifier to specify a unique instance of a person. This column is used to partition data tables in the Bulk Data API and should be included on all table joins. Use personid to join to tables in other models within the Bulk Data API. |
| participantkey | VARCHAR |
Internal identifier to specify a unique instance of a participant in an RKStudio project. Key relationship with the participant table. |
| emaileventkey | VARCHAR |
Internal identifier to specify a unique instance of email event. |
| clickurl | VARCHAR |
URL that was clicked in the email |
| eventtype | VARCHAR |
Bounce, Click, Complaint, Delivery, Open or Send |
| messageid | VARCHAR |
Internal identifier to specific a unique email message |
| source | VARCHAR |
Email Source |
| projectname | VARCHAR |
The name of the project to which this participant is associated. The project name is displayed in RKStudio to project coordinators. |
| projectdisplayname | VARCHAR |
The display name of the project to which this participant is associated. The project display name is displayed to participants in the MyDataHelps app. |
| template | VARCHAR |
Email template |
| time | TIMESTAMP |
Email Sent Time |
| opentime | TIMESTAMP |
Email Open Time |
| clicktime | TIMESTAMP |
Email Click Time |
| clicklinktagslink | VARCHAR |
Email Tag Links |
| clicklinktagscategories | VARCHAR |
Email Tag Categories |
| clicklinktagsarticle | VARCHAR |
Email Tag Article |
