Filename: [SENDER-ID]_newsletter_audit_specific_[newsletterID]_[full|incremental].csv (respectively with individual date suffix)

Example:

"newsletterId";"ts";"userId";"status";"sourceType";"sourceId";"remark"
"80347";"2011-01-26 00:10:04";"522503";"1";"1";"13011";""

• newsletterId [int]: ID of newsletter
• ts [datetime]: timestamp of addition/loss (YYYY-MM-DD HH:MM:SS)
• userId [int]: ID of user (promio internal, unique)
• status [int, -1|1]:
  1: addition
  -1: loss
• sourceType [int]: source of change:
  1: address generation
  3: manual addition (e.g. addition of a target group to the newsletter)
  4: promio.mail cronjob (automatic processes)
  5: promio.mail manual change (e.g. subscription / unsubscribe via newsletter manager)
  7: holiday block
  8: auto campaign
  9: hardbounce cleaner
  10: blacklist cleaner
  11: removal because of feedbackloop complaint
  13: SOAP
  15: quarantine cleaner
  17: list unsubscribe (unsubscribe via list unsubscribe link in email header)
• sourceID [int]: optional, corresponding to sourceType, e.g. ID of address generation if added by adress generation, ID of target group if added by target group, ID of email if unsubcribe by list unsubcribe link.
• remark [string]: optional, additional information