Email Reporting Exports FAQ

Print Friendly and PDF Follow

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