In This Article:

    The "email" object

    In This Article:

      Salsa creates an email object for every message sent from an email blast.  The email contains the final status of each message sent by a blast.

      Layout

      Field Type Notes
      email_KEY int(16)  Primary key created by Salsa
      supporter_KEY int(16)  Required primary key for the supporter table
      organization_KEY int(16)  Required primary key for the organization table
      email_blast_KEY int(16)  Require primary key for the email_blast_table
      Last_Modified timestamp  YYYY:MM:DD HH:MM:SS (US Eastern time)
      Time_Requested timestamp  YYYY:MM:DD HH:MM:SS (US Eastern time)
      Time_Sent timestamp  YYYY:MM:DD HH:MM:SS (US Eastern time)
      Status text enum 'New'

      'Pending'
      'Send Failed'
      'Sent'
      'Bounced'
      'Opened'
      'Replied'
      'Delete Pending'
      'Testing'
      'Sent and Opened'
      'Sent and Clicked'
      'Bad Address'
      'Delayed'
      'SMSNew'
      'Sent and Converted'
      Status_Count int(4)  Usually one (1)
      thread_ID int(8)  Internal use only

       

      Was this article helpful?
      0 out of 0 found this helpful
      Have more questions? Submit a request

      Comments

      0 comments

      Please sign in to leave a comment.