How is the csv export named?
- message_[MessageId]_[Metric][export_timestamp]
What do the different columns and values in the CSV export Represent?
- 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
What do the different time stamps represent?
-
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.
What Columns does each CSV export have?
- Export From Delivered
-
- recipientId
- recipientName
- recipientEmailAddress
- recipientConstituentId
- recipientClassYear
- deliveredTimestamp
- dateAdded
- Export from Opens
- recipientId
- recipientName
- recipientEmailAddress
- recipientConstituentId
- recipientClassYear
- openedTimestamp
- hasClick
- hasConversion
- lastActionTime
- Export from Clicks
- linkId
- messageId
- externalLinkId
- linkName
- Url
- totalClicks
- uniqueClicks
- lastUpdated
- Export from Conversions
- recipientId
- recipientName
- recipientEmailAddress
- recipientConstituentId
- recipientClassYear
- conversionCount
- profileUpdateCount
- registrationCount
- donationCount
- membershipCount
- lastActionTime
- Export from Bounces
- bounceId
- recipientName
- recipientEmailAddress
- recipientConstituentId
- recipientClassYear
- bouncedTimestamp
- bounceType
- bounceReason
- dateAdded
- Export from Unopened
- recipientId
- recipientName
- recipientEmailAddress
- recipientConstituentId
- recipientClassYear
- Export from Spam Report
- spamReportId
- recipientName
- recipientEmailAddress
- recipientConstituentId
- recipientClassYear
- spamReportedTimestamp
- dateAdded