Email Reporting Exports FAQ

message_[MessageId]_[Metric][export_timestamp]

recipientId: a unique identifier for an email recipient in email reporting database recipient table. The id is helpful when you don't have a recipientConstiuentId populated.

linkId: a unique identifier for a hyperlink in the email reporting database

messageId: the unique identifier in the reporting database for the sent email marketing message (also present in filename)

externalLinkId: The link's unique identifier in the content management system

recipientConstituentId: Your database of record's primary key

Timestamp: the time when the tracked action occurred.

dateAdded: the timestamp for when the tracked action was written to the reporting database. If you pull a report multiple times, this date will help you identify the newest data.

lastActionTime: When an export includes information on multiple actions (opens export, conversions export), the csv includes the timestamp for the chronologically last action. If you pull a report multiple times, this date will help you know if a row has updated since your last export.

Export From Delivered

Export from Opens

Export from Clicks

Export from Conversions

Export from Bounces

Export from Unopened

Export from Spam Report