HubSpot | Email Event Standard Dataset
Below are the measures and dimensions Alight Analytics considers standard for HubSpot - Email Event dataset. There is a two day lag on HubSpot and data is pulled for one day.
| Field Name | Date | Description |
| Report Date | Whole Number | The date the activity occurred. |
| Click | Whole Number | The recipient clicked on a link within the message. |
| Deferred | Whole Number | The recipient's email server has temporarily rejected message, and subsequent attempts will be made to deliver the message. This is also referred to as a soft bounce |
| Unique Deferred | Whole Number | The unique number of deferred messages.. |
| Dropped | Whole Number | The message was rejected, either by HubSpot or by our delivery provider, and no attempt will be made to deliver the message. |
| Unique Dropped | Whole Number | The unique number of dropped messages. |
| Forward | Whole Number | The recipient forwarded the message. |
| Unique Forward | Whole Number | The unique number of forwarded messages. |
| Open | Whole Number | The recipient opened the message. |
| Unique Open | Whole Number | The unique number of opened messages. |
| Sent | Whole Number | The message was sent to and received by our delivery provider. |
| Unique Sent | Whole Number | The unique number of sent messages. |
| Spam Report | Whole Number | The recipient flagged the message as spam. |
| Unique Spam Report | Whole Number | The unique number of spam reports. |
| Status Change | Whole Number | The number of status changes |
| Unique Status Change | Whole Number | The unique number of status changes |
| Delivered | Whole Number | The number of emails delivered. |
| Unique Delivered | Whole Number | The unique number of delivered. |
| Bounce | Whole Number | The number of bounces. |
| Unique Bounces | Whole Number | The number of unique bounces. |
| App ID | Whole Number | An ID referencing the HubSpot Application which sent the email message. |
| App | Dimension | The name of the HubSpot Application which sent the email message. |
| Campaign | Dimension | The Campaign name. |
| Campaign ID | Whole Number | An ID referencing the email campaign which the email message is part of |
| Insert Date | DateTime | Internal use: when the row was inserted in the table |
| ChannelMix Profile | Dimension | When needed, distinguishes between HubSpot accounts - Contents defined by Alight. |