Email OneView
Below are the fields for the Email OneView dataset. The sources that populate a OneView can be customized to your data specifications and email data source, however, the datasets that are available in the standard Email OneView configuration are:
- Act-On (v_act_on_message_statistics)
- Campaign Monitor (v_campaign_monitor_summary)
- Constant Contact (v_constant_contact_campaign_performance)
- Emfluence (v_emfluence_email)
- Exact Target (v_exact_target_send)
- Hubspot (v_hubspot_event)
- IBM Watson (v_ibm_watson_email_mailing)
- Mailchimp (v_mailchimp)
- Pardot (v_pardot_email)
- Snappy Kraken (v_snappy_kraken_activity)
| Field | Field Type | Description |
| Report Date | Date | Date the email was sent |
| Sent Time | Timestamp | Time the email was sent |
| Campaign ID | String | ID of the campaign under which the email was sent |
| Campaign | String | Campaign under which the email was sent |
| From Email | String | Email address from which the email was sent |
| From Name | String | Name associated to the email from which the email was sent |
| Subject | String | Subject of the email |
| Sends | Integer | Number of emails sent |
| Deliveries | Integer | Number of emails delivered |
| Opens | Decimal | Number of emails opened |
| Unique Opens | Integer | Number of individual users that opened the email |
| Clicks | Integer |
Number of clicks |
| Unique Clicks | Integer |
Number of individual users that clicked |
| Bounces | Integer |
Number of bounces |
| Forwards | Integer |
Number of times the email was forwarded |
| Spam Complaints | Integer |
Number of times the email was reported as spam |
| Unsubscribes | Integer |
Number of times users unsubscribed through this email |
| Data Source | String |
The data source from where the record originated |
| Campaign Key | String | The Campaign Key associated with the campaign metadata |
| Insert Date | Timestamp | Time data was inserted into the table. |
|
Client ID |
String | Internal metadata |
|
Client Name |
String | The client associated to the data |
|
Profile ID |
String | Internal metadata |
|
Profile Name |
String |
A descriptive name for the segment of data from each data source
|