Data fields reported in individual level tracking CSV exports

This article refers to the data fields available in the export tables of the Email Analytics report. The individual-level tracking CSV contains very detailed information. It may contain millions of rows of records and be quite large in file size. This report displays one unique open on each row for the email(s) associated with the tracking code. Here's a quick guide to what you'll find in this report:

Data field Data type Description
created_at timestamp A date/time stamp for when this individual open was recorded. All timestamps used in Email Analytics reports are in GMT (0:00).
custom_type varchar (65535) An optional field containing custom data. It's typically used for including information about the segment the email was sent in. How to add a custom parameter to your tracking code.
mail_client varchar (255) The email client used for this open. For example, Outlook.
mail_client_specific varchar (255) The specific details of the client the email was opened in. Sometimes this is a version number, such as Outlook 2007, it can also be a specific model number of a device, Samsung Galaxy S9, a web browser used to open a web-based email client, Using Internet Explorer, or even a range of versions, such as Outlook 2000-2003.
mail_client_friendly_name varchar (255) Data taken from the mail_client_specific and mail_client fields joined together in a single field, i.e. mail_client_friendly_name = mail_client_specific + mail_client.
rendering_engine varchar (255) The rendering engine used to display the email. This is a superset of the email client. For example, many versions of Outlook, as well as Lotus Notes, use the Internet Explorer engine to render emails. Other versions of Outlook use the Word rendering engine.
platform varchar (255) We categorize platform as desktop, webmail, mobile or image cache.
read_seconds integer (11) The number of seconds the email was opened for. This value will increase if the email is left open, up to a total of 20 seconds, which is when we stop recording. More about engagement tracking.
read_category varchar (255) We group the read_seconds into three broader categories - Glanced, Skimmed and Read.
city This field is blank as of January 2022 To align with rising data privacy protection measures and to protect the privacy of your subscribers, Litmus removed the geolocation data from Litmus Email Analytics in January 2022.
region This field is blank as of January 2022 To align with rising data privacy protection measures and to protect the privacy of your subscribers, Litmus removed the geolocation data from Litmus Email Analytics in January 2022.
country This field is blank as of January 2022 To align with rising data privacy protection measures and to protect the privacy of your subscribers, Litmus removed the geolocation data from Litmus Email Analytics in January 2022.
long varchar (255) An obsolete data field for newer tracking campaigns. To support our commitment to PII compliance, Litmus no longer stores the longitude and latitude coordinates of where an open took place.
lat varchar (255) An obsolete data field for newer tracking campaigns. To support our commitment to PII compliance, Litmus no longer stores the longitude and latitude coordinates of where an open took place
referrer varchar (200) This applies only to opens that happened in a web-based email client, such as Outlook.com. We provide the full referrer header, which will list out the full web address for the email provider.
user_agent varchar (1000) This applies only to opens that happened in a desktop or mobile email client. We will list the full user agent of the email software.
campaign_guid varchar (50) The GUID is the unique identifier for your campaign's tracking code that Litmus uses internally. It's helpful if you wish to combine multiple CSV exports in a single spreadsheet.
custom_data varchar (100) An obsolete data field for newer tracking campaigns. This field exists to support older tracking codes’ data points that are now deprecated.
custom_id varchar (255) The custom_id field is populated when an ESP with a corresponding Unique User ID (UUID) merge tag is selected during the tracking code creation steps. The data shown is the ID reference the ESP generates for a specific contact record (also known as contact ID, record ID, recipient ID, subscriber key etc. depending on what terminology the ESP employs). This is the ID that you should use to link all the information in a given row back to a particular subscriber/recipient within your ESP.
reliability_category varchar (255) The reliability_category field is populated for each open to indicate whether Litmus deems the open to be from a reliable source. We refer to the email opens that exclude Apple Mail Privacy opens as reliable opens. We populate this field with Reliable to indicate the subscriber opened from an email client other than Apple Mail Privacy. The opens received from the Apple Mail Privacy feature are labeled AppleMailPrivacy.
Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Still need help? Contact Us Contact Us