Reading Email Activity Feed CSV Exports

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
email 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
Have more questions? Submit a request