This article serves the purpose of explaining the fields that are included in a Twilio SendGrid Email Activity CSV export file. Below are the fields that are included in every Email Activity export. The presence of data in each field will depend on the associated event.
Field Definitions
| Field Name | Description |
| processed | The time when the event was processed. The format is in UNIX timestamp. |
| message_id |
This is an unique, internal Twilio SendGrid ID for the message. The first half of this ID is pulled from the “smtp-id”. This ID can be used to retrieve activity data for the specific message. ** A unique ID assigned to the message. This ID can be used to retrieve activity data for the specific message. |
| event | The event type. Possible values are processed, dropped, delivered, deferred, bounce, open, click, spam report, unsubscribe, group unsubscribe, and group resubscribe. |
| api_key_id | ID of the API Key used to send the message |
| recv_message_id | X-Message-ID that is returned to the system making the API call when reaching our Mail Send endpoint. This ID is the first half of the message_id. |
| credential_id | **Please disregard this field. It is for SendGrid internal use only.** |
| subject | Subject of the email |
| from | Sender email address |
| Recipient email address | |
| asm_group_id | ID number of the Unsubscribe Group. Found within the Suppression -> Unsubscribe Group page |
| template_id | Dynamic Template ID |
| originating_ip | External IP address used to send the email request to Twilio SendGrid |
| reason | Response returned by the receiving server that describes the reason this event type was triggered. |
| outbound_ip | Twilio SendGrid IP address used to deliver the email with. |
| outbound_ip_type | The type of IP the Twilio SendGrid account is using; Dedicated or Shared |
| mx | The recipient mail server. |
| attempt | The number of attempts Twilio SendGrid has tried to deliver the email. |
| url | URL that is associated with the Click event |
| user_agent | The user agent responsible for the event. This is usually a web browser information. |
| type | Only associated with Bounce events and refers to the type of rejection that occurred. This can either be a hard bounce (Bounce) or a soft bounce (Blocked). |
| is_unique | Only associated with Click or Open events and refers to whether or not the event was a Unique Click or Unique Open. This can either be TRUE or FALSE. |
| username | ***refers to the teammate username, however for email delivery and engagement events this field is not relevant*** |
| categories | Categories are custom tags that you set for the purpose of organizing your emails. |
| marketing_campaign_id | Campaign ID of the Legacy Marketing Campaign |
| marketing_campaign_name | Name of the Legacy Marketing Campaign |
| marketing_campaign_split_id | A/B testing ID of the Legacy Marketing Campaign |
| marketing_campaign_version | Event data for Legacy Marketing Campaign emails sent as part of an A/B Test. The value for marketing_campaign_version are returned as A, B, C, etc. |
| unique_args | Information of unique arguments or custom arguments in the customer’s payload |