Snappy Kraken | Activity Standard Dataset
This article details the fields ChannelMix considers standard for Snappy Kraken - Activity. Data is pulled daily for the last 7 days with a 1 day lag.
| Field | Type | Description |
| report_date | timestamp | The system generated date and time that activity occured |
| Vessel ID | Whole Number | Vessel ID |
| Vessel | Text | Vessel |
|
Campaign ID |
Whole Number | Campaign ID |
| Campaign | Whole Number | Campaign |
| Step ID | Whole Number | Step ID |
| Step | Text | Step |
| Contact Name | Text | Contact Name |
| Contact Email | Text | Contact Email |
| Contact ID | Whole Number | Contact ID |
| Activity Type | Text | Activity Type |
| Opens | Whole Number | Opens |
| Clicks | Whole Number | Clicks |
| Emails | Whole Number | Emails |
| Views | Whole Number | Views |
| Form Submissions | Whole Number | Form Submissions |
| Click URL | Text | Click URL |
| Open Submitted | Boolean | Open Submitted |
| From Email | Text | Email address the email was sent from |
| From Name | Text | Name the email was sent from. |
| Reply Email | Text | The email the reply was sent from |
| Mail ID | Text | Mail ID |
| Email Subject | Text | Subject of email |
| Form ID | Whole Number | Form ID |
| Form Target Step ID | Whole Number | Form Target Step ID |
| Form Submission ID | Whole Number | Form Submission ID |
| Form Submitted Step ID | Whole Number | Form Submitted Step ID |
| Form Submitted Vessel ID | Text | Form Submitted Vessel ID |
| Form Submitted Campaign ID | Text | Form Submitted Campaign ID |
| Form Submitted First Name | Text | First name on the submitted form |
| Form Submitted Last Name | Text | Last name on the submitted form |
| Form Submitted Phone Number | Text | Phone number on the submitted form |
| Insert Date | Timestamp | ChannelMix Field: when the row was inserted into the dataset. |
| ChannelMix Profile | Text | ChannelMix Field: the ChannelMix Profile associated with the data. |