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 or mobile. |
| 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. |