Understanding Your Twilio SendGrid Email Activity CSV Export Fields


Navigating through your Twilio SendGrid Email Activity CSV export might seem daunting at first, but fear not! This guide is here to illuminate the path by explaining each field in detail. Whether you're a seasoned email veteran or new to the scene, understanding these fields will significantly enhance your email monitoring and analysis capabilities. Let’s dive in!


Field Definitions: Your Data Decoded

Below is a breakdown of every field included in the Email Activity export. The presence of data within each field depends on the event associated with each email activity record.


Field Definitions

Field Name Description
processed The time when the event was processed. The format is in UNIX timestamp.

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


Got More Questions?

This dive into Twilio SendGrid's CSV export fields might resemble mining through data treasures – because it kind of is! Every bit helps you understand how recipients interact with your emails, paving ways to optimize future sends.

If anything seems less than crystal clear or if there are more layers you wish to peel back, we’re here! Remember, mastering your email analytics begins with knowing what you're looking at – so keep this guide handy as you scale new heights with Twilio SendGrid.

Happy Emailing! Reach out anytime – We're excited to assist you in harnessing our feature-rich service effectively!

Have more questions? Submit a request